public JsonResult Create(PrintJobWorkReceived printerChalan) { int companyId = Convert.ToInt32(Session["CompanyID"]); using (var transaction = db.Database.BeginTransaction()) { try { var year_id = Convert.ToInt32(Session["FinancialYearID"]); var creaded_by = Convert.ToInt32(Session["UserID"]); DateTime dtDate = DateTime.Now; printerChalan.Created = dtDate; printerChalan.Updated = dtDate; printerChalan.created_by = creaded_by; printerChalan.financial_year = year_id; printerChalan.CompanyId = companyId; db.PrintJobWorkReceiveds.Add(printerChalan); db.SaveChanges(); int scope_id = printerChalan.Id; transaction.Commit(); return(Json(Convert.ToString(scope_id))); } catch { transaction.Rollback(); ViewBag.VendorId = new SelectList(db.Vendors.Where(x => x.VendorTypeId == 2 && x.CompanyId == companyId), "Id", "VendorName", printerChalan.VendorId); ViewBag.ProductId = new SelectList(db.Products.Where(x => x.ProductTypeId == 1 && x.IsActive == true && x.CompanyId == companyId), "Id", "ProductName"); } } return(Json("0")); }
// GET: PrinterChalans/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } int companyId = Convert.ToInt32(Session["CompanyID"]); PrintJobWorkReceived printerChalan = db.PrintJobWorkReceiveds.Where(x => x.CompanyId == companyId && x.Id == id).FirstOrDefault(); db.PrintJobWorkReceiveds.Remove(printerChalan); db.SaveChanges(); return(RedirectToAction("Index")); }
// GET: PrinterChalans/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } int companyId = Convert.ToInt32(Session["CompanyID"]); PrintJobWorkReceived printerChalan = db.PrintJobWorkReceiveds.Where(x => x.CompanyId == companyId && x.Id == id).FirstOrDefault(); if (printerChalan == null) { return(HttpNotFound()); } return(View(printerChalan)); }
public JsonResult Edit(PrintJobWorkReceived printerChalan) { int companyId = Convert.ToInt32(Session["CompanyID"]); using (var transaction = db.Database.BeginTransaction()) { try { foreach (var objPurchaseDetails in printerChalan.PrintJobWorkReceivedDetails) { if (objPurchaseDetails.Id == 0) { db.Entry(objPurchaseDetails).State = EntityState.Added; db.SaveChanges(); } else { db.Entry(objPurchaseDetails).State = EntityState.Modified; } } while (printerChalan.PrintJobWorkReceivedDetails.Where(x => x.Id == 0).Count() > 0) { printerChalan.PrintJobWorkReceivedDetails.Remove(printerChalan.PrintJobWorkReceivedDetails.Where(x => x.Id == 0).ToList()[0]); } DateTime dtDate = DateTime.Now; printerChalan.Updated = dtDate; db.Entry(printerChalan).State = EntityState.Modified; db.SaveChanges(); transaction.Commit(); return(Json(Convert.ToString(printerChalan.Id))); } catch { transaction.Rollback(); ViewBag.vendor_id = new SelectList(db.Vendors.Where(x => x.VendorTypeId == 2 && x.Company_Id == companyId), "Id", "VendorName", printerChalan.vendor_id); ViewBag.ProductId = new SelectList(db.Products.Where(x => x.ProductTypeId == 1 && x.IsActive == true && x.Company_Id == companyId), "Id", "ProductName"); } } return(Json("0")); }
// GET: PrinterChalans/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } int companyId = Convert.ToInt32(Session["CompanyID"]); PrintJobWorkReceived printerChalan = db.PrintJobWorkReceiveds.Where(x => x.CompanyId == companyId && x.Id == id).FirstOrDefault(); if (printerChalan == null) { return(HttpNotFound()); } ViewBag.ProductId = new SelectList(db.Products.Where(x => x.ProductTypeId == 1 && x.IsActive == true && x.CompanyId == companyId), "Id", "ProductName", printerChalan.VendorId); ViewBag.VendorId = new SelectList(db.Vendors.Where(x => x.VendorTypeId == 2 && x.CompanyId == companyId), "Id", "VendorName", printerChalan.VendorId); var year_id = Session["FinancialYearID"]; var year = db.FinancialYears.Find(year_id); ViewBag.StartYear = year.StartDate.ToString("dd-MMM-yyyy"); ViewBag.EndYear = year.EndDate.ToString("dd-MMM-yyyy"); return(View(printerChalan)); }