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