示例#1
0
    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();
        }
    }
示例#2
0
    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);
    }