public int DeleteEmployer(int EmployerID)
{
using (var db = new E2EWebPortalEntities())
{
return(db.sp_Delete_Employer(EmployerID));
}
}
public int ManageUserActivation(int RoleID, int EmployerID, int UserID, string IsActive)
{
using (var db = new E2EWebPortalEntities())
{
return(db.sp_ManageActivation_EA_Rew_Emp(RoleID, EmployerID, UserID, IsActive));
}
}
public int DeleteUser(int RoleID, int EmployerID, int UserID)
{
using (var db = new E2EWebPortalEntities())
{
return(db.sp_Delete_EA_Rew_Emp(RoleID, EmployerID, UserID));
}
}
public int UpsertEmployee(EmployeeViewModal user)
{
user.Password = EncryptionHelper.Encrypt(user.Password);
using (var db = new E2EWebPortalEntities())
{
return(db.sp_UpsertEmployee(user.EmployeeID
, user.UserName
, user.Password
, user.EmployerID
, user.RoleID
, user.Active
, user.FirstName
, user.MiddleName
, user.LastName
, user.NickName
, user.Title
, user.DateOfBirth
, user.Address1
, user.Address2
, user.City
, user.State
, user.zip
, user.WorkPhoneNumber
, user.Extn
, user.CellPhoneNumber
, user.PrimaryEmail
, user.SecondaryEmail
, user.CurrentVisaStatus
, user.CurrentVisaValidity));
}
}
public int UpsertReviewer(ReviewerViewModal user)
{
user.Password = EncryptionHelper.Encrypt(user.Password);
using (var db = new E2EWebPortalEntities())
{
return(db.sp_UpsertReviewer(user.ReviewerID
, user.UserName
, user.Password
, user.EmployerID
, user.RoleID
, user.Active
, user.ReviewerFirstName
, user.ReviewerMiddleName
, user.ReviewerLastName
, user.ReviewerNickName
, user.ReviewerTitle
, user.DateOfBirth
, user.Address1
, user.Address2
, user.City
, user.State
, user.zip
, user.WorkPhoneNumber
, user.Extn
, user.CellPhoneNumber
, user.PrimaryEmail
, user.SecondaryEmail));
}
}
public bool AddUserSendInvite(List <Invite> invites, int?EmployerID, string UserName)
{
//using (SqlConnection conn = new SqlConnection("data source=kumudini.database.windows.net;initial catalog=E2EWebPortal;persist security info=True;user id=SRV_E2EWebPortal;password=Admin@e2e;MultipleActiveResultSets=True;"))
using (var db = new E2EWebPortalEntities())
{
var dt = new DataTable();
dt.Columns.Add("FirstName");
dt.Columns.Add("LastName");
dt.Columns.Add("Email");
dt.Columns.Add("RoleID");
dt.Columns.Add("Notes");
dt.Columns.Add("EmployerID");
dt.Columns.Add("UserName");
foreach (Invite invite in invites)
{
dt.Rows.Add(invite.FirstName, invite.LastName, invite.Email, invite.Role, invite.AdditionalNotes, EmployerID, UserName);
}
var inviteList = new SqlParameter("InviteList", dt);
inviteList.TypeName = "[dbo].[SendInvitation]";
var users = db.Database.SqlQuery <int>("exec sp_AddUserSendInvite @InviteList", inviteList).ToList();
int i = 0;
foreach (int user in users)
{
invites[i].UserID = user;
i++;
}
return(users.Any());
}
}
public int UpdateLoginCount()
{
using (var db = new E2EWebPortalEntities())
{
return(db.sp_UpdateLoginCount());
}
}
public int MakeDefaultTaskReviewComment(int CommentID, int EmployerID, string isDefault)
{
using (var db = new E2EWebPortalEntities())
{
return(db.sp_MakeDefaultTaskReviewComment(EmployerID, CommentID, isDefault));
}
}
public int ResetCompletedTask(int roleID, int employerID, int adminUserID, int reviewerID, int employeeID, int taskID)
{
using (var db = new E2EWebPortalEntities())
{
return(db.sp_ResetCompletedTask(roleID, employerID, adminUserID, reviewerID, employeeID, taskID));
}
}
public int ActiveDeactiveEndClient(int EndClientID, int EmployerID, string Active)
{
using (var db = new E2EWebPortalEntities())
{
return(db.sp_ActiveDeactiveEndClient(EmployerID, EndClientID, Active));
}
}
public int ManageBusinessActivation(int EmployerID, string IsActive)
{
using (var db = new E2EWebPortalEntities())
{
return(db.sp_ManageBusinessActivation(IsActive, EmployerID));
}
}
public int DeleteReviewComments(int CommentID, int EmployerID)
{
using (var db = new E2EWebPortalEntities())
{
return(db.sp_DeleteReviewComments(EmployerID, CommentID));
}
}
public int UpdateTaskReview(TaskDetailsByWeekPeriodViewModal taskDetails)
{
using (var db = new E2EWebPortalEntities())
{
return(db.sp_UpdateTaskReview(taskDetails.EmployerID, taskDetails.ReviewerID, taskDetails.EmployeeID, taskDetails.TaskID, taskDetails.WeekPeriod, taskDetails.TaskSubmissionStatus, taskDetails.ReviewDate, taskDetails.ReviewerComments));
}
}
public int DeleteEndClient(int EndClientID, int EmployerID)
{
using (var db = new E2EWebPortalEntities())
{
return(db.sp_DeleteEndClient(EmployerID, EndClientID));
}
}
public List <string> GetWeekTaskCompleted(int employerID)
{
using (var db = new E2EWebPortalEntities())
{
return(db.sp_GetListWkPdTaskCompleted(employerID).ToList());
}
}
public Subscription GetSubscription(int EmployerId)
{
using (var db = new E2EWebPortalEntities())
{
return(db.Subscriptions.Where(s => s.EmployerId == EmployerId).FirstOrDefault());
}
}
public string SetResetCode(string userName)
{
string resetCode = string.Empty;
using (var db = new E2EWebPortalEntities())
{
var user = db.UserAccounts.Where(u => u.UserName == userName).FirstOrDefault();
if (user != null && user.UserAccountID != 0)
{
resetCode = Guid.NewGuid().ToString();
var userMIS = db.UserMIS.Where(u => u.UserId == user.UserAccountID).FirstOrDefault();
if (userMIS != null && userMIS.Id != 0)
{
userMIS.ResetCode = resetCode;
}
else
{
UserMI userMis = new UserMI {
UserId = user.UserAccountID, FailAttempts = 0, ResetCode = resetCode
};
}
db.SaveChanges();
return(resetCode);
}
else
{
return(resetCode);
}
}
}
public List <EndClientInfoViewModal> GetEndClientInfo(int employerID, int employeeID, int endClientID = -1)
{
using (var db = new E2EWebPortalEntities())
{
var endClients = db.sp_GetEndClientInfo(employerID, employeeID, endClientID).ToList();
return(Mapper.Map <List <sp_GetEndClientInfo_Result>, List <EndClientInfoViewModal> >(endClients));
}
}
public List <TaskDetailsByWeekPeriodViewModal> GetTaskDetailsByWeekPeriod(int roleID, int employerID, int reviewerID, int employeeID, string weekPeriod)
{
using (var db = new E2EWebPortalEntities())
{
var tasks = db.sp_GetTaskDetailsByWeekPeriod(roleID, employerID, reviewerID, employeeID, weekPeriod).ToList();
return(Mapper.Map <List <sp_GetTaskDetailsByWeekPeriod_Result>, List <TaskDetailsByWeekPeriodViewModal> >(tasks));
}
}
public List <PendReviewViewModal> GetListPendReview(int employerID, string PendPeriod)
{
using (var db = new E2EWebPortalEntities())
{
var pendSubmissionEE = db.sp_GetListPendReview(employerID, PendPeriod).ToList();
return(Mapper.Map <List <sp_GetListPendReview_Result>, List <PendReviewViewModal> >(pendSubmissionEE));
}
}
public TaskSubStatusSummaryViewModal GetTaskSubStatusSummary(int employerID)
{
using (var db = new E2EWebPortalEntities())
{
var taskSubStatusSummary = db.sp_GetTaskSubStatusSummary(employerID).FirstOrDefault();
return(Mapper.Map <sp_GetTaskSubStatusSummary_Result, TaskSubStatusSummaryViewModal>(taskSubStatusSummary));
}
}
public List <ClientSiteActivityReportViewModal> GetClientSiteActivity(int RoleID, int EmployerID, int AdminUserID, int UserID, DateTime StartDate, DateTime EndDate)
{
using (var db = new E2EWebPortalEntities())
{
var clientSiteActivities = db.rpt_ClientSiteActivity(RoleID, EmployerID, AdminUserID, UserID, StartDate, EndDate).ToList();
return(Mapper.Map <List <rpt_ClientSiteActivity_Result>, List <ClientSiteActivityReportViewModal> >(clientSiteActivities));
}
}
public List <BusinessViewModal> GetBusinessList()
{
using (var db = new E2EWebPortalEntities())
{
var businessList = db.sp_GetBusinessList().ToList();
return(Mapper.Map <List <sp_GetBusinessList_Result>, List <BusinessViewModal> >(businessList));
}
}
public List <BeneficiaryListReportViewModal> GetBeneficiaryList(int RoleID, int EmployerID)
{
using (var db = new E2EWebPortalEntities())
{
var beneficiaryList = db.rpt_GetBeneficiaryList(RoleID, EmployerID).ToList();
return(Mapper.Map <List <rpt_GetBeneficiaryList_Result>, List <BeneficiaryListReportViewModal> >(beneficiaryList));
}
}
public List <BeneficiaryDetailsReportViewModal> GetBeneficiaryDetails(int RoleID, int EmployerID, int UserID, int AdminUserID, DateTime StartDate, DateTime EndDate)
{
using (var db = new E2EWebPortalEntities())
{
var beneficiaryDetails = db.rpt_GetBeneficiaryDetails(RoleID, EmployerID, UserID, AdminUserID, StartDate, EndDate).ToList();
return(Mapper.Map <List <rpt_GetBeneficiaryDetails_Result>, List <BeneficiaryDetailsReportViewModal> >(beneficiaryDetails));
}
}
public List <TaskReviewCommentViewModal> GetAllReviewComments(int employerID, int commentID = -1)
{
using (var db = new E2EWebPortalEntities())
{
var endClients = db.sp_GetAllReviewComments(employerID, commentID).ToList();
return(Mapper.Map <List <sp_GetAllReviewComments_Result>, List <TaskReviewCommentViewModal> >(endClients));
}
}
public SubscriptionViewModal GetSubscriptionDetails(int EmployerId)
{
using (var db = new E2EWebPortalEntities())
{
var subscription = db.sp_GetSubscriptionDetails_AdminUser(EmployerId).FirstOrDefault();
return(Mapper.Map <sp_GetSubscriptionDetails_AdminUser_Result, SubscriptionViewModal>(subscription));
}
}
public bool ValidatePassword(string userName, string password)
{
password = EncryptionHelper.Encrypt(password);
using (var db = new E2EWebPortalEntities())
{
return(db.UserAccounts.Where(u => u.UserName == userName && u.Password == password).Any());
}
}
public List <WeekPeriodReportViewModal> GetListWeekPeriod(int EmployerID, int UserID, int RoleID, DateTime StartDate, DateTime EndDate)
{
using (var db = new E2EWebPortalEntities())
{
var clientSiteActivities = db.rpt_GetListWeekPeriod(EmployerID, UserID, RoleID, StartDate, EndDate).ToList();
return(Mapper.Map <List <rpt_GetListWeekPeriod_Result>, List <WeekPeriodReportViewModal> >(clientSiteActivities));
}
}
public EmployeeViewModal GetEmployeeByID(int EmployeeID)
{
using (var db = new E2EWebPortalEntities())
{
var employee = db.Employees.FirstOrDefault(e => e.EmployeeID == EmployeeID);
return(Mapper.Map <Employee, EmployeeViewModal>(employee));
}
}
