using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.OleDb;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Configuration;

namespace SaleLog
{
	/// <summary>
	/// Summary description for frmsale.
	/// </summary>
	public class frmsale : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.DataGrid dgclient;
		protected System.Web.UI.WebControls.Button cmdclear;
		protected System.Web.UI.WebControls.Button cmdgo;
		protected System.Web.UI.WebControls.Label lblfilterunit;
		protected System.Web.UI.WebControls.TextBox txtfilterclient;
		protected System.Web.UI.WebControls.Label lblfilterclient;
		protected System.Web.UI.WebControls.Label lblfilterbuilding;
		protected System.Web.UI.WebControls.Button cmdbuyers;
		protected System.Web.UI.WebControls.Button cmdunits;
		protected System.Web.UI.WebControls.DropDownList cbobuilding;
		protected System.Web.UI.WebControls.DataGrid dgbuyers;
		protected System.Web.UI.WebControls.TextBox Textbox1;
		protected System.Web.UI.WebControls.TextBox txtfilterunit;
		protected System.Web.UI.WebControls.CheckBox chkavailable;
		protected System.Web.UI.WebControls.CheckBox chkactive;
		protected System.Web.UI.WebControls.CheckBox chkclosed;
		protected System.Web.UI.WebControls.CheckBox chkreserved;
		protected System.Web.UI.WebControls.DropDownList cboproject;
		protected System.Web.UI.WebControls.Label Label3;
		protected System.Web.UI.WebControls.Label Label2;
		protected System.Web.UI.WebControls.Label Label1;
		protected System.Web.UI.WebControls.Panel pnlclient;
		protected System.Web.UI.WebControls.Label Label4;
		protected System.Web.UI.WebControls.Label Label5;
		protected System.Web.UI.WebControls.Label Label6;
		protected System.Web.UI.WebControls.Panel pnlstatus;
		protected System.Web.UI.WebControls.Label Label21;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// Put user code to initialize the page here
			
			
			if(dgbuyers.Visible == false)
			{
				populateSales();
			}
			if(!IsPostBack)
			{
				populateSales();
				BindProjectCombo();
				populateBuilding();
				dgbuyers.Visible=false;
				pnlclient.Visible=false;
			}
		}
		public void populateSales()
		{
			string strClosed = "";
			string strAvailable = "";
			string strActive = "";
			string strReserved = "";

			if(this.chkclosed.Checked)
			{
				strClosed = "Closed";
			}
			if(this.chkavailable.Checked)
			{
				strAvailable = "Available";
			}
			if(this.chkactive.Checked)
			{
				strActive = "Active";
			}
			if(this.chkreserved.Checked)
			{
				strReserved = "Reserved";
			}



			string strQry =string.Empty;

			if(strActive != "" || strAvailable != "" || strClosed != "" || strReserved != "")
			{
				strQry = " SELECT Building.BuildingName AS Bldg, Inventory.UnitNo, Inventory.InventoryID AS InventoryId, (IIf(Not IsNull([ReservClientID]),'Reserved',IIf(IsNull([ContractID]),'Available',[ContractStatusVal]))) AS [Contract Status], Inventory.BuildingID, [BuildingName] & '-' & [UnitNo] AS BuildingUnit, Inventory.ReservClientID";
				strQry = strQry + " FROM ActiveContractsList RIGHT JOIN (Inventory INNER JOIN Building ON Inventory.BuildingID = Building.BuildingID) ON ActiveContractsList.InventoryID = Inventory.InventoryID";
				strQry = strQry + " WHERE Inventory.UnitNo Is Not Null AND (((IIf(Not IsNull([ReservClientID]),'Reserved',IIf(IsNull([ContractID]),'Available',[ContractStatusVal]))))= " + "'" + strClosed + "'" + " Or ((IIf(Not IsNull([ReservClientID]),'Reserved',IIf(IsNull([ContractID]),'Available',[ContractStatusVal]))))= " + "'" + strAvailable +"'" + " Or ((IIf(Not IsNull([ReservClientID]),'Reserved',IIf(IsNull([ContractID]),'Available',[ContractStatusVal]))))= " + "'" + strActive + "'" + " Or ((IIf(Not IsNull([ReservClientID]),'Reserved',IIf(IsNull([ContractID]),'Available',[ContractStatusVal]))))= " + "'" + strReserved + "'" +") AND Inventory.BuildingID Is Not Null AND Inventory.ProjectID= " + Convert.ToInt32(Session["ProjId"]);
				strQry = strQry + " ORDER BY Building.BuildingName, Inventory.UnitNo";
				//Response.Write(strQry);
				//Response.End();
			}
			else
			{
				strQry = "SELECT Building.BuildingName AS Bldg, Inventory.UnitNo, Inventory.InventoryID AS InventoryId, (IIf(Not IsNull([ReservClientID]),'Reserved',IIf(IsNull([ContractID]),'Available',[ContractStatusVal]))) AS [Contract Status], Inventory.BuildingID, [BuildingName]  & '-' &[UnitNo] AS BuildingUnit, Inventory.ReservClientID,ActiveContractsList.ContractID ";
				strQry = strQry +  " FROM ActiveContractsList RIGHT JOIN (Inventory INNER JOIN Building ON Inventory.BuildingID = Building.BuildingID) ON ActiveContractsList.InventoryID = Inventory.InventoryID";
				strQry = strQry + " WHERE Inventory.UnitNo Is Not Null AND Inventory.BuildingID Is Not Null AND Inventory.ProjectID=" + Convert.ToInt32(Session["ProjId"]);
				strQry = strQry + " ORDER BY Building.BuildingName, Inventory.UnitNo";

			}

			
			OleDbConnection cn=new OleDbConnection(ConfigurationSettings.AppSettings["ConnectionString"].ToString());
			cn.Open();
			OleDbDataAdapter DaCmtLog=new OleDbDataAdapter(strQry,cn);
			DataSet ds=new DataSet();
			DaCmtLog.Fill(ds);
			dgclient.DataSource=ds;
			dgclient.DataKeyField=ds.Tables[0].Columns["InventoryID"].ColumnName;
			dgclient.DataBind();
			DaCmtLog.Dispose();
			cn.Close();

		}

		#region Web Form Designer generated code
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: This call is required by the ASP.NET Web Form Designer.
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// Required method for Designer support - do not modify
		/// the contents of this method with the code editor.
		/// </summary>
		private void InitializeComponent()
		{    
			this.dgclient.ItemCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.dgclient_ItemCommand);
			this.dgclient.ItemDataBound += new System.Web.UI.WebControls.DataGridItemEventHandler(this.dgclient_ItemDataBound);
			this.dgclient.SelectedIndexChanged += new System.EventHandler(this.dgclient_SelectedIndexChanged);
			this.cboproject.SelectedIndexChanged += new System.EventHandler(this.cboproject_SelectedIndexChanged);
			this.dgbuyers.ItemCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.dgbuyers_ItemCommand);
			this.cmdunits.Click += new System.EventHandler(this.cmdunits_Click);
			this.cmdbuyers.Click += new System.EventHandler(this.cmdbuyers_Click);
			this.cmdgo.Click += new System.EventHandler(this.cmdgo_Click);
			this.cmdclear.Click += new System.EventHandler(this.cmdclear_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void dgclient_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
		{
			string HasApp = string.Empty;
			if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
			{
				
				HasApp = Convert.ToString(DataBinder.Eval(e.Item.DataItem,"Contract Status"));
				if(HasApp == "Closed")
				{
					e.Item.ForeColor = System.Drawing.Color.Red;
				}
				if(HasApp == "Active")
				{
					e.Item.ForeColor = System.Drawing.Color.Goldenrod;
				}
				if(HasApp == "Available")
				{
					e.Item.ForeColor = System.Drawing.Color.Green;
				}
			}
		}

		private void cmdclear_Click(object sender, System.EventArgs e)
		{
			if(txtfilterunit.Text != "")
			{
				txtfilterunit.Text="";
				Session["FilterUnit"]=null;
				Session["FilterInventoryID"]=null;
				Session["FilterCount"]=null;
				populateBuilding();
			}
			if(txtfilterclient.Text != "")
			{
				txtfilterclient.Text = "";
				Session["FilterClient"] = null;
				BindBuyerGrid();
			}
			//Response.Redirect("frmcontract.aspx");
		}

		private void cmdgo_Click(object sender, System.EventArgs e)
		{
			if(txtfilterunit.Visible==true)
			{
				if(txtfilterunit.Text != "")
				{
					Session["FilterUnit"]=txtfilterunit.Text;
					filterunit();
				}
			}
			if(txtfilterclient.Visible==true)
			{
				if(txtfilterclient.Text != "")
				{
					Session["FilterClient"]=txtfilterclient.Text;
					BindBuyerGrid();
					//filterclient();
				}
			}
		}
		public void filterunit()
		{
			string strQry=string.Empty;
			int ProjectID=Convert.ToInt32(Session["ProjId"].ToString());
			int brokerid=Convert.ToInt32(Session["brokerid"].ToString());
			string UnitNo = this.txtfilterunit.Text.Trim();
			string recount = string.Empty;
			int buildingid = 0;
			if(cbobuilding.SelectedItem.Text != "-- Select --")
			{
				buildingid = Convert.ToInt32(cbobuilding.SelectedValue);
			}

			if(buildingid == 0)
			{
				strQry = "SELECT Building.BuildingName AS Bldg, Inventory.UnitNo, Inventory.InventoryID AS InventoryId, (IIf(Not IsNull([ReservClientID]),'Reserved',IIf(IsNull([ContractID]),'Available',[ContractStatusVal]))) AS [Contract Status], Inventory.BuildingID, [BuildingName]  & '-' &[UnitNo] AS BuildingUnit, Inventory.ReservClientID,ActiveContractsList.ContractID ";
				strQry = strQry +  " FROM ActiveContractsList RIGHT JOIN (Inventory INNER JOIN Building ON Inventory.BuildingID = Building.BuildingID) ON ActiveContractsList.InventoryID = Inventory.InventoryID";
				strQry = strQry + " WHERE Inventory.UnitNo Is Not Null AND Inventory.UnitNo LIKE " + UnitNo + " AND Inventory.BuildingID Is Not Null AND Inventory.ProjectID=" + Convert.ToInt32(Session["ProjId"]);
				strQry = strQry + " ORDER BY Building.BuildingName, Inventory.UnitNo";
			}
			else
			{
				strQry = "SELECT Building.BuildingName AS Bldg, Inventory.UnitNo, Inventory.InventoryID AS InventoryId, (IIf(Not IsNull([ReservClientID]),'Reserved',IIf(IsNull([ContractID]),'Available',[ContractStatusVal]))) AS [Contract Status], Inventory.BuildingID, [BuildingName]  & '-' &[UnitNo] AS BuildingUnit, Inventory.ReservClientID,ActiveContractsList.ContractID ";
				strQry = strQry +  " FROM ActiveContractsList RIGHT JOIN (Inventory INNER JOIN Building ON Inventory.BuildingID = Building.BuildingID) ON ActiveContractsList.InventoryID = Inventory.InventoryID";
				strQry = strQry + " WHERE Inventory.UnitNo Is Not Null AND Inventory.UnitNo LIKE " + UnitNo + " AND Inventory.BuildingID Is Not Null AND Inventory.BuildingID = " + buildingid + " AND Inventory.ProjectID=" + Convert.ToInt32(Session["ProjId"]);
				strQry = strQry + " ORDER BY Building.BuildingName, Inventory.UnitNo";

			}

					
			OleDbConnection cn=new OleDbConnection(ConfigurationSettings.AppSettings["ConnectionString"].ToString());
			cn.Open();
			OleDbCommand cmdTasks=new OleDbCommand(strQry,cn);
			cmdTasks.ExecuteNonQuery();
			
			OleDbDataAdapter daTasks=new OleDbDataAdapter();
			daTasks.SelectCommand=cmdTasks;
			DataSet dsTasks=new DataSet();
			daTasks.Fill(dsTasks);
			dgclient.DataSource=dsTasks;
			dgclient.DataBind();

			recount = dsTasks.Tables[0].Rows.Count.ToString();

			cn.Close();


			if(Session["FilterInventoryID"]== null)
			{
				int InventoryID = Convert.ToInt32(dsTasks.Tables[0].Rows[0]["InventoryID"].ToString());
				Session["FilterInventoryID"]=InventoryID;
				Session["FilterCount"]=Convert.ToInt32(recount)-1;
				Response.Write("<script language='javascript'>parent.frames['main'].location='frmcontract.aspx?InventoryID=" + InventoryID +"';</script>");
				//Response.Redirect("frmcontract.aspx?InventoryID=" + InventoryID);
			}
			
		}
		public void filterclient()
		{
//			string strQry=string.Empty;
//			int ProjectID=Convert.ToInt32(Session["ProjId"].ToString());
//			int brokerid=Convert.ToInt32(Session["brokerid"].ToString());
//			string ClientName = this.txtfilterclient.Text.Trim();
//			string recount = string.Empty;
//			
//			strQry = "SELECT Building.BuildingName AS Bldg, Inventory.UnitNo, Inventory.InventoryID AS InventoryId, (IIf(Not IsNull([ReservClientID]),'Reserved',IIf(IsNull([ContractID]),'Available',[ContractStatusVal]))) AS [Contract Status], Inventory.BuildingID, [BuildingName]  & '-' &[UnitNo] AS BuildingUnit, Inventory.ReservClientID,ActiveContractsList.ContractID ";
//			strQry = strQry +  " FROM ActiveContractsList RIGHT JOIN (Inventory INNER JOIN Building ON Inventory.BuildingID = Building.BuildingID) ON ActiveContractsList.InventoryID = Inventory.InventoryID";
//			strQry = strQry + " WHERE Inventory.UnitNo Is Not Null AND Inventory.UnitNo LIKE " + UnitNo + " AND Inventory.BuildingID Is Not Null AND Inventory.ProjectID=" + Convert.ToInt32(Session["ProjId"]);
//			strQry = strQry + " ORDER BY Building.BuildingName, Inventory.UnitNo";
//			
//			
//				
//			OleDbConnection cn=new OleDbConnection(ConfigurationSettings.AppSettings["ConnectionString"].ToString());
//			cn.Open();
//			OleDbCommand cmdTasks=new OleDbCommand(strQry,cn);
//			cmdTasks.ExecuteNonQuery();
//			
//			OleDbDataAdapter daTasks=new OleDbDataAdapter();
//			daTasks.SelectCommand=cmdTasks;
//			DataSet dsTasks=new DataSet();
//			daTasks.Fill(dsTasks);
//			dgclient.DataSource=dsTasks;
//			dgclient.DataBind();
//
//			recount = dsTasks.Tables[0].Rows.Count.ToString();
//
//			cn.Close();
//
//
//			if(Session["FilterInventoryID"]== null)
//			{
//				int InventoryID = Convert.ToInt32(dsTasks.Tables[0].Rows[0]["InventoryID"].ToString());
//				Session["FilterInventoryID"]=InventoryID;
//				Session["FilterCount"]=Convert.ToInt32(recount)-1;
//				Response.Write("<script language='javascript'>parent.frames['main'].location='frmcontract.aspx?InventoryID=" + InventoryID +"';</script>");
//				//Response.Redirect("frmcontract.aspx?InventoryID=" + InventoryID);
//			}
			
		}

		private void cmdunits_Click(object sender, System.EventArgs e)
		{
			cmdunits.BorderColor=Color.Yellow;
			cmdbuyers.BorderColor=Color.Firebrick;
			dgbuyers.Visible=false;
			pnlclient.Visible=false;
			pnlstatus.Visible=true;
			dgclient.Visible=true;
			lblfilterclient.Visible=false;
			txtfilterclient.Visible=false;
			chkactive.Visible=true;
			chkavailable.Visible=true;
			chkclosed.Visible=true;
			chkreserved.Visible=true;
			lblfilterbuilding.Visible=true;
			lblfilterunit.Visible=true;
			cbobuilding.Visible=true;
			txtfilterunit.Visible=true;
			populateSales();		
		}

		private void cmdbuyers_Click(object sender, System.EventArgs e)
		{
			cmdunits.BorderColor=Color.Firebrick;
			cmdbuyers.BorderColor=Color.Yellow;
			dgbuyers.Visible=true;
			pnlclient.Visible=true;
			pnlstatus.Visible=false;
			dgclient.Visible=false;
			chkactive.Visible=false;
			chkavailable.Visible=false;
			chkclosed.Visible=false;
			chkreserved.Visible=false;
			lblfilterclient.Visible=true;
			txtfilterclient.Visible=true;
			lblfilterbuilding.Visible=false;
			lblfilterunit.Visible=false;
			cbobuilding.Visible=false;
			txtfilterunit.Visible=false;
			BindBuyerGrid();
		}
		public void BindBuyerGrid()

		{
			
			string qry1=string.Empty;
			int pid=Convert.ToInt32(Session["ProjId"].ToString());
			int brokerid=Convert.ToInt32(Session["brokerid"].ToString());
			string clientname = txtfilterclient.Text.Trim();

			if (brokerid>0)
			{
				if(clientname != "")
				{
					qry1= " SELECT DISTINCT (Building.BuildingName) AS Building, Inventory.UnitNo AS Unit, [LastName] & ',' & [FirstName] AS Client, Client.ClientID, ActiveContractsList.InventoryID, ContractBuyer.ContractID AS ContractID, Appraisal.TitleOrddt";
					qry1=qry1+ " FROM ((ContractBuyer INNER JOIN Client ON ContractBuyer.ContractBuyer = Client.ClientID) INNER JOIN ((Inventory INNER JOIN Building ON Inventory.BuildingID = Building.BuildingID) INNER JOIN ActiveContractsList ON Inventory.InventoryID = ActiveContractsList.InventoryID) ON ContractBuyer.ContractID = ActiveContractsList.ContractID) LEFT JOIN Appraisal ON ContractBuyer.ContractID = Appraisal.ContractID";
					qry1=qry1+" WHERE (Inventory.ProjectID)=" + pid + " And Contract.BrokerID=" + brokerid ;
				}
				else
				{
					qry1= " SELECT DISTINCT (Building.BuildingName) AS Building, Inventory.UnitNo AS Unit, [LastName] & ',' & [FirstName] AS Client, Client.ClientID, ActiveContractsList.InventoryID, ContractBuyer.ContractID AS ContractID, Appraisal.TitleOrddt";
					qry1=qry1+ " FROM ((ContractBuyer INNER JOIN Client ON ContractBuyer.ContractBuyer = Client.ClientID) INNER JOIN ((Inventory INNER JOIN Building ON Inventory.BuildingID = Building.BuildingID) INNER JOIN ActiveContractsList ON Inventory.InventoryID = ActiveContractsList.InventoryID) ON ContractBuyer.ContractID = ActiveContractsList.ContractID) LEFT JOIN Appraisal ON ContractBuyer.ContractID = Appraisal.ContractID";
					qry1=qry1+" WHERE (Inventory.ProjectID)=" + pid + " And Contract.BrokerID=" + brokerid + " AND [LastName] like " + clientname + " or [FirstName] like " + clientname;
				}
			}
			else if(brokerid==0)
			{
				if(clientname != "")
				{				
					qry1= " SELECT DISTINCT (Building.BuildingName) AS Building, Inventory.UnitNo AS Unit, [LastName] & ',' & [FirstName] AS Client, Client.ClientID, ActiveContractsList.InventoryID, ContractBuyer.ContractID AS ContractID, Appraisal.TitleOrddt";
					qry1=qry1+ " FROM ((ContractBuyer INNER JOIN Client ON ContractBuyer.ContractBuyer = Client.ClientID) INNER JOIN ((Inventory INNER JOIN Building ON Inventory.BuildingID = Building.BuildingID) INNER JOIN ActiveContractsList ON Inventory.InventoryID = ActiveContractsList.InventoryID) ON ContractBuyer.ContractID = ActiveContractsList.ContractID) LEFT JOIN Appraisal ON ContractBuyer.ContractID = Appraisal.ContractID";
					qry1=qry1+" WHERE (Inventory.ProjectID)=" + pid + " AND [FirstName] like " + "'" + clientname + "'" + " or [LastName] like " + "'" + clientname + "'";

					//Response.Write(qry1);
					//Response.End();
				}
				else
				{
					qry1= " SELECT DISTINCT (Building.BuildingName) AS Building, Inventory.UnitNo AS Unit, [LastName] & ',' & [FirstName] AS Client, Client.ClientID, ActiveContractsList.InventoryID, ContractBuyer.ContractID AS ContractID, Appraisal.TitleOrddt";
					qry1=qry1+ " FROM ((ContractBuyer INNER JOIN Client ON ContractBuyer.ContractBuyer = Client.ClientID) INNER JOIN ((Inventory INNER JOIN Building ON Inventory.BuildingID = Building.BuildingID) INNER JOIN ActiveContractsList ON Inventory.InventoryID = ActiveContractsList.InventoryID) ON ContractBuyer.ContractID = ActiveContractsList.ContractID) LEFT JOIN Appraisal ON ContractBuyer.ContractID = Appraisal.ContractID";
					qry1=qry1+" WHERE (Inventory.ProjectID)=" + pid;
				}
			}

			
					
					
			OleDbConnection cn=new OleDbConnection(ConfigurationSettings.AppSettings["ConnectionString"].ToString());
			cn.Open();
			OleDbCommand cmdTasks=new OleDbCommand(qry1,cn);
			cmdTasks.ExecuteNonQuery();
			OleDbDataAdapter daTasks=new OleDbDataAdapter();
			daTasks.SelectCommand=cmdTasks;
			DataSet dsTasks=new DataSet();
			daTasks.Fill(dsTasks);
			dgbuyers.DataSource=dsTasks;
			dgbuyers.DataKeyField=dsTasks.Tables[0].Columns["InventoryID"].ColumnName;
			dgbuyers.DataBind();
			cn.Close();
		
		}

		private void dgclient_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			if(e.CommandName=="Select")
			{
				if(e.Item.ItemIndex >= 0)
				{
					string InventoryID = dgclient.DataKeys[e.Item.ItemIndex].ToString();
					Response.Write("<script language='javascript'>parent.frames['main'].location='frmcontract.aspx?InventoryID=" + InventoryID + "';</script>");
				}
			}
			dgclient.SelectedIndex=e.Item.ItemIndex;
			populateSales();
		}

		private void dgclient_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			
		}
		public void BindProjectCombo()
		{
			OleDbConnection cn=new OleDbConnection(ConfigurationSettings.AppSettings["ConnectionString"].ToString());
			cn.Open();
			OleDbCommand cmdTasks=new OleDbCommand("Select * from Project",cn);
			cmdTasks.ExecuteNonQuery();
			OleDbDataAdapter daTasks=new OleDbDataAdapter();
			daTasks.SelectCommand=cmdTasks;
			DataSet dsTasks=new DataSet();
			daTasks.Fill(dsTasks);
			cboproject.DataSource=dsTasks;
			cboproject.DataTextField=dsTasks.Tables[0].Columns["ProjectName"].ColumnName.ToString();
			cboproject.DataValueField=dsTasks.Tables[0].Columns["ProjectID"].ColumnName.ToString();
			cboproject.DataBind();
			cboproject.SelectedValue = Session["ProjId"].ToString();
			cn.Close();
		}

		private void cboproject_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			Session["ProjId"]=cboproject.SelectedValue;
			Session["ProjectName"]=cboproject.SelectedItem.Text;
			Response.Write("<script language='javascript'>window.parent.parent.frames['header'].location=window.parent.parent.frames['header'].location;</script>");
			populateSales();
		}
		public void populateBuilding()
		{
			
			string strBQuery;

			OleDbConnection cn=new OleDbConnection(ConfigurationSettings.AppSettings["ConnectionString"].ToString());
			cn.Open();

			strBQuery="select * from Building where ProjectID = " + Convert.ToInt32(Session["ProjID"])+" order by BuildingName";
			OleDbCommand cmdClientStatus=new OleDbCommand(strBQuery,cn);
			cmdClientStatus.ExecuteNonQuery();

			OleDbDataAdapter DAStatus = new OleDbDataAdapter();
			DAStatus.SelectCommand=cmdClientStatus;
			DataSet dsStatus=new DataSet();
			DAStatus.Fill(dsStatus);

			//DataRow row = dsStatus.Tables[0].NewRow();
			//row[0] = -1;
			//row[1] = "-- Select --";
			//dsStatus.Tables[0].Rows.Add(row);

			cbobuilding.DataSource=dsStatus;
			cbobuilding.DataTextField="BuildingName";
			cbobuilding.DataValueField="BuildingID";
			cbobuilding.DataBind();

			cn.Close();

		}

		private void dgbuyers_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			if(e.CommandName=="Select")
			{
				if(e.Item.ItemIndex >= 0)
				{
					string InventoryID = dgbuyers.DataKeys[e.Item.ItemIndex].ToString();
					Response.Write("<script language='javascript'>parent.frames['main'].location='frmcontract.aspx?InventoryID=" + InventoryID + "';</script>");
				}
			}
			dgbuyers.SelectedIndex=e.Item.ItemIndex;
			BindBuyerGrid();
		}


	}
}