private BudgetLimit[] Deserialize(DataRow row, Dictionary <string, int> monthDict, int year)
{
// преобразование строк в лимиты по месяцам
var budgetLimits = new List <BudgetLimit>();
foreach (var month in monthDict)
{
var limitAmount = row[month.Key];
if (limitAmount != null && String.IsNullOrEmpty(limitAmount.ToString().Trim()) == false)
{
BudgetLimit budgetLimit = null;
try
{
budgetLimit = new BudgetLimit()
{
Month = month.Value,
LimitAmount = Math.Round(Convert.ToDecimal(limitAmount), 0),
Year = year
};
}
catch (Exception)
{
}
budgetLimits.Add(budgetLimit);
}
}
return(budgetLimits.ToArray());
}
public ActionResult DeleteConfirmed(int id)
{
BudgetLimit budgetLimit = _budgetLimitService.GetById(id);
var user = _userService.GetUserDataForVersion();
var recycleBinInDBRelation = _serviceService.HasRecycleBinInDBRelation(budgetLimit);
if (recycleBinInDBRelation.hasRelated == false)
{
var recycleToRecycleBin = _budgetLimitService.RecycleToRecycleBin(budgetLimit.ID, user.Item1, user.Item2);
if (!recycleToRecycleBin.toRecycleBin)
{
ViewBag.RecycleBinError =
"Невозможно удалить, так как на удаляемый элемент ссылаются другие элементы в системе." +
"Сначала необходимо удалить элементы, которые ссылаются на данный элемент. " +
recycleToRecycleBin.relatedClassId;
return(View(budgetLimit));
}
}
else
{
ViewBag.RecycleBinError =
"Невозможно удалить, так как на удаляемый элемент ссылаются другие элементы в системе." +
$"Сначала необходимо удалить элементы, которые ссылаются на данный элемент. {recycleBinInDBRelation.relatedInDBClassId}";
return(View(budgetLimit));
}
return(RedirectToAction("Index"));
}
public ActionResult Edit(BudgetLimit budgetLimit)
{
if (ModelState.IsValid)
{
try
{
var limitDto = _budgetLimitService.GetLimitData(budgetLimit.CostSubItemID.Value, budgetLimit.DepartmentID.Value, budgetLimit.ProjectID, budgetLimit.Year.Value, budgetLimit.Month.Value);
if (limitDto != null)
{
budgetLimit.LimitAmountApproved = limitDto.LimitAmountReserved;
budgetLimit.FundsExpendedAmount = limitDto.LimitAmountActuallySpent;
}
else
{
budgetLimit.LimitAmountApproved = 0;
budgetLimit.FundsExpendedAmount = 0;
}
}
catch (Exception ex) { }
_budgetLimitService.Update(budgetLimit);
return(RedirectToAction("Index"));
}
SetViewBag(budgetLimit);
return(View(budgetLimit));
}
private void SetViewBag(BudgetLimit limit)
{
var selectedYear = limit?.Year ?? DateTime.Today.Year;
var selectedMonth = limit?.Month ?? DateTime.Today.Month;
var projectID = limit?.ProjectID;
var costSubItemID = limit?.CostSubItemID;
var departmentID = limit?.DepartmentID;
ViewBag.Months = new SelectList(Enumerable.Range(1, 12).Select(x =>
new SelectListItem()
{
Text = CultureInfo.CurrentCulture.DateTimeFormat.GetMonthName(x) + " (" + x + ")",
Value = x.ToString(),
}), "Value", "Text", selectedMonth);
ViewBag.Years = new SelectList(Enumerable.Range(DateTime.Today.Year - 10, 20).Select(x =>
new SelectListItem()
{
Text = x.ToString(),
Value = x.ToString(),
}), "Value", "Text", selectedYear);
ViewBag.ProjectID = new SelectList(_projectService.Get(x => x.ToList().OrderBy(p => p.ShortName).ToList()), "ID", "ShortName", projectID);
ViewBag.CostSubItemID = new SelectList(_costSubItemService.Get(x => x.ToList().OrderBy(csi => csi.ShortName).ToList()), "ID", "FullName", costSubItemID);
ViewBag.DepartmentID = new SelectList(_departmentService.Get(x => x.Where(d => d.IsFinancialCentre).OrderBy(d => d.ShortName).ToList()), "ID", "FullName", departmentID);
}
public ActionResult DeleteConfirmed(int id)
{
BudgetLimit budgetLimit = db.BudgetLimits.Find(id);
db.BudgetLimits.Remove(budgetLimit);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "BudgetLimitID,FoodLimit,ClothesLimit,AlcoholLimit,OtherLimit")] BudgetLimit budgetLimit)
{
if (ModelState.IsValid)
{
db.Entry(budgetLimit).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(budgetLimit));
}
public ActionResult Edit(BudgetLimit budgetlimit)
{
if (ModelState.IsValid)
{
db.Entry(budgetlimit).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(budgetlimit));
}
//
// GET: /BudgetLimit/Edit/5
public ActionResult Edit(int id = 0)
{
BudgetLimit budgetlimit = db.BudgetLimits.Find(id);
if (budgetlimit == null)
{
return(HttpNotFound());
}
return(View(budgetlimit));
}
public ActionResult Create([Bind(Include = "BudgetLimitID,FoodLimit,ClothesLimit,AlcoholLimit,OtherLimit")] BudgetLimit budgetLimit)
{
if (ModelState.IsValid)
{
db.BudgetLimits.Add(budgetLimit);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(budgetLimit));
}
public ActionResult Create(BudgetLimit budgetlimit)
{
if (ModelState.IsValid)
{
db.BudgetLimits.Add(budgetlimit);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(budgetlimit));
}
public ActionResult Edit([Bind(Include = "Id,BudgetCategoryId,Amount,Month")] BudgetLimit budgetLimit)
{
if (ModelState.IsValid)
{
db.Entry(budgetLimit).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.BudgetCategoryId = new SelectList(db.BudgetCategories, "Id", "Name", budgetLimit.BudgetCategoryId);
return(View(budgetLimit));
}
// GET: BudgetLimits/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
BudgetLimit budgetLimit = db.BudgetLimits.Find(id);
if (budgetLimit == null)
{
return(HttpNotFound());
}
return(View(budgetLimit));
}
public ActionResult Delete(int?id)
{
if (id == null)
{
return(StatusCode(StatusCodes.Status400BadRequest));
}
BudgetLimit budgetLimit = _budgetLimitService.GetById(id.Value);
if (budgetLimit == null)
{
return(StatusCode(StatusCodes.Status404NotFound));
}
return(View(budgetLimit));
}
// GET: BudgetLimits/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
BudgetLimit budgetLimit = db.BudgetLimits.Find(id);
if (budgetLimit == null)
{
return(HttpNotFound());
}
ViewBag.BudgetCategoryId = new SelectList(db.BudgetCategories, "Id", "Name", budgetLimit.BudgetCategoryId);
return(View(budgetLimit));
}
public ActionResult Edit(int?id)
{
if (id == null)
{
return(StatusCode(StatusCodes.Status400BadRequest));
}
BudgetLimit budgetLimit = _budgetLimitService.GetById(id.Value);
if (budgetLimit == null)
{
return(StatusCode(StatusCodes.Status404NotFound));
}
if (budgetLimit.IsVersion)
{
return(StatusCode(StatusCodes.Status403Forbidden));
}
SetViewBag(budgetLimit);
return(View(budgetLimit));
}
