public JsonResult Create(acc_transactions acc_transactions)
{
var CompanyId = Convert.ToInt32(Session["CompanyID"]);
using (var transaction = db.Database.BeginTransaction())
{
try
{
var year_id = Convert.ToInt32(Session["FinancialYearID"]);
var creaded_by = User.Identity.GetUserId <int>();
DateTime dtDate = DateTime.Now;
acc_transactions.FinancialYear_Id = year_id;
acc_transactions.Company_Id = CompanyId;
db.acc_transactions.Add(acc_transactions);
db.SaveChanges();
int scope_id = acc_transactions.id;
transaction.Commit();
return(Json(Convert.ToString(scope_id)));
}
catch (Exception e)
{
transaction.Rollback();
ViewBag.FinancialYear_Id = new SelectList(db.FinancialYears, "Id", "Name");
ViewBag.voucher_type = new SelectList(db.VoucherTypes, "Id", "VoucherName");
ViewBag.acc_ledger_id = new SelectList(db.acc_ledger.Where(x => x.Company_Id == CompanyId), "Id", "name");
}
}
return(Json("0"));
}
// POST: /Journal/Delete/5
public ActionResult DeleteConfirmed(int id)
{
acc_transactions acc_transactions = db.acc_transactions.Find(id);
if (acc_transactions == null)
{
return(HttpNotFound());
}
db.acc_transactions.Remove(acc_transactions);
db.SaveChanges();
return(RedirectToAction("Index"));
}
// GET: /Journal/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
acc_transactions acc_transactions = db.acc_transactions.Find(id);
if (acc_transactions == null)
{
return(HttpNotFound());
}
return(View(acc_transactions));
}
public JsonResult Edit(acc_transactions acc_transactions)
{
var CompanyId = Convert.ToInt32(Session["CompanyID"]);
using (var transaction = db.Database.BeginTransaction())
{
try
{
var year_id = Convert.ToInt32(Session["FinancialYearID"]);
var creaded_by = User.Identity.GetUserId <int>();
DateTime dtDate = DateTime.Now;
acc_transactions.FinancialYear_Id = year_id;
acc_transactions.Company_Id = CompanyId;
foreach (var objdtl in acc_transactions.acc_transactions_details)
{
if (objdtl.id == 0)
{
db.Entry(objdtl).State = EntityState.Added;
db.SaveChanges();
}
else
{
db.Entry(objdtl).State = EntityState.Modified;
}
}
while (acc_transactions.acc_transactions_details.Where(x => x.id == 0).Count() > 0)
{
acc_transactions.acc_transactions_details.Remove(acc_transactions.acc_transactions_details.Where(x => x.id == 0).ToList()[0]);
}
db.Entry(acc_transactions).State = EntityState.Modified;
db.SaveChanges();
transaction.Commit();
return(Json(Convert.ToString(acc_transactions.id)));
}
catch (Exception e)
{
transaction.Rollback();
ViewBag.FinancialYear_Id = new SelectList(db.FinancialYears, "Id", "Name");
ViewBag.voucher_type = new SelectList(db.VoucherTypes, "Id", "VoucherName");
ViewBag.acc_ledger_id = new SelectList(db.acc_ledger.Where(x => x.Company_Id == CompanyId), "Id", "name");
}
}
return(Json("0"));
}
// GET: /Journal/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var CompanyId = Convert.ToInt32(Session["CompanyID"]);
acc_transactions acc_transactions = db.acc_transactions.Where(x => x.Company_Id == CompanyId && x.id == id).FirstOrDefault();
if (acc_transactions == null)
{
return(HttpNotFound());
}
return(View(acc_transactions));
}
// GET: /Journal/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var CompanyId = Convert.ToInt32(Session["CompanyID"]);
acc_transactions acc_transactions = db.acc_transactions.Where(x => x.Company_Id == CompanyId && x.id == id).FirstOrDefault();
if (acc_transactions == null)
{
return(HttpNotFound());
}
ViewBag.Company_Id = new SelectList(db.Companies, "Id", "Name");
ViewBag.FinancialYear_Id = new SelectList(db.FinancialYears, "Id", "Name");
ViewBag.voucher_type = new SelectList(db.VoucherTypes, "Id", "VoucherName");
ViewBag.voucherDate = acc_transactions.voucher_date;
ViewBag.acc_ledger_id = new SelectList(db.acc_ledger.Where(x => x.Company_Id == CompanyId), "Id", "name");
return(View(acc_transactions));
}
