public List<VIEW_FOR_SUPPLIER_MASTER_NEW> GetSupplier(int startIndex, int maximumRows, string sortExpression, string filterExpression, string scommode, string sfname, string slname, string semail, string smob, string stele)
{
if (!String.IsNullOrEmpty(filterExpression))
{
Supply = Supply.Where(filterExpression);
}
if (!String.IsNullOrEmpty(sortExpression))
{
Supply = Supply.OrderBy(sortExpression);
}
if (!String.IsNullOrEmpty(scommode))
{
NewSupplierDataContext db = new NewSupplierDataContext();
Supply = db.VIEW_FOR_SUPPLIER_MASTER_NEWs.Where(p => (p.COMMUNICATION_MODE_NAME.Contains(scommode)));
}
if (!String.IsNullOrEmpty(sfname))
{
NewSupplierDataContext db = new NewSupplierDataContext();
Supply = db.VIEW_FOR_SUPPLIER_MASTER_NEWs.Where(p => (p.SUPPLIER_COMPANY_NAME.Contains(sfname)));
}
if (!String.IsNullOrEmpty(slname))
{
NewSupplierDataContext db = new NewSupplierDataContext();
Supply = db.VIEW_FOR_SUPPLIER_MASTER_NEWs.Where(p => (p.SUPPLIER_TYPE_NAME.Contains(slname)));
}
if (!String.IsNullOrEmpty(semail))
{
NewSupplierDataContext db = new NewSupplierDataContext();
Supply = db.VIEW_FOR_SUPPLIER_MASTER_NEWs.Where(p => (p.SUPPLIER_REL_EMAIL.Contains(semail)));
}
if (!String.IsNullOrEmpty(smob))
{
NewSupplierDataContext db = new NewSupplierDataContext();
Supply = db.VIEW_FOR_SUPPLIER_MASTER_NEWs.Where(p => (p.SUPPLIER_REL_MOBILE.Contains(smob)));
}
if (!String.IsNullOrEmpty(stele))
{
NewSupplierDataContext db = new NewSupplierDataContext();
Supply = db.VIEW_FOR_SUPPLIER_MASTER_NEWs.Where(p => (p.SUPPLIER_REL_PHONE.Contains(stele)));
}
else
{
Supply = Supply.OrderBy("SUPPLIER_ID ASC");
}
return Supply.Skip(startIndex).Take(maximumRows).ToList();
}
public List<VIEW_SUPPLIER_CONTECT_DETAIL> Contectdetail(string SUPPLIER_ID, string city, string state, string country)
{
if (!String.IsNullOrEmpty(city))
{
NewSupplierDataContext db = new NewSupplierDataContext();
Contect = db.VIEW_SUPPLIER_CONTECT_DETAILs.Where(p => (p.CITY_NAME.Contains(city)));
}
if (!String.IsNullOrEmpty(state))
{
NewSupplierDataContext db = new NewSupplierDataContext();
Contect = db.VIEW_SUPPLIER_CONTECT_DETAILs.Where(p => (p.STATE_NAME.Contains(state)));
}
if (!String.IsNullOrEmpty(country))
{
NewSupplierDataContext db = new NewSupplierDataContext();
Contect = db.VIEW_SUPPLIER_CONTECT_DETAILs.Where(p => (p.COUNTRY_NAME.Contains(country)));
}
Contect = Contect.Where(String.Format(@"SUPPLIER_ID == {0}", SUPPLIER_ID));
return Contect.ToList();
}