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