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)); }