public static int AddBuilding(mBuilding pBuilding)
{
int isSucess = 0;
using (SqlConnection con = new SqlConnection(Global.connString))
{
con.Open();
using (SqlCommand command = new SqlCommand("INSERT INTO tblBuildings (BuildingType, LandLordID, BuildingName, BuildingCity, BuildingAddress , TotalUnits, Contractor, CompletionDate, BuildingImage, Parking, Security, KidFriendly, IsActive) " +
" VALUES ( @BuildingType, @LandLordID, @BuildingName, @BuildingCity, @BuildingAddress, @TotalUnits, @Contractor, @CompletionDate, @BuildingImage , @Parking, @Security, @KidFriendly, @IsActive) ", con))
{
command.Parameters.AddWithValue("@BuildingType", pBuilding.BuildingType);
command.Parameters.AddWithValue("@LandLordID", pBuilding.LandLordID);
command.Parameters.AddWithValue("@BuildingName", pBuilding.BuildingName);
command.Parameters.AddWithValue("@BuildingCity", pBuilding.BuildingCity);
command.Parameters.AddWithValue("@BuildingAddress", pBuilding.BuildingAddress);
command.Parameters.AddWithValue("@TotalUnits", pBuilding.TotalUnits);
command.Parameters.AddWithValue("@Contractor", pBuilding.Contractor);
command.Parameters.AddWithValue("@CompletionDate", pBuilding.CompletionDate);
command.Parameters.AddWithValue("@BuildingImage", pBuilding.BuildingImage);
command.Parameters.AddWithValue("@Parking", pBuilding.Parking);
command.Parameters.AddWithValue("@Security", pBuilding.Security);
command.Parameters.AddWithValue("@Kidfriendly", pBuilding.KidFriendly);
command.Parameters.AddWithValue("@IsActive", pBuilding.IsActive);
isSucess = command.ExecuteNonQuery();
}
}
return(isSucess);
}
public static int UpdateBuildig(mBuilding pBuilding)
{
int isSucess = 0;
using (SqlConnection con = new SqlConnection(Global.connString))
{
con.Open();
using (SqlCommand command = new SqlCommand("UPDATE tblBuildings SET [BuildingType] = @BuildingType, [LandLordID] = @LandLordID, [BuildingName] = @BuildingName, [BuildingCity] = @BuildingCity, " +
" [BuildingAddress] = @BuildingAddress, [TotalUnits] = @TotalUnits, [Contractor] = @Contractor, [CompletionDate] = @CompletionDate," +
" [BuildingImage] = @BuildingImage,[Parking] = @Parking,[Security] = @Security,[KidFriendly] = @KidFriendly, " +
" [IsActive] = @IsActive WHERE BuildingID = @BuildingID ", con))
{
command.Parameters.AddWithValue("@BuildingID", pBuilding.BuildingID);
command.Parameters.AddWithValue("@BuildingType", pBuilding.BuildingType);
command.Parameters.AddWithValue("@LandLordID", pBuilding.LandLordID);
command.Parameters.AddWithValue("@BuildingName", pBuilding.BuildingName);
command.Parameters.AddWithValue("@BuildingCity", pBuilding.BuildingCity);
command.Parameters.AddWithValue("@BuildingAddress", pBuilding.BuildingAddress);
command.Parameters.AddWithValue("@TotalUnits", pBuilding.TotalUnits);
command.Parameters.AddWithValue("@Contractor", pBuilding.Contractor);
command.Parameters.AddWithValue("@CompletionDate", pBuilding.CompletionDate);
command.Parameters.AddWithValue("@BuildingImage", pBuilding.BuildingImage);
command.Parameters.AddWithValue("@Parking", pBuilding.Parking);
command.Parameters.AddWithValue("@Security", pBuilding.Security);
command.Parameters.AddWithValue("@KidFriendly", pBuilding.KidFriendly);
command.Parameters.AddWithValue("@IsActive", pBuilding.IsActive);
isSucess = command.ExecuteNonQuery();
}
}
return(isSucess);
}
