asp code for directory edit

telephone_directory1.asp


<br /><!--#include file="../DATABASE_MODULE/openMyconn.inc"--> <br /><!--#include file="tm_security.inc"--> <br /><!--#include file="../includes/common_functions.inc"--> <br /><% <br /> <br />THIS_FILE_NAME="telephone_directory1.asp" <br />ACTION_FILE_NAME="telephone_directory2.asp" <br />PRIMARY_KEY="user_name" <br />PRIMARY_KEY_VALUE=REQUEST(PRIMARY_KEY) <br />POSTBACK_PRIMARY_KEY="postback_user_name" <br />JOB=REQUEST("JOB") <br />%> <br /><html> <br /><head> <br /><link href="../style_sheet_module/current_style.css" rel="stylesheet"> <br /><meta NAME="GENERATOR" Content="Microsoft Visual Studio 6.0"> <br /><!--#include file="../includes/magicGrid_javascript.inc"--> <br /></head> <br /><body topmargin=0 leftmargin=0> <br /><%banner_institute_variable="Update STAFF DATA"%> <br /><!--#include file="../includes/banner_institute.inc"--> <br /><%select_month_institute_faculty_variable="close_popup"%> <br /><!--#include file="../includes/select_institute_faculty_close.inc"--> <br /><!--#include file="../includes/alert_result_msg.inc"--> <br /> <br /><script> <br />function validate() <br />{ <br /> var isValidatedMailID=validate_mailID('document.magicgrid.email_add'); <br /> if (isValidatedMailID==false) <br /> { <br /> return false; <br /> } <br /> return true; <br />} <br /></script> <br /> <br /> <br /><form name="magicgrid" method="Post" action="<%=ACTION_FILE_NAME%>"> <br /><input type="hidden" name="job" value="<%=request("job")%>"> <br /><input type="hidden" name="<%=PRIMARY_KEY%>" value=""> <br /><% <br />'''''''''''''''''''''''''''''''''''''''''''''' <br />inst=request("selected_c_institute_cd") <br />if inst="" then <br />inst=session("inst") <br />end if <br />if inst="" then <br />inst=session("c_institute_cd") <br />end if <br />session("inst")=inst <br /> <br />if inst="" or inst="ALL" then <br />INSTITUTE_CONDITION="" <br />else <br />INSTITUTE_CONDITION=" and u.c_institute_cd='"&inst&"'" <br />end if <br />''''''''''''''''''''''''''''''''''''''''''''' <br />'''''''''''''''''''''''''''''''''''''''''''''' <br />selected_faculty=request("selected_faculty") <br />if selected_faculty="" then <br />selected_faculty=session("selected_faculty") <br />end if <br />session("selected_faculty")=selected_faculty <br />if selected_faculty="" or selected_faculty="ALL" then <br />FACULTY_CONDITION="" <br />else <br />FACULTY_CONDITION=" and u.faculty='"&selected_faculty&"'" <br />end if <br />''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' <br /> <br />order_by=request("order_by") <br />if order_by="" then <br />order_by="name" <br />end if <br />session("order_by")=order_by <br />ORDER_BY_CONDITION=" order by " & order_by <br />%> <br /> <% <br /> if Request(PRIMARY_KEY)<>"" and Request("job")="edit" then <br /> set objRsEDIT=Myconn.execute("select * from master_user_account where user_name='"& PRIMARY_KEY_VALUE&"' and c_institute_cd='" & session("c_institute_cd")& "'") <br /> if not objRsEDIT.eof then%> <br /> <table align=center bgcolor=pink border=1 cellspacing=0> <br /> <tr> <br /> <td class="ctms_red" colspan=2> <br /> Edit Form </td> <br /> </tr> <br /> <tr> <br /> <td class="ctms_very_small">Staff Name </td> <br /> <td class="ctms_very_small"><%=objRsEDIT("NAME")%></td> <br /> </tr> <br /> <tr> <br /> <td class="ctms_very_small">Designation</td> <br /> <td class="ctms_very_small"><%=objRsEDIT("Designation")%></td> <br /> </tr> <br /> <tr> <br /> <td class="ctms_very_small">Faculty</td> <br /> <td class="ctms_very_small"><%=objRsEDIT("faculty")%></td> <br /> </tr> <br /> <tr> <br /> <td class="ctms_very_small">Post eg.SDE(SWG)</td> <br /> <td class="ctms_very_small"><input type=text name="post" value="<%=objRsEDIT("Post")%>" size=15 class="ctms_mand"></td> <br /> </tr> <br /> <tr> <br /> <td class="ctms_very_small">Office Phone No</td> <br /> <td class="ctms_very_small"><input type=text name="tele_no_off" value="<%=objRsEDIT("tele_no_off")%>" size=15 class="ctms_mand"></td> <br /> </tr> <br /> <tr> <br /> <td class="ctms_very_small">Residence Phone No</td> <br /> <td class="ctms_very_small"><input type=text name="tele_no_res" value="<%=objRsEDIT("tele_no_res")%>" size=15 class="ctms_mand"></td> <br /> </tr> <br /> <tr> <br /> <td class="ctms_very_small">Mobile Phone No</td> <br /> <td class="ctms_very_small"><input type=text name="mobile_no" value="<%=objRsEDIT("mobile_no")%>" size=15 class="ctms_mand"></td> <br /> </tr> <br /> <tr> <br /> <td class="ctms_very_small">Email ID</td> <br /> <td class="ctms_very_small"><input type=text name="email_add" value="<%=objRsEDIT("email_add")%>" size=15 class="ctms_mand"></td> <br /> </tr> <br /> <tr> <br /> <td colspan=2 align=center class="ctms_very_small"> <br /> <img src="../images/save_small.gif" alt="Save" border="0" onClick="fnSave('<%=objRsEDIT(PRIMARY_KEY)%>')"> <br /> <img style="cursor:hand;border:none" src="../images/reset_small.gif" alt="Ignore & Reset " OnClick="location.href='<%=THIS_FILE_NAME%>?result=IGNORED at your request'"> <br /> </td> <br /> </tr> <br /> </table><% <br /> end if <br /> end if%> <br /><% <br />sql="select * from master_user_account u,master_institute i where i.c_institute_cd=u.c_institute_cd " & INSTITUTE_CONDITION & FACULTY_CONDITION & ORDER_BY_CONDITION <br />''''session("dr")=sql <br />''''response.redirect("../includes/dr.asp") <br /> <br />set objRs=Myconn.execute(sql) <br />%> <br /> <br /> <br /> <br /><table cellspacing="0" border=0 style="border-collapse: collapse" width="100%" class="ctms"> <br /><td width="100%" align="center" class="ctms_large"> <br />UPDATE TELEPHONE DIRECTORY <br /></td> <br /></tr> <br /></table> <br /><table border="1" cellspacing=0 align=center width=100% class="ctms"> <br /><tr> <br /><th class="ctms_very_small">  <br /> <br /></th> <br /><th nowrap class="ctms_very_small"> <br />SNo <br /></th> <br /><th width="83" class="ctms_very_small"> <br />Staff Name <br /><img src="../images/sort.gif" border="0" style="cursor:hand" onclick="location.href='<%=THIS_FILE_NAME%>?job=<%=job%>&<%=PRIMARY_KEY%>=<%=PRIMARY_KEY_VALUE%>&order_by=name'"> <br /></th> <br /><th width="60" class="ctms_very_small"> <br />Designation <br /><img src="../images/sort.gif" border="0" style="cursor:hand" onclick="location.href='<%=THIS_FILE_NAME%>?job=<%=job%>&<%=PRIMARY_KEY%>=<%=PRIMARY_KEY_VALUE%>&order_by=designation'"> <br /></th> <br /> <br /><th width="33" class="ctms_very_small"> <br />Post <br /></th> <br /> <br /><th width="54" class="ctms_very_small"> <br />Faculty <br /><img src="../images/sort.gif" border="0" style="cursor:hand" onclick="location.href='<%=THIS_FILE_NAME%>?job=<%=job%>&<%=PRIMARY_KEY%>=<%=PRIMARY_KEY_VALUE%>&order_by=faculty'"> <br /></th> <br /><th width="34" class="ctms_very_small"> <br />Office <br /></th> <br /><th width="55" class="ctms_very_small"> <br />Residence <br /></th> <br /><th width="37" class="ctms_very_small"> <br />Mobile <br /></th> <br /><th width="44" class="ctms_very_small"> <br />Email ID <br /></th> <br /><th width="55" class="ctms_very_small"> <br />Staff No <br /><img src="../images/sort.gif" border="0" style="cursor:hand" onclick="location.href='<%=THIS_FILE_NAME%>?job=<%=job%>&<%=PRIMARY_KEY%>=<%=PRIMARY_KEY_VALUE%>&order_by=c_staff_no'"> <br /></th> <br /><th width="120" class="ctms_very_small"> <br />Trg Centre <br /><img src="../images/sort.gif" border="0" style="cursor:hand" onclick="location.href='<%=THIS_FILE_NAME%>?job=<%=job%>&<%=PRIMARY_KEY%>=<%=PRIMARY_KEY_VALUE%>&order_by=c_institute_name'"> <br /></th> <br /><th width=50 nowrap class="ctms_very_small">  <br /> <br /></th> <br /> <br /></tr> <br /><% <br />if objRs.eof then <br /> %> <br /> <tr> <br /> <td colspan=14 align=center > <br /> <font size=4 color=RED> <br /> <B> <br /> NIL <br /> </B> <br /> </font> <br /> The List is empty <br /> </td> <br /> </tr> <br /> <% <br />else <br /> i=1 <br />while not objRs.eof <br /> tr_bgcolor="white" <br /> if i mod 2=0 then tr_bgcolor="#f0f0f0" <br /> if cstr(objRs(PRIMARY_KEY))=Request(POSTBACK_PRIMARY_KEY) then tr_bgcolor="yellow"%> <br /> <tr bgcolor="<%=tr_bgcolor%>"> <br /> <td nowrap class="ctms_very_small"> <br /> <img style="cursor:hand" src="../images/edit_small.gif" alt="Edit" border="0" onClick="fnEdit('<%=objRs(PRIMARY_KEY)%>')"> <br /> </td> <br /> <td class="ctms_very_small"><%=i%></td> <br /> <td class="ctms_very_small"> <%=objRs("name")%></td> <br /> <td class="ctms_very_small"> <%=objRs("designation")%></td> <br /> <td class="ctms_very_small"> <%=objRs("post")%></td> <br /> <td class="ctms_very_small"> <%=objRs("faculty")%></td> <br /> <td class="ctms_very_small"> <%=objRs("tele_no_off")%></td> <br /> <td class="ctms_very_small"> <%=objRs("tele_no_res")%></td> <br /> <td class="ctms_very_small"> <%=objRs("mobile_no")%></td> <br /> <td class="ctms_very_small"> <%=objRs("email_add")%></td> <br /> <td class="ctms_very_small"> <%=objRs("c_staff_no")%></td> <br /> <td class="ctms_very_small"> <%=objRs("c_institute_name")%></td> <br /> <td nowrap class="ctms_very_small"> <br /> <img style="cursor:hand" src="../images/edit_small.gif" alt="Edit" border="0" onClick="fnEdit('<%=objRs(PRIMARY_KEY)%>')"> <br /> </td> <br /> </tr><% <br /> <br /> i=i+1 <br /> objRs.movenext <br />wend <br />end if <br />%> <br /> <br /></table> <br /><table align=center> <br /><tr> <br /><td class="ctms_very_small_red"> <br />New Faculty Members cannot be added here. To Add New Faculty member, please go back and select the link FACULTY-MEMBER <br /> <br /></td></tr> <br /></table> <br /><font color=white> <br /> <br /><%=sql%> <br /><br><%=inst%> <br /><br><%=primary_key%> <br /></font> <br /> <br /> <br /> <br />




