public int DeleteEMPData(EmployeeInfo EmpInfo,string userID) { int flag=0; SqlConnection sqlCon = new SqlConnection(conStr); SqlCommand sqlCmd = new SqlCommand("sp_delete_EmployeeInfo", sqlCon); sqlCmd.CommandType = CommandType.StoredProcedure; SqlParameter sp_empID = sqlCmd.Parameters.Add("@EMP_ID", SqlDbType.Int); sp_empID.Value = EmpInfo.EMPID; SqlParameter pUserID = sqlCmd.Parameters.Add("@UserID", SqlDbType.VarChar, 20); pUserID.Value = userID; try { sqlCon.Open(); sqlCmd.ExecuteNonQuery(); flag = 1; } catch (Exception ex) { objNLog.Error("Exception : " + ex.Message); } finally { sqlCon.Close(); } return flag; }
public void CalculatePayslip_ShouldReturnPayslip() { // Arrange EmployeeInfo employeeInfo = new EmployeeInfo { FirstName = "David", LastName = "Rudd", AnnualSalary = 60050, SuperRate = 0.09M, PaymentStartDate = "01 March – 31 March", }; // Act Payslip actual = this.employeeIncomeService.CalculatePayslip(employeeInfo); // Assert Payslip expected = new Payslip { Name = "David Rudd", PayPeriod = "01 March – 31 March", GrossIncome = 5004, IncomeTax = 922, NetIncome = 4082, Super = 450 }; actual.ShouldBeEquivalentTo(expected); }
private void CheckAnnualSalary(EmployeeInfo employeeInfo) { if (employeeInfo.AnnualSalary < 0) { throw new OverflowException(); } }
private void EmailEveryone(MonthlyValidationReminderRecords records) { EmployeeInfo e = new EmployeeInfo(); Employees userList = e.GetAllUserEmails(); foreach (Employee user in userList) { string email = user.Email; StringBuilder emailBuilder = new StringBuilder(); string templatePath = HttpContext.Current.Server.MapPath(AppConfiguration.Current.MonthlyValidationReminder); string templateText = File.ReadAllText(templatePath); DotLiquid.Template.RegisterSafeType(typeof(MonthlyValidationReminderRecord), new string[] { "FacilityName", "EmmittingAssetName", "UnitOfMeasure", "ValidationPeriod", "EmissionVolume", "FormattedVolume" }); Template template = Template.Parse(templateText); string date = DateTime.Now.AddMonths(-1).ToString("MMMM yyyy"); string html = template.Render(Hash.FromAnonymousObject(new { Date = date, SystemAdmin = config.SystemAdmin, Kickouts = records })); if (email != null) SendEmail(html, config.MonthyValidationReminderSubject, config.SystemAdmin, email); else EmailTechnicalError("Could not send kickout report to: " + user); } }
/// <summary> /// Adds the item. /// </summary> public void AddItem() { var employeeInfo = new EmployeeInfo(); if (employeeInfo.ShowDialog() == true & employeeInfo.CurrentEmployee != null) { var employee = employeeInfo.CurrentEmployee; Employees.Add(employeeInfo.CurrentEmployee); } }
public async Task<ActionResult> Edit(int id,EmployeeInfo Emp) { HttpResponseMessage responseMessage = await client.PutAsJsonAsync(url+"/" +id, Emp); if (responseMessage.IsSuccessStatusCode) { return RedirectToAction("Index"); } return RedirectToAction("Error"); }
/// <summary> /// Edits selected item. /// </summary> public void EditItem() { if (MainDataGrid.SelectedIndex >= 0) { Employee employee = MainDataGrid.SelectedItem as Employee; var employeeInfo = new EmployeeInfo(); employeeInfo.DataContext = employee; employeeInfo.ShowDialog(); } }
public void SaveEmployee(EmployeeInfo employeeInfo) { if (employeeInfo == null) return; var employee = (Employee) employeeInfo; var empFact = employee.GetFactory(); empFact.Persist(employee); }
public bool AddEmployee(EmployeeInfo.Employee emp) { if (emp == null) { return false; } else { EmployeeInfo.Employee.DefaultEmployees.Add(emp); return true; } }
public Result<EmployeeInfo> Get() { View.Run(); EmployeeInfo info = null; if (ServiceResult == ServiceResult.Ok) { info = new EmployeeInfo { FirstName = FirstName, LastName = LastName, Email = Email }; } Result<EmployeeInfo> result = new Result<EmployeeInfo>(ServiceResult, info); return result; }
public Payslip CalculatePayslip(EmployeeInfo employeeInfo) { this.CheckSuperRate(employeeInfo); this.CheckAnnualSalary(employeeInfo); Payslip payslip = new Payslip(); this.CalcName(employeeInfo, payslip); this.CalcPayPeriod(employeeInfo, payslip); this.CalcGrossIncome(employeeInfo, payslip); this.CalcIncomeTax(employeeInfo, payslip); this.CalcNetIncome(payslip); this.CalcSuper(employeeInfo, payslip); return payslip; }
public bool ModifyEmployees(EmployeeInfo.Employee emp) { if (emp == null) { return false; } else { for (int i = 0; i < EmployeeInfo.Employee.DefaultEmployees.Count; i++) { if (EmployeeInfo.Employee.DefaultEmployees[i].Id == emp.Id) { EmployeeInfo.Employee.DefaultEmployees[i] = emp; } } return true; } }
// ***************************************************************************** // Returns the list of all employees public EmployeeInfo GetEmployeeDetails(int empID) { // Get details about the specified employee SqlDataAdapter adapter = new SqlDataAdapter( String.Format(EmployeeCommandList.cmdEmployeeDetails, empID), ConfigurationManager.ConnectionStrings["J2EENorthwind"].ConnectionString); DataTable table = new DataTable(); adapter.Fill(table); // Execute the command and populate the return buffer DataRow row = table.Rows[0]; EmployeeInfo info = new EmployeeInfo(); info.ID = empID; info.FirstName = row["firstname"].ToString(); info.LastName = row["lastname"].ToString(); info.Title = row["title"].ToString(); info.Country = row["country"].ToString(); info.Notes = row["notes"].ToString(); return info; }
public DataTable GetEMPData(EmployeeInfo EmpInfo) { SqlConnection sqlCon = new SqlConnection(conStr); SqlCommand sqlCmd = new SqlCommand("sp_getEmployeeInfo", sqlCon); sqlCmd.CommandType = CommandType.StoredProcedure; SqlParameter sp_empID = sqlCmd.Parameters.Add("@EMP_ID", SqlDbType.Int); sp_empID.Value = EmpInfo.EMPID; SqlDataAdapter sqlDa = new SqlDataAdapter(sqlCmd); DataSet dsemp = new DataSet(); try { sqlDa.Fill(dsemp, "Details"); } catch (Exception ex) { objNLog.Error("Exception : " + ex.Message); } return dsemp.Tables["Details"]; }
public void CalculatePayslip_ShouldNOTThrowOverflowException_WhenAnnualSalaryIsIntMaxAndSuperRateIsGreaterThan50OrLessThan0(decimal superRate) { // Arrange EmployeeInfo employeeInfo = new EmployeeInfo { FirstName = "David", LastName = "Rudd", AnnualSalary = int.MaxValue, SuperRate = superRate, PaymentStartDate = "01 March – 31 March", }; // Act Action action = () => { this.employeeIncomeService.CalculatePayslip(employeeInfo); }; // Assert action.ShouldNotThrow<OverflowException>(); }
public void InitClass() { EmployeeInfo info = MockRepository.Mock <EmployeeInfo>("ID001"); Assert.NotNull(info); }
// // GET: /Base/ //public ActionResult Index() //{ // return View(); //} // // 摘要: // 在调用操作方法前调用。 // // 参数: // filterContext: // 有关当前请求和操作的信息。 protected override void OnActionExecuting(ActionExecutingContext filterContext) { //接收登陆的用户名 EmployeeInfo em = filterContext.HttpContext.Session["Employeer"] as EmployeeInfo; /*收件箱 GetEmailMessages HaverID,IsDel=0,IsRead=0*/ EmailDal dalem = new EmailDal(); if (em != null) { List <GetEmailMessages> get = dalem.GetHaverEmail(em.ID, 0, 0); Session["list"] = get; Session["HaveNum"] = get.Count; } else { RedirectToAction("/login/login"); } /*地址栏可输入跳转!!!*/ /*-----------------------------------锁屏开始------------------------------------------*/ //拿到控制器名称 string controllerName = filterContext.RouteData.Values["controller"].ToString(); //拿到视图名称 string actionName = filterContext.RouteData.Values["action"].ToString(); //全路径 string url = Request.Url.ToString(); http://localhost:1224/home/main/1 //虚拟路径 string url = Request.Path; /home/main/1 string url = Request.Path; //判断是否锁屏 if (controllerName == "home" && actionName == "lock") { Session["isLock"] = "true"; } if (Session["isLock"] != null && Session["isLock"] == "true") { if (url == "/home/main/" + em.LoginPassword) { filterContext.RouteData.Values["controller"] = "home"; filterContext.RouteData.Values["action"] = "main"; Session["isLock"] = "false"; } else { filterContext.RouteData.Values["controller"] = "home"; filterContext.RouteData.Values["action"] = "lock"; } } /*-----------------------------------锁屏结束------------------------------------------*/ //登陆失败跳转到登陆页面 if (em == null) { filterContext.Result = new RedirectResult("/login/login"); } else { EmployeeDal dal = new EmployeeDal(); RoleInfo r = dal.GetRoleByEmployeeID(em.ID); int roleID = r.ID; //获取角色ID List <PermissionInfo> alllist = dal.GetAllPermissions(); //查询所有菜单栏 //判断用户有无角色 if (r != null) { ViewBag.roleName = r.RoleName; if (roleID == 1) { ViewBag.list = alllist; } else { /* * 根据员工id 查询该员工的所有权限(角色权限+个人权限) */ List <PermissionInfo> allpers = dal.GetPers(em.ID); ViewBag.allpers = allpers; } } } }
public int update_EmpInfo(EmployeeInfo EmpInfo,string userID) { int flag = 0; SqlConnection sqlCon = new SqlConnection(conStr); SqlCommand sqlCmd = new SqlCommand("sp_update_MEmployee", sqlCon); sqlCmd.CommandType = CommandType.StoredProcedure; SqlParameter sp_empID = sqlCmd.Parameters.Add("@Emp_ID", SqlDbType.Int); sp_empID.Value = EmpInfo.EMPID; SqlParameter Emp_FName = sqlCmd.Parameters.Add("@Emp_FName", SqlDbType.VarChar, 25); Emp_FName.Value = EmpInfo.EMPFName; SqlParameter Emp_MName = sqlCmd.Parameters.Add("@Emp_MName", SqlDbType.VarChar, 15); Emp_MName.Value = EmpInfo.EMPMName; SqlParameter Emp_LName = sqlCmd.Parameters.Add("@Emp_LName", SqlDbType.VarChar, 25); Emp_LName.Value = EmpInfo.EMPLName; SqlParameter Emp_Address1 = sqlCmd.Parameters.Add("@Emp_Address", SqlDbType.VarChar, 50); Emp_Address1.Value = EmpInfo.Address1; SqlParameter Emp_Address2 = sqlCmd.Parameters.Add("@Emp_Address2", SqlDbType.VarChar, 50); Emp_Address2.Value = EmpInfo.Address2; SqlParameter Emp_City = sqlCmd.Parameters.Add("@Emp_City", SqlDbType.VarChar, 50); Emp_City.Value = EmpInfo.City; SqlParameter Emp_State = sqlCmd.Parameters.Add("@Emp_State", SqlDbType.VarChar, 50); Emp_State.Value = EmpInfo.State; SqlParameter Emp_Zip = sqlCmd.Parameters.Add("@Emp_Zip", SqlDbType.VarChar, 10); Emp_Zip.Value = EmpInfo.ZIP; SqlParameter Emp_Phone = sqlCmd.Parameters.Add("@Emp_Phone", SqlDbType.VarChar, 12); Emp_Phone.Value = EmpInfo.Phone; SqlParameter Emp_HomePhone = sqlCmd.Parameters.Add("@Emp_HomePhone", SqlDbType.VarChar, 12); Emp_HomePhone.Value = EmpInfo.Pat_CellPhone; //@Emp_Email SqlParameter Emp_Email = sqlCmd.Parameters.Add("@Emp_Email", SqlDbType.VarChar, 50); Emp_Email.Value = EmpInfo.EMail; //@Emp_HireDate SqlParameter Emp_HireDate = sqlCmd.Parameters.Add("@Emp_HireDate", SqlDbType.Date); Emp_HireDate.Value = EmpInfo.EMPHireDate.ToShortDateString(); SqlParameter Emp_TermDate = sqlCmd.Parameters.Add("@Emp_TermDate", SqlDbType.Date); Emp_TermDate.Value = EmpInfo.EMPTermDate.ToShortDateString(); SqlParameter Emp_Sup1 = sqlCmd.Parameters.Add("@Emp_Sup1", SqlDbType.Int); if (EmpInfo.EMPSup1 != 0) Emp_Sup1.Value = EmpInfo.EMPSup1; SqlParameter Emp_Sup2 = sqlCmd.Parameters.Add("@Emp_Sup2", SqlDbType.Int); if (EmpInfo.EMPSup2 != 0) Emp_Sup2.Value = EmpInfo.EMPSup2; SqlParameter Emp_LocID = sqlCmd.Parameters.Add("@Emp_LocID", SqlDbType.Int); if (EmpInfo.LocationID != 0) { Emp_LocID.Value = EmpInfo.LocationID; } else Emp_LocID.Value = Convert.DBNull; SqlParameter Emp_TitleID = sqlCmd.Parameters.Add("@Emp_TitleID", SqlDbType.Int); if (EmpInfo.TitleID != 0) { Emp_TitleID.Value = EmpInfo.TitleID; } else Emp_TitleID.Value = Convert.DBNull; //@Emp_Role SqlParameter Emp_Role = sqlCmd.Parameters.Add("@Emp_Role", SqlDbType.VarChar, 10); Emp_Role.Value = EmpInfo.Role; SqlParameter Isapprov = sqlCmd.Parameters.Add("@Isapprov", SqlDbType.Char, 1); Isapprov.Value = EmpInfo.IsApprove; SqlParameter Emp_Status = sqlCmd.Parameters.Add("@Emp_Status", SqlDbType.Char, 1); Emp_Status.Value = EmpInfo.Status; SqlParameter Emp_Comments = sqlCmd.Parameters.Add("@Emp_Comments", SqlDbType.Char, 255); Emp_Comments.Value = EmpInfo.Comments; SqlParameter pUserID = sqlCmd.Parameters.Add("@UserID", SqlDbType.VarChar, 20); pUserID.Value = userID; try { sqlCon.Open(); sqlCmd.ExecuteNonQuery(); flag = 1; } catch (Exception ex) { objNLog.Error("Exception : " + ex.Message); } finally { sqlCon.Close(); } return flag; }
public void CalculatePayslip_ShouldReturnPayslip_WhenAnnualSalaryIsIntMaxAndSuperRateIs50() { // Arrange EmployeeInfo employeeInfo = new EmployeeInfo { FirstName = "David", LastName = "Rudd", AnnualSalary = int.MaxValue, SuperRate = 0.5M, PaymentStartDate = "01 March – 31 March", }; // Act Payslip actual = this.employeeIncomeService.CalculatePayslip(employeeInfo); // Assert Payslip expected = new Payslip { Name = "David Rudd", PayPeriod = "01 March – 31 March", GrossIncome = 178956970, IncomeTax = 80528432, NetIncome = 98428538, Super = 89478485 }; actual.ShouldBeEquivalentTo(expected); }
public static void deleteEmployeeInfo(EmployeeInfo EmployeeInfoObj) { EmployeeInfoDBMapper dbm = new EmployeeInfoDBMapper(); dbm.delete(EmployeeInfoObj); }
protected void PageInit() { int dsid = Convert.ToInt32(Request["DriverScoreId"].ToString()); DriverScoreInfo ds = new DriverScoreInfo(dsid); EmployeeInfo em = new EmployeeInfo(Convert.ToInt32(ds.EmployeeId)); lblName.Text = em.EmployeeName.ToString(); PositionInfo position = new PositionInfo(Convert.ToInt32(em.PositionId)); lblPosition.Text = position.PositionName.ToString(); DepartInfo depart = new DepartInfo(Convert.ToInt32(em.DepartId)); lblDepart.Text = depart.DepartName.ToString(); //ddlYear.SelectedValue=ds.YearId.ToString(); //ddlMonth.SelectedValue=ds.MonthId.ToString(); YearInfo year = new YearInfo(Convert.ToInt32(ds.YearId)); MonthInfo month = new MonthInfo(Convert.ToInt32(ds.MonthId)); lblDate.Text = year.YearName + "Äê" + month.MonthNames + "ÔÂ"; lblSelfds1.Text = ds.Selfds1.ToString(); lblSelfds2.Text = ds.Selfds2.ToString(); lblSelfds3.Text = ds.Selfds3.ToString(); lblSelfds4.Text = ds.Selfds4.ToString(); lblSelfds5.Text = ds.Selfds5.ToString(); lblSelfds6.Text = ds.Selfds6.ToString(); lblSelfds7.Text = ds.Selfds7.ToString(); lblSelfds8.Text = ds.Selfds8.ToString(); lblSelfds9.Text = ds.Selfds9.ToString(); lblSelfds10.Text = ds.Selfds10.ToString(); lblSelfds11.Text = ds.Selfds11.ToString(); lblSelfds12.Text = ds.Selfds12.ToString(); lblSelfds13.Text = ds.Selfds13.ToString(); lblSelfds14.Text = ds.Selfds14.ToString(); lblSelfds15.Text = ds.Selfds15.ToString(); lblSelfds16.Text = ds.Selfds16.ToString(); lblSelfds17.Text = ds.Selfds17.ToString(); lblSelfds18.Text = ds.Selfds18.ToString(); lblSelfds19.Text = ds.Selfds19.ToString(); lblSelfds20.Text = ds.Selfds20.ToString(); lblSelfds21.Text = ds.Selfds21.ToString(); lblSelfds22.Text = ds.Selfds22.ToString(); lblSelfds23.Text = ds.Selfds23.ToString(); lblUpds1.Text = ds.Upds1.ToString(); lblUpds2.Text = ds.Upds2.ToString(); lblUpds3.Text = ds.Upds3.ToString(); lblUpds4.Text = ds.Upds4.ToString(); lblUpds5.Text = ds.Upds5.ToString(); lblUpds6.Text = ds.Upds6.ToString(); lblUpds7.Text = ds.Upds7.ToString(); lblUpds8.Text = ds.Upds8.ToString(); lblUpds9.Text = ds.Upds9.ToString(); lblUpds10.Text = ds.Upds10.ToString(); lblUpds11.Text = ds.Upds11.ToString(); lblUpds12.Text = ds.Upds12.ToString(); lblUpds13.Text = ds.Upds13.ToString(); lblUpds14.Text = ds.Upds14.ToString(); lblUpds15.Text = ds.Upds15.ToString(); lblUpds16.Text = ds.Upds16.ToString(); lblUpds17.Text = ds.Upds17.ToString(); lblUpds18.Text = ds.Upds18.ToString(); lblUpds19.Text = ds.Upds19.ToString(); lblUpds20.Text = ds.Upds20.ToString(); lblUpds21.Text = ds.Upds21.ToString(); lblUpds22.Text = ds.Upds22.ToString(); lblUpds23.Text = ds.Upds23.ToString(); lblSectds1.Text = ds.Secds1.ToString(); lblSectds2.Text = ds.Secds2.ToString(); lblSectds3.Text = ds.Secds3.ToString(); lblSectds4.Text = ds.Secds4.ToString(); lblSectds5.Text = ds.Secds5.ToString(); lblSectds6.Text = ds.Secds6.ToString(); lblSectds7.Text = ds.Secds7.ToString(); lblSectds8.Text = ds.Secds8.ToString(); lblSectds9.Text = ds.Secds9.ToString(); lblSectds10.Text = ds.Secds10.ToString(); lblSectds11.Text = ds.Secds11.ToString(); lblSectds12.Text = ds.Secds12.ToString(); lblSectds13.Text = ds.Secds13.ToString(); lblSectds14.Text = ds.Secds14.ToString(); lblSectds15.Text = ds.Secds15.ToString(); lblSectds16.Text = ds.Secds16.ToString(); lblSectds17.Text = ds.Secds17.ToString(); lblSectds18.Text = ds.Secds18.ToString(); lblSectds19.Text = ds.Secds19.ToString(); lblSectds20.Text = ds.Secds20.ToString(); lblSectds21.Text = ds.Secds21.ToString(); lblSectds22.Text = ds.Secds22.ToString(); lblSectds23.Text = ds.Secds23.ToString(); lblTotalScore.Text = ds.TotalScore.ToString(); }
public override string ToString() { StringBuilder __sb = new StringBuilder("Employment("); bool __first = true; if (__isset.userId) { if (!__first) { __sb.Append(", "); } __first = false; __sb.Append("UserId: "); __sb.Append(UserId); } if (__isset.mode) { if (!__first) { __sb.Append(", "); } __first = false; __sb.Append("Mode: "); __sb.Append(Mode); } if (EmployeeInfo != null && __isset.employeeInfo) { if (!__first) { __sb.Append(", "); } __first = false; __sb.Append("EmployeeInfo: "); __sb.Append(EmployeeInfo == null ? "<null>" : EmployeeInfo.ToString()); } if (__isset.personEmploymentId) { if (!__first) { __sb.Append(", "); } __first = false; __sb.Append("PersonEmploymentId: "); __sb.Append(PersonEmploymentId); } if (__isset.requestId) { if (!__first) { __sb.Append(", "); } __first = false; __sb.Append("RequestId: "); __sb.Append(RequestId); } if (City != null && __isset.city) { if (!__first) { __sb.Append(", "); } __first = false; __sb.Append("City: "); __sb.Append(City == null ? "<null>" : City.ToString()); } if (DbStatus != null && __isset.dbStatus) { if (!__first) { __sb.Append(", "); } __first = false; __sb.Append("DbStatus: "); __sb.Append(DbStatus == null ? "<null>" : DbStatus.ToString()); } if (EmployeeIds != null && __isset.employeeIds) { if (!__first) { __sb.Append(", "); } __first = false; __sb.Append("EmployeeIds: "); __sb.Append(EmployeeIds); } if (__isset.rating) { if (!__first) { __sb.Append(", "); } __first = false; __sb.Append("Rating: "); __sb.Append(Rating); } __sb.Append(")"); return(__sb.ToString()); }
List <EmployeeInfo> GetEmployeeList() { //上月期间开始 DateTime date = SalaryResult.GetLastSalaryDate(group); //2018-7-11 获取软件开发人员 List <EmployeeInfo> developer_list = new List <EmployeeInfo>(); List <string> names = Developer.GetDeveloperList(); foreach (string name in names) { EmployeeInfo emp = EmployeeInfo.GetEmployeeInfoByName(name); if (emp != null) { developer_list.Add(emp); } } List <EmployeeInfo> emp_list = new List <EmployeeInfo>(); if (jobgrade != null) { if (salary_plan == "软件开发") { emp_list = developer_list; } else { //先将在职员工信息加载到内存 EmployeeInfo.GetEmployeeList(company_code, group, true); //获取上月工资表中的人员名单 emp_list = SalaryResult.GetEmployeeList(date.Year, date.Month, company_code, group, !check包括离职人员.Checked); //剔除软件开发人员 foreach (EmployeeInfo emp in developer_list) { emp_list.RemoveAll(a => a.员工编号 == emp.员工编号); } } } else { if (group == "管培生") { //先将在职员工信息加载到内存 EmployeeInfo.GetEmployeeList(company_code, null, true); //获取上月工资表中的人员名单 emp_list = SalaryResult.GetEmployeeList(date.Year, date.Month, company_code, null, !check包括离职人员.Checked); //移除非管培生 emp_list.RemoveAll(a => a.是管培生 == false); } else { string[] grade_list = null; if (group == "副总经理以上") { grade_list = 副总经理以上职等.Split(new char[] { ',' }); } if (grade_list != null) { for (int i = 0; i < grade_list.Length; i++) { //先将在职员工信息加载到内存 EmployeeInfo.GetEmployeeList(company_code, group, true); //获取上月工资表中的人员名单 List <EmployeeInfo> emps = SalaryResult.GetEmployeeList(date.Year, date.Month, company_code, grade_list[i], !check包括离职人员.Checked); emp_list.AddRange(emps); } } } //剔除软件开发人员 foreach (EmployeeInfo emp in developer_list) { emp_list.RemoveAll(a => a.员工编号 == emp.员工编号); } } //如果不是管培生组,剔除管培生 if (group != "管培生") { emp_list.RemoveAll(a => a.是管培生); } return(emp_list); }
static void Main(string[] args) { // Constants const int kNumWeeksPerYear = 52; Double[] kTaxCutoffs = // Cutoff income for tax brackets { 9525, 38700, 82500, 157500, 200000, 500000 }; Double[] kTaxPercents = // Percentages for tax brackets { .10, .12, .22, .24, .32, .35, .37 }; Console.WriteLine("Payroll Calculator"); // Output program name List <EmployeeInfo> employees = new List <EmployeeInfo>(); // Hold information on all employees // Main application loop while (true) { EmployeeInfo tmp = new EmployeeInfo(); // Builder struct Console.Write("\n"); // Get employee name do { Console.Write("Enter employee name (type 'done' to stop): "); tmp.sEmployeeName = Console.ReadLine(); } while (tmp.sEmployeeName == ""); if (tmp.sEmployeeName == "done") { break; // Stop entering names if done } String inputBuffer = ""; // Buffer to hold input to number do // Input hourly rate { Console.Write("Enter hourly pay rate: "); inputBuffer = Console.ReadLine(); } while (!Double.TryParse(inputBuffer, out tmp.numHourlyRate)); inputBuffer = ""; // Clear buffer do // Input hours worked { Console.Write("Enter hours worked: "); inputBuffer = Console.ReadLine(); } while (!Double.TryParse(inputBuffer, out tmp.numHoursWorked)); // Calculate gross pay per week & estimate per year tmp.numGrossPay = tmp.numHourlyRate * tmp.numHoursWorked; tmp.numGrossPerYear = tmp.numGrossPay * kNumWeeksPerYear; // Set tax percentage ushort taxNdx = 0; while (tmp.numGrossPerYear > kTaxCutoffs[taxNdx]) { taxNdx++; } tmp.numNetPay = tmp.numGrossPay - (tmp.numGrossPay * kTaxPercents[taxNdx]); // Calculate net pay tmp.numTaxesDeducted = tmp.numGrossPay * kTaxPercents[taxNdx]; // Calculate deducted taxes employees.Add(tmp); // Copy builder to new ndx of employee list } // Output information foreach (EmployeeInfo obj in employees) { Console.WriteLine("\n"); // 2 newlines Console.WriteLine("Payroll information for employee: " + obj.sEmployeeName); Console.WriteLine("Hourly rate: " + obj.numHourlyRate); Console.WriteLine("Hours worked: " + obj.numHoursWorked); Console.WriteLine("Gross pay: " + obj.numGrossPay); Console.WriteLine("Estimated yearly gross pay: " + obj.numGrossPerYear); Console.WriteLine("Taxes deducted: " + obj.numTaxesDeducted); Console.WriteLine("Net pay this week: " + obj.numNetPay); } // Emulate DOS shell pause Console.WriteLine(" Press any key to continue . . . "); Console.ReadKey(); }
public void Write(TProtocol oprot) { TStruct struc = new TStruct("Employment"); oprot.WriteStructBegin(struc); TField field = new TField(); if (__isset.userId) { field.Name = "userId"; field.Type = TType.I32; field.ID = 1; oprot.WriteFieldBegin(field); oprot.WriteI32(UserId); oprot.WriteFieldEnd(); } if (__isset.mode) { field.Name = "mode"; field.Type = TType.I16; field.ID = 2; oprot.WriteFieldBegin(field); oprot.WriteI16(Mode); oprot.WriteFieldEnd(); } if (EmployeeInfo != null && __isset.employeeInfo) { field.Name = "employeeInfo"; field.Type = TType.Struct; field.ID = 3; oprot.WriteFieldBegin(field); EmployeeInfo.Write(oprot); oprot.WriteFieldEnd(); } if (__isset.personEmploymentId) { field.Name = "personEmploymentId"; field.Type = TType.I64; field.ID = 4; oprot.WriteFieldBegin(field); oprot.WriteI64(PersonEmploymentId); oprot.WriteFieldEnd(); } if (__isset.requestId) { field.Name = "requestId"; field.Type = TType.I64; field.ID = 5; oprot.WriteFieldBegin(field); oprot.WriteI64(RequestId); oprot.WriteFieldEnd(); } if (City != null && __isset.city) { field.Name = "city"; field.Type = TType.Struct; field.ID = 6; oprot.WriteFieldBegin(field); City.Write(oprot); oprot.WriteFieldEnd(); } if (DbStatus != null && __isset.dbStatus) { field.Name = "dbStatus"; field.Type = TType.Struct; field.ID = 7; oprot.WriteFieldBegin(field); DbStatus.Write(oprot); oprot.WriteFieldEnd(); } if (EmployeeIds != null && __isset.employeeIds) { field.Name = "employeeIds"; field.Type = TType.String; field.ID = 8; oprot.WriteFieldBegin(field); oprot.WriteString(EmployeeIds); oprot.WriteFieldEnd(); } if (__isset.rating) { field.Name = "rating"; field.Type = TType.I32; field.ID = 9; oprot.WriteFieldBegin(field); oprot.WriteI32(Rating); oprot.WriteFieldEnd(); } oprot.WriteFieldStop(); oprot.WriteStructEnd(); }
public ActionResult Create(EmployeeInfo Emp) { _repository.Add(Emp); return(RedirectToAction("Index")); }
public ActionResult Create() { var Emp = new EmployeeInfo(); return(View(Emp)); }
public bool EmployeeInsert(EmployeeInfo empInfo) { try { SqlParameter[] param = new SqlParameter[29]; int i; param[0] = new SqlParameter("@FirstName", SqlDbType.VarChar); param[1] = new SqlParameter("@MiddleName", SqlDbType.VarChar); param[2] = new SqlParameter("@LastName", SqlDbType.VarChar); param[3] = new SqlParameter("@BirthDate", SqlDbType.DateTime); param[4] = new SqlParameter("@Gender", SqlDbType.VarChar); param[5] = new SqlParameter("@CivilStatus", SqlDbType.Int); param[6] = new SqlParameter("@SSNo", SqlDbType.VarChar); param[7] = new SqlParameter("@TinNo", SqlDbType.VarChar); param[8] = new SqlParameter("@Citizenship", SqlDbType.VarChar); param[9] = new SqlParameter("@MobileNo", SqlDbType.VarChar); param[10] = new SqlParameter("@HomePhoneNo", SqlDbType.VarChar); param[11] = new SqlParameter("@Street1", SqlDbType.VarChar); param[12] = new SqlParameter("@Street2", SqlDbType.VarChar); param[13] = new SqlParameter("@City", SqlDbType.VarChar); param[14] = new SqlParameter("@State", SqlDbType.VarChar); param[15] = new SqlParameter("@Country", SqlDbType.VarChar); param[16] = new SqlParameter("@EducBackGround", SqlDbType.VarChar); param[17] = new SqlParameter("@Recognitions", SqlDbType.VarChar); param[18] = new SqlParameter("@Email", SqlDbType.VarChar); param[19] = new SqlParameter("@EnterpriseId", SqlDbType.VarChar); param[20] = new SqlParameter("@Level", SqlDbType.Int); param[21] = new SqlParameter("@LMU", SqlDbType.VarChar); param[22] = new SqlParameter("@GMU", SqlDbType.VarChar); param[23] = new SqlParameter("@DateHired", SqlDbType.DateTime); param[24] = new SqlParameter("@WorkGroup", SqlDbType.VarChar); param[25] = new SqlParameter("@Specialty", SqlDbType.Int); param[26] = new SqlParameter("@ServiceLine", SqlDbType.VarChar); param[27] = new SqlParameter("@Status", SqlDbType.VarChar); param[28] = new SqlParameter("@CreatedBy", SqlDbType.Int); param[0].Value = empInfo.FirstName; param[1].Value = empInfo.MiddleName; param[2].Value = empInfo.LastName; param[3].Value = empInfo.BirthDate; param[4].Value = empInfo.Gender; param[5].Value = empInfo.CivilStatus; param[6].Value = empInfo.SSNo; param[7].Value = empInfo.TinNo; param[8].Value = empInfo.Citizenship; param[9].Value = empInfo.MobileNo; param[10].Value = empInfo.HomePhoneNo; param[11].Value = empInfo.Street1; param[12].Value = empInfo.Street2; param[13].Value = empInfo.City; param[14].Value = empInfo.State; param[15].Value = empInfo.Country; param[16].Value = empInfo.EducBackGround; param[17].Value = empInfo.Recognitions; param[18].Value = empInfo.AccentureDetailsInfo.Email; param[19].Value = empInfo.AccentureDetailsInfo.EnterpriseId; param[20].Value = empInfo.AccentureDetailsInfo.Level; param[21].Value = empInfo.AccentureDetailsInfo.LMU; param[22].Value = empInfo.AccentureDetailsInfo.GMU; param[23].Value = empInfo.AccentureDetailsInfo.DateHired; param[24].Value = empInfo.AccentureDetailsInfo.WorkGroup; param[25].Value = empInfo.AccentureDetailsInfo.Specialty; param[26].Value = empInfo.AccentureDetailsInfo.ServiceLine; param[27].Value = empInfo.AccentureDetailsInfo.Status; param[28].Value = empInfo.CreatedBy; i = SqlHelper.ExecuteNonQuery(constr, CommandType.StoredProcedure, "spCreateEmployee", param); if (i > 0) { return(true); } else { return(false); } } catch (SqlException ex) { new CustomException(ex.Message, "Employee DAO", "You are inside an exception", ex.StackTrace, " ", CreatedBy); return(false); } }
/// <summary> /// Reload the EmployeeInfo from the database /// </summary> /// <remarks> /// use this method when you want to relad the EmployeeInfo /// from the database, discarding any changes /// </remarks> public static void reload(ref EmployeeInfo mo) { if (mo == null) { throw new System.ArgumentNullException("null object past to reload function"); } mo = (EmployeeInfo)new EmployeeInfoDBMapper().findByKey(mo.Id); }
protected override void OnNavigatedTo(NavigationEventArgs e) { this.ClickedEmployee = (EmployeeInfo)e.Parameter; FillFIelds(); }
public static void saveEmployeeInfo(DataTable dt, ref EmployeeInfo mo) { foreach (DataRow dr in dt.Rows) { saveEmployeeInfo(dr, ref mo); } }
protected void btnSendFile_Click(object sender, EventArgs e) { if (IsPageValid()) { try { int emid = Convert.ToInt32(Session["EmployeeId"]); EmployeeInfo em = (EmployeeInfo)Session["Employee"]; //获取文件名 string name = this.UpFile.FileName; DateTime sendtime = DateTime.Now; if (!CanYou.OA.BLL.FileInfo.IsFileSame(name)) { string[] strto = new String[lbxRecv.Items.Count]; for (int i = 0; i < lbxRecv.Items.Count; i++) { CanYou.OA.BLL.FileInfo file = new CanYou.OA.BLL.FileInfo(); file.RecvEmployeeId = Convert.ToInt32(lbxRecv.Items[i].Value); file.FileName = name; file.FileTypeId = Convert.ToInt32(ddlFileType.SelectedValue.ToString()); file.SendEmployeeId = emid; file.Memo = txtMemo.Text.ToString(); file.SendTime = sendtime; file.IsCommon = 0; file.IsDelete = 0; file.IsMsg = 0; file.Save(); MessageInfo Msg = new MessageInfo(); Msg.Msg = "您收到新文件:" + name; Msg.Url = "~/ShareManage/RecvFile.aspx"; Msg.RecvEmployeeId = Convert.ToInt32(lbxRecv.Items[i].Value); Msg.Memo = file.FileId.ToString(); Msg.EmployeeName = em.EmployeeName; Msg.MsgType = "daiyue"; Msg.MsgTime = DateTime.Now.ToString("yyyy-MM-dd"); Msg.MsgTitle = name; Msg.Save(); EmployeeInfo ems = new EmployeeInfo(Convert.ToInt32(lbxRecv.Items[0].Value)); strto[i] = ems.Qq.ToString(); } //文件上传地址根目录,这里通过IIS架设本地主机为FTP服务器 //string FileSaveUri = @"ftp://192.168.11.70/www/Files/File/"; ////FTP用户名密码,就是本机的用户名密码 //string ftpUser = "******"; //string ftpPassWord = "******"; //SendFiles(FileSaveUri, ftpUser, ftpPassWord); this.UpFile.PostedFile.SaveAs(Server.MapPath("~/Files/File/" + UpFile.FileName)); MessageInfo.SendMailS(strto, "OA新消息", "您收到新文件"); Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script language='javascript'>alert('发送成功!');</script>"); } else { Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script language='javascript'>alert('该文件名已存在,请重命名!');</script>"); } } catch (Exception ex) { ClientScript.RegisterStartupScript(this.GetType(), "Save", "alert('发送失败:" + ex.Message + "');", true); } } }
public void ImportExcel() { ExcelShiftsOfDepartment excelShiftsOfDepartment = ReadExcelShiftData(); excelShiftsOfDepartment.DepartmentId = 2; //HR excelShiftsOfDepartment.Location = 2; excelShiftsOfDepartment.Month = 7; excelShiftsOfDepartment.Year = 2017; Dictionary <string, int> duplicatedEmployees = ValidateDuplicatedData(excelShiftsOfDepartment); string siteUrl = "http://rbvhspdev01:81/"; ShiftManagementDAL _shiftManagementDAL = new ShiftManagementDAL(siteUrl); ShiftManagementDetailDAL _shiftManagementDetailDAL = new ShiftManagementDetailDAL(siteUrl); List <ShiftManagement> shiftManagements = _shiftManagementDAL.GetByMonthYearDepartment(excelShiftsOfDepartment.Month, excelShiftsOfDepartment.Year, excelShiftsOfDepartment.DepartmentId, excelShiftsOfDepartment.Location); List <ShiftManagementDetail> shiftManagementDetails = new List <ShiftManagementDetail>(); if (shiftManagements != null && shiftManagements.Count > 0) { shiftManagementDetails = _shiftManagementDetailDAL.GetByShiftManagementID(shiftManagements[0].ID); } EmployeeInfoDAL _employeeInfoDAL = new EmployeeInfoDAL(siteUrl); List <EmployeeInfo> employeesOfDepartment = _employeeInfoDAL.GetByLocationAndDepartment(2, excelShiftsOfDepartment.DepartmentId, true, 4, StringConstant.EmployeeInfoList.EmployeeIDField); if (shiftManagementDetails != null && shiftManagementDetails.Count > 0) { foreach (var employeeShift in excelShiftsOfDepartment.EmployeeShifts) { EmployeeInfo employeeInfo = employeesOfDepartment.Where(e => e.EmployeeID == employeeShift.EmployeeID).FirstOrDefault(); if (employeeInfo != null) { employeeShift.EmployeeLookupID = employeeInfo.ID; } } List <int> employeeLookupIds = excelShiftsOfDepartment.EmployeeShifts.Select(e => e.EmployeeLookupID).ToList(); shiftManagementDetails = shiftManagementDetails.Where(e => employeeLookupIds.Contains(e.Employee.LookupId)).ToList(); } foreach (ExcelEmployeeShift excelEmployeeShift in excelShiftsOfDepartment.EmployeeShifts) { ShiftManagementDetail shiftManagementDetail = shiftManagementDetails.Where(e => e.Employee.LookupId == excelEmployeeShift.EmployeeLookupID).FirstOrDefault(); if (shiftManagementDetail == null) { shiftManagementDetail = new ShiftManagementDetail(); EmployeeInfo employeeInfo = employeesOfDepartment.Where(e => e.EmployeeID == excelEmployeeShift.EmployeeID).FirstOrDefault(); shiftManagementDetail.Employee = new LookupItem() { LookupId = employeeInfo.ID, LookupValue = employeeInfo.FullName }; shiftManagementDetails.Add(shiftManagementDetail); } ShiftTimeDAL _shiftTimeDAL = new ShiftTimeDAL(siteUrl); List <ShiftTime> shiftTimes = _shiftTimeDAL.GetAll(); for (int i = 0; i < 11; i++) { ShiftTime shiftTime = shiftTimes.Where(e => e.Code.ToUpper() == excelEmployeeShift.ShiftCodes[i].ToUpper()).FirstOrDefault(); if (shiftTime != null) { Type type = typeof(ShiftManagementDetail); PropertyInfo shiftApprovalInfo = type.GetProperty(string.Format("ShiftTime{0}Approval", i + 21)); object shiftApprovalValue = shiftApprovalInfo.GetValue(shiftManagementDetail, null); if (shiftApprovalValue != null && Convert.ToBoolean(shiftApprovalValue) == false) { PropertyInfo shiftInfo = type.GetProperty(string.Format("ShiftTime{0}", i + 21)); LookupItem shiftValue = shiftInfo.GetValue(shiftManagementDetail, null) as LookupItem; if (shiftValue == null) { shiftValue = new LookupItem(); } shiftValue.LookupId = shiftTime.ID; shiftValue.LookupValue = shiftTime.Code; } } } for (int i = 11; i < 31; i++) { ShiftTime shiftTime = shiftTimes.Where(e => e.Code.ToUpper() == excelEmployeeShift.ShiftCodes[i].ToUpper()).FirstOrDefault(); if (shiftTime != null) { Type type = typeof(ShiftManagementDetail); PropertyInfo shiftApprovalInfo = type.GetProperty(string.Format("ShiftTime{0}Approval", i - 10)); object shiftApprovalValue = shiftApprovalInfo.GetValue(shiftManagementDetail, null); if (shiftApprovalValue != null && Convert.ToBoolean(shiftApprovalValue) == false) { PropertyInfo shiftInfo = type.GetProperty(string.Format("ShiftTime{0}", i - 10)); LookupItem shiftValue = shiftInfo.GetValue(shiftManagementDetail, null) as LookupItem; if (shiftValue == null) { shiftValue = new LookupItem(); } shiftValue.LookupId = shiftTime.ID; shiftValue.LookupValue = shiftTime.Code; } } } } int shiftId = 0; if (shiftManagements == null || shiftManagements.Count == 0) { Biz.Models.ShiftManagement shiftManagement = new Biz.Models.ShiftManagement(); shiftManagement.Department = new LookupItem() { LookupId = excelShiftsOfDepartment.DepartmentId, LookupValue = excelShiftsOfDepartment.DepartmentId.ToString() }; shiftManagement.Location = new LookupItem() { LookupId = excelShiftsOfDepartment.Location, LookupValue = excelShiftsOfDepartment.Location.ToString() }; shiftManagement.Month = excelShiftsOfDepartment.Month; shiftManagement.Year = excelShiftsOfDepartment.Year; EmployeeInfo requester = _employeeInfoDAL.GetByADAccount(122); shiftManagement.Requester = new LookupItem() { LookupId = requester.ID, LookupValue = requester.FullName }; EmployeeInfo approvedBy = _employeeInfoDAL.GetByPositionDepartment(StringConstant.EmployeePosition.DepartmentHead, excelShiftsOfDepartment.DepartmentId, excelShiftsOfDepartment.Location).FirstOrDefault(); shiftManagement.ApprovedBy = new User() { ID = approvedBy.ADAccount.ID, UserName = approvedBy.ADAccount.UserName, FullName = approvedBy.FullName, IsGroup = false }; shiftId = _shiftManagementDAL.SaveOrUpdate(shiftManagement); } else { shiftId = shiftManagements[0].ID; } if (shiftId > 0) { foreach (ShiftManagementDetail shiftManagementDetail in shiftManagementDetails) { shiftManagementDetail.ShiftManagementID = new LookupItem() { LookupId = shiftId, LookupValue = shiftId.ToString() }; int shiftDetailId = _shiftManagementDetailDAL.SaveOrUpdate(shiftManagementDetail); } } }
public void TestGetEmployeeById() { EmployeeInfo info = scanmark.Get(1); Assert.IsNotNull(info); }
public async Task <ActionResult <int> > AddEMp([FromBody] EmployeeInfo em) { db.EmployeeInfo.Add(em); return(await db.SaveChangesAsync()); }
/// <summary> /// Function for save /// </summary> public void SaveFunction() { try { EmployeeInfo infoEmployee = new EmployeeInfo(); EmployeeCreationBll BllEmployeeCreation = new EmployeeCreationBll(); infoEmployee.EmployeeCode = txtEmployeeCode.Text.Trim(); infoEmployee.EmployeeName = txtEmployeeName.Text.Trim(); infoEmployee.DesignationId = Convert.ToDecimal(cmbDesignation.SelectedValue.ToString()); infoEmployee.Dob = Convert.ToDateTime(dtpDob.Text.ToString()); infoEmployee.MaritalStatus = (cmbMaritalStatus.Text.ToString()).TrimEnd(); if (cmbGender.Text != string.Empty) { infoEmployee.Gender = (cmbGender.SelectedItem.ToString()).TrimEnd(); } else { infoEmployee.Gender = cmbGender.Text.ToString(); } infoEmployee.Qualification = txtQualification.Text.Trim(); infoEmployee.Address = txtAddress.Text.Trim(); infoEmployee.PhoneNumber = txtPhoneNumber.Text.Trim(); infoEmployee.MobileNumber = txtMobileNumber.Text.Trim(); infoEmployee.Email = txtEmail.Text.Trim(); infoEmployee.JoiningDate = Convert.ToDateTime(txtJoiningDate.Text.ToString()); infoEmployee.TerminationDate = Convert.ToDateTime(txtTerminationDate.Text.ToString()); if (cbxActive.Checked) { infoEmployee.IsActive = true; } else { infoEmployee.IsActive = false; } infoEmployee.Narration = txtNarration.Text.Trim(); infoEmployee.BloodGroup = (cmbBloodGroup.Text.ToString()).TrimEnd(); infoEmployee.PassportNo = txtPassportNumber.Text.Trim(); infoEmployee.PassportExpiryDate = Convert.ToDateTime(dtpPassportExpiryDate.Text.ToString()); infoEmployee.VisaNumber = txtVisaNumber.Text.Trim(); infoEmployee.VisaExpiryDate = Convert.ToDateTime(dtpVisaExpiryDate.Text.ToString()); infoEmployee.LabourCardNumber = txtlabourCardNumber.Text.Trim(); infoEmployee.LabourCardExpiryDate = Convert.ToDateTime(dtpLabourCardExpiryDate.Text.ToString()); infoEmployee.SalaryType = (cmbSalaryType.SelectedItem.ToString()).TrimEnd(); if (cmbSalaryType.SelectedItem.ToString() == "Daily wage") { if (txtDailyWage.Text.Trim() != string.Empty) { infoEmployee.DailyWage = Convert.ToDecimal(txtDailyWage.Text.ToString()); } } else { if (cmbDefaultPackage.Text != string.Empty) { infoEmployee.DefaultPackageId = Convert.ToDecimal(cmbDefaultPackage.SelectedValue.ToString()); } } infoEmployee.BankName = txtBankName.Text.Trim(); infoEmployee.BankAccountNumber = txtBankAccountNumber.Text.Trim(); infoEmployee.BranchName = txtBranch.Text.Trim(); infoEmployee.BranchCode = txtBranchCode.Text.Trim(); infoEmployee.PanNumber = txtPanNumber.Text.Trim(); infoEmployee.PfNumber = txtPfNumber.Text.Trim(); infoEmployee.EsiNumber = txtEsiNumber.Text.Trim(); infoEmployee.ExtraDate = DateTime.Now; infoEmployee.Extra1 = string.Empty; infoEmployee.Extra2 = string.Empty; if (BllEmployeeCreation.EmployeeCodeCheckExistance(txtEmployeeCode.Text.Trim(), 0) == false) { decEmployeeId = BllEmployeeCreation.EmployeeAddWithReturnIdentity(infoEmployee); Messages.SavedMessage(); ClearFunction(); decIdForOtherForms = decEmployeeId; if (frmSalesInvoiceObj != null) { if (decIdForOtherForms != 0) { this.Close(); } } } else { Messages.InformationMessage("Employee code already exist"); txtEmployeeCode.Focus(); } } catch (Exception ex) { MessageBox.Show("EC1" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
// DELETE api/<controller>/5 /// <summary> /// 删除 /// </summary> /// <param name="collection"></param> /// <returns></returns> //public Common.ClientResult.Result Delete(string query) //{ // IBLL.IEmployeeBLL m_BLL = new EmployeeBLL(); // Common.ClientResult.Result result = new Common.ClientResult.Result(); // string returnValue = string.Empty; // int[] deleteId = Array.ConvertAll<string, int>(query.Split(','), delegate(string s) { return int.Parse(s); }); // if (deleteId != null && deleteId.Length > 0) // { // if (m_BLL.DeleteCollection(ref validationErrors, deleteId)) // { // LogClassModels.WriteServiceLog(Suggestion.DeleteSucceed + ",信息的Id为" + string.Join(",", deleteId), "消息" // );//删除成功,写入日志 // result.Code = Common.ClientCode.Succeed; // result.Message = Suggestion.DeleteSucceed; // } // else // { // if (validationErrors != null && validationErrors.Count > 0) // { // validationErrors.All(a => // { // returnValue += a.ErrorMessage; // return true; // }); // } // LogClassModels.WriteServiceLog(Suggestion.DeleteFail + ",信息的Id为" + string.Join(",", deleteId) + "," + returnValue, "消息" // );//删除失败,写入日志 // result.Code = Common.ClientCode.Fail; // result.Message = Suggestion.DeleteFail + returnValue; // } // } // return result; //} /// <summary> /// 创建 /// </summary> /// <param name="entity">实体对象</param> /// <returns></returns> //public Common.ClientResult.Result Post([FromBody]Employee entity) //{ // IBLL.IEmployeeBLL m_BLL = new EmployeeBLL(); // Common.ClientResult.Result result = new Common.ClientResult.Result(); // if (entity != null && ModelState.IsValid) // { // //string currentPerson = GetCurrentPerson(); // //entity.CreateTime = DateTime.Now; // //entity.CreatePerson = currentPerson; // string returnValue = string.Empty; // if (m_BLL.Create(ref validationErrors, entity)) // { // LogClassModels.WriteServiceLog(Suggestion.InsertSucceed + ",员工的信息的Id为" + entity.Id, "员工" // );//写入日志 // result.Code = Common.ClientCode.Succeed; // result.Message = Suggestion.InsertSucceed; // return result; //提示创建成功 // } // else // { // if (validationErrors != null && validationErrors.Count > 0) // { // validationErrors.All(a => // { // returnValue += a.ErrorMessage; // return true; // }); // } // LogClassModels.WriteServiceLog(Suggestion.InsertFail + ",员工的信息," + returnValue, "员工" // );//写入日志 // result.Code = Common.ClientCode.Fail; // result.Message = Suggestion.InsertFail + returnValue; // return result; //提示插入失败 // } // } // result.Code = Common.ClientCode.FindNull; // result.Message = Suggestion.InsertFail + ",请核对输入的数据的格式"; //提示输入的数据的格式不对 // return result; //} /// <summary> /// 添加 /// </summary> /// <param name="entity"></param> /// <returns></returns> public Common.ClientResult.Result Create([FromBody] EmployeeInfo entity) { IBLL.IEmployeeBLL m_BLL = new EmployeeBLL(); Common.ClientResult.Result result = new Common.ClientResult.Result(); #region 验证 //if (entity.CertificateType == null) //{ // result.Code = Common.ClientCode.FindNull; // result.Message = "请选择证件类型"; // return result; //提示输入的数据的格式不对 //} //if (entity.Sex == null) //{ // result.Code = Common.ClientCode.FindNull; // result.Message = "请选择性别"; // return result; //提示输入的数据的格式不对 //} //if (entity.AccountType == null) //{ // result.Code = Common.ClientCode.FindNull; // result.Message = "请选择户口类型"; // return result; //提示输入的数据的格式不对 //} //if (entity.CertificateType == "居民身份证") //{ // string number = entity.BasicInfo.CertificateNumber; // if (Common.CardCommon.CheckCardID18(number) == false) // { // result.Code = Common.ClientCode.FindNull; // result.Message = "证件号不正确请重新输入"; // return result; //提示输入的数据的格式不对 // } //} //if (entity.CompanyId==0) //{ // result.Code = Common.ClientCode.FindNull; // result.Message = "请选择所属公司"; // return result; //提示输入的数据的格式不对 //} //if (string.IsNullOrEmpty(entity.Citys)) //{ // result.Code = Common.ClientCode.FindNull; // result.Message = "请选择社保缴纳地"; // return result; //提示输入的数据的格式不对 //} //if (entity.PoliceAccountNatureId == 0) //{ // result.Code = Common.ClientCode.FindNull; // result.Message = "请选择户口性质"; // return result; //提示输入的数据的格式不对 //} #endregion //if (entity != null && ModelState.IsValid) //{ Employee baseModel = entity.BasicInfo; //基本信息 baseModel.AccountType = entity.AccountType; baseModel.CertificateType = entity.CertificateType; baseModel.Sex = entity.Sex; baseModel.CreateTime = DateTime.Now; baseModel.CreatePerson = LoginInfo.RealName; EmployeeContact contact = entity.empContacts; contact.CreatePerson = LoginInfo.RealName; contact.CreateTime = DateTime.Now; EmployeeBank bank = entity.empBank; if (bank.AccountName == null && bank.Bank == null && bank.BranchBank == null && bank.Account == null) { bank = null; } else { bank.CreatePerson = LoginInfo.RealName; bank.CreateTime = DateTime.Now; } CompanyEmployeeRelation relation = new CompanyEmployeeRelation(); relation.CityId = entity.Citys; relation.State = "在职"; relation.CompanyId = entity.CompanyId; relation.CreateTime = DateTime.Now; relation.CreatePerson = LoginInfo.RealName; relation.Station = entity.Station; relation.PoliceAccountNatureId = entity.PoliceAccountNatureId; string returnValue = string.Empty; if (m_BLL.EmployeeAdd(ref validationErrors, baseModel, contact, bank, relation)) { //LogClassModels.WriteServiceLog(Suggestion.InsertSucceed + ",客户_企业信息_待审核的信息的Id为" + entity.ID, "客户_企业信息_待审核" //);//写入日志 result.Code = Common.ClientCode.Succeed; result.Message = Suggestion.InsertSucceed; return(result); //提示创建成功 } else { if (validationErrors != null && validationErrors.Count > 0) { validationErrors.All(a => { returnValue += a.ErrorMessage; return(true); }); } //LogClassModels.WriteServiceLog(Suggestion.InsertFail + ",客户_企业信息_待审核的信息," + returnValue, "客户_企业信息_待审核" // );//写入日志 result.Code = Common.ClientCode.Fail; result.Message = Suggestion.InsertFail + returnValue; return(result); //提示插入失败 } //} result.Code = Common.ClientCode.FindNull; result.Message = Suggestion.InsertFail + ",请核对输入的数据的格式"; //提示输入的数据的格式不对 return(result); }
/// <summary> /// Function to fill controls when cell double click in frmEmployeeRegister for updation /// </summary> /// <param name="decEmployeeId"></param> /// <param name="frm"></param> public void CallFromEmployeeRegister(decimal decEmployeeId, frmEmployeeRegister frm) { try { base.Show(); frmEmployeeRegisterObj = frm; EmployeeInfo infoEmployee = new EmployeeInfo(); EmployeeCreationBll BllEmployeeCreation = new EmployeeCreationBll(); infoEmployee = BllEmployeeCreation.EmployeeView(decEmployeeId); lblEmployeeId.Text = infoEmployee.EmployeeId.ToString(); txtEmployeeCode.Text = infoEmployee.EmployeeCode.ToString(); strEmployeeCode = infoEmployee.EmployeeCode.ToString(); txtEmployeeName.Text = infoEmployee.EmployeeName.ToString(); cmbDesignation.SelectedValue = infoEmployee.DesignationId; dtpDob.Text = infoEmployee.Dob.ToString("dd-MMM-yyyy"); cmbMaritalStatus.SelectedItem = infoEmployee.MaritalStatus.ToString(); cmbGender.SelectedItem = infoEmployee.Gender.ToString(); txtQualification.Text = infoEmployee.Qualification; cmbBloodGroup.SelectedItem = infoEmployee.BloodGroup.ToString(); txtAddress.Text = infoEmployee.Address; txtBankAccountNumber.Text = infoEmployee.BankAccountNumber; txtBankName.Text = infoEmployee.BankName; txtBranch.Text = infoEmployee.BranchName; txtEmail.Text = infoEmployee.Email; txtEsiNumber.Text = infoEmployee.EsiNumber; txtlabourCardNumber.Text = infoEmployee.LabourCardNumber; txtBranchCode.Text = infoEmployee.BranchCode; txtMobileNumber.Text = infoEmployee.MobileNumber; txtNarration.Text = infoEmployee.Narration; txtPanNumber.Text = infoEmployee.PanNumber; txtPassportNumber.Text = infoEmployee.PassportNo; txtPfNumber.Text = infoEmployee.PfNumber; txtPhoneNumber.Text = infoEmployee.PhoneNumber; txtVisaNumber.Text = infoEmployee.VisaNumber; cmbSalaryType.SelectedItem = infoEmployee.SalaryType; if (cmbSalaryType.SelectedItem.ToString() == "Daily wage") { txtDailyWage.Text = infoEmployee.DailyWage.ToString(); } else { cmbDefaultPackage.SelectedValue = int.Parse(infoEmployee.DefaultPackageId.ToString()); } txtJoiningDate.Text = infoEmployee.JoiningDate.ToString("dd-MMM-yyyy"); dtpLabourCardExpiryDate.Value = infoEmployee.LabourCardExpiryDate; dtpPassportExpiryDate.Value = infoEmployee.PassportExpiryDate; txtTerminationDate.Text = infoEmployee.TerminationDate.ToString("dd-MMM-yyyy"); dtpVisaExpiryDate.Value = infoEmployee.VisaExpiryDate; txtEmployeeCode.Focus(); if (infoEmployee.IsActive) { cbxActive.Checked = true; } else { cbxActive.Checked = false; } btnSave.Text = "Update"; btnDelete.Enabled = true; txtEmployeeCode.Select(); } catch (Exception ex) { MessageBox.Show("EC12" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
public void CalculatePayslip_ShouldThrowOverflowException_WhenAnnualSalaryIsNegative() { // Arrange EmployeeInfo employeeInfo = new EmployeeInfo { FirstName = "David", LastName = "Rudd", AnnualSalary = -1, SuperRate = 0, PaymentStartDate = "01 March – 31 March", }; // Act Action action = () => { this.employeeIncomeService.CalculatePayslip(employeeInfo); }; // Assert action.ShouldThrow<OverflowException>(); }
public int CreateEmployee(EmployeeInfo Emp) { context.EmployeeInfo.Add(Emp); context.SaveChanges(); return(Emp.EmpNo); }
/// <summary> ///登录 /// </summary> /// <param name="ENo">员工号</param> /// <param name="Rpassword">密码</param> /// <returns></returns> public static LoginResult Login(string ENo, string Rpassword) { using (EFContext Context = new EFContext()) { var jieguo = from s in Context.EmployeeInfo select s; if (jieguo.FirstOrDefault() == null) { EmployeeInfo employee = new EmployeeInfo() { ENo = ENo, EName = "管理员", Esex = true, Ephone = "", Eemail = "", EcardID = Rpassword, Ppassword = Rpassword.Substring(12), Eheart = "", Pid = 1 }; PositionInfo positionInfo = new PositionInfo() { PoName = "超级管理员", PoLeave = 1, PoMinMoney = 0, Permission = "ALL" }; PersonMessage personMessage = new PersonMessage() { EID = 1, PeBeginWork = DateTime.Now.ToString(), PeEndwork = "", Pstatic = true }; DbEntityEntry <EmployeeInfo> entityEntry = Context.Entry <EmployeeInfo>(employee); entityEntry.State = System.Data.Entity.EntityState.Added; DbEntityEntry <PositionInfo> entityEn = Context.Entry <PositionInfo>(positionInfo); entityEn.State = System.Data.Entity.EntityState.Added; DbEntityEntry <PersonMessage> person = Context.Entry <PersonMessage>(personMessage); person.State = System.Data.Entity.EntityState.Added; Context.SaveChanges(); Rpassword = Rpassword.Substring(12); //"create trigger trigger_insert on employeeinfo for insert as insert into PersonMessage values(@@IDENTITY,CONVERT(varchar(12) , getdate(), 111 ),'',1)" } var result = (from a in Context.EmployeeInfo join b in Context.PositionInfo on a.Pid equals b.PoID join c in Context.PersonMessage on a.EID equals c.EID where a.ENo.Equals(ENo) && a.Ppassword.Equals(Rpassword) select new { name = a.EName, Eid = a.EID, Pstats = c.Pstatic, ENo = a.ENo, PoName = b.PoName, permissins = b.Permission }).ToList().FirstOrDefault(); LoginResult loginResult = new LoginResult(); if (result == null) { loginResult.Result = false; } else { if (result.Pstats) { loginResult.Result = true; loginResult.EID = result.Eid; loginResult.EName = result.name.ToString(); loginResult.ENo = result.ENo.ToString(); loginResult.PoName = result.PoName.ToString(); loginResult.Permissins = result.permissins.ToString(); } else { loginResult.Result = false; } } return(loginResult); } }
public static List <EmployeeInfo> GetEmpInfo(AprajitaRetailsContext db) { var emps = db.Attendances.Include(c => c.Employee). Where(c => (c.AttDate) == (DateTime.Today)).OrderByDescending(c => c.Employee.StaffName); var empPresent = db.Attendances.Include(c => c.Employee) .Where(c => c.Status == AttUnits.Present && (c.AttDate).Month == (DateTime.Today).Month) .GroupBy(c => c.Employee.StaffName).OrderBy(c => c.Key).Select(g => new { StaffName = g.Key, Days = g.Count() }).ToList(); var empAbsent = db.Attendances.Include(c => c.Employee) .Where(c => c.Status == AttUnits.Absent && (c.AttDate).Month == (DateTime.Today).Month) .GroupBy(c => c.Employee.StaffName).OrderBy(c => c.Key).Select(g => new { StaffName = g.Key, Days = g.Count() }).ToList(); var totalSale = db.DailySales.Include(c => c.Salesman).Where(c => (c.SaleDate).Month == (DateTime.Today).Month).Select(a => new { StaffName = a.Salesman.SalesmanName, Amount = a.Amount }).ToList(); List <EmployeeInfo> infoList = new List <EmployeeInfo>(); foreach (var item in emps) { if (item.Employee.StaffName != "Amit Kumar") { EmployeeInfo info = new EmployeeInfo() { Name = item.Employee.StaffName, AbsentDays = 0, NoOfBills = 0, Present = "", PresentDays = 0, Ratio = 0, TotalSale = 0 }; if (item.Status == AttUnits.Present) { info.Present = "Present"; } else { info.Present = "Absent"; } try { if (item.Employee.Category == EmpType.Salesman) { info.IsSalesman = true; } if (empPresent != null) { var pd = empPresent.Where(c => c.StaffName == info.Name).FirstOrDefault(); if (pd != null) { info.PresentDays = pd.Days; } else { info.PresentDays = 0; } } else { info.PresentDays = 0; } if (empAbsent != null) { var ad = empAbsent.Where(c => c.StaffName == info.Name).FirstOrDefault(); if (ad != null) { info.AbsentDays = ad.Days; } else { info.AbsentDays = 0; } } else { info.AbsentDays = 0; } //var ts = db.DailySales.Include(c=>c.Salesman ).Where (c => c.Salesman.SalesmanName == info.Name && (c.SaleDate).Month == (DateTime.Today).Month).ToList(); if (totalSale != null && (item.Employee.Category == EmpType.Salesman || item.Employee.Category == EmpType.StoreManager)) { var ts = totalSale.Where(c => c.StaffName == info.Name).ToList(); info.TotalSale = (decimal?)ts.Sum(c => (decimal?)c.Amount) ?? 0; info.NoOfBills = (int?)ts.Count ?? 0; } if (info.PresentDays > 0 && info.TotalSale > 0) { info.Ratio = Math.Round((double)info.TotalSale / info.PresentDays, 2); } } catch (Exception) { // Log.Error().Message("emp-present exception"); } infoList.Add(info); } } return(infoList); }
public int UpdateEmployeeInfo(EmployeeInfo theEmployee) { return(EmployeeIntegration.UpdateEmployeeInfo(theEmployee)); }
public override void ItemAdded(SPItemEventProperties properties) { try { base.ItemAdded(properties); var siteURL = properties.WebUrl; var vehicleManagementDAL = new VehicleManagementDAL(siteURL); var ItemID = properties.ListItemId; var currentItem = vehicleManagementDAL.GetByID(ItemID); taskManagementDAL = new TaskManagementDAL(siteURL); TaskManagement taskManagement = new TaskManagement(); taskManagement.StartDate = DateTime.Now; taskManagement.DueDate = currentItem.RequestDueDate; taskManagement.PercentComplete = 0; taskManagement.ItemId = currentItem.ID; taskManagement.ItemURL = properties.List.DefaultDisplayFormUrl + "?ID=" + properties.ListItemId; taskManagement.ListURL = properties.List.DefaultViewUrl; taskManagement.TaskName = TASK_NAME; taskManagement.TaskStatus = TaskStatusList.InProgress; taskManagement.StepModule = StepModuleList.VehicleManagement.ToString(); taskManagement.Department = currentItem.CommonDepartment; taskManagement.AssignedTo = currentItem.DepartmentHead; employeeInfoDAL = new EmployeeInfoDAL(siteURL); EmployeeInfo requesterInfo = employeeInfoDAL.GetByID(currentItem.Requester.LookupId); if ((int)Convert.ToDouble(requesterInfo.EmployeeLevel.LookupValue, CultureInfo.InvariantCulture.NumberFormat) == (int)StringConstant.EmployeeLevel.DepartmentHead) { taskManagement.StepStatus = StepStatusList.BODApproval; } else { taskManagement.StepStatus = StepStatusList.DHApproval; } DepartmentDAL _departmentDAL = new DepartmentDAL(siteURL); Department departmentHR = _departmentDAL.GetByCode("HR"); if (departmentHR.ID == currentItem.CommonDepartment.LookupId) { taskManagement.NextAssign = null; } else { EmployeeInfo deptHeadOfHR = employeeInfoDAL.GetByPositionDepartment(StringConstant.EmployeePosition.DepartmentHead, requesterInfo.FactoryLocation.LookupId, departmentHR.ID).FirstOrDefault(); if (deptHeadOfHR != null) { taskManagement.NextAssign = deptHeadOfHR.ADAccount; } } taskManagementDAL.SaveItem(taskManagement); var mailDAL = new EmailTemplateDAL(siteURL); var emailTemplate = mailDAL.GetByKey("VehicleManagement_Request"); EmployeeInfo assigneeInfo = employeeInfoDAL.GetByADAccount(taskManagement.AssignedTo.ID); currentItem.ApprovalStatus = taskManagement.StepStatus; vehicleManagementDAL.SaveOrUpdate(currentItem); vehicleManagementDAL.SendEmail(currentItem, emailTemplate, null, assigneeInfo, VehicleTypeOfEmail.Request, siteURL); try { List <EmployeeInfo> toUsers = DelegationPermissionManager.GetListOfDelegatedEmployees(siteURL, assigneeInfo.ID, StringConstant.VehicleManagementList.ListUrl, currentItem.ID); vehicleManagementDAL.SendDelegationEmail(currentItem, emailTemplate, toUsers, siteURL); } catch { } } catch (Exception ex) { ULSLogging.Log(new SPDiagnosticsCategory("STADA - Transportation Event Receiver - ItemAdded fn", TraceSeverity.Unexpected, EventSeverity.Error), TraceSeverity.Unexpected, string.Format(CultureInfo.InvariantCulture, "{0}:{1}", ex.Message, ex.StackTrace)); } }
public static EmployeeInfo loadFromDataRow(DataRow r) { DataRowLoader a = new DataRowLoader(); IModelObject mo = new EmployeeInfo(); a.DataSource = r; a.load(mo); return (EmployeeInfo)mo; }
/// <summary> /// To be called on when user clicks OK. Attempts to add a new employee given the values entered in the boxes. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnOK_Click(object sender, EventArgs e) { multiListBox.Visible = false; if (!radMale.Checked && !radFemale.Checked) { MessageBox.Show("Please enter gender."); return; } //Calculates age based on given date of birth DateTime zeroTime = new DateTime(1, 1, 1); TimeSpan age = DateTime.Now - dtpDOB.Value; int years = (zeroTime + age).Year - 1; //If the calculated age don't correlate with input age, an error must be thrown if (years != (int)numAge.Value) { //Employees must be between 18 and 60 years old, according to client specifications if (years >= MIN_AGE && years <= MAX_AGE) { DialogResult answer = MessageBox.Show( $"Liar. According to date of birth, {txtName.Text} isn't {numAge.Value} years, " + $"{(radMale.Checked? "he" : "she")} is {years} years old.\n" + $"Change age to {years}?\n" + $"(If no, employee will NOT be added)", "Age error", MessageBoxButtons.YesNo); if (answer == DialogResult.Yes) { numAge.Value = years; } else { return; } } else { MessageBox.Show( $"Liar. according to date of birth, {txtName.Text} is {years} years old. Please try again.\n" + $"Please note that employees must be between {MIN_AGE} and {MAX_AGE}."); return; } } //Adds all checked hobbies to the hobby-list List <Hobby> hob = new List <Hobby>(); foreach (Hobby h in chkLstHobbies.CheckedItems) { hob.Add(h); } //if the new employee is null, just return EmployeeInfo emp = CreateEmployee(); if (emp == null) { return; } //Tries to add the new employee. If that fails, Prompt the user that the given employeenumber already exists if (!employeeHandler.AddEmployee(emp)) { MessageBox.Show($"Employee-number {mskTxtEmpNo.Text} already exists."); return; } txtDetails.Text = emp.ToLongString(); }
public static void saveEmployeeInfo(DataRow dr, ref EmployeeInfo mo) { if (mo == null) { mo = new EmployeeInfo(); } foreach (DataColumn dc in dr.Table.Columns) { mo.setAttribute(dc.ColumnName, dr[dc.ColumnName]); } saveEmployeeInfo(mo); }
/// <summary> /// To be called on when the index is changed in the multiListBox, to update the txtDetails-textbox with appropriate data /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void multiListBox_SelectedIndexChanged(object sender, EventArgs e) { EmployeeInfo tempEmp = (EmployeeInfo)multiListBox.SelectedItem; txtDetails.Text = tempEmp.ToLongString(); }
public void saveEmployeeInfo(EmployeeInfo mo) { base.save(mo); }
protected void Page_Load(object sender, EventArgs e) { //查看是否有用户级语言辅助器,没有则用公共的 LangHelper = FetchData.GetLanguageHelper(Session); lblUser.Text = LangHelper.GetText("User Name:"); lblPwd.Text = LangHelper.GetText("Password:"******"Change Password"); lblNewPwd.Text = LangHelper.GetText("New Password:"******"Confirm New Password:"******"Verify Code:"); btnSubmit.Text = LangHelper.GetText("Login"); imgVerifyCode.ToolTip = LangHelper.GetText("Click For New Picture."); imgVerifyCode.AlternateText = LangHelper.GetText("Verify Code"); btnSubmit.Text = LangHelper.GetText("Login"); imgVerifyCode.ImageUrl = "FetchData.ashx?fn=VerifyCode&k=" + (new System.Random().Next()); if (Request["iptUser"] != null) { string sErrInfo = null; #if !WEB_DEBUG try { if (string.Equals((string)Session["VerifyCode"], Request["iptCheckCode"], StringComparison.OrdinalIgnoreCase) == false) { throw new Exception(LangHelper.GetText("Verify Code Is Incorrect !")); } #endif string userName = Request["iptUser"]; string password = Request["iptPwd"]; Session["LogonEmployee"] = null; bool bChangePwd = Cvt.ToBoolean(Request["bChangePwd"]); string sNewPwd = Request["iptNewPwd"]; string sConfirmPwd = Request["iptConfirmPwd"]; if ((!bChangePwd) || sNewPwd != sConfirmPwd || string.IsNullOrEmpty(sNewPwd)) { sNewPwd = ""; } string sStation = "", sFromIP = Request.ServerVariables["HTTP_X_FORWARDED_FOR"], sFromHost = Request.UserHostName, sFromMAC = ""; if (string.IsNullOrEmpty(sFromIP)) { sFromIP = Request.ServerVariables["REMOTE_ADDR"]; } if (string.IsNullOrEmpty(sFromIP)) { sFromIP = Request.UserHostAddress; } if (string.IsNullOrEmpty(sFromHost)) { sFromHost = Common.GetHostName(sFromIP); } sFromMAC = Common.GetCustomerMacByArp(sFromIP); EmployeeInfo Employee = UserMgr.CheckLoginAuthenticate(LangHelper, userName, password, sNewPwd, sStation, sFromIP, sFromMAC, sFromHost); if (Employee != null) { Session["LogonEmployee"] = Employee; //如果父框架有方法f_LoginAuthenticated方法,则调用它 string sHtml = "<script type=\"text/javascript\">" //+ "if(parent.LoginDlg) parent.LoginDlg.close();" + "if(parent.f_LoginAuthenticated) parent.f_LoginAuthenticated();" + "</script>"; errorInfoLable.Controls.Add(new LiteralControl(sHtml)); string sTarget = Request["target"]; if (!string.IsNullOrEmpty(sTarget)) { Response.Redirect(Server.UrlDecode(sTarget)); } } ; #if !WEB_DEBUG } catch (Exception excep) { sErrInfo = excep.Message; } #endif if (sErrInfo != null) { errorInfoLable.Controls.Add(new LiteralControl(Server.HtmlEncode(sErrInfo))); } }; }
private void AddRow(EmployeeAccessDataSet ds, EmployeeInfo employee, SKDCard card, CardDoor door, AccessTemplate template, Dictionary<Guid, Tuple<Tuple<GKSKDZone, string>, Tuple<GKSKDZone, string>>> zoneMap, List<Guid> addedZones) { if (!zoneMap.ContainsKey(door.DoorUID)) return; var zones = zoneMap[door.DoorUID]; var dataRow = ds.Data.NewDataRow(); dataRow.Type = card.GKCardType.ToDescription(); dataRow.Number = card.Number.ToString(); if (employee != null) { dataRow.Employee = employee.Name; dataRow.Organisation = employee.Organisation; dataRow.Department = employee.Department; dataRow.Position = employee.Position; } if (template != null) dataRow.Template = template.Name; if (zones.Item1 != null && !addedZones.Contains(zones.Item1.Item1.UID)) { var row1 = ds.Data.NewDataRow(); row1.ItemArray = dataRow.ItemArray; row1.Zone = zones.Item1.Item2; row1.No = zones.Item1.Item1.No; ds.Data.AddDataRow(row1); addedZones.Add(zones.Item1.Item1.UID); } if (zones.Item2 != null && !addedZones.Contains(zones.Item2.Item1.UID)) { var row2 = ds.Data.NewDataRow(); row2.ItemArray = dataRow.ItemArray; row2.Zone = zones.Item2.Item2; row2.No = zones.Item2.Item1.No; ds.Data.AddDataRow(row2); addedZones.Add(zones.Item2.Item1.UID); } }
public void Insert(EmployeeInfo info) { _employeeInfoRepository.Insert(info); }
/// <summary> /// By convention, when VMController receives a list item from the client, it will look for the function that starts /// with the list property name and ends with "_get" to access the list item for the purpose of updating its value. /// </summary> /// <param name="iKey">List item key.</param> /// <returns>List item.</returns> public EmployeeInfo Employees_get(string iKey) { EmployeeInfo employeeInfo = null; var record = _Model.GetRecord(int.Parse(iKey)); if (record != null) employeeInfo = new EmployeeInfo { Id = record.Id, FirstName = record.FirstName, LastName = record.LastName }; // Handle the event when the employee data is changed on the client. if (employeeInfo != null) employeeInfo.PropertyChanged += Employee_PropertyChanged; return employeeInfo; }
public void Update(EmployeeInfo info) { _employeeInfoRepository.Update(info); }
public DataTable get_EMPDataByNames(EmployeeInfo EMPInfo) { DataTable empdata = new DataTable(); SqlConnection sqlCon = new SqlConnection(conStr); string sqlQuery = "select * from Employee where Employee.Emp_LName='" + EMPInfo.EMPLName + "' and Employee.Emp_FName='" + EMPInfo.EMPFName + "'"; SqlCommand cmd = new SqlCommand(); cmd.CommandText = sqlQuery; cmd.Connection = sqlCon; SqlDataAdapter sqlDa = new SqlDataAdapter(cmd); DataSet dsEMPnames = new DataSet(); try { sqlDa.Fill(dsEMPnames, "Names"); int a= dsEMPnames.Tables["Names"].Rows.Count; } catch (Exception ex) { objNLog.Error("Exception : " + ex.Message); } return dsEMPnames.Tables["Names"]; }
/// ************************************************************** /// <summary> /// 描述:为所有人补签到签退 /// </summary> /// <param name="date">签到或者签退的日期</param> /// <param name="signInTime">签到时间</param> /// <param name="signOutTime">签退时间</param> /// <param name="appendForEmpID">被补签到人的ID</param> /// <param name="note">说明</param> /// <returns></returns> /// ************************************************************** public int UpdateCheckInInfoBySystem(string date, string signInTime, string signOutTime, string note, int appendEmpID, string appendEmpName, int appendForEmpID) { string sql = ""; DateTime signInDate = DateTime.Parse(date + " " + signInTime); DateTime signOutDate = DateTime.Parse(date + " " + signOutTime); TimeSpan timeSpan = signOutDate - signInDate; WorkDuration workDuration = WorkDurationService.Instance.GetWorkDuration(); List <CheckInInfo> modifyedEmpList = new List <CheckInInfo>(); int workTime = timeSpan.Hours; if (workTime > workDuration.WDDayDuration) { workTime = workDuration.WDDayDuration; } if (appendForEmpID == 0) { List <EmployeeInfo> empList = EmployeeService.Instance.GetList(); if (empList != null && empList.Count > 0) { for (int i = 0; i < empList.Count; i++) { //为所有人进行签到签退 //判断是否已经签过到/退 //MODIFY CheckInInfo checkInfo = isCheckInInfoExisted(date, int.Parse(empList[i].EmpID)); if (checkInfo != null) { return(0); } #region ------------------1. 插入语句 //MODIFY //SQL语句过长问题 sql = string.Format(@"Insert into T_CheckingInInfo( F_EmpID, F_EmpName, F_DepID, F_DepName, F_CISignInDate, F_CISignOutDate, F_CIRealityWorkDuration, F_AppendSignInPersonID, F_AppendSignInPersonName, F_AppendSignInPersonNote, F_CIIsLate, F_CIIsLeaveEarvly, F_CIIsAbsenteeism, F_CIIsNormal, F_CICreateDate, F_CIIsSignIn, F_CIIsCalculate, F_Date ) values({0},'{1}',{2},'{3}','{4}','{5}',{6},{7},'{8}','{9}',{10}, '{11}',{12},{13},'{14}');", empList[i].EmpID, empList[i].EmpName, empList[i].DepID, empList[i].DepName, signInDate, signOutDate, workTime, appendEmpID, appendEmpName, note.Replace("'", "''"), makeSql(signOutDate, signInDate, workDuration), DateTime.Now.ToString("yyyy-MM-dd"), "0", "0", date); #endregion int res = MrDBAccess.ExecuteNonQuery(sql); if (res == 0) { return(0); } modifyedEmpList.Add(GetCheckInfo(int.Parse(empList[i].EmpID), date)); } } } else { //为某个员工进行签到签退 #region ---------------------------sql语句 EmployeeInfo employeeInfo = EmployeeService.Instance.GetEmployee(appendForEmpID); CheckInInfo checkInfo = isCheckInInfoExisted(date, int.Parse(employeeInfo.EmpID)); if (checkInfo != null) { return(0); } sql = string.Format(@"INSERT INTO T_CheckingInInfo(F_EmpID, F_EmpName, F_DepID, F_DepName, F_CISignInDate, F_CISignOutDate, F_CIRealityWorkDuration, F_AppendSignInPersonID, F_AppendSignInPersonName, F_AppendSignInPersonNote, F_CIIsLate, F_CIIsLeaveEarvly, F_CIIsAbsenteeism, F_CIIsNormal, F_CICreateDate, F_CIIsSignIn, F_CIIsCalculate, F_Date) VALUES({0},'{1}',{2},'{3}','{4}','{5}',{6},{7},'{8}','{9}',{10}, '{11}',{12},{13},'{14}')", employeeInfo.EmpID, employeeInfo.EmpName, employeeInfo.DepID, employeeInfo.DepName, signInDate, signOutDate, workTime, appendEmpID, appendEmpName, note.Replace("'", "''"), makeSql(signOutDate, signInDate, workDuration), DateTime.Now.ToString("yyyy-MM-dd"), "0", "0", date); #endregion int res = MrDBAccess.ExecuteNonQuery(sql); if (res == 0) { return(0); } modifyedEmpList.Add(GetCheckInfo(int.Parse(employeeInfo.EmpID), date)); } //List<CheckInInfo> modifyedEmpList = GetCheckInInfoListNoCalculate(); MonthAttendanceService.Instance.UpdateForAppendSignEmp(modifyedEmpList, true); return(1); }
public string set_Title(EmployeeInfo EmpInfo) { SqlConnection sqlCon = new SqlConnection(conStr); SqlCommand sqlCmd = new SqlCommand("sp_set_Title", sqlCon); sqlCmd.CommandType = CommandType.StoredProcedure; SqlParameter Emp_Title = sqlCmd.Parameters.Add("@Title", SqlDbType.VarChar, 50); Emp_Title.Value = EmpInfo.Title; SqlParameter Emp_TDesc = sqlCmd.Parameters.Add("@TitleDesc", SqlDbType.VarChar, 255); Emp_TDesc.Value = EmpInfo.TitleDesc; SqlParameter Emp_TimeEntry = sqlCmd.Parameters.Add("@TimeEntry", SqlDbType.Char,1); Emp_TimeEntry.Value = EmpInfo.TimeEntry; try { sqlCon.Open(); sqlCmd.ExecuteNonQuery(); sqlCon.Close(); return "Title added successfully .."; } catch (Exception ex) { objNLog.Error("Exception : " + ex.Message); return ex.Message; } }
private XElement BuildViewString(bool isAdminDepartment, string departmentId) { var url = SPContext.Current.Web.Url; EmployeeInfoDAL _employeeInfoDAL = new EmployeeInfoDAL(url); EmployeeInfo currentEmployeeInfo = _employeeInfoDAL.GetByADAccount(SPContext.Current.Web.CurrentUser.ID); XElement filterElement = null; string deptFilterStr = @"<Eq> <FieldRef Name='CommonDepartment' LookupId='TRUE'/> <Value Type='Lookup'>{DepartmentId}</Value> </Eq>"; if (isBOD || isAdminDepartment) { if ((!string.IsNullOrEmpty(departmentId) && departmentId.Trim().Equals("0")) && (isBOD || isAdminDepartment)) { deptFilterStr = @"<IsNotNull> <FieldRef Name='CommonDepartment' /> </IsNotNull>"; } } deptFilterStr = $@"<And> {deptFilterStr} <Eq> <FieldRef Name='CommonLocation' LookupId='TRUE'/> <Value Type='Lookup'>{currentEmployeeInfo.FactoryLocation.LookupId}</Value> </Eq> </And>"; string statusQuery = @"<Gt> <FieldRef Name='ID' /> <Value Type='Counter'>0</Value> </Gt>"; if (!isBOD && isAdminDepartment) { statusQuery = @"<Eq> <FieldRef Name='ApprovalStatus' /> <Value Type='Text'>Approved</Value> </Eq>"; } filterElement = XElement.Parse(@"<And>" + statusQuery + @"<And>" + deptFilterStr + @"<And> <Geq> <FieldRef Name='Created' /> <Value IncludeTimeValue='TRUE' Type='CommonFrom'>{FromDate}</Value> </Geq> <Leq> <FieldRef Name='Created' /> <Value IncludeTimeValue='TRUE' Type='CommonFrom'>{ToDate}</Value> </Leq> </And> </And> </And>"); return(filterElement); }
public String ckRequire2; // 변경 // thay đổi protected void Page_Load(object sender, EventArgs e) { bllSecCardData = new SecCardData(); bllElecApprove = new ElecApprove(); // 로그인 체크 check login EmployeeInfo loginEmployee = new EmployeeInfo(); loginEmployee = (EmployeeInfo)Session["loginMember"]; if (loginEmployee == null) { Response.Redirect("~/login.aspx", true); } // 임직원 정보 보이기 //xem thông tin nhân viên lblDepartment.Text = loginEmployee.Dep_name; lblUpnid.Text = loginEmployee.Upnid; lblOfficeName.Text = loginEmployee.OfficeName; lblDisplayName.Text = loginEmployee.DisplayName; lblTitle.Text = loginEmployee.Title_name; if (loginEmployee.OfficePhoneNumber.Equals(" ")) { if (inOfficePhone.Text.Equals(" ")) { inOfficePhone.Text = ""; } } else { if (inOfficePhone.Text.Equals("")) { inOfficePhone.Text = loginEmployee.OfficePhoneNumber; } } if (Page.IsPostBack) { SecCardDataInfo secCardDataInfo = new SecCardDataInfo(); ElecApproveInfo elecApproveInfo = new ElecApproveInfo(); secCardDataInfo.RegDate = DateTime.Now.ToString("yyyyMMdd"); secCardDataInfo.RequestUserCode = loginEmployee.Upnid; secCardDataInfo.RequestUserName = loginEmployee.DisplayName; secCardDataInfo.RequestDepCode = loginEmployee.Department; secCardDataInfo.RequestDepDesc = loginEmployee.Dep_name; secCardDataInfo.RoleCode = loginEmployee.Title; secCardDataInfo.RoleDesc = loginEmployee.Title_name; secCardDataInfo.OfficePhone = inOfficePhone.Text; secCardDataInfo.Comment = comment.Text; secCardDataInfo.ReqDateFrom = txtStartDate.Text; secCardDataInfo.ReqDateEnd = txtEndDate.Text; secCardDataInfo.Flag = Convert.ToInt32(hiddenflag.Value); secCardDataInfo.ApprovalState = 0; // 신규 mới if (Request.QueryString["mode"].Equals("write")) { approveDocCode = bllSecCardData.GetNewApproveCode(); secCardDataInfo.ElecApproveCode = approveDocCode; elecApproveInfo.ElecApproveCode = approveDocCode; int result = bllSecCardData.insertSecCardData(secCardDataInfo); int result2 = bllElecApprove.insertElecApprove(elecApproveInfo); secCardCode = bllSecCardData.selectMaxCode(); } // 수정 sửa else { secCardDataInfo.SecDataCode = Convert.ToInt32(Request["secCardDataCode"]); int result = bllSecCardData.updateSecCardData(secCardDataInfo); secCardCode = Convert.ToInt32(Request.QueryString["secCardDataCode"]); } Response.Redirect("viewSecCardManager.aspx?secCardDataCode=" + secCardCode, true); } else { // 신규 mới if (Request.QueryString["mode"].Equals("write")) { // 신규 결재 코드 가져오기 approveDocCode = bllSecCardData.GetNewApproveCode(); //ckRequire1 = "checked"; } else { SecCardDataInfo oldSecCardDataInfo = bllSecCardData.selectSecCardData(Request.QueryString["secCardDataCode"]); inOfficePhone.Text = oldSecCardDataInfo.OfficePhone; comment.Text = oldSecCardDataInfo.Comment; txtStartDate.Text = oldSecCardDataInfo.ReqDateFrom; txtEndDate.Text = oldSecCardDataInfo.ReqDateEnd; if (oldSecCardDataInfo.Flag == 1) { ckRequire1 = "checked"; } else { ckRequire2 = "checked"; } } } }
private string encryptkey = "Oyea"; //密钥 #region 执行“目录”控件中的项操作 /// <summary> /// 执行“目录”控件中的项操作 /// </summary> /// <param name="control">控件类型</param> /// <param name="form">所属窗体</param> public void ShowForm(ToolStripMenuItem control, Form form) { switch (control.Tag.ToString()) { case "1": EmployeeInfo employee = new EmployeeInfo(); employee.MdiParent = form; employee.StartPosition = FormStartPosition.CenterScreen; employee.Show(); break; case "2": CompanyInfo company = new CompanyInfo(); company.MdiParent = form; company.StartPosition = FormStartPosition.CenterScreen; company.Show(); break; case "3": Login login = new Login(); login.StartPosition = FormStartPosition.CenterScreen; login.ShowDialog(); form.Dispose(); //释放窗体资源 break; case "5": GoodsIn goodsin = new GoodsIn(); goodsin.MdiParent = form; goodsin.StartPosition = FormStartPosition.CenterScreen; goodsin.Show(); break; case "6": ReGoods regoods = new ReGoods(); regoods.MdiParent = form; regoods.StartPosition = FormStartPosition.CenterScreen; regoods.Show(); break; case "7": GoodsFind stockfind = new GoodsFind(); stockfind.MdiParent = form; stockfind.StartPosition = FormStartPosition.CenterScreen; stockfind.Show(); break; case "8": s sellgoods = new s(); sellgoods.MdiParent = form; sellgoods.StartPosition = FormStartPosition.CenterScreen; sellgoods.Show(); break; case "9": CustomerReGoods customerregoods = new CustomerReGoods(); customerregoods.MdiParent = form; customerregoods.StartPosition = FormStartPosition.CenterScreen; customerregoods.Show(); break; case "10": SellFind sellfind = new SellFind(); sellfind.MdiParent = form; sellfind.StartPosition = FormStartPosition.CenterScreen; sellfind.Show(); break; case "11": ChangeGoods changegoods = new ChangeGoods(); changegoods.MdiParent = form; changegoods.StartPosition = FormStartPosition.CenterScreen; changegoods.Show(); break; case "12": StockAlarm stockalarm = new StockAlarm(); stockalarm.MdiParent = form; stockalarm.StartPosition = FormStartPosition.CenterScreen; stockalarm.Show(); break; case "13": StockFind stockfindall = new StockFind(); stockfindall.MdiParent = form; stockfindall.StartPosition = FormStartPosition.CenterScreen; stockfindall.Show(); break; case "14": EmployeeReport employeereport = new EmployeeReport(); employeereport.MdiParent = form; employeereport.StartPosition = FormStartPosition.CenterScreen; employeereport.Show(); break; case "15": CompanyReport companyreport = new CompanyReport(); companyreport.MdiParent = form; companyreport.StartPosition = FormStartPosition.CenterScreen; companyreport.Show(); break; case "16": GoodsInReport goodsinreport = new GoodsInReport(); goodsinreport.MdiParent = form; goodsinreport.StartPosition = FormStartPosition.CenterScreen; goodsinreport.Show(); break; case "17": GoodsInAnalysisReport sellgodsreport = new GoodsInAnalysisReport(); sellgodsreport.MdiParent = form; sellgodsreport.StartPosition = FormStartPosition.CenterScreen; sellgodsreport.Show(); break; case "18": EmployeeSellReport employeesellreport = new EmployeeSellReport(); employeesellreport.MdiParent = form; employeesellreport.StartPosition = FormStartPosition.CenterScreen; employeesellreport.Show(); break; case "19": GoodsInAnalysisReport goodsinana = new GoodsInAnalysisReport(); goodsinana.MdiParent = form; goodsinana.StartPosition = FormStartPosition.CenterScreen; goodsinana.Show(); break; case "20": SellGoodsAnalysisReport sellana = new SellGoodsAnalysisReport(); sellana.MdiParent = form; sellana.StartPosition = FormStartPosition.CenterScreen; sellana.Show(); break; case "21": SetPopedom setpopedom = new SetPopedom(); setpopedom.MdiParent = form; setpopedom.StartPosition = FormStartPosition.CenterScreen; setpopedom.Show(); break; case "22": ChangePwd changepwd = new ChangePwd(); changepwd.MdiParent = form; changepwd.StartPosition = FormStartPosition.CenterScreen; changepwd.Show(); break; case "23": BakData bakdata = new BakData(); bakdata.MdiParent = form; bakdata.StartPosition = FormStartPosition.CenterScreen; bakdata.Show(); break; case "24": ReBakData rebakdata = new ReBakData(); rebakdata.MdiParent = form; rebakdata.StartPosition = FormStartPosition.CenterScreen; rebakdata.Show(); break; case "25": SysUser sysuser = new SysUser(); sysuser.MdiParent = form; sysuser.StartPosition = FormStartPosition.CenterScreen; sysuser.Show(); break; case "30": CustomerInfo customer = new CustomerInfo(); customer.MdiParent = form; customer.StartPosition = FormStartPosition.CenterScreen; customer.Show(); break; case "31": EmployeeSellAnalysisReport sell = new EmployeeSellAnalysisReport(); sell.MdiParent = form; sell.StartPosition = FormStartPosition.CenterScreen; sell.Show(); break; default: break; } }