protected void btnSearch_Click(object sender, EventArgs e)
{
try
{
JobsDTO dto = new JobsDTO();
conn = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();
SqlConnection myConn = new SqlConnection(conn);
myConn.Open();
string select = "Select jobID, itemID, technicianID, dateAssigned from Jobs where (jobID= "; select += dropDownJobID.SelectedValue + ")";
SqlCommand selectCmd = new SqlCommand(select, myConn);
SqlDataReader myReader;
myReader = selectCmd.ExecuteReader();
while (myReader.Read())
{
if (myReader.GetString(0) == dropDownJobID.SelectedValue)
{
dto.jobID = myReader.GetString(0);
dto.itemID = myReader.GetString(1);
dto.techID = myReader.GetString(2);
dto.dateAssigned = myReader.GetString(3);
break;
}
}
myConn.Close();
Session["JobsDTO"] = dto;
Server.Transfer("JobsEdit2.aspx");
}
catch (SqlException ex)
{
Console.Write("Error: " + ex.ToString());
}
}
public IActionResult Create(JobsDTO jobs)
{
if (ModelState.IsValid)
{
_jobs.AddJob(_mapper.Map <Jobs>(jobs));
return(RedirectToAction(nameof(Index)));
}
return(View(jobs));
}
private void getSessionData()
{
JobsDTO dto = (JobsDTO)Session["JobsDTO"];
ModelFacade facade = new ModelFacade();
Jobs job = facade.createJob(dto);
lblJobID.Text = job.jobID;
lblItemID.Text = job.itemID;
lblTechID.Text = job.techID;
lblDateAssigned.Text = job.dateAssigned;
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
JobsDTO dto = (JobsDTO)Session["JobsDTO"];
ModelFacade facade = new ModelFacade();
Jobs job = facade.createJob(dto);
JobsDAO dao = new JobsDAO();
dao.issueJob(job);
Session.Abandon();
Response.Redirect("~/Staff/AdminHome.aspx");
}
public Jobs createJob(JobsDTO dto)
{
Jobs job = new Jobs();
job.jobID = dto.jobID;
job.itemID = dto.itemID;
job.techID = dto.techID;
job.dateAssigned = dto.dateAssigned;
job.partID = dto.partID;
job.hoursWorked = dto.hoursWorked;
job.dateCompleted = dto.dateCompleted;
return(job);
}
public JobsDTO Patch(int id, [FromBody] JsonPatchDocument <JobsDTO> jobPatch)
{
//get original job object from the database
Jobs originJob = jobRepository.GetJobsByID(id);
//use automapper to map that to DTO object
JobsDTO jobDTO = _mapper.Map <JobsDTO>(originJob);
//apply the patch to that DTO
jobPatch.ApplyTo(jobDTO);
//use automapper to map the DTO back ontop of the database object
_mapper.Map(jobDTO, originJob);
//update job in the database
_context.Update(originJob);
_context.SaveChanges();
return(jobDTO);
}
public IActionResult Edit(int id, JobsDTO jobs)
{
if (id != jobs.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_jobs.UpdateJob(_mapper.Map <Jobs>(jobs));
}
catch (Exception ex)
{
ModelState.AddModelError("ErrorUpdate", ex.Message);
}
return(RedirectToAction(nameof(Index)));
}
return(View(jobs));
}
