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