public ActionResult NewEmployee(EmployeeViewModel model)
{
Employee newEmployee = new Employee();
try
{
//Transfer the models info to our main Employee Model
newEmployee.EmployeeID = model.EmployeeID;
newEmployee.FirstName = model.FirstName;
newEmployee.LastName = model.LastName;
newEmployee.MiddleName = model.MiddleName;
newEmployee.PhoneNumber = model.PhoneNumber;
newEmployee.EmailAddress = model.EmailAddress;
newEmployee.Gender = model.Gender;
newEmployee.PositionID = model.PositionID;
newEmployee.DepartmentID = model.DepartmentID;
if (model.Status_booleanVal)
{
newEmployee.Status = 1;
}
else
{
newEmployee.Status = 0;
}
if (model.CompanyName != null)
{
newEmployee.IsCompany = 1;
newEmployee.CompanyName = model.CompanyName;
}
EmployeeProcess employeeProcess = new EmployeeProcess();
int result = employeeProcess.Add(newEmployee);
if (result == FASTConstant.RETURN_VAL_SUCCESS)
{
TempData[FASTConstant.TMPDATA_RESULT] = FASTConstant.SUCCESSFUL;
TempData[FASTConstant.TMPDATA_SOURCE] = "Add New Employee";
TempData[FASTConstant.TMPDATA_EXTRAMESSAGE] = "The new employee has been added to the database.";
TempData[FASTConstant.TMPDATA_ACTION] = "Index";
TempData[FASTConstant.TMPDATA_CONTROLLER] = "Employee";
return(View("~/Views/Shared/Result.cshtml"));
}
else
{
throw new Exception("There was an error while adding the new employee.");
}
}
catch (Exception ex)
{
TempData[FASTConstant.TMPDATA_RESULT] = FASTConstant.FAILURE;
TempData[FASTConstant.TMPDATA_SOURCE] = "Add New Employee";
TempData[FASTConstant.TMPDATA_EXTRAMESSAGE] = ex.Message;
return(View("~/Views/Shared/Result.cshtml"));
}
}
public ActionResult MyAssets()
{
AssignmentProcess assignProcess = new AssignmentProcess();
EmployeeProcess employeeProcess = new EmployeeProcess();
ViewBag.Assignments = assignProcess.GetCurrentAssignmentsByEmployeeID(User.Identity.Name.ToInteger());
ViewBag.Acceptances = assignProcess.GetAssignmentsForAcceptanceByEmployeeID(User.Identity.Name.ToInteger());
ViewBag.History = assignProcess.GetAllAssignmentsByEmployeeID(User.Identity.Name.ToInteger());
return(View(employeeProcess.GetEmployeeProfileByID(User.Identity.Name.ToInteger())));
}
public ActionResult MyAssetHistoryReport()
{
AssignmentProcess assignProcess = new AssignmentProcess();
EmployeeProcess employeeProcess = new EmployeeProcess();
int employeeID = User.Identity.Name.ToInteger();
ViewBag.Employee = employeeProcess.GetEmployeeProfileByID(employeeID);
ViewBag.Assets = assignProcess.GetAllAssignmentsByEmployeeID(employeeID);
return(View());
}
private string GetEmployee(int employeeID)
{
if (employeeID > 0)
{
EmployeeProcess process = new EmployeeProcess();
Common.Employee employee = process.GetByID(employeeID);
return(String.Format("{0} , {1} {2}", employee.LastName, employee.FirstName, employee.MiddleName));
}
return(String.Empty);
}
public ActionResult Index()
{
EmployeeProcess employeeProcess = new EmployeeProcess();
IQueryable <vwEmployeeList> list = employeeProcess.GetEmployeeProfiles();
int departmentID = 0;
if (Session["Department"] != null)
{
if (Int32.TryParse(Session["Department"].ToString(), out departmentID))
{
list = employeeProcess.GetEmployeeProfiles().Where(i => i.DepartmentID == departmentID);
}
}
TempData["Employees"] = list.ToList();
return(View(list.ToList()));
}
public ActionResult EditEmployee(int mod)
{
GenericProcess <Department> deptProcess = new GenericProcess <Department>();
GenericProcess <Position> positionProcess = new GenericProcess <Position>();
EmployeeProcess employeeProcess = new EmployeeProcess();
ViewBag.Departments = deptProcess.GetAll().ToList();
ViewBag.Positions = positionProcess.GetAll().ToList();
int employeeID = mod;
FASTWeb.Models.EmployeeViewModel employeeEditView =
new EmployeeViewModel();
Employee employeeToEdit = employeeProcess.GetEmployeeByID(employeeID);
//move data to editview
employeeEditView.EmployeeID = employeeToEdit.EmployeeID;
employeeEditView.FirstName = employeeToEdit.FirstName;
employeeEditView.MiddleName = employeeToEdit.MiddleName;
employeeEditView.LastName = employeeToEdit.LastName;
employeeEditView.EmailAddress = employeeToEdit.EmailAddress;
employeeEditView.PhoneNumber = employeeToEdit.PhoneNumber;
employeeEditView.Gender = employeeToEdit.Gender;
employeeEditView.PositionID = employeeToEdit.PositionID;
employeeEditView.DepartmentID = employeeToEdit.DepartmentID;
employeeEditView.IsCompany = employeeToEdit.IsCompany;
employeeEditView.CompanyName = employeeToEdit.CompanyName;
employeeEditView.Status = employeeToEdit.Status;
if (employeeToEdit.Status == 1)
{
employeeEditView.Status_booleanVal = true;
}
else
{
employeeEditView.Status_booleanVal = false;
}
return(View(employeeEditView));
}
public ActionResult SearchEmployeeRights(int employeeID)
{
EmployeeProcess empProcess = new EmployeeProcess();
vwEmployeeList employee = empProcess.GetEmployeeProfileByID(employeeID);
GenericProcess <vwAccessRight> accessProcess = new GenericProcess <vwAccessRight>();
List <vwAccessRight> rights = accessProcess.GetAll().Where(i => i.EmployeeID == employeeID).ToList();
GenericProcess <AccessLevel> levels = new GenericProcess <AccessLevel>();
GenericProcess <vwDepartmentList> departments = new GenericProcess <vwDepartmentList>();
ViewBag.EmployeeID = employeeID;
ViewBag.AccessLevel = levels.GetAll().ToList();
ViewBag.Department = departments.GetAll().ToList();
ViewBag.Rights = rights;
return(View("NewAccessRight", employee));
}
public ActionResult ShowDepartmentEmployee(int departmentID)
{
EmployeeProcess employeeProcess = new EmployeeProcess();
GenericProcess <Common.vwDepartmentList> deptProcess =
new GenericProcess <Common.vwDepartmentList>();
List <vwEmployeeList> listOfEmployees = new List <vwEmployeeList>();
vwDepartmentList department = new vwDepartmentList();
try
{
listOfEmployees = employeeProcess.GetEmployeesByDepartmentID(departmentID);
department = deptProcess.GetAll().Where(i => i.DepartmentID == departmentID).First();
}
catch { }
ViewBag.Department = department.GroupName;
return(View("Index", listOfEmployees));
}
public ActionResult UploadFile()
{
ExcelHelper excelHelp = new ExcelHelper();
List <FixAssetExcelUploadModel> assets = new List <FixAssetExcelUploadModel>();
BulkUpload currentUpload = new Common.BulkUpload();
BulkUploadProcess bulkProcess = new BulkUploadProcess();
AssetProcess assetProcess = new AssetProcess();
EmployeeProcess employeeProcess = new EmployeeProcess();
Employee sender = new Employee();
ConfigurationProcess configProcess = new ConfigurationProcess();
FastEmailConfiguration emailConfig = configProcess.GetEmailConfiguration();
StringBuilder uploadLog = new StringBuilder();
string filename = string.Empty;
string completeFileName = string.Empty;
//This is for the logging
bulkProcess.UserID = User.Identity.Name.ToInteger();
configProcess.UserID = User.Identity.Name.ToInteger();
employeeProcess.UserID = User.Identity.Name.ToInteger();
assetProcess.UserID = User.Identity.Name.ToInteger();
try
{
#region Get Request Files
foreach (string upload in Request.Files)
{
if (!(Request.Files[upload] != null && Request.Files[upload].ContentLength > 0))
{
continue;
}
string path = HttpContext.Server.MapPath("\\App_Data\\BulkUploads");
filename = Path.GetFileName(Request.Files[upload].FileName);
//check the filename and ensure its an xlsx file
if (String.Compare(filename.Substring(filename.Length - 4), "xlsx", true) != 0)
{
throw new Exception("Invalid file extension.");
}
//add the current time as unique indicator
filename = DateTime.Now.ToFileTime().ToString() + "_" + filename;
// If Upload folder is not yet existing, this code will create that directory.
if (!System.IO.Directory.Exists(path))
{
System.IO.Directory.CreateDirectory(path);
}
completeFileName = Path.Combine(path, filename);
Request.Files[upload].SaveAs(completeFileName);
}
#endregion
BulkUpload newFile = new BulkUpload()
{
EmployeeID = User.Identity.Name.ToInteger(),
FilePath = filename,
TotalRecords = 0,
TotalInserts = 0,
RequestDate = DateTime.Now,
Type = FASTConstant.BULKIPLOAD_TYPE_ASSET
};
if (bulkProcess.Add(newFile) == FASTConstant.RETURN_VAL_SUCCESS)
{
//get the current upload
currentUpload = bulkProcess.GetCurrentUpload(newFile.FilePath, newFile.EmployeeID);
}
if (currentUpload != null)
{
#region Process the excel file
//Success! Lets process the file.
System.Data.DataTable fixAssetTable = new DataTable();
fixAssetTable = excelHelp.GetExcelDataTable(completeFileName, "SELECT * FROM [FixAsset$]");
fixAssetTable = excelHelp.ConvertToFixAssetTable(fixAssetTable);
if (fixAssetTable == null)
{
throw new Exception("The upload file contains null data.");
}
assets = fixAssetTable.ToList <Models.FixAssetExcelUploadModel>();
sender = employeeProcess.GetEmployeeByID(currentUpload.EmployeeID);
if (assets.Count > 0)
{
int totalInserts = 0;
currentUpload.TotalRecords = assets.Count;
bulkProcess.UpdateProcessingStep(currentUpload, FASTConstant.BULKUPLOAD_STATUS_INPROGRESS);
foreach (FixAssetExcelUploadModel asset in assets)
{
FixAsset tempAsset = new FixAsset()
{
AssetTag = asset.AssetTag,
SerialNumber = asset.SerialNumber,
Model = asset.Model,
Brand = asset.Brand,
AssetClassID = asset.AssetClassID,
AssetTypeID = asset.AssetTypeID,
AssetStatusID = asset.AssetStatusID,
AcquisitionDate = asset.AcquisitionDate
};
if (assetProcess.Add(tempAsset) == FASTConstant.RETURN_VAL_SUCCESS)
{
totalInserts++;
uploadLog.AppendLine(String.Format("<p>{0} : {1} inserted.</p>", FASTConstant.SUCCESSFUL, asset.AssetTag));
}
else
{
uploadLog.AppendLine(String.Format("<p>{0} : {1} not inserted.</p>", FASTConstant.FAILURE, asset.AssetTag));
}
}
currentUpload.TotalInserts = totalInserts;
bulkProcess.UpdateProcessingStep(currentUpload, FASTConstant.BULKUPLOAD_STATUS_DONE);
//Send email to the requestor
FastEmail email = new FastEmail();
email.Receipients = new List <string>()
{
sender.EmailAddress
};
email.Subject = FASTConstant.EMAIL_SIMPLE_SUBJECT.Replace("[XXX]", "Fix Asset Bulk Upload Result");
email.HTMLBody = FASTProcess.Helper.EmailHelper.GenerateHTMLBody(FASTProcess.Helper.EmailHelper.EmailType.BULK_UPLOAD);
email.HTMLBody = email.HTMLBody.Replace(FASTConstant.EMAIL_RECEIPIENT_NAME, sender.FirstName + " " + sender.LastName);
email.HTMLBody = email.HTMLBody.Replace(FASTConstant.EMAIL_BULKUPLOAD_INFO, bulkProcess.GenerateUploadinformationHTML(currentUpload));
email.HTMLBody = email.HTMLBody.Replace(FASTConstant.EMAIL_BULKUPLOAD_LOG, uploadLog.ToString());
email.HTMLBody = email.HTMLBody.Replace(FASTConstant.EMAIL_BULKUPLOAD_SUMMARY, bulkProcess.GenerateSummaryinformationHTML(currentUpload));
SMTPEmail emailSender = new SMTPEmail(emailConfig, email);
emailSender.SendEmail();
}
else
{
bulkProcess.UpdateProcessingStep(currentUpload, FASTConstant.BULKUPLOAD_STATUS_DONE);
}
#endregion
}
TempData["Result"] = "SUCCESSFUL";
TempData["Source"] = "File Upload";
TempData["ExtraMessage"] = "An email will be sent to you containing the results of the upload process.";
TempData["Action"] = "Index";
TempData["Controller"] = "FixAsset";
return(View("~/Views/Shared/Result.cshtml"));
}
catch (Exception ex)
{
TempData["Result"] = "FAILURE";
TempData["Source"] = "Fix Asset Bulk Upload";
TempData["ExtraMessage"] = ex.Message;
return(View("~/Views/Shared/Result.cshtml"));
}
}
