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