public ItBudgetReportItem FillItBudgetItem(Budget bud, float peopleCost, int level) { var item = new ItBudgetReportItem(); item.BudgetName = bud.Name; var empList = Employee.GetList(idBudget: bud.Id, showHidden: false); var peopleList = new List<ItBudgetReportItemPeople>(); foreach (Employee emp in empList) { if (emp.HasAdAccount) { var p = new ItBudgetReportItemPeople(); p.FullName = emp.FullName; p.PositionName = emp.Position.Name; p.Cost = peopleCost; p.BudgetName = bud.Name; peopleList.Add(p); } } item.Peoples = peopleList; if (bud.EmpCount.HasValue) { item.PeopleCount = bud.EmpCount.Value;} else { item.PeopleCount = 0;} item.CostSum = item.PeopleCount * peopleCost; item.Level = level; return item; }
public HttpResponseMessage Save(Budget model) { HttpResponseMessage response = new HttpResponseMessage(HttpStatusCode.Created); try { model.CurUserAdSid = GetCurUser().Sid; model.Save(); response.Content = new StringContent(String.Format("{{\"id\":{0}}}", model.Id)); } catch (Exception ex) { response = new HttpResponseMessage(HttpStatusCode.OK); response.Content = new StringContent(MessageHelper.ConfigureExceptionMessage(ex)); } return response; }
public static IEnumerable<Budget> GetList() { var dt = Db.Stuff.ExecuteQueryStoredProcedure("get_budget_list"); var lst = new List<Budget>(); foreach (DataRow row in dt.Rows) { var model = new Budget(row); lst.Add(model); } return lst.OrderBy(x=>x.Parent.Name).ThenBy(x=>x.Name); }
public IHttpActionResult Get(int id) { var model = new Budget(id); return Ok(model); }
private void FillSelf(DataRow row) { Id = Db.DbHelper.GetValueIntOrDefault(row, "id"); Name = Db.DbHelper.GetValueString(row, "name"); Descr = Db.DbHelper.GetValueString(row, "descr"); EmpCount = Db.DbHelper.GetValueIntOrNull(row, "emp_count"); IdParent = Db.DbHelper.GetValueIntOrNull(row, "id_parent"); if (IdParent.HasValue) { Parent = new Budget(IdParent.Value);} else { Parent = new Budget(); } }