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