private object[] Take(ProjectBomModel model)
 {
     return(new object[]
     {
         "@line_id", model.Id,
         "@project_id", model.ProjectId,
         "@line_num", model.LineNo,
         "@status", model.Status,
         "@item_no", model.ItemNo,
         "@item_description", model.ItemDescription,
         "@quantity", model.Quantity,
         "@material", model.Material,
         "@revision", model.Revision,
         "@menu_id", model.MenuID,
         "@brand", model.Brand,
         "@remarks", model.Remarks,
         "@cost_code", model.CostCode,
         "@bom_no", model.BomNo,
         "@cost_price", model.CostPrice,
         "@due_date", model.DueDate,
         "@total_cost", model.TotalCost,
         "@messages", model.Messages,
         "@urgent_flag", model.UrgentFlag,
         "@last_update_date", model.LastUpdateDate,
         "@last_updated_by", model.LastUpdateBy,
         "@creation_date", model.CreationDate,
         "@created_by", model.CreatedBy
     });
 }
        public void Delete(ProjectBomModel model)
        {
            string sql = @"DELETE FROM prj_project_costs WHERE proj_cost_id = @proj_cost_id";

            object[] parms = { "@proj_cost_id", model.Id };
            db.Update(sql, parms);
        }
 public void Update(ProjectBomModel model)
 {
     throw new NotImplementedException();
 }
 public int Insert(ProjectBomModel model)
 {
     throw new NotImplementedException();
 }