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();
}
}
