public bool UpdateBuilding(BuildingManager building) { SqlParameter[] sp = new SqlParameter[3]; sp[0] = new SqlParameter("@BuildingID", building.BuildingID); sp[1] = new SqlParameter("@BuildingName", building.BuildingName); sp[2] = new SqlParameter("@BuildingDesc", building.BuildingDesc); return datalayer.Execute_NonQuery("sp_UpdateBuilding", CommandType.StoredProcedure, sp); }
public bool AddNewBuilding(BuildingManager building) { SqlParameter[] sp = new SqlParameter[4]; sp[0] = new SqlParameter("@LocationID", building.LocationID); sp[1] = new SqlParameter("@BuildingName", building.BuildingName); sp[2] = new SqlParameter("@BuildingDesc", building.BuildingDesc); sp[3] = new SqlParameter("@CreatedDate", DateTime.Now); return datalayer.Execute_NonQuery("sp_AddNewBuilding", CommandType.StoredProcedure, sp); }
public void bindBuildingGrid() { BuildingManager b = new BuildingManager(); DataSet ds = b.listBuildingbyLocation(LocationID); if (ds.Tables[0].Rows.Count > 0) { BuildingGrid.AutoGenerateColumns = false; BuildingGrid.DataSource = null; //Set Columns Count BuildingGrid.ColumnCount = 3; //Add Columns BuildingGrid.Columns[0].Name = "BuildingID"; BuildingGrid.Columns[0].HeaderText = "BuildingID"; BuildingGrid.Columns[0].DataPropertyName = "BuildingID"; BuildingGrid.Columns[1].HeaderText = "Building Name"; BuildingGrid.Columns[1].Name = "BuildingName"; BuildingGrid.Columns[1].DataPropertyName = "BuildingName"; BuildingGrid.Columns[2].Name = "BuildingDescription"; BuildingGrid.Columns[2].HeaderText = "Building Description"; BuildingGrid.Columns[2].DataPropertyName = "BuildingDescription"; BuildingGrid.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"; BuildingGrid.Columns.Add(Editlink); DataGridViewLinkColumn Deletelink = new DataGridViewLinkColumn(); Deletelink.UseColumnTextForLinkValue = true; Deletelink.HeaderText = "delete"; Deletelink.DataPropertyName = "lnkForDeleteColumn"; Deletelink.LinkBehavior = LinkBehavior.SystemDefault; Deletelink.Text = "Delete"; BuildingGrid.Columns.Add(Deletelink); DataGridViewLinkColumn AddBuilding = new DataGridViewLinkColumn(); AddBuilding.UseColumnTextForLinkValue = true; AddBuilding.HeaderText = "Add Flats"; AddBuilding.DataPropertyName = "lnkForFlatsColumn"; AddBuilding.LinkBehavior = LinkBehavior.SystemDefault; AddBuilding.Text = "Add Flats"; BuildingGrid.Columns.Add(AddBuilding); } }
private void btnUpdateBuilding_Click(object sender, EventArgs e) { BuildingManager building = new BuildingManager(); building.BuildingID = Convert.ToInt32(lblBuildingID.Text); building.LocationID = LocationID; building.BuildingName = txtBuildingName.Text; building.BuildingDesc = txtBuildingDescription.Text; bool res = building.UpdateBuilding(building); if (res) { MessageBox.Show("Record Updated Successfully"); bindBuildingGrid(); switchpnl(false); } else { MessageBox.Show("Error"); } }