public int BuildPaganationRRList(AmenitiesReservationSearchModel model)
{
int NOP = 0;
ShomaRMEntities db = new ShomaRMEntities();
try
{
DataTable dtTable = new DataTable();
using (var cmd = db.Database.Connection.CreateCommand())
{
db.Database.Connection.Open();
cmd.CommandText = "usp_GetReservationRequestPaginationAndSearchData";
cmd.CommandType = CommandType.StoredProcedure;
DbParameter param0 = cmd.CreateParameter();
param0.ParameterName = "FromDate";
param0.Value = model.FromDate;
cmd.Parameters.Add(param0);
DbParameter param1 = cmd.CreateParameter();
param1.ParameterName = "ToDate";
param1.Value = model.ToDate;
cmd.Parameters.Add(param1);
DbParameter param3 = cmd.CreateParameter();
param3.ParameterName = "PageNumber";
param3.Value = model.PageNumber;
cmd.Parameters.Add(param3);
DbParameter param4 = cmd.CreateParameter();
param4.ParameterName = "NumberOfRows";
param4.Value = model.NumberOfRows;
cmd.Parameters.Add(param4);
DbParameter param5 = cmd.CreateParameter();
param5.ParameterName = "UnitId";
param5.Value = model.UnitId != null?Convert.ToInt32(model.UnitId) : 0;
cmd.Parameters.Add(param5);
DbParameter param6 = cmd.CreateParameter();
param6.ParameterName = "AmenityName";
param6.Value = model.AmenityName != null ? model.AmenityName : string.Empty;
cmd.Parameters.Add(param6);
DbParameter param8 = cmd.CreateParameter();
param8.ParameterName = "SortBy";
param8.Value = model.SortBy;
cmd.Parameters.Add(param8);
DbParameter param9 = cmd.CreateParameter();
param9.ParameterName = "OrderBy";
param9.Value = model.OrderBy;
cmd.Parameters.Add(param9);
DbDataAdapter da = DbProviderFactories.GetFactory("System.Data.SqlClient").CreateDataAdapter();
da.SelectCommand = cmd;
da.Fill(dtTable);
db.Database.Connection.Close();
}
if (dtTable.Rows.Count > 0)
{
NOP = int.Parse(dtTable.Rows[0]["NumberOfPages"].ToString());
}
db.Dispose();
return(NOP);
}
catch (Exception ex)
{
db.Database.Connection.Close();
throw ex;
}
}
public List <AmenitiesReservationSearchModel> FillRRSearchGrid(AmenitiesReservationSearchModel 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_GetReservationRequestPaginationAndSearchData";
cmd.CommandType = CommandType.StoredProcedure;
DbParameter param0 = cmd.CreateParameter();
param0.ParameterName = "FromDate";
param0.Value = model.FromDate;
cmd.Parameters.Add(param0);
DbParameter param1 = cmd.CreateParameter();
param1.ParameterName = "ToDate";
param1.Value = model.ToDate;
cmd.Parameters.Add(param1);
DbParameter param3 = cmd.CreateParameter();
param3.ParameterName = "PageNumber";
param3.Value = model.PageNumber;
cmd.Parameters.Add(param3);
DbParameter param4 = cmd.CreateParameter();
param4.ParameterName = "NumberOfRows";
param4.Value = model.NumberOfRows;
cmd.Parameters.Add(param4);
DbParameter param5 = cmd.CreateParameter();
param5.ParameterName = "UnitId";
param5.Value = model.UnitId;
cmd.Parameters.Add(param5);
DbParameter param6 = cmd.CreateParameter();
param6.ParameterName = "AmenityName";
param6.Value = model.AmenityName != null ? model.AmenityName : string.Empty;
cmd.Parameters.Add(param6);
DbParameter param8 = cmd.CreateParameter();
param8.ParameterName = "SortBy";
param8.Value = model.SortBy;
cmd.Parameters.Add(param8);
DbParameter param9 = cmd.CreateParameter();
param9.ParameterName = "OrderBy";
param9.Value = model.OrderBy;
cmd.Parameters.Add(param9);
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();
searchmodel.UnitId = dr["UnitID"].ToString();
searchmodel.UnitNo = dr["UnitNo"].ToString();
lstReservationRequest.Add(searchmodel);
}
db.Dispose();
return(lstReservationRequest.ToList());
}
catch (Exception ex)
{
db.Database.Connection.Close();
throw ex;
}
}
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;
}
}
