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