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