private void Update() { if (!base.ValidateIfCommandAllowed(Request.Url.AbsoluteUri, ENums.PageCommand.Update)) { return; } if (!ValidateValues("update")) { return; } bool bActionCompleted; AccomodationDTO oAccomData = null; AccomodationMaster oAccomMaster = new AccomodationMaster(); oAccomData = MapControlsToObject(); bActionCompleted = oAccomMaster.Update(oAccomData); if (bActionCompleted == true) { base.DisplayAlert("The record has been updated successfully"); ClearControls(); lblStatus.Text = "Updated Successfully"; } else { lblStatus.Text = "Error Occured while updating: Please refer to the error log."; } oAccomData = null; oAccomMaster = null; //lblStatus.Text = "Updated"; }
public bool updateStatus(AccomodationDTO oAccomData) { string sProcName; DatabaseManager oDB; try { oDB = new DatabaseManager(); sProcName = "up_Upd_Activate"; oDB.DbCmd = oDB.GetStoredProcCommand(sProcName); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@iAccomId", DbType.Int32, oAccomData.AccomodationId); oDB.ExecuteNonQuery(oDB.DbCmd); } catch (Exception exp) { GF.LogError("clsAccomodationMaster.updateStatus", exp.Message.ToString()); oDB = null; return(false); } finally { oDB = null; } return(true); }
public bool Insert(AccomodationDTO oAccomData) { string sProcName; DatabaseManager oDB; try { oDB = new DatabaseManager(); sProcName = "up_Ins_AccomodationMaster"; oDB.DbCmd = oDB.GetStoredProcCommand(sProcName); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@iAccomodationTypeId", DbType.Int32, oAccomData.AccomodationTypeId); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@sAccomodation", DbType.String, oAccomData.AccomodationName); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@RegionId", DbType.Int32, oAccomData.RegionId); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@AccomInitial", DbType.String, oAccomData.AccomInitial); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@AccomPolicyUrl", DbType.String, oAccomData.AccomPolicyUrl); int accomId = Convert.ToInt32(oDB.ExecuteScalar(oDB.DbCmd)); } catch (Exception exp) { GF.LogError("clsAccomodationMaster.Insert", exp.Message.ToString()); oDB = null; return(false); } finally { oDB = null; } return(true); }
private void Delete() { if (!base.ValidateIfCommandAllowed(Request.Url.AbsoluteUri, ENums.PageCommand.Delete)) { return; } bool bActionCompleted; string sMessage = ""; AccomodationDTO oAccomData = new AccomodationDTO(); AccomodationMaster oAccomMaster = new AccomodationMaster(); int Id = 0; int.TryParse(hfId.Value, out Id); if (Id == 0) { lblStatus.Text = "Please click on edit again."; return; } oAccomData.AccomodationId = Id; /* * * CHECK IF THE ACCOMODATION 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 * */ GF.HasRecords(Convert.ToString(Id), "accomodation", out sMessage); if (sMessage != "") { base.DisplayAlert(sMessage); btnDelete.Enabled = true; } else { bActionCompleted = oAccomMaster.Delete(oAccomData); if (bActionCompleted == true) { base.DisplayAlert("The record has been deleted successfully."); ClearControls(); //lblStatus.Text = "Deleted"; } else { base.DisplayAlert("Error Occured while deletion: Please refer to the error log."); } //lblStatus.Text = "Error Occured while updating: Please refer to the error log."; } oAccomMaster = null; oAccomData = null; }
private AccomodationDTO MapControlsToObject() { AccomodationDTO oAccomData = new AccomodationDTO(); int id = 0; int.TryParse(hfId.Value, out id); oAccomData.AccomodationId = id; oAccomData.AccomodationName = txtAccomName.Text.ToString(); oAccomData.AccomodationTypeId = Convert.ToInt32(ddlAccomTypeId.SelectedValue.ToString()); oAccomData.RegionId = Convert.ToInt32(ddlRegion.SelectedValue.ToString()); oAccomData.AccomInitial = txtAccomInitial.Text.ToString(); oAccomData.AccomPolicyUrl = txtAccomPolicyUrl.Text.ToString(); return(oAccomData); }
public AccomodationDTO GetAccomodation(int accomodationTypeId, int accomodationId) { AccomodationDTO[] accomodationDTOList = GetAccomodations(accomodationTypeId); AccomodationDTO accomodation = null; for (int i = 0; i < accomodationDTOList.Length; i++) { if (accomodationDTOList[i].AccomodationId == accomodationId) { accomodation = accomodationDTOList[i]; } } return(accomodation); }
public AccomodationDTO[] GetData1(int RegionId, int AccomodationTypeId, int AccomodationId) { DataSet ds; AccomodationDTO[] AccomData; AccomData = null; ds = null; string sProcName; DatabaseManager oDB; try { oDB = new DatabaseManager(); sProcName = "up_Get_Accomodations1"; oDB.DbCmd = oDB.GetStoredProcCommand(sProcName); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@iAccomTypeId", DbType.Int32, AccomodationTypeId); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@iAccomId", DbType.Int32, AccomodationId); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@iRegionId", DbType.Int32, RegionId); ds = oDB.ExecuteDataSet(oDB.DbCmd); if (ds != null && ds.Tables[0].Rows.Count > 0) { AccomData = new AccomodationDTO[ds.Tables[0].Rows.Count]; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { AccomData[i] = new AccomodationDTO(); AccomData[i].AccomodationTypeId = Convert.ToInt32(ds.Tables[0].Rows[i][0]); AccomData[i].AccomodationType = Convert.ToString(ds.Tables[0].Rows[i][1]); AccomData[i].AccomodationId = Convert.ToInt32(ds.Tables[0].Rows[i][2]); AccomData[i].AccomodationName = Convert.ToString(ds.Tables[0].Rows[i][3]); AccomData[i].RegionId = Convert.ToInt32(ds.Tables[0].Rows[i][4]); AccomData[i].Region = Convert.ToString(ds.Tables[0].Rows[i][5]); AccomData[i].AccomInitial = Convert.ToString(ds.Tables[0].Rows[i][6]); AccomData[i].AccomPolicyUrl = Convert.ToString(ds.Tables[0].Rows[i][7]); AccomData[i].AccomodationSeasonList = GetAccomodationSeasonDates(AccomData[i].AccomodationId); } } } catch (Exception exp) { GF.LogError("clsAccomodationMaster.Update", exp.Message.ToString()); oDB = null; } finally { oDB = null; } return(AccomData); }
public AccomodationDTO[] GetAccomodations(int AccomodationTypeId) { DataSet ds; AccomodationDTO[] AccomData; //CombinedAccomData[] oCombinedAccomData = null; ; AccomData = null; ds = null; string sProcName; DatabaseManager oDB; try { oDB = new DatabaseManager(); sProcName = "up_GetAccomodations"; oDB.DbCmd = oDB.GetStoredProcCommand(sProcName); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@iAccomodationTypeID", DbType.Int32, AccomodationTypeId); ds = oDB.ExecuteDataSet(oDB.DbCmd); if (ds != null && ds.Tables[0].Rows.Count > 0) { AccomData = new AccomodationDTO[ds.Tables[0].Rows.Count]; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { AccomData[i] = new AccomodationDTO(); AccomData[i].AccomodationId = Convert.ToInt32(ds.Tables[0].Rows[i][0].ToString()); AccomData[i].AccomodationName = Convert.ToString(ds.Tables[0].Rows[i][1].ToString()); AccomData[i].AccomInitial = Convert.ToString(ds.Tables[0].Rows[i][2].ToString()); } } } catch (Exception exp) { GF.LogError("clsAccomodationMaster.Update", exp.Message.ToString()); oDB = null; return(null); } finally { oDB = null; } // return oCombinedAccomData; return(AccomData); }
protected void btnInactive_Click(object sender, EventArgs e) { AccomodationMaster oAccomMaster = new AccomodationMaster(); AccomodationDTO oAccomData = new AccomodationDTO(); int accomid = 0; if (Session["accomid"] != null) { accomid = Convert.ToInt32(Session["accomid"].ToString()); oAccomData.AccomodationId = accomid; } if (btnInactive.Text == "Inactive") { bool n = updateStatus(oAccomData); if (n == true) { lblStatus.Text = "Successfully Inctive"; lblStatus.ForeColor = System.Drawing.Color.Green; btnInactive.Text = "Active"; } } else { bool n = updateStatus(oAccomData); if (n == true) { lblStatus.Text = "Successfully Active"; lblStatus.ForeColor = System.Drawing.Color.Green; btnInactive.Text = "Inactive"; } } //ScriptManager.RegisterStartupScript(this, this.GetType(), "showPopup", "if (!confirm('Do you want to continue?')) return false;", true); }
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); }