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