public string DeleteChemicalPreparationMasterDetail(vmCmnParameters objcmnParam) { string result = ""; using (var transaction = new TransactionScope()) { GFactory_EF_PrdDyingChemicalSetup = new PrdDyingChemicalSetup_EF(); GenericFactory_EF_PrdDyingChemicalSetupDetail = new PrdDyingChemicalSetupDetail_EF(); var MasterItem = new PrdDyingChemicalSetup(); var DetailItem = new List <PrdDyingChemicalSetupDetail>(); //For Update Master Detail var MasterAll = GFactory_EF_PrdDyingChemicalSetup.GetAll().Where(x => x.ChemicalSetupID == objcmnParam.id && x.CompanyID == objcmnParam.loggedCompany); var DetailAll = GenericFactory_EF_PrdDyingChemicalSetupDetail.GetAll().Where(x => x.ChemicalSetupID == objcmnParam.id && x.CompanyID == objcmnParam.loggedCompany); //-------------------END---------------------- try { MasterItem = MasterAll.First(x => x.ChemicalSetupID == objcmnParam.id); MasterItem.CompanyID = objcmnParam.loggedCompany; MasterItem.DeleteBy = objcmnParam.loggeduser; MasterItem.DeleteOn = DateTime.Now; MasterItem.DeletePc = HostService.GetIP(); MasterItem.IsDeleted = true; foreach (PrdDyingChemicalSetupDetail d in DetailAll.Where(d => d.ChemicalSetupID == objcmnParam.id)) { d.CompanyID = objcmnParam.loggedCompany; d.DeleteBy = objcmnParam.loggeduser; d.DeleteOn = DateTime.Now; d.DeletePc = HostService.GetIP(); d.IsDeleted = true; DetailItem.Add(d); } if (MasterItem != null) { GFactory_EF_PrdDyingChemicalSetup.Update(MasterItem); GFactory_EF_PrdDyingChemicalSetup.Save(); } if (DetailItem != null) { GenericFactory_EF_PrdDyingChemicalSetupDetail.UpdateList(DetailItem.ToList()); GenericFactory_EF_PrdDyingChemicalSetupDetail.Save(); } transaction.Complete(); result = MasterItem.CmnItemColor.ColorName; } catch (Exception e) { result = ""; e.ToString(); } } return(result); }
public int SaveChemicalPrepartion(PrdDyingChemicalSetup model, List <PrdDyingChemicalSetupDetail> details, UserCommonEntity commonEntity) { GFactory_EF_PrdDyingChemicalSetup = new PrdDyingChemicalSetup_EF(); GenericFactory_EF_PrdDyingChemicalSetupDetail = new PrdDyingChemicalSetupDetail_EF(); int masterID = (int)model.ChemicalSetupID; PrdDyingChemicalSetup modelBase = new PrdDyingChemicalSetup(); List <Int32> UpdatedIDs = new List <Int32>(); List <PrdDyingChemicalSetupDetail> detailsList = new List <PrdDyingChemicalSetupDetail>(); List <PrdDyingChemicalSetupDetail> detailsInsertionList = new List <PrdDyingChemicalSetupDetail>(); int result = 0; try { modelBase = ModelBinding(model, details); foreach (var item in modelBase.PrdDyingChemicalSetupDetails) { if (item.EntryStateStatus == "Modified") { PrdDyingChemicalSetupDetail detailsEntity = new PrdDyingChemicalSetupDetail(); detailsEntity = DetailsBinding(modelBase.PrdDyingChemicalSetupDetails.Where(x => x.ChemicalSetupDetailID == item.ChemicalSetupDetailID).FirstOrDefault()); detailsList.Add(detailsEntity); UpdatedIDs.Add((int)detailsEntity.ChemicalSetupDetailID); } if (item.EntryStateStatus == "Add" && masterID > 0) { PrdDyingChemicalSetupDetail detailsEntity = new PrdDyingChemicalSetupDetail(); detailsEntity = DetailsBinding(modelBase.PrdDyingChemicalSetupDetails.Where(x => x.ChemicalSetupDetailID == item.ChemicalSetupDetailID).FirstOrDefault()); detailsInsertionList.Add(detailsEntity); } } foreach (var item in UpdatedIDs) { modelBase.PrdDyingChemicalSetupDetails.Remove(modelBase.PrdDyingChemicalSetupDetails.Where(x => x.ChemicalSetupDetailID == item).FirstOrDefault()); } if (masterID == 0) { GFactory_EF_PrdDyingChemicalSetup.Insert(modelBase); GFactory_EF_PrdDyingChemicalSetup.Save(); } else { GFactory_EF_PrdDyingChemicalSetup.Update(model); GenericFactory_EF_PrdDyingChemicalSetupDetail.UpdateList(detailsList); GenericFactory_EF_PrdDyingChemicalSetupDetail.InsertList(detailsInsertionList); GFactory_EF_PrdDyingChemicalSetup.Save(); GenericFactory_EF_PrdDyingChemicalSetupDetail.Save(); } result = 1; } catch (Exception ex) { ex.Message.ToString(); } return(result); }
public IHttpActionResult SaveChemicalPrepartion(object[] data) { int result = 0; PrdDyingChemicalSetup master = JsonConvert.DeserializeObject <PrdDyingChemicalSetup>(data[0].ToString()); List <PrdDyingChemicalSetupDetail> Details = JsonConvert.DeserializeObject <List <PrdDyingChemicalSetupDetail> >(data[1].ToString()); #region Shared Entity UserCommonEntity commonEntity = JsonConvert.DeserializeObject <UserCommonEntity>(data[2].ToString()); var loggedCompnyID = commonEntity.loggedCompnyID; var loggedUserID = commonEntity.loggedUserID; var MenuID = commonEntity.currentMenuID; var loggedUserBranchID = commonEntity.loggedUserBranchID; var currentModuleID = commonEntity.currentModuleID; var loggedUserDepartmentID = commonEntity.loggedUserDepartmentID; var TransactionTypeID = commonEntity.currentTransactionTypeID; List <CmnMenu> menuList = JsonConvert.DeserializeObject <List <CmnMenu> >(commonEntity.MenuList.ToString()); List <CmnMenu> ChildMenues = JsonConvert.DeserializeObject <List <CmnMenu> >(commonEntity.ChildMenues.ToString()); #endregion Shared Entity try { result = objChemicalService.SaveChemicalPrepartion(master, Details, commonEntity); // result = 1; } catch (Exception e) { e.ToString(); result = 0; } return(Json(new { result })); //return _finishGoodes; }
private PrdDyingChemicalSetup ModelBinding(PrdDyingChemicalSetup model, List <PrdDyingChemicalSetupDetail> details) { GFactory_EF_PrdDyingChemicalSetup = new PrdDyingChemicalSetup_EF(); try { Int64 NextID = GFactory_EF_PrdDyingChemicalSetup.getMaxVal_int64("ChemicalSetupID", "PrdDyingChemicalSetup"); model.ChemicalSetupID = model.ChemicalSetupID == 0 ? NextID : model.ChemicalSetupID; model.ColorID = model.ColorID; model.Qty = model.Qty; model.DepartmentID = model.DepartmentID; model.UserID = model.UserID; model.UnitID = model.UnitID; model.IsDeleted = false; NextID = GFactory_EF_PrdDyingChemicalSetup.getMaxVal_int64("ChemicalSetupDetailID", "PrdDyingChemicalSetupDetail"); foreach (PrdDyingChemicalSetupDetail Item in details) { PrdDyingChemicalSetupDetail entity = new PrdDyingChemicalSetupDetail(); entity.ChemicalSetupDetailID = Item.ChemicalSetupDetailID; if (Item.ChemicalSetupDetailID == 0) { if (Item.IsDeleted) { continue; } Item.ChemicalSetupDetailID = NextID++; entity.ChemicalSetupDetailID = Item.ChemicalSetupDetailID; entity.EntryStateStatus = "Add"; } else if (Item.IsDeleted == true) { entity.EntryStateStatus = "Delete"; } else { entity.EntryStateStatus = "Modified"; } entity.ItemID = Item.ItemID; entity.Qty = Item.Qty; entity.ChemicalSetupID = model.ChemicalSetupID; entity.UnitID = Item.UnitID; entity.IsDeleted = Item.IsDeleted; entity.CompanyID = Item.CompanyID; entity.CompanyID = model.CompanyID; entity.CreateBy = Item.CreateBy; entity.CreateOn = Item.CreateOn; entity.CreatePc = Item.CreatePc; entity.UpdateBy = Item.UpdateBy; entity.UpdateOn = Item.UpdateOn; entity.UpdatePc = Item.UpdatePc; if (entity.EntryStateStatus != "Delete") { entity.IsDeleted = false; } else { entity.EntryStateStatus = "Modified"; entity.IsDeleted = true; } entity.DeleteBy = Item.DeleteBy; entity.DeleteOn = Item.DeleteOn; entity.DeletePc = Item.DeletePc; model.PrdDyingChemicalSetupDetails.Add(entity); } return(model); } catch (Exception ex) { ex.Message.ToString(); throw; } }