public ActionResult ABEdit([Bind(Include = "AccountsBalanceId,Date,Balance,Note,AccountId")] AccountsBalance accountsBalance)
{
if (ModelState.IsValid)
{
try
{
//Получаем идентификатор текущего пользователя
using (ApplicationDbContext aspdb = new ApplicationDbContext())
{
var user = System.Web.HttpContext.Current.User.Identity.GetUserId();
accountsBalance.UserId = user;
}
db.Database.Log = (s => System.Diagnostics.Debug.WriteLine(s)); //===================Debug===============
db.Entry(accountsBalance).State = EntityState.Modified;
db.SaveChanges();
TempData["MessageOK"] = "Информация обновлена";
return(RedirectToAction("ABShow"));
}
catch (Exception ex)
{
ViewBag.ErMes = ex.Message;
ViewBag.ErStack = ex.StackTrace;
ViewBag.ErInner = ex.InnerException.InnerException.Message;
return(View("Error"));
}
}
TempData["MessageError"] = "Ошибка валидации модели";
accountsBalance.AccountNumber = db.Accounts.FirstOrDefault(x => x.AccountId == accountsBalance.AccountId).AccountNumber.ToString();
return(View(accountsBalance));
}
public ActionResult ABCreate([Bind(Include = "AccountsBalanceId,Date,Balance,Note,AccountId")] AccountsBalance accountsBalance)
{
if (ModelState.IsValid)
{
try
{
//Получаем идентификатор текущего пользователя
using (ApplicationDbContext aspdb = new ApplicationDbContext())
{
var user = System.Web.HttpContext.Current.User.Identity.GetUserId();
accountsBalance.UserId = user;
}
db.AccountsBalances.Add(accountsBalance);
db.SaveChanges();
TempData["MessageOK"] = "Информация добавлена";
return(RedirectToAction("ABShow"));
}
catch (Exception ex)
{
ViewBag.ErMes = ex.Message;
ViewBag.ErStack = ex.StackTrace;
ViewBag.ErInner = ex.InnerException.InnerException.Message;
return(View("Error"));
}
}
return(View(accountsBalance));
}
public ActionResult ABDelete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
AccountsBalance accountsBalance = db.AccountsBalances.Find(id);
if (accountsBalance == null)
{
return(HttpNotFound());
}
return(View(accountsBalance));
}
public ActionResult ABEdit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
AccountsBalance accountsBalance = db.AccountsBalances.Find(id);
if (accountsBalance == null)
{
return(HttpNotFound());
}
accountsBalance.AccountNumber = db.Accounts.FirstOrDefault(x => x.AccountId == accountsBalance.AccountId).AccountNumber.ToString();
return(View(accountsBalance));
}
public ActionResult ABCreate(int?AccountId)
{
if (AccountId == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
string _accNum = db.Accounts.FirstOrDefault(x => x.AccountId == AccountId).AccountNumber.ToString();
DateTime _date = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
AccountsBalance _acb = new AccountsBalance();
_acb.AccountNumber = _accNum;
_acb.Date = _date;
return(View(_acb));
}
public ActionResult DeleteConfirmed(int id)
{
try
{
AccountsBalance _acb = db.AccountsBalances.FirstOrDefault(x => x.AccountsBalanceId == id);
if (_acb == null)
{
TempData["MessageError"] = "Удаляемый объект отсутствует в базе данных";
return(RedirectToAction("ABShow"));
}
db.AccountsBalances.Remove(_acb);
db.SaveChanges();
TempData["MessageOK"] = "Информация удалена";
return(RedirectToAction("ABShow"));
}
catch (Exception ex)
{
ViewBag.ErMes = ex.Message;
ViewBag.ErStack = ex.StackTrace;
ViewBag.ErInner = ex.InnerException.InnerException.Message;
return(View("Error"));
}
}
public JsonResult SaveBatch(DateTime?Date, String dataJSON)
{
if (Date == null || String.IsNullOrEmpty(dataJSON))
{
return(Json(new { Result = false, Message = "Ошибка валидации модели!" }, JsonRequestBehavior.AllowGet));
}
if (db.AccountsBalances.Where(x => x.Date == Date).Count() > 0)
{
return(Json(new { Result = false, Message = "В базе данных присутствует информация по остаткам на счетах на указанную дату!" }, JsonRequestBehavior.AllowGet));
}
try
{
string _user = String.Empty;
//Получаем идентификатор текущего пользователя
using (ApplicationDbContext aspdb = new ApplicationDbContext())
{
_user = System.Web.HttpContext.Current.User.Identity.GetUserId();
}
string _jsonObject = dataJSON.Replace(@"\", string.Empty);
var serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
IList <JSONBalances> jsonObject = serializer.Deserialize <IList <JSONBalances> >(_jsonObject);
List <AccountsBalance> _balancelist = new List <AccountsBalance>();
DateTime _date;
DateTime.TryParse(Date.ToString(), out _date);
foreach (var Balances in jsonObject)
{
decimal _balance;
Decimal.TryParse(Balances.Balance.ToString(), out _balance);
AccountsBalance _acb = new AccountsBalance
{
AccountId = Balances.AccountId,
Date = _date,
Balance = _balance,
Note = Balances.Note,
UserId = _user
};
_balancelist.Add(_acb);
}
db.AccountsBalances.AddRange(_balancelist);
db.SaveChanges();
return(Json(new { Result = true, Message = "Информация добавлена " }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
ViewBag.ErMes = ex.Message;
ViewBag.ErStack = ex.StackTrace;
ViewBag.ErInner = ex.InnerException.InnerException.Message;
return(Json(new { Result = false, Message = "Ошибка выполнения запроса! " + ex.Message + ex.StackTrace }, JsonRequestBehavior.AllowGet));
}
}
