public void bindFlatGrid()
{
FlatManager f = new FlatManager();
DataSet ds = f.ListFlats(BuildingID);
if (ds.Tables[0].Rows.Count > 0)
{
FlatGrid.AutoGenerateColumns = false;
FlatGrid.DataSource = null;
//Set Columns Count
FlatGrid.ColumnCount = 3;
//Add Columns
FlatGrid.Columns[0].Name = "Id";
FlatGrid.Columns[0].HeaderText = "Id";
FlatGrid.Columns[0].DataPropertyName = "FlatID";
FlatGrid.Columns[1].HeaderText = "FlatNo";
FlatGrid.Columns[1].Name = "FlatNo";
FlatGrid.Columns[1].DataPropertyName = "FlatNo";
FlatGrid.Columns[2].Name = "Price";
FlatGrid.Columns[2].HeaderText = "Price";
FlatGrid.Columns[2].DataPropertyName = "Price";
FlatGrid.DataSource = ds.Tables[0];
//Buttons
DataGridViewLinkColumn Editlink = new DataGridViewLinkColumn();
Editlink.UseColumnTextForLinkValue = true;
Editlink.HeaderText = "Edit";
Editlink.DataPropertyName = "lnkForEditColumn";
Editlink.LinkBehavior = LinkBehavior.SystemDefault;
Editlink.Text = "Edit";
FlatGrid.Columns.Add(Editlink);
DataGridViewLinkColumn Deletelink = new DataGridViewLinkColumn();
Deletelink.UseColumnTextForLinkValue = true;
Deletelink.HeaderText = "delete";
Deletelink.DataPropertyName = "lnkForDeleteColumn";
Deletelink.LinkBehavior = LinkBehavior.SystemDefault;
Deletelink.Text = "Delete";
FlatGrid.Columns.Add(Deletelink);
DataGridViewLinkColumn AddBuilding = new DataGridViewLinkColumn();
AddBuilding.UseColumnTextForLinkValue = true;
AddBuilding.HeaderText = "Sell";
AddBuilding.DataPropertyName = "lnkForSellColumn";
AddBuilding.LinkBehavior = LinkBehavior.SystemDefault;
AddBuilding.Text = "Sell";
FlatGrid.Columns.Add(AddBuilding);
}
}
public bool AddFlat(FlatManager flat)
{
SqlParameter[] sp = new SqlParameter[6];
sp[0] = new SqlParameter("@BuildingID", flat.BuildingID);
sp[1] = new SqlParameter("@FlatNo", flat.FlatNo);
sp[2] = new SqlParameter("@Price", flat.Price);
sp[3] = new SqlParameter("@DownPayment", flat.DownPayment);
sp[4] = new SqlParameter("@AmountPayed", flat.AmountPayed);
sp[5] = new SqlParameter("@IsSelled", false);
return datalayer.Execute_NonQuery("sp_AddFlat", CommandType.StoredProcedure, sp);
}
private void btnAddFlat_Click(object sender, EventArgs e)
{
FlatManager f = new FlatManager();
f.BuildingID = BuildingID;
f.FlatNo = txtFlatNo.Text;
f.Price = Convert.ToInt64(txtPrice.Text);
f.DownPayment = 0;
f.AmountPayed = 0;
f.IsSelled = false;
bool res = f.AddFlat(f);
if (res)
{
MessageBox.Show("Record Inserted Successfully");
bindFlatGrid();
switchpnl(false);
}
else
{
MessageBox.Show("Error");
}
}
