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);
}
}
}
}