telephone_directory2.asp


<br /> <br /> <br /><!--#include file="../database_module/openMyconn.inc"--> <br /><!--#include file="tm_security.inc"--> <br /> <br /><html> <br /><head> <br /><METADATA TYPE="TypeLib" NAME="Microsoft Remote Data Services Server 2.6 Library" UUID="{9381D8F6-0288-11D0-9501-00AA00B911A5}" VERSION="1.5"> <br /><METADATA TYPE="TypeLib" NAME="Microsoft ActiveX Data Objects 2.6 Library" UUID="{00000206-0000-0010-8000-00AA006D2EA4}" VERSION="2.6"> <br /> <br /></head> <br /><body> <br /> <br /><% <br />job=Request("job") <br />user_name=trim(request("user_name")) <br /> <br />if user_name="" and job="save" then <br /> response.redirect("telephone_directory1.asp?result=FAILED UPDATION...Error code:16:record id not passed") <br />end if <br />email_add=trim(request("email_add")) <br />is_email_validat=instr(email_add,"@") <br />is_email_validdot=instr(email_add,".") <br />if email_add <>"" then <br /> if is_email_validat <1 or is_email_validdot<1 then <br /> response.redirect("telephone_directory1.asp?result=FAILED UPDATION...Email Address is not valid") <br /> end if <br />end if <br /> <br />if user_name <>"" and job="save" then <br /> set objRs=Server.CreateObject("ADODB.Recordset") <br /> objRs.CursorLocation=3 <br /> sql="select * from master_user_account where user_name='"& user_name & "' and c_institute_cd='" & session("c_institute_cd") & "'" <br /> objRs.open sql,myconn,1,3 <br /> if not objRs.eof then <br /> objRs("post")=trim(request("post")) <br /> objRs("tele_no_off")=trim(request("tele_no_off")) <br /> objRs("tele_no_res")=trim(request("tele_no_res")) <br /> objRs("mobile_no")=trim(request("mobile_no")) <br /> objRs("email_add")=trim(request("email_add")) <br /> objRs.update <br /> response.redirect("telephone_directory1.asp?postback_user_name=" & user_name & "&result=Successfully Updated") <br /> end if <br />end if <br /> <br />%> <br /> <br /> <br />