public static TuVanLamDichVu Insert(TuVanLamDichVu item)
{
var Item = new TuVanLamDichVu();
var obj = new SqlParameter[6];
obj[0] = new SqlParameter("LDV_ID", item.ID);
obj[1] = new SqlParameter("LDV_TVDV_ID", item.TVDV_ID);
obj[2] = new SqlParameter("LDV_KH_ID", item.KH_ID);
obj[3] = new SqlParameter("LDV_NhanVien", item.NhanVien);
if (item.NgayLam > DateTime.MinValue)
{
obj[4] = new SqlParameter("LDV_NgayLam", item.NgayLam);
}
else
{
obj[4] = new SqlParameter("LDV_NgayLam", DBNull.Value);
}
obj[5] = new SqlParameter("LDV_ThuTu", item.ThuTu);
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblSpaMgr_TuVanLamDichVu_Insert_InsertNormal_linhnx", obj))
{
while (rd.Read())
{
Item = getFromReader(rd);
}
}
return(Item);
}
public static TuVanLamDichVu SelectById(Guid LDV_ID)
{
var Item = new TuVanLamDichVu();
var obj = new SqlParameter[1];
obj[0] = new SqlParameter("LDV_ID", LDV_ID);
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblSpaMgr_TuVanLamDichVu_Select_SelectById_linhnx", obj))
{
while (rd.Read())
{
Item = getFromReader(rd);
}
}
return(Item);
}
public static TuVanLamDichVu getFromReader(IDataReader rd)
{
var Item = new TuVanLamDichVu();
if (rd.FieldExists("LDV_ID"))
{
Item.ID = (Guid)(rd["LDV_ID"]);
}
if (rd.FieldExists("LDV_TVDV_ID"))
{
Item.TVDV_ID = (Guid)(rd["LDV_TVDV_ID"]);
}
if (rd.FieldExists("LDV_KH_ID"))
{
Item.KH_ID = (Guid)(rd["LDV_KH_ID"]);
}
if (rd.FieldExists("LDV_NhanVien"))
{
Item.NhanVien = (String)(rd["LDV_NhanVien"]);
}
if (rd.FieldExists("LDV_NgayLam"))
{
Item.NgayLam = (DateTime)(rd["LDV_NgayLam"]);
}
if (rd.FieldExists("LDV_ThuTu"))
{
Item.ThuTu = (Int32)(rd["LDV_ThuTu"]);
}
if (rd.FieldExists("LDV_NhanVien_Ten"))
{
Item.NhanVien_Ten = (String)(rd["LDV_NhanVien_Ten"]);
}
if (rd.FieldExists("LDV_KH_Ten"))
{
Item.KH_Ten = (String)(rd["LDV_KH_Ten"]);
}
if (rd.FieldExists("LDV_DV_Ten"))
{
Item.DV_Ten = (String)(rd["LDV_DV_Ten"]);
}
Item._TuVanDichVu = TuVanDichVuDal.getFromReader(rd);
Item._XuatNhap = XuatNhapDal.getFromReader(rd);
return(Item);
}
