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