protected void update_Click(object sender, EventArgs e)
{
SqlCommand sqlcm = new SqlCommand();
string st_diema, st_diemb, st_diemc, st_mamon, st_sql;
string st_msv = Request.QueryString.Get("user").ToString();
Clsconnect cls_con = new Clsconnect();
st_diema = tbx_diema.Text;
st_diemb = tbx_diemb.Text;
st_diemc = tbx_diemc.Text;
st_mamon = tbx_mamon.Text;
double tkso = 0.6 * double.Parse(st_diema) + 0.3 * double.Parse(st_diemb) + 0.1 * double.Parse(st_diemc);
try
{
cls_con.connect_Data();
st_sql = "SELECT count(mamh) FROM tbl_diem WHERE masv='" + st_msv + "'and mamh=" + st_mamon;
sqlcm = new SqlCommand(st_sql, cls_con.con);
int k = Convert.ToInt16(sqlcm.ExecuteScalar());
if (k == 0)
{
lbl_tb.Text = "Lỗi: Sinh viên không học môn này!";
lbl_tb.Visible = true;
}
else
{
int check;
st_sql = "UPDATE dbo.tbl_diem SET DiemC = " + st_diemc + ", DiemB = " + st_diemb + " , DiemA = " + st_diema + " , TongKet = " + tkso + " WHERE masv='" + st_msv + "'and mamh=" + st_mamon;
sqlcm = new SqlCommand(st_sql, cls_con.con);
check = sqlcm.ExecuteNonQuery();
if (check > 0)
{
Response.Redirect("~/dsdiem2.aspx?user="******"&type=update");
}
else
{
lbl_tb.Text = "Lỗi: Sửa dữ liệu không thành công!";
lbl_tb.Visible = true;
}
}
}
finally
{
cls_con.close_Data();
}
}
protected void btt_add_Click(object sender, EventArgs e)
{
Clsconnect cls_con = new Clsconnect();
SqlCommand sqlcm = new SqlCommand();
string st_user, st_pass, st_sql;
st_user = tbx_creatuser.Text;
st_pass = tbx_creatpass.Text;
try
{
cls_con.connect_Data();
st_sql = "SELECT count(username) FROM tbl_account WHERE username='******'";
sqlcm = new SqlCommand(st_sql, cls_con.con);
int k = Convert.ToInt16(sqlcm.ExecuteScalar());
if (k > 0)
{
lbl_tb.Text = "Lỗi: Tên đăng nhập đã tồn tại trong CSDL!";
lbl_tb.Visible = true;
}
else
{
int check;
st_sql = "INSERT INTO tbl_account (username,password) VALUES('" + st_user + "',N'" + st_pass + "');";
sqlcm = new SqlCommand(st_sql, cls_con.con);
check = sqlcm.ExecuteNonQuery();
if (check > 0)
{
lbl_tb.Text = "Lỗi: Thêm mới tài khoản thành công!";
Response.Redirect("~/loginView.aspx");
}
else
{
lbl_tb.Text = "Lỗi: Thêm mới dữ liệu không thành công!";
lbl_tb.Visible = true;
}
}
}
catch (SqlException ex)
{
Response.Write(ex);
}
finally
{
cls_con.close_Data();
}
}
public Boolean checkaccount(string username, string password)
{
Clsconnect cls_con = new Clsconnect();
bool check = true;
string query = "SELECT COUNT(*) FROM tbl_account where username='******' and password='******' ";
cls_con.connect_Data();
SqlCommand cmd = new SqlCommand(query, cls_con.con);
int check1 = (int)cmd.ExecuteScalar();
if (check1 == 0)
{
check = false;
}
cls_con.close_Data();
return(check);
}
protected void Page_Load(object sender, EventArgs e)
{
diem ds = new diem();
string st_msv = Request.QueryString.Get("user").ToString();
Clsconnect cls_con = new Clsconnect();
SqlCommand sqlcm, sqlcm1;
SqlDataReader re;
string check;
check = Request.QueryString.Get("type");
try
{
if (check == null)
{
lbl_tb.Text = "";
lbl_tb.Visible = true;
}
else if (check.ToString() == "update")
{
lbl_tb.Text = "Cập nhật điểm thành công";
lbl_tb.Visible = true;
}
cls_con.connect_Data();
string query1 = "Select tensv, tbl_sinhvien.Masv, tencn,tenlop from tbl_sinhvien inner join tbl_chuyennganh on chuyennganh = macn inner join tbl_addlop on tbl_addlop.MaSv = tbl_sinhvien.Masv inner join tbl_lop on tbl_addlop.Malop=tbl_lop.malop where tbl_sinhvien.Masv=" + st_msv;
string tensv = "", masv1 = "", cn = "", tenlop = "";
sqlcm1 = new SqlCommand(query1, cls_con.con);
SqlDataReader re1 = sqlcm1.ExecuteReader();
while (re1.Read())
{
tensv = re1.GetValue(0).ToString();
masv1 = re1.GetValue(1).ToString();
cn = re1.GetValue(2).ToString();
tenlop = re1.GetValue(3).ToString();
}
re1.Close();
lbl_tensv.Text = tensv;
lbl_masv.Text = masv1;
lbl_cn.Text = cn;
lbl_lop.Text = tenlop;
string st_kq = "";
string query = "SELECT tbl_addmonhoc.MaMH,TenMH,DiemC,DiemB,DiemA,TongKet,TinChi FROM dbo.tbl_diem INNER JOIN dbo.tbl_addmonhoc ON tbl_addmonhoc.MaDk = tbl_diem.MaDk INNER JOIN dbo.tbl_monhoc ON tbl_monhoc.MaMH = tbl_addmonhoc.MaMH WHERE dbo.tbl_diem.MaSv =" + st_msv;
st_kq = "<table class='w3-table w3-striped w3-bordered w3-border w3-hoverable w3-white w3-card'>";
st_kq = st_kq + "<tr class='w3-blue w3-center'><td><b>STT</b></td><td><b>Mã môn</b></td><td><b>Tên môn học</b></td><td><b>Tín chỉ</b></td><td><b>Điểm C</b></td><td><b>Điểm B</b></td><td><b>Điểm A</b></td><td><b>Tổng Kết(10)</b></td><td><b>Tổng Kết(CH)</b></td></tr>";
sqlcm = new SqlCommand(query, cls_con.con);
re = sqlcm.ExecuteReader();
byte i = 0;
while (re.Read())
{
i++;
string temp = re.GetValue(5).ToString();
string tkch = "";
double tkso = double.Parse(temp);
if (tkso < 4.0)
{
tkch = "F";
}
else
if (tkso <= 4.9)
{
tkch = "D";
}
else
if (tkso <= 5.4)
{
tkch = "D+";
}
else
if (tkso < 6.4)
{
tkch = "C";
}
else
if (tkso < 6.9)
{
tkch = "C+";
}
else
if (tkso < 7.9)
{
tkch = "B";
}
else
if (tkso < 8.4)
{
tkch = "B+";
}
else
{
tkch = "A";
}
st_kq = st_kq + " <tr><td>" + i.ToString() + "</td><td>" + re.GetValue(0).ToString() + "</td ><td>" + re.GetValue(1).ToString() + "</td ><td>" + re.GetValue(6).ToString() + "</td ><td>" + re.GetValue(2).ToString() + "</td ><td>" + re.GetValue(3).ToString() + "</td ><td>" + re.GetValue(4).ToString() + "</td ><td>" + re.GetValue(5).ToString() + "</td ><td>" + tkch + "</td ></tr > ";
}
re.Close();
st_kq = st_kq + "</table>";
dsach.Text = st_kq;
}
finally
{
cls_con.close_Data();
}
Label1.Text = ds.tongket(st_msv).ToString();
Label2.Text = ds.tongket1(st_msv).ToString();
Label3.Text = ds.tinchi(st_msv);
}
public AddMHDAL()
{
dataConnec = new Clsconnect();
}
public login()
{
cls_con = new Clsconnect();
}
public ktramasv()
{
dataConnec = new Clsconnect();
}
public diem()
{
cls_con = new Clsconnect();
}
