public IHttpActionResult GetWorkingDays(WorkingDaysModel model)
{
return(Content(HttpStatusCode.OK,
WorkingDays.Query(new GetWorkingDays {
StartDate = model.StartDate, EndDate = model.EndDate
})));
}
public void insertNumberOfWorkingDays(WorkingDaysModel numberOfWorkingDaysModel)
{
if (con.State.ToString() != "Open")
{
con.Open();
}
string query = "INSERT INTO NumOfWorkingDays(weekday,weekend,id) VALUES ('" + numberOfWorkingDaysModel.WeekdayDays + "','" + numberOfWorkingDaysModel.WeekendDays + "', 1)";
SqlCommand com = new SqlCommand(query, con);
int ret = NewMethod(com);
string queryDays = "INSERT INTO Working_days(monday,tuesday,wednesday,thursday,friday,saturday,sunday,id) VALUES ('" + numberOfWorkingDaysModel.Monday + "','" + numberOfWorkingDaysModel.Tuesday + "','" + numberOfWorkingDaysModel.Wednesday + "','" + numberOfWorkingDaysModel.Thursday + "','" + numberOfWorkingDaysModel.Friday + "','" + numberOfWorkingDaysModel.Saturday + "','" + numberOfWorkingDaysModel.Sunday + "', 1)";
SqlCommand comDay = new SqlCommand(queryDays, con);
int retDay = NewMethod(comDay);
MessageBox.Show("successfully Added");
con.Close();
}
public void updateNumberOfWorkingDays(WorkingDaysModel numberOfWorkingDaysModel)
{
if (con.State.ToString() != "Open")
{
con.Open();
}
string sqlNum = "UPDATE NumOfWorkingDays SET weekday='" + numberOfWorkingDaysModel.WeekdayDays + "', weekend='" + numberOfWorkingDaysModel.WeekendDays + "' WHERE id = 1";
SqlCommand comNum = new SqlCommand(sqlNum, con);
string sqlDay = "UPDATE Working_days SET monday='" + numberOfWorkingDaysModel.Monday + "', tuesday='" + numberOfWorkingDaysModel.Tuesday + "', wednesday='" + numberOfWorkingDaysModel.Wednesday + "', thursday='" + numberOfWorkingDaysModel.Thursday + "', friday='" + numberOfWorkingDaysModel.Friday + "', saturday='" + numberOfWorkingDaysModel.Saturday + "', sunday='" + numberOfWorkingDaysModel.Sunday + "' WHERE id = 1";
SqlCommand comDay = new SqlCommand(sqlDay, con);
string ans = MessageBox.Show("Are sure to Update this record?", "Warning", MessageBoxButtons.YesNo, MessageBoxIcon.Warning).ToString();
if (ans == "Yes")
{
int retNum = comNum.ExecuteNonQuery();
int retDay = comDay.ExecuteNonQuery();
MessageBox.Show("No of records Updated Information");
}
con.Close();
}
