public virtual void SetUp()
{
var options = new DbContextOptionsBuilder <EmployeeDetailsContext>()
.UseInMemoryDatabase(Guid.NewGuid().ToString())
.Options;
context = new EmployeeDetailsContext(options);
uow = new EmployeeUnitOfWork(context);
logger = new Mock <ILogger <EmployeeController> >();
mockUow = new Mock <IEmployeeUnitOfWork>();
mockUow.Setup(m => m.EmployeeRepository).Returns(uow.EmployeeRepository);
mockUow.Setup(m => m.TypeDiscountRulesRepository).Returns(uow.TypeDiscountRulesRepository);
mockUow.Setup(m => m.TypePayrollDetailsRepository).Returns(uow.TypePayrollDetailsRepository);
sut = new EmployeeController(logger.Object, mockUow.Object);
uow.TypeDiscountRulesRepository.Add(new TypeDiscountRules()
{
discount_type_id = 1,
discount_rule = "A",
discount = 0.1M
});
uow.TypePayrollDetailsRepository.Add(new TypePayrollDetails()
{
payroll_type_id = 1,
yearly_paychecks = 20,
salary_per_paycheck = 1000,
employee_yearly_deductions = 500,
dependent_yearly_deductions = 200
});
uow.Save();
}
public ActionResult Index()
{
//using (var context = new EmployeeDetailsContext())
//{
// List<EmployeeDetails> Employeelist = context.EmployeeDetails.ToList();
// List<District> District1 = context.districts.ToList();
// List<SubDivision> SubDivision1 = context.SubDivisions.ToList();
// return View(Employeelist);
//}
EmployeeDetailsContext entities = new EmployeeDetailsContext();
DM_DashboardModel dmModel = new DM_DashboardModel();
foreach (var district in entities.districts)
{
dmModel.District.Add(new SelectListItem {
Text = district.DistName, Value = district.DistId.ToString()
});
}
return(View(dmModel));
//return View();
}
public HttpResponseMessage GetFiles()
{
EmployeeDetailsContext entities = new EmployeeDetailsContext();
var files = from file in entities.FileModal
select new { id = file.Id, Name = file.FileName };
return(Request.CreateResponse(HttpStatusCode.OK, files));
}
// GET: Default1
public ActionResult Index()
{
List <EmployeeDetails> Employeelist;
using (var context = new EmployeeDetailsContext())
{
Employeelist = context.EmployeeDetails.ToList();
}
return(View(Employeelist));
}
public ActionResult UserDashBoardIndex()
{
UserAssignedTask taskmodle = new UserAssignedTask();
List <UserAssignedTask> taskmodleList = new List <UserAssignedTask>();
//dynamic taskmodle = new UserAssignedTask();
TaskModels taskmodle1 = new TaskModels();
EmployeeDetailsContext _db = new EmployeeDetailsContext();
// int fileId=_db.
ApplicationUser user = System.Web.HttpContext.Current.GetOwinContext().GetUserManager <ApplicationUserManager>().FindById(System.Web.HttpContext.Current.User.Identity.GetUserId());
var UserGuid = user.Id;
var adminRoleID = Guid.Parse(user.Id);
// taskmodle = _db.UserAssignedTask.Where(c => c.LogedInUserGuid.Equals(user.Id)).SingleOrDefault();
taskmodle = _db.UserAssignedTask.Where(c => c.LogedInUserGuid == adminRoleID).FirstOrDefault();
int taskid = taskmodle.TaskId;
string loggedInUserName = taskmodle.UserName;
taskmodleList = _db.UserAssignedTask.Where(c => c.UserName == loggedInUserName).ToList();
ViewBag.FileId = taskmodle1.FileId;
return(View(taskmodle));
}
public JsonResult UserDashBoardIndex1()
{
UserAssignedTask taskmodle = new UserAssignedTask();
List <UserAssignedTask> taskmodleList = new List <UserAssignedTask>();
//dynamic taskmodle = new UserAssignedTask();
TaskModels taskmodle1 = new TaskModels();
EmployeeDetailsContext _db = new EmployeeDetailsContext();
// int fileId=_db.
ApplicationUser user = System.Web.HttpContext.Current.GetOwinContext().GetUserManager <ApplicationUserManager>().FindById(System.Web.HttpContext.Current.User.Identity.GetUserId());
var UserGuid = user.Id;
var adminRoleID = Guid.Parse(user.Id);
// taskmodle = _db.UserAssignedTask.Where(c => c.LogedInUserGuid.Equals(user.Id)).SingleOrDefault();
taskmodle = _db.UserAssignedTask.Where(c => c.LogedInUserGuid == adminRoleID).FirstOrDefault();
int taskid = taskmodle.TaskId;
string loggedInUserName = taskmodle.UserName;
taskmodleList = _db.UserAssignedTask.Where(c => c.UserName == loggedInUserName).ToList();
int taskid1 = 0;
int fileId1;
foreach (var c in taskmodleList)
{
taskid1 = c.TaskId;
var query = from st in _db.Task
where st.FileId == taskid1
select st.FileId;
//var student = query.SingleOrDefault<TaskModels>();
c.FileID = query.FirstOrDefault();
// fileId1 = _db.Task.Where(s => s.FileId == taskid1).FirstOrDefault();
}
ViewBag.FileId = taskmodle1.FileId;
return(Json(taskmodleList, JsonRequestBehavior.AllowGet));
//return View(taskmodle);
}
public ActionResult Index(int?districtId, int?subDivisionId)
{
DM_DashboardModel dmModel = new DM_DashboardModel();
EmployeeDetailsContext entities = new EmployeeDetailsContext();
foreach (var district in entities.districts)
{
dmModel.District.Add(new SelectListItem {
Text = district.DistName, Value = district.DistId.ToString()
});
}
if (districtId.HasValue)
{
var subDivisions = (from subDivision in entities.SubDivisions
where subDivision.DistrictId == districtId.Value
select subDivision).ToList();
foreach (var district in subDivisions)
{
dmModel.SubDivision.Add(new SelectListItem {
Text = district.SubDivName, Value = district.SubDivId.ToString()
});
}
//if (stateId.HasValue)
//{
// var cities = (from city in entities.Cities
// where city.StateId == stateId.Value
// select city).ToList();
// foreach (var city in cities)
// {
// model.Cities.Add(new SelectListItem { Text = city.CityName, Value = city.CityId.ToString() });
// }
//}
}
return(View(dmModel));
}
public EmployeeDetailsController(EmployeeDetailsContext context)
{
_context = context;
}
