bool checkJobBookingExist(JobBooking jobBooking) { string query = $"select * from JobBooking where Date = '{jobBooking.Date}' and UserID = '{jobBooking.UserID.ToString()}'"; SqlDataReader reader = executeQuery(query); return(reader.Read()); }
public IHttpActionResult SaveData([FromUri] Guid userID, JobBooking jobBooking) { jobBooking.UserID = userID; string query = ""; if (checkJobBookingExist(jobBooking)) { query = $"update JobBooking set WorkingState = {jobBooking.WorkingState} where Date = '{jobBooking.Date}' and UserID = '{jobBooking.UserID}'"; } else { query = $"insert into JobBooking (UserID, Date, WorkingState) values ('{jobBooking.UserID}', '{jobBooking.Date}', {jobBooking.WorkingState})"; } sqlConnection.Close(); executeQuery(query); return(Ok()); }
public IHttpActionResult SaveData(JobBooking jobBooking) { Guid userID = new Guid("E8CC28D7-8E5A-496D-8183-25ECDE19F48E"); jobBooking.UserID = userID; string query = ""; if (checkJobBookingExist(jobBooking)) { query = $"update JobBooking set WorkingState = {jobBooking.WorkingState} where Date = '{jobBooking.Date}' and UserID = '{jobBooking.UserID}'"; } else { query = $"insert into JobBooking (UserID, Date, WorkingState) values ('{jobBooking.UserID}', '{jobBooking.Date}', {jobBooking.WorkingState})"; } sqlConnection.Close(); executeQuery(query); return(Ok()); }