protected void ddlTransact_SelectedIndexChanged(object sender, EventArgs e) { MySQLDatabase db = new MySQLDatabase(); var yearId = new YearTable(db).GetYearId(DateTime.Now.Year); var YCSId = new YearClassSectionTable(db).GetYearClassSectionId(yearId, Convert.ToInt32(ddlClass.SelectedValue), Convert.ToInt32(ddlSection.SelectedValue)); if (ddlTransact.SelectedValue == "1") { db.Execute("addTransactionAccessibility", new Dictionary <string, object>() { { "@Tid", ddlTeacher.SelectedValue }, { "@YCSId", YCSId } }, true); hInfo.InnerText = ddlTeacher.SelectedItem.Text + " now can access class " + ddlClass.SelectedItem.Text + ", section " + ddlSection.SelectedItem.Text; hInfo.Attributes["class"] = "text-success"; hInfo.Visible = true; } else { db.Execute("removeTransactionAccessibility", new Dictionary <string, object>() { { "@TId", ddlTeacher.SelectedValue }, { "@YCSId", YCSId } }, true); hInfo.InnerText = ddlTeacher.SelectedItem.Text + " now cannot access class " + ddlClass.SelectedItem.Text + ", section " + ddlSection.SelectedItem.Text; hInfo.Attributes["class"] = "text-danger"; hInfo.Visible = true; } }
protected void ddlTeacher_SelectedIndexChanged(object sender, EventArgs e) { var yearId = new YearTable(db).GetYearId(DateTime.Now.Year); //var teacherId = Context.GetOwinContext().GetUserManager<ApplicationUserManager>().FindByName(User.Identity.Name).Id; ReloadDDLCanTransact(yearId); hInfo.Visible = false; }
//protected void ReloadYCSId(object obj, EventArgs ea) { // var yearId = db.QueryValue("getYearId", new Dictionary<string, object>() { { "@pyear", DateTime.Now.Year } }, true); // ViewState["YCSId"] = Convert.ToInt32(new MySQLDatabase().QueryValue( // "getYearClassSectionId", // new Dictionary<string, object>() { // {"@pyearid", yearId }, // {"@pclassid", ddlClass.SelectedValue }, // {"@psectionid", ddlSection.SelectedValue } }, // true)); //} protected void ReloadDDLSection(object obje, EventArgs ea) { var teacherId = new UserTable <IdentityUser>(db).GetUserId(User.Identity.Name); var yearId = new YearTable(db).GetYearId(DateTime.Now.Year); ddlSection.DataSource = new TeacherSubjectTable(db).GetSection(teacherId, yearId, ddlClass.SelectedValue); ddlSection.DataTextField = "Text"; ddlSection.DataValueField = "Value"; ddlSection.DataBind(); BindCheckBoxes(null, null); }
public void AddYearClick() { try { YearTable year = new YearTable(_iGenreLableAdd.YearAdd); year.Create(); _iGenreLableAdd.ShowSuccessMessage(); } catch { _iGenreLableAdd.ShowErrorMessage(); } }
private void addYear_Click(object sender, EventArgs e) { try { string temp = yearBox.Text; YearTable year = new YearTable(temp); year.Create(); MessageBox.Show("Done!^_^", "TheResult"); } catch { MessageBox.Show("Something bad has happened!", "Whoops!"); } }
protected void Page_Init(object sender, EventArgs e) { if (!IsPostBack) { var teacherId = Context.GetOwinContext().GetUserManager <ApplicationUserManager>().FindByName(User.Identity.Name).Id; var yearId = new YearTable(db).GetYearId(DateTime.Now.Year); ddlClass.DataSource = new TeacherSubjectTable(db).GetClass(teacherId, yearId); ddlClass.DataTextField = "Text"; ddlClass.DataValueField = "Value"; ddlClass.DataBind(); ReloadDDLSection(null, null); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { var res = new YearTable(db).GetAllYear(); ddlFromYear.DataSource = res; ddlFromYear.DataBind(); ReloadDDLFromClass(null, null); ddlToYear.DataSource = res; ddlToYear.DataBind(); ReloadDDLToClass(null, null); hPromote.Visible = false; } }
private void LoadStudentClass() { var yearId = new YearTable(db).GetYearId(DateTime.Now.Year); ddlClass.DataSource = new YearClassSectionTable(db).GetClassByYear(yearId); ddlClass.DataBind(); if (ddlClass.Items.Count > 0) { ReloadDDLSection(yearId); } else { ddlSection.Items.Clear(); } }
// add artist and album private void addButton_Click(object sender, EventArgs e) { try { string artistName = artistTBox.Text; if (artistName == "") { Exception ex = new Exception("Please, insert artist's name!"); throw ex; } string gName = genreBox.Text; Genre gID = Genre.GetGenreID(gName); Artist findartist = Artist.CheckArtist(artistName); Artist artist = new Artist(); if (findartist == null) { artist = new Artist(artistName, gID); artist.Create(); artist = Artist.CheckArtist(artistName); } else { artist = Artist.CheckArtist(artistName); } string y = yearBox.Text; YearTable year = YearTable.GetYearID(y); if (year == null) { year = new YearTable(y); year.Create(); year = YearTable.GetYearID(y); } else { year = YearTable.GetYearID(y); } string l = lableBox.Text; Lable lable = Lable.GetLableID(l); if (lable == null) { lable = new Lable(l); lable.Create(); lable = Lable.GetLableID(l); } else { lable = Lable.GetLableID(l); } string af = formatBox.Text; AlbumFormat format = AlbumFormat.GetFormatID(af); if (format == null) { format = new AlbumFormat(af); format.Create(); format = AlbumFormat.GetFormatID(af); } else { format = AlbumFormat.GetFormatID(af); } string alname = albumTBox.Text; Album album = new Album(alname, artist, year, lable, format); album.Create(); album = Album.GetAlbumID(alname); string[] tracklist = tracklistTBox.Lines; TrackList tl; for (int i = 0; i < tracklist.Length; ++i) { string tnum = "00"; string tname = ""; string tempp = ""; bool whitespace = false; for (int j = 0; j < tracklist[i].Length; ++j) { if (tracklist[i][j] == ' ' && !whitespace) { whitespace = true; tnum = tempp; tempp = ""; } else { tempp += tracklist[i][j]; } } tname = tempp; tl = new TrackList(tname, tnum, album); tl.Create(); } MessageBox.Show("Done!^_^", "TheResult"); } catch { MessageBox.Show("Something bad has happened!", "Whoops!"); } }
public void AddButtClick() { try { if (_addMusicControl.ArtistAdd == "") { Exception ex = new Exception("Please, insert artist's name!"); throw ex; } Genre gId = Genre.GetGenreID(_addMusicControl.GenreAdd); Artist findartist = Artist.CheckArtist(_addMusicControl.ArtistAdd); Artist artist; if (findartist == null) { artist = new Artist(_addMusicControl.ArtistAdd, gId); artist.Create(); artist = Artist.CheckArtist(_addMusicControl.ArtistAdd); } else { artist = Artist.CheckArtist(_addMusicControl.ArtistAdd); } YearTable year = YearTable.GetYearID(_addMusicControl.YearAdd); if (year == null) { year = new YearTable(_addMusicControl.YearAdd); year.Create(); year = YearTable.GetYearID(_addMusicControl.YearAdd); } else { year = YearTable.GetYearID(_addMusicControl.YearAdd); } Lable lable = Lable.GetLableId(_addMusicControl.LableAdd); if (lable == null) { lable = new Lable(_addMusicControl.LableAdd); lable.Create(); lable = Lable.GetLableId(_addMusicControl.LableAdd); } else { lable = Lable.GetLableId(_addMusicControl.LableAdd); } AlbumFormat format = AlbumFormat.GetFormatId(_addMusicControl.FormatAdd); if (format == null) { format = new AlbumFormat(_addMusicControl.FormatAdd); format.Create(); format = AlbumFormat.GetFormatId(_addMusicControl.FormatAdd); } else { format = AlbumFormat.GetFormatId(_addMusicControl.FormatAdd); } Album album = new Album(_addMusicControl.AlbumAdd, artist, year, lable, format); album.Create(); album = Album.GetAlbumId(_addMusicControl.AlbumAdd); TrackList tl; for (int i = 0; i < _addMusicControl.TrackListAdd.Length; ++i) { string tnum = "00"; string tname = ""; string tempp = ""; bool whitespace = false; for (int j = 0; j < _addMusicControl.TrackListAdd[i].Length; ++j) { if (_addMusicControl.TrackListAdd[i][j] == ' ' && !whitespace) { whitespace = true; tnum = tempp; tempp = ""; } else { tempp += _addMusicControl.TrackListAdd[i][j]; } } tname = tempp; tl = new TrackList(tname, tnum, album); tl.Create(); } _addMusicControl.ShowSuccessMessage(); } catch { _addMusicControl.ShowErrorMessage(); } }
protected void ddlClass_SelectedIndexChanged(object sender, EventArgs e) { var yearId = new YearTable(db).GetYearId(DateTime.Now.Year); ReloadDDLSection(yearId); }