public bool SuaBanDoc(MemberDb bd)
{
try
{
String sql = "UPDATE [BanDoc]"
+ " SET [HoTen] = @HoTen"
+ " ,[Email] = @Email"
+ " ,[DiaChi] = @DiaChi"
+ " ,[NamSinh] = @NamSinh"
+ " ,[SoDienThoai] = @SoDienThoai"
+ " WHERE ID = @ID";
DatabaseParamCls[] newVariable = null;
newVariable = new DatabaseParamCls[] {
new DatabaseParamCls("HoTen", bd.HoTen),
new DatabaseParamCls("Email", bd.Email),
new DatabaseParamCls("DiaChi", bd.DiaChi),
new DatabaseParamCls("NamSinh", Common.convertDateFormat(bd.NamSinh, "yyyy-MM-dd")),
new DatabaseParamCls("SoDienThoai", bd.SoDienThoai),
new DatabaseParamCls("ID", bd.ID)
};
dt = dpro.GetRecordSet(sql, newVariable);
return(true);
}
catch (Exception e)
{
throw e;
}
return(false);
}
public bool SuaNhanVien(NhanVienDb nv)
{
try
{
String sql = "UPDATE [NhanVien]"
+ " SET [TenDangNhap] = @TenDangNhap";
if (!String.IsNullOrWhiteSpace(nv.MatKhau))
{
sql += " ,[MatKhau] = @MatKhau";
}
sql += " ,[HoTen] = @HoTen"
+ " ,[Email] = @Email"
+ " ,[DiaChi] = @DiaChi"
+ " ,[NamSinh] = @NamSinh"
+ " ,[QueQuan] = @QueQuan"
+ " ,[PhanQuyen] = @PhanQuyen"
+ " ,[SoDienThoai] = @SoDienThoai"
+ " WHERE ID = @ID";
DatabaseParamCls[] newVariable = null;
if (!String.IsNullOrWhiteSpace(nv.MatKhau))
{
newVariable = new DatabaseParamCls[] {
new DatabaseParamCls("TenDangNhap", nv.TenDangNhap),
new DatabaseParamCls("MatKhau", nv.MatKhau),
new DatabaseParamCls("HoTen", nv.HoTen),
new DatabaseParamCls("Email", nv.Email),
new DatabaseParamCls("DiaChi", nv.DiaChi),
new DatabaseParamCls("NamSinh", Common.convertDateFormat(nv.NamSinh, "yyyy-MM-dd")),
new DatabaseParamCls("QueQuan", nv.QueQuan),
new DatabaseParamCls("PhanQuyen", nv.PhanQuyen),
new DatabaseParamCls("SoDienThoai", nv.SoDienThoai),
new DatabaseParamCls("ID", nv.Id)
};
}
else
{
newVariable = new DatabaseParamCls[] {
new DatabaseParamCls("TenDangNhap", nv.TenDangNhap),
new DatabaseParamCls("HoTen", nv.HoTen),
new DatabaseParamCls("Email", nv.Email),
new DatabaseParamCls("DiaChi", nv.DiaChi),
new DatabaseParamCls("NamSinh", Common.convertDateFormat(nv.NamSinh, "yyyy-MM-dd")),
new DatabaseParamCls("QueQuan", nv.QueQuan),
new DatabaseParamCls("PhanQuyen", nv.PhanQuyen),
new DatabaseParamCls("SoDienThoai", nv.SoDienThoai),
new DatabaseParamCls("ID", nv.Id)
};
}
dt = dpro.GetRecordSet(sql, newVariable);
return(true);
}
catch (Exception e)
{
throw e;
}
return(false);
}
