public JsonResult Edit(ReturnCylinder obj)
        {
            bool   status   = true;
            string vMessage = "";

            try
            {
                if (ModelState.IsValid)
                {
                    if (obj.ReturnDetail != null)
                    {
                        foreach (var item in obj.ReturnDetail)
                        {
                            if (db.LiveCylinderDetails.Where(ite => ite.cylinder_Id == item.cylinder_Id).FirstOrDefault().EmptyCylinderCount <= 0)
                            {
                                vMessage = "No Cylinder Available";
                                status   = false;
                                break;
                            }
                        }
                    }

                    if (status)
                    {
                        repo.Update(obj);
                        vMessage = "Record Updated Successfully";
                        status   = true;
                    }
                }
                else
                {
                    status = false;
                }
            }
            catch (Exception ex)
            {
                vMessage = "Sorry Some Problem Occured";
                status   = false;
            }

            return(new JsonResult {
                Data = new { status = status, Message = vMessage }
            });
        }
        public JsonResult Create(ReturnCylinder obj)
        {
            bool   status   = true;
            string vMessage = "";

            try
            {
                if (ModelState.IsValid)
                {
                    if (obj.ReturnDetail != null)
                    {
                        foreach (var item in obj.ReturnDetail)
                        {
                            if (db.LiveCylinderDetails.Where(ite => ite.cylinder_Id == item.cylinder_Id).FirstOrDefault().EmptyCylinderCount <= 0)
                            {
                                vMessage = "No Cylinder Available";
                                status   = false;
                                break;
                            }

                            var fiiledcount = db.LiveCylinderDetails.Where(ite => ite.cylinder_Id == item.cylinder_Id).FirstOrDefault();
                            if (fiiledcount.EmptyCylinderCount <= 0 && item.EmptyCylinder > 0)
                            {
                                status   = false;
                                vMessage = "No empty Cylinder Available for " + item.cylinderType;
                                break;
                            }
                            else if (fiiledcount.FilledCylinderCount <= 0 && item.FilledCylinder > 0)
                            {
                                status   = false;
                                vMessage = "No filled Cylinder Available for " + item.cylinderType;
                                break;
                            }
                            else if (fiiledcount.ReplacementCylinderCount <= 0 && item.RejectedCylinder > 0)
                            {
                                status   = false;
                                vMessage = "No rejected Cylinder Available for " + item.cylinderType;
                                break;
                            }
                            else if (fiiledcount.EmptyCylinderCount < item.EmptyCylinder && item.EmptyCylinder > 0)
                            {
                                status   = false;
                                vMessage = "Only " + fiiledcount.EmptyCylinderCount + " empty cylinder available for " + item.cylinderType;
                                break;
                            }
                            else if (fiiledcount.FilledCylinderCount < item.FilledCylinder && item.FilledCylinder > 0)
                            {
                                status   = false;
                                vMessage = "Only " + fiiledcount.FilledCylinderCount + " empty cylinder available for " + item.cylinderType;
                                break;
                            }
                        }
                    }
                    if (status)
                    {
                        if (obj.ReturnDetail != null)
                        {
                            repo.Insert(obj);
                        }
                        vMessage = "Record Added Successfully";
                        status   = true;
                    }
                }
                else
                {
                    status   = false;
                    vMessage = "Please fill mandatory fields";
                }
            }
            catch (Exception ex)
            {
                vMessage = "Sorry Some Problem Occured";
                status   = false;
            }

            return(new JsonResult {
                Data = new { status = status, Message = vMessage }
            });
        }