private void processProfile(DataRow dr)
{
if (dr["fld_name"].ToString().ToUpper().Equals("MARITAL_STATUS"))
{
Data.update_marital_status(ViewState["EE_Number"].ToString(), dr["Proposed"].ToString(), ViewState["User_Name"].ToString());
}
else if (dr["fld_name"].ToString().ToUpper().Equals("BIRTH_DATE"))
{
Data.update_DOB(ViewState["EE_Number"].ToString(), dr["Proposed"].ToString(), ViewState["User_Name"].ToString());
}
else
{
string sql = "update eeprofile_ set [fld_name] = '[fls_value]', maintenance_userid = '[user]', maintenance_date_time = sysdate where employee_number = [eeno]";
sql = sql.Replace("[fld_name]", dr["fld_name"].ToString());
sql = sql.Replace("[fls_value]", dr["Proposed"].ToString());
sql = sql.Replace("[user]", ViewState["User_Name"].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();
}