private static bool ValidateDrawingDate(DrawingDateBO drawingDateToValidate, ref BrokenRuleCollection brokenRules)
{
//Set default return value to true
bool returnValue = true;
//Validate email address
if (drawingDateToValidate != null)
{
if (drawingDateToValidate.DrawingDate == DateTime.MinValue)
{
//Email was not in a valid format
brokenRules.Add("Drawing Date", "is an invalid email format.");
returnValue = false;
}
if (drawingDateToValidate.DrawingDate > DateTime.Now)
{
//Email cannot be a date beyond the current date
brokenRules.Add("Drawing Date " + drawingDateToValidate.DrawingDate.ToString(), "cannot be a future date.");
}
if(drawingDateToValidate.DrawingDate == DateTime.MinValue)
{
//Emailis required
brokenRules.Add("Drawing Date", "Drawing date is required");
returnValue = false;
}
}
else
{
//Generic error - class not instantiated
brokenRules.Add("Drawing Date", "Drawing Date was not instantiated.");
returnValue = false;
}
return returnValue;
}
public static int Save(int drawingDateId, int gameId, DrawingDateBO drawingDateToSave)
{
//Instantiates a brokenRules collection and check for any validation errors
BrokenRuleCollection saveBrokenRules = new BrokenRuleCollection();
if (gameId <= 0)
{
saveBrokenRules.Add("Drawing date", "Invalid game id");
}
ValidateDrawingDate(drawingDateToSave, ref saveBrokenRules);
if (saveBrokenRules.Count() > 0)
{
throw new BLLException("There was an error saving email.", saveBrokenRules);
}
else
{
//Call DAL to save
return DrawingDateDAL.Save(drawingDateId, gameId, drawingDateToSave);
}
}
/// <summary>
/// Initializes a new instance of the DrawingDate class and fills it with the data from the IDataRecord
/// </summary>
/// <param name="myDataRecord"></param>
/// <returns></returns>
private static DrawingDateBO FillDataRecord(IDataRecord myDataRecord)
{
DrawingDateBO myDrawingDateObject = new DrawingDateBO();
myDrawingDateObject.WinningNumbers = new WinningNumbers();
myDrawingDateObject.DrawingDateId = myDataRecord.GetInt32(myDataRecord.GetOrdinal("DrawingDateId"));
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("DrawingDate")))
{
myDrawingDateObject.DrawingDate = myDataRecord.GetDateTime(myDataRecord.GetOrdinal("DrawingDate"));
}
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("Jackpot")))
{
myDrawingDateObject.Jackpot = myDataRecord.GetInt32(myDataRecord.GetOrdinal("Jackpot"));
}
return myDrawingDateObject;
}
/// <summary>
/// Initializes a new instance of the DrawingDate class and fills it with the data from the IDataRecord
/// </summary>
/// <param name="myDataRecord"></param>
/// <returns></returns>
private static DrawingDateBO FillDataRecordWinningNums(IDataRecord myDataRecord)
{
DrawingDateBO myDrawingDateObject = new DrawingDateBO();
myDrawingDateObject.WinningNumbers = new WinningNumbers();
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("WinningNumbersId")))
{
myDrawingDateObject.WinningNumbers.WinningNumbersId = myDataRecord.GetInt32(myDataRecord.GetOrdinal("WinningNumbersId"));
}
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("NumberValue")))
{
myDrawingDateObject.WinningNumbers.NumberValue = myDataRecord.GetInt32(myDataRecord.GetOrdinal("NumberValue"));
}
return myDrawingDateObject;
}
public static int Save(int drawingDateId, int gameId, DrawingDateBO drawingDateToSave)
{
ExecuteTypeEnum queryId = ExecuteTypeEnum.InsertItem;
int result = 0;
if (drawingDateId > 0)
{
queryId = ExecuteTypeEnum.UpdateItem;
}
using (SqlConnection myConnection = new SqlConnection(AppConfiguration.ConnectionString))
{
using (SqlCommand myCommand = new SqlCommand("usp_ExecuteDrawingDate", myConnection))
{
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.AddWithValue("@QueryId", queryId);
myCommand.Parameters.AddWithValue("@DrawingDateId", drawingDateId);
if (drawingDateToSave.DrawingDate != null)
{
myCommand.Parameters.AddWithValue("@DrawingDate", drawingDateToSave.DrawingDate);
}
if (drawingDateToSave.Jackpot != null)
{
myCommand.Parameters.AddWithValue("@Jackpot", drawingDateToSave.Jackpot);
}
if (gameId != null)
{
myCommand.Parameters.AddWithValue("@GameId", gameId);
}
//add return output parameter to command object
myCommand.Parameters.Add(HelperDAL.GetReturnParameterInt("ReturnValue"));
myConnection.Open();
myCommand.ExecuteNonQuery();
//Get return value from stored procedure and return Id
result = (int)myCommand.Parameters["@ReturnValue"].Value;
}
myConnection.Close();
}
return result;
}
