public static void CreateIctusDataTMPCollection2() { List <ictusDataTMP> ictusDataList = IctusDBManager.GetAllictusDataTMP(); if (ictusDataList != null && ictusDataList.Count() > 0) { ncLog.Message("Nº rows ictusDataList:" + ictusDataList.Count()); int cont = 0; foreach (ictusDataTMP iter in ictusDataList) { ictusDataTMP2 newIctusDataTMP = new ictusDataTMP2(iter); if (!newIctusDataTMP.IsOk()) { ncLog.Error("Unable to create newIctusDataTMP2 for pacienteID:" + iter.pacienteID); } else { if (!IctusDBManager.NewIctusDataTMP2(newIctusDataTMP)) { ncLog.Error("Unable to insert newIctusDataTMP2 for pacienteID:" + newIctusDataTMP.pacienteID); } else { ++cont; ncLog.Message("Inserted ictusDataTMP2 nº:" + cont); } } } } }
public static void DifferentUSVB() { List <ictusDataTMP> ictusDataTMPList = IctusDBManager.GetAllictusDataTMP(); if (ictusDataTMPList != null && ictusDataTMPList.Count() > 0) { List <string> usbList = ictusDataTMPList.Select(x => x.usvb_nombre).Distinct().ToList(); int svbN = ictusDataTMPList.Where(x => x.usvb_nombre.Contains("SVB") || x.usvb_nombre.Contains("ACU")).Count(); int umeN = ictusDataTMPList.Where(x => x.usvb_nombre.Contains("UME") || x.usvb_nombre.Contains("UVI") || x.usvb_nombre.Contains("VIR")).Count(); int heliN = ictusDataTMPList.Where(x => x.usvb_nombre.Contains("HELI")).Count(); ncLog.Message("DifferentUSVB::svbN:" + svbN + " - umeN:" + umeN + "heliN:" + heliN); Dictionary <int, List <ictusDataTMP> > svbMpa = ictusDataTMPList.Where(x => x.usvb_nombre.Contains("SVB") || x.usvb_nombre.Contains("ACU")).GroupBy(x => x.fecha.Year).ToDictionary(y => y.Key, y => y.ToList()); Dictionary <int, List <ictusDataTMP> > umeMap = ictusDataTMPList.Where(x => x.usvb_nombre.Contains("UME") || x.usvb_nombre.Contains("UVI") || x.usvb_nombre.Contains("VIR")).GroupBy(x => x.fecha.Year).ToDictionary(y => y.Key, y => y.ToList()); Dictionary <int, List <ictusDataTMP> > heliMap = ictusDataTMPList.Where(x => x.usvb_nombre.Contains("HELI")).GroupBy(x => x.fecha.Year).ToDictionary(y => y.Key, y => y.ToList()); string msg = string.Empty; foreach (KeyValuePair <int, List <ictusDataTMP> > iter in svbMpa) { msg += "\r\nAño:" + iter.Key + " - Nº Registrsos:" + iter.Value.Count(); } ncLog.Message("SVBMap::" + msg); msg = string.Empty; foreach (KeyValuePair <int, List <ictusDataTMP> > iter in umeMap) { msg += "\r\nAño:" + iter.Key + " - Nº Registrsos:" + iter.Value.Count(); } ncLog.Message("umeMap::" + msg); msg = string.Empty; foreach (KeyValuePair <int, List <ictusDataTMP> > iter in heliMap) { msg += "\r\nAño:" + iter.Key + " - Nº Registrsos:" + iter.Value.Count(); } ncLog.Message("heliMap::" + msg); int a = 0; } }
public static bool LoaumeDataTMP() { bool result = false; try { umeDataTMPList = IctusDBManager.GetAllUmeDataTMP(); if (umeDataTMPList != null && umeDataTMPList.Count() != 0) { result = true; } } catch (Exception exp) { ncLog.Exception("LoaumeDataTMP::" + exp.Message); } return(result); }
private void btUpdateDB_Click(object sender, EventArgs e) { IctusDBManager.DropIctusData(); ncLog.Message("ClearDB::Ictus data collection has been deleted"); List <ictusData> ictusDataColletion = IctusDBManager.GetAllictusData(); if (ictusDataColletion != null && ictusDataColletion.Count() > 0) { ncLog.Warning("LoadDB::ictusData collections is not empty. You must remove it!! Nº documents:" + ictusDataColletion.Count()); return; } ictusDataColletion.Clear(); foreach (KeyValuePair <long, List <umeDataTMP> > iter in Util.ictusDataMap) { ictusData newIctusdata = new ictusData(iter.Key, iter.Value); if (newIctusdata.IsOk()) { ictusDataColletion.Add(newIctusdata); } } ncLog.Message("LoadDB::Nº rows ictusDataColletion:[" + ictusDataColletion.Count() + "]"); foreach (ictusData iter in ictusDataColletion) { if (!IctusDBManager.NewIctusData(iter)) { ncLog.Error("LoadDB::Unable to insert new ictusData for pacienteID:" + iter.pacienteID); } } List <ictusData> ictusDataInDB = IctusDBManager.GetAllictusData(); ncLog.Message("LoadDB::Nº rows inserted:[" + ictusDataInDB.Count() + "]"); }
public static bool LoadHospitalList() { bool result = false; try { hospitalList = IctusDBManager.GetAllHospitales(); if (hospitalList != null && hospitalList.Count() != 0) { result = true; } else { ncLog.Error("LoadHospitalList::Unable to load Hospitales from database"); } } catch (Exception exp) { ncLog.Exception("LoadHospitalList::" + exp.Message); } return(result); }
public static void InfoDifferentCIE() { Dictionary <long, List <umeDataTMP> > result = new Dictionary <long, List <umeDataTMP> >(); try { List <umeDataTMP> umeDataTMPList = IctusDBManager.GetAllUmeDataTMP(); if (umeDataTMPList == null || umeDataTMPList.Count() == 0) { ncLog.Error("InfoDifferentCIE::Null or empty umeDataTMPList!!"); return; } string msg = "ID,CIE1,Responsable1,CIE2, Responsable2"; Dictionary <long, List <umeDataTMP> > umeDataTMPMap = umeDataTMPList.GroupBy(x => x.inc_id).ToDictionary(y => y.Key, y => y.ToList()); if (umeDataTMPMap != null && umeDataTMPMap.Count() != 0) { foreach (KeyValuePair <long, List <umeDataTMP> > iter in umeDataTMPMap) { long pacienteID = iter.Key; List <string> cieGroup = iter.Value.Select(x => x.cie_codigo).Distinct().ToList(); if (cieGroup != null && cieGroup.Count() > 1) { msg += "\r\n" + pacienteID; int size = cieGroup.Count; int counter = 1; foreach (string iterCie in cieGroup) { if (size == 3) { if (counter == 2) { ++counter; continue; } } umeDataTMP dataFound = iter.Value.Where(x => x.cie_codigo == iterCie).FirstOrDefault(); msg += "," + iterCie + "," + dataFound.dim_responsable_nombre; ++counter; } msg += "," + iter.Value.FirstOrDefault().inc_sello_temporal.Year; } } } ncLog.Message(msg); } catch (Exception exp) { ncLog.Exception("InfoDifferentCIE::" + exp.Message); } }
private void btClearDB_Click(object sender, EventArgs e) { IctusDBManager.DropIctusData(); ncLog.Message("ClearDB::Ictus data collection has been deleted"); }
private void btLoadZBS_Click(object sender, EventArgs e) { try { using (OpenFileDialog openFileDialog = new OpenFileDialog()) { openFileDialog.Filter = "Excel files (*.xls)|*.xls|All files (*.*)|*.*"; openFileDialog.FilterIndex = 2; openFileDialog.RestoreDirectory = true; if (openFileDialog.ShowDialog() == DialogResult.OK) { //Get the path of specified file string filePath = openFileDialog.FileName; txtZBSPath.Text = filePath; ncLog.Message("ExcelPath:" + filePath); Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.Application(); Microsoft.Office.Interop.Excel.Workbook wb = app.Workbooks.Open(filePath, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing); Worksheet sheet = (Worksheet)wb.Sheets["ZBS"]; Range excelRange = sheet.UsedRange; int nRows = excelRange.Rows.Count; ncLog.Message("Nº Rows:" + nRows); foreach (Microsoft.Office.Interop.Excel.Range row in excelRange.Rows) { int rowNumber = row.Row; if (rowNumber != 1) //Headers { string[] arrayAG = Util.GetRange("A" + rowNumber + ":G" + rowNumber + "", sheet); zbs newZBS = new zbs(arrayAG); if (!newZBS.IsOk()) { ncLog.Error("LoadZBS::Unable to create ZBS object row number:" + rowNumber); continue; } if (IctusDBManager.NewZBS(newZBS)) { ncLog.Message("LoadZBS::Inserted row number:" + rowNumber); } else { ncLog.Message("LoadZBS::Unable to insert row number:" + rowNumber); } } } } } } catch (Exception exp) { ncLog.Exception("LoadZBS::" + exp.Message); } }
//private void btLoadDatosUME_Click(object sender, EventArgs e) //{ // try // { // if(!Util.LoadDataMasterList()) // { // ncLog.Error("LoadDatosUME::Unable to load data master in memory. We can NOT continue!!!"); // return; // } // using (OpenFileDialog openFileDialog = new OpenFileDialog()) // { // //openFileDialog.InitialDirectory = "c:\\"; // openFileDialog.Filter = "Excel files (*.xls)|*.xls|All files (*.*)|*.*"; // openFileDialog.FilterIndex = 2; // openFileDialog.RestoreDirectory = true; // if (openFileDialog.ShowDialog() == DialogResult.OK) // { // //Get the path of specified file // string filePath = openFileDialog.FileName; // txtDatosUME.Text = filePath; // ncLog.Message("ExcelPath:" + filePath); // Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.Application(); // Microsoft.Office.Interop.Excel.Workbook wb = app.Workbooks.Open(filePath, Type.Missing, Type.Missing, Type.Missing, Type.Missing, // Type.Missing, Type.Missing, Type.Missing, Type.Missing, // Type.Missing, Type.Missing, Type.Missing, Type.Missing, // Type.Missing, Type.Missing); // int sheetsNumber = wb.Sheets.Count; //11 => from 11 to 1 // //From sheetsNumber to 1 => From 2008 to 2018 // for (int iter = sheetsNumber; iter >= 1; --iter) // { // Worksheet sheet = (Worksheet)wb.Sheets[iter]; // Range excelRange = sheet.UsedRange; // int nRows = excelRange.Rows.Count; // ncLog.Message("Sheet:[" + sheet.Name + "] - Nº Rows:" + nRows); // foreach (Microsoft.Office.Interop.Excel.Range row in excelRange.Rows) // { // int rowNumber = row.Row; // if (rowNumber != 1) //Headers // { // string[] arrayAO = GetRange("A" + rowNumber + ":O" + rowNumber + "", sheet); // umeData newUmeData = new umeData(arrayAO); // if (!newUmeData.IsOk()) // { // ncLog.Error("LoadUMEData::Unable to create USVB object row number:" + rowNumber); // continue; // } // if (IctusDBManager.NewUmeData(newUmeData)) // { // ncLog.Message("LoadUMEData::Inserted row number:" + rowNumber); // } // else // { // ncLog.Message("LoadUMEData::Unable to insert row number:" + rowNumber); // } // } // } // } // } // } // } // catch (Exception exp) // { // ncLog.Exception("LoadHospitales::" + exp.Message); // } //} private void btLoadDatosUME_Click(object sender, EventArgs e) { try { if (!Util.LoadDataMasterList()) { ncLog.Error("LoadDatosUME::Unable to load data master in memory. We can NOT continue!!!"); return; } using (OpenFileDialog openFileDialog = new OpenFileDialog()) { //openFileDialog.InitialDirectory = "c:\\"; openFileDialog.Filter = "Excel files (*.xls)|*.xls|All files (*.*)|*.*"; openFileDialog.FilterIndex = 2; openFileDialog.RestoreDirectory = true; if (openFileDialog.ShowDialog() == DialogResult.OK) { //Get the path of specified file string filePath = openFileDialog.FileName; txtDatosUME.Text = filePath; ncLog.Message("ExcelPath:" + filePath); Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.Application(); Microsoft.Office.Interop.Excel.Workbook wb = app.Workbooks.Open(filePath, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing); int sheetsNumber = wb.Sheets.Count; //11 => from 11 to 1 sheetsNumber = sheetsNumber - 2; //Because 2008 and 2009 are inserted yet //From sheetsNumber to 1 => From 2008 to 2018 for (int iter = sheetsNumber; iter >= 1; --iter) { Worksheet sheet = (Worksheet)wb.Sheets[iter]; Range excelRange = sheet.UsedRange; int nRows = excelRange.Rows.Count; ncLog.Message("Sheet:[" + sheet.Name + "] - Nº Rows:" + nRows); foreach (Microsoft.Office.Interop.Excel.Range row in excelRange.Rows) { int rowNumber = row.Row; if (rowNumber != 1) //Headers { string[] arrayAO = Util.GetRange("A" + rowNumber + ":O" + rowNumber + "", sheet); umeDataTMP newUmeData = new umeDataTMP(arrayAO); if (newUmeData.inc_id == Int64.MinValue) { ncLog.Error("LoadUMEDataTMP::Unable to create umeDataTMP document for id:" + arrayAO[0]); continue; } if (IctusDBManager.NewUmeDataTMP(newUmeData)) { ncLog.Message("LoadUMEDataTMP::Inserted row number:" + rowNumber); } else { ncLog.Message("LoadUMEDataTMP::Unable to insert row number:" + rowNumber); } } } //iter = 1; //For only year 2008 } } } } catch (Exception exp) { ncLog.Exception("LoadHospitales::" + exp.Message); } }