public async Task UpdateEmployeeImage(EmployeeImageViewModel model)
{
if (model.EmployeeImage != null)
{
var employeeImage = new EmployeeImageModel
{
ImageId = model.ImageId,
EmployeeId = model.EmployeeId,
};
using (var memoryStream = new MemoryStream())
{
await model.EmployeeImage.CopyToAsync(memoryStream);
employeeImage.Images = memoryStream.ToArray();
}
var existingImage = await _employeeImageService.ExistsAsync(model.EmployeeId);
if (existingImage)
{
await _employeeImageService.UpdateAsync(employeeImage);
}
else
{
await _employeeImageService.AddAsync(employeeImage);
}
}
}
public int SaveEmployeeImage(EmployeeImageModel image)
{
var resultVal = imgrepository.AddEmployeeImage(image);
return(0);
}
public async Task UpdateAsync(EmployeeImageModel model)
{
var entity = await _repository.GetByIdAsync(model.ImageId);
entity.EmployeeId = model.EmployeeId;
entity.Images = model.Images;
await _repository.UpdateAsync(entity);
}
public ActionResult UploadPhoto(EmployeeImageModel image, HttpPostedFileBase file)
{
try
{
//if (file != null && file.ContentLength > 0)
// try
// {
// string path = Path.Combine(Server.MapPath("~/Images"),
// Path.GetFileName(file.FileName));
// file.SaveAs(path);
// ViewBag.Message = "File uploaded successfully";
// image.EmployeeImage= new byte[file.ContentLength];
// file.InputStream.Read(image.EmployeeImage, 0, file.ContentLength);
// ImageService imageService = new ImageService();
// imageService.SaveImage(image);
// return Json("Uploaded Successful");
// }
// catch (Exception ex)
// {
// ViewBag.Message = "ERROR:" + ex.Message.ToString();
// }
//else
//{
// ViewBag.Message = "You have not specified a file.";
//}
//return View();
String FileExt = Path.GetExtension(file.FileName).ToUpper();
EmployeeImageService imageService = new EmployeeImageService();
if (FileExt == ".JPG")
{
Stream str = file.InputStream;
BinaryReader Br = new BinaryReader(str);
Byte[] FileDet = Br.ReadBytes((Int32)str.Length);
image.EmployeeNumber = (Int64)Session["empId"];
image.FileDescription = "EmployeeImage";
image.FileName = file.FileName;
image.FileContent = FileDet;
imageService.SaveEmployeeImage(image);
return(Json("Photo Uploaded Successfully"));
}
else
{
return(Json("Invalid file format"));
}
}
catch (Exception ex)
{
return(Json("Upload failed"));
}
}
public async Task <EmployeeImageModel> AddAsync(EmployeeImageModel model)
{
var entity = new EmployeeImage
{
ImageId = model.ImageId,
EmployeeId = model.EmployeeId,
Images = model.Images
};
entity = await _repository.AddAsync(entity);
return(_mapper.Map <EmployeeImage, EmployeeImageModel>(entity));
}
public int AddEmployeeImage(EmployeeImageModel image)
{
try
{
string query = string.Empty;
using (IDbConnection connection = OpenConnection())
{
var param = new DynamicParameters();
if (image != null)
{
query = StoredProcedure.AddEmployeeImage;
}
return(connection.Execute(query, image, commandType: CommandType.StoredProcedure));
}
}
catch (Exception ex)
{
return(0);
}
}
public async Task UpdateProfile(ProfileEditViewModel model)
{
if (model.EmployeeImage != null)
{
var employeeImage = new EmployeeImageModel
{
ImageId = model.ImageId,
EmployeeId = model.EmployeeId,
};
using (var memoryStream = new MemoryStream())
{
await model.EmployeeImage.CopyToAsync(memoryStream);
employeeImage.Images = memoryStream.ToArray();
}
var existingImage = await _employeeImageService.ExistsAsync(model.EmployeeId);
if (existingImage)
{
await _employeeImageService.UpdateAsync(employeeImage);
}
else
{
await _employeeImageService.AddAsync(employeeImage);
}
}
// update employee
var employee = new EmployeeModel
{
EmployeeId = model.EmployeeId,
GlobalId = model.GlobalId,
CardId = model.CardId,
Title = model.Title,
TitleThai = model.TitleThai,
EmployeeType = model.EmployeeType,
FirstName = model.FirstName,
LastName = model.LastName,
FirstNameThai = model.FirstNameThai,
LastNameThai = model.LastNameThai,
Gender = model.Gender,
BirthDate = model.BirthDate,
HireDate = model.HireDate,
AvailableFlag = true,
ChangedDate = DateTime.Now,
};
await _employeeService.UpdateAsync(employee);
// add or update employee state
var employeeState = new EmployeeStateModel
{
EmployeeId = model.EmployeeId,
DepartmentId = model.DepartmentId,
SectionId = model.SectionId,
ShiftId = (byte)model.ShiftId,
LevelId = model.LevelId,
PositionId = model.JobPositionId,
JobFunctionId = model.JobFunctionId,
BusStationId = model.BusStationId,
JoinDate = model.JoinDate,
ChangedDate = DateTime.Now
};
var existEmployeeState = await _employeeStateService.ExistsAsync(model.EmployeeId);
if (existEmployeeState)
{
await _employeeStateService.UpdateAsync(employeeState);
}
else
{
await _employeeStateService.AddAsync(employeeState);
}
// add or update address
var address = new EmployeeAddressModel
{
EmployeeAddressId = model.EmployeeAddressId,
EmployeeId = model.EmployeeId,
HomeAddress = model.HomeAddress,
City = model.City,
Country = model.Country,
PostalCode = model.PostalCode,
PhoneNumber = model.PhoneNumber,
EmailAddress = model.EmailAddress,
ChangedDate = DateTime.Now
};
if (address.EmployeeAddressId > 0)
{
await _employeeAddressService.UpdateAsync(address);
}
else
{
await _employeeAddressService.AddAsync(address);
}
}
