public static int Save(FitnessClass fitnessClassToSave)
{
int result = 0;
ExecuteTypeEnum queryId = ExecuteTypeEnum.InsertItem;
if (fitnessClassToSave.FitnessClassId > 0)
{
queryId = ExecuteTypeEnum.UpdateItem;
}
using (SqlConnection myConnection = new SqlConnection(AppConfiguration.ConnectionString))
{
using (SqlCommand myCommand = new SqlCommand("usp_ExecuteFitnessClass", myConnection))
{
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.AddWithValue("@QueryId", queryId);
myCommand.Parameters.AddWithValue("@FitnessClassId", fitnessClassToSave.FitnessClassId);
myCommand.Parameters.AddWithValue("@FitnessClassName", fitnessClassToSave.FitnessClassName);
myCommand.Parameters.Add(HelperDAL.GetReturnParameterInt("ReturnValue"));
myConnection.Open();
myCommand.ExecuteNonQuery();
result = (int)myCommand.Parameters["@ReturnValue"].Value;
}
myConnection.Close();
}
return(result);
}
//public static Instructor GetItem(int instructorID)
//{
// Instructor tempItem = null;
// using (SqlConnection myConnection = new SqlConnection(AppConfiguration.ConnectionString))
// {
// using (SqlCommand myCommand = new SqlCommand("usp_GetInstructor", myConnection))
// {
// myCommand.CommandType = CommandType.StoredProcedure;
// myCommand.Parameters.AddWithValue("@QueryID", SelectTypeEnum.GetItem);
// myCommand.Parameters.AddWithValue("@InstructorId", instructorID);
// myConnection.Open();
// using (SqlDataReader myReader = myCommand.ExecuteReader())
// {
// if (myReader.Read())
// {
// tempItem = FillDataRecord(myReader);
// }
// myReader.Close();
// }
// }
// }
// return tempItem;
//}
#region INSERT and UPDATE
/// <summary>
/// Saves the Instructor to the Databese. Determines to INSERT or UPDATE based on
/// valid instructorId
/// </summary>
/// <param name="instructorToSave"></param>
/// <returns></returns>
public static int Save(Instructor instructorToSave)
{
int result = 0;
ExecuteTypeEnum queryId = ExecuteTypeEnum.InsertItem;
if (instructorToSave.InstructorId > 0)
{
queryId = ExecuteTypeEnum.UpdateItem;
}
using (SqlConnection myConnection = new SqlConnection(AppConfiguration.ConnectionString))
{
using (SqlCommand myCommand = new SqlCommand("usp_ExecuteInstructor", myConnection))
{
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.AddWithValue("@QueryId", queryId);
myCommand.Parameters.AddWithValue("@InstructorId", instructorToSave.InstructorId);
myCommand.Parameters.AddWithValue("@PersonId", instructorToSave.PersonId);
if (instructorToSave.HireDate != DateTime.MinValue)
{
myCommand.Parameters.AddWithValue("@HireDate", instructorToSave.HireDate.ToShortDateString());
}
if (instructorToSave.TermDate != DateTime.MinValue)
{
myCommand.Parameters.AddWithValue("@TermDate", instructorToSave.TermDate.ToShortDateString());
}
if (instructorToSave.Description != null)
{
myCommand.Parameters.AddWithValue("@Description", instructorToSave.Description);
}
if (instructorToSave.EntityTypeId != 0)
{
myCommand.Parameters.AddWithValue("@EntityTypeId", instructorToSave.EntityTypeId);
}
//Add return output parameter to command object
myCommand.Parameters.Add(HelperDAL.GetReturnParameterInt("ReturnValue"));
myConnection.Open();
myCommand.ExecuteNonQuery();
result = (int)myCommand.Parameters["@ReturnValue"].Value;
}
myConnection.Close();
}
return(result);
}
public static int Save(Gym gymToSave)
{
int result = 0;
ExecuteTypeEnum queryId = ExecuteTypeEnum.InsertItem;
if (gymToSave.GymId > 0)
{
queryId = ExecuteTypeEnum.UpdateItem;
}
using (SqlConnection myConnection = new SqlConnection(AppConfiguration.ConnectionString))
{
using (SqlCommand myCommand = new SqlCommand("usp_ExecuteGym", myConnection))
{
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.AddWithValue("@QueryId", queryId);
myCommand.Parameters.AddWithValue("@GymId", gymToSave.GymId);
if (gymToSave.GymName != null)
{
myCommand.Parameters.AddWithValue("@GymName", gymToSave.GymName);
}
if (gymToSave.Abbreviation != null)
{
myCommand.Parameters.AddWithValue("@GymAbbreviation", gymToSave.Abbreviation);
}
if (gymToSave.WebSite != null)
{
myCommand.Parameters.AddWithValue("@WebSite", gymToSave.WebSite);
}
if (gymToSave.Description != null)
{
myCommand.Parameters.AddWithValue("@Description", gymToSave.Description);
}
//if (gymToSave.CreateDate != DateTime.MinValue)
// myCommand.Parameters.AddWithValue("@CreateDate", gymToSave.CreateDate.ToShortDateString());
myCommand.Parameters.Add(HelperDAL.GetReturnParameterInt("ReturnValue"));
myConnection.Open();
myCommand.ExecuteNonQuery();
result = (int)myCommand.Parameters["@ReturnValue"].Value;
}
myConnection.Close();
}
return(result);
}
public static int Save(Location locationToSave)
{
int result = 0;
ExecuteTypeEnum queryId = ExecuteTypeEnum.InsertItem;
if (locationToSave.ID > 0)
{
queryId = ExecuteTypeEnum.UpdateItem;
}
using (SqlConnection myConnection = new SqlConnection(AppConfiguration.ConnectionString))
{
using (SqlCommand myCommand = new SqlCommand("usp_ExecuteLocation", myConnection))
{
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.AddWithValue("@QueryId", queryId);
myCommand.Parameters.AddWithValue("@LocationId", locationToSave.ID);
if (locationToSave.Name != null)
{
myCommand.Parameters.AddWithValue("@LocationName", locationToSave.Name);
}
if (locationToSave.Address01 != null)
{
myCommand.Parameters.AddWithValue("@Abbreviation", locationToSave.Address01);
}
if (locationToSave.Address02 != null)
{
myCommand.Parameters.AddWithValue("@Website", locationToSave.Address02);
}
if (locationToSave.City != null)
{
myCommand.Parameters.AddWithValue("@Description", locationToSave.City);
}
myCommand.Parameters.Add(HelperDAL.GetReturnParameterInt("ReturnValue"));
myConnection.Open();
myCommand.ExecuteNonQuery();
result = (int)myCommand.Parameters["@ReturnValue"].Value;
}
myConnection.Close();
}
return(result);
}
public static int Save(int entityId, EntityType entityTypeToSave)
{
int result = 0;
ExecuteTypeEnum queryId = ExecuteTypeEnum.InsertItem;
if (entityTypeToSave.EntityTypeId > 0)
{
queryId = ExecuteTypeEnum.UpdateItem;
}
using (SqlConnection myConnection = new SqlConnection(AppConfiguration.ConnectionString))
{
using (SqlCommand myCommand = new SqlCommand("usp_ExecuteEntityType", myConnection))
{
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.AddWithValue("@QueryId", queryId);
myCommand.Parameters.AddWithValue("@EntityId", entityId);
myCommand.Parameters.AddWithValue("@EntityTypeId", entityTypeToSave.EntityTypeId);
if (entityTypeToSave.EntityTypeName != null)
{
myCommand.Parameters.AddWithValue("@EntityTypeName", entityTypeToSave.EntityTypeName);
}
if (entityTypeToSave.DisplayName != null)
{
myCommand.Parameters.AddWithValue("@DisplayName", entityTypeToSave.DisplayName);
}
if (entityTypeToSave.Description != null)
{
myCommand.Parameters.AddWithValue("@Description", entityTypeToSave.Description);
}
myCommand.Parameters.Add(HelperDAL.GetReturnParameterInt("ReturnValue"));
myConnection.Open();
myCommand.ExecuteNonQuery();
result = (int)myCommand.Parameters["@ReturnValue"].Value;
}
myConnection.Close();
}
return(result);
}
public static int Save(int instructorId, EmailAddress emailToSave)
{
int result = 0;
ExecuteTypeEnum queryId = ExecuteTypeEnum.InsertItem;
if (emailToSave.EmailId > 0)
{
queryId = ExecuteTypeEnum.UpdateItem;
}
using (SqlConnection myConnection = new SqlConnection(AppConfiguration.ConnectionString))
{
using (SqlCommand myCommand = new SqlCommand("usp_ExecuteEmail", myConnection))
{
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.AddWithValue("@QueryId", queryId);
myCommand.Parameters.AddWithValue("@EmailId", emailToSave.EmailId);
myCommand.Parameters.AddWithValue("@InstructorId", instructorId);
myCommand.Parameters.AddWithValue("@EntityTypeId", emailToSave.EmailType.EntityTypeId);
if (emailToSave.EmailValue != null)
{
myCommand.Parameters.AddWithValue("@EmailAddress", emailToSave.EmailValue);
}
myCommand.Parameters.Add(HelperDAL.GetReturnParameterInt("ReturnValue"));
myConnection.Open();
myCommand.ExecuteNonQuery();
result = (int)myCommand.Parameters["@ReturnValue"].Value;
}
myConnection.Close();
}
return(result);
}
/// <summary>
/// Saves the Person to the Databese. Determines to INSERT or UPDATE based on
/// valid personId
/// </summary>
/// <param name="personToSave"></param>
/// <returns></returns>
public static int Save(Person personToSave)
{
int result = 0;
ExecuteTypeEnum queryId = ExecuteTypeEnum.InsertItem;
if (personToSave.PersonId > 0)
{
queryId = ExecuteTypeEnum.UpdateItem;
}
using (SqlConnection myConnection = new SqlConnection(AppConfiguration.ConnectionString))
{
using (SqlCommand myCommand = new SqlCommand("usp_ExecutePerson", myConnection))
{
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.AddWithValue("@QueryId", queryId);
if (personToSave.PersonId > 0)
{
myCommand.Parameters.AddWithValue("@PersonId", personToSave.PersonId);
}
if (personToSave.FirstName != null)
{
myCommand.Parameters.AddWithValue("@FirstName", personToSave.FirstName);
}
if (personToSave.LastName != null)
{
myCommand.Parameters.AddWithValue("@LastName", personToSave.LastName);
}
if (personToSave.DisplayFirstName != null)
{
myCommand.Parameters.AddWithValue("@DisplayFirstName", personToSave.DisplayFirstName);
}
if (personToSave.Gender != null)
{
myCommand.Parameters.AddWithValue("@Gender", personToSave.Gender);
}
if (personToSave.BirthDate != DateTime.MinValue)
{
myCommand.Parameters.AddWithValue("@BirthDate", personToSave.BirthDate.ToShortDateString());
}
//Add return output parameter to command object
myCommand.Parameters.Add(HelperDAL.GetReturnParameterInt("ReturnValue"));
myConnection.Open();
myCommand.ExecuteNonQuery();
result = (int)myCommand.Parameters["@ReturnValue"].Value;
}
myConnection.Close();
}
return(result);
}
public static int Save(Person personToSave)
{
int result = 0;
ExecuteEnum queryId = ExecuteEnum.INSERT_ITEM;
//Notes: Check for valid PersonId - if exists then UPDATE, else INSERT
// 10 = INSERT_ITEM
// 20 = UPDATE_ITEM
if (personToSave.PersonId > 0)
{
queryId = ExecuteEnum.UPDATE_ITEM;
}
using (SqlConnection myConnection = new SqlConnection(AppConfiguration.ConnectionString))
{
using (SqlCommand myCommand = new SqlCommand("usp_ExecutePerson", myConnection))
{
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.AddWithValue("@QueryId", queryId);
if (personToSave.PersonId > 0)
{
myCommand.Parameters.AddWithValue("@PersonId", personToSave.PersonId);
}
if (personToSave.FirstName != null)
{
myCommand.Parameters.AddWithValue("@FirstName", personToSave.FirstName);
}
if (personToSave.LastName != null)
{
myCommand.Parameters.AddWithValue("@LastName", personToSave.LastName);
}
if (personToSave.DisplayFirstName != null)
{
myCommand.Parameters.AddWithValue("@DisplayFirstName", personToSave.DisplayFirstName);
}
if (personToSave.Gender != null)
{
myCommand.Parameters.AddWithValue("@Gender", personToSave.Gender);
}
if (personToSave.BirthDate != DateTime.MinValue)
{
myCommand.Parameters.AddWithValue("@BirthDate", personToSave.BirthDate.ToShortDateString());
}
//notes: add return output parameter to command object
myCommand.Parameters.Add(HelperDAL.GetReturnParameterInt("ReturnValue"));
myConnection.Open();
myCommand.ExecuteNonQuery();
//notes: get return value from stored procedure andreturn Id
result = (int)myCommand.Parameters["@ReturnValue"].Value;
}
myConnection.Close();
}
return(result);
}
