private void UpdateMonthFixed(FixedAmountItem[] items)
{
UpdateFixItem(items, dgvMonthFix);
}
private void SaveFixAmount(string empId, FixedAmountItem[] monFixitems, FixedAmountItem[] bonusFixitems, SqlTransaction trans)
{
try
{
// delete all.
empDAO.deleteFixAmountByEmpId(trans, empId);
// insert new.
foreach (FixedAmountItem item in monFixitems)
{
item.EmployeeId = empId;
empDAO.addFixAmountItem(trans, item, "N0001");
}
foreach (FixedAmountItem item in bonusFixitems)
{
item.EmployeeId = empId;
empDAO.addFixAmountItem(trans, item, "N0001");
}
}
catch (DAOException)
{
throw;
}
}
private void UpdateFixItem(FixedAmountItem[] items, DataGridView dgv)
{
dgv.Rows.Clear();
foreach (FixedAmountItem item in items)
{
dgv.Rows.Add(new object[3] { item.ItemName, item.ItemValue, item.PayrollItemId});
}
}
private void UpdateBonusFixed(FixedAmountItem[] items)
{
UpdateFixItem(items, dgvBonusFix);
}
private SqlParameter[] BuildFixAmountParam(FixedAmountItem item, string currentUser, bool isInsertOP)
{
List<SqlParameter> paras = new List<SqlParameter>();
paras.Add(new SqlParameter("@EmployeeId", SqlDbType.VarChar, 20));
paras.Add(new SqlParameter("@PayrollItemId",SqlDbType.VarChar,20));
paras.Add(new SqlParameter("@ItemValue",SqlDbType.Float));
paras.Add(new SqlParameter("@UpdateUser", SqlDbType.VarChar, 20));
paras[0].Value = item.EmployeeId;
paras[1].Value = item.PayrollItemId;
paras[2].Value = item.ItemValue;
paras[3].Value = currentUser;
if (isInsertOP)
{
paras.Add(new SqlParameter("@CreateUser", SqlDbType.VarChar, 20));
paras[4].Value = currentUser;
}
return paras.ToArray();
}
public List<FixedAmountItem> getEmpFixedAmountItem(string id, bool bonus)
{
string sqlStr = bonus ?
dbUtil.getSqlStatement("SQL_EMP_BonusFix_SearchByEmpId") :
dbUtil.getSqlStatement("SQL_EMP_MonthFix_SearchByEmpId");
SqlParameter[] sqlParms = {
new SqlParameter("@EmpID",SqlDbType.VarChar,20)
};
sqlParms[0].Value = id;
try
{
List<FixedAmountItem> mfs = new List<FixedAmountItem>();
DataSet searchResult = DAO.DBAccess.ExecuteAdapter(DAO.DBAccess.SQLConnectionString, CommandType.Text, sqlStr, sqlParms);
foreach (DataTable dt in searchResult.Tables)
{
foreach (DataRow dr in dt.Rows)
{
FixedAmountItem mf = new FixedAmountItem();
mf.EmployeeId = id;
mf.PayrollItemId = dr["PayrollItemId"].ToString();
mf.ItemName = dr["ItemName"].ToString();
mf.ItemValue = Convert.ToDouble(dr["ItemValue"]);
mfs.Add(mf);
}
}
return mfs;
}
catch (Exception ex)
{
throw new DAOException("E0001", ex);
}
}
public int addFixAmountItem(SqlTransaction trans, FixedAmountItem item, string currentUser)
{
string sqlStr = dbUtil.getSqlStatement("SQL_EMP_FixAmount_Insert");
SqlParameter[] sqlParms = BuildFixAmountParam(item, currentUser, true);
try
{
return (int)DAO.DBAccess.ExecuteNonQuery(trans, CommandType.Text, sqlStr, sqlParms);
}
catch (Exception ex)
{
throw new DAOException("E0001", ex);
}
}