public string SaveUpdateReservationRequest(AmenitiesReservationModel model) { string msg = ""; ShomaRMEntities db = new ShomaRMEntities(); DateTime dt = DateTime.Parse(model.DesiredTime != null ? model.DesiredTime : "00:00"); DateTime dtF = DateTime.Parse(model.DesiredTimeFrom != null ? model.DesiredTimeFrom : "00:00"); DateTime dtT = DateTime.Parse(model.DesiredTimeTo != null ? model.DesiredTimeTo : "00:00"); if (model.ARID == 0) { var saveReservationRequest = new tbl_AmenityReservation() { TenantID = model.TenantID, AmenityID = model.AmenityID, DesiredDate = model.DesiredDate, DesiredTime = dt.ToString("HH:mm"), Duration = model.Duration, DurationID = model.DurationID, DepositFee = model.DepositFee, ReservationFee = model.ReservationFee, Status = model.Status, DesiredTimeFrom = dtF.ToString("HH:mm"), DesiredTimeTo = dtT.ToString("HH:mm"), Guest = model.Guest }; db.tbl_AmenityReservation.Add(saveReservationRequest); db.SaveChanges(); msg = "Reservation Request Save Successfully"; } else { var GetReservationRequestData = db.tbl_AmenityReservation.Where(p => p.TenantID == model.TenantID).FirstOrDefault(); if (GetReservationRequestData != null) { GetReservationRequestData.AmenityID = model.AmenityID; GetReservationRequestData.DesiredDate = model.DesiredDate; GetReservationRequestData.DesiredTime = dt.ToString("HH:mm"); GetReservationRequestData.Duration = model.Duration; GetReservationRequestData.DurationID = model.DurationID; GetReservationRequestData.DepositFee = model.DepositFee; GetReservationRequestData.ReservationFee = model.ReservationFee; GetReservationRequestData.Status = model.Status; GetReservationRequestData.DesiredTimeFrom = model.DesiredTimeFrom; GetReservationRequestData.DesiredTimeTo = model.DesiredTimeTo; GetReservationRequestData.Guest = model.Guest; db.SaveChanges(); msg = "Reservation Request Updated Successfully"; } } db.Dispose(); return(msg); }
public AmenitiesReservationModel GetRRInfo(long Id) { ShomaRMEntities db = new ShomaRMEntities(); AmenitiesReservationModel model = new AmenitiesReservationModel(); var GetRRData = db.tbl_AmenityReservation.Where(p => p.ARID == Id).FirstOrDefault(); if (GetRRData != null) { model.TenantID = GetRRData.TenantID; model.AmenityID = GetRRData.AmenityID; model.DesiredDate = GetRRData.DesiredDate; model.DesiredDateString = GetRRData.DesiredDate != null?GetRRData.DesiredDate.Value.ToString("MM/dd/yyyy") : ""; DateTime dt = DateTime.Parse(GetRRData.DesiredTime != string.Empty ? GetRRData.DesiredTime : "00:00"); model.DesiredTime = dt.ToString("hh:mm tt"); model.Duration = GetRRData.Duration; model.DurationID = GetRRData.DurationID; model.DepositFee = GetRRData.DepositFee; model.ReservationFee = GetRRData.ReservationFee; model.Status = GetRRData.Status; model.DesiredTimeFrom = GetRRData.DesiredTimeFrom; model.DesiredTimeTo = GetRRData.DesiredTimeTo; model.Guest = GetRRData.Guest; } var GetAmenityData = db.tbl_Amenities.Where(p => p.ID == model.AmenityID).FirstOrDefault(); if (GetAmenityData != null) { model.AmenityName = GetAmenityData.Amenity; } var GetTenantData = db.tbl_TenantInfo.Where(p => p.TenantID == model.TenantID).FirstOrDefault(); if (GetTenantData != null) { model.TenantName = GetTenantData != null ? GetTenantData.FirstName + " " + GetTenantData.LastName : ""; } model.ARID = Id; return(model); }
public AmenitiesReservationModel GetRRData(int Id) { ShomaRMEntities db = new ShomaRMEntities(); AmenitiesReservationModel model = new AmenitiesReservationModel(); var GetRRData = db.tbl_AmenityReservation.Where(p => p.ARID == Id).FirstOrDefault(); if (GetRRData != null) { model.AmenityID = GetRRData.AmenityID; model.DesiredDate = GetRRData.DesiredDate; model.DesiredTime = GetRRData.DesiredTime; model.Duration = GetRRData.Duration; model.DurationID = GetRRData.DurationID; model.DepositFee = GetRRData.DepositFee; model.ReservationFee = GetRRData.ReservationFee; model.Status = GetRRData.Status; model.DesiredTimeFrom = GetRRData.DesiredTimeFrom; model.DesiredTimeTo = GetRRData.DesiredTimeTo; model.Guest = GetRRData.Guest; } model.ARID = Id; return(model); }
public List <AmenitiesReservationSearchModel> FillRRList(AmenitiesReservationModel model) { ShomaRMEntities db = new ShomaRMEntities(); List <AmenitiesReservationSearchModel> lstReservationRequest = new List <AmenitiesReservationSearchModel>(); try { DataTable dtTable = new DataTable(); using (var cmd = db.Database.Connection.CreateCommand()) { db.Database.Connection.Open(); cmd.CommandText = "usp_ReservationRequestList"; cmd.CommandType = CommandType.StoredProcedure; DbParameter param0 = cmd.CreateParameter(); param0.ParameterName = "id"; param0.Value = model.TenantID; cmd.Parameters.Add(param0); DbDataAdapter da = DbProviderFactories.GetFactory("System.Data.SqlClient").CreateDataAdapter(); da.SelectCommand = cmd; da.Fill(dtTable); db.Database.Connection.Close(); } foreach (DataRow dr in dtTable.Rows) { AmenitiesReservationSearchModel searchmodel = new AmenitiesReservationSearchModel(); searchmodel.ARID = Convert.ToInt64(dr["ARID"].ToString()); searchmodel.TenantID = Convert.ToInt64(dr["AmenityID"].ToString()); searchmodel.AmenityID = Convert.ToInt64(dr["AmenityID"].ToString()); searchmodel.DesiredDate = dr["DesiredDate"].ToString(); string time = dr["DesiredTime"].ToString(); DateTime dt = DateTime.Parse(time != string.Empty ? time : "00:00 AM"); searchmodel.DesiredTime = dt.ToString("hh:mm tt"); searchmodel.DurationID = dr["DurationID"].ToString(); searchmodel.DepositFee = dr["DepositFee"].ToString(); searchmodel.ReservationFee = dr["ReservationFee"].ToString(); searchmodel.Status = dr["Status"].ToString() == null ? "" : dr["Status"].ToString(); searchmodel.Duration = dr["Duration"].ToString(); searchmodel.TenantName = dr["TenantName"].ToString(); searchmodel.AmenityName = dr["AmenityName"].ToString(); searchmodel.DesiredTimeFrom = dr["DesiredTimeFrom"].ToString(); searchmodel.DesiredTimeTo = dr["DesiredTimeTo"].ToString(); searchmodel.Guest = dr["Guest"].ToString(); string desireDt = dr["DesiredDate"].ToString(); if (desireDt != string.Empty) { DateTime dttt = DateTime.Parse(desireDt).AddDays(-3); searchmodel.calculatedDate = dttt.ToString("MM/dd/yyyy"); } else { searchmodel.calculatedDate = ""; } lstReservationRequest.Add(searchmodel); } db.Dispose(); return(lstReservationRequest.ToList()); } catch (Exception ex) { db.Database.Connection.Close(); throw ex; } }