public void addSalaryDetails(worker.empSalary eSalary)
{
SqlCommand cmd = new SqlCommand();
try
{
cmd.CommandText = "saveEmpSalaryDetails";
cmd.Connection = utility.getConn();
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@id", eSalary.ID);
cmd.Parameters.AddWithValue("@empid", recid);
cmd.Parameters.AddWithValue("@paygradeid", eSalary.pay_grade.ID);
cmd.Parameters.AddWithValue("@freq", eSalary.freq);
cmd.Parameters.AddWithValue("@currency", eSalary.currency);
cmd.Parameters.AddWithValue("@amount", eSalary.amount);
cmd.Parameters.AddWithValue("@reason", eSalary.reason);
cmd.Parameters.AddWithValue("@recDate", eSalary.recDate);
cmd.Parameters.AddWithValue("@comment", eSalary.comment);
cmd.Parameters.AddWithValue("@vehAllow", eSalary.vehAllow);
cmd.Parameters.AddWithValue("@liveAllow", eSalary.liveAllow);
cmd.Parameters.AddWithValue("@gasAllow", eSalary.gasAllow);
cmd.Connection.Open();
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw new Exception("Error occurred:" + ex.Message);
}
finally
{
cmd.Connection.Close();
}
}
public List <worker.empSalary> salaryHistory()
{
List <worker.empSalary> salHistory = new List <worker.empSalary>();
SqlCommand cmd = new SqlCommand();
try
{
cmd.Connection = utility.getConn();
cmd.Connection.Open();
cmd.CommandText = "select * from view_empSalary where empid=" + recid + " order by ID DESC";
SqlDataReader dbread = cmd.ExecuteReader();
while (dbread.Read())
{
worker.empSalary tmp = new worker.empSalary();
tmp.ID = Convert.ToInt32(dbread["ID"]);
tmp.amount = Convert.ToDouble(dbread["payamt"]);
tmp.comment = Convert.ToString(dbread["comment"]);
tmp.currency = Convert.ToString(dbread["currency"]);
tmp.freq = Convert.ToString(dbread["payfreq"]);
tmp.pay_grade.name = Convert.ToString(dbread["paygrade"]);
tmp.reason = Convert.ToString(dbread["reason"]);
tmp.recDate = Convert.ToDateTime(dbread["datein"]);
// tmp = Convert.ToString(dbread["reason"]);
// active = Convert.ToBoolean(dbread["active"]);
salHistory.Add(tmp);
}
dbread.Close();
}
finally
{
cmd.Connection.Close();
}
return(salHistory);
}