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