public StatementModelBuilder(DAL.Employer employer, bool current, int Yr, int period, int EmployeeId, string empNo, DAL.PayrollItem payrollitem, string Conn)
{
//initialize
if (string.IsNullOrEmpty(Conn))
{
throw new ArgumentNullException("connection");
}
connection = Conn;
db = new SBPayrollDBEntities(connection);
rep = new Repository(connection);
_current = current;
_EmployeeId = EmployeeId;
employee = rep.GetEmployee(_EmployeeId);
_employer = employer;
_ViewModel = new StatementModel();
_payrollitem = payrollitem;
_year = Yr;
_period = period;
itemid = payrollitem.Id;
fileLogo = _employer.Logo;
slogan = _employer.Slogan;
var et = rep.GetEmployeeTxn(employee.EmpNo, _payrollitem.Id);
if (et.Count() > 0)
{
emptxn = et.First();
}
}
public List <EmployeeTransaction> GetDayTransaction(string date)
{
try
{
// string date = DateTime.Now.Date.ToString();
Query = @"SELECT e.Id, e.EmpId, Sum(e.ItemQuentity) as ItemQuentity,CONVERT(varchar, e.CheckDate, 23) as CheckDate,e.CheckTime, a.Name as EmployeeName, d.Name as DivisionName, p.Name as DepartmentName, c.SectionName as SectionName, f.Name as ItemName
FROM EmployeeCafeteriaTransaction e
Inner Join Employee a on a.EmpId = e.EmpId
Inner join Division d on d.id = a.DivisionId
Inner join Department p on p.id = a.DepartmentId
Inner join Section c on c.id = a.SectionId
Inner join FoodItemCost f on f.id = e.FoodItemCostId
WHERE CheckDate='" + date + "'" +
"Group By e.Id, e.EmpId,e.CheckDate,e.CheckTime, a.Name,d.Name,p.Name, c.SectionName, f.Name ";
Command.CommandText = Query;
Command.Connection = Connection;
Connection.Open();
Reader = Command.ExecuteReader();
List <EmployeeTransaction> employeeTransactions = new List <EmployeeTransaction>();
if (Reader.HasRows)
{
while (Reader.Read())
{
EmployeeTransaction employeeTransaction = new EmployeeTransaction();
employeeTransaction.Id = (int)Reader["Id"];
employeeTransaction.EmpId = Reader["EmpId"].ToString();
employeeTransaction.EmployeeName = Reader["EmployeeName"].ToString();
employeeTransaction.Division = Reader["DivisionName"].ToString();
employeeTransaction.Department = Reader["DepartmentName"].ToString();
employeeTransaction.Section = Reader["SectionName"].ToString();
employeeTransaction.ItemName = Reader["ItemName"].ToString();
employeeTransaction.CheckDate = Reader["CheckDate"].ToString();
employeeTransaction.CheckTime = Reader["CheckTime"].ToString();
employeeTransactions.Add(employeeTransaction);
}
}
return(employeeTransactions);
}
catch (Exception exception)
{
return(null);
}
finally
{
Connection.Close();
}
}
public void DeleteNonCashBenefitsEmpTxn(EmployeeTransaction emptn)
{
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (IsEmployeeTransactionValid())
{
try
{
var _employerquery = (from ep in db.Employers
select ep).FirstOrDefault();
DAL.Employer _Employer = _employerquery;
EmployeeTransaction et = new EmployeeTransaction();
decimal _amount;
if (!string.IsNullOrEmpty(txtAmount.Text) && decimal.TryParse(txtAmount.Text, out _amount))
{
et.Amount = decimal.Parse(txtAmount.Text.Trim());
}
et.PostDate = DateTime.Today;
et.EmployeeId = employee.Id;
if (employee.EmpNo != null)
{
et.EmpNo = employee.EmpNo;
}
if (cbItemId.SelectedIndex != -1)
{
et.ItemId = cbItemId.SelectedValue.ToString();
}
et.Recurrent = chkRecurrent.Checked;
et.Processed = false;
et.InitialAmount = 0M;
et.AccumulativePayment = 0M;
et.Enabled = true;
et.TrackYTD = chkTrackYTD.Checked;
et.CreatedBy = _User;
et.LastChangeDate = DateTime.Today;
et.LastChangedBy = _User;
if (_Employer.AuthorizedSignatory != null)
{
et.AuthorizedBy = _Employer.AuthorizedSignatory;
}
et.AuthorizeDate = DateTime.Today;
decimal _YTDAmount;
if (!string.IsNullOrEmpty(txtYTDAmount.Text) && decimal.TryParse(txtYTDAmount.Text, out _YTDAmount))
{
et.Balance = _YTDAmount;
}
et.ShowYTDInPayslip = chkShowYTDinPayslip.Checked;
if (db.EmployeeTransactions.Any(i => i.EmpNo == et.EmpNo && i.ItemId == et.ItemId))
{
MessageBox.Show("Employee Transaction for item \n" + et.ItemId + "Exists!", "SB Payroll", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
if (!db.EmployeeTransactions.Any(i => i.EmpNo == et.EmpNo && i.ItemId == et.ItemId))
{
db.EmployeeTransactions.AddObject(et);
db.SaveChanges();
}
EditEmployee f = (EditEmployee)this.Owner;
f.GridRefresh();
this.Close();
}
catch (Exception ex)
{
Utils.ShowError(ex);
}
}
}
