public static List <Model.mdlCost> GetSearchCost(string keyword) { var pCost = DataContext.Costs.Where(fld => fld.CostID.Contains(keyword)).OrderBy(fld => fld.CostID).ToList(); var mdlCostList = new List <Model.mdlCost>(); foreach (var cost in pCost) { var mdlCost = new Model.mdlCost(); mdlCost.CostID = cost.CostID; mdlCost.CostName = cost.CostName; mdlCost.Type = cost.Type; mdlCostList.Add(mdlCost); } return(mdlCostList); }
public static List <Model.mdlCost> LoadCost() { var mdlCostList = new List <Model.mdlCost>(); List <SqlParameter> sp = new List <SqlParameter>() { }; DataTable dtCustomer = Manager.DataFacade.DTSQLCommand("SELECT CostID, CostName, Type FROM Cost", sp); foreach (DataRow drCustomer in dtCustomer.Rows) { var mdlCost = new Model.mdlCost(); mdlCost.CostID = drCustomer["CostID"].ToString(); mdlCost.CostName = drCustomer["CostName"].ToString(); mdlCost.Type = drCustomer["Type"].ToString(); mdlCostList.Add(mdlCost); } return(mdlCostList); }