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);
}
