public static UserFunction Update(UserFunction Updated)
{
UserFunction Item = new UserFunction();
SqlParameter[] obj = new SqlParameter[10];
obj[0] = new SqlParameter("UF_ID", Updated.ID);
obj[1] = new SqlParameter("UF_Username", Updated.Username);
obj[2] = new SqlParameter("UF_LAY_ID", Updated.LAY_ID);
obj[3] = new SqlParameter("UF_FN_ID", Updated.FN_ID);
obj[4] = new SqlParameter("UF_FN_Url", Updated.FN_Url);
obj[5] = new SqlParameter("UF_Doc", Updated.Doc);
obj[6] = new SqlParameter("UF_ThuTu", Updated.ThuTu);
obj[7] = new SqlParameter("UF_RowId", Updated.RowId);
obj[8] = new SqlParameter("UF_NgayTao", Updated.NgayTao);
obj[9] = new SqlParameter("UF_NguoiTao", Updated.NguoiTao);
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblUserFunction_Update_UpdateNormal_linhnx", obj))
{
while (rd.Read())
{
Item = getFromReader(rd);
}
}
return(Item);
}
public static UserFunction SelectById(Int32 UF_ID)
{
UserFunction Item = new UserFunction();
SqlParameter[] obj = new SqlParameter[1];
obj[0] = new SqlParameter("UF_ID", UF_ID);
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblUserFunction_Select_SelectById_linhnx", obj))
{
while (rd.Read())
{
Item = getFromReader(rd);
}
}
return(Item);
}
public static UserFunction getFromReader(IDataReader rd)
{
UserFunction Item = new UserFunction();
Item.ID = (Int32)(rd["UF_ID"]);
Item.Username = (String)(rd["UF_Username"]);
Item.LAY_ID = (Int32)(rd["UF_LAY_ID"]);
Item.FN_ID = (Int32)(rd["UF_FN_ID"]);
Item.FN_Url = (String)(rd["UF_FN_Url"]);
Item.Doc = (String)(rd["UF_Doc"]);
Item.ThuTu = (Int32)(rd["UF_ThuTu"]);
Item.RowId = (Guid)(rd["UF_RowId"]);
Item.NgayTao = (DateTime)(rd["UF_NgayTao"]);
Item.NguoiTao = (String)(rd["UF_NguoiTao"]);
return(Item);
}