public void updateTimeSlotsWE(TimeSlotsModelWE timeSlotsModelWE) { if (con.State.ToString() != "Open") { con.Open(); } string sqlTime = "UPDATE working_timeWE SET Hours='" + timeSlotsModelWE.WorkingTimeHrsWE + "', Minutes='" + timeSlotsModelWE.WorkingTimeMinWE + "' WHERE id = 1"; SqlCommand comTime = new SqlCommand(sqlTime, con); string sqlStart = "UPDATE start_timeWE SET Hours='" + timeSlotsModelWE.StartTimeHrsWE + "', Minutes='" + timeSlotsModelWE.StartTimeMinWE + "' WHERE id = 1"; SqlCommand comStart = new SqlCommand(sqlStart, con); string sqlType = "UPDATE time_sloat_typeWE SET Type='" + timeSlotsModelWE.TimeSloatTypeWE + "' WHERE id = 1"; SqlCommand comType = new SqlCommand(sqlType, con); string sqlSlots = "DELETE FROM time_slotsWE"; 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(); createTimeSlotsWE(timeSlotsModelWE); MessageBox.Show("No of records Updated Information"); } con.Close(); }
public void insertTimeSlotsWE(TimeSlotsModelWE timeSlotsModelWE) { createTimeSlotsWE(timeSlotsModelWE); if (con.State.ToString() != "Open") { con.Open(); } string queryTime = "INSERT INTO working_timeWE(Hours,Minutes,id) VALUES ('" + timeSlotsModelWE.WorkingTimeHrsWE + "','" + timeSlotsModelWE.WorkingTimeMinWE + "', 1)"; SqlCommand comTime = new SqlCommand(queryTime, con); int retTime = NewMethod(comTime); string queryStart = "INSERT INTO start_timeWE(Hours,Minutes,id) VALUES ('" + timeSlotsModelWE.StartTimeHrsWE + "','" + timeSlotsModelWE.StartTimeMinWE + "', 1)"; SqlCommand comStart = new SqlCommand(queryStart, con); int retStart = NewMethod(comStart); string queryType = "INSERT INTO time_sloat_typeWE(Type,id) VALUES ('" + timeSlotsModelWE.TimeSloatTypeWE + "', 1)"; SqlCommand comType = new SqlCommand(queryType, con); int retType = NewMethod(comType); MessageBox.Show("successfully Added"); con.Close(); }
public void createTimeSlotsWE(TimeSlotsModelWE timeSlotsModelWE) { float startTimeWE; if (timeSlotsModelWE.StartTimeMinWE == 0) { startTimeWE = timeSlotsModelWE.StartTimeHrsWE; float timeSlotWE = (float)Convert.ToDouble(startTimeWE); int count = 0; if (timeSlotsModelWE.TimeSloatTypeWE == "One hour time slots") { while (count < timeSlotsModelWE.WorkingTimeHrsWE) { string queryTimeSloat = "INSERT INTO time_slotsWE(Time_Slots) VALUES ('" + timeSlotWE.ToString() + "')"; SqlCommand comTime = new SqlCommand(queryTimeSloat, con); int retTime = NewMethod(comTime); timeSlotWE = timeSlotWE + float.Parse("1.00"); count++; } } else if (timeSlotsModelWE.TimeSloatTypeWE == "Thirty minutes time slots") { while (count < timeSlotsModelWE.WorkingTimeHrsWE) { string queryTimeSloat = "INSERT INTO time_slotsWE(Time_Slots) VALUES ('" + timeSlotWE.ToString() + "')"; SqlCommand comTime = new SqlCommand(queryTimeSloat, con); int retTime = NewMethod(comTime); float timeSlot30WE = timeSlotWE + float.Parse("0.30"); string queryTimeSloat30 = "INSERT INTO time_slotsWE(Time_Slots) VALUES ('" + timeSlot30WE.ToString() + "')"; SqlCommand comTime30 = new SqlCommand(queryTimeSloat30, con); int retTime30 = NewMethod(comTime30); timeSlotWE = timeSlotWE + float.Parse("1.00"); count++; } if (timeSlotsModelWE.WorkingTimeMinWE == 30) { string queryTimeSloat30 = "INSERT INTO time_slotsWE(Time_Slots) VALUES ('" + timeSlotWE.ToString() + "')"; SqlCommand comTime30 = new SqlCommand(queryTimeSloat30, con); int retTime30 = NewMethod(comTime30); } } } else if (timeSlotsModelWE.StartTimeMinWE == 30) { startTimeWE = (float)timeSlotsModelWE.StartTimeHrsWE + float.Parse("0.30"); float timeSlotWE = (float)Convert.ToDouble(startTimeWE); int count = 0; if (timeSlotsModelWE.TimeSloatTypeWE == "One hour time slots") { while (count < timeSlotsModelWE.WorkingTimeHrsWE) { string queryTimeSloat = "INSERT INTO time_slotsWE(Time_Slots) VALUES ('" + timeSlotWE.ToString() + "')"; SqlCommand comTime = new SqlCommand(queryTimeSloat, con); int retTime = NewMethod(comTime); timeSlotWE = timeSlotWE + float.Parse("1.00"); count++; } } else if (timeSlotsModelWE.TimeSloatTypeWE == "Thirty minutes time slots") { while (count < timeSlotsModelWE.WorkingTimeHrsWE) { string queryTimeSloat = "INSERT INTO time_slotsWE(Time_Slots) VALUES ('" + timeSlotWE.ToString() + "')"; SqlCommand comTime = new SqlCommand(queryTimeSloat, con); int retTime = NewMethod(comTime); float timeSlot30WE = (timeSlotWE - float.Parse("0.30")) + float.Parse("1.00"); string queryTimeSloat30 = "INSERT INTO time_slotsWE(Time_Slots) VALUES ('" + timeSlot30WE.ToString() + "')"; SqlCommand comTime30 = new SqlCommand(queryTimeSloat30, con); int retTime30 = NewMethod(comTime30); timeSlotWE = timeSlot30WE + float.Parse("0.30"); count++; } if (timeSlotsModelWE.WorkingTimeMinWE == 30) { string queryTimeSloat30 = "INSERT INTO time_slotsWE(Time_Slots) VALUES ('" + timeSlotWE.ToString() + "')"; SqlCommand comTime30 = new SqlCommand(queryTimeSloat30, con); int retTime30 = NewMethod(comTime30); } } } }