public HttpResponseMessage SaveFinishProPricSetup(object[] data) { string result = ""; try { prdFinishingProcessPriceSetup objPrdFinishingProcessPriceSetup = JsonConvert.DeserializeObject <prdFinishingProcessPriceSetup>(data[0].ToString()); int menuID = Convert.ToInt16(data[1]); if (ModelState.IsValid && objPrdFinishingProcessPriceSetup != null && objPrdFinishingProcessPriceSetup.FinishingProcessID.ToString() != "" && menuID != 0) { result = objFPR.SaveFinishProPricSetup(objPrdFinishingProcessPriceSetup, menuID); } else { result = ""; } } catch (Exception e) { e.ToString(); result = ""; } return(Request.CreateResponse(HttpStatusCode.OK, result)); }
public string SaveFinishProPricSetup(prdFinishingProcessPriceSetup objPrdFinishingProcessPriceSetup, int menuID) { GenericFactory_EF_CmnCombo = new CmnCombo_EF(); string result = ""; using (ERP_Entities _ctxCmn = new ERP_Entities()) { using (TransactionScope transactionScope = new TransactionScope()) { try { List <prdFinishingProcessPriceSetup> lstFroUpdate = (from lupdate in _ctxCmn.prdFinishingProcessPriceSetups.Where(m => m.IsActive == true && m.CompanyID == objPrdFinishingProcessPriceSetup.CompanyID && m.FinishingProcessID == objPrdFinishingProcessPriceSetup.FinishingProcessID).ToList() select lupdate).ToList(); prdFinishingProcessPriceSetup objFpp = new prdFinishingProcessPriceSetup(); foreach (prdFinishingProcessPriceSetup fp in lstFroUpdate) { fp.IsActive = false; //objFpp = fp; } long NextId = Convert.ToInt64(GenericFactory_EF_CmnCombo.getMaxID("prdFinishingProcessPriceSetup")); string customCode = ""; string CustomNo = GenericFactory_EF_CmnCombo.getCustomCode(menuID, DateTime.Now, objPrdFinishingProcessPriceSetup.CompanyID, 1, 1); if (!string.IsNullOrEmpty(CustomNo)) { customCode = CustomNo; } else if (string.IsNullOrEmpty(CustomNo)) { customCode = NextId.ToString(); } //.........END for custom code............ // string newProcessPriceNo = customCode; objPrdFinishingProcessPriceSetup.ProcessPriceID = (int)NextId; objPrdFinishingProcessPriceSetup.CreateOn = DateTime.Now; objPrdFinishingProcessPriceSetup.CreatePc = HostService.GetIP(); objPrdFinishingProcessPriceSetup.ProcessPriceNo = newProcessPriceNo; _ctxCmn.prdFinishingProcessPriceSetups.Add(objPrdFinishingProcessPriceSetup); //............Update MaxID.................// GenericFactory_EF_CmnCombo.updateMaxID("prdFinishingProcessPriceSetup", Convert.ToInt64(NextId)); //............Update CustomCode.............// GenericFactory_EF_CmnCombo.updateCustomCode(menuID, DateTime.Now, objPrdFinishingProcessPriceSetup.CompanyID, 1, 1); _ctxCmn.SaveChanges(); transactionScope.Complete(); result = newProcessPriceNo; } catch (Exception e) { result = ""; } } } return(result); }