public static bool UpdatePresent(PresentDay presentDay)
{
PresentDay currentPresentDay = GetPresentById(presentDay.IdPresentDay);
TimeSpan t = DateTime.Parse(presentDay.TimeEnd.ToString("yyyy-MM-dd HH:mm:ss")) - currentPresentDay.TimeBegin;
double addedHours = t.TotalHours;
string query = $"UPDATE task.PresentDay SET EndHour='{presentDay.TimeEnd.ToString("yyyy-MM-dd HH:mm:ss")}',TotalHours={addedHours} WHERE IdPresentDay={presentDay.IdPresentDay}";
if (DBAccess.RunNonQuery(query) == 1)
{
BOL.Models.Task currentTask = LogicTask.GetTaskByIdProjectAndIdUser(currentPresentDay.UserId, currentPresentDay.ProjectId);
currentTask.GivenHours += (decimal)addedHours;
if (LogicTask.UpdateTask(currentTask))
{
User Currentuser = LogicManager.GetUserDetails(currentPresentDay.UserId);
Currentuser.NumHoursWork += (decimal)addedHours;
if (LogicManager.UpdateUser(Currentuser))
{
return(true);
}
}
}
return(false);
}
public HttpResponseMessage Post([FromBody] PresentDay value)
{
if (ModelState.IsValid)
{
return((LogicPresentDay.AddPresent(value)) ?
new HttpResponseMessage(HttpStatusCode.Created) :
new HttpResponseMessage(HttpStatusCode.BadRequest)
{
Content = new ObjectContent <String>("Can not add to DB", new JsonMediaTypeFormatter())
});
}
;
List <string> ErrorList = new List <string>();
//if the code reached this part - the user is not valid
foreach (var item in ModelState.Values)
{
foreach (var err in item.Errors)
{
ErrorList.Add(err.ErrorMessage);
}
}
return(new HttpResponseMessage(HttpStatusCode.BadRequest)
{
Content = new ObjectContent <List <string> >(ErrorList, new JsonMediaTypeFormatter())
});
}
public static bool updatePresentDay(PresentDay presentDay)
{
try
{
var httpWebRequest = (HttpWebRequest)WebRequest.Create($@"http://{GlobalProp.URI}api/updatePresentDay");
httpWebRequest.ContentType = "application/json";
httpWebRequest.Method = "PUT";
using (var streamWriter = new StreamWriter(httpWebRequest.GetRequestStream()))
{
string cardsString = Newtonsoft.Json.JsonConvert.SerializeObject(presentDay, Formatting.None);
streamWriter.Write(cardsString);
streamWriter.Flush();
streamWriter.Close();
}
var httpResponse = (HttpWebResponse)httpWebRequest.GetResponse();
if (httpResponse.StatusDescription == "OK")
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
return(false);
}
}
/// <summary>
/// Update pressent- date time
/// </summary>
/// <param name="present">PresentDay contain- idUser, idProject, dateEnd</param>
/// <returns>bool true- succsess to update, false- failed to update</returns>
public static bool UpdatePresent(PresentDay present)
{
string dateEnd = present.TimeEnd.ToLocalTime().ToString("yyyy-MM-dd hh:mm:ssss");
string query = $"set @id=0;select max(presentDayId) into @id from presentday where id = {present.UserId} and projectId ={present.ProjectId}; UPDATE `managertasks`.`presentday`SET`timeEnd` = '{dateEnd}' WHERE presentDayId = @id and id ={present.UserId} and projectId = {present.ProjectId}";
return(DBAccess.RunNonQuery(query) != null);
}
/// <summary>
/// AddPresentDay
/// </summary>
/// <param name="presentDay">presentDay contain -idUser, idProject and dateStart</param>
/// <returns>bool true- succses update, false- failed update</returns>
public static bool UpdatePresentDay(PresentDay presentDay)
{
try
{
var httpWebRequest = (HttpWebRequest)WebRequest.Create($@"{GlobalProp.URI}api/updatePresentDay");
httpWebRequest.ContentType = "application/json";
httpWebRequest.Method = "PUT";
using (var streamWriter = new StreamWriter(httpWebRequest.GetRequestStream()))
{
string cardsString = Newtonsoft.Json.JsonConvert.SerializeObject(presentDay, Formatting.None);
streamWriter.Write(cardsString);
streamWriter.Flush();
streamWriter.Close();
}
var httpResponse = (HttpWebResponse)httpWebRequest.GetResponse();
var responseString = new StreamReader(httpResponse.GetResponseStream()).ReadToEnd();
BaseService.GetMessage(responseString, "succses");
return(true);
}
catch (WebException ex)
{
BaseService.GetErrorsFromServer(ex);
return(false);
}
catch
{
BaseService.GetMessage("failed to set pressent", "failed");
return(false);
}
}
/// <summary>
/// Add pressent
/// </summary>
/// <param name="presentDay">presentDay- contain idUser, idProject, dateBegin </param>
/// <returns></returns>
public static bool AddPresent(PresentDay presentDay)
{
string dateBegin = presentDay.TimeBegin.ToLocalTime().ToString("yyyy-MM-dd hh:mm:ssss");
string dateEnd = presentDay.TimeEnd.ToLocalTime().ToString("yyyy-MM-dd hh:mm:ssss");
string query = $"INSERT INTO `managertasks`.`PresentDay`(`timeBegin`,`timeEnd`,`projectId`,`id`) VALUES('{dateBegin}','{dateEnd}',{presentDay.ProjectId},{presentDay.UserId}); ";
return(DBAccess.RunNonQuery(query) == 1);
}
//end timer to finish work
private bool EndPressent()
{
timerPressent.Enabled = false;
PresentDay p = new PresentDay();
p.UserId = GlobalProp.CurrentUser.UserId;
p.ProjectId = (listProjectsWorker.SelectedItem.Tag as Project).ProjectId;
p.TimeEnd = DateTime.Now;
return(PresentDayRequests.UpdatePresentDay(p));
}
private void btn_login_Click(object sender, EventArgs e)
{
presentDay = new PresentDay()
{
UserId = worker.UserId,
ProjectId = currentProject.ProjectId,
TimeBegin = DateTime.Parse(txt_clock.Text),
};
cmb_myProjects.Enabled = false;
PresentDayRequests.AddPresent(presentDay);
btn_login.Enabled = false;
btn_logout.Enabled = true;
}
public HttpResponseMessage Put([FromBody] PresentDay value)
{
if (ModelState.IsValid)
{
return((LogicPresentDay.UpdatePresent(value)) ?
new HttpResponseMessage(HttpStatusCode.OK) :
new HttpResponseMessage(HttpStatusCode.BadRequest)
{
Content = new ObjectContent <String>("Can not update in DB", new JsonMediaTypeFormatter())
});
}
;
return(Request.CreateResponse(HttpStatusCode.BadRequest, BaseLogic.GetErorList(ModelState.Values)));
}
public static bool AddPresent(PresentDay NewpresentDay)
{
//Post Request for Register
var httpWebRequest = (HttpWebRequest)WebRequest.Create(@"http://localhost:61309/api/PresentDay/AddPresent");
httpWebRequest.ContentType = "application/json";
httpWebRequest.Method = "POST";
using (var streamWriter = new StreamWriter(httpWebRequest.GetRequestStream()))
{
string presentDay = JsonConvert.SerializeObject(NewpresentDay, Formatting.None);
streamWriter.Write(presentDay);
streamWriter.Flush();
streamWriter.Close();
}
try
{
//Gettting response
var httpResponse = (HttpWebResponse)httpWebRequest.GetResponse();
//Reading response
using (var streamReader = new StreamReader(httpResponse.GetResponseStream(), ASCIIEncoding.ASCII))
{
string result = streamReader.ReadToEnd();
//If AddPresent succeeded
if (httpResponse.StatusCode == HttpStatusCode.Created)
{
if (!int.TryParse(result, out idPresentDay))
{
return(false);
}
return(true);
}
return(false);
}
}
catch (WebException ex)
{
using (var stream = ex.Response.GetResponseStream())
using (var reader = new StreamReader(stream))
{
//Printing the matchung errors:
MessageBox.Show(reader.ReadToEnd());
}
return(false);
}
}
public static int AddPresent(PresentDay presentDay)
{
//TODO:לעדכן את סך השעות שהעובד עבד
string query = $"INSERT INTO `task`.`PresentDay`(`IdProject`,`IdUser`,`startHour`,`EndHour`,`Totalhours`) VALUES({presentDay.ProjectId},{presentDay.UserId},'{presentDay.TimeBegin.ToString("yyyy-MM-dd HH:mm:ss tt")}','{presentDay.TimeEnd.ToString("yyyy-MM-dd HH:mm:ss")}',{presentDay.sumHoursDay}); ";
if (DBAccess.RunNonQuery(query) == 1)
{
try {
return(GetPresent(presentDay.UserId, presentDay.ProjectId, presentDay.TimeBegin).IdPresentDay);
}
catch
{
return(0);
}
}
return(0);
}
private void btn_end_Click(object sender, EventArgs e)
{
timer1.Enabled = false;
PresentDay p = new PresentDay();
p.UserId = GlobalProp.CurrentUser.UserId;
p.ProjectId = (cmbx_projects.SelectedItem as Project).ProjectId;
p.TimeEnd = DateTime.Now;
if (PresentDayRequests.updatePresentDay(p))
{
MessageBox.Show("End");
}
else
{
MessageBox.Show("Error");
}
}
public static bool UpdatePresentDay(PresentDay presentDay)
{
HttpWebRequest httpWebRequest = (HttpWebRequest)WebRequest.Create($@"http://localhost:61309/api/PresentDay/UpdatePresentDay");
httpWebRequest.ContentType = "application/json";
httpWebRequest.Method = "PUT";
using (var streamWriter = new StreamWriter(httpWebRequest.GetRequestStream()))
{
dynamic currentPresentDay = presentDay;
string currentPresentNameString = Newtonsoft.Json.JsonConvert.SerializeObject(currentPresentDay, Formatting.None);
streamWriter.Write(currentPresentNameString);
streamWriter.Flush();
streamWriter.Close();
}
//Get response
try
{
//Gettting response
var httpResponse = (HttpWebResponse)httpWebRequest.GetResponse();
//Reading response
using (var streamReader = new StreamReader(httpResponse.GetResponseStream(), ASCIIEncoding.ASCII))
{
string result = streamReader.ReadToEnd();
//If AddPresent succeeded
if (httpResponse.StatusCode == HttpStatusCode.OK)
{
return(true);
}
return(false);
}
}
catch (WebException ex)
{
using (var stream = ex.Response.GetResponseStream())
using (var reader = new StreamReader(stream))
{
//Printing the matchung errors:
MessageBox.Show(reader.ReadToEnd());
}
return(false);
}
}
public static bool AddPresent(PresentDay NewpresentDay)
{
try
{
//Post Request for Register
var httpWebRequest = (HttpWebRequest)WebRequest.Create(@"http://localhost:61309/api/AddPresent");
httpWebRequest.ContentType = "application/json";
httpWebRequest.Method = "POST";
using (var streamWriter = new StreamWriter(httpWebRequest.GetRequestStream()))
{
string user = JsonConvert.SerializeObject(NewpresentDay, Formatting.None);
streamWriter.Write(user);
streamWriter.Flush();
streamWriter.Close();
}
//Gettting response
var httpResponse = (HttpWebResponse)httpWebRequest.GetResponse();
//Reading response
using (var streamReader = new StreamReader(httpResponse.GetResponseStream(), ASCIIEncoding.ASCII))
{
string result = streamReader.ReadToEnd();
//If Register succeeded
if (httpResponse.StatusCode == HttpStatusCode.Created)
{
idPresentDay = int.Parse(result);
return(true);
}
//Printing the matching error
}
}
catch (Exception exception)
{
System.Windows.Forms.MessageBox.Show("failed to add");
}
return(false);
}
public HttpResponseMessage UpdatePresentDay([FromBody] PresentDay value)
{
if (ModelState.IsValid)
{
return(LogicPresentDay.UpdatePresent(value) ?
Request.CreateResponse(HttpStatusCode.OK) :
Request.CreateResponse(HttpStatusCode.BadRequest, "Can not update in DB"));
}
;
List <string> ErrorList = new List <string>();
//if the code reached this part - the user is not valid
foreach (var item in ModelState.Values)
{
foreach (var err in item.Errors)
{
ErrorList.Add(err.ErrorMessage);
}
}
return(Request.CreateResponse(HttpStatusCode.BadRequest, ErrorList));
}
private void btn_start_Click(object sender, EventArgs e)
{
timer1.Enabled = true;
//btn_end.Visible = true;
//btn_start.Visible = false;
PresentDay p = new PresentDay();
p.UserId = GlobalProp.CurrentUser.UserId;
p.ProjectId = (cmbx_projects.SelectedItem as Project).ProjectId;
DateTime d = DateTime.Now;
p.TimeBegin = d;
p.TimeEnd = d;
if (PresentDayRequests.addPresentDay(p))
{
MessageBox.Show("Start");
}
else
{
MessageBox.Show("Error");
}
}
public static bool addPresentDay(PresentDay presentDay)
{
try
{
var httpWebRequest = (HttpWebRequest)WebRequest.Create($"{GlobalProp.URI}api/AddPresent");
httpWebRequest.ContentType = "application/json";
httpWebRequest.Method = "POST";
using (var streamWriter = new StreamWriter(httpWebRequest.GetRequestStream()))
{
string NewUserString = Newtonsoft.Json.JsonConvert.SerializeObject(presentDay, Formatting.None);
streamWriter.Write(NewUserString);
streamWriter.Flush();
streamWriter.Close();
}
//Gettting response
var httpResponse = (HttpWebResponse)httpWebRequest.GetResponse();
//Reading response
using (var streamReader = new System.IO.StreamReader(httpResponse.GetResponseStream(), ASCIIEncoding.ASCII))
{
string result = streamReader.ReadToEnd();
//If Login succeeded
if (result != null)
{
return(true);
}
else
{
return(false);
}
}
}
catch (Exception ex)
{
return(false);
}
}
