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); }