public bool CapNhatInfo(string tendangnhap, string ten, string ho, string password, string birthday, int gioitinh, string sdt, string quequan, byte[] anh, int tucach, int maso)
{
SqlCommand cmd = new SqlCommand("sp_updateSinhVien");
cmd.CommandType = CommandType.StoredProcedure;
object b = anh;
cmd.Parameters.Add("@ms", SqlDbType.Int).Value = maso;
cmd.Parameters.Add("@TenDN", SqlDbType.NVarChar, 20).Value = tendangnhap;
cmd.Parameters.Add("@Ten", SqlDbType.NVarChar, 20).Value = ten;
cmd.Parameters.Add("@Ho", SqlDbType.NVarChar, 20).Value = ho;
cmd.Parameters.Add("@password", SqlDbType.NVarChar, 20).Value = password;
cmd.Parameters.Add("@birthday", SqlDbType.DateTime).Value = birthday;
cmd.Parameters.Add("@GioiTInh", SqlDbType.Int).Value = gioitinh;
cmd.Parameters.Add("@Sdt", SqlDbType.NVarChar, 15).Value = sdt;
cmd.Parameters.Add("@QueQuan", SqlDbType.NVarChar, 20).Value = quequan;
cmd.Parameters.Add("@Anh", SqlDbType.Image).Value = (b == null) ? DBNull.Value : b;
cmd.Parameters.Add("@TuCach", SqlDbType.Int).Value = tucach;
GlobalVariable.GVPassword = password;
try
{
GlobalVariable.GVAnh = anh;
}
catch
{
GlobalVariable.GVAnh = null;
}
return(dangnhap.ExecuteNonQuery(cmd));
}
public bool RestoreUsers(int maso, int tucach)
{
SqlCommand cmd = new SqlCommand("sp_restoreuser");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@maso", SqlDbType.Int).Value = maso;
cmd.Parameters.Add("@tc", SqlDbType.Int).Value = tucach;
return(dangnhap.ExecuteNonQuery(cmd));
}
public void updateClass(int malop, int magv, int mamh, string hocky, string namhoc, int siso, string tenLop)
{
SqlCommand cmd = new SqlCommand("sp_updateClass");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@malop", SqlDbType.Int).Value = malop;
cmd.Parameters.Add("@magv", SqlDbType.Int).Value = magv;
cmd.Parameters.Add("@mamh", SqlDbType.Int).Value = mamh;
cmd.Parameters.Add("@hk", SqlDbType.Char, 5).Value = hocky;
cmd.Parameters.Add("@namhoc", SqlDbType.Char, 15).Value = namhoc;
cmd.Parameters.Add("@ss", SqlDbType.Int).Value = siso;
cmd.Parameters.Add("@tenlop", SqlDbType.Char, 15).Value = tenLop;
dangnhap.ExecuteNonQuery(cmd);
}
public void DangKiHocPhan(int malop, int masv)
{
SqlCommand cmd = new SqlCommand("sp_InsertNewStudenttoClass");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@malop", SqlDbType.Int).Value = malop;
cmd.Parameters.Add("@masv", SqlDbType.Int).Value = masv;
dangnhap.ExecuteNonQuery(cmd);
}
public bool CapNhatDsDiem(float tk, float gk, float ck, int masv, int malop)
{
SqlCommand cmd = new SqlCommand("sp_CapNhatDiem");
cmd.CommandType = CommandType.StoredProcedure;
// TK
if (tk != -1)
{
cmd.Parameters.Add("@tk", SqlDbType.Float).Value = tk;
}
else
{
cmd.Parameters.Add("@tk", SqlDbType.Float).Value = DBNull.Value;
}
//GK
if (gk != -1)
{
cmd.Parameters.Add("@gk", SqlDbType.Float).Value = gk;
}
else
{
cmd.Parameters.Add("@gk", SqlDbType.Float).Value = DBNull.Value;
}
// CK
if (ck != -1)
{
cmd.Parameters.Add("@ck", SqlDbType.Float).Value = ck;
}
else
{
cmd.Parameters.Add("@ck", SqlDbType.Float).Value = DBNull.Value;
}
cmd.Parameters.Add("@masv", SqlDbType.Char, 15).Value = masv;
cmd.Parameters.Add("@malop", SqlDbType.Int).Value = malop;
return(dangnhap.ExecuteNonQuery(cmd));
}
public bool insertNewSinhVien(string tendangnhap, string ten, string ho, string password, string birthday, int gioitinh, string sdt, string quequan, byte[] anh)
{
SqlCommand cmd = new SqlCommand("sp_insertNewSinhVien");
cmd.CommandType = CommandType.StoredProcedure;
object b = anh;
cmd.Parameters.Add("@TenDN", SqlDbType.NVarChar, 20).Value = tendangnhap;
cmd.Parameters.Add("@Ten", SqlDbType.NVarChar, 20).Value = ten;
cmd.Parameters.Add("@Ho", SqlDbType.NVarChar, 20).Value = ho;
cmd.Parameters.Add("@password", SqlDbType.NVarChar, 20).Value = password;
cmd.Parameters.Add("@birthday", SqlDbType.DateTime).Value = birthday;
cmd.Parameters.Add("@GioiTInh", SqlDbType.Int).Value = gioitinh;
cmd.Parameters.Add("@Sdt", SqlDbType.NVarChar, 15).Value = sdt;
cmd.Parameters.Add("@QueQuan", SqlDbType.NVarChar, 20).Value = quequan;
cmd.Parameters.Add("@Anh", SqlDbType.Image).Value = (b == null) ? DBNull.Value : b;
cmd.Parameters.Add("@TuCach", SqlDbType.Int).Value = 0;
return(dangnhap.ExecuteNonQuery(cmd));
}