public static giaothuongHam Update(giaothuongHam Updated)
{
giaothuongHam Item = new giaothuongHam();
SqlParameter[] obj = new SqlParameter[17];
obj[0] = new SqlParameter("giaothuongHamID", Updated.giaothuongHamID);
obj[1] = new SqlParameter("tieude", Updated.tieude);
obj[2] = new SqlParameter("tieudeen", Updated.tieudeen);
obj[3] = new SqlParameter("mota", Updated.mota);
obj[4] = new SqlParameter("motaen", Updated.motaen);
obj[5] = new SqlParameter("chitiet", Updated.chitiet);
obj[6] = new SqlParameter("chitieten", Updated.chitieten);
obj[7] = new SqlParameter("hinhanh", Updated.hinhanh);
obj[8] = new SqlParameter("hinhanhlon", Updated.hinhanhlon);
obj[9] = new SqlParameter("xuatxu", Updated.xuatxu);
obj[10] = new SqlParameter("ngayhethan", Updated.ngayhethan);
obj[11] = new SqlParameter("ngaydang", Updated.ngaydang);
obj[12] = new SqlParameter("doanhnghiepID", Updated.doanhnghiepID);
obj[13] = new SqlParameter("nhomID", Updated.nhomID);
obj[14] = new SqlParameter("trangthai", Updated.trangthai);
obj[15] = new SqlParameter("loaigiaothuongHamID", Updated.loaigiaothuongHamID);
obj[16] = new SqlParameter("nhomconID", Updated.nhomconID);
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_giaothuongHam_Update_UpdateNormal_linhnx", obj))
{
while (rd.Read())
{
Item = getFromReader(rd);
}
}
return(Item);
}
public static giaothuongHam SelectById(Guid giaothuongHamID)
{
giaothuongHam Item = new giaothuongHam();
SqlParameter[] obj = new SqlParameter[1];
obj[0] = new SqlParameter("giaothuongHamID", giaothuongHamID);
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_giaothuongHam_Select_SelectById_linhnx", obj))
{
while (rd.Read())
{
Item = getFromReader(rd);
}
}
return(Item);
}
public static giaothuongHam getFromReader(IDataReader rd)
{
giaothuongHam Item = new giaothuongHam();
if (rd.FieldExists("giaothuongHamID"))
{
Item.giaothuongHamID = (Guid)(rd["giaothuongHamID"]);
}
if (rd.FieldExists("tieude"))
{
Item.tieude = (String)(rd["tieude"]);
}
if (rd.FieldExists("tieudeen"))
{
Item.tieudeen = (String)(rd["tieudeen"]);
}
if (rd.FieldExists("mota"))
{
Item.mota = (String)(rd["mota"]);
}
if (rd.FieldExists("motaen"))
{
Item.motaen = (String)(rd["motaen"]);
}
if (rd.FieldExists("chitiet"))
{
Item.chitiet = (String)(rd["chitiet"]);
}
if (rd.FieldExists("chitieten"))
{
Item.chitieten = (String)(rd["chitieten"]);
}
if (rd.FieldExists("hinhanh"))
{
Item.hinhanh = (String)(rd["hinhanh"]);
}
if (rd.FieldExists("hinhanhlon"))
{
Item.hinhanhlon = (String)(rd["hinhanhlon"]);
}
if (rd.FieldExists("xuatxu"))
{
Item.xuatxu = (String)(rd["xuatxu"]);
}
if (rd.FieldExists("ngayhethan"))
{
Item.ngayhethan = (DateTime)(rd["ngayhethan"]);
}
if (rd.FieldExists("ngaydang"))
{
Item.ngaydang = (DateTime)(rd["ngaydang"]);
}
if (rd.FieldExists("doanhnghiepID"))
{
Item.doanhnghiepID = (String)(rd["doanhnghiepID"]);
}
if (rd.FieldExists("nhomID"))
{
Item.nhomID = (String)(rd["nhomID"]);
}
if (rd.FieldExists("trangthai"))
{
Item.trangthai = (Int32)(rd["trangthai"]);
}
if (rd.FieldExists("loaigiaothuongHamID"))
{
Item.loaigiaothuongHamID = (Int16)(rd["loaigiaothuongHamID"]);
}
if (rd.FieldExists("nhomconID"))
{
Item.nhomconID = (String)(rd["nhomconID"]);
}
return(Item);
}
