public static HocsinhRegisterInfo GetInfo(int hocsinh_ID, int contentId)
{
HocsinhRegisterInfo retVal = null;
var dbConn = new SqlConnection(AppEnv.ConnectionString);
var dbCmd = new SqlCommand("Solart_Register_GetInfo", dbConn)
{
CommandType = CommandType.StoredProcedure
};
dbCmd.Parameters.AddWithValue("@Hocsinh_ID", hocsinh_ID);
dbCmd.Parameters.AddWithValue("@Content_ID", contentId);
try
{
dbConn.Open();
var dr = dbCmd.ExecuteReader();
if (dr.Read())
{
retVal = new HocsinhRegisterInfo();
retVal.Hocsinh_ID = ConvertUtility.ToInt32(dr["Hocsinh_ID"]);
retVal.Content_ID = ConvertUtility.ToInt32(dr["Content_ID"]);
retVal.RegisterTime = ConvertUtility.ToDateTime(dr["RegisterTime"]);
}
if (dr != null)
{
dr.Close();
}
}
finally
{
dbConn.Close();
}
return(retVal);
}
public static void Update(HocsinhRegisterInfo hocsinhRegisterInfo)
{
var dbConn = new SqlConnection(AppEnv.ConnectionString);
var dbCmd = new SqlCommand("Solart_Register_Update", dbConn)
{
CommandType = CommandType.StoredProcedure
};
dbCmd.Parameters.AddWithValue("@Hocsinh_ID", hocsinhRegisterInfo.Hocsinh_ID);
dbCmd.Parameters.AddWithValue("@Content_ID", hocsinhRegisterInfo.Content_ID);
dbCmd.Parameters.AddWithValue("@RegisterTime", hocsinhRegisterInfo.RegisterTime);
try
{
dbConn.Open();
dbCmd.ExecuteNonQuery();
}
finally
{
dbConn.Close();
}
}
public static int Insert(HocsinhRegisterInfo hocsinhRegisterInfo)
{
var dbConn = new SqlConnection(AppEnv.ConnectionString);
var dbCmd = new SqlCommand("Solart_Register_Insert", dbConn)
{
CommandType = CommandType.StoredProcedure
};
dbCmd.Parameters.AddWithValue("@Hocsinh_ID", hocsinhRegisterInfo.Hocsinh_ID);
dbCmd.Parameters.AddWithValue("@Content_ID", hocsinhRegisterInfo.Content_ID);
dbCmd.Parameters.AddWithValue("@RegisterTime", hocsinhRegisterInfo.RegisterTime);
dbCmd.Parameters.AddWithValue("@RETURN_VALUE", SqlDbType.Int).Direction = ParameterDirection.ReturnValue;
try
{
dbConn.Open();
dbCmd.ExecuteNonQuery();
return((int)dbCmd.Parameters["@RETURN_VALUE"].Value);
}
finally
{
dbConn.Close();
}
}
private static HocsinhRegisterInfo CreateEntityFromReader(IDataReader reader)
{
var item = new HocsinhRegisterInfo();
try { if (!reader.IsDBNull(reader.GetOrdinal("Hocsinh_ID")))
{
item.Hocsinh_ID = ConvertUtility.ToInt32(reader["Hocsinh_ID"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Content_ID")))
{
item.Content_ID = ConvertUtility.ToInt32(reader["Content_ID"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("RegisterTime")))
{
item.RegisterTime = ConvertUtility.ToDateTime(reader["RegisterTime"]);
}
}
catch { }
return(item);
}
