public HttpResponseMessage SaveUpdateFinishing(object[] data) { vmPrdFinishingMRRMasterShrinkage itemMaster = JsonConvert.DeserializeObject <vmPrdFinishingMRRMasterShrinkage>(data[0].ToString()); List <vmPrdFinishingMRRMasterShrinkage> Shrinkage = JsonConvert.DeserializeObject <List <vmPrdFinishingMRRMasterShrinkage> >(data[1].ToString()); vmCmnParameters objcmnParam = JsonConvert.DeserializeObject <vmCmnParameters>(data[2].ToString()); string result = ""; try { if (ModelState.IsValid && itemMaster != null && Shrinkage != null) { result = objProductionEntryService.SaveUpdateFinishing(itemMaster, Shrinkage, objcmnParam); } else { result = ""; } } catch (Exception e) { e.ToString(); result = ""; } return(Request.CreateResponse(HttpStatusCode.OK, result)); }
public vmPrdFinishingMRRMasterShrinkage GetWeavingSetInformation(object[] data) { vmPrdFinishingMRRMasterShrinkage model = null; vmCmnParameters objcmnParam = JsonConvert.DeserializeObject <vmCmnParameters>(data[0].ToString()); try { model = objProductionEntryService.GetWeavingSetInformation(objcmnParam); } catch (Exception e) { e.ToString(); } return(model); }
public vmPrdFinishingMRRMasterShrinkage GetWeavingSetInformation(vmCmnParameters objcmnParam) { GenericFactory_vmPrdFinishingMRRMasterShrinkage_GF = new vmPrdFinishingMRRMasterShrinkage_VM(); vmPrdFinishingMRRMasterShrinkage objSetInformation = null; string spQuery = string.Empty; try { Hashtable ht = new Hashtable(); ht.Add("CompanyID", objcmnParam.loggedCompany); ht.Add("WeavingMRRID", objcmnParam.id); //ht.Add("FinishingMRRID", objcmnParam.ItemType); //FinishingMRRID is applicable when retrieve sizemrrmaster data spQuery = "[Get_WeavingSetInformation]"; objSetInformation = GenericFactory_vmPrdFinishingMRRMasterShrinkage_GF.ExecuteQuerySingle(spQuery, ht); } catch (Exception e) { e.ToString(); } return(objSetInformation); }
public string SaveUpdateFinishing(vmPrdFinishingMRRMasterShrinkage itemMaster, List <vmPrdFinishingMRRMasterShrinkage> Shrinkage, vmCmnParameters objcmnParam) { string result = string.Empty; using (TransactionScope transaction = new TransactionScope()) { //*********************************************Start Initialize Variable***************************************** string CustomNo = string.Empty, FinishingMRRNo = string.Empty; long MainMasterId = 0, ShrinkageMasterID = 0; //***************************************End Initialize Variable************************************************* //**************************Start Initialize Generic Repository Based on table*********************************** GenericFactory_PrdFinishingMRRMaster_EF = new PrdFinishingMRRMaster_EF(); GenericFactory_PrdFinishingMRRShrinkage_EF = new PrdFinishingMRRShrinkage_EF(); //****************************End Initialize Generic Repository Based on table*********************************** //**********************************Start Create Related Table Instance to Save********************************** var MasterItem = new PrdFinishingMRRMaster(); var ShrinkageItem = new PrdFinishingMRRShrinkage(); //**************************************************Start Main Operation************************************************ try { if (itemMaster.FinishingMRRID == 0) { //***************************************************Start Save Operation************************************************ //**********************************************Start Generate Master & Detail ID**************************************** MainMasterId = Convert.ToInt16(GenericFactory_PrdFinishingMRRMaster_EF.getMaxID("PrdFinishingMRRMaster")); ShrinkageMasterID = Convert.ToInt16(GenericFactory_PrdFinishingMRRShrinkage_EF.getMaxID("PrdFinishingMRRShrinkage")); //***********************************************End Generate Master & Detail ID***************************************** CustomNo = GenericFactory_PrdFinishingMRRMaster_EF.getCustomCode(objcmnParam.menuId, DateTime.Now, objcmnParam.loggedCompany, 1, 1); if (CustomNo == null || CustomNo == "") { FinishingMRRNo = MainMasterId.ToString(); } else { FinishingMRRNo = CustomNo; } MasterItem = new PrdFinishingMRRMaster { FinishingMRRID = MainMasterId, FinishingMRRNo = FinishingMRRNo, FinishingMRRTypeID = objcmnParam.tTypeId, FinishingMRRDate = (DateTime)itemMaster.FinishingMRRDate, ItemID = itemMaster.ItemID, SetID = itemMaster.SetID, SizeMRRID = itemMaster.SizeMRRID, WeavingMRRID = itemMaster.WeavingMRRID, BuyerID = (int)itemMaster.BuyerID, PIID = itemMaster.PIID, FinishingTypeID = (int)itemMaster.FinishingTypeID, MachineID = itemMaster.MachineID, ShiftID = itemMaster.ShiftID, StartTime = TimeSpan.Parse(itemMaster.StartTime == null ? "0:00" : itemMaster.StartTime), EndTime = TimeSpan.Parse(itemMaster.EndTime == null ? "0:00" : itemMaster.EndTime), Length = itemMaster.Length, UnitID = itemMaster.UnitID, OperatorID = itemMaster.OperatorID, ShiftEngineerID = itemMaster.ShiftEngineerID, Remarks = itemMaster.Remarks, CompanyID = objcmnParam.loggedCompany, CreateBy = objcmnParam.loggeduser, CreateOn = DateTime.Now, CreatePc = HostService.GetIP(), IsDeleted = false }; ShrinkageItem = new PrdFinishingMRRShrinkage { FinishingMRRShrinkageID = ShrinkageMasterID, FinishingMRRID = MainMasterId, ReqWeight = Shrinkage[0].ReqWeight, FiniWeight = Shrinkage[0].FiniWeight, AWWeight = Shrinkage[0].AWWeight, ItemID = Shrinkage[0].ItemID, SetID = Shrinkage[0].SetID, SizeMRRID = Shrinkage[0].SizeMRRID, WeavingMRRID = Shrinkage[0].WeavingMRRID, GreigeEPIPPI = Shrinkage[0].GreigeEPIPPI, FiniEPI = Shrinkage[0].FiniEPI, FiniPPI = Shrinkage[0].FiniPPI, AWEPIPPI = Shrinkage[0].AWEPIPPI, CuttableWidth = Shrinkage[0].CuttableWidth, FiniWidth = Shrinkage[0].FiniWidth, AWWidth = Shrinkage[0].AWWidth, WReqd = Shrinkage[0].WReqd, LShrinkage = Shrinkage[0].LShrinkage, WShrinkage = Shrinkage[0].WShrinkage, FiniSkew = Shrinkage[0].FiniSkew, IsFSPercent = Shrinkage[0].IsFSPercent, AWSkew = Shrinkage[0].AWSkew, IsAWPercent = Shrinkage[0].IsAWPercent, MovSkew = Shrinkage[0].MovSkew, IsMovPercent = Shrinkage[0].IsMovPercent, CompanyID = objcmnParam.loggedCompany, CreateBy = objcmnParam.loggeduser, CreateOn = DateTime.Now, CreatePc = HostService.GetIP(), IsDeleted = false }; } else { var MasterAll = GenericFactory_PrdFinishingMRRMaster_EF.GetAll().Where(x => x.FinishingMRRID == itemMaster.FinishingMRRID && x.CompanyID == objcmnParam.loggedCompany); var ShrinkageAll = GenericFactory_PrdFinishingMRRShrinkage_EF.GetAll().Where(x => x.FinishingMRRID == itemMaster.FinishingMRRID && x.CompanyID == objcmnParam.loggedCompany); //*************************************End Get Data From Related Table to Update********************************* FinishingMRRNo = itemMaster.FinishingMRRNo; //Update PrdFinishingMRRMaster MasterItem = MasterAll.First(x => x.FinishingMRRID == itemMaster.FinishingMRRID); MasterItem.FinishingMRRDate = (DateTime)itemMaster.FinishingMRRDate; MasterItem.ItemID = itemMaster.ItemID; MasterItem.SetID = itemMaster.SetID; MasterItem.SizeMRRID = itemMaster.SizeMRRID; MasterItem.WeavingMRRID = itemMaster.WeavingMRRID; MasterItem.BuyerID = (int)itemMaster.BuyerID; MasterItem.PIID = itemMaster.PIID; MasterItem.FinishingTypeID = (int)itemMaster.FinishingTypeID; MasterItem.MachineID = itemMaster.MachineID; MasterItem.ShiftID = itemMaster.ShiftID; MasterItem.StartTime = TimeSpan.Parse(itemMaster.StartTime == null ? "0:00" : itemMaster.StartTime); MasterItem.EndTime = TimeSpan.Parse(itemMaster.EndTime == null ? "0:00" : itemMaster.EndTime); MasterItem.Length = itemMaster.Length; MasterItem.UnitID = itemMaster.UnitID; MasterItem.OperatorID = itemMaster.OperatorID; MasterItem.ShiftEngineerID = itemMaster.ShiftEngineerID; MasterItem.Remarks = itemMaster.Remarks; MasterItem.CompanyID = objcmnParam.loggedCompany; MasterItem.UpdateBy = objcmnParam.loggeduser; MasterItem.UpdateOn = DateTime.Now; MasterItem.UpdatePc = HostService.GetIP(); //Update PrdFinishingMRRShrinkage ShrinkageItem = ShrinkageAll.First(x => x.FinishingMRRID == itemMaster.FinishingMRRID && x.FinishingMRRShrinkageID == Shrinkage[0].FinishingMRRShrinkageID); ShrinkageItem.ReqWeight = Shrinkage[0].ReqWeight; ShrinkageItem.FiniWeight = Shrinkage[0].FiniWeight; ShrinkageItem.AWWeight = Shrinkage[0].AWWeight; ShrinkageItem.ItemID = Shrinkage[0].ItemID; ShrinkageItem.SetID = Shrinkage[0].SetID; ShrinkageItem.SizeMRRID = Shrinkage[0].SizeMRRID; ShrinkageItem.WeavingMRRID = Shrinkage[0].WeavingMRRID; ShrinkageItem.GreigeEPIPPI = Shrinkage[0].GreigeEPIPPI; ShrinkageItem.FiniEPI = Shrinkage[0].FiniEPI; ShrinkageItem.FiniPPI = Shrinkage[0].FiniPPI; ShrinkageItem.AWEPIPPI = Shrinkage[0].AWEPIPPI; ShrinkageItem.CuttableWidth = Shrinkage[0].CuttableWidth; ShrinkageItem.FiniWidth = Shrinkage[0].FiniWidth; ShrinkageItem.AWWidth = Shrinkage[0].AWWidth; ShrinkageItem.WReqd = Shrinkage[0].WReqd; ShrinkageItem.LShrinkage = Shrinkage[0].LShrinkage; ShrinkageItem.WShrinkage = Shrinkage[0].WShrinkage; ShrinkageItem.FiniSkew = Shrinkage[0].FiniSkew; ShrinkageItem.IsFSPercent = Shrinkage[0].IsFSPercent; ShrinkageItem.AWSkew = Shrinkage[0].AWSkew; ShrinkageItem.IsAWPercent = Shrinkage[0].IsAWPercent; ShrinkageItem.MovSkew = Shrinkage[0].MovSkew; ShrinkageItem.IsMovPercent = Shrinkage[0].IsMovPercent; ShrinkageItem.CompanyID = objcmnParam.loggedCompany; ShrinkageItem.UpdateBy = objcmnParam.loggeduser; ShrinkageItem.UpdateOn = DateTime.Now; ShrinkageItem.UpdatePc = HostService.GetIP(); } if (itemMaster.FinishingMRRID > 0) { if (MasterItem != null) { GenericFactory_PrdFinishingMRRMaster_EF.Update(MasterItem); GenericFactory_PrdFinishingMRRMaster_EF.Save(); } if (ShrinkageItem != null) { GenericFactory_PrdFinishingMRRShrinkage_EF.Update(ShrinkageItem); GenericFactory_PrdFinishingMRRShrinkage_EF.Save(); } } else { if (MasterItem != null) { GenericFactory_PrdFinishingMRRMaster_EF.Insert(MasterItem); GenericFactory_PrdFinishingMRRMaster_EF.Save(); GenericFactory_PrdFinishingMRRMaster_EF.updateMaxID("PrdFinishingMRRMaster", Convert.ToInt64(MainMasterId)); GenericFactory_PrdFinishingMRRMaster_EF.updateCustomCode(objcmnParam.menuId, DateTime.Now, objcmnParam.loggedCompany, 1, 1); } if (ShrinkageItem != null) { GenericFactory_PrdFinishingMRRShrinkage_EF.Insert(ShrinkageItem); GenericFactory_PrdFinishingMRRShrinkage_EF.Save(); GenericFactory_PrdFinishingMRRShrinkage_EF.updateMaxID("PrdFinishingMRRShrinkage", Convert.ToInt64(ShrinkageMasterID)); } } transaction.Complete(); result = FinishingMRRNo; } catch (Exception e) { e.ToString(); result = ""; } #region To check Validation Error //catch (DbEntityValidationException e) //{ // foreach (var eve in e.EntityValidationErrors) // { // Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", // eve.Entry.Entity.GetType().Name, eve.Entry.State); // foreach (var ve in eve.ValidationErrors) // { // Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"", // ve.PropertyName, ve.ErrorMessage); // } // } // throw; //} #endregion } return(result); //**************************************************End Main Operation************************************************ }