public bool UpdateHR_SalaryStucture(HR_SalaryStucture hR_SalaryStucture)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("UpdateHR_SalaryStucture", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@SalaryStructureID", SqlDbType.Int).Value = hR_SalaryStucture.SalaryStructureID;
cmd.Parameters.Add("@SalaryStuctureName", SqlDbType.NVarChar).Value = hR_SalaryStucture.SalaryStuctureName;
cmd.Parameters.Add("@Basic", SqlDbType.Decimal).Value = hR_SalaryStucture.Basic;
cmd.Parameters.Add("@HouseRent", SqlDbType.Decimal).Value = hR_SalaryStucture.HouseRent;
cmd.Parameters.Add("@Others", SqlDbType.Decimal).Value = hR_SalaryStucture.Others;
cmd.Parameters.Add("@Total", SqlDbType.Decimal).Value = hR_SalaryStucture.Total;
cmd.Parameters.Add("@EmployeeID", SqlDbType.NVarChar).Value = hR_SalaryStucture.EmployeeID;
cmd.Parameters.Add("@EmployeeID", SqlDbType.NVarChar).Value = hR_SalaryStucture.EmployeeID;
cmd.Parameters.Add("@EmployeeID", SqlDbType.NVarChar).Value = hR_SalaryStucture.EmployeeID;
cmd.Parameters.Add("@ModifiedBy", SqlDbType.NVarChar).Value = hR_SalaryStucture.ModifiedBy;
cmd.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = hR_SalaryStucture.ModifiedDate;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public HR_SalaryStucture GetHR_SalaryStuctureFromReader(IDataReader reader)
{
try
{
HR_SalaryStucture hR_SalaryStucture = new HR_SalaryStucture
(
DataAccessObject.IsNULL<int>(reader["SalaryStructureID"]),
DataAccessObject.IsNULL<string>(reader["SalaryStuctureName"]),
DataAccessObject.IsNULL<decimal>(reader["Basic"]),
DataAccessObject.IsNULL<decimal>(reader["HouseRent"]),
DataAccessObject.IsNULL<decimal>(reader["Others"]),
DataAccessObject.IsNULL<decimal>(reader["Total"]),
DataAccessObject.IsNULL<string>(reader["EmployeeID"].ToString()),
DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]),
DataAccessObject.IsNULL<string>(reader["ModifiedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["ModifiedDate"])
);
return hR_SalaryStucture;
}
catch(Exception ex)
{
return null;
}
}
