// GET: EmployeeImages/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
EmployeeImage employeeImage = _employeeImageManager.FindById((int)id);
if (employeeImage == null)
{
return(HttpNotFound());
}
EmployeeImageViewModel employeeImageViewModel = Mapper.Map <EmployeeImageViewModel>(employeeImage);
return(View(employeeImageViewModel));
}
// New-Button control is clicked
private void NewEmployeeButton_Click(object sender, RoutedEventArgs e)
{
// add a new employee
EmployeeImage employeeImage = (EmployeeImage)ImageComboBox.SelectedValue;
ViewModel.AddEmployee(FirstnameTextBox.Text, LastnameTextBox.Text, JobTitleTextBox.Text, employeeImage);
// empty UI fields
FirstnameTextBox.Text = "";
LastnameTextBox.Text = "";
JobTitleTextBox.Text = "";
ImageComboBox.SelectedIndex = -1;
// select firstname
FirstnameTextBox.Focus(FocusState.Programmatic);
}
public async Task UpdateEmployeeImage(EmployeeImage user)
{
using (var sqlConnection = new SqlConnection(connectionString))
{
await sqlConnection.OpenAsync();
var dynamicParameters = new DynamicParameters();
dynamicParameters.Add("@StatementType", "Update");
dynamicParameters.Add("@EmployeeId", user.EmployeeId);
dynamicParameters.Add("@BLOBData", user.blobData);
await sqlConnection.ExecuteAsync(
"spSelectInsertUpdateDeleteEmpImage",
dynamicParameters,
commandType : CommandType.StoredProcedure);
}
}
public static EmployeeImage GetByEmployeeID(string emp)
{
var result = new EmployeeImage();
try
{
using (var ctx = new BIG_DBEntities())
{
result = ctx.EmployeeImages.Where(x => x.EMP_ID == emp).FirstOrDefault();
}
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
public async Task <IHttpActionResult> POST([FromBody] EmployeeImage image)
{
try
{
if (ModelState.IsValid)
{
var img = await EmployeeImage.AddItemAsync(image);
return(Ok(img));
}
else
{
return(BadRequest());
}
}
catch (Exception ex)
{
return(BadRequest());
}
}
public JsonResult UploadImage(EmployeeImageViewModel employeeImageViewModel)
{
var file = employeeImageViewModel.ImageFile;
byte[] imageBytes = null;
int imgId = 0;
if (file != null)
{
//file.SaveAs(Server.MapPath("/EmployeeProfileImages/" + file.FileName));
BinaryReader reader = new BinaryReader(file.InputStream);
imageBytes = reader.ReadBytes(file.ContentLength);
EmployeeImage employeeImage = new EmployeeImage();
employeeImage.ImageByte = imageBytes;
employeeImage.ImageName = file.FileName;
employeeImage.ImagePath = null; /*"/EmployeeProfileImages/" + file.FileName;*/
_employeeImageManager.Add(employeeImage);
imgId = employeeImage.Id;
}
return(Json(imgId, JsonRequestBehavior.AllowGet));
}
public static bool UploadPhoto(EmployeeImage Photo)
{
var result = false;
try
{
if (Photo != null)
{
DeletePhoto(Photo.EMP_ID);
}
using (var ctx = new BIG_DBEntities())
{
ctx.EmployeeImages.Add(Photo);
ctx.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
public IResult Delete(EmployeeImage employeeImage)
{
FileHelper.Delete(employeeImage.ImagePath);
_employeeImageDal.Delete(employeeImage);
return(new SuccessResult(Messages.EmployeeImagesSuccessfullyDeleted));
}
/// <summary>
/// Saves the employee's image into the context (SCAPEDB in this case)
/// </summary>
/// <param name="image">Employee image to save</param>
public async Task saveImageEmployee(EmployeeImage image)
{
_context.Image.Add(image);
await _context.SaveChangesAsync();
}
public async Task Put(string employeeId, [FromBody] EmployeeImage user)
{
await this.empDataProvider.UpdateEmployeeImage(user);
}
public async Task Post([FromBody] EmployeeImage user)
{
await this.empDataProvider.AddEmployeeImage(user);
}
