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); }