public static void ProcessNewRequest(SourceRequestViewModel model, string _EmpNum)
{
string Content = "A new sourcing request has been initiated by " + model.INITIATOR_NAME;
Content += " , log on to the Procurement application to approve/decline the request.";
try
{
SOURCING_REQUEST _NewRequest = new SOURCING_REQUEST();
decimal ItemId = GetSequence();
var InfoFromHRMS = GetInfoFromHRMS.GetSupervisorsDetails(_EmpNum);
using (Entities context = new Entities())
{
_NewRequest.TEMP_ID = ItemId;
_NewRequest.ITEM_CATEGORY = model.ITEM_CATEGORY;
_NewRequest.ITEM_DESCRIPTION = model.ITEM_DESCRIPTION;
_NewRequest.PREFERED_VENDOR = model.PREFERED_VENDOR;
_NewRequest.PREFERED_VENDOR_ID = model.PREFERED_VENDOR_ID;
_NewRequest.INITIATING_BRANCH = model.INITIATING_BRANCH;
_NewRequest.INITIATOR_NAME = model.INITIATOR_NAME;
_NewRequest.INITIATOR_NUMBER = model.INITIATOR_NUMBER;
_NewRequest.INITIATING_BRANCHCODE = model.INITIATING_BRANCHCODE;
_NewRequest.INITIATING_DEPT = model.INITIATING_DEPT;
_NewRequest.INITIATION_DATE = DateTime.Now;
_NewRequest.INITIATOR_EMAIL = model.INITIATOR_EMAIL;
_NewRequest.EXPECTED_DELIVERY_DATE = model.EXPECTED_DELIVERY_DATE;
_NewRequest.INITIATING_DEPTCODE = model.INITIATING_DEPTCODE;
_NewRequest.LINE_MANAGER_NAME = InfoFromHRMS.FullName;
_NewRequest.LINE_MANAGER_NUM = InfoFromHRMS.EmployeeNumber;
_NewRequest.LINE_MANAGER_APPR = "Pending";
_NewRequest.LINE_MANAGER_EMAIL = InfoFromHRMS.Email;
_NewRequest.ITEM_CATEGORY_ID = model.ITEM_CATEGORY_ID;
context.SOURCING_REQUEST.Add(_NewRequest);
context.SaveChanges();
}
DocumentUploadDownload.UploadDocument(model.Files, model.INITIATING_BRANCHCODE, ItemId);
bool MailResponse = SendMail.prepMail(Content, InfoFromHRMS.FullName, InfoFromHRMS.Email, emailTemplatePath);
if (MailResponse)
{
Logger.Log("Email Sent to " + InfoFromHRMS.Email, "Info");
}
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
Logger.Log("Entity of type " + eve.Entry.Entity.GetType().Name + " in state " + eve.Entry.State + " has the following validation errors:", "error");
foreach (var ve in eve.ValidationErrors)
{
Logger.Log("- Property: " + ve.PropertyName + ", Error: " + ve.ErrorMessage + " ", "error");
}
}
// Logger.Log("An error occured upon inserting new request into database. Error: " + ex.StackTrace, "error");
}
}
public ActionResult Login(LoginViewModel model, string urlReturn)
{
string _Role = "";
//var pass = AuthenticationService.Validate(model.UserName, model.Password);
var profile = AuthenticationService.GetUserProfile(model.UserName);
if (profile.EmployeeNumber != null)
{
var claims = new List <Claim>();
//var profile = AuthenticationService.GetUserProfile(model.UserName);
var userDetailsFrmDb = UserDBValidation.CheckUserExist(model.UserName);// Check is user exist in the database
if (userDetailsFrmDb != null)
{
_Role = userDetailsFrmDb.ROLE;
claims.Add(new Claim(ClaimTypes.Role, _Role));
claims.Add(new Claim(ClaimTypes.Rsa, Convert.ToString(userDetailsFrmDb.ROLE_ID)));
claims.Add(new Claim(ClaimTypes.Dns, userDetailsFrmDb.CATEGORY));
claims.Add(new Claim(ClaimTypes.Dsa, Convert.ToString(userDetailsFrmDb.CATEGORY_ID)));
claims.Add(new Claim(ClaimTypes.Actor, Convert.ToString(userDetailsFrmDb.USER_ID)));
}
else
{
_Role = "Public";
claims.Add(new Claim(ClaimTypes.Role, _Role));
}
var GetBranchCodeAndCostCenter = GetInfoFromHRMS.GetCostCenterWithEmpNumber(profile.EmployeeNumber);
var GetDeptCodeDesc = GetInfoFromHRMS.GetDeptCodeDesc(GetBranchCodeAndCostCenter.CostCenterCode);
var Branches = GetInfoFromHRMS.GetBranches(GetBranchCodeAndCostCenter.BranchCode);
string MainBranch = Branches.Branch;
var BranchCode = GetBranchCodeAndCostCenter.BranchCode ?? profile.BranchCode;
//if (BranchCode == Category.HQCODE)
//{
// claims.Add(new Claim(ClaimTypes.Actor, GetBranchCodeAndCostCenter.CostCenterCode));
//}
claims.Add(new Claim(ClaimTypes.Name, profile.UserName));
claims.Add(new Claim(ClaimTypes.GivenName, profile.FullName));
claims.Add(new Claim(ClaimTypes.SerialNumber, profile.EmployeeNumber));
claims.Add(new Claim(ClaimTypes.UserData, GetDeptCodeDesc.DeptName));
claims.Add(new Claim(ClaimTypes.Email, profile.Email));
claims.Add(new Claim(ClaimTypes.StateOrProvince, MainBranch));
claims.Add(new Claim(ClaimTypes.PostalCode, BranchCode));
claims.Add(new Claim(ClaimTypes.Actor, GetBranchCodeAndCostCenter.CostCenterCode));
claims.Add(new Claim(ClaimTypes.Locality, GetDeptCodeDesc.DeptName));
SignInAsync(new ClaimsIdentity(claims, DefaultAuthenticationTypes.ApplicationCookie));
Logger.Log("Successful Login by " + profile.FullName + " Employee's Number " + profile.EmployeeNumber, "info");
return(RedirectToLocal(urlReturn, _Role));
}
ViewBag.ErrorMessage = "Invalid username or password.";
return(View(model));
}
//get users in Procurement
public static List <SelectListItem> GetUsersInProcurement()
{
List <SelectListItem> _listItems = new List <SelectListItem>();
var UserInProcurement = GetInfoFromHRMS.GetUsersInProcurementDept();
foreach (var item in UserInProcurement)
{
_listItems.Add(new SelectListItem
{
Text = item.FullName,
Value = GetUserName(item.Email)
});
}
return(_listItems);
}
