public JsonResult SaveUnLoadCylinderDetails(int userid, DateTime unloadDate, int cylindertype, int nooffilledcylinder, int noofemptycylinder, int noofrejectedcylinder, string remark) { string vErroMessage = ""; bool status = false; try { UnloadCylinder obj = new UnloadCylinder(); obj.createdBy = User.Identity.Name; obj.createdOn = System.DateTime.Now; obj.user_id = userid; string vUsername = db.tblusers.Where(obj1 => (obj1.ID == userid)).SingleOrDefault().username; obj.UnloadDate = unloadDate; obj.userName = vUsername; List <UnloadDetail> objdlist = new List <UnloadDetail>(); UnloadDetail objd = new UnloadDetail(); objd.FilledCylinder = nooffilledcylinder; objd.EmptyCylinder = noofemptycylinder; objd.RejectedCylinder = noofrejectedcylinder; objd.cylinder_Id = cylindertype; string cylindertypename = db.CylinderMasters.Where(ite => ite.ID == cylindertype).FirstOrDefault().cylinderType; objd.cylinderType = cylindertypename; objdlist.Add(objd); vErroMessage = "Record Added Successfully"; status = true; } catch (Exception ex) { vErroMessage = "Error Occured while your transaction!"; status = false; } return(new JsonResult() { Data = new { status = status, Message = vErroMessage } }); }
public JsonResult SaveUnLoadCylinderDetails(int userid, DateTime unloadDate, int cylindertype, int nooffilledcylinder, int noofemptycylinder, int noofrejectedcylinder, string remark) { string vErroMessage = ""; bool status = true; try { var deliverycount = ( from delivery in db.DeliveryDetails where delivery.userid == userid && delivery.C_deliveryDate == unloadDate && delivery.unload_Flag == false select delivery ).ToList(); if (deliverycount == null || deliverycount.Count <= 0) { status = false; vErroMessage = "No Delivery found " + "on" + unloadDate; } else { // foreach (var item in obj.UnloadDetail) // { var deliverlist = deliverycount.Where(ite => ite.cylinder_Id == cylindertype).ToList(); var existingemptycount = deliverlist.Sum(ite => ite.emptyCylinder).HasValue ? deliverlist.Sum(ite => ite.emptyCylinder).Value : 0; if (noofemptycylinder != existingemptycount) { status = false; vErroMessage = "Empty Cylinder counts are not matching with delivery details"; } var existingreplacecount = deliverlist.Sum(ite => ite.emptyCylinder).HasValue ? deliverlist.Sum(ite => ite.emptyCylinder).Value : 0; if (noofrejectedcylinder != existingreplacecount) { status = false; vErroMessage = "Replacement Cylinder counts are not matching with delivery details"; } } if (status) { UnloadCylinder obj = new UnloadCylinder(); obj.createdBy = User.Identity.Name; obj.createdOn = System.DateTime.Now; obj.user_id = userid; string vUsername = db.tblusers.Where(obj1 => (obj1.ID == userid)).SingleOrDefault().username; obj.UnloadDate = unloadDate; obj.userName = vUsername; List <UnloadDetail> objdlist = new List <UnloadDetail>(); UnloadDetail objd = new UnloadDetail(); objd.FilledCylinder = nooffilledcylinder; objd.EmptyCylinder = noofemptycylinder; objd.RejectedCylinder = noofrejectedcylinder; objd.cylinder_Id = cylindertype; string cylindertypename = db.CylinderMasters.Where(ite => ite.ID == cylindertype).FirstOrDefault().cylinderType; objd.cylinderType = cylindertypename; objdlist.Add(objd); obj.UnloadDetail = objdlist; unrepo.Insert(obj); vErroMessage = "Record Added Successfully"; status = true; } } catch (Exception ex) { vErroMessage = "Error Occured while your transaction!"; status = false; } return(new JsonResult() { Data = new { status = status, Message = vErroMessage } }); }