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