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