public static PluginZone SelectById(Int32 PZ_ID)
{
PluginZone Item = new PluginZone();
SqlParameter[] obj = new SqlParameter[1];
obj[0] = new SqlParameter("PZ_ID", PZ_ID);
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblPluginZone_Select_SelectById_hoangda", obj))
{
while (rd.Read())
{
Item = getFromReader(rd);
}
}
return(Item);
}
public static PluginZone UpdateMove(string id, string z_id, string thuTu)
{
PluginZone Item = new PluginZone();
SqlParameter[] obj = new SqlParameter[3];
obj[0] = new SqlParameter("PZ_ID", id);
obj[1] = new SqlParameter("PZ_Z_ID", z_id);
obj[2] = new SqlParameter("PZ_ThuTu", thuTu);
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblPluginZone_Update_UpdateMove_hoangda", obj))
{
while (rd.Read())
{
Item = getFromReader(rd);
}
}
return(Item);
}
public static PluginZone Insert(PluginZone Inserted)
{
PluginZone Item = new PluginZone();
SqlParameter[] obj = new SqlParameter[3];
obj[0] = new SqlParameter("PZ_Z_ID", Inserted.Z_ID);
obj[1] = new SqlParameter("PZ_Settings", Inserted.Settings);
obj[2] = new SqlParameter("PZ_ThuTu", Inserted.ThuTu);
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblPluginZone_Insert_InsertNormal_hoangda", obj))
{
while (rd.Read())
{
Item = getFromReader(rd);
}
}
return(Item);
}
public static PluginZone getFromReader(IDataReader rd)
{
PluginZone Item = new PluginZone();
if (rd.FieldExists("PZ_ID"))
{
Item.ID = (Int32)(rd["PZ_ID"]);
}
if (rd.FieldExists("PZ_Z_ID"))
{
Item.Z_ID = (Int32)(rd["PZ_Z_ID"]);
}
if (rd.FieldExists("PZ_Settings"))
{
Item.Settings = (String)(rd["PZ_Settings"]);
}
if (rd.FieldExists("PZ_ThuTu"))
{
Item.ThuTu = (Int32)(rd["PZ_ThuTu"]);
}
return(Item);
}