public static MonhocInfo GetInfo(int monhoc_ID) { MonhocInfo retVal = null; var dbConn = new SqlConnection(AppEnv.ConnectionString); var dbCmd = new SqlCommand("Solart_Monhoc_GetInfo", dbConn) { CommandType = CommandType.StoredProcedure }; dbCmd.Parameters.AddWithValue("@Monhoc_ID", monhoc_ID); try { dbConn.Open(); var dr = dbCmd.ExecuteReader(); if (dr.Read()) { retVal = new MonhocInfo(); retVal.Monhoc_ID = ConvertUtility.ToInt32(dr["Monhoc_ID"]); retVal.Monhoc_Name = ConvertUtility.ToString(dr["Monhoc_Name"]); } if (dr != null) { dr.Close(); } } finally { dbConn.Close(); } return(retVal); }
private static MonhocInfo CreateEntityFromReader(IDataReader reader) { var item = new MonhocInfo(); try { if (!reader.IsDBNull(reader.GetOrdinal("Monhoc_ID"))) { item.Monhoc_ID = ConvertUtility.ToInt32(reader["Monhoc_ID"]); } } catch { } try { if (!reader.IsDBNull(reader.GetOrdinal("Monhoc_Name"))) { item.Monhoc_Name = ConvertUtility.ToString(reader["Monhoc_Name"]); } } catch { } return(item); }
public static void Update(MonhocInfo monhocInfo) { var dbConn = new SqlConnection(AppEnv.ConnectionString); var dbCmd = new SqlCommand("Solart_Monhoc_Update", dbConn) { CommandType = CommandType.StoredProcedure }; dbCmd.Parameters.AddWithValue("@Monhoc_ID", monhocInfo.Monhoc_ID); dbCmd.Parameters.AddWithValue("@Monhoc_Name", monhocInfo.Monhoc_Name); try { dbConn.Open(); dbCmd.ExecuteNonQuery(); } finally { dbConn.Close(); } }
public static int Insert(MonhocInfo monhocInfo) { var dbConn = new SqlConnection(AppEnv.ConnectionString); var dbCmd = new SqlCommand("Solart_Monhoc_Insert", dbConn) { CommandType = CommandType.StoredProcedure }; dbCmd.Parameters.AddWithValue("@Monhoc_Name", monhocInfo.Monhoc_Name); 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(); } }