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