/// <summary>
/// Saves a Instructor in the database.
/// </summary>
/// <param name="myInstructor">The Instructor to store.</param>
/// <returns>The new ID if the Instructor is new in the database or the existing ID when an record was updated.</returns>
public static int Save(Instructor myInstructor)
{
int result = 0;
using (SqlConnection myConnection = new SqlConnection(AppSettings.ConnectionString))
{
SqlCommand myCommand = new SqlCommand("spSaveInstructor", myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.AddWithValue("@IID", myInstructor.IId);
myCommand.Parameters.AddWithValue("@Password", myInstructor.Password);
myCommand.Parameters.AddWithValue("@FName", myInstructor.FName);
if (String.IsNullOrEmpty(myInstructor.MI))
{
myCommand.Parameters.AddWithValue("@MI", DBNull.Value);
}
else
{
myCommand.Parameters.AddWithValue("@MI", myInstructor.MI);
}
myCommand.Parameters.AddWithValue("@LName", myInstructor.LName);
myCommand.Parameters.AddWithValue("@Street", myInstructor.Street);
myCommand.Parameters.AddWithValue("@City", myInstructor.City);
myCommand.Parameters.AddWithValue("@State", myInstructor.State);
myCommand.Parameters.AddWithValue("@Zipcode", myInstructor.Zipcode);
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;
}
/// <summary>
/// Creates an instance of Instructor from the data record in the database.
/// </summary>
/// <param name="myRecord">Single row of record.</param>
/// <returns>A Instructor</returns>
private static Instructor FillRecord(IDataRecord myRecord)
{
Instructor myInstructor = new Instructor();
myInstructor.IId = myRecord.GetString(myRecord.GetOrdinal("IID"));
myInstructor.Password = myRecord.GetString(myRecord.GetOrdinal("Password"));
myInstructor.FName = myRecord.GetString(myRecord.GetOrdinal("Fname"));
if (!myRecord.IsDBNull(myRecord.GetOrdinal("MI")))
{
myInstructor.MI = myRecord.GetString(myRecord.GetOrdinal("MI"));
}
myInstructor.LName = myRecord.GetString(myRecord.GetOrdinal("Lname"));
myInstructor.Street = myRecord.GetString(myRecord.GetOrdinal("Street"));
myInstructor.City = myRecord.GetString(myRecord.GetOrdinal("City"));
myInstructor.State = myRecord.GetString(myRecord.GetOrdinal("State"));
myInstructor.Zipcode = myRecord.GetString(myRecord.GetOrdinal("Zipcode"));
return myInstructor;
}
public static int Save(Instructor myInstructor)
{
return InstructorDA.Save(myInstructor);
}
