/// <summary>
/// Chỗ này truyền vào tương tự hàm sửa.cũng theo khóa chính
/// </summary>
/// <param name="Ma"></param>
/// <returns></returns>
public HSSV LayHSSV(string Ma)
{
SqlParameter[] parm = new SqlParameter[] {
new SqlParameter(PARM_MAHSSV, SqlDbType.NVarChar, 30)
};
parm[0].Value = Ma;
SqlDataReader d = DALHelper.ExecuteReader(DALHelper.ConnectionString, CommandType.StoredProcedure, "tblHSSV_Lay1", parm);
HSSV hs = new HSSV();
if (d.Read())
{
hs.MaHSSV = d[0].ToString();
hs.HoTen = d[1].ToString();
hs.MaLop = d[2].ToString();
hs.GioiTinh = bool.Parse(d[3].ToString());
hs.NgaySinh = DateTime.Parse(d[4].ToString());
hs.NoiSinh = d[5].ToString();
hs.QueQuan = d[6].ToString();
hs.NoiOHienNay = d[7].ToString();
hs.DienThoai = d[8].ToString();
hs.EMail = d[9].ToString();
hs.UrlPhoto = d[10].ToString();
hs.GhiChu = d[11].ToString();
hs.MatKhau = d[12].ToString();
hs.TrangThai = bool.Parse(d[13].ToString());
}
return(hs);
}
public List <HSSV> DSHSSV()
{
SqlDataReader d = DALHelper.ExecuteReader(DALHelper.ConnectionString, CommandType.StoredProcedure, "tblHSSV_DS", null);//chỗ này để ý cuối là null
List <HSSV> mylist = new List <HSSV>();
while (d.Read())
{
HSSV hs = new HSSV();
hs.MaHSSV = d[0].ToString();
hs.HoTen = d[1].ToString();
hs.MaLop = d[2].ToString();
hs.GioiTinh = bool.Parse(d[3].ToString());
hs.NgaySinh = DateTime.Parse(d[4].ToString());
hs.NoiSinh = d[5].ToString();
hs.QueQuan = d[6].ToString();
hs.NoiOHienNay = d[7].ToString();
hs.DienThoai = d[8].ToString();
hs.EMail = d[9].ToString();
hs.UrlPhoto = d[10].ToString();
hs.GhiChu = d[11].ToString();
hs.MatKhau = d[12].ToString();
hs.TrangThai = bool.Parse(d[13].ToString());
mylist.Add(hs);
}
d.Dispose();
return(mylist);
}
protected void btnSave_Click(object sender, EventArgs e)
{
HSSV hssv = new HSSV();
hssv.HoTen = txtHoTen.Text;
hssv.MaLop = txtMaLop.Text;
hssv.GioiTinh = rdbNam.Checked;
hssv.NgaySinh = DateTime.Parse(txtNgaySinh.Text);
hssv.NoiSinh = txtNoiSinh.Text;
hssv.QueQuan = txtQueQuan.Text;
hssv.NoiOHienNay = txtNoiOHienNay.Text;
hssv.DienThoai = txtDienThoai.Text;
hssv.EMail = txtEMail.Text;
hssv.GhiChu = txtGhiChu.Text;
hssv.MatKhau = txtMatKhau.Text;
hssv.TrangThai = rdHD.Checked;
if (fileAnh.HasFile)
{
hssv.UrlPhoto = Up(fileAnh);
}
if (editType.Value == "add")
{
hssv.MaHSSV = txtMaHSSV.Text;
int t = hssvbll.Them(hssv);
LoadHSSV();
}
else
{
hssv.MaHSSV = txtMaHSSV.Text;
hssvbll.Sua(hssv);
LoadHSSV();
EditState.Value = "hide";
}
EditState.Value = "hide";
//if (fileAnh.HasFile)
//{
// hssv.UrlPhoto = Up(fileAnh);
//}
//if (editType.Value == "add")
//{
// hssv.MaHSSV = txtMaHSSV.Text;
// int t = hssvbll.Them(hssv);
// LoadHSSV();
//}
//else
//{
// hssv.MaHSSV = txtMaHSSV.Text;
// hssvbll.Sua(hssv);
// LoadHSSV();
// EditState.Value = "hide";
//}
}
protected void grvHSSV_RowCommand(object sender, GridViewCommandEventArgs e)
{
GridViewRow gvr;
try
{
gvr = (GridViewRow)(((LinkButton)e.CommandSource).NamingContainer);
}
catch { return; }
int index = gvr.RowIndex;
if (e.CommandName == "Sua")
{
HSSV hssv = new HSSV();
GridViewRow gvrow = grvHSSV.Rows[index];
txtMaHSSV.Enabled = false;
txtMaHSSV.Text = HttpUtility.HtmlDecode(gvrow.Cells[0].Text).ToString();
hssv = hssvbll.LayHSSV(txtMaHSSV.Text);
txtHoTen.Text = hssv.HoTen;
txtMaLop.Text = hssv.MaLop;
if (hssv.GioiTinh)
{
rdbNam.Checked = true;
}
else
{
rdbNu.Checked = true;
}
txtNgaySinh.Text = hssv.NgaySinh.ToShortDateString();
txtNoiSinh.Text = hssv.NoiSinh;
txtQueQuan.Text = hssv.QueQuan;
txtNoiOHienNay.Text = hssv.NoiOHienNay;
txtDienThoai.Text = hssv.DienThoai;
txtEMail.Text = hssv.EMail;
txtGhiChu.Text = hssv.GhiChu;
if (hssv.TrangThai)
{
rdHD.Checked = true;
}
else
{
rdKHD.Checked = true;
}
EditState.Value = "edit";
editType.Value = "edit";
}
else
if (e.CommandName == "Xoa")
{
GridViewRow gvrow = grvHSSV.Rows[index];
string id = HttpUtility.HtmlDecode(gvrow.Cells[0].Text).ToString();
idDelete.Value = id;
EditState.Value = "delete";
}
}
public int Sua(HSSV hs)
{
SqlParameter[] parm = new SqlParameter[] {
new SqlParameter(PARM_MAHSSV, SqlDbType.NVarChar, 30),
new SqlParameter(PARM_HOTEN, SqlDbType.NVarChar, 30),
new SqlParameter(PARM_MALOP, SqlDbType.NVarChar, 30),
new SqlParameter(PARM_GIOITINH, SqlDbType.Bit),
new SqlParameter(PARM_NGAYSINH, SqlDbType.Date),
new SqlParameter(PARM_NOISINH, SqlDbType.NVarChar, 100),
new SqlParameter(PARM_QUEQUAN, SqlDbType.NVarChar, 100),
new SqlParameter(PARM_NOIOHIENNAY, SqlDbType.NVarChar, 100),
new SqlParameter(PARM_DIENTHOAI, SqlDbType.NVarChar, 30),
new SqlParameter(PARM_EMAIL, SqlDbType.NVarChar, 30),
new SqlParameter(PARM_URLPHOTO, SqlDbType.NVarChar, 150),
new SqlParameter(PARM_GHICHU, SqlDbType.NVarChar, 1000),
new SqlParameter(PARM_MATKHAU, SqlDbType.NVarChar, 30),
new SqlParameter(PARM_TRANGTHAI, SqlDbType.Bit)
};
parm[0].Value = hs.MaHSSV;
parm[1].Value = hs.HoTen;
parm[2].Value = hs.MaLop;
parm[3].Value = hs.GioiTinh;
parm[4].Value = hs.NgaySinh;
parm[5].Value = hs.NoiSinh;
parm[6].Value = hs.QueQuan;
parm[7].Value = hs.NoiOHienNay;
parm[8].Value = hs.DienThoai;
parm[9].Value = hs.EMail;
if (hs.UrlPhoto == "" || hs.UrlPhoto == null)
{
parm[10].Value = DBNull.Value;
}
else
{
parm[10].Value = hs.UrlPhoto;
}
if (hs.GhiChu == "" || hs.GhiChu == null)
{
parm[11].Value = DBNull.Value;
}
else
{
parm[11].Value = hs.GhiChu;
}
parm[12].Value = hs.MatKhau;
parm[13].Value = hs.TrangThai;
return(DALHelper.ExecuteNonQuery(DALHelper.ConnectionString, CommandType.StoredProcedure, "tblHSSV_Sua", parm));
}
public HSSV Login(string Ma, string pass)
{
SqlParameter[] parm = new SqlParameter[] {
new SqlParameter(PARM_MAHSSV, SqlDbType.NVarChar, 30),
new SqlParameter(PARM_MATKHAU, SqlDbType.NVarChar, 30)
};
parm[0].Value = Ma;
parm[1].Value = pass;
SqlDataReader d = DALHelper.ExecuteReader(DALHelper.ConnectionString, CommandType.StoredProcedure, "tblHSSV_Login", parm);
HSSV tt = new HSSV();
if (d.Read())
{
tt.MaHSSV = d[0].ToString();
tt.HoTen = d[1].ToString();
tt.UrlPhoto = d[2].ToString();
}
return(tt);
}
public int Sua(HSSV hs)
{
return(hsdal.Sua(hs));
}
public int Them(HSSV hs)
{
return(hsdal.Them(hs));
}
