public vmPrdWeavingMachineConfigMasterDetail GetMaintenanceMachineData(vmCmnParameters objcmnParam) { vmPrdWeavingMachineConfigMasterDetail objMMOMachineData = null; try { using (_ctxCmn = new ERP_Entities()) { objMMOMachineData = (from IM in _ctxCmn.MntMachineMaintenanceOrders.Where(x => x.CompanyID == objcmnParam.loggedCompany && x.IsDeleted == false && x.MaintenanceID == objcmnParam.id) join MC in _ctxCmn.PrdWeavingMachinConfigs on IM.MachineConfigID equals MC.MachineConfigID join CO in _ctxCmn.CmnOrganograms on IM.DepartmentID equals CO.OrganogramID select new { MachineConfigID = IM.MachineConfigID, MachineConfigNo = MC.MachineConfigNo, DepartmentID = IM.DepartmentID, OrganogramName = CO.OrganogramName }).ToList().Select(x => new vmPrdWeavingMachineConfigMasterDetail { MachineConfigID = x.MachineConfigID, MachineConfigNo = x.MachineConfigNo, DepartmentID = x.DepartmentID, OrganogramName = x.OrganogramName }).FirstOrDefault(); } } catch (Exception e) { e.ToString(); } return(objMMOMachineData); }
public HttpResponseMessage SaveUpdateMachineMaintenanceOrder(object[] data) { string result = string.Empty; vmPrdWeavingMachineConfigMasterDetail model = JsonConvert.DeserializeObject <vmPrdWeavingMachineConfigMasterDetail>(data[0].ToString()); vmCmnParameters objcmnParam = JsonConvert.DeserializeObject <vmCmnParameters>(data[1].ToString()); try { result = objMMOEntryService.SaveUpdateMachineMaintenanceOrder(model, objcmnParam); } catch (Exception e) { e.ToString(); result = ""; } return(Request.CreateResponse(HttpStatusCode.OK, result)); }
public string SaveUpdateMachineMaintenanceRelease(vmPrdWeavingMachineConfigMasterDetail model, vmCmnParameters objcmnParam) { string result = string.Empty; using (TransactionScope transaction = new TransactionScope()) { GenericFactory_MntMachineMaintenanceOrder_EF = new MntMachineMaintenanceOrder_EF(); GenericFactory_WeavingMachinConfig_EF = new PrdWeavingMachinConfig_EF(); var umodel = new MntMachineMaintenanceOrder(); var uConfig = new PrdWeavingMachinConfig(); try { umodel = GenericFactory_MntMachineMaintenanceOrder_EF.GetAll().Where(x => x.MaintenanceID == model.MaintenanceID).FirstOrDefault(); umodel.IsReleased = true; umodel.IsMaintenance = false; umodel.MaintenanceEmployeeID = objcmnParam.loggeduser; umodel.ReleaseRemarks = model.ReleaseRemarks; umodel.ReleaseDate = model.ReleaseDate; uConfig = GenericFactory_WeavingMachinConfig_EF.GetAll().Where(x => x.MachineConfigID == model.MachineConfigID).FirstOrDefault(); uConfig.IsMaintenance = false; if (umodel != null) { GenericFactory_MntMachineMaintenanceOrder_EF.Update(umodel); GenericFactory_MntMachineMaintenanceOrder_EF.Save(); } if (uConfig != null) { GenericFactory_WeavingMachinConfig_EF.Update(uConfig); GenericFactory_WeavingMachinConfig_EF.Save(); } transaction.Complete(); result = umodel.MaintenanceNo; } catch (Exception e) { e.ToString(); result = ""; } } return(result); }
public IHttpActionResult GetMaintenanceMachineData(object[] data) { vmPrdWeavingMachineConfigMasterDetail MData = null; vmCmnParameters objcmnParam = JsonConvert.DeserializeObject <vmCmnParameters>(data[0].ToString()); try { MData = objMMREntryService.GetMaintenanceMachineData(objcmnParam); } catch (Exception e) { e.ToString(); } return(Json(new { MData })); //return objDOMaster.ToList(); }
public HttpResponseMessage SaveUpdateWeavingMasterDetail(object[] data) { vmPrdWeavingMachineConfigMasterDetail itemMaster = JsonConvert.DeserializeObject <vmPrdWeavingMachineConfigMasterDetail>(data[0].ToString()); List <vmPrdWeavingMachineConfigMasterDetail> itemDetails = JsonConvert.DeserializeObject <List <vmPrdWeavingMachineConfigMasterDetail> >(data[1].ToString()); vmCmnParameters objcmnParam = JsonConvert.DeserializeObject <vmCmnParameters>(data[2].ToString()); string result = ""; try { if (ModelState.IsValid && itemMaster != null && itemDetails.Count > 0) { result = objweavingservice.SaveUpdateWeavingMasterDetail(itemMaster, itemDetails, objcmnParam); } } catch (Exception e) { e.ToString(); result = ""; } // System.Web.HttpContext.Current.Session.Add("LCReferenceNo", result); return(Request.CreateResponse(HttpStatusCode.OK, result)); }
public string SaveUpdateWeavingMasterDetail(vmPrdWeavingMachineConfigMasterDetail Master, List <vmPrdWeavingMachineConfigMasterDetail> Detail, vmCmnParameters objcmnParam) { string result = string.Empty; using (var transaction = new TransactionScope()) { //*********************************************Start Initialize Variable***************************************** long MasterId = 0, DetailId = 0, FirstDigit = 0, OtherDigits = 0; //***************************************End Initialize Variable************************************************* //**************************Start Initialize Generic Repository Based on table*********************************** GenericFactory_PrdWeavingMachinConfig_EF = new PrdWeavingMachinConfig_EF(); GenericFactory_PrdWeavingMachineConfigDetail_EF = new PrdWeavingMachineConfigDetail_EF(); //****************************End Initialize Generic Repository Based on table*********************************** //**********************************Start Create Related Table Instance to Save********************************** var MasterItem = new PrdWeavingMachinConfig(); var DetailItem = new List <PrdWeavingMachineConfigDetail>(); var DetailItems = new List <PrdWeavingMachineConfigDetail>(); //************************************End Create Related Table Instance to Save********************************** //*************************************Start Create Model Instance to get Data*********************************** vmPrdWeavingMachineConfigMasterDetail item = new vmPrdWeavingMachineConfigMasterDetail(); vmPrdWeavingMachineConfigMasterDetail items = new vmPrdWeavingMachineConfigMasterDetail(); PrdWeavingMachineConfigDetail itemdel = new PrdWeavingMachineConfigDetail(); //***************************************End Create Model Instance to get Data*********************************** var SDetail = Detail.Where(x => x.MachineConfigDetailID == 0).ToList(); var UDetail = Detail.Where(x => x.MachineConfigDetailID != 0).ToList(); //**************************************************Start Main Operation************************************************ if (Detail.Count > 0) { try { if (Master.MachineConfigID == 0) { //***************************************************Start Save Operation************************************************ //**********************************************Start Generate Master & Detail ID**************************************** MasterId = Convert.ToInt16(GenericFactory_PrdWeavingMachinConfig_EF.getMaxID("PrdWeavingMachinConfig")); DetailId = Convert.ToInt64(GenericFactory_PrdWeavingMachineConfigDetail_EF.getMaxID("PrdWeavingMachineConfigDetail")); FirstDigit = Convert.ToInt64(DetailId.ToString().Substring(0, 1)); OtherDigits = Convert.ToInt64(DetailId.ToString().Substring(1, DetailId.ToString().Length - 1)); //***********************************************End Generate Master & Detail ID***************************************** MasterItem = new PrdWeavingMachinConfig { MachineConfigID = (int)MasterId, MachineConfigNo = Master.MachineConfigNo, Remarks = Master.Remarks, DepartmentID = Master.DepartmentID, CompanyID = objcmnParam.loggedCompany, CreateBy = objcmnParam.loggeduser, CreateOn = DateTime.Now, CreatePc = HostService.GetIP(), IsDeleted = false, IsBook = false, IsCorrupted = false, IsMaintenance = false }; for (int i = 0; i < Detail.Count; i++) { item = Detail[i]; var Detailitem = new PrdWeavingMachineConfigDetail { MachineConfigDetailID = Convert.ToInt32(FirstDigit + "" + OtherDigits), MachineConfigID = (int)MasterId, MachineID = (long)item.MachineID, Description = item.Description, CompanyID = objcmnParam.loggedCompany, CreateBy = objcmnParam.loggeduser, CreateOn = DateTime.Now, CreatePc = HostService.GetIP(), IsDeleted = false }; DetailItem.Add(Detailitem); OtherDigits++; } //***************************************************End Save Operation************************************************ } else { //***********************************Start Get Data From Related Table to Update********************************* var MasterAll = GenericFactory_PrdWeavingMachinConfig_EF.GetAll().Where(x => x.MachineConfigID == Master.MachineConfigID && x.CompanyID == objcmnParam.loggedCompany); var DetailAll = GenericFactory_PrdWeavingMachineConfigDetail_EF.GetAll().Where(x => x.MachineConfigID == Master.MachineConfigID && x.CompanyID == objcmnParam.loggedCompany).ToArray(); //*************************************End Get Data From Related Table to Update********************************* //***************************************************Start Update Operation******************************************** MasterItem = MasterAll.First(x => x.MachineConfigID == Master.MachineConfigID); MasterItem.MachineConfigNo = Master.MachineConfigNo; MasterItem.DepartmentID = Master.DepartmentID; MasterItem.Remarks = Master.Remarks; MasterItem.CompanyID = objcmnParam.loggedCompany; MasterItem.UpdateBy = objcmnParam.loggeduser; MasterItem.UpdateOn = DateTime.Now; MasterItem.UpdatePc = HostService.GetIP(); MasterItem.IsDeleted = false; for (int i = 0; i < UDetail.Count; i++) { item = UDetail[i]; foreach (PrdWeavingMachineConfigDetail d in DetailAll.Where(d => d.MachineConfigID == Master.MachineConfigID && d.MachineConfigDetailID == item.MachineConfigDetailID)) { d.MachineID = (long)item.MachineID; d.Description = item.Description; d.CompanyID = objcmnParam.loggedCompany; d.UpdateBy = objcmnParam.loggeduser; d.UpdateOn = DateTime.Now; d.UpdatePc = HostService.GetIP(); d.IsDeleted = false; DetailItem.Add(d); break; } } if (SDetail != null && SDetail.Count != 0) { for (int i = 0; i < SDetail.Count; i++) { item = SDetail[i]; DetailId = Convert.ToInt64(GenericFactory_PrdWeavingMachineConfigDetail_EF.getMaxID("PrdWeavingMachineConfigDetail")); FirstDigit = Convert.ToInt64(DetailId.ToString().Substring(0, 1)); OtherDigits = Convert.ToInt64(DetailId.ToString().Substring(1, DetailId.ToString().Length - 1)); var Detailitems = new PrdWeavingMachineConfigDetail { MachineConfigDetailID = Convert.ToInt32(FirstDigit + "" + OtherDigits), MachineConfigID = (long)Master.MachineConfigID, MachineID = (long)item.MachineID, Description = item.Description, CompanyID = objcmnParam.loggedCompany, CreateBy = objcmnParam.loggeduser, CreateOn = DateTime.Now, CreatePc = HostService.GetIP(), IsDeleted = false }; DetailItems.Add(Detailitems); GenericFactory_PrdWeavingMachineConfigDetail_EF.updateMaxID("PrdWeavingMachineConfigDetail", Convert.ToInt64(FirstDigit + "" + (OtherDigits))); } } if (UDetail.Count < DetailAll.Count()) { for (int i = 0; i < DetailAll.Count(); i++) { itemdel = DetailAll[i]; var delDetail = (from del in DetailItem.Where(x => x.MachineConfigDetailID == itemdel.MachineConfigDetailID) select del.MachineConfigDetailID).FirstOrDefault(); if (delDetail != itemdel.MachineConfigDetailID) { var tem = DetailAll.FirstOrDefault(d => d.MachineConfigID == Master.MachineConfigID && d.MachineConfigDetailID == itemdel.MachineConfigDetailID); tem.CompanyID = objcmnParam.loggedCompany; tem.DeleteBy = objcmnParam.loggeduser; tem.DeleteOn = DateTime.Now; tem.DeletePc = HostService.GetIP(); tem.IsDeleted = true; DetailItem.Add(tem); } } } //***************************************************End Update Operation******************************************** } if (Master.MachineConfigID > 0) { //***************************************************Start Update************************************************ if (MasterItem != null) { GenericFactory_PrdWeavingMachinConfig_EF.Update(MasterItem); GenericFactory_PrdWeavingMachinConfig_EF.Save(); } if (DetailItem != null && DetailItem.Count != 0) { GenericFactory_PrdWeavingMachineConfigDetail_EF.UpdateList(DetailItem.ToList()); GenericFactory_PrdWeavingMachineConfigDetail_EF.Save(); } if (DetailItems != null && DetailItems.Count != 0) { GenericFactory_PrdWeavingMachineConfigDetail_EF.InsertList(DetailItems.ToList()); GenericFactory_PrdWeavingMachineConfigDetail_EF.Save(); } //***************************************************End Update************************************************ } else { //***************************************************Start Save************************************************ if (MasterItem != null) { GenericFactory_PrdWeavingMachinConfig_EF.Insert(MasterItem); GenericFactory_PrdWeavingMachinConfig_EF.Save(); GenericFactory_PrdWeavingMachinConfig_EF.updateMaxID("PrdWeavingMachinConfig", Convert.ToInt64(MasterId)); } if (DetailItem != null && DetailItem.Count != 0) { GenericFactory_PrdWeavingMachineConfigDetail_EF.InsertList(DetailItem.ToList()); GenericFactory_PrdWeavingMachineConfigDetail_EF.Save(); GenericFactory_PrdWeavingMachineConfigDetail_EF.updateMaxID("PrdWeavingMachineConfigDetail", Convert.ToInt64(FirstDigit + "" + (OtherDigits - 1))); } //******************************************************End Save************************************************ } transaction.Complete(); result = MasterItem.MachineConfigNo; } catch (Exception e) { result = ""; e.ToString(); } } else { result = ""; } } return(result); //**************************************************End Main Operation************************************************ }
public string SaveUpdateMachineMaintenanceOrder(vmPrdWeavingMachineConfigMasterDetail model, vmCmnParameters objcmnParam) { string result = string.Empty; using (TransactionScope transaction = new TransactionScope()) { GenericFactory_MntMachineMaintenanceOrder_EF = new MntMachineMaintenanceOrder_EF(); GenericFactory_WeavingMachinConfig_EF = new PrdWeavingMachinConfig_EF(); long MainId = 0; string CustomNo = string.Empty, MaintenanceNo = string.Empty; var umodel = new MntMachineMaintenanceOrder(); var uConfig = new PrdWeavingMachinConfig(); try { if (model.MaintenanceID > 0) { umodel = GenericFactory_MntMachineMaintenanceOrder_EF.GetAll().Where(x => x.MaintenanceID == model.MaintenanceID).FirstOrDefault(); umodel.MachineConfigID = model.MachineConfigID; umodel.DepartmentID = model.DepartmentID; umodel.EmployeeID = objcmnParam.loggeduser; umodel.Reason = model.Reason; umodel.MaintenanceDate = model.MaintenanceDate; umodel.CompanyID = objcmnParam.loggedCompany; umodel.UpdateBy = objcmnParam.loggeduser; umodel.UpdateOn = DateTime.Now; umodel.UpdatePc = HostService.GetIP(); } else { MainId = Convert.ToInt16(GenericFactory_MntMachineMaintenanceOrder_EF.getMaxID("MntMachineMaintenanceOrder")); CustomNo = GenericFactory_MntMachineMaintenanceOrder_EF.getCustomCode(objcmnParam.menuId, DateTime.Now, objcmnParam.loggedCompany, 1, 1); if (CustomNo == null || CustomNo == "") { MaintenanceNo = MainId.ToString(); } else { MaintenanceNo = CustomNo; } umodel = new MntMachineMaintenanceOrder() { MaintenanceID = (int)MainId, MaintenanceNo = MaintenanceNo, MachineConfigID = model.MachineConfigID, DepartmentID = model.DepartmentID, EmployeeID = objcmnParam.loggeduser, Reason = model.Reason, IsMaintenance = true, MaintenanceDate = model.MaintenanceDate, IsDeleted = false, CompanyID = objcmnParam.loggedCompany, CreateBy = objcmnParam.loggeduser, CreateOn = DateTime.Now, CreatePc = HostService.GetIP() }; } uConfig = GenericFactory_WeavingMachinConfig_EF.GetAll().Where(x => x.MachineConfigID == model.MachineConfigID).FirstOrDefault(); uConfig.IsMaintenance = true; if (model.MaintenanceID > 0) { GenericFactory_MntMachineMaintenanceOrder_EF.Update(umodel); GenericFactory_MntMachineMaintenanceOrder_EF.Save(); } else { GenericFactory_MntMachineMaintenanceOrder_EF.Insert(umodel); GenericFactory_MntMachineMaintenanceOrder_EF.Save(); GenericFactory_MntMachineMaintenanceOrder_EF.updateMaxID("MntMachineMaintenanceOrder", Convert.ToInt64(MainId)); GenericFactory_MntMachineMaintenanceOrder_EF.updateCustomCode(objcmnParam.menuId, DateTime.Now, objcmnParam.loggedCompany, 1, 1); } if (uConfig != null) { GenericFactory_WeavingMachinConfig_EF.Update(uConfig); GenericFactory_WeavingMachinConfig_EF.Save(); } transaction.Complete(); result = umodel.MaintenanceNo; } catch (Exception e) { e.ToString(); result = ""; } } return(result); }