public static SuKien Update(SuKien item)
{
var Item = new SuKien();
var obj = new SqlParameter[17];
obj[0] = new SqlParameter("SK_ID", item.ID);
obj[1] = new SqlParameter("SK_DM_ID", item.DM_ID);
obj[2] = new SqlParameter("SK_PID", item.PID);
obj[3] = new SqlParameter("SK_KH_ID", item.KH_ID);
obj[4] = new SqlParameter("SK_Ten", item.Ten);
obj[5] = new SqlParameter("SK_MoTa", item.MoTa);
obj[6] = new SqlParameter("SK_NhanVien", item.NhanVien);
if (item.NgayBatDau > DateTime.MinValue)
{
obj[7] = new SqlParameter("SK_NgayBatDau", item.NgayBatDau);
}
else
{
obj[7] = new SqlParameter("SK_NgayBatDau", DBNull.Value);
}
if (item.NgayKetThuc > DateTime.MinValue)
{
obj[8] = new SqlParameter("SK_NgayKetThuc", item.NgayKetThuc);
}
else
{
obj[8] = new SqlParameter("SK_NgayKetThuc", DBNull.Value);
}
obj[9] = new SqlParameter("SK_CaNgay", item.CaNgay);
if (item.NgayTao > DateTime.MinValue)
{
obj[10] = new SqlParameter("SK_NgayTao", item.NgayTao);
}
else
{
obj[10] = new SqlParameter("SK_NgayTao", DBNull.Value);
}
obj[11] = new SqlParameter("SK_NguoiTao", item.NguoiTao);
if (item.NgayCapNhat > DateTime.MinValue)
{
obj[12] = new SqlParameter("SK_NgayCapNhat", item.NgayCapNhat);
}
else
{
obj[12] = new SqlParameter("SK_NgayCapNhat", DBNull.Value);
}
obj[13] = new SqlParameter("SK_NguoiCapNhat", item.NguoiCapNhat);
obj[14] = new SqlParameter("SK_BoQua", item.BoQua);
obj[15] = new SqlParameter("SK_Xoa", item.Xoa);
obj[16] = new SqlParameter("SK_ThanhCong", item.ThanhCong);
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblSpaMgr_SuKien_Update_UpdateNormal_linhnx", obj))
{
while (rd.Read())
{
Item = getFromReader(rd);
}
}
return(Item);
}
public static SuKien SelectById(Guid SK_ID)
{
var Item = new SuKien();
var obj = new SqlParameter[1];
obj[0] = new SqlParameter("SK_ID", SK_ID);
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblSpaMgr_SuKien_Select_SelectById_linhnx", obj))
{
while (rd.Read())
{
Item = getFromReader(rd);
}
}
return(Item);
}
public static SuKien getFromReader(IDataReader rd)
{
var Item = new SuKien();
if (rd.FieldExists("SK_ID"))
{
Item.ID = (Guid)(rd["SK_ID"]);
}
if (rd.FieldExists("SK_DM_ID"))
{
Item.DM_ID = (Guid)(rd["SK_DM_ID"]);
}
if (rd.FieldExists("SK_PID"))
{
Item.PID = (Guid)(rd["SK_PID"]);
}
if (rd.FieldExists("SK_KH_ID"))
{
Item.KH_ID = (Guid)(rd["SK_KH_ID"]);
}
if (rd.FieldExists("SK_Ten"))
{
Item.Ten = (String)(rd["SK_Ten"]);
}
if (rd.FieldExists("SK_MoTa"))
{
Item.MoTa = (String)(rd["SK_MoTa"]);
}
if (rd.FieldExists("SK_NhanVien"))
{
Item.NhanVien = (String)(rd["SK_NhanVien"]);
}
if (rd.FieldExists("SK_NgayBatDau"))
{
Item.NgayBatDau = (DateTime)(rd["SK_NgayBatDau"]);
}
if (rd.FieldExists("SK_NgayKetThuc"))
{
Item.NgayKetThuc = (DateTime)(rd["SK_NgayKetThuc"]);
}
if (rd.FieldExists("SK_CaNgay"))
{
Item.CaNgay = (Boolean)(rd["SK_CaNgay"]);
}
if (rd.FieldExists("SK_NgayTao"))
{
Item.NgayTao = (DateTime)(rd["SK_NgayTao"]);
}
if (rd.FieldExists("SK_NguoiTao"))
{
Item.NguoiTao = (String)(rd["SK_NguoiTao"]);
}
if (rd.FieldExists("SK_NgayCapNhat"))
{
Item.NgayCapNhat = (DateTime)(rd["SK_NgayCapNhat"]);
}
if (rd.FieldExists("SK_NguoiCapNhat"))
{
Item.NguoiCapNhat = (String)(rd["SK_NguoiCapNhat"]);
}
if (rd.FieldExists("SK_BoQua"))
{
Item.BoQua = (Boolean)(rd["SK_BoQua"]);
}
if (rd.FieldExists("SK_Xoa"))
{
Item.Xoa = (Boolean)(rd["SK_Xoa"]);
}
if (rd.FieldExists("SK_NhanVien_Ten"))
{
Item.NhanVien_Ten = (String)(rd["SK_NhanVien_Ten"]);
}
if (rd.FieldExists("SK_DM_Ten"))
{
Item.DM_Ten = (String)(rd["SK_DM_Ten"]);
}
if (rd.FieldExists("KH_Ten"))
{
Item.KH_Ten = (String)(rd["KH_Ten"]);
}
if (rd.FieldExists("SK_ThanhCong"))
{
Item.ThanhCong = (Boolean)(rd["SK_ThanhCong"]);
}
return(Item);
}
