public void updateTimeSlots(TimeSlotsModel timeSlotsModel) { if (con.State.ToString() != "Open") { con.Open(); } string sqlTime = "UPDATE working_time SET Hours='" + timeSlotsModel.WorkingTimeHrs + "', Minutes='" + timeSlotsModel.WorkingTimeMin + "' WHERE id = 1"; SqlCommand comTime = new SqlCommand(sqlTime, con); string sqlStart = "UPDATE start_time SET Hours='" + timeSlotsModel.StartTimeHrs + "', Minutes='" + timeSlotsModel.StartTimeMin + "' WHERE id = 1"; SqlCommand comStart = new SqlCommand(sqlStart, con); string sqlType = "UPDATE time_sloat_type SET Type='" + timeSlotsModel.TimeSloatType + "' WHERE id = 1"; SqlCommand comType = new SqlCommand(sqlType, con); string sqlSlots = "DELETE FROM time_slots"; SqlCommand comSlots = new SqlCommand(sqlSlots, con); string ans = MessageBox.Show("Are sure to Update this record?", "Warning", MessageBoxButtons.YesNo, MessageBoxIcon.Warning).ToString(); if (ans == "Yes") { comTime.ExecuteNonQuery(); comStart.ExecuteNonQuery(); comType.ExecuteNonQuery(); comSlots.ExecuteNonQuery(); createTimeSlots(timeSlotsModel); MessageBox.Show("No of records Updated Information"); } con.Close(); }
public void insertTimeSlots(TimeSlotsModel timeSlotsModel) { createTimeSlots(timeSlotsModel); if (con.State.ToString() != "Open") { con.Open(); } string queryTime = "INSERT INTO working_time(Hours,Minutes,id) VALUES ('" + timeSlotsModel.WorkingTimeHrs + "','" + timeSlotsModel.WorkingTimeMin + "', 1)"; SqlCommand comTime = new SqlCommand(queryTime, con); int retTime = NewMethod(comTime); string queryStart = "INSERT INTO start_time(Hours,Minutes,id) VALUES ('" + timeSlotsModel.StartTimeHrs + "','" + timeSlotsModel.StartTimeMin + "', 1)"; SqlCommand comStart = new SqlCommand(queryStart, con); int retStart = NewMethod(comStart); string queryType = "INSERT INTO time_sloat_type(Type,id) VALUES ('" + timeSlotsModel.TimeSloatType + "', 1)"; SqlCommand comType = new SqlCommand(queryType, con); int retType = NewMethod(comType); MessageBox.Show("successfully Added"); con.Close(); }
public void createTimeSlots(TimeSlotsModel timeSlotsModel) { float startTime; if (timeSlotsModel.StartTimeMin == 0) { startTime = timeSlotsModel.StartTimeHrs; float timeSlot = (float)Convert.ToDouble(startTime); int count = 0; if (timeSlotsModel.TimeSloatType == "One hour time slots") { while (count < timeSlotsModel.WorkingTimeHrs) { string queryTimeSloat = "INSERT INTO time_slots(Time_Slots) VALUES ('" + timeSlot.ToString() + "')"; SqlCommand comTime = new SqlCommand(queryTimeSloat, con); int retTime = NewMethod(comTime); timeSlot = timeSlot + float.Parse("1.00"); count++; } } else if (timeSlotsModel.TimeSloatType == "Thirty minutes time slots") { while (count < timeSlotsModel.WorkingTimeHrs) { string queryTimeSloat = "INSERT INTO time_slots(Time_Slots) VALUES ('" + timeSlot.ToString() + "')"; SqlCommand comTime = new SqlCommand(queryTimeSloat, con); int retTime = NewMethod(comTime); float timeSlot30 = timeSlot + float.Parse("0.30"); string queryTimeSloat30 = "INSERT INTO time_slots(Time_Slots) VALUES ('" + timeSlot30.ToString() + "')"; SqlCommand comTime30 = new SqlCommand(queryTimeSloat30, con); int retTime30 = NewMethod(comTime30); timeSlot = timeSlot + float.Parse("1.00"); count++; } if (timeSlotsModel.WorkingTimeMin == 30) { string queryTimeSloat30 = "INSERT INTO time_slots(Time_Slots) VALUES ('" + timeSlot.ToString() + "')"; SqlCommand comTime30 = new SqlCommand(queryTimeSloat30, con); int retTime30 = NewMethod(comTime30); } } } else if (timeSlotsModel.StartTimeMin == 30) { startTime = (float)timeSlotsModel.StartTimeHrs + float.Parse("0.30"); float timeSlot = (float)Convert.ToDouble(startTime); int count = 0; if (timeSlotsModel.TimeSloatType == "One hour time slots") { while (count < timeSlotsModel.WorkingTimeHrs) { string queryTimeSloat = "INSERT INTO time_slots(Time_Slots) VALUES ('" + timeSlot.ToString() + "')"; SqlCommand comTime = new SqlCommand(queryTimeSloat, con); int retTime = NewMethod(comTime); timeSlot = timeSlot + float.Parse("1.00"); count++; } } else if (timeSlotsModel.TimeSloatType == "Thirty minutes time slots") { while (count < timeSlotsModel.WorkingTimeHrs) { string queryTimeSloat = "INSERT INTO time_slots(Time_Slots) VALUES ('" + timeSlot.ToString() + "')"; SqlCommand comTime = new SqlCommand(queryTimeSloat, con); int retTime = NewMethod(comTime); float timeSlot30 = (timeSlot - float.Parse("0.30")) + float.Parse("1.00"); string queryTimeSloat30 = "INSERT INTO time_slots(Time_Slots) VALUES ('" + timeSlot30.ToString() + "')"; SqlCommand comTime30 = new SqlCommand(queryTimeSloat30, con); int retTime30 = NewMethod(comTime30); timeSlot = timeSlot30 + float.Parse("0.30"); count++; } if (timeSlotsModel.WorkingTimeMin == 30) { string queryTimeSloat30 = "INSERT INTO time_slots(Time_Slots) VALUES ('" + timeSlot.ToString() + "')"; SqlCommand comTime30 = new SqlCommand(queryTimeSloat30, con); int retTime30 = NewMethod(comTime30); } } } }