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