public int Insert_Material_Vendor(MaterialVendorInfo MaterialVendorInfo) { int Material_Vendor_Id = 0; Material_Vendor_Id = Convert.ToInt32(_sqlRepo.ExecuteScalerObj(Set_Values_In_Material_Vendor(MaterialVendorInfo), StoredProcedures.Insert_Material_Vendor_Sp.ToString(), CommandType.StoredProcedure)); return(Material_Vendor_Id); }
public VendorViewModel() { Vendor_Grid = new List <VendorInfo>(); Material_Vendor_Grid = new List <MaterialVendorInfo>(); Vendor = new VendorInfo(); Material_Vendor = new MaterialVendorInfo(); Friendly_Message = new List <FriendlyMessageInfo>(); Pager = new PaginationInfo(); States = new List <StateInfo>(); Nations = new List <NationInfo>(); Filter = new Vendor_Filter(); Material_Category = new List <MaterialCategoryInfo>(); Is_Primary = false; Attribute_Code = new AttributeCodeInfo(); Material_Category_Info = new MaterialCategoryInfo(); Materials = new List <MaterialInfo>(); }
public MaterialVendorViewModel() { Material_Vendor_Grid = new List <MaterialVendorInfo>(); Material_Vendor = new MaterialVendorInfo(); Friendly_Message = new List <FriendlyMessageInfo>(); Pager = new PaginationInfo(); }
private MaterialVendorInfo Get_Material_Vendor_Values(DataRow dr) { MaterialVendorInfo Material_vendor = new MaterialVendorInfo(); Material_vendor.Material_Vendor_Id = Convert.ToInt32(dr["Material_Vendor_Id"]); Material_vendor.Material_Id = Convert.ToInt32(dr["Material_Id"]); Material_vendor.Vendor_Id = Convert.ToInt32(dr["Vendor_Id"]); Material_vendor.Vendor_Name = Convert.ToString(dr["Vendor_Name"]); Material_vendor.Priority_Order = Convert.ToInt32(dr["Priority_Order"]); return(Material_vendor); }
public MaterialViewModel() { Material = new MaterialInfo(); Material_Vendor = new MaterialVendorInfo(); Materials = new List <MaterialInfo>(); Material_Vendors = new List <MaterialVendorInfo>(); Pager = new PaginationInfo(); Material_Categories = new List <MaterialCategoryInfo>(); Material_SubCategories = new List <MaterialSubCategoryInfo>(); Friendly_Message = new List <FriendlyMessageInfo>(); Filter = new MaterialFilter(); Vendor_Grid = new List <VendorInfo>(); }
private List <SqlParameter> Set_Values_In_Material_Vendor(MaterialVendorInfo MaterialVendorInfo) { List <SqlParameter> sqlParamList = new List <SqlParameter>(); if (MaterialVendorInfo.Material_Vendor_Id != 0) { sqlParamList.Add(new SqlParameter("@Material_Vendor_Id", MaterialVendorInfo.Material_Vendor_Id)); } sqlParamList.Add(new SqlParameter("@Material_Id", MaterialVendorInfo.Material_Id)); sqlParamList.Add(new SqlParameter("@Vendor_Id", MaterialVendorInfo.Vendor_Id)); sqlParamList.Add(new SqlParameter("@Priority_Order", MaterialVendorInfo.Priority_Order)); if (MaterialVendorInfo.Material_Vendor_Id == 0) { sqlParamList.Add(new SqlParameter("@CreatedBy", MaterialVendorInfo.CreatedBy)); } return(sqlParamList); }
public void Update_Material_Vendor(MaterialVendorInfo MaterialVendorInfo) { }
public int Insert_Material_Vendor(MaterialVendorInfo MaterialVendorInfo) { return(_materialRepo.Insert_Material_Vendor(MaterialVendorInfo)); }