private void processdisapproveAddress(DataRow dr)
{
string sql = "update pending_emplyee_address set [fld_name] = '~[fls_value]' where employee_number = [eeno]";
sql = sql.Replace("[fld_name]", dr["fld_name"].ToString());
sql = sql.Replace("[fls_value]", dr["Proposed"].ToString());
sql = sql.Replace("[eeno]", ViewState["EE_Number"].ToString());
SQLStatic.SQL.ExecScaler(sql);
if (GetData().Rows.Count.Equals(0))
{
Data.processes_profile_address(ViewState["EE_Number"].ToString(), ViewState["User_Name"].ToString());
drawEEGrid();
AutoSelect();
}
DrawProfile();
}