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