private void RemoveSession() { if (this.sessionHiddenRe.Value == "") { this.Master._Logger.Warn(new AdminException(". this.sessionHiddenRe.Value == \"\""), MethodBase.GetCurrentMethod().Name); this.Notify(this.Master._Notifier.Notify(23, "Red", "")); this.sessionHiddenRe.Value = ""; return; } GraduateSession session = (GraduateSession)this.Master._CoachingDal.Get("session", this.sessionHiddenRe.Value); if (session == null) { this.Master._Logger.Warn(new AdminException(". session == null"), MethodBase.GetCurrentMethod().Name); this.Notify(this.Master._Notifier.Notify(23, "Red", "")); this.sessionHiddenRe.Value = ""; return; } try { this.Master._CoachingDal.DeleteAllGraduatesFromSession(this.sessionHiddenRe.Value); this.Master._CoachingDal.Delete("session", this.sessionHiddenRe.Value); this.Master._Logger.Log(new AdminException("." + session.GraduateYearHebrew + " " + session.GraduateYearNumber + " Was Successfully Removed"), MethodBase.GetCurrentMethod().Name); this.Notify(this.Master._Notifier.Notify(28, "White", session.GraduateYearHebrew + " " + session.GraduateYearNumber)); ListItem r = (this.graduatesRemoveUpdateSessionSelector.Items.FindByValue("s" + session.GraduateSessionID)); this.graduatesRemoveUpdateSessionSelector.Items.Remove(r); this.addGraduateSelector.Items.Remove(r); this.selectSessionGraduate.Items.Remove(r); } catch (Exception) { try { this.Master._CoachingDal.DeleteAllGraduatesFromSession(this.sessionHiddenRe.Value); this.Master._CoachingDal.Delete("session", this.sessionHiddenRe.Value); this.Master._Logger.Log(new AdminException("." + session.GraduateYearHebrew + " " + session.GraduateYearNumber + " Was Successfully Removed"), MethodBase.GetCurrentMethod().Name); this.Notify(this.Master._Notifier.Notify(28, "White", session.GraduateYearHebrew + " " + session.GraduateYearNumber)); ListItem r = (this.graduatesRemoveUpdateSessionSelector.Items.FindByValue("s" + session.GraduateSessionID)); this.graduatesRemoveUpdateSessionSelector.Items.Remove(r); this.addGraduateSelector.Items.Remove(r); this.selectSessionGraduate.Items.Remove(r); } catch (Exception e) { this.Master._Logger.Error(e, MethodBase.GetCurrentMethod().Name); this.Notify(this.Master._Notifier.Notify(38, "Red", session.GraduateYearHebrew + " " + session.GraduateYearNumber)); } } }
public void DeleteAllGraduatesFromSession(string sessionID) { if (sessionID == "" || sessionID == null) { return; } GraduateSession session = (GraduateSession)this.Get("session", sessionID); if (session == null) { return; } IEnumerable <Graduate> graduates = from session in this.coachingDal.Graduates where session.GraduateSessionID == sessionID select session; for (int i = 0; i < graduates.Count(); i++) { this.coachingDal.Graduates.DeleteOnSubmit(graduates.ElementAt(i)); } this.coachingDal.SubmitChanges(); }
protected void selectSessionGraduate_SelectedIndexChanged(object sender, EventArgs e) { if (!ValidateFields("graduate5")) { return; } GraduateSession session = (GraduateSession)this.Master._CoachingDal.Get("session", this.selectSessionGraduate.SelectedValue.Remove(0, 1)); if (session == null) { this.Master._Logger.Warn(new AdminException(". session == null"), MethodBase.GetCurrentMethod().Name); this.Notify(this.Master._Notifier.Notify(23, "Red", "")); return; } this.SelectGraduateDiv(true); this.selectGraduatesGraduate.Items.Clear(); this.selectGraduatesGraduate.Items.Add(new ListItem("--Select Graduate--", "0")); foreach (Graduate gra in this.Master._CoachingDal.GetAllGraduatesBySession(session.GraduateSessionID)) { this.selectGraduatesGraduate.Items.Add(new ListItem(gra.GraduateName, "s" + gra.GraduateID)); } }
private void UpdateSession() { if (this.sessionHiddenUp.Value == "") { this.Master._Logger.Warn(new AdminException(". this.sessionHiddenUp.Value == \"\""), MethodBase.GetCurrentMethod().Name); this.Notify(this.Master._Notifier.Notify(23, "Red", "")); return; } GraduateSession session = (GraduateSession)this.Master._CoachingDal.Get("session", this.sessionHiddenUp.Value); if (session == null) { this.Master._Logger.Warn(new AdminException(". session == null"), MethodBase.GetCurrentMethod().Name); this.Notify(this.Master._Notifier.Notify(23, "Red", "")); return; } if (!this.Master._CoachingDal.CheckIfSessionPlaceAvailableExcept(session.GraduatePlace, int.Parse(this.graduatesPlaceSelector.Text))) { this.Master._Logger.Warn(new AdminException (@". this.Master._CoachingDal.CheckIfSessionPlaceAvailableExcept(session.GraduatePlace, int.Parse(this.graduatesPlaceSelector.Text)))"), MethodBase.GetCurrentMethod().Name); this.Notify(this.Master._Notifier.Notify(74, "Red", "")); return; } try { session.GraduateYearHebrew = this.graduatesYearHebrew.Text; session.GraduateYearNumber = this.graduatesYearNumberSelector.SelectedValue; session.GraduatePlace = int.Parse(this.graduatesPlaceSelector.Text); this.Master._CoachingDal.Update("session", session, TimeNow.TheTimeNow); this.Master._Logger.Log(new AdminException(". " + this.graduatesYearHebrew.Text + " " + this.graduatesYearNumberSelector.SelectedValue + "Was Successfully Updated"), MethodBase.GetCurrentMethod().Name); this.Notify(this.Master._Notifier.Notify(27, "White", this.graduatesYearHebrew.Text + " " + this.graduatesYearNumberSelector.SelectedValue)); ListItem r = (this.graduatesRemoveUpdateSessionSelector.Items.FindByValue("s" + session.GraduateSessionID)); this.graduatesRemoveUpdateSessionSelector.Items.Remove(r); this.addGraduateSelector.Items.Remove(r); this.selectSessionGraduate.Items.Remove(r); ListItem m = new ListItem(session.GraduateYearNumber + ", " + session.GraduateYearHebrew, "s" + session.GraduateSessionID); this.graduatesRemoveUpdateSessionSelector.Items.Add(m); this.addGraduateSelector.Items.Add(m); this.selectSessionGraduate.Items.Add(m); } catch (Exception e) { this.Master._Logger.Error(e, MethodBase.GetCurrentMethod().Name); this.Notify(this.Master._Notifier.Notify(25, "Red", this.graduatesYearHebrew.Text + " " + this.graduatesYearNumberSelector.SelectedValue)); } }
public GraduateSession Update(ref GraduateSession m, DateTime time) { this.GraduateSessionID = m.GraduateSessionID; this.GraduateYearHebrew = m.GraduateYearHebrew; this.GraduateYearNumber = m.GraduateYearNumber; this.CreationTime = m.CreationTime; this.spCreationTime = m.spCreationTime; return(this); }
public bool CheckIfSessionPlaceAvailableExcept(int existSessionPlace, int newSessionPlace) { if (existSessionPlace < 0 || newSessionPlace < 0) { return(false); } GraduateSession p = this.coachingDal.GraduateSessions.SingleOrDefault (g => g.GraduatePlace != existSessionPlace && g.GraduatePlace == newSessionPlace); return(p == null); }
public bool CheckIfSessionPlaceAvailable(int sessionPlace) { if (sessionPlace < 0) { return(false); } GraduateSession p = this.coachingDal.GraduateSessions.SingleOrDefault (g => g.GraduatePlace == sessionPlace); return(p == null); }
public IEnumerable <Graduate> GetAllGraduatesBySession(string sessionID) { if (sessionID == "" || sessionID == null) { return(null); } GraduateSession session = (GraduateSession)this.Get("session", sessionID); if (session == null) { return(null); } IEnumerable <Graduate> graduates = from session in this.coachingDal.Graduates where session.GraduateSessionID == sessionID select session; return(graduates); }
private void AddSession() { if (!this.Master._CoachingDal.CheckIfSessionPlaceAvailable(int.Parse(this.graduatesPlaceSelector.Text))) { this.Master._Logger.Warn(new AdminException (". !this.Master._CoachingDal.CheckIfSessionPlaceAvailable(int.Parse(this.graduatesPlaceSelector.Text))"), MethodBase.GetCurrentMethod().Name); this.Notify(this.Master._Notifier.Notify(74, "Red", "")); return; } try { GraduateSession session = new GraduateSession { GraduatePlace = int.Parse(this.graduatesPlaceSelector.Text), GraduateSessionID = this.Master._CoachingDal.GetNextAvailableID("session"), GraduateYearHebrew = this.graduatesYearHebrew.Text, GraduateYearNumber = this.graduatesYearNumberSelector.SelectedValue, CreationTime = TimeNow.TheTimeNow, spCreationTime = TimeNow.TheTimeNow.ToShortDateString() }; this.Master._CoachingDal.Add("session", session, TimeNow.TheTimeNow); this.Master._Logger.Log(new AdminException(". " + this.graduatesYearHebrew.Text + " " + this.graduatesYearNumberSelector.SelectedValue + "Was Successfully Added"), MethodBase.GetCurrentMethod().Name); this.Notify(this.Master._Notifier.Notify(26, "White", this.graduatesYearHebrew.Text + " " + this.graduatesYearNumberSelector.SelectedValue)); ListItem m = new ListItem(session.GraduateYearNumber + ", " + session.GraduateYearHebrew, "s" + session.GraduateSessionID); this.graduatesRemoveUpdateSessionSelector.Items.Add(m); this.addGraduateSelector.Items.Add(m); this.selectSessionGraduate.Items.Add(m); } catch (Exception e) { this.Master._Logger.Error(e, MethodBase.GetCurrentMethod().Name); this.Notify(this.Master._Notifier.Notify(41, "Red", this.graduatesYearHebrew.Text + " " + this.graduatesYearNumberSelector.SelectedValue)); } }
protected void graduatesUpdateSessionButton_Click(object sender, EventArgs e) { if (!this.ValidateFields("graduate3")) { return; } this.sessionHiddenUp.Value = this.graduatesRemoveUpdateSessionSelector.SelectedValue.Remove(0, 1).ToString(); this.SwitchDivs(1); GraduateSession session = (GraduateSession)this.Master._CoachingDal.Get("session", this.sessionHiddenUp.Value); if (session == null) { this.Master._Logger.Warn(new AdminException(". session == null"), MethodBase.GetCurrentMethod().Name); this.Notify(this.Master._Notifier.Notify(23, "Red", "")); return; } this.ClearFields(1); this.graduatesYearHebrew.Text = session.GraduateYearHebrew; this.graduatesYearNumberSelector.Items.FindByValue(session.GraduateYearNumber).Selected = true; this.graduatesPlaceSelector.Text = session.GraduatePlace.ToString(); }
protected void Page_Load(object sender, EventArgs e) { if (Request["type"] == null) { this._logger.Error(new AdminException (". Request[\"type\"] == null"), MethodBase.GetCurrentMethod().Name); Response.Redirect("Default.aspx?error=true"); } if (Request["pageID"] == null) { this._logger.Error(new AdminException (". Request[\"pageID\"] == null"), MethodBase.GetCurrentMethod().Name); Response.Redirect("Default.aspx?error=true"); } if (Request["type"] == "content") { try { ContentP page = (ContentP)this._coachingDal.Get("content", (string)Request["pageID"]); if (page == null) { throw new AdminException(". page == null"); } if (page.ContentLanguageID.Trim() == "1") { this.content.Attributes["class"] = "hebrew"; } if (page.ContentLanguageID.Trim() == "2") { this.content.Attributes["class"] = "english"; } this._globalFunctions.SetPageSEO (page.ContentTitle, page.ContentDescription, page.ContentKeyWords, this.Page); this.content.InnerHtml = this._globalFunctions.FixBackUrl(page.ContentContent); this.Session["tab"] = "c" + page.ContentID; } catch (Exception y) { this._logger.Error(y, MethodBase.GetCurrentMethod().Name); Response.Redirect("Default.aspx?error=true"); } } if (Request["type"] == "article") { try { Article page = (Article)this._coachingDal.Get("article", (string)Request["pageID"]); if (page == null) { throw new AdminException(". page == null"); } if (page.ArticleLanguageID.Trim() == "1") { this.content.Attributes["class"] = "hebrew"; } if (page.ArticleLanguageID.Trim() == "2") { this.content.Attributes["class"] = "english"; } this._globalFunctions.SetPageSEO (page.ArticleTitle, page.ArticleDescription, page.ArticleKeyWords, this.Page); this.content.InnerHtml = this._globalFunctions.FixBackUrl(page.ArticleContent); } catch (Exception u) { this._logger.Error(u, MethodBase.GetCurrentMethod().Name); Response.Redirect("Default.aspx?error=true"); } } if (Request["type"] == "graduates") { if (Request["sessionID"] == null) { this._logger.Error(new AdminException (". Request[\"sessionID\"] == null"), MethodBase.GetCurrentMethod().Name); Response.Redirect("Default.aspx?error=true"); } GraduateSession session = (GraduateSession)this._coachingDal.Get("session", Request["sessionID"]); if (session == null) { this._logger.Error(new AdminException (". session == null"), MethodBase.GetCurrentMethod().Name); Response.Redirect("Default.aspx?error=true"); } this.content.Attributes["class"] = "graduate"; StringBuilder build = new StringBuilder(@"<div class=""space3""></div>"); foreach (Graduate g in this._coachingDal.GetAllGraduatesBySession(Request["sessionID"])) { build.Append(g.GraduateName + "<br />"); } this.content.InnerHtml = build.ToString(); } }
public string GetNextAvailableID(string type) { if (type == "" || type == null) { return(type); } int result = 0; switch (type) { case "admin": AdminUser ad = null; while ((ad = (AdminUser)this.Get(type, result.ToString())) != null) { result += 1; } break; case "article": Article ar = null; while ((ar = (Article)this.Get(type, result.ToString())) != null) { result += 1; } break; case "content": ContentP co = null; while ((co = (ContentP)this.Get(type, result.ToString())) != null) { result += 1; } break; case "mailList": MailList ma = null; while ((ma = (MailList)this.Get(type, result.ToString())) != null) { result += 1; } break; case "log": Log lo = null; while ((lo = (Log)this.Get(type, result.ToString())) != null) { result += 1; } break; case "graduate": Graduate gr = null; while ((gr = (Graduate)this.Get(type, result.ToString())) != null) { result += 1; } break; case "session": GraduateSession ss = null; while ((ss = (GraduateSession)this.Get(type, result.ToString())) != null) { result += 1; } break; case "lead": Lead le = null; while ((le = (Lead)this.Get(type, result.ToString())) != null) { result += 1; } break; case "news": New ne = null; while ((ne = (New)this.Get(type, result.ToString())) != null) { result += 1; } break; default: break; } return(result.ToString()); }
public void Update(string type, object item, DateTime time) { if (type == "" || type == null || time == default(DateTime)) { return; } switch (type) { case "admin": AdminUser ad1 = (AdminUser)item; AdminUser ad2 = null; if ((ad2 = (AdminUser)this.Get(type, ad1.AdminUserID)) != null) { ad2.Update(ref ad1, time); ad2.LastUpdate = time; ad2.spLastUpdate = time.ToString(); } break; case "article": Article ar1 = (Article)item; Article ar2 = null; if ((ar2 = (Article)this.Get(type, ar1.ArticleID)) != null) { ar2.Update(ref ar1, time); ar2.LastUpdate = time; ar2.spLastUpdate = time.ToString(); } break; case "content": ContentP co1 = (ContentP)item; ContentP co2 = null; if ((co2 = (ContentP)this.Get(type, co1.ContentID)) != null) { co2.Update(ref co1, time); co2.LastUpdate = time; co2.spLastUpdate = time.ToString(); } break; case "log": Log lo1 = (Log)item; Log lo2 = null; if ((lo2 = (Log)this.Get(type, lo1.LogID.ToString())) != null) { lo2.Update(ref lo1, time); } break; case "graduate": Graduate gr1 = (Graduate)item; Graduate gr2 = null; if ((gr2 = (Graduate)this.Get(type, gr1.GraduateID)) != null) { gr2.Update(ref gr1, time); } break; case "session": GraduateSession ss1 = (GraduateSession)item; GraduateSession ss2 = null; if ((ss2 = (GraduateSession)this.Get(type, ss1.GraduateSessionID)) != null) { ss2.Update(ref ss1, time); } break; case "lead": Lead le1 = (Lead)item; Lead le2 = null; if ((le2 = (Lead)this.Get(type, le1.LeadID.ToString())) != null) { le2.Update(ref le1, time); } break; case "news": New ne1 = (New)item; New ne2 = null; if ((ne2 = (New)this.Get(type, ne1.NewsID.ToString())) != null) { ne2.Update(ref ne1, time); } break; default: break; } this.coachingDal.SubmitChanges(); }
public void Delete(string type, string itemID) { if (type == "" || type == null || itemID == null || itemID == "") { return; } switch (type) { case "admin": AdminUser m = null; if ((m = (AdminUser)this.Get(type, itemID)) != null) { this.coachingDal.AdminUsers.DeleteOnSubmit(m); } break; case "article": Article ar = null; if ((ar = (Article)this.Get(type, itemID)) != null) { this.coachingDal.Articles.DeleteOnSubmit(ar); } break; case "content": ContentP co = null; if ((co = (ContentP)this.Get(type, itemID)) != null) { this.coachingDal.ContentPs.DeleteOnSubmit(co); } break; case "mailList": MailList ma = null; if ((ma = (MailList)this.Get(type, itemID)) != null) { this.coachingDal.MailLists.DeleteOnSubmit(ma); } break; case "log": Log lo = null; if ((lo = (Log)this.Get(type, itemID)) != null) { this.coachingDal.Logs.DeleteOnSubmit(lo); } break; case "graduate": Graduate gr = null; if ((gr = (Graduate)this.Get(type, itemID)) != null) { this.coachingDal.Graduates.DeleteOnSubmit(gr); } break; case "session": GraduateSession se = null; if ((se = (GraduateSession)this.Get(type, itemID)) != null) { this.coachingDal.GraduateSessions.DeleteOnSubmit(se); } break; case "lead": Lead le = null; if ((le = (Lead)this.Get(type, itemID)) != null) { this.coachingDal.Leads.DeleteOnSubmit(le); } break; case "news": New ne = null; if ((ne = (New)this.Get(type, itemID)) != null) { this.coachingDal.News.DeleteOnSubmit(ne); } break; default: break; } this.coachingDal.SubmitChanges(); }
public void Add(string type, object item, DateTime time) { if (type == "" || type == null || item == null || time == default(DateTime) || time == default(DateTime)) { return; } switch (type) { case "admin": AdminUser ad = (AdminUser)item; if (this.Get(type, ad.AdminUserID) == null) { ad.CreationTime = time; ad.spCreationTime = time.ToShortDateString(); this.coachingDal.AdminUsers.InsertOnSubmit(ad); } break; case "article": Article ar = (Article)item; if (this.Get(type, ar.ArticleID) == null) { ar.CreationTime = time; this.coachingDal.Articles.InsertOnSubmit(ar); } break; case "content": ContentP co = (ContentP)item; if (this.Get(type, co.ContentID) == null) { co.CreationTime = time; this.coachingDal.ContentPs.InsertOnSubmit(co); } break; case "mailList": MailList ma = (MailList)item; if (this.Get(type, ma.MailListID) == null) { ma.MailListJoinTime = time; ma.spMailListLastUpdate = time.ToShortDateString(); this.coachingDal.MailLists.InsertOnSubmit(ma); } break; case "log": Log lo = (Log)item; if (this.Get(type, lo.LogID.ToString()) == null) { lo.LogDate = time; lo.spLogDate = time.ToShortDateString(); this.coachingDal.Logs.InsertOnSubmit(lo); } break; case "graduate": Graduate gr = (Graduate)item; if (this.Get(type, gr.GraduateID.ToString()) == null) { gr.CreationTime = time; gr.spCreationTime = time.ToShortDateString(); this.coachingDal.Graduates.InsertOnSubmit(gr); } break; case "session": GraduateSession se = (GraduateSession)item; if (this.Get(type, se.GraduateSessionID.ToString()) == null) { se.CreationTime = time; se.spCreationTime = time.ToShortDateString(); this.coachingDal.GraduateSessions.InsertOnSubmit(se); } break; case "lead": Lead le = (Lead)item; if (this.Get(type, le.LeadID.ToString()) == null) { le.LeadDate = time; le.spLeadDate = time.ToString(); this.coachingDal.Leads.InsertOnSubmit(le); } break; case "news": New ne = (New)item; if (this.Get(type, ne.NewsID) == null) { ne.NewsCreationDate = time; ne.spNewsCreationDate = time.ToShortDateString(); this.coachingDal.News.InsertOnSubmit(ne); } break; default: break; } this.coachingDal.SubmitChanges(); }
private void SwitchDivs(int index) { if (index <= 0) { this.Master._Logger.Error(new AdminException (". index <= 0"), MethodBase.GetCurrentMethod().Name); this.Notify(this.Master._Notifier.Notify(23, "Red", "")); return; } this.graduatesAddNewSession.Visible = false; this.graduatesUpdateRemoveSession.Visible = false; this.graduatesAddNewGraduate.Visible = false; this.graduatesRemoveGraduate.Visible = false; this.graduatesNotify.Visible = false; this.graduatesAddNewSession.Attributes["class"] = "unVisi"; this.graduatesUpdateRemoveSession.Attributes["class"] = "unVisi"; this.graduatesAddNewGraduate.Attributes["class"] = "unVisi"; this.graduatesRemoveGraduate.Attributes["class"] = "unVisi"; this.graduatesNotify.Attributes["class"] = "unVisi"; switch (index) { case 1: this.graduatesAddNewSession.Visible = true; this.graduatesAddNewSession.Attributes["class"] = "visi"; if (this.graduatesYearNumberSelector.Items.Count == 0) { this.graduatesYearNumberSelector.Items.Add(new ListItem("--Select Year--", "0")); for (int i = 2010; i > 1980; i--) { this.graduatesYearNumberSelector.Items.Add(new ListItem(i.ToString(), i.ToString())); } } if (this.sessionHiddenUp.Value != "") { GraduateSession session = (GraduateSession)this.Master._CoachingDal.Get("session", this.sessionHiddenUp.Value); if (session == null) { this.Master._Logger.Warn(new AdminException(". session == null"), MethodBase.GetCurrentMethod().Name); this.Notify(this.Master._Notifier.Notify(23, "Red", "")); return; } this.graduatesYearHebrew.Text = session.GraduateYearHebrew; this.graduatesYearNumberSelector.Items.FindByValue(session.GraduateYearNumber).Selected = true; } break; case 2: this.graduatesUpdateRemoveSession.Visible = true; this.graduatesUpdateRemoveSession.Attributes["class"] = "visi"; break; case 3: this.graduatesAddNewGraduate.Visible = true; this.graduatesAddNewGraduate.Attributes["class"] = "visi"; break; case 4: this.graduatesRemoveGraduate.Visible = true; this.graduatesRemoveGraduate.Attributes["class"] = "visi"; break; case 5: this.graduatesNotify.Visible = true; this.graduatesNotify.Attributes["class"] = "visi"; break; default: break; } }