public void AddEmployeeValidTest()
{
var employeeDal = new EmployeeDal();
var employee = new Employee
{
FirstName = "TestEmployeeForTestingAdd",
LastName = "TestEmployeeForTesting",
Username = "******",
IsManager = false,
Password = "******"
};
employeeDal.AddEmployee(employee, "testpasswordforAddtesting");
var result = employeeDal.Authenticate(employee.Username, employee.Password);
Assert.AreEqual(1, result);
employeeDal.RemoveEmployee(employee.Username);
var resultAfterDelete = employeeDal.Authenticate(employee.Username, employee.Password);
this.cleanDataBase(employee);
Assert.AreEqual(0, resultAfterDelete);
}
public ActionResult OnGetUserInfo(string sessionId)
{
StatusReport sr = new StatusReport();
if (string.IsNullOrEmpty(sessionId))//如果sessionId为空，则返回错误信息
{
sr.status = "Fail";
sr.result = "sessionId不存在";
sr.parameters = sessionId;
return(Json(sr));
}
SessionBag sessionBag = null;
sessionBag = SessionContainer.GetSession(sessionId);
if (sessionBag == null)
{
sr.status = "Fail";
sr.result = "session已失效";
return(Json(sr));
}
string openId = sessionBag.OpenId;
sr = EmployeeDal.CheckOpenIdExist(openId);
//if (sr.data != null)
//{
// var o = JsonConvert.DeserializeObject(sr.data);
// return Json(new { status = "Success", result = "成功", data = o });
//}
//else
//{
return(Json(sr));
//}
}
public ActionResult OnBindUser(string userName, string password, string sessionId)
{
StatusReport sr = new StatusReport();
SessionBag sessionBag = null;
sessionBag = SessionContainer.GetSession(sessionId);
if (sessionBag == null)
{
sr.status = "Fail";
sr.result = "session已失效";
return(Json(sr));
}
string openId = sessionBag.OpenId;
//string openId = "oTTDy0KN71B2XLMXobrapvhqlHcY";
int id = EmployeeDal.CheckEmployeeExist(userName, password);
string temp = id > 0 ? "存在" : "不存在";
if (id > 0)
{
sr = EmployeeDal.BindEmployee(id, openId);
return(Json(sr));
}
else
{
var data = new
{
msg = "hello world",
username = userName,
password = password,
isExist = temp
};
return(Json(data));
}
}
public void AuthenticateEmployeeValidTest()
{
var employeeDal = new EmployeeDal();
var result = employeeDal.Authenticate("Username", "Password");
Assert.AreEqual(1, result);
}
/// <summary>
/// Método lógica de negocio para insertar un Cliente
/// </summary>
/// <param name="employee"></param>
public static void Insert(Employee employee)
{
OperationsLogs.WriteLogsDebug("ClienteBrl", "Insertar", string.Format("{0} Info: {1}",
DateTime.Now.ToString(),
"Empezando a ejecutar el método lógica de negocio para crear un Cliente"));
try
{
EmployeeDal.Insertar(employee);
}
catch (SqlException ex)
{
OperationsLogs.WriteLogsRelease("ClienteBrl", "Insertar", string.Format("{0} Error: {1}",
DateTime.Now.ToString(), ex.Message));
throw ex;
}
catch (Exception ex)
{
OperationsLogs.WriteLogsRelease("ClienteBrl", "Insertar", string.Format("{0} Error: {1}",
DateTime.Now.ToString(), ex.Message));
throw ex;
}
OperationsLogs.WriteLogsDebug("ClienteBrl", "Insertar", string.Format("{0} Info: {1}",
DateTime.Now.ToString(),
"Termino de ejecutar el método lógica de negocio para insertar Cliente"));
}
public IActionResult Post(EmployeeModel obj)
{
//Employee controller you will call validate
//create object of context
var context = new ValidationContext(obj, null, null);
//fill the error
var result = new List <ValidationResult>();
var isValid = Validator.TryValidateObject(obj, context, result, true);
if (result.Count == 0)
{
EmployeeDal dal = new EmployeeDal();
dal.Database.EnsureCreated(); //<--tblEmployee created
dal.Add(obj);
dal.SaveChanges(); //Physical commit
List <EmployeeModel> recs = dal.EmployeeModels.Include(emp => emp.addresses).ToList <EmployeeModel>();
return(StatusCode(200, recs)); //200
}
else
{
return(StatusCode(500, result));//500internal (error)
}
}
public void GetEmployeeHistoryValidTest()
{
var employeeDal = new EmployeeDal();
var result = employeeDal.GetEmployeeHistory(4);
Assert.AreEqual(0, result.Count);
}
public void AddAsync_EntityDoesNotAlreadyExist_ReturnsEntity()
{
var firstEntity = new Employee
{
Id = 1,
};
var secondEntity = new Employee
{
Id = 2,
};
var data = new List <Employee>
{
firstEntity
};
var mockSet = data.AsQueryable().BuildMockDbSet();
var mockDbContext = Substitute.For <IDatabaseContext>();
mockDbContext.Set <Employee>().Returns(mockSet);
var mockLogger = Substitute.For <ILogger <EmployeeDal> >();
var dal = new EmployeeDal(mockDbContext, mockLogger);
var result = Task.Run(async() => await dal.AddAsync(secondEntity)).GetAwaiter().GetResult();
Assert.That(result, Is.EqualTo(secondEntity));
}
public ActionResult OnGetUserInfoTest(string openid)
{
StatusReport sr = new StatusReport();
sr = EmployeeDal.CheckOpenIdExist(openid);
return(Json(sr));
}
/// <summary>
/// 角色管理页面
/// </summary>
/// <returns></returns>
public ActionResult RoleManage()
{
//删除角色
//接收角色id
if (Request["num"] != null)
{
int id = Convert.ToInt32(Request["num"]);
//根据角色id查询“员工角色表”此角色有无员工担当
Employee_RoleInfo er = dal.GetEmployee_RoleInfoByRoleID(id);
if (er != null)
{
return(Content("0"));
}
else
{
//根据角色id删除角色
bool isDel = dal.DelRoleByRoleID(id);
if (isDel)
{
return(Content("1"));
}
}
}
//查询所有员工
EmployeeDal emdal = new EmployeeDal();
List <EmployeeInfo> emlist = emdal.GetAllEmployeer();
//查询所有权限（查询菜单栏）
PermissionDal pd = new PermissionDal();
List <PermissionInfo> perslist = pd.GetAll();
//查询所有角色
List <RoleInfo> roles = dal.GetRoles();
ViewBag.emlist = emlist;
ViewBag.roles = roles;
int? RoleID = Convert.ToInt32(Request["RoleID"]);
string RoleName = Request["RoleName"];
if (RoleName != null)
{
Session["RoleName"] = RoleName;
}
if (RoleID != 0)
{
Session["RoleID"] = RoleID;
List <RoleInfo_PermissionInfo> persByRoID = dal.GetPerByRoleID(RoleID);
List <PermissionInfo> NotPerByRoId = dal.GetNotPerByRoId(RoleID);
ViewBag.persByRoID = persByRoID;
ViewBag.NotPerByRoId = NotPerByRoId;
ViewBag.perslist = perslist;
}
return(View());
}
public ActionResult getEmployees() // JSON collection
{
EmployeeDal dal = new EmployeeDal();
List <Employee> Employeescoll = dal.Employees.ToList <Employee>();
Thread.Sleep(10000);
return(Json(Employeescoll, JsonRequestBehavior.AllowGet));
}
public MainWindow()
{
InitializeComponent();
Model db = new Model();
eDal = new EmployeeDal(db);
}
/// <summary>
/// 工资页面
/// </summary>
/// <returns></returns>
public ActionResult Paylist()
{
//查询所有员工
EmployeeDal edal = new EmployeeDal();
List <EmployeeInfo> emlist = edal.GetAllEmployeer();
ViewBag.allem = emlist;
//查询所有员工工资
List <Payroll> allPays = edal.GetPayrolls();
ViewBag.allPays = allPays;
//接收员工id
int id = Convert.ToInt32(Request["id"]);
if (id != 0)
{
List <SalaryRecord> srlist = dal.GetByID(id);
//循环遍历查询‘发放时间’有无与正在发送的时间相同
string ispay = "";
//查询该员工在这月有无发送工资
foreach (var item in srlist)
{
DateTime paytime = (DateTime)item.PayTime;
if (paytime.Year == DateTime.Now.Year && paytime.Month == DateTime.Now.Month)
{
ispay = "已支付";
return(Content("1"));
}
}
//添加工资发送记录
if (ispay == "")
{
//获取该员工的总工资
int salary = Convert.ToInt32(Request["salary"]);
bool isAdd = false;
//增加工资记录
if (id != 0)
{
SalaryRecord sr = new SalaryRecord();
sr.EmployeeId = id;
sr.TotalSalary = salary;
sr.PayTime = DateTime.Now;
//增加发放工资记录
isAdd = dal.AddPayRecord(sr);
if (isAdd)
{
return(Content("0"));
}
}
}
}
return(View());
}
public void AddAsync_NullEntity_ThrowsArgumentNullException()
{
var mockDbContext = Substitute.For <IDatabaseContext>();
var mockLogger = Substitute.For <ILogger <EmployeeDal> >();
var dal = new EmployeeDal(mockDbContext, mockLogger);
var e = Assert.Throws <ArgumentNullException>(() => dal.AddAsync(null).GetAwaiter().GetResult());
Assert.That(e.Message, Does.Contain("entity"));
}
public IActionResult Get(/*[FormBody]or[FromForm]*/ string employeeName)
{
EmployeeDal dal = new EmployeeDal();
List <EmployeeModel> search = (from temp in dal.EmployeeModels
where temp.name == employeeName
select temp)
.ToList <EmployeeModel>();
return(Ok(search));
}
public void Filter_PredicateIsNull_ThrowsArgumentNullException()
{
var mockDbContext = Substitute.For <IDatabaseContext>();
var mockLogger = Substitute.For <ILogger <EmployeeDal> >();
var dal = new EmployeeDal(mockDbContext, mockLogger);
var e = Assert.Throws <ArgumentNullException>(() => dal.Filter(null));
Assert.That(e.Message, Does.Contain("predicate"));
}
public void GetEmployeesValidTest()
{
var employeeDal = new EmployeeDal();
var currentEmployee = new Employee {
Username = "******"
};
var result = employeeDal.GetEmployees(currentEmployee);
Assert.AreEqual(4, result.Count);
}
public void GetCurrentUserValidTest()
{
var employeeDal = new EmployeeDal();
var result = employeeDal.GetCurrentUser("Username", "Password");
Assert.AreEqual("Username", result.Username);
Assert.AreEqual("EmployeeFirst", result.FirstName);
Assert.IsFalse(result.IsManager);
}
public IActionResult Search(string employeeName)
{
EmployeeDal dal = new EmployeeDal();
List <EmployeeModel> search = (from temp in dal.EmployeeModels
where temp.name == employeeName
select temp)
.ToList <EmployeeModel>();
return(Ok(search));
}
public static async Task <IEnumerable <EmployeeDto> > GetEmployees()
{
var employees = await EmployeeDal.GetEmployees();
var employeesDto = new List <EmployeeDto>();
foreach (var employee in employees)
{
employeesDto.Add(EmployeesFactory.GetEmployee(employee));
}
return(employeesDto);
}
/// <summary>
/// 发送邮件页面(发件箱)
/// </summary>
/// <returns></returns>
public ActionResult SendEmail()
{
Model.EmployeeInfo em = (Model.EmployeeInfo)Session["Employeer"];
//查询所有员工
EmployeeDal edal = new EmployeeDal();
List <EmployeeInfo> emlist = edal.GetAllEmployeerElse(em.ID);
ViewBag.allem = emlist;
GetNewEmail();//刷新邮件数量
return(View());
}
//check if the id number exist in the employee table.
public Boolean ChechIDS(string id)
{
EmployeeDal dal = new EmployeeDal();
List <Employee> LE = (from x in dal.Employees
where x.ID.ToString() == id
select x).ToList <Employee>();
if (LE.Count == 0)
{
return(true);
}
return(false);
}
public ActionResult SearchEmployee()
{
EmployeeViewModel obj = new EmployeeViewModel();
EmployeeDal dal = new EmployeeDal();
string str = Request.Form["txtEmployeeName"].ToString();
List <Employee> Employeescoll
= (from x in dal.Employees
where x.EmployeeName == str
select x).ToList <Employee>();
obj.Employees = Employeescoll;
return(View("SearchEmployee", obj));
}
public static bool ChangePassword(int uid, string oldpwd, string newpwd)
{
bool retValue = false;
using (MySqlConnection conn = DBUtility.OpenConnection())
{
if (EmployeeDal.CheckPwd(uid, oldpwd, conn))
{
retValue = EmployeeDal.UpdatePwd(uid, newpwd, conn) > 0;
}
}
return(true);
}
public ActionResult OnCheckPassword(string userId, string password)
{
StatusReport sr = new StatusReport();
if (string.IsNullOrEmpty(userId) || string.IsNullOrEmpty(password))
{
sr.status = "Fail";
sr.result = "信息不完整";
return(Json(sr));
}
sr = EmployeeDal.CheckPassword(userId, password);
return(Json(sr));
}
/// <summary>
/// 考勤管理页面
/// </summary>
/// <returns></returns>
public ActionResult TimeManage()
{
//接收所有员工信息
EmployeeDal emdal = new EmployeeDal();
List <EmployeeInfo> elist = emdal.GetAllEmployeer();
ViewBag.alluser = elist;
//查询所有考勤记录
List <TimeSheet> rslist = dal.GetTimeSheets();
ViewBag.allts = rslist;
return(View());
}
public static async Task <IEnumerable <EmployeeDto> > GetEmployee(int id)
{
var employees = await EmployeeDal.GetEmployees();
Employee employee = employees.FirstOrDefault(emp => emp.Id == id);
if (employee == null)
{
return new EmployeeDto[] { }
}
;
return(new EmployeeDto[] { EmployeesFactory.GetEmployee(employee) });
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
////保存修改到数据库
EmployeeDal employeeDal = new EmployeeDal();
if (ViewState["OP"].ToString() == "ADD")
{
employeeDal.Insert(txtEmployeeCode.Text, txtEmployeeName.Text, txtDepartmentID.Text, ddlStatus.SelectedValue, txtRemark.Text);
}
else
{
employeeDal.Save(txtEmployeeCode.Text, txtEmployeeName.Text, txtDepartmentID.Text, ddlStatus.SelectedValue, txtRemark.Text);
}
JScript.Instance.ShowMessage(UpdatePanel1, "保存数据成功。");
}
private void BindData()
{
pager.PageSize = PagingSize;
EmployeeDal employeeDal = new EmployeeDal();
string filter = null;
if (ViewState["Filter"] != null)
filter = ViewState["Filter"].ToString();
pager.RecordCount = employeeDal.GetCount(filter);
DataTable table = employeeDal.GetAll(pageIndex, PagingSize, filter);
BindTable2GridView(gvMain, table);
}
public DataSet EmployeeAndDetails(int Empid)
{
EmployeeDal employeeDal = new EmployeeDal();
var dataTable1 = employeeDal.GetEmployee(Empid);
DetailsDal detailsDal = new DetailsDal();
var Det = detailsDal.GetDetails(Empid);
DataSet dataSet = new DataSet();
dataSet.Tables.Add(dataTable1);
dataSet.Tables.Add(Det);
return(dataSet);
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
////保存修改到数据库
EmployeeDal employeeDal = new EmployeeDal();
if (ViewState["OP"].ToString() == "ADD")
{
employeeDal.Insert(txtEmployeeCode.Text, txtEmployeeName.Text, txtDepartmentID.Text, ddlStatus.SelectedValue, txtRemark.Text);
}
else
{
employeeDal.Save(txtEmployeeCode.Text, txtEmployeeName.Text, txtDepartmentID.Text, ddlStatus.SelectedValue, txtRemark.Text);
}
JScript.Instance.ShowMessage(UpdatePanel1, "保存数据成功。");
}
/// <summary>
/// 权限管理页面
/// </summary>
/// <returns></returns>
public ActionResult PermissionManage()
{
//查询所有员工
EmployeeDal emdal = new EmployeeDal();
List <EmployeeInfo> emlist = emdal.GetAllEmployeer();
ViewBag.emlist = emlist;
//查询所有权限（查询菜单栏）
PermissionDal pd = new PermissionDal();
List <PermissionInfo> all = pd.GetAll();
ViewBag.all = all;
return(View());
}
protected void btnDelete_Click(object sender, EventArgs e)
{
EmployeeDal employeeDal = new EmployeeDal();
int deleteCount = 0;
foreach (GridViewRow row in gvMain.Rows)
{
if (row.Cells[0].Controls.Count != 0 && ((CheckBox)row.Cells[0].Controls[0]).Checked)
{
employeeDal.Delete(row.Cells[2].Text);
deleteCount++;
}
}
if (deleteCount == 0)
JScript.Instance.ShowMessage(UpdatePanel1, "请选择要删除的记录。");
else
JScript.Instance.ShowMessage(UpdatePanel1, "删除数据成功。");
BindData();
}
