/// <summary> /// Creates an instance of Department from the data record in the database. /// </summary> /// <param name="myRecord">Single row of record.</param> /// <returns>An Department.</returns> private static Department FillRecord(IDataRecord myRecord) { Department myDepartment = new Department(); myDepartment.DNo = myRecord.GetInt32(myRecord.GetOrdinal("DNo")); myDepartment.DName = myRecord.GetString(myRecord.GetOrdinal("DName")); myDepartment.DLocation = myRecord.GetString(myRecord.GetOrdinal("DLocation")); return myDepartment; }
/// <summary> /// Saves an Department in the database. /// </summary> /// <param name="myDepartment">The Department to store.</param> /// <returns>The new Department id if the Department is new in the database or the existing ID when an record was updated.</returns> public static int Save(Department myDepartment) { int result = 0; using (SqlConnection myConnection = new SqlConnection(AppSettings.ConnectionString)) { SqlCommand myCommand = new SqlCommand("spSaveDepartment", myConnection); myCommand.CommandType = CommandType.StoredProcedure; myCommand.Parameters.AddWithValue("@DNo", myDepartment.DNo); myCommand.Parameters.AddWithValue("@DName", myDepartment.DName); myCommand.Parameters.AddWithValue("@DLocation", myDepartment.DLocation); DbParameter retValue = myCommand.CreateParameter(); retValue.Direction = ParameterDirection.ReturnValue; myCommand.Parameters.Add(retValue); myConnection.Open(); myCommand.ExecuteNonQuery(); result = Convert.ToInt32(retValue.Value); myConnection.Close(); } return result; }