private void Save()
{
if (!base.ValidateIfCommandAllowed(Request.Url.AbsoluteUri, ENums.PageCommand.Add))
{
return;
}
bool bActionCompleted = false;
FloorDTO oFloorData = new FloorDTO();
oFloorData.Floor = Convert.ToInt32(txtFloor.Text.Trim().ToString());
FloorMaster oFloorMaster = new FloorMaster();
bActionCompleted = oFloorMaster.Insert(oFloorData);
if (bActionCompleted == true)
{
base.DisplayAlert("The record has been inserted successfully.");
txtFloor.Text = "";
lblStatus.Text = "Saved";
}
else
{
lblStatus.Text = "Error Occured while insertion: Please refer to the error log.";
}
oFloorData = null;
oFloorMaster = null;
}
public bool Delete(FloorDTO oFloorData)
{
string sProcName;
DatabaseManager oDB;
try
{
oDB = new DatabaseManager();
sProcName = "up_Del_FloorMaster";
oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@iFloorId", DbType.Int32, oFloorData.FloorId);
oDB.ExecuteNonQuery(oDB.DbCmd);
}
catch (Exception exp)
{
oDB = null;
oFloorData = null;
GF.LogError("clsFloorMaster.Delete", exp.Message);
return(false);
}
finally
{
oDB = null;
oFloorData = null;
}
return(true);
}
private FloorDTO[] PopulateDataObject(string Query)
{
FloorDTO[] oFloorData;
DataSet ds;
oFloorData = null;
ds = GetDataFromDB(Query);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
oFloorData = new FloorDTO[ds.Tables[0].Rows.Count];
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
oFloorData[i] = new FloorDTO();
if (ds.Tables[0].Rows[i][0] != DBNull.Value)
{
oFloorData[i].FloorId = Convert.ToInt32(ds.Tables[0].Rows[i][0]);
}
if (ds.Tables[0].Rows[i][1] != DBNull.Value)
{
oFloorData[i].Floor = Convert.ToInt32(ds.Tables[0].Rows[i][1]);
}
}
}
return(oFloorData);
}
private void Delete()
{
if (!base.ValidateIfCommandAllowed(Request.Url.AbsoluteUri, ENums.PageCommand.Add))
{
return;
}
if (ValidateValues() == false)
{
return;
}
bool bActionCompleted = false;
int Id = 0;
int.TryParse(hfId.Value, out Id);
if (Id == 0)
{
lblStatus.Text = "Please click on edit button again.";
return;
}
FloorDTO oFloorData = new FloorDTO();
oFloorData.FloorId = Id;
FloorMaster oFloorMaster = new FloorMaster();
/*
* ADDED BY VIJAY
* CHECK IF THE FLOOR WHICH IS TO BE DELETED HAS ANY ASSOCIATED RECORDS...IF YES, MOVE OUT OF THE FUNCTION ELSE PROCEED
* IF THE OUTPUT OF sMessage IS "", THEN RECORD CAN BE DELETED, ELSE NOT
*
*/
string sMessage = "";
GF.HasRecords(Convert.ToString(Id), "floor", out sMessage);
if (sMessage != "")
{
base.DisplayAlert(sMessage);
btnDelete.Enabled = true;
}
else
{
bActionCompleted = oFloorMaster.Delete(oFloorData);
if (bActionCompleted == true)
{
base.DisplayAlert("The record has been deleted successfully");
txtFloor.Text = "";
//lblStatus.Text = "Deleted";
RefreshGrid();
}
else
{
base.DisplayAlert("Error Occured while deletion: Please refer to the error log.");
}
// lblStatus.Text = "Error Occured while updation: Please refer to the error log.";
}
oFloorData = null;
oFloorMaster = null;
}
public static Floor convertToFloor(FloorDTO f)
{
Floor floor = new Floor();
floor.FloorID = f.id;
floor.Descrizione = f.descrizione;
floor.Nome = f.nomeFloor;
floor.Building = BuildingConverter.convertToBuilding(f.building);
return(floor);
}
public static FloorDTO convertToDto(Floor f)
{
FloorDTO floor = new FloorDTO();
floor.id = f.FloorID;
floor.descrizione = f.Descrizione;
floor.nomeFloor = f.Nome;
floor.building = BuildingConverter.convertToDto(f.Building);
return(floor);
}
//A helper function to get a floor from its DTO version.
private Floor GetFloorFromDTO(FloorDTO floorDTO)
{
Floor floor = new Floor();
//We copy attributes that aren't Guid or Guid collections.
FloorDTO.GetAttributesFromDTO(floorDTO, floor);
//For each Guid in a collection we get the apropriate camera.
floor.Cameras = (ICollection <Camera>)floorDTO.Cameras.Select(cameraGuid => CameraService.GetCamera(cameraGuid));
return(floor);
}
private void Update()
{
if (!base.ValidateIfCommandAllowed(Request.Url.AbsoluteUri, ENums.PageCommand.Add))
{
return;
}
if (ValidateValues() == false)
{
return;
}
bool bActionCompleted = false;
int Id = 0;
int.TryParse(hfId.Value, out Id);
if (Id == 0)
{
lblStatus.Text = "Please click on edit button again.";
return;
}
FloorDTO oFloorData = new FloorDTO();
oFloorData.FloorId = Id;
oFloorData.Floor = Convert.ToInt32(txtFloor.Text.Trim().ToString());
FloorMaster oFloorMaster = new FloorMaster();
bActionCompleted = oFloorMaster.Update(oFloorData);
if (bActionCompleted == true)
{
base.DisplayAlert("The record has been updated successfully.");
txtFloor.Text = "";
lblStatus.Text = "Updated";
}
else
{
lblStatus.Text = "Error Occured while updation: Please refer to the error log.";
}
oFloorData = null;
oFloorMaster = null;
}
// PUT: api/Floors
public void Put([FromBody] FloorDTO floorDTO)
{
Floor floor = GetFloorFromDTO(floorDTO);
Service.Update(floor);
}
// POST: api/Floors
public void Post([FromBody] FloorDTO floorDTO)
{
Floor floor = GetFloorFromDTO(floorDTO);
Service.Add(floor);
}
