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 List <MaterialCategoryInfo> Get_Material_Category() { List <MaterialCategoryInfo> retVal = new List <MaterialCategoryInfo>(); DataTable dt = _sqlRepo.ExecuteDataTable(null, StoredProcedures.Get_Material_Categories_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) { MaterialCategoryInfo MaterialCategoryInfo = new MaterialCategoryInfo(); MaterialCategoryInfo.Material_Category_Id = Convert.ToInt32(dr["Material_Category_Id"]); MaterialCategoryInfo.Material_Category_Name = Convert.ToString(dr["Material_Category_Name"]); retVal.Add(MaterialCategoryInfo); } } return(retVal); }
private MaterialCategoryInfo Get_Material_Category_Values(DataRow dr) { MaterialCategoryInfo Material_Category = new MaterialCategoryInfo(); Material_Category.Material_Category_Id = Convert.ToInt32(dr["Material_Category_Id"]); Material_Category.Material_Category_Name = Convert.ToString(dr["Material_Category_Name"]); return(Material_Category); }