public List <SiteCategory> GetAll()
{
SiteCategoryDAC _siteCategoryComponent = new SiteCategoryDAC();
IDataReader reader = _siteCategoryComponent.GetAllSiteCategory().CreateDataReader();
List <SiteCategory> _siteCategoryList = new List <SiteCategory>();
while (reader.Read())
{
if (_siteCategoryList == null)
{
_siteCategoryList = new List <SiteCategory>();
}
SiteCategory _siteCategory = new SiteCategory();
if (reader["SiteCategoryId"] != DBNull.Value)
{
_siteCategory.SiteCategoryId = Convert.ToInt32(reader["SiteCategoryId"]);
}
if (reader["Name"] != DBNull.Value)
{
_siteCategory.Name = Convert.ToString(reader["Name"]);
}
if (reader["RowGuid"] != DBNull.Value)
{
_siteCategory.RowGuid = new Guid(reader["RowGuid"].ToString());
}
if (reader["ModifiedDate"] != DBNull.Value)
{
_siteCategory.ModifiedDate = Convert.ToDateTime(reader["ModifiedDate"]);
}
_siteCategory.NewRecord = false;
_siteCategoryList.Add(_siteCategory);
}
reader.Close();
return(_siteCategoryList);
}
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 SiteCategory GetByID(int _siteCategoryId)
{
SiteCategoryDAC _siteCategoryComponent = new SiteCategoryDAC();
IDataReader reader = _siteCategoryComponent.GetByIDSiteCategory(_siteCategoryId);
SiteCategory _siteCategory = null;
while (reader.Read())
{
_siteCategory = new SiteCategory();
if (reader["SiteCategoryId"] != DBNull.Value)
{
_siteCategory.SiteCategoryId = Convert.ToInt32(reader["SiteCategoryId"]);
}
if (reader["Name"] != DBNull.Value)
{
_siteCategory.Name = Convert.ToString(reader["Name"]);
}
if (reader["RowGuid"] != DBNull.Value)
{
_siteCategory.RowGuid = new Guid(reader["RowGuid"].ToString());
}
if (reader["ModifiedDate"] != DBNull.Value)
{
_siteCategory.ModifiedDate = Convert.ToDateTime(reader["ModifiedDate"]);
}
_siteCategory.NewRecord = false;
}
reader.Close();
return(_siteCategory);
}
public FrmSiteCat(SiteCategory scategory)
{
_scategory = scategory;
InitializeComponent();
if (_scategory.Id > 0)
{
txtName.Text = _scategory.CategoryName;
}
}
public bool Insert(SiteCategory sitecategory)
{
int autonumber = 0;
SiteCategoryDAC sitecategoryComponent = new SiteCategoryDAC();
bool endedSuccessfuly = sitecategoryComponent.InsertNewSiteCategory(ref autonumber, sitecategory.Name, sitecategory.RowGuid, sitecategory.ModifiedDate);
if (endedSuccessfuly)
{
sitecategory.SiteCategoryId = autonumber;
}
return(endedSuccessfuly);
}
public ActionResult Save(SiteCategory siteCategory)
{
if (siteCategory.Id != 0)
{
_db.SiteCategories.Attach(siteCategory);
_db.Entry(siteCategory).State = EntityState.Modified;
}
else
{
_db.SiteCategories.Add(siteCategory);
}
SaveChanges();
TempData["success"] = "Site Category " + siteCategory.Name + " saved";
return(RedirectToAction("Index"));
}
private void butRemove_Click(object sender, EventArgs e)
{
if (lsvCategory.SelectedItems.Count > 0)
{
try
{
SiteCategory sc = (SiteCategory)lsvCategory.SelectedItems[0].Tag;
DataRepository.DeleteSiteCategory(sc);
BindSiteCategorys();
}
catch (Exception ex)
{
new FrmShowError(new ExceptionStatus()
{
ex = ex, message = "Sorry you could not delete this Site-Category."
}).ShowDialog();
}
finally
{
DataRepository.CloseSession();
}
}
}
public virtual void TranTest()
{
SiteCategory siteCategory = new SiteCategory
{
ContentTitle = "测试add",
HasModelContent = 11,
Sequence = 11,
Depth = 1,
ParId = 1,
ModelId = 1
};
_siteCategoryRepository.AddEntity(siteCategory);
//_siteCategoryRepository.UpdateByExp(w => w.ModelId == 1, s => new SiteCategory
//{
// ContentTitle = "修改11"
//});
int i = 0;
int b = 10 / i;
_pdProductRepository.DeleteByExp(w => w.Id == 2);
}
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."));
}
}
public static void DeleteSiteCategory(SiteCategory sc)
{
DaoFactory.GetDaoFactory().CreateSiteCategoryDao().Delete(sc);
}
public static void SaveOrUpdateSiteCategory(SiteCategory sc)
{
DaoFactory.GetDaoFactory().CreateSiteCategoryDao().SaveOrUpdate(sc);
}
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);
}
public bool Update(SiteCategory sitecategory, int old_siteCategoryId)
{
SiteCategoryDAC sitecategoryComponent = new SiteCategoryDAC();
return(sitecategoryComponent.UpdateSiteCategory(sitecategory.Name, sitecategory.RowGuid, sitecategory.ModifiedDate, old_siteCategoryId));
}
