public List <AutocompleteInfo> Get_Vendor_AutoComplete(string vendor_Name)
{
List <AutocompleteInfo> vendors = new List <AutocompleteInfo>();
List <SqlParameter> sqlParams = new List <SqlParameter>();
sqlParams.Add(new SqlParameter("@Vendor_Name", vendor_Name));
DataTable dt = _sqlRepo.ExecuteDataTable(sqlParams, StoredProcedures.Get_Vendor_By_Name_Sp.ToString(), CommandType.StoredProcedure);
if (dt != null && dt.Rows.Count > 0)
{
List <DataRow> drList = new List <DataRow>();
drList = dt.AsEnumerable().ToList();
foreach (DataRow dr in drList)
{
AutocompleteInfo auto = new AutocompleteInfo();
auto.Label = Convert.ToString(dr["Vendor_Name"]);
auto.Value = Convert.ToInt32(dr["Vendor_Id"]);
vendors.Add(auto);
}
}
return(vendors);
}
public List <RoleAccessInfo> Get_Access_List()
{
List <RoleAccessInfo> RoleAccessList = new List <RoleAccessInfo>();
DataTable dt = sqlRepo.ExecuteDataTable(null, StoredProcedures.Get_Access_Function_Sp.ToString(), CommandType.StoredProcedure);
if (dt != null && dt.Rows.Count > 0)
{
int count = 0;
List <DataRow> drList = new List <DataRow>();
drList = dt.AsEnumerable().ToList();
count = drList.Count();
foreach (DataRow dr in drList)
{
RoleAccessInfo roleAccess = new RoleAccessInfo();
roleAccess.Access_Function_Id = Convert.ToInt32(dr["Access_Fuction_Id"]);
roleAccess.Access_Name = Convert.ToString(dr["Access_Function_Name"]);
RoleAccessList.Add(roleAccess);
}
}
return(RoleAccessList);
}
public List <MaterialInfo> Get_Materials(ref PaginationInfo pager)
{
List <MaterialInfo> Materials = new List <MaterialInfo>();
DataTable dt = _sqlRepo.ExecuteDataTable(null, StoredProcedures.Get_Materials_Sp.ToString(), CommandType.StoredProcedure);
foreach (DataRow dr in CommonMethods.GetRows(dt, ref pager))
{
Materials.Add(Get_Material_Values(dr));
}
return(Materials);
}
public List <ComplaintInfo> Get_Complaints(ref PaginationInfo pager)
{
List <ComplaintInfo> complaints = new List <ComplaintInfo>();
DataTable dt = _sqlRepo.ExecuteDataTable(null, StoredProcedures.Get_Complaints_Sp.ToString(), CommandType.StoredProcedure);
foreach (DataRow dr in CommonMethods.GetRows(dt, ref pager))
{
complaints.Add(Get_Complaint_Values(dr));
}
return(complaints);
}
public List <PackingInfo> Get_Packings(ref PaginationInfo pager)
{
List <PackingInfo> packings = new List <PackingInfo>();
DataTable dt = _sqlRepo.ExecuteDataTable(null, StoredProcedures.Get_Packing_Sp.ToString(), CommandType.StoredProcedure);
foreach (DataRow dr in CommonMethods.GetRows(dt, ref pager))
{
packings.Add(Get_Packing_Values(dr));
}
return(packings);
}
public List <AttributeCodeInfo> Get_Attribute_Codes(ref PaginationInfo pager)
{
List <AttributeCodeInfo> retVal = new List <AttributeCodeInfo>();
DataTable dt = _sqlRepo.ExecuteDataTable(null, StoredProcedures.Get_Attribute_Codes_sp.ToString(), CommandType.StoredProcedure);
foreach (DataRow dr in CommonMethods.GetRows(dt, ref pager))
{
retVal.Add(Get_Attribute_Code_Values(dr));
}
return(retVal);
}
public List <NationInfo> Get_Nations(ref PaginationInfo pager)
{
List <NationInfo> Nations = new List <NationInfo>();
DataTable dt = sqlRepo.ExecuteDataTable(null, StoredProcedures.Get_Nation_Sp.ToString(), CommandType.StoredProcedure);
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in CommonMethods.GetRows(dt, ref pager))
{
Nations.Add(Get_Nation_Values(dr));
}
}
return(Nations);
}
public List <VendorInfo> Get_Vendors(ref PaginationInfo pager)
{
List <VendorInfo> vendors = new List <VendorInfo>();
DataTable dt = _sqlRepo.ExecuteDataTable(null, StoredProcedures.Get_Vendors_Sp.ToString(), CommandType.StoredProcedure);
foreach (DataRow dr in CommonMethods.GetRows(dt, ref pager))
{
vendors.Add(Get_Vendor_Values(dr));
}
return(vendors);
}
public List <IndustrialInfo> Get_Industrials(ref PaginationInfo pager)
{
List <IndustrialInfo> industrials = new List <IndustrialInfo>();
DataTable dt = _sqlRepo.ExecuteDataTable(null, StoredProcedures.Get_Industrial_Master_List_Sp.ToString(), CommandType.StoredProcedure);
//var tupleData = CommonMethods.GetRows(dt, ref pager);
foreach (DataRow dr in CommonMethods.GetRows(dt, ref pager))
{
industrials.Add(Get_Industrial_Values(dr));
}
return(industrials);
}
public List <WArticleInfo> Get_WArticles(ref PaginationInfo pager)
{
List <WArticleInfo> wArticles = new List <WArticleInfo>();
DataTable dt = _sqlRepo.ExecuteDataTable(null, StoredProcedures.Get_W_Articles_Sp.ToString(), CommandType.StoredProcedure);
foreach (DataRow dr in CommonMethods.GetRows(dt, ref pager))
{
wArticles.Add(Get_WArticle_Values(dr));
}
return(wArticles);
}
public List <QualityInfo> Get_Qualities(ref PaginationInfo pager)
{
List <QualityInfo> qualities = new List <QualityInfo>();
DataTable dt = _sqlRepo.ExecuteDataTable(null, StoredProcedures.Get_Qualities_Sp.ToString(), CommandType.StoredProcedure);
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in CommonMethods.GetRows(dt, ref pager))
{
QualityInfo quality = new QualityInfo();
quality.Quality_Id = Convert.ToInt32(dr["Quality_Id"]);
quality.Quality_No = Convert.ToInt32(dr["Quality_No"]);
qualities.Add(quality);
}
}
return(qualities);
}
public List <StateInfo> Get_States(int nation_Id, ref PaginationInfo pager)
{
List <StateInfo> States = new List <StateInfo>();
List <SqlParameter> sqlParams = new List <SqlParameter>();
sqlParams.Add(new SqlParameter("@Nation_Id", nation_Id));
DataTable dt = sqlRepo.ExecuteDataTable(sqlParams, StoredProcedures.Get_State_By_Nation_Id_Sp.ToString(), CommandType.StoredProcedure);
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in CommonMethods.GetRows(dt, ref pager))
{
States.Add(Get_State_Values(dr));
}
}
return(States);
}
public List <ConsumableInfo> Get_Category_Name(PaginationInfo pager)
{
List <ConsumableInfo> consumables = new List <ConsumableInfo>();
DataTable dt = _sqlRepo.ExecuteDataTable(null, StoredProcedures.Get_Category_Name_sp.ToString(), CommandType.StoredProcedure);
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in CommonMethods.GetRows(dt, ref pager))
{
ConsumableInfo consumable = new ConsumableInfo();
consumable.Category_Id = Convert.ToInt32(dr["CategoryId"]);
consumable.Category_Name = Convert.ToString(dr["CategoryName"]);
consumables.Add(consumable);
}
}
return(consumables);
}
public List <CustomerInfo> Get_Customers(ref PaginationInfo pager)
{
List <CustomerInfo> CustomerList = new List <CustomerInfo>();
DataTable dt = _sqlRepo.ExecuteDataTable(null, StoredProcedures.Get_Customer_Sp.ToString(), CommandType.StoredProcedure);
foreach (DataRow dr in CommonMethods.GetRows(dt, ref pager))
{
CustomerList.Add(Get_Customer_Values(dr));
}
return(CustomerList);
}
public List <QualityInfo> Get_Qualities(ref PaginationInfo pager)
{
List <QualityInfo> qualities = new List <QualityInfo>();
DataTable dt = _sqlRepo.ExecuteDataTable(null, StoredProcedures.Get_Quality_Sp.ToString(), CommandType.StoredProcedure);
foreach (DataRow dr in CommonMethods.GetRows(dt, ref pager))
{
qualities.Add(Get_Quality_Values(dr));
}
return(qualities);
}
public List <FactoryInfo> Get_Factories(ref PaginationInfo pager)
{
List <FactoryInfo> factories = new List <FactoryInfo>();
DataTable dt = _sqlRepo.ExecuteDataTable(null, StoredProcedures.Get_Factories_Sp.ToString(), CommandType.StoredProcedure);
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in CommonMethods.GetRows(dt, ref pager))
{
FactoryInfo factory = new FactoryInfo();
factory.Factory_Id = Convert.ToInt32(dr["Factory_Id"]);
factory.Factory_Name = Convert.ToString(dr["Factory_Name"]);
factories.Add(factory);
}
}
return(factories);
}
public void Insert_Enquiry(ref EnquiryInfo enquiry)
{
DataTable dt = _sqlRepo.ExecuteDataTable(Set_Values_In_Enquiry(enquiry), StoredProcedures.Insert_Enquiry_Sp.ToString(), CommandType.StoredProcedure);
List <DataRow> drList = new List <DataRow>();
drList = dt.AsEnumerable().ToList();
foreach (DataRow dr in drList)
{
enquiry.Enquiry_Id = Convert.ToInt32(dr["Enquiry_Id"]);
enquiry.Enquiry_No = Convert.ToString(dr["Enquiry_No"]);
}
}
