public int Insert_Industrial_Vendor(IndustrialVendorInfo industrialVendorInfo)
{
int industrial_Vendor_Id = 0;
industrial_Vendor_Id = Convert.ToInt32(_sqlRepo.ExecuteScalerObj(Set_Values_In_Industrial_Vendor(industrialVendorInfo), StoredProcedures.Insert_Industrial_Vendor_Sp.ToString(), CommandType.StoredProcedure));
return(industrial_Vendor_Id);
}
private IndustrialVendorInfo Get_Industrial_Vendor_Values(DataRow dr)
{
IndustrialVendorInfo industrial_vendor = new IndustrialVendorInfo();
industrial_vendor.Industrial_Vendor_Id = Convert.ToInt32(dr["Industrial_Vendor_Id"]);
industrial_vendor.Industrial_Master_Id = Convert.ToInt32(dr["Industrial_Master_Id"]);
industrial_vendor.Vendor_Id = Convert.ToInt32(dr["Vendor_Id"]);
industrial_vendor.Vendor_Name = Convert.ToString(dr["Vendor_Name"]);
industrial_vendor.Priority_Order = Convert.ToInt32(dr["Priority_Order"]);
return(industrial_vendor);
}
public IndustrialViewModel()
{
Industrial = new IndustrialInfo();
Industrial_Vendor = new IndustrialVendorInfo();
Industrials = new List <IndustrialInfo>();
Industrial_Vendors = new List <IndustrialVendorInfo>();
Pager = new PaginationInfo();
Industrial_Categories = new List <IndustrialCategoryInfo>();
Industrial_Groups = new List <IndustrialGroupInfo>();
Friendly_Message = new List <FriendlyMessageInfo>();
Filter = new IndustrialFilter();
}
private List <SqlParameter> Set_Values_In_Industrial_Vendor(IndustrialVendorInfo industrialVendorInfo)
{
List <SqlParameter> sqlParamList = new List <SqlParameter>();
if (industrialVendorInfo.Industrial_Vendor_Id != 0)
{
sqlParamList.Add(new SqlParameter("@Industrial_Vendor_Id", industrialVendorInfo.Industrial_Vendor_Id));
}
sqlParamList.Add(new SqlParameter("@Industrial_Master_Id", industrialVendorInfo.Industrial_Master_Id));
sqlParamList.Add(new SqlParameter("@Vendor_Id", industrialVendorInfo.Vendor_Id));
sqlParamList.Add(new SqlParameter("@Priority_Order", industrialVendorInfo.Priority_Order));
if (industrialVendorInfo.Industrial_Vendor_Id == 0)
{
sqlParamList.Add(new SqlParameter("@CreatedBy", industrialVendorInfo.CreatedBy));
}
sqlParamList.Add(new SqlParameter("@UpdatedBy", industrialVendorInfo.UpdatedBy));
return(sqlParamList);
}
public void Update_Industrial_Vendor(IndustrialVendorInfo industrialVendorInfo)
{
}
public int Insert_Industrial_Vendor(IndustrialVendorInfo industrialVendorInfo)
{
return(_industrialRepo.Insert_Industrial_Vendor(industrialVendorInfo));
}