public bool Delete(RoomCategoryDTO oRoomCategoryData) { string sProcName; DatabaseManager oDB; try { oDB = new DatabaseManager(); sProcName = "up_Del_RoomCategoryMaster"; oDB.DbCmd = oDB.GetStoredProcCommand(sProcName); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@iRoomCategoryId", DbType.Int32, oRoomCategoryData.RoomCategoryId); oDB.ExecuteNonQuery(oDB.DbCmd); } catch (Exception exp) { oDB = null; oRoomCategoryData = null; GF.LogError("clsRoomCategoryMaster.Delete", exp.Message); return(false); } finally { oDB = null; oRoomCategoryData = null; } return(true); }
public bool Insert(RoomCategoryDTO oRoomCategoryData) { string sProcName; DatabaseManager oDB; try { oDB = new DatabaseManager(); sProcName = "up_Ins_RoomCategoryMaster"; oDB.DbCmd = oDB.GetStoredProcCommand(sProcName); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@sRoomCategory", DbType.String, oRoomCategoryData.RoomCategory.Trim()); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@categoryAlias", DbType.String, oRoomCategoryData.CategoryAlias.Trim()); oDB.ExecuteNonQuery(oDB.DbCmd); } catch (Exception exp) { oDB = null; oRoomCategoryData = null; GF.LogError("clsRoomCategoryMaster.Insert", exp.Message); return(false); } finally { oDB = null; } return(true); }
private void Save() { if (!base.ValidateIfCommandAllowed(Request.Url.AbsoluteUri, ENums.PageCommand.Add)) { return; } bool bActionCompleted = false; RoomCategoryDTO oNationalityData = new RoomCategoryDTO(); oNationalityData.RoomCategory = txtRoomcategory.Text.ToString(); oNationalityData.CategoryAlias = txtCategoryAlias.Text; RoomCategoryMaster oNationalityMaster = new RoomCategoryMaster(); bActionCompleted = oNationalityMaster.Insert(oNationalityData); if (bActionCompleted == true) { base.DisplayAlert("The record has been inserted successfully"); txtRoomcategory.Text = ""; lblStatus.Text = "Data Saved Successfully"; lblStatus.ForeColor = System.Drawing.Color.Green; } else { lblStatus.Text = "Error Occured while insertion: Please refer to the error log."; } lblStatus.ForeColor = System.Drawing.Color.Red; oNationalityData = null; oNationalityMaster = null; }
private void Delete() { if (!base.ValidateIfCommandAllowed(Request.Url.AbsoluteUri, ENums.PageCommand.Delete)) { 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; } RoomCategoryDTO oNationalityData = new RoomCategoryDTO(); oNationalityData.RoomCategoryId = Id; RoomCategoryMaster oNationalityMaster = new RoomCategoryMaster(); /* * ADDED BY VIJAY * CHECK IF THE NATIONALITY 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), "nationality", out sMessage); if (sMessage != "") { base.DisplayAlert(sMessage); btnDelete.Enabled = true; } else { bActionCompleted = oNationalityMaster.Delete(oNationalityData); if (bActionCompleted == true) { base.DisplayAlert("The record has been deleted successfully"); txtRoomcategory.Text = ""; //lblStatus.Text = "Deleted"; RefreshGrid(); } else { base.DisplayAlert("Error Occured while deletion: Please refer to the error log."); } } oNationalityData = null; oNationalityMaster = null; }
private void Update() { if (!base.ValidateIfCommandAllowed(Request.Url.AbsoluteUri, ENums.PageCommand.Update)) { 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; } RoomCategoryDTO oNationalityData = new RoomCategoryDTO(); oNationalityData.RoomCategoryId = Id; oNationalityData.RoomCategory = txtRoomcategory.Text.ToString(); oNationalityData.CategoryAlias = txtCategoryAlias.Text; RoomCategoryMaster oNationalityMaster = new RoomCategoryMaster(); bActionCompleted = oNationalityMaster.Update(oNationalityData); if (bActionCompleted == true) { base.DisplayAlert("The record has been updated successfully"); txtRoomcategory.Text = ""; txtCategoryAlias.ReadOnly = false; lblStatus.Text = "Updated"; } else { lblStatus.Text = "Error Occured while updation: Please refer to the error log."; } oNationalityData = null; oNationalityMaster = null; }
private RoomCategoryDTO[] PopulateDataObject(string Query) { RoomCategoryDTO[] oRoomCategoryData; DataSet ds; oRoomCategoryData = null; ds = GetDataFromDB(Query); if (ds != null && ds.Tables[0].Rows.Count > 0) { oRoomCategoryData = new RoomCategoryDTO[ds.Tables[0].Rows.Count]; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { oRoomCategoryData[i] = new RoomCategoryDTO(); oRoomCategoryData[i].RoomCategoryId = Convert.ToInt32(ds.Tables[0].Rows[i][0]); oRoomCategoryData[i].RoomCategory = Convert.ToString(ds.Tables[0].Rows[i][1]).Trim(); oRoomCategoryData[i].CategoryAlias = Convert.ToString(ds.Tables[0].Rows[i][2]).Trim(); } } return(oRoomCategoryData); }
public Accomodation GetReleasedRooms(int BookingId) { Accomodation accomodation; DataSet dsAccomodationData; DataRow dr; string sProcName; DatabaseManager oDB; dsAccomodationData = null; accomodation = null; try { oDB = new DatabaseManager(); sProcName = "up_Get_ReleasedRooms"; oDB.DbCmd = oDB.GetStoredProcCommand(sProcName); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@iBookingId", DbType.Int32, BookingId); dsAccomodationData = oDB.ExecuteDataSet(oDB.DbCmd); oDB = null; } catch (Exception exp) { oDB = null; dsAccomodationData = null; GF.LogError("clsBookingRoomReleaseHandler.GetReleasedRooms", exp.Message); } #region Populate the Object if (dsAccomodationData != null && dsAccomodationData.Tables[0].Rows.Count > 0) { accomodation = new Accomodation(); List <AccomodationRoomType> accomodationRoomTypes = null; List <AccomodationRoom> accomodationRooms = null; for (int i = 0; i < dsAccomodationData.Tables[0].Rows.Count; i++) { dr = dsAccomodationData.Tables[0].Rows[i]; int AccomodationId = Convert.ToInt32(dr.ItemArray.GetValue(3)); int bId = Convert.ToInt32(dr.ItemArray.GetValue(1)); int CategoryId = Convert.ToInt32(dr.ItemArray.GetValue(11)); int TypeId = Convert.ToInt32(dr.ItemArray.GetValue(12)); string RoomCategoryName = Convert.ToString(dr.ItemArray.GetValue(13)); string RoomTypeName = Convert.ToString(dr.ItemArray.GetValue(14)); string RoomNo = Convert.ToString(dr.ItemArray.GetValue(4)); if (accomodation.AccomodationDetail == null) { AccomodationDTO accomodationDetail = new AccomodationDTO(); accomodationDetail.AccomodationId = AccomodationId; accomodation.AccomodationDetail = accomodationDetail; } AccomodationRoomCategory Category = null; if (accomodation.Categories != null) { Category = accomodation.Categories.Find(delegate(AccomodationRoomCategory CategoryTypes) { return(CategoryTypes.RoomCategory.RoomCategoryId == CategoryId); }); if (Category != null && Category.RoomTypes != null) { accomodationRoomTypes = Category.RoomTypes; } else { accomodationRoomTypes = null; } } if (Category == null) { RoomCategoryDTO newRoomCategory = new RoomCategoryDTO(); newRoomCategory.RoomCategoryId = CategoryId; newRoomCategory.RoomCategory = RoomCategoryName; Category = new AccomodationRoomCategory(); Category.RoomCategory = newRoomCategory; accomodationRoomTypes = null; accomodationRooms = null; } AccomodationRoomType AccomodationRoomType = null; if (Category.RoomTypes != null) { AccomodationRoomType = Category.RoomTypes.Find(delegate(AccomodationRoomType type) { return(type.RoomType.RoomTypeId == TypeId); }); if (AccomodationRoomType != null && AccomodationRoomType.Rooms != null) { accomodationRooms = AccomodationRoomType.Rooms; } else { accomodationRooms = null; } } if (AccomodationRoomType == null) { RoomTypeDTO newRoomType = new RoomTypeDTO(); newRoomType.RoomTypeId = TypeId; newRoomType.RoomType = RoomTypeName; AccomodationRoomType = new AccomodationRoomType(); AccomodationRoomType.RoomType = newRoomType; if (accomodationRoomTypes == null) { accomodationRoomTypes = new List <AccomodationRoomType>(); } accomodationRoomTypes.Add(AccomodationRoomType); Category.RoomTypes = accomodationRoomTypes; accomodationRooms = null; } AccomodationRoom AccomodationRoom = null; if (AccomodationRoomType.Rooms != null) { AccomodationRoom = AccomodationRoomType.Rooms.Find(delegate(AccomodationRoom room) { return(room.RoomDetail.RoomNo == RoomNo); }); } if (AccomodationRoom == null) { RoomDTO newRoom = new RoomDTO(); newRoom.RoomNo = RoomNo; AccomodationRoom = new AccomodationRoom(); AccomodationRoom.RoomDetail = newRoom; if (accomodationRooms == null) { accomodationRooms = new List <AccomodationRoom>(); } accomodationRooms.Add(AccomodationRoom); AccomodationRoomType.Rooms = accomodationRooms; } if (accomodation.Categories == null) { List <AccomodationRoomCategory> categories = new List <AccomodationRoomCategory>(); categories.Add(Category); accomodation.Categories = categories; } else { if (!accomodation.Categories.Exists(delegate(AccomodationRoomCategory CategoryTypes) { return(CategoryTypes.RoomCategory.RoomCategoryId == CategoryId); })) { accomodation.Categories.Add(Category); } } } } #endregion return(accomodation); }
public IHttpActionResult Put([FromUri] int id, [FromBody] RoomCategoryDTO RoomCategory) { RoomCategoryService.PrePutDTO(ModelState, currentClient, id, RoomCategory); return(Ok()); }
public RoomCategoryDTO Post([FromBody] RoomCategoryDTO RoomCategory) { return(RoomCategoryService.PrePostDTO(ModelState, currentClient, RoomCategory)); }