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