static void Main(string[] args) { try { var employee = new MEmployee { Run = IMock.RunType.SUCCESS, Arrange = IMock.RunType.SUCCESS, Test = IMock.RunType.SUCCESS, Assert = IMock.RunType.SUCCESS }; var employee2 = new MEmployee { Run = IMock.RunType.EXCEPTION, Exception = new Exception("Employee Error"), Throws = IMock.RunType.EXCEPTION, Arrange = IMock.RunType.EXCEPTION, Test = IMock.RunType.EXCEPTION, Assert = IMock.RunType.EXCEPTION }; } catch (Exception e) { Console.WriteLine(e.Message); } Console.ReadLine(); }
private void SaveCommission(TTransDet det, decimal?commission, string employeeId, EnumCommissionPeople commissionPeople) { //search employee commission MEmployee emp = _mEmployeeRepository.Get(employeeId); string typeCommission = EnumCommissionType.Fix.ToString(); decimal? commissionVal = commission; MActionComm actionComm = _mActionCommRepository.GetByEmployeeAndAction(emp, det.ActionId); if (actionComm != null) { typeCommission = actionComm.ActionCommType; commissionVal = actionComm.ActionCommVal; if (typeCommission == EnumCommissionType.Percent.ToString()) { commission = det.TransDetTotal.Value * (commissionVal / 100); } else { commission = commissionVal; } } TCommission comm = new TCommission(det); comm.SetAssignedIdTo(Guid.NewGuid().ToString()); comm.EmployeeId = emp; comm.CommissionType = commissionPeople.ToString(); comm.CommissionValue = commission; comm.CreatedDate = DateTime.Now; comm.CreatedBy = User.Identity.Name; comm.DataStatus = EnumDataStatus.New.ToString(); _tCommissionRepository.Save(comm); }
public override void Run() { try { Msg("MEmployee - OK"); var employee = new MEmployee { Run = IMock.RunType.SUCCESS, Arrange = IMock.RunType.SUCCESS, Test = IMock.RunType.SUCCESS, Assert = IMock.RunType.SUCCESS }; Msg("MEmployee - ERROR"); var employee2 = new MEmployee { Run = IMock.RunType.EXCEPTION, ExceptionExpected = new Exception("Employee Error"), Throws = IMock.RunType.EXCEPTION, Arrange = IMock.RunType.EXCEPTION, Test = IMock.RunType.EXCEPTION, Assert = IMock.RunType.EXCEPTION }; } catch (Exception e) { Console.WriteLine(e.Message); } }
public bool InsertIntoEmployee(MEmployee emp) { StringBuilder sb = new StringBuilder(); sb.Append("insert into tb_employee (name,sex,birthday,learnDegree,post,dept,job,tel,address,email,state,photoPath) values(@EmpName,@Sex,@Birthday,@LearnDegree,@Post,@Department,@Job,@Tel,@Address,@Email,@State,@PhotoPath)"); SqlParameter[] param = { SQLDbHelper.GetParameter("@EmpName", SqlDbType.VarChar, 20, "name", emp.Name), SQLDbHelper.GetParameter("@Sex", SqlDbType.VarChar, 10, "sex", emp.Sex), SQLDbHelper.GetParameter("@Birthday", SqlDbType.SmallDateTime, "birthday", emp.Birthday), SQLDbHelper.GetParameter("@LearnDegree", SqlDbType.VarChar, 50, "learnDegree", emp.LearnDegree), SQLDbHelper.GetParameter("@Post", SqlDbType.VarChar, 50, "post", emp.Post), SQLDbHelper.GetParameter("@Department", SqlDbType.VarChar, 50, "dept", emp.Dept), SQLDbHelper.GetParameter("@Job", SqlDbType.VarChar, 50, "job", emp.Job), SQLDbHelper.GetParameter("@Tel", SqlDbType.VarChar, 50, "tel", emp.Tel), SQLDbHelper.GetParameter("@Address", SqlDbType.VarChar, 50, "address", emp.Address), SQLDbHelper.GetParameter("@Email", SqlDbType.VarChar, 50, "email", emp.Email), SQLDbHelper.GetParameter("@State", SqlDbType.VarChar, 50, "state", emp.State), SQLDbHelper.GetParameter("@PhotoPath", SqlDbType.VarChar, 50, "photoPath", emp.PhotoPath) }; bool is_succeed = SQLDbHelper.ExecuteSql(sb.ToString(), param); if (is_succeed) { return(true); } else { return(false); } }
private void mnuContextMenu_Click(object sender, RoutedEventArgs e) { MenuItem mnu = (sender as MenuItem); string name = mnu.Name; if (name.Equals("mnuEdit")) { showEditWindow(); } else if (name.Equals("mnuCopy")) { CUtil.EnableForm(false, ParentControl); CTable newobj = OnixWebServiceAPI.CopyEmployee(currentObj.GetDbObject()); if (newobj != null) { MEmployee ivd = new MEmployee(newobj); itemSources.Insert(0, ivd); } else { //Error here CHelper.ShowErorMessage(OnixWebServiceAPI.GetLastErrorDescription(), "ERROR_USER_ADD", null); } CUtil.EnableForm(true, ParentControl); } }
public bool UpdateEmployeeByID(MEmployee emp) { StringBuilder sb = new StringBuilder(); sb.Append("update tb_employee set name=@EmpName,sex=@Sex,birthday=@Birthday,"); sb.Append("learnDegree=@LearnDegree,post=@Post,dept=@Department,job=@Job,tel=@Tel,"); sb.Append("address=@Address,email=@Email,state=@State where ID=@ID"); SqlParameter[] param = { SQLDbHelper.GetParameter("@ID", SqlDbType.Int, 4, "ID", emp.ID), SQLDbHelper.GetParameter("@EmpName", SqlDbType.VarChar, 20, "name", emp.Name), SQLDbHelper.GetParameter("@Sex", SqlDbType.VarChar, 10, "sex", emp.Sex), SQLDbHelper.GetParameter("@Birthday", SqlDbType.SmallDateTime, "birthday", emp.Birthday), SQLDbHelper.GetParameter("@LearnDegree", SqlDbType.VarChar, 50, "learnDegree", emp.LearnDegree), SQLDbHelper.GetParameter("@Post", SqlDbType.VarChar, 50, "post", emp.Post), SQLDbHelper.GetParameter("@Department", SqlDbType.VarChar, 50, "dept", emp.Dept), SQLDbHelper.GetParameter("@Job", SqlDbType.VarChar, 50, "job", emp.Job), SQLDbHelper.GetParameter("@Tel", SqlDbType.VarChar, 50, "tel", emp.Tel), SQLDbHelper.GetParameter("@Address", SqlDbType.VarChar, 50, "address", emp.Address), SQLDbHelper.GetParameter("@Email", SqlDbType.VarChar, 50, "email", emp.Email), SQLDbHelper.GetParameter("@State", SqlDbType.VarChar, 50, "state", emp.State) }; bool is_succeed = SQLDbHelper.ExecuteSql(sb.ToString(), param); if (is_succeed) { return(true); } else { return(false); } }
public override Tuple <CTable, ObservableCollection <MBaseModel> > QueryData() { MEmployee em = (MEmployee)model; em.EmployeeType = employeeType; items = OnixWebServiceAPI.GetEmployeeList(model.GetDbObject()); lastObjectReturned = OnixWebServiceAPI.GetLastObjectReturned(); itemSources.Clear(); int idx = 0; foreach (CTable o in items) { MEmployee v = new MEmployee(o); v.RowIndex = idx; itemSources.Add(v); idx++; } Tuple <CTable, ObservableCollection <MBaseModel> > tuple = new Tuple <CTable, ObservableCollection <MBaseModel> >(lastObjectReturned, itemSources); return(tuple); }
public IActionResult DeleteView(int id) { //self written code. need to cover delete of photo too. MEmployee deletedEmployee = _emp_repository.DeleteEmployee(id); return(RedirectToAction("listview")); }
public static InstallmentPaymentFormViewModel Create(ITInstallmentRepository installmentRepository, IMEmployeeRepository mEmployeeRepository, string loanCode) { installmentRepository.DbContext.BeginTransaction(); InstallmentPaymentFormViewModel viewModel = new InstallmentPaymentFormViewModel(); TInstallment ins = installmentRepository.GetLastInstallment(loanCode); if (ins == null) { ins = new TInstallment(); } viewModel.installment = ins; viewModel.installment.InstallmentPaymentDate = DateTime.Today; installmentRepository.DbContext.RollbackTransaction(); var listEmployee = mEmployeeRepository.GetEmployeeByDept(EnumDepartment.COL.ToString()); MEmployee employee = new MEmployee(); //mCustomer.SupplierName = "-Pilih Supplier-"; listEmployee.Insert(0, employee); var collector = from emp in listEmployee //where emp.DepartmentId.DepartmentName == "COLLECTOR" select new { Id = emp.Id, Name = emp.PersonId != null ? emp.PersonId.PersonName : "-Pilih Kolektor-" }; viewModel.CollectorList = new SelectList(collector, "Id", "Id", string.Empty); return(viewModel); }
public async Task <IActionResult> OnPostEditAsync(MEmployee item1) { try { if (!TryValidateModel(item1)) { return(BadRequest(ModelState)); } var user = await _userManager.GetUserAsync(User); item1.UpdatedBy = user.Id; item1.UpdatedDate = DateTime.Now; await _mEmployeeService.EditAsync(item1); var employees = await _mEmployeeService.GetAllAsync(); return(Partial("MEmployeePartials/_MEmployeeViewListPartial", employees)); } catch (Exception ex) { _logger.LogError("Error occured : {@ex}", ex); return(BadRequest(ex.Message)); } }
public static AcquittanceViewModel Create(ITLoanRepository loanRepository, IMEmployeeRepository mEmployeeRepository, string loanCode) { AcquittanceViewModel viewModel = new AcquittanceViewModel(); TLoan loan = loanRepository.GetLoanByLoanCode(loanCode); viewModel.BasicPrice = loan.LoanBasicPrice; viewModel.CreditPrice = loan.LoanCreditPrice; viewModel.Installment = loan.LoanBasicInstallment; viewModel.LoanTenor = loan.LoanTenor; viewModel.PaidInstallment = (loan.Installments).Where(x => x.InstallmentStatus == EnumInstallmentStatus.Paid.ToString()).Count(); viewModel.RequiredInstallment = Math.Ceiling(loan.LoanTenor.Value * 0.75m); viewModel.RequiredInstallmentTotal = (viewModel.RequiredInstallment - viewModel.PaidInstallment) * viewModel.Installment; viewModel.LoseSort = viewModel.LoanTenor - viewModel.RequiredInstallment; viewModel.LoseSortTotal = viewModel.LoseSort * (viewModel.CreditPrice / viewModel.LoanTenor); viewModel.Provision = viewModel.LoseSortTotal.Value * 0.1m; viewModel.MustPaid = viewModel.RequiredInstallmentTotal + viewModel.LoseSortTotal + viewModel.Provision; var listEmployee = mEmployeeRepository.GetEmployeeByDept(EnumDepartment.COL.ToString()); MEmployee employee = new MEmployee(); listEmployee.Insert(0, employee); var collector = from emp in listEmployee select new { Id = emp.Id, Name = emp.PersonId != null ? emp.PersonId.PersonName : "-Pilih Kolektor-" }; viewModel.CollectorList = new SelectList(collector, "Id", "Id", string.Empty); return(viewModel); }
public IList <TAbsent> GetAbsentByEmployeeId(MEmployee employeeId, DateTime?dayWork) { StringBuilder sql = new StringBuilder(); sql.AppendLine(@" select ta from TAbsent as ta"); if (employeeId != null) { sql.AppendLine( @" where ta.EmployeeId = :employeeId"); } if (dayWork.HasValue) { sql.AppendLine( @" and (ta.AbsentDate = :dayWork)"); } IQuery q = Session.CreateQuery(sql.ToString()); q.SetEntity("employeeId", employeeId); if (dayWork.HasValue) { q.SetDateTime("dayWork", dayWork.Value); } return(q.List <TAbsent>()); }
private void bindingNavigatorSaveItem_Click(object sender, EventArgs e) { if (!ValidateForm()) { return; } if (employeeIdTextBox.Enabled == true) { emp = new MEmployee(); } else { emp = (MEmployee)DataMaster.GetObjectById(typeof(MEmployee), employeeIdTextBox.Text); } emp.DepId = depIdComboBox.SelectedValue.ToString(); emp.EmployeeDesc = employeeDescTextBox.Text; emp.EmployeeDesc2 = employeeDesc2TextBox.Text; emp.EmployeeAddress = employeeAddressTextBox.Text; emp.EmployeeBirthDate = employeeBirthDateDateTimePicker.Value; emp.EmployeeBirthPlace = employeeBirthPlaceTextBox.Text; emp.EmployeeGender = employeeGenderComboBox.SelectedItem.ToString(); emp.EmployeeId = employeeIdTextBox.Text; emp.EmployeeIdCard = employeeIdCardTextBox.Text; emp.EmployeeMaritalStatus = employeeMaritalStatusComboBox.SelectedItem.ToString(); emp.EmployeeName = employeeNameTextBox.Text; emp.EmployeePhone = employeePhoneTextBox.Text; emp.EmployeeStartWork = employeeStartWorkDateTimePicker.Value; emp.EmployeeStatus = employeeStatusComboBox.SelectedItem.ToString(); emp.ModifiedBy = lbl_UserName.Text; emp.ModifiedDate = DateTime.Now; if (employeeIdTextBox.Enabled == true) { try { DataMaster.SavePersistence(emp); } catch (NHibernate.NonUniqueObjectException) { RecreateBalloon(); balloonHelp.Caption = "Validasi data kurang"; balloonHelp.Content = "Karyawan dengan kode " + employeeIdTextBox.Text + " sudah pernah diinput, silahkan input dengan kode yang lain"; balloonHelp.ShowBalloon(employeeIdTextBox); employeeIdTextBox.Focus(); return; } ModuleControlSettings.SaveLog(ListOfAction.Insert, employeeIdTextBox.Text, ListOfTable.MEmployee, lbl_UserName.Text); } else { DataMaster.UpdatePersistence(emp); ModuleControlSettings.SaveLog(ListOfAction.Update, employeeIdTextBox.Text, ListOfTable.MEmployee, lbl_UserName.Text); } BindData(); }
public UFormEmployeeWithholdingTax(MBaseModel model, int page, int issue, int totalPage, MReportConfig cfg, CReportPageParam param) { if (model == null) { model = new MEmployee(new Wis.WsClientAPI.CTable("")); } dataSource = model; pageNo = page; pageCount = totalPage; pageParam = param; rptConfig = cfg; issueCout = issue; init(); MEmployee ad = (dataSource as MEmployee); numberTextAmount = ad.EmployeeTax.TaxAmount; primaryColumns.Clear(); primaryColumns.Add(new GridLength(70, GridUnitType.Star)); primaryColumns.Add(new GridLength(14, GridUnitType.Star)); primaryColumns.Add(new GridLength(13, GridUnitType.Star)); primaryColumns.Add(new GridLength(13, GridUnitType.Star)); DataContext = model; InitializeComponent(); }
private void populateSalary() { if (isInLoad) { return; } if (mv.EmployeeID.Equals("")) { return; } String empID = mv.EmployeeID; CTable dat = new CTable(""); dat.SetFieldValue("EMPLOYEE_ID", empID); CUtil.EnableForm(false, this); CTable empObj = OnixWebServiceAPI.SubmitObjectAPI("GetEmployeeInfo", dat); CUtil.EnableForm(true, this); MEmployee emp = new MEmployee(empObj); mv.ReceiveIncome = emp.Salary; }
//FOR IN-MEMORY //public IActionResult Createview(MEmployee employee) //{ // if (ModelState.IsValid) // { // MEmployee newemployee = _emp_repository.AddEmployee(employee); // return RedirectToAction("detailsview", new { id = newemployee.EmpID }); // } // return View(); //} //FOR SQL public IActionResult Createview(EmployeeCreateViewModel model) { if (ModelState.IsValid) { string uniquefilename = null; if (model.Photo != null) { string uploadFolderPath = ProcessUploadedFile(model); uniquefilename = uploadFolderPath; //string uploadFolderPath = Path.Combine(_hostEnvironment.WebRootPath, "uploads"); //uniquefilename = Guid.NewGuid().ToString() + "-" + model.Photo.FileName; //string filepath = Path.Combine(uploadFolderPath, uniquefilename); //model.Photo.CopyTo(new FileStream(filepath, FileMode.Create)); } MEmployee newemployee = new MEmployee { Name = model.Name, Email = model.Email, Dept = model.Dept, PhotoPath = uniquefilename }; _emp_repository.AddEmployee(newemployee); return(RedirectToAction("detailsview", new { id = newemployee.EmpID })); } return(View()); }
public IList <TAbsent> GetAbsentByEmployeeId(MEmployee employeeId) { ICriteria criteria = Session.CreateCriteria(typeof(TAbsent)) .Add(Expression.Eq("EmployeeId", employeeId)); return(criteria.List <TAbsent>()); }
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { try { objdept.ID = Convert.ToInt32(this.GridView1.DataKeys[e.RowIndex].Value); DataTable dtDept = dept.SelectDepartmentByID(objdept); employee emp = new employee(); MEmployee objemp = new MEmployee(); objemp.Dept = dtDept.Rows[0]["name"].ToString(); DataTable dtEmp = emp.SelectEmployeeByDept(objemp); if (dtEmp.Rows.Count > 0) { string myscript = @"alert('此部门内尚有员工,不能删除!');"; Page.ClientScript.RegisterStartupScript(this.GetType(), "myscript", myscript, true); } else { dept.DeleteDepartmentByID(objdept); } GridView1.DataSource = dept.SelectAllDepartment(); GridView1.DataBind(); } catch (Exception ex) { this.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + ex.Message + "');</script>"); } }
private void cmdTaxReport_Click(object sender, RoutedEventArgs e) { bool result = CHelper.ValidateTextBox(lblEmployeeTax, txtTaxYear, false); if (!result) { return; } MEmployee emp = vw as MEmployee; CTable dat = emp.GetDbObject().CloneAll(); dat.SetFieldValue("TAX_YEAR", txtTaxYear.Text); dat.SetFieldValue("EMPLOYEE_ID", emp.EmployeeID); CTable obj = OnixWebServiceAPI.SubmitObjectAPI("GetEmployeeTaxYearSummary", dat); ArrayList arr = obj.GetChildArray("EMPLOYEE_YEARLY_SUMMARY"); emp.EmployeeTax.TaxYear = txtTaxYear.Text; if (arr.Count > 0) { CTable o = (CTable)arr[0]; emp.EmployeeTax.TaxAmount = o.GetFieldValue("DEDUCT_TAX"); emp.EmployeeTax.RevenueAmount = o.GetFieldValue("RECEIVE_AMOUNT"); emp.EmployeeTax.SocialInsuranceAmount = o.GetFieldValue("DEDUCT_SOCIAL_SECURITY"); } WinFormPrinting w = new WinFormPrinting("grpHRTax", emp); w.ShowDialog(); }
private void ConvertToEmployee(EmployeeViewModel custVM, MEmployee cust) { cust.EmployeeName = custVM.EmployeeName; cust.EmployeePhone = custVM.EmployeePhone; cust.EmployeeAddress = custVM.EmployeeAddress; cust.EmployeeJoinDate = custVM.EmployeeJoinDate; cust.EmployeeBasicSalary = custVM.EmployeeBasicSalary; cust.EmployeeDailyAllowance = custVM.EmployeeDailyAllowance; }
private void TransferFormValuesTo(MEmployee mEmployeeToUpdate, MEmployee mEmployeeFromForm) { mEmployeeToUpdate.DepartmentId = mEmployeeFromForm.DepartmentId; mEmployeeToUpdate.EmployeeStatus = mEmployeeFromForm.EmployeeStatus; mEmployeeToUpdate.EmployeeDesc = mEmployeeFromForm.EmployeeDesc; mEmployeeToUpdate.EmployeeCommissionProductType = mEmployeeFromForm.EmployeeCommissionProductType; mEmployeeToUpdate.EmployeeCommissionProductVal = mEmployeeFromForm.EmployeeCommissionProductVal; mEmployeeToUpdate.EmployeeCommissionServiceType = mEmployeeFromForm.EmployeeCommissionServiceType; mEmployeeToUpdate.EmployeeCommissionServiceVal = mEmployeeFromForm.EmployeeCommissionServiceVal; }
public void Test1() { var employee = new MEmployee { Run = IMock.RunType.SUCCESS, Arrange = IMock.RunType.SUCCESS, Test = IMock.RunType.SUCCESS, Assert = IMock.RunType.SUCCESS }; }
public void Update(int id, MEmployee item) { var entity = _context.Emp.Find(id); if (entity == null) { return; } _context.Entry(entity).CurrentValues.SetValues(item); _context.SaveChanges(); }
public ActionResult InsertOrUpdate(MEmployee viewModel, FormCollection formCollection) { if (formCollection["oper"].Equals("add")) { return(Insert(viewModel, formCollection)); } else if (formCollection["oper"].Equals("edit")) { return(Update(viewModel, formCollection)); } return(View()); }
private void updateOtRate() { CUtil.EnableForm(false, this); CTable newobj = OnixWebServiceAPI.SubmitObjectAPI("GetEmployeeInfo", vw.GetDbObject()); if (newobj != null) { MEmployee emp = new MEmployee(newobj); mv.OtRate = emp.HourRate; } CUtil.EnableForm(true, this); }
public async Task <IList <MEmployee> > GetAsync(MEmployee entity) { _logger.LogInformation("Employees data is being data collected based on search"); var result = await _dbContext.MEmployees .Include(item => item.MCompany_Navigation) .Include(item => item.CreatedBy_Navigation) .Where(item => EF.Functions.Like(item.Code, $"%{entity.Code}%")) .ToListAsync(); return(result); }
private void bindingNavigatorDeleteItem_Click(object sender, EventArgs e) { if (!string.IsNullOrEmpty(employeeIdTextBox.Text.Trim())) { if (MessageBox.Show("Anda yakin menghapus data?", "Konfirmasi Hapus Data", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK) { emp = (MEmployee)DataMaster.GetObjectById(typeof(MEmployee), employeeIdTextBox.Text); DataMaster.Delete(emp); BindData(); } } }
private static SelectList GetEmployeeList() { IMEmployeeRepository mEmployeeRepository = new MEmployeeRepository(); IList <MEmployee> listEmployee = mEmployeeRepository.GetAll(); MEmployee employee = new MEmployee(); listEmployee.Insert(0, employee); var emps = from emp in listEmployee select new { Id = emp.Id, Name = emp.PersonId != null ? emp.PersonId.PersonName : "-Pilih Salesman-" }; return(new SelectList(emps, "Id", "Name")); }
public DataTable SelectEmployeeByDept(MEmployee emp) { StringBuilder sb = new StringBuilder(); sb.Append("select * from tb_employee where dept=@Dept"); SqlParameter[] param = { SQLDbHelper.GetParameter("@Dept", SqlDbType.VarChar, 50, "dept", emp.Dept) }; DataTable dt = SQLDbHelper.ExecuteDt(sb.ToString(), param); return(dt); }
public DataTable SelectEmployeeByID(MEmployee emp) { StringBuilder sb = new StringBuilder(); sb.Append("select * from tb_employee where ID=@ID"); SqlParameter[] param = { SQLDbHelper.GetParameter("@ID", SqlDbType.Int, 4, "ID", emp.ID) }; DataTable dt = SQLDbHelper.ExecuteDt(sb.ToString(), param); return(dt); }