public static NONCONFORMANCE UpdateNonconf(SQM.Website.PSsqmEntities ctx, NONCONFORMANCE nonconf, string updateBy) { try { nonconf = (NONCONFORMANCE)SQMModelMgr.SetObjectTimestamp((object)nonconf, updateBy, nonconf.EntityState); if (nonconf.EntityState == EntityState.Detached || nonconf.EntityState == EntityState.Added) { ctx.AddToNONCONFORMANCE(nonconf); } if (nonconf.STATUS == "D") { ctx.DeleteObject(nonconf); } ctx.SaveChanges(); } catch (Exception e) { //SQMLogger.LogException(e); } return(nonconf); }
public static NONCONFORMANCE LookupNonconf(SQM.Website.PSsqmEntities ctx, decimal nonconfID, string nonconfCode) { NONCONFORMANCE nonconf = null; try { if (nonconfID == 0) { nonconf = (from m in ctx.NONCONFORMANCE where (m.NONCONF_CD.ToUpper() == nonconfCode.ToUpper()) select m).SingleOrDefault(); if (nonconf == null) { nonconf = (from m in ctx.NONCONFORMANCE where (m.NONCONF_NAME.ToUpper() == nonconfCode.ToUpper()) select m).SingleOrDefault(); } } else { nonconf = (from m in ctx.NONCONFORMANCE where (m.NONCONF_ID == nonconfID) select m).SingleOrDefault(); } } catch { } return(nonconf); }
public static SQM_MEASURE UpdateSQMMeasure(SQM.Website.PSsqmEntities ctx, SQM_MEASURE measure, string updateBy) { try { measure = (SQM_MEASURE)SQMModelMgr.SetObjectTimestamp((object)measure, updateBy, measure.EntityState); if (measure.EntityState == EntityState.Detached || measure.EntityState == EntityState.Added) { ctx.AddToSQM_MEASURE(measure); } if (measure.STATUS == "D") { ctx.DeleteObject(measure); } ctx.SaveChanges(); } catch (Exception e) { //SQMLogger.LogException(e); } return(measure); }
public static SETTINGS UpdateSettings(SQM.Website.PSsqmEntities ctx, SETTINGS settings, string updateBy) { settings = (SETTINGS)SQMModelMgr.SetObjectTimestamp((object)settings, updateBy, settings.EntityState); if (settings.EntityState == EntityState.Detached) { ctx.AddToSETTINGS(settings); } ctx.SaveChanges(); return(settings); }
public SQMStream CreateNew(string sessionID) { this.Stream = new STREAM(); this.Data = new StreamData(); this.RecList = new List <STREAM_REC>(); this.NCList = new List <STREAM_NC>(); this.MeasureList = new List <STREAM_MEASURE>(); this.isNew = true; this.SessionID = sessionID; this.Entities = new PSsqmEntities(); return(this); }
public ProblemCase Initialize() { this.ProbCase = new PROB_CASE(); this.IncidentList = new List <INCIDENT>(); this.IssueList = new List <object>(); this.PartIssueItemList = new List <PartIssueItem>(); this.Entities = new PSsqmEntities(); this.TeamTask = new TaskStatusMgr().Initialize(21, 0); this.StepComplete = ""; this.AttachmentsList = new List <ATTACHMENT>(); this.PersonSelectList = new List <PERSON>(); return(this); }
public static SETTINGS SelectSettingByCode(SQM.Website.PSsqmEntities ctx, string settingGroup, string settingFamily, string settingCode) { SETTINGS setting = null; try { setting = (from s in ctx.SETTINGS where (s.SETTING_GROUP.ToUpper() == settingGroup.ToUpper() && s.SETTING_FAMILY.ToUpper() == settingFamily.ToUpper() && s.SETTING_CD.ToUpper() == settingCode.ToUpper()) orderby s.SETTING_GROUP, s.SETTING_CD select s).Single(); } catch (Exception ex) { //SQMLogger.LogException(ex); } return(setting); }
public static STREAM LookupStream(SQM.Website.PSsqmEntities ctx, decimal streamID) { STREAM stream = null; try { stream = (from s in ctx.STREAM where (s.STREAM_ID == streamID) select s).Single(); } catch (Exception e) { //SQMLogger.LogException(e); } return(stream); }
public static PERSPECTIVE_VIEW UpdateView(SQM.Website.PSsqmEntities ctx, PERSPECTIVE_VIEW view, string updateBy) { try { if (view.STATUS == "D") { ctx.DeleteObject(view); } else { view = (PERSPECTIVE_VIEW)SQMModelMgr.SetObjectTimestamp((object)view, updateBy, view.EntityState); if (view.EntityState == EntityState.Detached || view.EntityState == EntityState.Added) { view.STATUS = "A"; ctx.AddToPERSPECTIVE_VIEW(view); } foreach (PERSPECTIVE_VIEW_ITEM vi in view.PERSPECTIVE_VIEW_ITEM.ToList()) { if (vi.STATUS == "D" || vi.ITEM_SEQ < 1) { ctx.DeleteObject(vi); } else { if (vi.EntityState == EntityState.Detached || vi.EntityState == EntityState.Added) { vi.STATUS = "A"; vi.CALCS_SCOPE = view.PERSPECTIVE; ctx.AddToPERSPECTIVE_VIEW_ITEM(vi); } } } } ctx.SaveChanges(); } catch (Exception e) { //SQMLogger.LogException(e); } return(view); }
public static SQM_MEASURE LookupSQMMeasure(SQM.Website.PSsqmEntities ctx, decimal measureID, string measureCode) { SQM_MEASURE measure = null; if (measureID == 0) { measure = (from m in ctx.SQM_MEASURE where (m.MEASURE_CD.ToUpper() == measureCode.ToUpper()) select m).Single(); } else { measure = (from m in ctx.SQM_MEASURE where (m.MEASURE_ID == measureID) select m).Single(); } return(measure); }
public static PROB_CASE LookupCase(SQM.Website.PSsqmEntities ctx, decimal caseID) { PROB_CASE probCase = null; try { probCase = (from o in ctx.PROB_CASE.Include("PROB_OCCUR").Include("PROB_DEFINE").Include("PROB_CONTAIN").Include("PROB_CAUSE").Include("PROB_RISK").Include("PROB_VERIFY").Include("PROB_PREVENT").Include("PROB_CLOSE") where (o.PROBCASE_ID == caseID) select o).Single(); if (probCase.PROB_CONTAIN != null) { probCase.PROB_CONTAIN.PROB_CONTAIN_ACTION.Load(); } if (probCase.PROB_CAUSE != null) { probCase.PROB_CAUSE.PROB_CAUSE_STEP.Load(); if (probCase.PROB_CAUSE.PROB_CAUSE_STEP != null && probCase.PROB_CAUSE.PROB_CAUSE_STEP.Count > 0) { probCase.PROB_CAUSE_ACTION.Load(); } if (probCase.PROB_VERIFY != null) { probCase.PROB_VERIFY.PROB_VERIFY_VERS.Load(); } } if (probCase.PROB_PREVENT != null) { probCase.PROB_PREVENT_LIST.Load(); } } catch (Exception e) { // SQMLogger.LogException(e); } return(probCase); }
public SQMStream Load(decimal streamID) { this.Entities = new PSsqmEntities(); this.isNew = false; this.Stream = LookupStream(this.Entities, streamID); if (this.Stream.PART_ID > 0) { this.Data.Partdata = SQMModelMgr.LookupPartData(this.Entities, (decimal)this.Stream.COMPANY_ID, (decimal)this.Stream.PART_ID); } if (this.Stream.SUPP_COMPANY_ID > 0) { this.Data.Supplier = SQMModelMgr.LookupCompany((decimal)this.Stream.SUPP_COMPANY_ID); this.Data.SupplierPlant = SQMModelMgr.LookupPlant((decimal)this.Stream.SUPP_PLANT_ID); } if (this.Stream.CUST_COMPANY_ID > 0) { this.Data.Customer = SQMModelMgr.LookupCompany((decimal)this.Stream.CUST_COMPANY_ID); this.Data.CustomerPlant = SQMModelMgr.LookupPlant((decimal)this.Stream.CUST_PLANT_ID); } this.RecList = FillHistory(12); return(this); }
protected void Page_Load(object sender, EventArgs e) { SQMLoader dataLoader = new SQMLoader().Initialize(1, ""); // if (dataLoader.LoadPerson() != 99) // return; if (dataLoader.LoadBusOrgs() != 99) { return; } // if (dataLoader.LoadPlants() != 99) // return; // if (dataLoader.LoadParts() != 99) // return; // if (dataLoader.LoadNonConformances() != 99) // return; using (SQM.Website.PSsqmEntities ctx = new SQM.Website.PSsqmEntities()) { ctx.ContextOptions.LazyLoadingEnabled = false; BUSINESS_ORG buOrg = new BUSINESS_ORG(); buOrg.COMPANY_ID = 3; buOrg.BUS_ORG_ID = 2; SQMModelMgr.SelectBusOrgList(ctx, 5, 0, true); //SQMModelMgr.CreateBusOrgNonConf(ctx, buOrg); //List<vw_CompanyNonConformance> NCList = SQMModelMgr.SelectCompanyNCList(1, 1, false); //SQMModelMgr.UpdateCompanyNCList(NCList, 1, 1); //COMPANY company = new COMPANY(); //SQMModelMgr.SetGridCode((object)company, company.EntityState, 1); //PERSON person = SQMModelMgr.LookupPerson(ctx, "mike", false); //COMPANY co = SQMModelMgr.LookupCompany(ctx, "dunsSUPC", false); //List<PART> partList = SQMModelMgr.SelectPartList(ctx, 1); //PART pt = partList[0]; //List<PLANT> plantList = SQMModelMgr.SelectPlantList(ctx, 3, 0); //PLANT pl = plantList[0]; // var bu_rec = (from b in ctx.COMPANies // select b).ToList(); //COMPANY comp = bu_rec[1]; //comp.LAST_UPD_BY = "me"; //comp.LAST_UPD_DT = DateTime.Now; // comp.CS_COMPANY_OVER_F = "Y"; // comp = (COMPANY)SQMModelMgr.SetPropertyValue((object)comp, "LAST_UPD_BY", "jack"); // comp = (COMPANY)SQMModelMgr.SetPropertyValue((object)comp, "CS_COMPANY_OVER_F", "Y"); /* * COMPANY newcomp = new COMPANY(); * newcomp.SD_ID = 0; * newcomp.ULT_DUNS_CODE = "duns002"; * newcomp.ULT_GRID_CODE = ""; * newcomp.COMPANY_NAME = newcomp.UNIQUE_ID_NAME = "SUPPLIER B"; * newcomp.CS_COMPANY_OVER_F = ""; * newcomp.STATUS = "A"; * newcomp.CREATE_BY = newcomp.LAST_UPD_BY = "me"; * newcomp.CREATE_DT = newcomp.LAST_UPD_DT = DateTime.Now; * ctx.COMPANies.AddObject(newcomp); */ //ctx.SaveChanges(); } }