public static int DeleteProfile(NhanVienObj qh)
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@ma", qh.MaNV)
};
return(ConnectToSQL_Datvd.Execute_NonQuery("XoaNhanVien", para));
}
public static int UpdateProfile(NhanVienObj qh)
{
SqlParameter[] para = new SqlParameter[]
{ new SqlParameter("@ma", qh.MaNV),
new SqlParameter("@gioitinh", qh.GioiTinh),
new SqlParameter("@ten", qh.TenNV),
new SqlParameter("@maquay", qh.MaQuay),
new SqlParameter("@ngay", qh.NgaySinh),
new SqlParameter("@luong", qh.Luong),
new SqlParameter("@diachi", qh.DiaChi),
new SqlParameter(@"sdt", qh.SDT) };
return(ConnectToSQL_Datvd.Execute_NonQuery("SuaNhanVien", para));
}
public static DataTable GetDataQuay()
{
try
{
DataTable dt = new DataTable();
string sql = " select * from QuayHang";
conn = ConnectToSQL_Datvd.Connect();
SqlDataAdapter da = new SqlDataAdapter(sql, conn);
da.Fill(dt);
conn.Close();
return(dt);
}
catch
{
conn.Close();
return(null);
}
}
public static DataTable GetData()
{
try
{
DataTable dt = new DataTable();
string sql = " select MaNV,TenNV,GioiTinh,DiaChi,SDT,NgaySinh,Luong,TenQuay from NhanVien n left join QuayHang q on n.MaQuay=q.MaQuay";
conn = ConnectToSQL_Datvd.Connect();
SqlDataAdapter da = new SqlDataAdapter(sql, conn);
da.Fill(dt);
conn.Close();
return(dt);
}
catch
{
conn.Close();
return(null);
}
}
