public void DeleteSkippedDates(SkippedDatesModel skm)
{
using (IDbConnection connection = new MySqlConnection(GlobalConfig.CnnString(db)))
{
var p = new DynamicParameters();
p.Add("@InSeasonDivisionsID", skm.SeasonDivisionsID);
p.Add("@InDateToRemove", skm.DateToSkip);
connection.Execute("spDeleteSkippedDates", p, commandType: CommandType.StoredProcedure);
}
}
/// <summary>
/// Create SkippedDates Model and Update DB et.al
/// </summary>
/// <param name="model"></param>
private void createSkippedDates(SeasonDivisionsModel model)
{
List <SkippedDatesModel> skModels = new List <SkippedDatesModel>();
foreach (DateTime date in skippedDates)
{
SkippedDatesModel skDates = new SkippedDatesModel(model.SeasonDivisionsID, date);
//skDates.SeasonDivisionsID = model.SeasonDivisionsID;
//skDates.DateToSkip = date;
GlobalConfig.Connection.CreateSkippedDates(skDates);
skModels.Add(skDates);
}
sdm.skippedDates = skModels;
skippedDates = new List <DateTime>();
}
private void addDates(DivisionModel model)
{
// For each newly added date to skip
foreach (DateTime date in datesToAdd)
{
// add date to DivisionModel list of skipped dates
model.DivisionSkippedDates.Add(date);
// create a new skipped dates model with seasonDivisionsID and the date
SkippedDatesModel skm = new SkippedDatesModel(sdm.SeasonDivisionsID, date);
// update the DB with new date(s)
GlobalConfig.Connection.CreateSkippedDates(skm);
}
// reset the dates to add list
datesToAdd = new List <DateTime>();
}
/// <summary>
/// Saves a new SkippedDate to the MySQL DB
/// </summary>
/// <param name="model"></param>
/// <returns>The SkippedDate information, including the unique identifier</returns>
public SkippedDatesModel CreateSkippedDates(SkippedDatesModel model)
{
using (IDbConnection connection = new MySqlConnection(GlobalConfig.CnnString(db)))
{
var p = new DynamicParameters();
p.Add("@SkippedDatesID", 0, dbType: DbType.Int32, direction: ParameterDirection.Output);
p.Add("@SeasonDivisionsID", model.SeasonDivisionsID);
p.Add("@DateToSkip", model.DateToSkip);
connection.Execute("spSkippedDates", p, commandType: CommandType.StoredProcedure);
// grabs newly created ID from database and returns it as part of the current Person Model
// https://stackoverflow.com/questions/13151861/fetch-last-inserted-id-form-stored-procedure-in-mysql
var id = p.Get <int?>("SkippedDatesID");
model.SkippedDatesID = Convert.ToInt32(id);
return(model);
}
}
private void addDatesButton_Click(object sender, EventArgs e)
{
// create a new SeasonDivisionsModel
sdm.StartDate = StartDate.Value;
GlobalConfig.Connection.AddStartDate(sdm);
// store division in Db and return ID
//GlobalConfig.Connection.createSeasonDivisions(model);
foreach (DateTime date in skippedDates)
{
SkippedDatesModel skDates = new SkippedDatesModel();
skDates.SeasonDivisionsID = sdm.SeasonDivisionsID;
skDates.DateToSkip = date;
GlobalConfig.Connection.CreateSkippedDates(skDates);
}
sdm.skippedDates = GlobalConfig.Connection.GetSkippedDates(sdm);
skippedDates.Clear();
callingForm.DatesComplete(sdm);
this.Close();
}
public void DeleteSkippedDates(SkippedDatesModel model)
{
throw new NotImplementedException();
}
public SkippedDatesModel CreateSkippedDates(SkippedDatesModel model)
{
throw new NotImplementedException();
}
