public HttpResponseMessage SaveLot(object[] data)
{
CmnLot objCmnLot = JsonConvert.DeserializeObject <CmnLot>(data[0].ToString());
string result = "";
try
{
if (ModelState.IsValid && objCmnLot != null && objCmnLot.LotNo.ToString() != "")
{
result = objGRRService.SaveLot(objCmnLot);
}
else
{
result = "";
}
}
catch (Exception e)
{
e.ToString();
result = "";
}
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
public string SaveLot(CmnLot objCmnLot)
{
GenericFactory_EF_CmnCombo = new CmnCombo_EF();
string result = "";
using (ERP_Entities _ctxCmn = new ERP_Entities())
{
if (objCmnLot.LotID > 0)
{
//using (TransactionScope transaction = new TransactionScope())
//{
// try
// {
// Int64 mrrID = mrrMaster.MrrID;
// IEnumerable<InvMrrMaster> lstInvMrrMaster = (from qcm in _ctxCmn.InvMrrMasters.Where(m => m.MrrID == mrrID) select qcm).ToList();
// InvMrrMaster objInvMrrMaster = new InvMrrMaster();
// foreach (InvMrrMaster qcms in lstInvMrrMaster)
// {
// qcms.UpdateBy = mrrMaster.CreateBy;
// qcms.UpdateOn = DateTime.Now;
// qcms.UpdatePc = HostService.GetIP();
// qcms.ChallanNo = mrrMaster.ChallanNo;
// qcms.CHID = mrrMaster.CHID;
// qcms.CompanyID = mrrMaster.CompanyID;
// qcms.GrrID = mrrMaster.GrrID;
// qcms.CurrencyID = mrrMaster.CurrencyID;
// qcms.MrrDate = mrrMaster.MrrDate;
// qcms.DepartmentID = mrrMaster.DepartmentID;
// qcms.Description = mrrMaster.Description;
// qcms.IsDeleted = false;
// qcms.MrrNo = mrrMaster.MrrNo;
// qcms.MrrQcID = mrrMaster.MrrQcID;
// qcms.MrrTypeID = mrrMaster.MrrTypeID;
// qcms.PIID = mrrMaster.PIID;
// qcms.POID = mrrMaster.POID;
// qcms.PONo = mrrMaster.PONo;
// qcms.Remarks = mrrMaster.Remarks;
// qcms.ReqNo = mrrMaster.ReqNo;
// qcms.RequisitionID = mrrMaster.RequisitionID;
// //qcms.StatusBy = mrrMaster.StatusBy;
// //qcms.StatusDate = mrrMaster.StatusDate;
// //qcms.StatusID = mrrMaster.StatusID;
// objInvMrrMaster = qcms;
// }
// List<InvMrrDetail> lstInvMrrDetail = new List<InvMrrDetail>();
// foreach (InvMrrDetail qcdt in mrrDetails)
// {
// InvMrrDetail objInvMrrDetail = (from qcdetl in _ctxCmn.InvMrrDetails.Where(m => m.MrrDetailID == qcdt.MrrDetailID) select qcdetl).FirstOrDefault();
// //start for exist passed n reject qty
// // decimal? prePassedRejectQty = objInvMrrQcDetail.PassQty + objInvMrrQcDetail.RejectQty;
// //end for exist passed n reject qty
// objInvMrrDetail.Amount = qcdt.Amount;
// objInvMrrDetail.BatchID = qcdt.BatchID;
// objInvMrrDetail.IsDeleted = false;
// objInvMrrDetail.GradeID = qcdt.GradeID;
// objInvMrrDetail.UnitID = qcdt.UnitID;
// objInvMrrDetail.UpdateBy = mrrMaster.CreateBy;
// objInvMrrDetail.UpdateOn = DateTime.Now;
// objInvMrrDetail.UpdatePc = HostService.GetIP();
// objInvMrrDetail.ItemID = qcdt.ItemID;
// objInvMrrDetail.LotID = qcdt.LotID;
// objInvMrrDetail.Qty = qcdt.Qty;
// objInvMrrDetail.UnitPrice = qcdt.UnitPrice;
// lstInvMrrDetail.Add(objInvMrrDetail);
// //InvGrrDetail objInvGrrDetail = (from grrd in _ctxCmn.InvGrrDetails.Where(m => m.GrrID == qcMaster.GrrID && m.ItemID == qcdt.ItemID) select grrd).FirstOrDefault();
// //objInvGrrDetail.QcRemainingQty = (objInvGrrDetail.QcRemainingQty + prePassedRejectQty) - (qcdt.PassQty + qcdt.RejectQty);
// }
// _ctxCmn.SaveChanges();
// transaction.Complete();
// result = mrrMaster.MrrNo.ToString();
// }
// catch (Exception e)
// {
// e.ToString();
// result = "";
// }
//}
}
else
{
using (TransactionScope transaction = new TransactionScope())
{
try
{
//...........START new maxId........//
long NextId = Convert.ToInt64(GenericFactory_EF_CmnCombo.getMaxID("CmnLot"));
objCmnLot.LotID = NextId;
objCmnLot.CreateOn = DateTime.Now;
objCmnLot.CreatePc = HostService.GetIP();
objCmnLot.IsDeleted = false;
_ctxCmn.CmnLots.Add(objCmnLot);
//............Update MaxID.................//
GenericFactory_EF_CmnCombo.updateMaxID("CmnLot", Convert.ToInt64(NextId));
_ctxCmn.SaveChanges();
transaction.Complete();
result = NextId.ToString();
}
catch (Exception e)
{
result = "";
}
}
}
}
return(result);
}
