public JsonResult CreateDetailsJson(List <CuttingSheetDetail> Details)
{
string errors11 = "";
int test = 0;
CuttingSheetDetail Detail = new CuttingSheetDetail();
foreach (CuttingSheetDetail d in Details)
{
try
{
Detail = new CuttingSheetDetail();
Detail.CuttingSheetId = int.Parse(d.CuttingSheetId.ToString());
Detail.MaterialId = int.Parse(d.MaterialId.ToString());
Detail.qty = float.Parse(d.qty.ToString());
//get material
Material material = materialRepository.GetById(Detail.MaterialId);
//check availability of item in warehouse
float AvailableQty = materialRepository.AvailableQty(material);
if (AvailableQty > Detail.qty)
{
Detail.status = statusList.InStock;
}
else
{
Detail.status = statusList.Purchase;
}
Detail.IssueQty = 0;
db.CuttingSheetDetails.Add(Detail);
db.SaveChanges();
//reserve qty in warehouse
materialRepository.ReserveQty(material, Detail.qty);
db.SaveChanges();
}
catch (Exception ex)
{
DeleteConfirmed(Detail.CuttingSheetId);
test = 1;
errors11 = errors11 + ex.Message;
if (ex.InnerException != null)
{
if (ex.InnerException.InnerException != null)
{
errors11 = errors11 + ex.InnerException.InnerException.Message;
}
}
return(Json(errors11));
}
}
if (test == 1)
{
return(Json(errors11));
}
return(Json("Cutting Sheet Saved Successfully"));
}
public JsonResult CreateDetailsJson(List <CuttingSheetDetail> Details)
{
string errors11 = "";
int aaa = 0;
int test = 0;
int eid = 0;
CuttingSheetDetail EP = new CuttingSheetDetail();
foreach (var d in Details)
{
CuttingSheetDetail csd = db.CuttingSheetDetails.Find(d.CuttingSheetDetailId);
csd.qtyApproved = d.qtyApproved;
csd.Remark = d.Remark;
csd.Approval = false;
db.SaveChanges();
}
return(Json("Cutting Sheet Saved Successfully"));
}
public JsonResult EditDetailsJson(List <CuttingSheetDetail> Details, int id)
{
string errors11 = "";
int aaa = 0;
int test = 0;
int eid = 0;
//delete exist
var cs = db.CuttingSheets.Find(id);
List <CuttingSheetDetail> OldDetails = cs.CuttingSheetDetails.ToList();
foreach (CuttingSheetDetail d in OldDetails)
{
db.CuttingSheetDetails.Remove(d);
}
db.SaveChanges();
CuttingSheetDetail EP = new CuttingSheetDetail();
foreach (CuttingSheetDetail d in Details)
{
try
{
EP = new CuttingSheetDetail();
EP.CuttingSheetId = int.Parse(d.CuttingSheetId.ToString());
eid = int.Parse(d.CuttingSheetId.ToString());
EP.MaterialId = int.Parse(d.MaterialId.ToString());
Material mm = db.Materials.Find(EP.MaterialId);
EP.qty = float.Parse(d.qty.ToString());
float?AvailableQty = mm.qty - mm.Resevedqty - mm.MinReOrder;
if (AvailableQty > EP.qty)
{
EP.status = statusList.InStock;
}
else
{
EP.status = statusList.Purchase;
}
db.CuttingSheetDetails.Add(EP);
db.SaveChanges();
var StockIssue = db.StockIssues.Find(eid);
mm.Resevedqty = mm.Resevedqty + EP.qty;
db.SaveChanges();
}
catch (Exception ex)
{
DeleteConfirmed(eid);
test = 1;
errors11 = errors11 + ex.Message;
if (ex.InnerException != null)
{
if (ex.InnerException.InnerException != null)
{
errors11 = errors11 + ex.InnerException.InnerException.Message;
}
}
return(Json(errors11));
}
}
if (test == 1)
{
return(Json(errors11));
}
return(Json("Cutting Sheet Saved Successfully"));
}
public JsonResult EditDetailsJson(List <CuttingSheetDetail> Details, int id)
{
string errors11 = "";
int test = 0;
//delete exist
var cs = db.CuttingSheets.Find(id);
List <CuttingSheetDetail> OldDetails = cs.CuttingSheetDetails.ToList();
foreach (CuttingSheetDetail d in OldDetails)
{
db.CuttingSheetDetails.Remove(d);
Material material = materialRepository.GetById(d.MaterialId);
materialRepository.ReleaseReserveQty(material, d.qty);
}
db.SaveChanges();
CuttingSheetDetail detail = new CuttingSheetDetail();
foreach (CuttingSheetDetail d in Details)
{
try
{
detail = new CuttingSheetDetail();
detail.CuttingSheetId = int.Parse(d.CuttingSheetId.ToString());
detail.MaterialId = int.Parse(d.MaterialId.ToString());
detail.qty = float.Parse(d.qty.ToString());
Material mm = db.Materials.Find(detail.MaterialId);
//EP.qty = float.Parse(d.qty.ToString());
Material material = materialRepository.GetById(detail.MaterialId);
float? AvailableQty = materialRepository.AvailableQty(material);
if (AvailableQty > detail.qty)
{
detail.status = statusList.InStock;
}
else
{
detail.status = statusList.Purchase;
}
db.CuttingSheetDetails.Add(detail);
db.SaveChanges();
materialRepository.ReserveQty(material, detail.qty);
materialRepository.Save();
}
catch (Exception ex)
{
DeleteConfirmed(detail.CuttingSheetId);
test = 1;
errors11 = errors11 + ex.Message;
if (ex.InnerException != null)
{
if (ex.InnerException.InnerException != null)
{
errors11 = errors11 + ex.InnerException.InnerException.Message;
}
}
return(Json(errors11));
}
}
if (test == 1)
{
return(Json(errors11));
}
return(Json("Cutting Sheet Saved Successfully"));
}
