public static User CheckLogin(SEGRepository segRep, string user)
{
User u = null;
using (SEGContext seg = segRep.GetContext())
{
u = seg.Users.FirstOrDefault(x => x.Name.Trim().ToUpper() == user.Trim().ToUpper());
}
return u;
}
public static void DeleteDiagnosticsImage(SEGRepository segR, Guid diagId, Guid imgId)
{
using (SEGContext seg = segR.GetContext())
{
DiagnosticsImages ih = seg.DiagnosticsImages.FirstOrDefault(x => x.DiagnosticID == diagId && x.ImageId == imgId);
seg.DiagnosticsImages.Remove(ih);
Image i = seg.Images.FirstOrDefault(x => x.Id == imgId);
seg.Images.Remove(i);
seg.SaveChanges();
}
}
public bool CheckDatabase()
{
bool isOk = false;
if(configLoaded)
{
// Load segR
segR = new SEGRepository(ConnString());
//
using(var seg = segR.GetContext())
{
if (seg.RiskAnalysisTypes.Count() != 4)
{
dbError = "Database is Empty. Initialization error. Please delete DB and reload";
configLoaded = false;
}
else
isOk = true;
}
}
return isOk;
}
public static void ChangeAssets(SEGRepository segR)
{
List<Item> dtItems = DiagnosticsHelper.GetStandardsForType(segR, "Mechanical");
using (SEGContext seg = segR.GetContext())
{
List<Asset> assets = seg.Assets.ToList();
foreach(Asset a in assets)
{
Diagnostics d = DiagnosticsHelper.GetMechanicalDiagnostics(segR,a.Id);
List<DiagnosticsDetail> dL = DiagnosticsHelper.GetDiagnosticsDetails(segR, d.Id);
// Go through each of the items
foreach(Item i in dtItems)
{
DiagnosticsDetail ddl = seg.DiagnosticsDetails.FirstOrDefault(x => x.DiagnosticsId == d.Id && x.ItemId == i.Id);
if(ddl==null)
{
// We need to add this diagnostics detail
DiagnosticsDetail dd = new DiagnosticsDetail();
dd.Comments = "";
dd.DiagnosticsId = d.Id;
dd.EntryDate = DateTime.MinValue;
dd.ExecutorId = Guid.Empty;
dd.ImageId = Guid.Empty;
dd.ItemId = i.Id;
dd.Status = "_new_";
dd.VerifierId = Guid.Empty;
dd.VerifyDate = DateTime.MinValue;
seg.DiagnosticsDetails.Add(dd);
}
}
seg.SaveChanges();
Console.WriteLine("Asset:" + a.Id);
}
}
}
public static void SaveDiagnosticsImage(SEGRepository segR, Guid diagId, Guid imgId)
{
using (SEGContext seg = segR.GetContext())
{
List<DiagnosticsImages> imgs = seg.DiagnosticsImages.Where(x=>x.DiagnosticID == diagId).ToList();
int nextOrder = 1;
if(imgs.Count>0)
nextOrder = seg.DiagnosticsImages.Where(x=>x.DiagnosticID == diagId).OrderBy(x=>x.Order).ToList().Last().Order+1;
DiagnosticsImages ih = new DiagnosticsImages();
ih.ImageId = imgId;
ih.DiagnosticID = diagId;
ih.Order = nextOrder;
seg.DiagnosticsImages.Add(ih);
seg.SaveChanges();
}
}
public static void ModifyDetails(SEGRepository segR, Guid diId, string newStatus, string newComments, Guid newImgId)
{
using (SEGContext seg = segR.GetContext())
{
DiagnosticsDetail di = seg.DiagnosticsDetails.FirstOrDefault(x => x.Id == diId);
if(di.ImageId!=newImgId && di.ImageId!=Guid.Empty)
{
Image img = seg.Images.FirstOrDefault(x=>x.Id == di.ImageId);
seg.Images.Remove(img);
}
di.ImageId = newImgId;
di.Comments = newComments;
di.Status = newStatus;
seg.SaveChanges();
}
}
public static List<Item> GetStandardsForType(SEGRepository segR, string standardsType)
{
List<Item> dtItems = new List<Item>();
using (SEGContext seg = segR.GetContext())
{
ItemClass ic = seg.ItemClasses.FirstOrDefault(a => a.Name == standardsType);
dtItems = seg.Items.Where(x => x.ItemClassId == ic.Id).OrderBy(x => x.Index).ToList();
}
return dtItems;
}
public static Diagnostics GetMechanicalDiagnostics(SEGRepository segR, Guid assetId)
{
Diagnostics d = null;
using (SEGContext seg = segR.GetContext())
{
DiagnosticsType dt = seg.DiagnosticsTypes.FirstOrDefault(t => t.Name == "Mechanical");
d = seg.Diagnostics.FirstOrDefault(a => a.AssetId == assetId && a.DiagnosticsTypeId == dt.Id);
}
return d;
}
public static ItemSubSection GetItemSubSection(SEGRepository segR, Guid id)
{
ItemSubSection item = null;
using (SEGContext seg = segR.GetContext())
{
item = seg.ItemSubSections.FirstOrDefault(x => x.Id == id);
}
return item;
}
public static Item GetItem(SEGRepository segR, Guid iId)
{
Item item = null;
using (SEGContext seg = segR.GetContext())
{
item = seg.Items.FirstOrDefault(x => x.Id == iId);
}
return item;
}
public static void AddElectricalDiagnostics(SEGRepository segR, Guid assetId)
{
List<Diagnostics> electrical = DiagnosticsHelper.GetElectricalDiagnostics(segR,assetId).ToList();
int nextIndex = 1;
if(electrical.Count>0)
{
nextIndex = electrical.OrderBy(x => x.Index).Last().Index + 1;
}
using (SEGContext seg = segR.GetContext())
{
DiagnosticsType dtEle = seg.DiagnosticsTypes.FirstOrDefault(a => a.Name == "Electrical");
ItemClass icEle = seg.ItemClasses.FirstOrDefault(a => a.Name == "Electrical");
List<Item> dtEItems = seg.Items.Where(x => x.ItemClassId == icEle.Id).OrderBy(x => x.Index).ToList();
// Asset info
AssetInfo ai = new AssetInfo();
ai.Key = "EDIAG_" + nextIndex + "_INFO1";
ai.Value = "";
ai.AssetId = assetId;
seg.AssetInfos.Add(ai);
ai = new AssetInfo();
ai.Key = "EDIAG_" + nextIndex + "_INFO2";
ai.Value = "";
ai.AssetId = assetId;
seg.AssetInfos.Add(ai);
ai = new AssetInfo();
ai.Key = "EDIAG_" + nextIndex + "_INFO3";
ai.Value = "";
ai.AssetId = assetId;
seg.AssetInfos.Add(ai);
ai = new AssetInfo();
ai.Key = "EDIAG_" + nextIndex + "_INFO4";
ai.Value = "";
ai.AssetId = assetId;
seg.AssetInfos.Add(ai);
// Mechanical Diagnostics
Diagnostics d = new Diagnostics();
d.AreaId = Guid.Empty;
d.AssetId = assetId;
d.Index = nextIndex;
d.DiagnosticsTypeId = dtEle.Id;
seg.Diagnostics.Add(d);
seg.SaveChanges();
foreach (Item i in dtEItems)
{
DiagnosticsDetail dd = new DiagnosticsDetail();
dd.Comments = "";
dd.DiagnosticsId = d.Id;
dd.EntryDate = DateTime.MinValue;
dd.ExecutorId = Guid.Empty;
dd.ImageId = Guid.Empty;
dd.ItemId = i.Id;
dd.Status = "_new_";
dd.VerifierId = Guid.Empty;
dd.VerifyDate = DateTime.MinValue;
seg.DiagnosticsDetails.Add(dd);
}
seg.SaveChanges();
}
}
public static List<Image> GetDiagnosticsImages(SEGRepository segR, Guid diagId)
{
List<Image> imgs = new List<Image>();
using (SEGContext seg = segR.GetContext())
{
List<DiagnosticsImages> di = seg.DiagnosticsImages.Where(x => x.DiagnosticID == diagId).ToList();
foreach(DiagnosticsImages d in di)
{
Image i = seg.Images.FirstOrDefault(x => x.Id == d.ImageId);
ImageHelper.FillImage(i);
imgs.Add(i);
}
}
return imgs;
}
public static List<DiagnosticsDetail> GetDiagnosticsDetails(SEGRepository segR, Guid dId)
{
List<DiagnosticsDetail> dd = new List<DiagnosticsDetail>();
using (SEGContext seg = segR.GetContext())
{
dd = seg.DiagnosticsDetails.Where(a => a.DiagnosticsId == dId).ToList();
}
return dd;
}
public static DiagnosticsDetail GetDiagnosticsDetail(SEGRepository segR, Guid diId)
{
DiagnosticsDetail di = null;
using (SEGContext seg = segR.GetContext())
{
di = seg.DiagnosticsDetails.FirstOrDefault(x => x.Id == diId);
}
return di;
}
public static void Load(SEGRepository segR)
{
Guid iId = ImageHelper.SaveImage(segR, @"Media\project_01.png");
List<Guid> assetImg = new List<Guid>();
for (int i = 1; i <= 135;i++ )
{
Guid gi = ImageHelper.SaveImage(segR, @"C:\Develop\SEG\Multimedia\Taschibra\Final\"+i.ToString()+".jpg");
assetImg.Add(gi);
}
Guid pId;
Guid uId;
using (SEGContext seg = segR.GetContext())
{
Project p = new Project();
p.Name = "Taschibra";
p.ImageId = iId;
p.Active = true;
seg.Projects.Add(p);
User u = new User();
u.Active = true;
u.FullName = "Isabela Paredes";
u.IsAdmin = true;
u.IsApprover = true;
u.IsExecutor = true;
u.IsVerifier = true;
u.Name = "isaparedes";
u.Password = "******";
seg.Users.Add(u);
seg.SaveChanges();
pId = p.Id;
uId = u.Id;
}
List<string> aNames = new List<string>();
List<Guid> aIds = new List<Guid>();
DiagnosticsType dtGen;
DiagnosticsType dtMec;
DiagnosticsType dtEle;
ItemClass icGen;
ItemClass icMec;
ItemClass icEle;
List<Item> dtGItems;
List<Item> dtMItems;
using (SEGContext seg = segR.GetContext())
{
aNames.Add("1. INJEÇÃO");
aNames.Add("2. MOAGEM");
aNames.Add("3. FERRAMENTARIA");
aNames.Add("4. PERFILADEIRA");
aNames.Add("5. PEÇAS ESPECIAIS");
aNames.Add("6. PINTURA");
aNames.Add("7. PINTURA COLORIDA");
aNames.Add("8. OFICINA");
aNames.Add("9. REFLETOR");
aNames.Add("10. ALMOXARIFADO");
aNames.Add("11. MONTAGEM");
aNames.Add("12. RETRABALHO");
aNames.Add("13. PEÇAS SOLTAS");
aNames.Add("14. MARCENARIA");
aNames.Add("15. RECICLAGEM");
aNames.Add("16. FIGURAS");
dtGen = seg.DiagnosticsTypes.FirstOrDefault(a => a.Name == "General");
dtMec = seg.DiagnosticsTypes.FirstOrDefault(a => a.Name == "Mechanical");
dtEle = seg.DiagnosticsTypes.FirstOrDefault(a => a.Name == "Electrical");
icGen = seg.ItemClasses.FirstOrDefault(a => a.Name == "General");
icMec = seg.ItemClasses.FirstOrDefault(a => a.Name == "Mechanical");
icEle = seg.ItemClasses.FirstOrDefault(a => a.Name == "Electrical");
dtGItems = seg.Items.Where(x => x.ItemClassId == icGen.Id).OrderBy(x => x.Index).ToList();
dtMItems = seg.Items.Where(x => x.ItemClassId == icMec.Id).OrderBy(x => x.Index).ToList();
}
using (SEGContext seg = segR.GetContext())
{
foreach (string s in aNames)
{
ProjectArea a = new ProjectArea();
a.ProjectId = pId;
a.Name = s;
a.ImageId = Guid.Empty;
a.Active = true;
seg.ProjectAreas.Add(a);
seg.SaveChanges();
aIds.Add(a.Id);
Diagnostics d = new Diagnostics();
d.AreaId = a.Id;
d.AssetId = Guid.Empty;
d.DiagnosticsTypeId = dtGen.Id;
d.Index = 0;
seg.Diagnostics.Add(d);
seg.SaveChanges();
foreach (Item i in dtGItems)
{
DiagnosticsDetail dd = new DiagnosticsDetail();
dd.Comments = "";
dd.DiagnosticsId = d.Id;
dd.EntryDate = DateTime.MinValue;
dd.ExecutorId = Guid.Empty;
dd.ImageId = Guid.Empty;
dd.ItemId = i.Id;
dd.Status = "_new_";
dd.VerifierId = Guid.Empty;
dd.VerifyDate = DateTime.MinValue;
seg.DiagnosticsDetails.Add(dd);
}
seg.SaveChanges();
}
}
using (SEGContext seg = segR.GetContext())
{
StreamReader sr = new StreamReader(@"Data\assets.txt", System.Text.Encoding.GetEncoding(1252), true);
int assetidx=0;
while (!sr.EndOfStream)
{
string sline = sr.ReadLine();
char[] delimiters = new char[] { '\t' };
string[] sitems = sline.Split(delimiters);
int aidx = Convert.ToInt32(sitems[1]);
string sid = sitems[2];
string stag = sitems[3];
string sdesc = sitems[4].Replace("\"", "").Trim();
Asset asset = new Asset();
asset.ProjectAreaId = aIds[aidx - 1];
asset.ExecutorId = uId;
asset.VerifierId = Guid.Empty;
asset.ApproverId = Guid.Empty;
asset.ImageId = assetImg[assetidx];
asset.EntryDate = DateTime.Now;
asset.VerifyDate = DateTime.MinValue;
asset.ApprovalDate = DateTime.MinValue;
seg.Assets.Add(asset);
seg.SaveChanges();
AssetInfo aInfo = new AssetInfo();
aInfo.AssetId = asset.Id;
aInfo.Key = "ID";
aInfo.Value = sid;
seg.AssetInfos.Add(aInfo);
aInfo = new AssetInfo();
aInfo.AssetId = asset.Id;
aInfo.Key = "TAG";
aInfo.Value = stag;
seg.AssetInfos.Add(aInfo);
aInfo = new AssetInfo();
aInfo.AssetId = asset.Id;
aInfo.Key = "LOCATION";
aInfo.Value = "";
seg.AssetInfos.Add(aInfo);
aInfo = new AssetInfo();
aInfo.AssetId = asset.Id;
aInfo.Key = "DESCRIPTION";
aInfo.Value = sdesc;
seg.AssetInfos.Add(aInfo);
// Mechanical Diagnostics
Diagnostics d = new Diagnostics();
d.AreaId = Guid.Empty;
d.AssetId = asset.Id;
d.Index = 0;
d.DiagnosticsTypeId = dtMec.Id;
seg.Diagnostics.Add(d);
seg.SaveChanges();
DiagnosticsImages di = new DiagnosticsImages();
di.DiagnosticID = d.Id;
di.ImageId = asset.ImageId;
di.Order = 0;
seg.DiagnosticsImages.Add(di);
seg.SaveChanges();
foreach (Item i in dtMItems)
{
DiagnosticsDetail dd = new DiagnosticsDetail();
dd.Comments = "";
dd.DiagnosticsId = d.Id;
dd.EntryDate = DateTime.MinValue;
dd.ExecutorId = Guid.Empty;
dd.ImageId = Guid.Empty;
dd.ItemId = i.Id;
dd.Status = "_new_";
dd.VerifierId = Guid.Empty;
dd.VerifyDate = DateTime.MinValue;
seg.DiagnosticsDetails.Add(dd);
}
seg.SaveChanges();
assetidx++;
}
}
}
public static void FixMechDiag(SEGRepository segR)
{
using (SEGContext seg = segR.GetContext())
{
DiagnosticsType dtGen = seg.DiagnosticsTypes.FirstOrDefault(a => a.Name == "General");
DiagnosticsType dtMec = seg.DiagnosticsTypes.FirstOrDefault(a => a.Name == "Mechanical");
DiagnosticsType dtEle = seg.DiagnosticsTypes.FirstOrDefault(a => a.Name == "Electrical");
ItemClass icGen = seg.ItemClasses.FirstOrDefault(a => a.Name == "General");
ItemClass icMec = seg.ItemClasses.FirstOrDefault(a => a.Name == "Mechanical");
ItemClass icEle = seg.ItemClasses.FirstOrDefault(a => a.Name == "Electrical");
bool hasSS = false;
int idx = 0;
ItemSection iS = null;
ItemSubSection iSS = null;
List<Item> fItems = seg.Items.Where(x => x.ItemClassId == icMec.Id).ToList();
List<ItemSection> fItemSections = new List<ItemSection>();
List<ItemSubSection> fItemSubSections = new List<ItemSubSection>();
foreach (Item i in fItems)
{
ItemSection aiS = null;
if(fItemSections.Count>0)
aiS = fItemSections.FirstOrDefault(x => x.Id == i.ItemSectionId);
if(aiS==null)
{
aiS = seg.ItemSections.FirstOrDefault(x => x.Id == i.ItemSectionId);
fItemSections.Add(aiS);
}
if (i.ItemSubSectionId != Guid.Empty)
{
ItemSubSection aiSS = null;
if (fItemSubSections.Count > 0)
aiSS = fItemSubSections.FirstOrDefault(x => x.Id == i.ItemSubSectionId);
if (aiSS == null)
{
aiSS = seg.ItemSubSections.FirstOrDefault(x => x.Id == i.ItemSubSectionId);
fItemSubSections.Add(aiSS);
}
}
}
StreamReader sr = new StreamReader(@"Data\mechanical2.txt", System.Text.Encoding.GetEncoding(1252), true);
while (!sr.EndOfStream)
{
string sline = sr.ReadLine();
char[] delimiters = new char[] { '\t' };
string[] sitems = sline.Split(delimiters);
// Let's see what the first value has
if (sitems[0] == "section")
{
iS = new ItemSection();
string scode = sitems[1].Trim();
iS.Code = scode;
iS.Title = sitems[5].Replace("\"", "").Trim();
// Now we try to find the code within fItemSections
if (fItemSections.FirstOrDefault(x => x.Code == iS.Code) == null)
{
// We now add it
seg.ItemSections.Add(iS);
seg.SaveChanges();
Console.WriteLine("Added Section :" + iS.Code);
}
else
iS = fItemSections.FirstOrDefault(x => x.Code == iS.Code);
hasSS = false;
}
else if (sitems[0] == "print")
{
iSS = new ItemSubSection();
iSS.ItemSectionId = iS.Id;
string scode = sitems[1].Trim();
scode = scode + "." + sitems[2].Trim();
// Check if item 3 is a 0 or empty
if (sitems[3].Trim() == "0" || sitems[3].Trim() == "")
{
// Nothing
}
else
{
scode = scode + "." + sitems[3].Trim();
}
if (sitems[4].Trim().Length > 0)
{
scode = scode + "|" + sitems[4].Trim();
}
else
{
// Nothing
}
iSS.Code = scode;
iSS.Title = sitems[5].Replace("\"", "").Trim();
// Now we try to find the code within fItemSections
if (fItemSubSections.FirstOrDefault(x => x.Code == iSS.Code) == null)
{
// We now add it
seg.ItemSubSections.Add(iSS);
seg.SaveChanges();
Console.WriteLine("Added SubSection :" + iSS.Code);
}
else
iSS = fItemSubSections.FirstOrDefault(x => x.Code == iSS.Code);
hasSS = false;
}
else
{
// Check code, and based on the last item, see if it is in SS or not
string scode = sitems[1].Trim();
scode = scode + "." + sitems[2].Trim();
// Check if item 3 is a 0
if (sitems[3].Trim() == "0" || sitems[3].Trim() == "")
{
// Nothing
}
else
{
scode = scode + "." + sitems[3].Trim();
}
if (sitems[4].Trim().Length > 0)
{
scode = scode + "|" + sitems[4].Trim();
hasSS = true;
}
else
{
hasSS = false;
}
Item i = new Item();
i.Index = idx;
i.ItemSectionId = iS.Id;
if (hasSS)
i.ItemSubSectionId = iSS.Id;
else
i.ItemSubSectionId = Guid.Empty;
i.ItemClassId = icMec.Id;
i.Code = scode;
i.Title = sitems[5].Replace("\"", "").Trim();
if (fItems.FirstOrDefault(x => x.Code == i.Code) == null)
{
// We now add it
seg.Items.Add(i);
seg.SaveChanges();
Console.WriteLine("Added Item :" + i.Code);
}
else
{
i = seg.Items.FirstOrDefault(x => x.Code == i.Code && x.ItemClassId == icMec.Id);
i.Index = idx;
seg.SaveChanges();
}
idx++;
}
}
sr.Close();
}
}
public static Diagnostics GetAreaDiagnostics(SEGRepository segR, Guid areaId)
{
Diagnostics d = null;
using (SEGContext seg = segR.GetContext())
{
d = seg.Diagnostics.FirstOrDefault(x => x.AreaId == areaId);
}
return d;
}
public static List<Diagnostics> GetElectricalDiagnostics(SEGRepository segR, Guid assetId)
{
List<Diagnostics> d = null;
using (SEGContext seg = segR.GetContext())
{
DiagnosticsType dt = seg.DiagnosticsTypes.FirstOrDefault(t => t.Name == "Electrical");
d = seg.Diagnostics.Where(a => a.AssetId == assetId && a.DiagnosticsTypeId == dt.Id).ToList();
}
return d;
}
