private void butDeletesite_Click(object sender, EventArgs e) { if (lsvGroups.SelectedItems.Count > 0 && _error == false) //b { ForlabSite site = this.GetSelectedSite(); if (site != null && MessageBox.Show("Are you sure you want to delete this site?", "Delete Site", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { try { DataRepository.DeleteSite(site); DataRepository.CloseSession(); //b _region = DataRepository.GetRegionById(site.Region.Id); //b } catch (Exception ex) { _error = true; FrmShowError frm = new FrmShowError(new ExceptionStatus() { message = "Site could not be deleted.", ex = ex }); frm.ShowDialog(); LQTUserMessage msg = SaveOrUpdateObject();//added b this.Close(); } } DisplaySites(); } }
public void RegionPane(ForlabRegion region, bool enableCtr) { //this._region = region; this._enableCtr = enableCtr; SetControlState(); BindRegion(); }
void lqtToolStrip1_SaveAndNewClick(object sender, EventArgs e) { try { LQTUserMessage msg = SaveOrUpdateObject(); ((LqtMainWindowForm)_mdiparent).ShowStatusBarInfo(msg.Message, _reloadCtr); DataRepository.CloseSession(); ForlabRegion r = _site.Region; SiteCategory sc = _site.SiteCategory; _site = new ForlabSite(); _site.Region = r; _site.SiteCategory = sc; LoadSiteCtr(); _isedited = false; if (_site.SiteCategory != null)//b { comCategory.SelectedValue = _site.SiteCategory.Id; } } catch (Exception ex) { new FrmShowError(CustomExceptionHandler.ShowExceptionText(ex)).ShowDialog(); } }
public RegionPane(ForlabRegion region, bool enableCtr) { this._region = region; this._enableCtr = enableCtr; InitializeComponent(); SetControlState(); BindRegion(); }
private void PopRegion() { ForlabRegion r = new ForlabRegion(); r.RegionName = "--All--"; r.Id = 0; IList <ForlabRegion> regionList = DataRepository.GetAllRegion(); regionList.Insert(0, r); comRegion.DataSource = regionList; }
public RegionForm(ForlabRegion region, Form mdiparent) { this._region = region; this._mdiparent = mdiparent; InitializeComponent(); lqtToolStrip1.SaveAndCloseClick += new EventHandler(lqtToolStrip1_SaveAndCloseClick); lqtToolStrip1.SaveAndNewClick += new EventHandler(lqtToolStrip1_SaveAndNewClick); LoadRegionCtr();//b }
private void butNewsite_Click(object sender, EventArgs e) { if (CreateOrEditSite != null) { ForlabSite site = new ForlabSite(); site.Region = _region; CreateOrUpdateEventArgs eArgs = new CreateOrUpdateEventArgs(site); CreateOrEditSite(this, eArgs); _region = DataRepository.GetRegionById(site.Region.Id);//b } DisplaySites(); }
public override LQTUserMessage SaveOrUpdateObject() { ForlabRegion region = LqtUtil.GetComboBoxValue <ForlabRegion>(comRegion); if (txtName.Text.Trim() == string.Empty) { throw new LQTUserException("Site Name must not be empty."); } if (LqtUtil.GetComboBoxValue <ForlabRegion>(comRegion) == null) { throw new LQTUserException("A Region must be selected."); } if (DataRepository.GetSiteByName(txtName.Text.Trim(), LqtUtil.GetComboBoxValue <ForlabRegion>(comRegion).Id) != null && _site.Id <= 0) { throw new LQTUserException("The Site Name already exists in the region."); } if (txtworkingdays.Text.Trim() == string.Empty) { throw new LQTUserException("General Working Days Can not be empty."); } _site.SiteName = txtName.Text; _site.CD4TestingDaysPerMonth = int.Parse(txtCd4Td.Text); _site.ChemistryTestingDaysPerMonth = int.Parse(txtChemTd.Text); _site.HematologyTestingDaysPerMonth = int.Parse(txthemaTd.Text); _site.ViralLoadTestingDaysPerMonth = int.Parse(txtViralTd.Text); _site.OtherTestingDaysPerMonth = int.Parse(txtOtherTd.Text); _site.CD4RefSite = int.Parse(comCD4RefSite.Tag.ToString()); _site.ChemistryRefSite = int.Parse(comChemistryRefSite.Tag.ToString()); _site.HematologyRefSite = int.Parse(comHematologyRefSite.Tag.ToString()); _site.ViralLoadRefSite = int.Parse(comViralLoadRefSite.Tag.ToString()); _site.OtherRefSite = int.Parse(comOtheRefSite.Tag.ToString()); _site.WorkingDays = int.Parse(txtworkingdays.Text); if (_site.Region == null) { _site.Region = LqtUtil.GetComboBoxValue <ForlabRegion>(comRegion); } _site.SiteCategory = LqtUtil.GetComboBoxValue <SiteCategory>(comCategory); AddDefaultStatus(); DataRepository.SaveOrUpdateSite(_site); return(new LQTUserMessage("Site was saved or updated successfully.")); }
private void butEditsite_Click(object sender, EventArgs e) { if (lsvGroups.SelectedItems.Count > 0 && _error == false) //b { if (CreateOrEditSite != null) { ForlabSite site = GetSelectedSite(); //b CreateOrUpdateEventArgs eArgs = new CreateOrUpdateEventArgs(site); //(GetSelectedSite());//b CreateOrEditSite(this, eArgs); _region = DataRepository.GetRegionById(site.Region.Id); //b } DisplaySites(); } }
private void PopRegion() { try { IList <ForlabRegion> regions = DataRepository.GetAllRegion(); ForlabRegion region = new ForlabRegion(); region.Id = 0; region.RegionName = "--Select Region Here--"; regions.Insert(0, region); comregion.DataSource = regions; } catch (Exception ex) { } }
void lqtToolStrip1_SaveAndNewClick(object sender, EventArgs e) { try { //LQTUserMessage msg = _rPane.SaveOrUpdateObject();//b LQTUserMessage msg = SaveOrUpdateObject();//added b ((LqtMainWindowForm)_mdiparent).ShowStatusBarInfo(msg.Message); DataRepository.CloseSession(); ((LqtMainWindowForm)_mdiparent).BuildNavigationMenu(); _region = new ForlabRegion(); LoadRegionCtr(); ((LqtMainWindowForm)_mdiparent).BuildNavigationMenu(); } catch (Exception ex) { new FrmShowError(CustomExceptionHandler.ShowExceptionText(ex)).ShowDialog(); } }
private void butSave_Click(object sender, EventArgs e) { int count = 0; int error = 0; try { foreach (RegionReportedData rd in _rdata) { if (!rd.IsExist) { if (!rd.HasError) { ForlabRegion region = new ForlabRegion(); region.RegionName = rd.RegionName; region.ShortName = rd.ShortName; count++; DataRepository.SaveOrUpdateRegion(region); } else { error++; } } else { error++; } } MessageBox.Show(count + " Regions/Districts/Provinces are imported and saved successfully." + Environment.NewLine + error + " Regions/Districts/Provinces Failed.", "Importing", MessageBoxButtons.OK, MessageBoxIcon.Information); this.DialogResult = System.Windows.Forms.DialogResult.OK; this.Close(); } catch { MessageBox.Show("Error: Unable to import and save Region/District/Province data.", "Importing", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { DataRepository.CloseSession(); } }
private void comregion_SelectedIndexChanged(object sender, EventArgs e) { if (comregion.Text == "--Select Region Here--") { _regionId = 0; } else { if (LqtUtil.GetComboBoxValue <ForlabRegion>(comregion) != null) { _selectedRegion = LqtUtil.GetComboBoxValue <ForlabRegion>(comregion); _regionId = _selectedRegion.Id; } else { _regionId = 0; } } BindDataToChart(); }
private IList <ReportedData> GetDataRow(DataSet ds) { string categoryName = null; string regionName; string siteName; string testName; string duration; decimal amount; int stockout; int instrumentDownTime; decimal adjusited; int rowno = 0; bool haserror; string cName = ""; string rName = ""; string sName = ""; string tName = ""; ForecastCategory fcategory = null; ForlabRegion region = null; ForlabSite site = null; //MasterProduct product = null; Test test = null; string errorDescription = ""; IList <ReportedData> rdlist = new List <ReportedData>(); DataRow dr = ds.Tables[0].Rows[0]; //foreach (DataRow dr in ds.Tables[0].Rows) //{ for (int i = 1; i < ds.Tables[0].Rows.Count; i = i + 4) { rowno++; haserror = false; DataRow dr1 = ds.Tables[0].Rows[i]; DataRow dr2 = ds.Tables[0].Rows[i + 1]; DataRow dr3 = ds.Tables[0].Rows[i + 2]; DataRow dr4 = ds.Tables[0].Rows[i + 3]; DataRow g = ds.Tables[0].Rows[0]; // int colid = 0; int f = 3; int colid; //0 if (_forecastInfo.DatausageEnum == DataUsageEnum.DATA_USAGE3) { colid = 3; } else { colid = 4; } do { regionName = ""; siteName = ""; if (_forecastInfo.DatausageEnum == DataUsageEnum.DATA_USAGE3) { categoryName = Convert.ToString(dr1[0]).Trim(); //(dr[colid++]) testName = Convert.ToString(dr1[1]).Trim(); //(dr[colid++])testName } else { regionName = Convert.ToString(dr1[0]).Trim(); //(dr[colid++]) region name siteName = Convert.ToString(dr1[1]).Trim(); //(dr[colid++]) site name testName = Convert.ToString(dr1[2]).Trim(); //(dr[colid++])testName } if (_forecastInfo.PeriodEnum != ForecastPeriodEnum.Monthly || _forecastInfo.PeriodEnum != ForecastPeriodEnum.Bimonthly) { duration = Convert.ToString(DateTime.FromOADate(Convert.ToDouble(dr[colid])));//(g[f]) Convert.ToString(dr[colid++]); // reporting period(duration) } // f = f + 3; else { duration = Convert.ToString(dr[colid]); } //duration = Convert.ToString(dr[colid++]); // reporting period(duration) try { if (dr1[colid].ToString() == string.Empty) { amount = 0; } else { amount = Convert.ToDecimal(dr1[colid]); //amount } ///if (amount == 0) // haserror = true; } catch { haserror = true; amount = 0; } try { if (dr2[colid].ToString() == string.Empty) { stockout = 0; } else { stockout = Convert.ToInt32(dr2[colid]); //stock out } } catch { haserror = true; stockout = 0; } try { if (dr3[colid].ToString() == string.Empty) { instrumentDownTime = 0; } else { instrumentDownTime = Convert.ToInt32(dr3[colid]); //instrumentDownTime } } catch { haserror = true; instrumentDownTime = 0; } //try //{ // adjusited = Convert.ToDecimal(dr[colid++]); //adjusted //} //catch //{ // haserror = true; adjusited = 0; // } ReportedData rd = null; if (_forecastInfo.DatausageEnum == DataUsageEnum.DATA_USAGE3) { rd = new ReportedData(categoryName, rowno, testName, duration, amount, stockout, instrumentDownTime); if (cName != categoryName) { if (!string.IsNullOrEmpty(categoryName)) { fcategory = DataRepository.GetForecastCategoryByName(_forecastInfo.Id, categoryName); } else { fcategory = null; } cName = categoryName; } if (fcategory != null) { rd.Category = fcategory; } else { rd.HasError = true; errorDescription = errorDescription + " Category Doesn't Exist"; } } else { rd = new ReportedData(regionName, rowno, siteName, testName, duration, amount, stockout, instrumentDownTime); if (rName != regionName) { if (!string.IsNullOrEmpty(regionName)) { region = DataRepository.GetRegionByName(regionName); } else { region = null; } rName = regionName; } if (region != null) { rd.Region = region; if (sName != siteName) { if (!string.IsNullOrEmpty(siteName)) { site = DataRepository.GetSiteByName(siteName, region.Id); } else { site = null; } sName = siteName; } if (site != null) { rd.Site = site; } else { haserror = true; errorDescription = errorDescription + " Site Doesn't Exist"; } } else { haserror = true; errorDescription = errorDescription + " Region Doesn't Exist"; } } if (tName != testName) { if (!string.IsNullOrEmpty(testName)) { test = DataRepository.GetTestByName(testName); } else { test = null; } tName = testName; } if (test != null) { rd.Test = test; } else { haserror = true; errorDescription = errorDescription + " Test Doesn't Exist"; } rd.HasError = haserror; rd.ErrorDescription = errorDescription; rdlist.Add(rd); colid++; errorDescription = ""; }while (colid < g.ItemArray.Length && g[colid].ToString() != "");// dr.ItemArray.Length / ds.Tables[0].Rows.Count); } return(rdlist); }
public void RebindRegion(ForlabRegion region) { this._region = region; BindRegion(); }
private IList <SiteImportData> GetDataRow(DataSet ds) { string regionName; string categoryName; string siteName; string siteLevel; DateTime? openDate; string rName = ""; ForlabRegion region = null; string cName = ""; SiteCategory siteCategory = null; int workingDays; int Cd4Td; int ChemTd; int hemaTd; int ViralTd; int OtherTd; int rowno = 0; bool haserror; IList <SiteImportData> rdlist = new List <SiteImportData>(); foreach (DataRow dr in ds.Tables[0].Rows) { string errorDescription = ""; rowno++; haserror = false; regionName = Convert.ToString(dr[0]).Trim(); //region name categoryName = Convert.ToString(dr[1]).Trim(); //site category name siteName = Convert.ToString(dr[2]).Trim(); //short name siteLevel = Convert.ToString(dr[3]); //Site Level try { workingDays = int.Parse(Convert.ToString(dr[4])); if (workingDays > 31) { haserror = true; errorDescription = errorDescription + " Working Days Can't Be More Than 31 Days"; } } catch { workingDays = 22; } try { Cd4Td = int.Parse(Convert.ToString(dr[5])); if (Cd4Td > 31 || Cd4Td > workingDays) { haserror = true; errorDescription = errorDescription + " CD4 Testing Days Can't Be More Than 31 Days or Working Days";//14 may 14 } } catch { Cd4Td = 0; } try { ChemTd = int.Parse(Convert.ToString(dr[6])); if (ChemTd > 31 || ChemTd > workingDays) { haserror = true; errorDescription = errorDescription + " Chemistry Testing Days Can't Be More Than 31 Days or Working Days"; } } catch { ChemTd = 0; } try { hemaTd = int.Parse(Convert.ToString(dr[7])); if (hemaTd > 31 || hemaTd > workingDays) { haserror = true; errorDescription = errorDescription + " Hematology Testing Days Can't Be More Than 31 Days or Working Days"; } } catch { hemaTd = 0; } try { ViralTd = int.Parse(Convert.ToString(dr[8])); if (ViralTd > 31 || ViralTd > workingDays) { haserror = true; errorDescription = errorDescription + " ViralLoad Testing Days Can't Be More Than 31 Days or Working Days"; } } catch { ViralTd = 0; } try { OtherTd = int.Parse(Convert.ToString(dr[9])); if (OtherTd > 31 || OtherTd > workingDays) { haserror = true; errorDescription = errorDescription + " Testing Days Can't Be More Than 31 Days or Working Days"; } } catch { OtherTd = 0; } try { openDate = Convert.ToDateTime(dr[10]); } catch { openDate = null; } SiteImportData rd = new SiteImportData(rowno, regionName, categoryName, siteName, siteLevel, workingDays, Cd4Td, ChemTd, hemaTd, ViralTd, OtherTd, openDate); if (rName != regionName) { if (!string.IsNullOrEmpty(regionName)) { region = DataRepository.GetRegionByName(regionName); } else { region = null; } rName = regionName; } if (region != null) { rd.Region = region; if (!String.IsNullOrEmpty(siteName)) { rd.IsExist = DataRepository.GetSiteByName(siteName, region.Id) != null; } else { haserror = true; } } else { haserror = true; } if (!string.IsNullOrEmpty(categoryName)) { siteCategory = DataRepository.GetSiteCategoryByName(categoryName); if (siteCategory == null) { siteCategory = new SiteCategory(); siteCategory.CategoryName = categoryName; DataRepository.SaveOrUpdateSiteCategory(siteCategory); } } else { haserror = true; } cName = categoryName; if (siteLevel != "")//14 may 14 null)//b { string[] sitelevel = Enum.GetNames(typeof(SiteLevelEnum)); string sl = ""; bool level = false; for (int i = 0; i < sitelevel.Length; i++) { sl = sitelevel[i].Replace('_', ' '); if (siteLevel == sl) { rd.SiteLevel = siteLevel; level = true; break; } } if (!level) { haserror = true; errorDescription = errorDescription + " Is Not Valid Site Level"; } } else { haserror = true; } rd.Category = siteCategory; rd.Cd4Td = Cd4Td; rd.ChemTd = ChemTd; rd.HemaTd = hemaTd; rd.ViralTd = ViralTd; rd.OtherTd = OtherTd; rd.HasError = haserror; rd.ErrorDescription = errorDescription;//14 may 14 rdlist.Add(rd); } return(rdlist); }
private IList <RefSiteImportData> GetDataRow(DataSet ds) { string regionName; string siteName; string rName = ""; ForlabRegion region = null; ForlabSite site = null; string CD4RefSite; string ChemRefSite; string HemRefSite; string ViralRefSite; string OtherRefSite; int rowno = 0; bool haserror; ForlabSite refSite = null; int CD4RefSiteId = 0; int ChemRefSiteId = 0; int HemRefSiteId = 0; int ViralRefSiteId = 0; int OtherRefSiteId = 0; IList <ForlabSite> _referingSites = new List <ForlabSite>(); IList <ForlabSite> sites; IList <ForlabSite> _validsites = new List <ForlabSite>(); IList <RefSiteImportData> rdlist = new List <RefSiteImportData>(); foreach (DataRow dr in ds.Tables[0].Rows) { string errorDiscription = ""; rowno++; haserror = false; regionName = Convert.ToString(dr[0]).Trim(); //region namegory name siteName = Convert.ToString(dr[1]).Trim(); //short name try { CD4RefSite = Convert.ToString(dr[2]); } catch { CD4RefSite = ""; } try { ChemRefSite = Convert.ToString(dr[3]); } catch { ChemRefSite = ""; } try { HemRefSite = Convert.ToString(dr[4]); } catch { HemRefSite = ""; } try { ViralRefSite = Convert.ToString(dr[5]); } catch { ViralRefSite = ""; } try { OtherRefSite = Convert.ToString(dr[6]); } catch { OtherRefSite = ""; } RefSiteImportData rd = new RefSiteImportData(rowno, regionName, siteName, CD4RefSite, ChemRefSite, HemRefSite, ViralRefSite, OtherRefSite); if (rName != regionName) { if (!string.IsNullOrEmpty(regionName)) { region = DataRepository.GetRegionByName(regionName); } else { region = null; } rName = regionName; } if (region != null) { rd.Region = region; if (!String.IsNullOrEmpty(siteName)) { site = DataRepository.GetSiteByName(siteName, region.Id); if (site != null) { //if((site.CD4RefSite.ToString().Trim()==(dr[2]).ToString().Trim().ToLower())||(site.ChemistryRefSite.ToString().Trim().ToLower()==(dr[3]).ToString().Trim().ToLower())|| // (site.HematologyRefSite.ToString().Trim().ToLower()==(dr[4]).ToString().Trim().ToLower())||(site.ViralLoadRefSite.ToString().Trim().ToLower()==(dr[5]).ToString().Trim().ToLower())|| // (site.OtherRefSite.ToString().Trim().ToLower()==(dr[6]).ToString().Trim().ToLower())) // rd.IsExist=true; } else { errorDiscription = errorDiscription + " Site doesn't exist"; haserror = true; } } else { errorDiscription = errorDiscription + " Site name required"; haserror = true; } if (!haserror) { if (!String.IsNullOrEmpty(CD4RefSite)) { if ((ISValidReferralSite(CD4RefSite, siteName, "CD4", out refSite)) || (ISValidReferralSite(CD4RefSite, siteName, "Flow Cytometry", out refSite))) { CD4RefSiteId = refSite.Id; } else { haserror = true; CD4RefSiteId = -1; errorDiscription = errorDiscription + " Is Not Valid CD4 Referral Site";//14 may 14 } } if (!String.IsNullOrEmpty(ChemRefSite)) { if (ISValidReferralSite(ChemRefSite, siteName, "Chemistry", out refSite)) { ChemRefSiteId = refSite.Id; } else { haserror = true; ChemRefSiteId = -1; errorDiscription = errorDiscription + " Is Not Valid Chemistry Referral Site"; } } if (!String.IsNullOrEmpty(HemRefSite)) { if (ISValidReferralSite(HemRefSite, siteName, "Hematology", out refSite)) { HemRefSiteId = refSite.Id; } else { haserror = true; HemRefSiteId = -1; errorDiscription = errorDiscription + " Is Not Valid Hematology Referral Site"; } } if (!String.IsNullOrEmpty(ViralRefSite)) { if (ISValidReferralSite(ViralRefSite, siteName, "ViralLoad", out refSite)) { ViralRefSiteId = refSite.Id; } else { haserror = true; ViralRefSiteId = -1; errorDiscription = errorDiscription + " Is Not Valid ViralLoad Referral Site"; } } if (!String.IsNullOrEmpty(OtherRefSite)) { if (ISValidReferralSite(OtherRefSite, siteName, "Other", out refSite)) { OtherRefSiteId = refSite.Id; } else { haserror = true; OtherRefSiteId = -1; errorDiscription = errorDiscription + " Is Not Valid Referral Site"; } } } else { haserror = true; } } else { errorDiscription = errorDiscription + " Region doesn't exist"; haserror = true; } rd.CD4RefSiteId = CD4RefSiteId; rd.ChemistryRefSiteId = ChemRefSiteId; rd.HematologyRefSiteId = HemRefSiteId; rd.ViralLoadRefSiteId = ViralRefSiteId; rd.OtheRefSiteId = OtherRefSiteId; rd.HasError = haserror; if (rd.CD4RefSiteId == 0 && rd.ChemistryRefSiteId == 0 && rd.HematologyRefSiteId == 0 && rd.ViralLoadRefSiteId == 0 && rd.OtheRefSiteId == 0) { rd.HasError = true; errorDiscription = errorDiscription + " At least one referral site required"; } rd.ErrorDescription = errorDiscription;//14 may 14 rdlist.Add(rd); CD4RefSiteId = 0; ChemRefSiteId = 0; HemRefSiteId = 0; ViralRefSiteId = 0; OtherRefSiteId = 0; } return(rdlist); }
private void SaveInstrument() { instcount = 0; IList <SiteInstrument> resultin = new List <SiteInstrument>(); result = DataRepository.GetAllSite(); try { foreach (SiteInstrumentImportData rd in _siteinstrumentdata) { try { if (!rd.IsExist && !rd.HasError) { SiteInstrument sitein = new SiteInstrument(); ForlabRegion Inregion = DataRepository.GetRegionByName(rd.RegionName); if (Inregion == null) { rd.HasError = true; } ForlabSite site = DataRepository.GetSiteByName(rd.SiteName, Inregion.Id); if (site == null) { rd.HasError = true; } TestingArea ta = DataRepository.GetTestingAreaByName(rd.TestingArea); if (ta == null) { rd.HasError = true; } Instrument Inst = DataRepository.GetInstrumentByNameAndTestingArea(rd.InstrumentName, ta.Id); sitein.Site = site; sitein.Instrument = Inst; sitein.Quantity = rd.Quantity; sitein.TestRunPercentage = rd.PecentRun; // DataRepository.SaveOrUpdateSite(site); foreach (ForlabSite sitei in result) { if (sitei.SiteName == rd.SiteName && !sitei.SiteInstruments.Contains(sitein)) { sitein.Site = sitei; sitei.SiteInstruments.Add(sitein); instcount++; } } } } catch (Exception ex) { rd.HasError = true; } } // // SaveAll(); // MessageBox.Show(instcount + " Site Instrument are imported successfully.", "Importing", MessageBoxButtons.OK, MessageBoxIcon.Information); // this.DialogResult = System.Windows.Forms.DialogResult.OK; //this.Close(); } catch { MessageBox.Show("Error: Unable to import Site Instrument data.", "Importing", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { // DataRepository.CloseSession(); } }
private void butInImport_Click(object sender, EventArgs e) { bool sitexist = false; int count = 0; if (string.IsNullOrEmpty(txtInFilename.Text.Trim())) { return; } if (!sitelist) { result = DataRepository.GetAllSite(); } if (result.Count > 0) { try { DataSet ds = LqtUtil.ReadExcelFile(txtInFilename.Text, 6); _siteinstrumentdata = GetInDataRow(ds); int[] percentage = new int[_siteinstrumentdata.Count]; bool haserror = false; lvInImport.BeginUpdate(); lvInImport.Items.Clear(); string errorString; foreach (SiteInstrumentImportData rd in _siteinstrumentdata) { string str; errorString = ""; ListViewItem li = new ListViewItem(rd.RowNo.ToString()); li.SubItems.Add(rd.RegionName); foreach (ForlabSite site in result) { if ((site.SiteName.ToLower() == rd.SiteName.ToLower()) && (site.Region.RegionName.ToLower() == rd.RegionName.ToLower())) { sitexist = true; break; } } if (!sitexist) { rd.HasError = true; if (rd.RegionName == "") { errorString = errorString + " Region Doesn't Exist";//14 may 14 } else { errorString = errorString + " Site Doesn't Exist In This Region";//14 may 14 } } sitexist = false; li.SubItems.Add(rd.SiteName); Instrument Inst = DataRepository.GetInstrumentByName(rd.InstrumentName); ForlabRegion Inregion = DataRepository.GetRegionByName(rd.RegionName); ForlabSite s = DataRepository.GetSiteByName(rd.SiteName, Inregion.Id); if (Inst != null) { li.SubItems.Add(Inst.TestingArea.AreaName); } else { haserror = true; rd.HasError = true; errorString = errorString + " Instrument Doesn't Exist"; //14 may 14 li.SubItems.Add(""); //? } count = 0; foreach (ListViewItem Item in lvInImport.Items) { if (Item.SubItems[1].Text.Trim().ToLower() == rd.RegionName.Trim().ToLower() && Item.SubItems[2].Text.Trim().ToLower() == rd.SiteName.Trim().ToLower() && Item.SubItems[4].Text.Trim().ToLower() == rd.InstrumentName.Trim().ToLower()) { rd.IsExist = true; str = "Duplicated"; } //if (rd.TestingArea == Item.SubItems[3].Text) //{ // try // { // percentage[count] = int.Parse(Item.SubItems[6].Text); // count++; // } // catch // { // } //} } //int sum = 0; //for (int i = 0; i < count; i++) //{ // sum = sum + percentage[i]; //} //if ((sum > 100 || sum < 100) && (sum!=0)) // rd.HasError = true; if (Inst != null && s != null) { foreach (SiteInstrument inst in s.SiteInstruments) { if (inst.Instrument == Inst) { rd.IsExist = true; } } } li.SubItems.Add(rd.InstrumentName); li.SubItems.Add(rd.Quantity.ToString()); li.SubItems.Add(rd.PecentRun.ToString()); str = rd.IsExist ? "Yes" : "No"; li.SubItems.Add(str); if (rd.HasError) { li.BackColor = Color.Red; haserror = true; if (rd.RegionName == "") { errorString = errorString + " Region Name Required";//14 may 14 } if (rd.SiteName == "") { errorString = errorString + " Site Name Required"; } if (rd.InstrumentName == "") { errorString = errorString + " Instrument Name Required";//14 may 14 } if (rd.SiteName == "") { errorString = errorString + " Site Name Required"; } } if (rd.IsExist) { li.BackColor = Color.Yellow; } li.SubItems.Add(errorString); lvInImport.Items.Add(li); } sort(); lvInImport.EndUpdate(); //lvInImport.BeginUpdate(); //lvInImport.Items.Clear(); //foreach (SiteInstrumentImportData rd in _siteinstrumentdata) //{ // string str; // ListViewItem li = new ListViewItem(rd.RowNo.ToString()); // li.SubItems.Add(rd.RegionName); // foreach (ForlabSite site in result) // { // if ((site.SiteName == rd.SiteName) && (site.Region.RegionName == rd.RegionName)) // { // sitexist = true; // break; // } // } // if (!sitexist) // rd.HasError = true; // sitexist = false; // li.SubItems.Add(rd.SiteName); // Instrument Inst = DataRepository.GetInstrumentByName(rd.InstrumentName); // ForlabSite s = DataRepository.GetSiteByName(rd.SiteName); // if (Inst != null) // li.SubItems.Add(Inst.TestingArea.AreaName); // else // { // haserror = true; // rd.HasError = true; // li.SubItems.Add(""); // } // count = 0; // foreach (ListViewItem Item in lvInImport.Items) // { // if (Item.SubItems[1].Text == rd.RegionName && Item.SubItems[2].Text == rd.SiteName && Item.SubItems[4].Text == rd.InstrumentName) // { // rd.IsExist = true; // str = "Duplicated"; // } // if (rd.TestingArea == Item.SubItems[3].Text) // { // try // { // percentage[count] = int.Parse(Item.SubItems[6].Text); // count++; // } // catch // { // } // } // } // int sum = 0; // for (int i = 0; i < count; i++) // { // sum = sum + percentage[i]; // } // if ((sum > 100 || sum < 100) && (sum != 0)) // rd.HasError = true; // if (Inst != null && s != null) // { // foreach (SiteInstrument inst in s.SiteInstruments) // { // if (inst.Instrument == Inst) // { // rd.IsExist = true; // } // } // } // li.SubItems.Add(rd.InstrumentName); // li.SubItems.Add(rd.Quantity.ToString()); // li.SubItems.Add(rd.PecentRun.ToString()); // str = rd.IsExist ? "Yes" : "No"; // li.SubItems.Add(str); // if (rd.HasError) // { // li.BackColor = Color.Cyan; // haserror = true; // } // if (rd.IsExist) // { // li.BackColor = Color.Red; // } // lvInImport.Items.Add(li); //} //lvInImport.EndUpdate(); // SaveInstrument(); butInClear.Enabled = true; // if (!haserror)//b jul 9 butInSave.Enabled = true; } catch (Exception ex) { MessageBox.Show("Error: " + ex.Message, "Importing", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("Error:Importing", "Importing", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public RegionPane(ForlabRegion region) : this(region, false) { }
public LQTUserMessage SaveOrUpdateObject() { bool refSite = true; bool testDays = true; ForlabRegion region = LqtUtil.GetComboBoxValue <ForlabRegion>(comRegion); this.Focus(); if (txtName.Text.Trim() == string.Empty) { throw new LQTUserException("Site Name must not be empty."); } if (LqtUtil.GetComboBoxValue <ForlabRegion>(comRegion) == null) { throw new LQTUserException("A Region must be selected."); } if (DataRepository.GetSiteByName(txtName.Text.Trim(), LqtUtil.GetComboBoxValue <ForlabRegion>(comRegion).Id) != null && _site.Id <= 0) { throw new LQTUserException("The Site Name already exists in the region."); } if (txtworkingdays.Text.Trim() == string.Empty) { throw new LQTUserException("General Working Days Can not be empty."); } if (int.Parse(txtworkingdays.Text) > 31) { throw new LQTUserException("General Working Days Can not be greater than 31."); } if (comsitelevel.Text.Trim() == string.Empty) { throw new LQTUserException("Site Level Can not be empty."); } if (comCategory.Text.Trim() == string.Empty) { throw new LQTUserException("Site Category can not be empty. Please add site category first."); } string test = ""; string wDays = ""; bool workDays = false; _site.SiteName = txtName.Text.Trim(); if (txtCd4Td.Text == "") { txtCd4Td.Text = "0"; } if (int.Parse(txtCd4Td.Text) > int.Parse(txtworkingdays.Text)) { testDays = false; test = test + "CD4, "; } else { _site.CD4TestingDaysPerMonth = int.Parse(txtCd4Td.Text); } if (txtChemTd.Text == "") { txtChemTd.Text = "0"; } if (int.Parse(txtChemTd.Text) > int.Parse(txtworkingdays.Text)) { testDays = false; test = test + "Chemistry, "; } else { _site.ChemistryTestingDaysPerMonth = int.Parse(txtChemTd.Text); } if (txthemaTd.Text == "") { txthemaTd.Text = "0"; } if (int.Parse(txthemaTd.Text) > int.Parse(txtworkingdays.Text)) { testDays = false; test = test + "Hematology, "; } else { _site.HematologyTestingDaysPerMonth = int.Parse(txthemaTd.Text); } if (txtViralTd.Text == "") { txtViralTd.Text = "0"; } if (int.Parse(txtViralTd.Text) > int.Parse(txtworkingdays.Text)) { testDays = false; test = test + "Viral Load, "; } else { _site.ViralLoadTestingDaysPerMonth = int.Parse(txtViralTd.Text); } if (txtOtherTd.Text == "") { txtOtherTd.Text = "0"; } if (int.Parse(txtOtherTd.Text) > int.Parse(txtworkingdays.Text)) { testDays = false; test = test + "Other: "; } else { _site.OtherTestingDaysPerMonth = int.Parse(txtOtherTd.Text); } _site.SiteLevel = comsitelevel.Text; //if (int.Parse(comCD4RefSite.Tag.ToString()) > 0 && int.Parse(txtCd4Td.Text) <= 0)//jul 5 //{ // wDays = wDays + "CD4, "; // workDays = true; //} //if (int.Parse(comChemistryRefSite.Tag.ToString()) > 0 && int.Parse(txtChemTd.Text) <= 0) //{ // wDays = wDays + "Chemistry, "; // workDays = true; //} //if (int.Parse(comHematologyRefSite.Tag.ToString()) > 0 && int.Parse(txthemaTd.Text) <= 0) //{ // wDays = wDays + "Hematology, "; // workDays = true; //} //if (int.Parse(comViralLoadRefSite.Tag.ToString()) > 0 && int.Parse(txtViralTd.Text) <= 0) //{ // wDays = wDays + "Viral Load, "; // workDays = true; //} //if (int.Parse(comOtheRefSite.Tag.ToString()) > 0 && int.Parse(txtOtherTd.Text) <= 0) //{ // wDays = wDays + "Other: "; // workDays = true; //} _site.CD4RefSite = int.Parse(comCD4RefSite.Tag.ToString()); _site.ChemistryRefSite = int.Parse(comChemistryRefSite.Tag.ToString()); _site.HematologyRefSite = int.Parse(comHematologyRefSite.Tag.ToString()); _site.ViralLoadRefSite = int.Parse(comViralLoadRefSite.Tag.ToString()); _site.OtherRefSite = int.Parse(comOtheRefSite.Tag.ToString()); _site.WorkingDays = int.Parse(txtworkingdays.Text); //if (workDays) //{ // throw new LQTUserException(wDays + " Testing days has to be greater than 0."); //} if (testDays == false) { throw new LQTUserException(test + " Testing Days Can't be Greater Than Working Days."); } if (refSite == false) { throw new LQTUserException("A Site Can't be Referral Site for Itself."); } if (_site.Region == null) { _site.Region = LqtUtil.GetComboBoxValue <ForlabRegion>(comRegion); } _site.SiteCategory = LqtUtil.GetComboBoxValue <SiteCategory>(comCategory); string siteCategory = _site.SiteCategory.CategoryName; //b SiteCategory sCatagory; //b if (!string.IsNullOrEmpty(siteCategory)) //b { sCatagory = DataRepository.GetSiteCategoryByName(siteCategory); if (siteCategory == null) { sCatagory = new SiteCategory(); sCatagory.CategoryName = siteCategory; DataRepository.SaveOrUpdateSiteCategory(sCatagory); } } if (lsvInstrument.Items.Count > 0)//b { if (TestDaysCount() != "") { throw new LQTUserException(TestDaysCount() + " Testing days has to be greater than 0"); } //if (WorkingDaysCount() != "")//dec19 //{ // throw new LQTUserException(WorkingDaysCount() + " Testing days has to be 0"); //} if (TestInstrumentPercentage() == "")//b { AddDefaultStatus(); DataRepository.SaveOrUpdateSite(_site); return(new LQTUserMessage("Site was saved or updated successfully.")); } else//b // return new LQTUserMessage("Site can not be saved or updated"); { throw new LQTUserException("The sum of % Tests Run for the " + TestInstrumentPercentage() + " must add up to 100%"); } } else { string workingtestDays = ""; if (int.Parse(txtCd4Td.Text) > 0) //&& comCD4RefSite.Tag.ToString() == "0")//add jul 5 { workingtestDays = workingtestDays + "CD4, "; } if (int.Parse(txtChemTd.Text) > 0)// && comChemistryRefSite.Tag.ToString() == "0") { workingtestDays = workingtestDays + "Chemistry, "; } if (int.Parse(txthemaTd.Text) > 0)// && comHematologyRefSite.Tag.ToString() == "0") { workingtestDays = workingtestDays + "Hematology, "; } if (int.Parse(txtViralTd.Text) > 0)// && comViralLoadRefSite.Tag.ToString() == "0") { workingtestDays = workingtestDays + "Viral Load, "; } if (int.Parse(txtOtherTd.Text) > 0)// && comOtheRefSite.Tag.ToString() == "0") { workingtestDays = workingtestDays + "Other "; } //if(workingtestDays!="")//dec 19 //throw new LQTUserException(workingtestDays + " Testing days has to be 0"); AddDefaultStatus(); DataRepository.SaveOrUpdateSite(_site); return(new LQTUserMessage("Site was saved or updated successfully.")); } }
private IList <ReportedData> GetDataRow(DataSet ds) { //ArrayList errorList = new ArrayList(); //int count = 0; //try //{ string regionName; string siteName; string productName; string duration; decimal amount; int stockout; int instrumentDownTime;//b decimal adjusited; int rowno = 0; bool haserror; string rName = ""; string sName = ""; string pName = ""; ForlabRegion region = null; ForlabSite site = null; MasterProduct product = null; IList <ReportedData> rdlist = new List <ReportedData>(); foreach (DataRow dr in ds.Tables[0].Rows) { rowno++; haserror = false; regionName = Convert.ToString(dr[0]); //region name siteName = Convert.ToString(dr[1]); //site name productName = Convert.ToString(dr[2]); //product name duration = Convert.ToString(dr[3]); // reporting period(duration) try { amount = Convert.ToDecimal(dr[4]); //amount } catch { haserror = true; amount = 0; } try { stockout = Convert.ToInt32(dr[5]); //stock out } catch { haserror = true; stockout = 0; } try { instrumentDownTime = Convert.ToInt32(dr[6]); //instrumentDownTime } catch { haserror = true; instrumentDownTime = 0; } try { adjusited = Convert.ToDecimal(dr[7]); //adjusted } catch { haserror = true; adjusited = 0; } ReportedData rd = new ReportedData(rowno, regionName, siteName, productName, duration, amount, stockout, instrumentDownTime); if (rName != regionName) { if (!string.IsNullOrEmpty(regionName)) { region = DataRepository.GetRegionByName(regionName); } else { region = null; } rName = regionName; } if (region != null) { rd.Region = region; if (sName != siteName) { if (!string.IsNullOrEmpty(siteName)) { site = DataRepository.GetSiteByName(siteName, region.Id); } else { site = null; } sName = siteName; } if (site != null) { rd.Site = site; } else { haserror = true; } } else { haserror = true; } if (pName != productName) { if (!string.IsNullOrEmpty(productName)) { product = DataRepository.GetProductByName(productName); } else { product = null; } pName = productName; } if (product != null) { rd.Product = product; } else { haserror = true; } rd.HasError = haserror; rdlist.Add(rd); } //} //catch (Exception ex) //{ // //ShowError(ex.Message); //} return(rdlist); }
public static void DeleteRegion(ForlabRegion t) { DaoFactory.GetDaoFactory().CreateRegionDao().Delete(t); }
public static void SaveOrUpdateRegion(ForlabRegion region) { DaoFactory.GetDaoFactory().CreateRegionDao().SaveOrUpdate(region); }