public List <AmenitiesSlotSearchModel> FillSlotSearchGrid(AmenitiesSlotSearchModel model) { ShomaRMEntities db = new ShomaRMEntities(); List <AmenitiesSlotSearchModel> lstSlot = new List <AmenitiesSlotSearchModel>(); try { DataTable dtTable = new DataTable(); using (var cmd = db.Database.Connection.CreateCommand()) { db.Database.Connection.Open(); cmd.CommandText = "usp_GetSlotPaginationAndSearchData"; 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 = "SortBy"; param5.Value = model.SortBy; cmd.Parameters.Add(param5); DbParameter param6 = cmd.CreateParameter(); param6.ParameterName = "OrderBy"; param6.Value = model.OrderBy; cmd.Parameters.Add(param6); DbDataAdapter da = DbProviderFactories.GetFactory("System.Data.SqlClient").CreateDataAdapter(); da.SelectCommand = cmd; da.Fill(dtTable); db.Database.Connection.Close(); } foreach (DataRow dr in dtTable.Rows) { AmenitiesSlotSearchModel searchmodel = new AmenitiesSlotSearchModel(); searchmodel.ID = Convert.ToInt64(dr["ID"].ToString()); searchmodel.AmenityID = Convert.ToInt64(dr["AmenityID"].ToString()); searchmodel.Duration = dr["Duration"].ToString(); searchmodel.Deposit = dr["Deposit"].ToString(); searchmodel.Fees = dr["Fees"].ToString(); searchmodel.AmenityName = dr["AmenityName"].ToString(); lstSlot.Add(searchmodel); } db.Dispose(); return(lstSlot.ToList()); } catch (Exception ex) { db.Database.Connection.Close(); throw ex; } }
public int BuildPaganationSlotList(AmenitiesSlotSearchModel 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_GetSlotPaginationAndSearchData"; 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 = "SortBy"; param5.Value = model.SortBy; cmd.Parameters.Add(param5); DbParameter param6 = cmd.CreateParameter(); param6.ParameterName = "OrderBy"; param6.Value = model.OrderBy; cmd.Parameters.Add(param6); 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; } }