private void createTable()
{
workingDaysHours = workingDaysHoursService.getWorkingDaysHours();
timeSlotsList.Add("08.30-09.30");
timeSlotsList.Add("09.30-10.30");
timeSlotsList.Add("10.30-11.30");
timeSlotsList.Add("11.30-12.30");
timeSlotsList.Add("12.30-13.00");
timeSlotsList.Add("13.00-14.00");
timeSlotsList.Add("14.00-15.00");
timeSlotsList.Add("15.00-16.00");
timeSlotsList.Add("16.00-17.00");
}
public bool addWorkingDaysHours(WorkingDaysHours workingDaysHours)
{
Boolean result = false;
string connectionString = @"Server=us-cdbr-east-03.cleardb.com;Database=heroku_e9719c4a59b4c8f;Uid=b9ff0a805dbcc5;Pwd=25d16e4a;";
MySqlConnection conn = new MySqlConnection(connectionString);
try
{
string query = "INSERT INTO workingdayshours (noOfWorkingDays, monday, tuesday, wednesday, thursday, friday, saturday, sunday, noOfWorkingHours, noOfWorkingMinutes) VALUES (@noOfWorkingDays, @monday, @tuesday, @wednesday, @thursday, @friday, @saturday, @sunday, @noOfWorkingHours, @noOfWorkingMinutes)";
conn.Open();
MySqlCommand cmd = new MySqlCommand(query, conn);
cmd.Parameters.AddWithValue("@noOfWorkingDays", workingDaysHours.NoOfWorkingDays);
cmd.Parameters.AddWithValue("@monday", workingDaysHours.Monday);
cmd.Parameters.AddWithValue("@tuesday", workingDaysHours.Tuesday);
cmd.Parameters.AddWithValue("@wednesday", workingDaysHours.Wednesday);
cmd.Parameters.AddWithValue("@thursday", workingDaysHours.Thursday);
cmd.Parameters.AddWithValue("@friday", workingDaysHours.Friday);
cmd.Parameters.AddWithValue("@saturday", workingDaysHours.Saturday);
cmd.Parameters.AddWithValue("@sunday", workingDaysHours.Sunday);
cmd.Parameters.AddWithValue("@noOfWorkingHours", workingDaysHours.NoOfHours);
cmd.Parameters.AddWithValue("@noOfWorkingMinutes", workingDaysHours.NoOfMinutes);
cmd.Prepare();
if (cmd.ExecuteNonQuery() == 1)
{
result = true;
}
else
{
result = false;
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
finally
{
conn.Close();
}
return(result);
}
public bool addWorkingDaysHours(WorkingDaysHours workingDaysHours)
{
Boolean result = false;
SQLiteConnection conn = new SQLiteConnection("Data Source=database.db;Version=3;");
try
{
string query = "INSERT INTO workingdayshours (noOfWorkingDays, monday, tuesday, wednesday, thursday, friday, saturday, sunday, noOfWorkingHours, noOfWorkingMinutes) VALUES (@noOfWorkingDays, @monday, @tuesday, @wednesday, @thursday, @friday, @saturday, @sunday, @noOfWorkingHours, @noOfWorkingMinutes)";
conn.Open();
SQLiteCommand cmd = new SQLiteCommand(query, conn);
cmd.Parameters.AddWithValue("@noOfWorkingDays", workingDaysHours.NoOfWorkingDays);
cmd.Parameters.AddWithValue("@monday", workingDaysHours.Monday);
cmd.Parameters.AddWithValue("@tuesday", workingDaysHours.Tuesday);
cmd.Parameters.AddWithValue("@wednesday", workingDaysHours.Wednesday);
cmd.Parameters.AddWithValue("@thursday", workingDaysHours.Thursday);
cmd.Parameters.AddWithValue("@friday", workingDaysHours.Friday);
cmd.Parameters.AddWithValue("@saturday", workingDaysHours.Saturday);
cmd.Parameters.AddWithValue("@sunday", workingDaysHours.Sunday);
cmd.Parameters.AddWithValue("@noOfWorkingHours", workingDaysHours.NoOfHours);
cmd.Parameters.AddWithValue("@noOfWorkingMinutes", workingDaysHours.NoOfMinutes);
cmd.Prepare();
if (cmd.ExecuteNonQuery() == 1)
{
result = true;
}
else
{
result = false;
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
finally
{
conn.Close();
}
return(result);
}
private void populateData()
{
workingDaysHours = workingDaysHoursService.getWorkingDaysHours();
btnDaysCount.Text = workingDaysHours.NoOfWorkingDays.ToString();
List <String> workingArr = new List <String>();
if (workingDaysHours.Monday == 1)
{
workingArr.Add("Monday");
}
if (workingDaysHours.Tuesday == 1)
{
workingArr.Add("Tuesday");
}
if (workingDaysHours.Wednesday == 1)
{
workingArr.Add("Wednesday");
}
if (workingDaysHours.Thursday == 1)
{
workingArr.Add("Thursday");
}
if (workingDaysHours.Friday == 1)
{
workingArr.Add("Friday");
}
if (workingDaysHours.Saturday == 1)
{
workingArr.Add("Saturday");
}
if (workingDaysHours.Sunday == 1)
{
workingArr.Add("Sunday");
}
btnWorkingDays.Text = String.Empty;
foreach (String day in workingArr)
{
btnWorkingDays.Text = btnWorkingDays.Text + " | " + day;
}
btnTime.Text = workingDaysHours.NoOfHours + ":" + workingDaysHours.NoOfMinutes;
}
public WorkingDaysHours getWorkingDaysHours()
{
string connectionString = @"Server=us-cdbr-east-03.cleardb.com;Database=heroku_e9719c4a59b4c8f;Uid=b9ff0a805dbcc5;Pwd=25d16e4a;";
MySqlConnection conn = new MySqlConnection(connectionString);
WorkingDaysHours workingDaysHours = new WorkingDaysHours();
try
{
string query = "SELECT * FROM workingdayshours";
conn.Open();
MySqlCommand cmd = new MySqlCommand(query, conn);
MySqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
workingDaysHours.Id = rdr.GetInt32(0);
workingDaysHours.NoOfWorkingDays = rdr.GetInt32(1);
workingDaysHours.Monday = rdr.GetInt32(2);
workingDaysHours.Tuesday = rdr.GetInt32(3);
workingDaysHours.Wednesday = rdr.GetInt32(4);
workingDaysHours.Thursday = rdr.GetInt32(5);
workingDaysHours.Friday = rdr.GetInt32(6);
workingDaysHours.Saturday = rdr.GetInt32(7);
workingDaysHours.Sunday = rdr.GetInt32(8);
workingDaysHours.NoOfHours = rdr.GetInt32(9);
workingDaysHours.NoOfMinutes = rdr.GetInt32(10);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
finally
{
conn.Close();
}
return(workingDaysHours);
}
public Boolean updateWorkingDaysHours(WorkingDaysHours workingDaysHours)
{
Boolean result = false;
string connectionString = @"Server=us-cdbr-east-03.cleardb.com;Database=heroku_e9719c4a59b4c8f;Uid=b9ff0a805dbcc5;Pwd=25d16e4a;";
MySqlConnection conn = new MySqlConnection(connectionString);
try
{
string query = "UPDATE workingdayshours SET noOfWorkingDays = @noworkingdays WHERE id = 2";
conn.Open();
MySqlCommand cmd = new MySqlCommand(query, conn);
cmd.Parameters.AddWithValue("@noworkingdays", workingDaysHours);
cmd.Prepare();
if (cmd.ExecuteNonQuery() == 1)
{
result = true;
}
else
{
result = false;
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
finally
{
conn.Close();
}
return(result);
}
private void getData()
{
workingDaysHoursService = new WorkingDaysHoursService();
workingDaysHours = workingDaysHoursService.getWorkingDaysHours();
// set data to fields
numericNoOfDays.Value = workingDaysHours.NoOfWorkingDays;
numericTPerDayHours.Value = workingDaysHours.NoOfHours;
numericTPerDayMinutes.Value = workingDaysHours.NoOfMinutes;
if (workingDaysHours.Monday == 1)
{
checkBoxMonday.Checked = true;
}
if (workingDaysHours.Tuesday == 1)
{
checkBoxTuesday.Checked = true;
}
if (workingDaysHours.Wednesday == 1)
{
checkBoxWednesday.Checked = true;
}
if (workingDaysHours.Thursday == 1)
{
checkBoxThursday.Checked = true;
}
if (workingDaysHours.Friday == 1)
{
checkBoxFriday.Checked = true;
}
if (workingDaysHours.Saturday == 1)
{
checkBoxSaturday.Checked = true;
}
if (workingDaysHours.Sunday == 1)
{
checkBoxSunday.Checked = true;
}
}
public WorkingDaysHours getWorkingDaysHours()
{
SQLiteConnection conn = new SQLiteConnection("Data Source=database.db;Version=3;");
WorkingDaysHours workingDaysHours = new WorkingDaysHours();
try
{
string query = "SELECT * FROM workingdayshours";
conn.Open();
SQLiteCommand cmd = new SQLiteCommand(query, conn);
SQLiteDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
workingDaysHours.Id = rdr.GetInt32(0);
workingDaysHours.NoOfWorkingDays = rdr.GetInt32(1);
workingDaysHours.Monday = rdr.GetInt32(2);
workingDaysHours.Tuesday = rdr.GetInt32(3);
workingDaysHours.Wednesday = rdr.GetInt32(4);
workingDaysHours.Thursday = rdr.GetInt32(5);
workingDaysHours.Friday = rdr.GetInt32(6);
workingDaysHours.Saturday = rdr.GetInt32(7);
workingDaysHours.Sunday = rdr.GetInt32(8);
workingDaysHours.NoOfHours = rdr.GetInt32(9);
workingDaysHours.NoOfMinutes = rdr.GetInt32(10);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
finally
{
conn.Close();
}
return(workingDaysHours);
}
public Boolean updateWorkingDaysHours(WorkingDaysHours workingDaysHours)
{
Boolean result = false;
SQLiteConnection conn = new SQLiteConnection("Data Source=database.db;Version=3;");
try
{
string query = "UPDATE workingdayshours SET noOfWorkingDays = @noworkingdays WHERE id = 2";
conn.Open();
SQLiteCommand cmd = new SQLiteCommand(query, conn);
cmd.Parameters.AddWithValue("@noworkingdays", workingDaysHours);
cmd.Prepare();
if (cmd.ExecuteNonQuery() == 1)
{
result = true;
}
else
{
result = false;
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
finally
{
conn.Close();
}
return(result);
}
private void btnUpdate_Click(object sender, EventArgs e)
{
#region adding validation
if (numericNoOfDays.Value < 1 ^ numericNoOfDays.Value >= 7)
{
numericNoOfDays.Focus();
errorAddWorkingDays.SetError(numericNoOfDays, "Please Enter Valid No Of Working Days");
}
else if (checkBoxMonday.Checked == false & checkBoxTuesday.Checked == false & checkBoxWednesday.Checked == false & checkBoxThursday.Checked == false & checkBoxFriday.Checked == false & checkBoxSaturday.Checked == false & checkBoxSunday.Checked == false)
{
ErrorMessage em = new ErrorMessage("Please Select One or More Working Days");
em.Show();
}
else if (numericTPerDayHours.Value < 0 ^ numericTPerDayHours.Value > 24)
{
numericTPerDayHours.Focus();
errorAddWorkingDays.SetError(numericTPerDayHours, "Please Enter Valid No Of Working Hours");
}
else if (numericTPerDayMinutes.Value < 0 ^ numericTPerDayMinutes.Value >= 60)
{
numericTPerDayMinutes.Focus();
errorAddWorkingDays.SetError(numericTPerDayMinutes, "Please Enter Valid No Of Working Minutes");
}
#endregion
else
{
workingDaysHoursService = new WorkingDaysHoursService();
WorkingDaysHours workingDaysHoursUpdate = new WorkingDaysHours();
#region Set Data to Object
// Set Data to model
workingDaysHoursUpdate.NoOfWorkingDays = int.Parse(numericNoOfDays.Value.ToString());
workingDaysHoursUpdate.NoOfHours = int.Parse(numericTPerDayHours.Value.ToString());
workingDaysHoursUpdate.NoOfMinutes = int.Parse(numericTPerDayMinutes.Value.ToString());
// Check Days Monday
if (checkBoxMonday.Checked == true)
{
workingDaysHoursUpdate.Monday = 1;
}
else
{
workingDaysHoursUpdate.Monday = 0;
}
// Check Days Tuesday
if (checkBoxTuesday.Checked == true)
{
workingDaysHoursUpdate.Tuesday = 1;
}
else
{
workingDaysHoursUpdate.Tuesday = 0;
}
// Check Days Wednesday
if (checkBoxWednesday.Checked == true)
{
workingDaysHoursUpdate.Wednesday = 1;
}
else
{
workingDaysHoursUpdate.Wednesday = 0;
}
// Check Days Thursday
if (checkBoxThursday.Checked == true)
{
workingDaysHoursUpdate.Thursday = 1;
}
else
{
workingDaysHoursUpdate.Thursday = 0;
}
// Check Days Friday
if (checkBoxFriday.Checked == true)
{
workingDaysHoursUpdate.Friday = 1;
}
else
{
workingDaysHoursUpdate.Friday = 0;
}
// Check Days Saturday
if (checkBoxSaturday.Checked == true)
{
workingDaysHoursUpdate.Saturday = 1;
}
else
{
workingDaysHoursUpdate.Saturday = 0;
}
// Check Days Sunday
if (checkBoxSunday.Checked == true)
{
workingDaysHoursUpdate.Sunday = 1;
}
else
{
workingDaysHoursUpdate.Sunday = 0;
}
#endregion
if (workingDaysHoursService.deleteWorkingDaysHours())
{
if (workingDaysHoursService.addWorkingDaysHours(workingDaysHoursUpdate))
{
SuccessMessage sm = new SuccessMessage("Working Days / Hours Updated Succesfully!");
sm.Show();
}
}
else
{
ErrorMessage em = new ErrorMessage("Ooops...Something went wrong");
em.Show();
}
}
}
