public void GetValue(string value)
{
try
{
string sText = value;
Semester sem = new Semester(sText);
data.SEMESTERS.Clear();
data.Read(UserID);
sem.Add(dtgvSem);
data.SEMESTERS.Add(sem);
CONNECT.OpenConnection();
string sql = "Insert Into SEMESTER(SEM_NAME, ID) values (N'" + value + "', '" + this.UserID + "')";
SqlCommand command = CONNECT.CreateSQLCmd(sql);
command.ExecuteNonQuery();
}
catch (Exception e)
{
MessageBox.Show("Đã xảy ra lỗi, vui lòng liên hệ đội ngũ phát triển!");
ReportError rp = new ReportError(this, e);
rp.Show();
this.Hide();
}
finally
{
CONNECT.CloseConnection();
}
}
public SemForm(MainForm p, string id)
{
try
{
data = new ListSem();
CONNECT = new Connect();
this.UserID = id;
this.parent = p;
InitializeComponent();
int style = NativeWinAPI.GetWindowLong(this.Handle, NativeWinAPI.GWL_EXSTYLE);
style |= NativeWinAPI.WS_EX_COMPOSITED;
NativeWinAPI.SetWindowLong(this.Handle, NativeWinAPI.GWL_EXSTYLE, style);
data.Read(UserID);
data.ShowSemToGridView(dtgvSem);
lSum.Text = "Số tín chỉ: " + data.SumOfCre.ToString();
lAver.Text = "Điểm TB: " + data.Average.ToString();
bMod.Visible = bDel.Visible = false;
data.SEMESTERS.Clear();
SetColor(Properties.Settings.Default.Color);
}
catch (Exception err)
{
MessageBox.Show("Đã xảy ra lỗi, vui lòng liên hệ đội ngũ phát triển!");
ReportError rp = new ReportError(this, err);
rp.Show();
}
}
public ScoreStatistics(MainForm p, string id, string name)
{
try
{
data = new ListSem();
CONNECT = new Connect();
this.UserID = id;
this.parent1 = p;
this.sNameOfSem = name;
InitializeComponent();
int style = NativeWinAPI.GetWindowLong(this.Handle, NativeWinAPI.GWL_EXSTYLE);
style |= NativeWinAPI.WS_EX_COMPOSITED;
NativeWinAPI.SetWindowLong(this.Handle, NativeWinAPI.GWL_EXSTYLE, style);
data.Read(UserID);
SetColor(Properties.Settings.Default.Color);
CreateChart();
parent = "mainform";
//var canvas = new Bunifu.DataViz.Canvas();
}
catch (Exception ex)
{
MessageBox.Show("Đã xảy ra lỗi, vui lòng liên hệ đội ngũ phát triển!");
ReportError rp = new ReportError(this, ex);
rp.Show();
}
}
public ScoreStatistics(SemForm p, string id)
{
try
{
data = new ListSem();
CONNECT = new Connect();
this.UserID = id;
this.parent2 = p;
InitializeComponent();
data.Read(UserID);
SetColor(Properties.Settings.Default.Color);
parent = "semform";
CreateChartOfSemesters();
//var canvas = new Bunifu.DataViz.Canvas();
}
catch (Exception ex)
{
MessageBox.Show("Đã xảy ra lỗi, vui lòng liên hệ đội ngũ phát triển!");
ReportError rp = new ReportError(this, ex);
rp.Show();
}
}
