public JsonResult Edit(TailorChalan tailorChalan)
{
var 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;
tailorChalan.Updated = dtDate;
tailorChalan.created_by = creaded_by;
tailorChalan.financial_year = year_id;
tailorChalan.CompanyId = CompanyId;
foreach (var objTailorDetails in tailorChalan.TailorChalanDetails)
{
if (objTailorDetails.Id == 0)
{
db.Entry(objTailorDetails).State = EntityState.Added;
db.SaveChanges();
}
}
foreach (var objTailorDetails in tailorChalan.TailorChalanDetails)
{
foreach (var objMat in objTailorDetails.TailorMaterialDetails)
{
objMat.TailorChalanDetailsId = objTailorDetails.Id;
if (objMat.Id == 0)
{
db.Entry(objMat).State = EntityState.Added;
db.SaveChanges();
}
}
}
while (tailorChalan.TailorChalanDetails.Where(x => x.Id == 0).Count() > 0)
{
tailorChalan.TailorChalanDetails.Remove(tailorChalan.TailorChalanDetails.Where(x => x.Id == 0).ToList()[0]);
}
db.Entry(tailorChalan).State = EntityState.Modified;
db.SaveChanges();
transaction.Commit();
return(Json(Convert.ToString(tailorChalan.Id)));
}
catch
{
transaction.Rollback();
ViewBag.VendorId = new SelectList(db.Vendors.Where(x => x.VendorTypeId == 3 && x.CompanyId == CompanyId), "Id", "VendorName", tailorChalan.VendorId);
ViewBag.ProductId = new SelectList(db.Products.Where(x => x.ProductTypeId == 2 && x.IsActive == true && x.CompanyId == CompanyId), "Id", "ProductName");
}
}
return(Json("0"));
}
// GET: TailorChalan/Delete/5
public ActionResult Delete(int? id)
{
if (id == null)
{
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
}
var CompanyId = Convert.ToInt32(Session["CompanyID"]);
TailorChalan tailorChalan = db.TailorChalans.Where(x => x.Company_Id == CompanyId && x.Id == id).FirstOrDefault();
db.TailorChalans.Remove(tailorChalan);
db.SaveChanges();
return RedirectToAction("Index");
}
// GET: TailorChalan/Details/5
public ActionResult Details(int? id)
{
if (id == null)
{
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
}
var CompanyId = Convert.ToInt32(Session["CompanyID"]);
TailorChalan tailorChalan = db.TailorChalans.Where(x => x.Company_Id == CompanyId && x.Id == id).FirstOrDefault();
if (tailorChalan == null)
{
return HttpNotFound();
}
return View(tailorChalan);
}
// GET: TailorChalan/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var CompanyId = Convert.ToInt32(Session["CompanyID"]);
TailorChalan tailorChalan = db.TailorChalans.Where(x => x.CompanyId == CompanyId && x.Id == id).FirstOrDefault();
if (tailorChalan == null)
{
return(HttpNotFound());
}
ViewBag.ProductId = new SelectList(db.Products.Where(x => x.IsActive == true && x.CompanyId == CompanyId), "Id", "ProductName");
ViewBag.VendorId = new SelectList(db.Vendors.Where(x => x.VendorTypeId == 3 && x.CompanyId == CompanyId), "Id", "VendorName");
return(View(tailorChalan));
}
public JsonResult Create(TailorChalan tailorChalan)
{
var 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;
tailorChalan.Created = dtDate;
tailorChalan.Updated = dtDate;
tailorChalan.created_by = creaded_by;
tailorChalan.financial_year = year_id;
tailorChalan.CompanyId = CompanyId;
db.TailorChalans.Add(tailorChalan);
db.SaveChanges();
int scope_id = tailorChalan.Id;
transaction.Commit();
return(Json(Convert.ToString(scope_id)));
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
foreach (var ve in eve.ValidationErrors)
{
}
}
transaction.Rollback();
ViewBag.VendorId = new SelectList(db.Vendors.Where(x => x.VendorTypeId == 3 && x.CompanyId == CompanyId), "Id", "VendorName", tailorChalan.VendorId);
ViewBag.ProductId = new SelectList(db.Products.Where(x => x.ProductTypeId == 1 && x.IsActive == true && x.CompanyId == CompanyId), "Id", "ProductName");
}
}
return(Json("0"));
}
