public List <TenantPetSearchListModel> FillTenantPetSearchGrid(TenantPetSearchListModel model)
{
ShomaRMEntities db = new ShomaRMEntities();
List <TenantPetSearchListModel> lstData = new List <TenantPetSearchListModel>();
try
{
DataTable dtTable = new DataTable();
using (var cmd = db.Database.Connection.CreateCommand())
{
db.Database.Connection.Open();
cmd.CommandText = "usp_GetTenantPetPaginationAndSearchData";
cmd.CommandType = CommandType.StoredProcedure;
DbParameter paramDF = cmd.CreateParameter();
paramDF.ParameterName = "FromDate";
paramDF.Value = model.FromDate;
cmd.Parameters.Add(paramDF);
DbParameter paramDT = cmd.CreateParameter();
paramDT.ParameterName = "ToDate";
paramDT.Value = model.ToDate;
cmd.Parameters.Add(paramDT);
DbParameter paramC = cmd.CreateParameter();
paramC.ParameterName = "Criteria";
paramC.Value = model.Criteria;
cmd.Parameters.Add(paramC);
DbParameter paramCT = cmd.CreateParameter();
paramCT.ParameterName = "CriteriaByText";
paramCT.Value = model.CriteriaByText;
cmd.Parameters.Add(paramCT);
DbParameter paramPN = cmd.CreateParameter();
paramPN.ParameterName = "PageNumber";
paramPN.Value = model.PageNumber;
cmd.Parameters.Add(paramPN);
DbParameter paramNOR = cmd.CreateParameter();
paramNOR.ParameterName = "NumberOfRows";
paramNOR.Value = model.NumberOfRows;
cmd.Parameters.Add(paramNOR);
DbParameter paramSortBy = cmd.CreateParameter();
paramSortBy.ParameterName = "SortBy";
paramSortBy.Value = model.SortBy;
cmd.Parameters.Add(paramSortBy);
DbParameter paramOrderBy = cmd.CreateParameter();
paramOrderBy.ParameterName = "OrderBy";
paramOrderBy.Value = model.OrderBy;
cmd.Parameters.Add(paramOrderBy);
DbDataAdapter da = DbProviderFactories.GetFactory("System.Data.SqlClient").CreateDataAdapter();
da.SelectCommand = cmd;
da.Fill(dtTable);
db.Database.Connection.Close();
}
foreach (DataRow dr in dtTable.Rows)
{
TenantPetSearchListModel usm = new TenantPetSearchListModel();
usm.PetID = Convert.ToInt32(dr["PetID"].ToString());
//usm.TenantID = Convert.ToInt64(dr["TenantID"].ToString());
usm.PetType = dr["PetType"].ToString();
usm.Breed = dr["Breed"].ToString();
usm.Weight = dr["Weight"].ToString();
usm.Age = dr["Age"].ToString();
usm.Photo = dr["Photo"].ToString();
usm.PetVaccinationCert = dr["PetVaccinationCert"].ToString();
usm.PetName = dr["PetName"].ToString();
usm.VetsName = dr["VetsName"].ToString();
usm.OriginalPhoto = dr["OriginalPhoto"].ToString();
usm.OriginalVaccinationCert = dr["OriginalVaccinationCert"].ToString();
usm.UniqID = dr["UniqID"].ToString();
string expiryDate = "";
try { expiryDate = Convert.ToDateTime(dr["ExpiryDate"].ToString()).ToString("MM/dd/yyyy"); } catch { expiryDate = ""; }
usm.ExpiryDate = expiryDate;
usm.TenantName = dr["TenantName"].ToString();
usm.UnitNo = dr["UnitNo"].ToString();
usm.NumberOfPages = int.Parse(dr["NumberOfPages"].ToString());
string filePath = HttpContext.Current.Server.MapPath("~/Content/assets/img/pet/" + usm.PetVaccinationCert);
usm.FilePath = filePath;
lstData.Add(usm);
}
db.Dispose();
return(lstData.ToList());
}
catch (Exception ex)
{
db.Database.Connection.Close();
throw ex;
}
}
public int BuildPaganationTenantPetList(TenantPetSearchListModel 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_GetTenantPetPaginationAndSearchData";
cmd.CommandType = CommandType.StoredProcedure;
DbParameter paramDF = cmd.CreateParameter();
paramDF.ParameterName = "FromDate";
paramDF.Value = model.FromDate;
cmd.Parameters.Add(paramDF);
DbParameter paramDT = cmd.CreateParameter();
paramDT.ParameterName = "ToDate";
paramDT.Value = model.ToDate;
cmd.Parameters.Add(paramDT);
DbParameter paramC = cmd.CreateParameter();
paramC.ParameterName = "Criteria";
paramC.Value = model.Criteria;
cmd.Parameters.Add(paramC);
DbParameter paramCT = cmd.CreateParameter();
paramCT.ParameterName = "CriteriaByText";
paramCT.Value = model.CriteriaByText;
cmd.Parameters.Add(paramCT);
DbParameter paramPN = cmd.CreateParameter();
paramPN.ParameterName = "PageNumber";
paramPN.Value = model.PageNumber;
cmd.Parameters.Add(paramPN);
DbParameter paramNOR = cmd.CreateParameter();
paramNOR.ParameterName = "NumberOfRows";
paramNOR.Value = model.NumberOfRows;
cmd.Parameters.Add(paramNOR);
DbParameter paramSortBy = cmd.CreateParameter();
paramSortBy.ParameterName = "SortBy";
paramSortBy.Value = model.SortBy;
cmd.Parameters.Add(paramSortBy);
DbParameter paramOrderBy = cmd.CreateParameter();
paramOrderBy.ParameterName = "OrderBy";
paramOrderBy.Value = model.OrderBy;
cmd.Parameters.Add(paramOrderBy);
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;
}
}
