public ActionResult DeleteConfirmed(int id) { CommissionDistTempMas commissionDistTempMas = db.CommissionDistTempMas.Find(id); db.CommissionDistTempMas.Remove(commissionDistTempMas); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "Id,BuyerInfoId,ProdDepartmentId,CalcType,IsAuth,OpBy,OpOn,AuthBy,AuthOn")] CommissionDistTempMas commissionDistTempMas) { if (ModelState.IsValid) { db.Entry(commissionDistTempMas).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.BuyerInfoId = new SelectList(db.BuyerInfo, "Id", "Name", commissionDistTempMas.BuyerInfoId); ViewBag.ProdDepartmentId = new SelectList(db.ProdDepartment, "Id", "Name", commissionDistTempMas.ProdDepartmentId); return(View(commissionDistTempMas)); }
// GET: CommissionTemplate/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } CommissionDistTempMas commissionDistTempMas = db.CommissionDistTempMas.Find(id); if (commissionDistTempMas == null) { return(HttpNotFound()); } return(View(commissionDistTempMas)); }
public JsonResult SaveComm(IEnumerable <CommissionDistTempDet> CommDetails, CommissionDistTempMas CommMas) { var result = new { flag = false, message = "Error occured. !", Id = 0 }; try { var OpDate = DateTime.Now; using (var dbContextTransaction = db.Database.BeginTransaction()) { try { //var OrderM = new BuyerOrderMas() //{ // Id = 0, // OrderRefNo = OrderMas.OrderRefNo, // OrderDate = OrderMas.OrderDate, // BuyerInfoId = OrderMas.BuyerInfoId, // ProdDepartmentId = OrderMas.ProdDepartmentId, // SeasonInfoId = OrderMas.SeasonInfoId, // FabSupplierId = OrderMas.FabSupplierId, // OpBy = 1, // OpOn = OpDate, // IsAuth = true, // IsLocked = false //}; CommMas.OpBy = 1; CommMas.OpOn = OpDate; CommMas.IsAuth = true; db.CommissionDistTempMas.Add(CommMas); db.SaveChanges(); foreach (var item in CommDetails) { //var OrderD = new BuyerOrderDet() //{ // Id = 0, // BuyerOrderMasId = OrderM.Id, // ProdCatTypeId = item.ProdCatTypeId, // StyleNo = item.StyleNo, // ProdSizeId = item.ProdSizeId, // ProdColorId = item.ProdColorId, // FabricItemId = item.FabricItemId, // SupplierId = item.SupplierId, // UnitPrice = item.UnitPrice, // Quantity = item.Quantity, // IsLocked = false //}; item.CommissionDistTempMasId = CommMas.Id; db.CommissionDistTempDet.Add(item); db.SaveChanges(); } dbContextTransaction.Commit(); result = new { flag = true, message = "Saving successful !!", Id = CommMas.Id }; Success("Record saved successfully.", true); } catch (Exception ex) { dbContextTransaction.Rollback(); result = new { flag = false, message = ex.Message, Id = 0 }; } } } catch (Exception ex) { result = new { flag = false, message = ex.Message, Id = 0 }; } return(Json(result, JsonRequestBehavior.AllowGet)); }
public JsonResult UpdateComm(IEnumerable <CommissionDistTempDet> CommDetails, CommissionDistTempMas CommMas, int[] DelItems) { var result = new { flag = false, message = "Error occured. !" }; try { var OpDate = DateTime.Now; using (var dbContextTransaction = db.Database.BeginTransaction()) { try { var commM = db.CommissionDistTempMas.Find(CommMas.Id); if (commM == null) { result = new { flag = false, message = "Invalid Commission Id. Saving failed !" }; return(Json(result, JsonRequestBehavior.AllowGet)); } commM.CalcType = CommMas.CalcType; commM.OpBy = 1; commM.OpOn = OpDate; db.Entry(commM).State = EntityState.Modified; db.SaveChanges(); foreach (var item in CommDetails) { item.CommissionDistTempMasId = commM.Id; item.Remarks = item.Remarks == null ? "" : item.Remarks; //var OrderD = new BuyerOrderDet() //{ // Id = item.Id, // BuyerOrderMasId = OrderMas.Id, // ProdCatTypeId = item.ProdCatTypeId, // StyleNo = item.StyleNo, // ProdSizeId = item.ProdSizeId, // ProdColorId = item.ProdColorId, // FabricItemId = item.FabricItemId, // SupplierId = item.SupplierId, // UnitPrice = item.UnitPrice, // Quantity = item.Quantity, // IsLocked = false //}; db.Entry(item).State = item.Id == 0 ? EntityState.Added : EntityState.Modified; //db.BuyerOrderDets.Add(OrderD); db.SaveChanges(); } if (DelItems != null) { foreach (var item in DelItems) { var delcomm = db.CommissionDistTempDet.Find(item); db.CommissionDistTempDet.Remove(delcomm); db.SaveChanges(); } } dbContextTransaction.Commit(); result = new { flag = true, message = "Update successful !!" }; Success("Updated successfully.", true); } catch (Exception ex) { dbContextTransaction.Rollback(); result = new { flag = false, message = ex.Message }; } } } catch (Exception ex) { result = new { flag = false, message = ex.Message }; } return(Json(result, JsonRequestBehavior.AllowGet)); }