public static NhomTin Insert(Int32?id, Int32?n_id, Int32?t_id)
{
NhomTin Item = new NhomTin();
SqlParameter[] obj = new SqlParameter[2];
if (n_id != null)
{
obj[0] = new SqlParameter("NT_N_ID", n_id);
}
else
{
obj[0] = new SqlParameter("NT_N_ID", DBNull.Value);
}
if (t_id != null)
{
obj[1] = new SqlParameter("NT_T_ID", t_id);
}
else
{
obj[1] = new SqlParameter("NT_T_ID", DBNull.Value);
}
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "tblRss_sp_tblRssNhomTin_Insert_InsertNormal_linhnx", obj))
{
while (rd.Read())
{
Item = getFromReader(rd);
}
}
return(Item);
}
public static NhomTin SelectById(Int32 NT_ID)
{
NhomTin Item = new NhomTin();
SqlParameter[] obj = new SqlParameter[1];
obj[0] = new SqlParameter("NT_ID", NT_ID);
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "tblRss_sp_tblRssNhomTin_Select_SelectById_linhnx", obj))
{
while (rd.Read())
{
Item = getFromReader(rd);
}
}
return(Item);
}
public static NhomTin Insert(NhomTin Inserted)
{
NhomTin Item = new NhomTin();
SqlParameter[] obj = new SqlParameter[2];
obj[0] = new SqlParameter("NT_N_ID", Inserted.N_ID);
obj[1] = new SqlParameter("NT_T_ID", Inserted.T_ID);
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "tblRss_sp_tblRssNhomTin_Insert_InsertNormal_linhnx", obj))
{
while (rd.Read())
{
Item = getFromReader(rd);
}
}
return(Item);
}
/// <summary>
/// hampv
/// </summary>
/// <param name="ROLE_ID"></param>
/// <param name="FN_List"></param>
/// <param name="NguoiTao"></param>
/// <returns></returns>
public static NhomTin UpdateByTIN_IdDanhmucList(string TIN_ID, string DM_List)
{
NhomTin Item = new NhomTin();
SqlParameter[] obj = new SqlParameter[3];
obj[0] = new SqlParameter("TIN_ID", TIN_ID);
obj[1] = new SqlParameter("DM_List", DM_List);
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblRssNhomTin_Update_UpdateByDM_IdDanhmucList_linhnx", obj))
{
while (rd.Read())
{
Item = getFromReader(rd);
}
}
return(Item);
}
public static NhomTin getFromReader(IDataReader rd)
{
NhomTin Item = new NhomTin();
Tin _Item = new Tin();
_Item = TinDal.getFromReader(rd);
if (rd.FieldExists("NT_ID"))
{
Item.ID = (Int32)(rd["NT_ID"]);
}
if (rd.FieldExists("NT_N_ID"))
{
Item.N_ID = (Int32)(rd["NT_N_ID"]);
}
if (rd.FieldExists("NT_T_ID"))
{
Item.T_ID = (Int32)(rd["NT_T_ID"]);
}
Item._Tin = _Item;
return(Item);
}
