public List <AmenitiesSlotModel> GetSlotListData(DateTime FromDate, DateTime ToDate)
{
ShomaRMEntities db = new ShomaRMEntities();
List <AmenitiesSlotModel> lstpr = new List <AmenitiesSlotModel>();
try
{
DataTable dtTable = new DataTable();
using (var cmd = db.Database.Connection.CreateCommand())
{
db.Database.Connection.Open();
cmd.CommandText = "usp_GetAmenitySlotList";
cmd.CommandType = CommandType.StoredProcedure;
DbParameter paramF = cmd.CreateParameter();
paramF.ParameterName = "FromDate";
paramF.Value = FromDate;
cmd.Parameters.Add(paramF);
DbParameter paramC = cmd.CreateParameter();
paramC.ParameterName = "ToDate";
paramC.Value = ToDate;
cmd.Parameters.Add(paramC);
DbDataAdapter da = DbProviderFactories.GetFactory("System.Data.SqlClient").CreateDataAdapter();
da.SelectCommand = cmd;
da.Fill(dtTable);
db.Database.Connection.Close();
}
foreach (DataRow dr in dtTable.Rows)
{
AmenitiesSlotModel pr = new AmenitiesSlotModel();
pr.AmenityID = Convert.ToInt64(dr["AmenityID"].ToString());
pr.Duration = dr["Duration"].ToString();
pr.Deposit = Convert.ToDecimal(dr["Deposit"].ToString());
pr.Fees = Convert.ToDecimal(dr["Deposit"].ToString());
lstpr.Add(pr);
}
db.Dispose();
return(lstpr.ToList());
}
catch (Exception ex)
{
db.Database.Connection.Close();
throw ex;
}
}
public AmenitiesSlotModel GetEventData(int Id)
{
ShomaRMEntities db = new ShomaRMEntities();
AmenitiesSlotModel model = new AmenitiesSlotModel();
var GetSlotData = db.tbl_AmenityPriceRange.Where(p => p.ID == Id).FirstOrDefault();
if (GetSlotData != null)
{
model.AmenityID = GetSlotData.AmenityID;
model.Duration = GetSlotData.Duration;
model.Deposit = GetSlotData.Deposit;
model.Fees = GetSlotData.Fees;
model.DurationID = Convert.ToInt64(GetSlotData.DurationID);
}
model.ID = Id;
return(model);
}
public string SaveUpdateSlot(AmenitiesSlotModel model)
{
string msg = "";
ShomaRMEntities db = new ShomaRMEntities();
if (model.ID == 0)
{
var saveSlot = new tbl_AmenityPriceRange()
{
AmenityID = model.AmenityID,
Duration = model.Duration,
Deposit = model.Deposit,
Fees = model.Fees,
DurationID = model.DurationID
};
db.tbl_AmenityPriceRange.Add(saveSlot);
db.SaveChanges();
msg = "Amenity Slot Save Successfully";
}
else
{
var GetSlotData = db.tbl_AmenityPriceRange.Where(p => p.ID == model.ID).FirstOrDefault();
if (GetSlotData != null)
{
GetSlotData.AmenityID = model.AmenityID;
GetSlotData.Duration = model.Duration;
GetSlotData.Deposit = model.Deposit;
GetSlotData.Fees = model.Fees;
GetSlotData.DurationID = model.DurationID;
db.SaveChanges();
msg = "Amenity Slot Updated Successfully";
}
}
db.Dispose();
return(msg);
}