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"); } }