public static PagesMgr getFromReader(IDataReader rd)
{
PagesMgr Item = new PagesMgr();
if (rd.FieldExists("PG_ID"))
{
Item.ID = (Int32)(rd["PG_ID"]);
}
if (rd.FieldExists("PG_Ten"))
{
Item.Ten = (String)(rd["PG_Ten"]);
}
if (rd.FieldExists("PG_Alias"))
{
Item.Alias = (String)(rd["PG_Alias"]);
}
if (rd.FieldExists("PG_Active"))
{
Item.Active = (Boolean)(rd["PG_Active"]);
}
if (rd.FieldExists("PG_KeyWords"))
{
Item.KeyWords = (String)(rd["PG_KeyWords"]);
}
if (rd.FieldExists("PG_Descriptions"))
{
Item.Descriptions = (String)(rd["PG_Descriptions"]);
}
return(Item);
}
public static PagesMgr SelectById(Int32 PG_ID)
{
PagesMgr Item = new PagesMgr();
SqlParameter[] obj = new SqlParameter[1];
obj[0] = new SqlParameter("PG_ID", PG_ID);
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblPagesMgr_Select_SelectById_linhnx", obj))
{
while (rd.Read())
{
Item = getFromReader(rd);
}
}
return(Item);
}
public static PagesMgr Insert(PagesMgr Inserted)
{
PagesMgr Item = new PagesMgr();
SqlParameter[] obj = new SqlParameter[5];
obj[0] = new SqlParameter("PG_Ten", Inserted.Ten);
obj[1] = new SqlParameter("PG_Alias", Inserted.Alias);
obj[2] = new SqlParameter("PG_Active", Inserted.Active);
obj[3] = new SqlParameter("PG_KeyWords", Inserted.KeyWords);
obj[4] = new SqlParameter("PG_Descriptions", Inserted.Descriptions);
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblPagesMgr_Insert_InsertNormal_linhnx", obj))
{
while (rd.Read())
{
Item = getFromReader(rd);
}
}
return(Item);
}
