public string DeleteFiniChemConsumptionMD(vmCmnParameters objcmnParam) { string result = string.Empty; using (TransactionScope transaction = new TransactionScope()) { GenericFactory_EF_PrdFinishingConsumptionMaster = new PrdFinishingConsumptionMaster_EF(); GenericFactory_EF_PrdFinishingConsumptionDetail = new PrdFinishingConsumptionDetail_EF(); string BWSNos = string.Empty; var FiniConM = new PrdFinishingConsumptionMaster(); var FiniConD = new PrdFinishingConsumptionDetail(); try { FiniConM = GenericFactory_EF_PrdFinishingConsumptionMaster.GetAll().Where(x => x.FinishingConsumptionID == objcmnParam.id).FirstOrDefault(); FiniConM.IsDeleted = true; FiniConM.CompanyID = objcmnParam.loggedCompany; FiniConM.DeleteBy = objcmnParam.loggeduser; FiniConM.DeleteOn = DateTime.Now; FiniConM.DeletePc = HostService.GetIP(); FiniConD = GenericFactory_EF_PrdFinishingConsumptionDetail.GetAll().Where(x => x.FinishingConsumptionID == objcmnParam.id).FirstOrDefault(); FiniConD.IsDeleted = true; FiniConD.CompanyID = objcmnParam.loggedCompany; FiniConD.DeleteBy = objcmnParam.loggeduser; FiniConD.DeleteOn = DateTime.Now; FiniConD.DeletePc = HostService.GetIP(); GenericFactory_EF_PrdFinishingConsumptionMaster.Update(FiniConM); GenericFactory_EF_PrdFinishingConsumptionMaster.Save(); transaction.Complete(); result = FiniConM.FinishingConsumptionNo; } catch (Exception e) { e.ToString(); result = ""; } } return(result); }
//public IEnumerable<vmChemicalSetupMasterDetail> GetChecmicalByID(vmCmnParameters objcmnParam) //{ // IEnumerable<vmChemicalSetupMasterDetail> objChemicalSetup = null; // using (ERP_Entities _ctxCmn = new ERP_Entities()) // { // try // { // objChemicalSetup = (from master in _ctxCmn.PrdFinishingChemicalSetups // join detail in _ctxCmn.PrdFinishingChemicalSetupDetails on master.FinChemicalStupID equals detail.FinChemicalStupID// into leftColorGroup // join FT in _ctxCmn.PrdFinishingTypes on master.FinishingProcessID equals FT.FinishingProcessID // join item in _ctxCmn.CmnItemMasters on detail.ChemicalID equals item.ItemID// into leftColorGroup // join uom in _ctxCmn.CmnUOMs on detail.UnitID equals uom.UOMID // where (FT.FInishTypeID == objcmnParam.id && master.IsDeleted == false) // select new vmChemicalSetupMasterDetail // { // FinChemicalStupID = master.FinChemicalStupID, // ChemicalID = detail.ChemicalID, // MaxQty = detail.MaxQty, // MinQty = detail.MinQty, // ItemName = item.ItemName, // UnitID = uom.UOMID, // UOMName = uom.UOMName // }).Distinct().ToList(); // } // catch (Exception e) // { // e.ToString(); // } // } // return objChemicalSetup; //} public string SaveUpdateChemConsumptionInfo(vmChemicalSetupMasterDetail ChemConsumptionInfo, List <vmChemicalSetupMasterDetail> DCDetailList, vmCmnParameters objcmnParam) { string result = string.Empty; using (TransactionScope transaction = new TransactionScope()) { GenericFactory_EF_PrdFinishingConsumptionMaster = new PrdFinishingConsumptionMaster_EF(); GenericFactory_EF_PrdFinishingConsumptionDetail = new PrdFinishingConsumptionDetail_EF(); long MasterId = 0, DetailId = 0, FirstDigit = 0, OtherDigits = 0; string CustomNo = string.Empty, FinishingConsumptionNo = string.Empty; //PrdFinishingConsumptionMaster Master = new PrdFinishingConsumptionMaster(); //List<PrdFinishingConsumptionDetail> Detail = new List<PrdFinishingConsumptionDetail>(); PrdFinishingConsumptionMaster Master = new PrdFinishingConsumptionMaster(); List <PrdFinishingConsumptionDetail> Detail = new List <PrdFinishingConsumptionDetail>(); vmChemicalSetupMasterDetail item = new vmChemicalSetupMasterDetail(); try { if (ChemConsumptionInfo.FinishingConsumptionID == 0) { MasterId = Convert.ToInt64(GenericFactory_EF_PrdFinishingConsumptionMaster.getMaxID("PrdFinishingConsumptionMaster")); DetailId = Convert.ToInt64(GenericFactory_EF_PrdFinishingConsumptionDetail.getMaxID("PrdFinishingConsumptionDetail")); FirstDigit = Convert.ToInt64(DetailId.ToString().Substring(0, 1)); OtherDigits = Convert.ToInt64(DetailId.ToString().Substring(1, DetailId.ToString().Length - 1)); CustomNo = GenericFactory_EF_PrdFinishingConsumptionMaster.getCustomCode(objcmnParam.menuId, DateTime.Now, objcmnParam.loggedCompany, objcmnParam.loggeduser, 1); // 1 for DB ID if (CustomNo != null && CustomNo != "") { FinishingConsumptionNo = CustomNo; } else { FinishingConsumptionNo = MasterId.ToString(); } Master = new PrdFinishingConsumptionMaster() { FinishingConsumptionID = MasterId, FinishingConsumptionNo = FinishingConsumptionNo, WeavingMRRID = ChemConsumptionInfo.WeavingMRRID, ItemID = ChemConsumptionInfo.ItemID, FinishingTypeID = ChemConsumptionInfo.FinishingTypeID, Volume = ChemConsumptionInfo.Volume, ConsumptionDate = ChemConsumptionInfo.ConsumptionDate, Remarks = ChemConsumptionInfo.Remarks, UnitID = (int)ChemConsumptionInfo.UnitID, IsDeleted = false, IsReleased = false, TransactionTypeID = objcmnParam.tTypeId, CompanyID = objcmnParam.loggedCompany, CreateOn = DateTime.Now, CreateBy = objcmnParam.loggeduser, CreatePc = HostService.GetIP(), }; foreach (vmChemicalSetupMasterDetail sdtl in DCDetailList) { PrdFinishingConsumptionDetail objConsmuptionDetail = new PrdFinishingConsumptionDetail(); objConsmuptionDetail.FinishingConsumptionDetailID = Convert.ToInt64(FirstDigit + "" + OtherDigits); objConsmuptionDetail.FinishingConsumptionID = MasterId; objConsmuptionDetail.ChemicalID = sdtl.ChemicalID; objConsmuptionDetail.UnitID = sdtl.UnitID; objConsmuptionDetail.RequiredQty = sdtl.RequiredQty; objConsmuptionDetail.AccQty = sdtl.AccQty; objConsmuptionDetail.Amount = sdtl.Amount; objConsmuptionDetail.BatchID = sdtl.BatchID; objConsmuptionDetail.SupplierID = sdtl.SupplierID; objConsmuptionDetail.ConsumptionDate = Master.ConsumptionDate; objConsmuptionDetail.UnitPrice = sdtl.UnitPrice; objConsmuptionDetail.IsDeleted = false; objConsmuptionDetail.IsReleased = false; objConsmuptionDetail.DepartmentID = objcmnParam.DepartmentID; objConsmuptionDetail.TransactionTypeID = objcmnParam.tTypeId; objConsmuptionDetail.CompanyID = objcmnParam.loggedCompany; objConsmuptionDetail.CreateOn = DateTime.Now; objConsmuptionDetail.CreateBy = objcmnParam.loggeduser; objConsmuptionDetail.CreatePc = HostService.GetIP(); Detail.Add(objConsmuptionDetail); OtherDigits++; } } else { Master = GenericFactory_EF_PrdFinishingConsumptionMaster.FindBy(m => m.FinishingConsumptionID == ChemConsumptionInfo.FinishingConsumptionID).FirstOrDefault(); Master.WeavingMRRID = ChemConsumptionInfo.WeavingMRRID; Master.ItemID = ChemConsumptionInfo.ItemID; Master.FinishingTypeID = ChemConsumptionInfo.FinishingTypeID; Master.Volume = ChemConsumptionInfo.Volume;; Master.ConsumptionDate = ChemConsumptionInfo.ConsumptionDate; Master.Remarks = ChemConsumptionInfo.Remarks; Master.UnitID = (int)ChemConsumptionInfo.UnitID; Master.TransactionTypeID = objcmnParam.tTypeId; Master.CompanyID = objcmnParam.loggedCompany; Master.UpdateOn = DateTime.Now; Master.UpdateBy = objcmnParam.loggeduser; Master.UpdatePc = HostService.GetIP(); foreach (vmChemicalSetupMasterDetail lcd in DCDetailList) { PrdFinishingConsumptionDetail FiniConDe = GenericFactory_EF_PrdFinishingConsumptionDetail.FindBy(m => m.FinishingConsumptionDetailID == lcd.FinishingConsumptionDetailID).FirstOrDefault(); FiniConDe.ChemicalID = lcd.ChemicalID; FiniConDe.UnitID = lcd.UnitID; FiniConDe.RequiredQty = lcd.RequiredQty; FiniConDe.AccQty = lcd.AccQty; FiniConDe.Amount = lcd.Amount; FiniConDe.BatchID = lcd.BatchID; FiniConDe.SupplierID = lcd.SupplierID; FiniConDe.ConsumptionDate = Master.ConsumptionDate; FiniConDe.UnitPrice = lcd.UnitPrice; FiniConDe.DepartmentID = objcmnParam.DepartmentID; FiniConDe.TransactionTypeID = objcmnParam.tTypeId; FiniConDe.CompanyID = objcmnParam.loggedCompany; FiniConDe.UpdateOn = DateTime.Now; FiniConDe.UpdateBy = objcmnParam.loggeduser; FiniConDe.UpdatePc = HostService.GetIP(); Detail.Add(FiniConDe); } } if (ChemConsumptionInfo.FinishingConsumptionID > 0) { GenericFactory_EF_PrdFinishingConsumptionMaster.Update(Master); GenericFactory_EF_PrdFinishingConsumptionMaster.Save(); GenericFactory_EF_PrdFinishingConsumptionDetail.UpdateList(Detail); GenericFactory_EF_PrdFinishingConsumptionDetail.Save(); } else { GenericFactory_EF_PrdFinishingConsumptionMaster.Insert(Master); GenericFactory_EF_PrdFinishingConsumptionMaster.Save(); GenericFactory_EF_PrdFinishingConsumptionMaster.updateMaxID("PrdFinishingConsumptionMaster", Convert.ToInt64(MasterId)); GenericFactory_EF_PrdFinishingConsumptionMaster.updateCustomCode(objcmnParam.menuId, DateTime.Now, objcmnParam.loggedCompany, 1, 1); GenericFactory_EF_PrdFinishingConsumptionDetail.InsertList(Detail); GenericFactory_EF_PrdFinishingConsumptionDetail.Save(); GenericFactory_EF_PrdFinishingConsumptionDetail.updateMaxID("PrdFinishingConsumptionDetail", Convert.ToInt64(FirstDigit + "" + (OtherDigits - 1))); } transaction.Complete(); result = Master.FinishingConsumptionNo; } catch (Exception e) { result = ""; e.ToString(); } } return(result); }