public JsonResult Create(UnloadCylinder obj)
{
bool status = true;
string vMessage = "";
try
{
if (ModelState.IsValid)
{
if (obj.UnloadDetail != null)
{
//foreach (var item in obj.UnloadDetail)
//{
var deliverycount = (
from delivery in db.DeliveryDetails
where delivery.userid == obj.user_id && delivery.C_deliveryDate == obj.UnloadDate &&
delivery.unload_Flag == false
select delivery
).ToList();
if (deliverycount == null || deliverycount.Count <= 0)
{
status = false;
vMessage = "No Delivery found " + "on" + Models.CommonFunction.GetShortDayFormat(obj.UnloadDate);
}
else
{
foreach (var item in obj.UnloadDetail)
{
var deliverlist = deliverycount.Where(ite => ite.cylinder_Id == item.cylinder_Id).ToList();
var existingemptycount = deliverlist.Sum(ite => ite.emptyCylinder).HasValue ? deliverlist.Sum(ite => ite.emptyCylinder).Value : 0;
if (item.EmptyCylinder != existingemptycount)
{
status = false;
vMessage = "Empty Cylinder counts are not matching with delivery details";
break;
}
var existingreplacecount = deliverlist.Sum(ite => ite.emptyCylinder).HasValue ? deliverlist.Sum(ite => ite.emptyCylinder).Value : 0;
if (item.RejectedCylinder != existingreplacecount)
{
status = false;
vMessage = "Replacement Cylinder counts are not matching with delivery details";
break;
}
}
}
//var fiiledcount = (
// from load in db.LoadCylinders
// join loaddetail in db.LoadDetails on load.ID equals loaddetail.load_Id
// where load.user_id == obj.user_id && load.loadDate == obj.UnloadDate
// && loaddetail.cylinder_Id == item.cylinder_Id
// select loaddetail
// ).FirstOrDefault();
//if (fiiledcount != null)
//{
//var cylindercount = (from del in db.DeliveryDetails
// where del.C_deliveryDate == obj.UnloadDate
// // && del.userid == obj.user_id
// && del.cylinder_Id == item.cylinder_Id
// select del).FirstOrDefault();
//if (cylindercount.emptyCylinder != item.EmptyCylinder)
//{
// status = false;
// vMessage = "User not delivered any cylinder for" + item.cylinderType + "on" + Models.CommonFunction.GetShortDayFormat(obj.UnloadDate);
// break;
//}
//}
//else
//{
// status = false;
// vMessage = "No Cylinder available for unload for cylinder" + item.cylinderType + "for" + Models.CommonFunction.GetShortDayFormat(obj.UnloadDate);
// break;
//}
// }
}
if (status)
{
obj.createdBy = Convert.ToString(Session["UserName"]);
obj.createdOn = System.DateTime.Now;
obj.users = repo.GetAllUsers();
if (obj.UnloadDetail != null)
{
repo.Insert(obj);
vMessage = "Record Added Successfully";
var UnloadCylinderList = repo.GetAllUnloadCylinders();
status = true;
}
}
}
else
{
status = false;
}
}
catch (Exception ex)
{
vMessage = "Sorry Some Problem Occured";
}
return(new JsonResult {
Data = new { status = status, Message = vMessage }
});
}
public JsonResult Edit(UnloadCylinder obj)
{
bool status = false;
string vMessage = "";
try
{
if (ModelState.IsValid)
{
if (obj.UnloadDetail != null)
{
foreach (var item in obj.UnloadDetail)
{
//var fiiledcount = (
// from load in db.LoadCylinders
// join loaddetail in db.LoadDetails on load.ID equals loaddetail.load_Id
// where load.user_id == obj.user_id && load.loadDate == obj.UnloadDate
// && loaddetail.cylinder_Id == item.cylinder_Id
// select loaddetail
// ).FirstOrDefault();
//if (fiiledcount == null)
//{
// status = false;
// vMessage = "No Cylinder available for unload for cylinder" + item.cylinderType + "for" + Models.CommonFunction.GetShortDayFormat(obj.UnloadDate);
// break;
//}
//else
{
var cylindercount = (from del in db.DeliveryDetails
where del.C_deliveryDate == obj.UnloadDate
// && del.userid == obj.user_id
&& del.cylinder_Id == item.cylinder_Id
select del).FirstOrDefault();
if (cylindercount.emptyCylinder != item.EmptyCylinder)
{
status = false;
vMessage = "User not delivered any cylinder for" + item.cylinderType + "on" + Models.CommonFunction.GetShortDayFormat(obj.UnloadDate);
break;
}
}
}
}
if (status)
{
obj.users = repo.GetAllUsers();
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 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 " + String.Format("{0:d MMM yyyy}", Convert.ToDateTime(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.replacementCylinder).HasValue ? deliverlist.Sum(ite => ite.replacementCylinder).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
}
});
}
