"{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil Consolas;}{\f1\fnil\fprq1\fcharset0 Courier New;}{\f2\fnil\fcharset0 Consolas;}{\f3\fnil\fcharset0 Arial;}}
{\colortbl ;\red0\green0\blue255;\red0\green0\blue0;\red255\green0\blue0;}
\viewkind4\uc1\pard\cf1\f0\fs19 u\cf2 sing System;
\par using System.Collections.Generic;
\par using System.Web;
\par using System.Web.UI;
\par using System.Web.UI.WebControls;
\par using System.Data.SqlClient;
\par using System.Data;
\par 
\par     public partial class _Default : System.Web.UI.Page
\par     \{
\par         
\par         static public String sConnStr = _$$$_002_$$$_server=10.131.14.153\\\\SQLEXPRESS;uid=sa;pwd=Allied2013;database=Audit_$$$_002_$$$_;
\par         SqlConnection con = new SqlConnection(sConnStr);
\par         SqlCommand cmd = null;
\par         string sSQL = _$$$_002_$$$__$$$_002_$$$_;
\par 
\par         protected void Page_Load(object sender, EventArgs e)
\par         \{
\par             try
\par             \{
\par                 con.Open();
\par                 if (!Page.IsPostBack)
\par                 \{   
\par                     ClearForm();
\par                 \}
\par             \}
\par             catch (Exception exp)
\par             \{ lblStatus.Text = exp.Message.ToString(); \}
\par         \}
\par 
\par         protected void txtUserID_TextChanged(object sender, EventArgs e)
\par         \{
\par             sSQL = _$$$_002_$$$_select count(*) from users where userid='_$$$_002_$$$_ + txtUserID.Text + _$$$_002_$$$_'_$$$_002_$$$_;
\par             SqlDataReader oReader = getDatareader(sSQL);
\par             oReader.Read();
\par             int lRecCount = int.Parse(oReader.GetValue(0).ToString());
\par             oReader.Close();
\par             if (lRecCount > 0)
\par             \{
\par                 ViewState\cf1 [_$$$_002_$$$_Mode_$$$_002_$$$_]\cf2  = _$$$_002_$$$_Edit_$$$_002_$$$_;
\par                 LoadForm();
\par             \}
\par             else
\par             \{
\par                 ViewState\cf1 [_$$$_002_$$$_Mode_$$$_002_$$$_]\cf2  = _$$$_002_$$$_Add_$$$_002_$$$_;
\par             \}
\par         \}
\par 
\par         protected void LoadForm()
\par         \{
\par             sSQL = _$$$_002_$$$_\f1\fs20 select \cf1\lang1024 [(\cf3 $\lang1033\f2\fs19 Fields\lang1024\f1\fs20 !\cf1 |1|n)(,|1|n-1)]\cf2  from \cf3 $Table!\cf2\lang1033\f0\fs19  where \cf3\f2 $wField!\cf2\f0 ='_$$$_002_$$$_ + txt\cf3\f2 $wField!\cf2\f0 .Text + _$$$_002_$$$_'_$$$_002_$$$_;
\par             SqlDataReader oReader = getDatareader(sSQL);
\par             oReader.Read();
\par             \cf1\f2 [(txt\cf3 $Fields!\cf1 .Text = \f0 oReader.GetValue(1).ToString();\f2 |1|n)]\cf2\f0 
\par             oReader.Close();
\par         \}
\par 
\par 
\par         protected void cmdSave_onClick(object sender, EventArgs e)
\par         \{
\par             try
\par             \{
\par                 if (ViewState\cf1 [_$$$_002_$$$_Mode_$$$_002_$$$_]\cf2 .Equals(_$$$_002_$$$_Add_$$$_002_$$$_))
\par                 \{
\par                    \f2 sSQL = _$$$_002_$$$_\f0 Insert Into \cf3\f2 $Table!\cf2\f0 (\cf1\f2 [(\cf3 $Fields!\cf1 |1|n)(,|1|n-1)]\cf2\f0 ) Values('_$$$_002_$$$_\f2  + \cf1 [(txt\cf3 $Fields!\cf1 .Text|1|n)(\f0 + _$$$_002_$$$_','_$$$_002_$$$_ +\f2 |1|n-1)]\cf2\f0  \f2 + _$$$_002_$$$_')_$$$_002_$$$_;
\par \f0                    ExecuteSQL(sSQL);
\par                 \}
\par                 else if (ViewState\cf1 [_$$$_002_$$$_Mode_$$$_002_$$$_]\cf2 .Equals(_$$$_002_$$$_Edit_$$$_002_$$$_))
\par                 \{
\par \f2\tab\tab\tab\f0 sSQL = _$$$_002_$$$_Update \cf3\f2 $Table!\cf2  \f0 set \cf1\f2 [(\cf3 $Fields!\cf1\f0 ='_$$$_002_$$$_ + txt\cf3\f2 $Fields!\cf1\f0 .Text  + _$$$_002_$$$_'\f2 |1|n)(,|1|n-1)]\cf2  \f0 where \cf3\f2 $wField!\cf2\f0 ='_$$$_002_$$$_ + txt\cf3\f2 $wField!\cf2\f0 .Text + _$$$_002_$$$_'_$$$_002_$$$_\f2 ;\f0 
\par                     ExecuteSQL(sSQL);
\par 
\par                 \}
\par                 lblStatus.Text = _$$$_002_$$$_Record Saved Successfully..._$$$_002_$$$_;
\par             \}
\par             catch (Exception exp)
\par             \{ lblStatus.Text = exp.Message.ToString(); \}
\par 
\par         \}
\par 
\par         protected void cmdCancel_onClick(object sender, EventArgs e)
\par         \{
\par             ClearForm();
\par         \}
\par 
\par         protected void ClearForm()
\par         \{
\par             \cf1\f2 [(txt\cf3 $Fields!\cf1 .Text = _$$$_002_$$$__$$$_002_$$$_;|1|n)]\cf2\f0 
\par         \}
\par 
\par         public SqlDataReader getDatareader(String pSQL)
\par         \{ 
\par             SqlDataReader rdr;
\par             cmd = new SqlCommand(pSQL, con);
\par             rdr = cmd.ExecuteReader();
\par             cmd.Dispose();
\par             return rdr;
\par         \}
\par 
\par         public void ExecuteSQL(String pSQL)
\par         \{
\par             cmd = new SqlCommand(pSQL, con);
\par             cmd.ExecuteNonQuery();
\par         \}
\par 
\par 
\par \}
\par 
\par \cf0\f3\fs17 
\par }
_$$$_001_$$$_{\rtf1\ansi\ansicpg1252\deff0{\fonttbl{\f0\fnil\fcharset0 Verdana;}}
{\colortbl ;\red0\green0\blue0;\red255\green0\blue0;}
\viewkind4\uc1\pard\lang1033\f0\fs17 u\cf1 sing System;
\par using System.Collections.Generic;
\par using System.Web;
\par using System.Web.UI;
\par using System.Web.UI.WebControls;
\par using System.Data.SqlClient;
\par using System.Data;
\par 
\par     public partial class _Default : System.Web.UI.Page
\par     \{
\par         
\par         static public String sConnStr = _$$$_002_$$$_server=10.131.14.153\\\\SQLEXPRESS;uid=sa;pwd=Allied2013;database=Audit_$$$_002_$$$_;
\par         SqlConnection con = new SqlConnection(sConnStr);
\par         SqlCommand cmd = null;
\par         string sSQL = _$$$_002_$$$__$$$_002_$$$_;
\par 
\par         protected void Page_Load(object sender, EventArgs e)
\par         \{
\par             try
\par             \{
\par                 con.Open();
\par                 if (!Page.IsPostBack)
\par                 \{   
\par                     ClearForm();
\par                 \}
\par             \}
\par             catch (Exception exp)
\par             \{ lblStatus.Text = exp.Message.ToString(); \}
\par         \}
\par 
\par         protected void txtUserID_TextChanged(object sender, EventArgs e)
\par         \{
\par             sSQL = _$$$_002_$$$_select count(*) from users where userid='_$$$_002_$$$_ + txtUserID.Text + _$$$_002_$$$_'_$$$_002_$$$_;
\par             SqlDataReader oReader = getDatareader(sSQL);
\par             oReader.Read();
\par             int lRecCount = int.Parse(oReader.GetValue(0).ToString());
\par             oReader.Close();
\par             if (lRecCount > 0)
\par             \{
\par                 ViewState[_$$$_002_$$$_Mode_$$$_002_$$$_] = _$$$_002_$$$_Edit_$$$_002_$$$_;
\par                 LoadForm();
\par             \}
\par             else
\par             \{
\par                 ViewState[_$$$_002_$$$_Mode_$$$_002_$$$_] = _$$$_002_$$$_Add_$$$_002_$$$_;
\par             \}
\par         \}
\par 
\par         protected void LoadForm()
\par         \{
\par             sSQL = _$$$_002_$$$_select \cf2 $Fields0001!\cf1 ,
\par \cf2 $Fields0002!\cf1 ,
\par \cf2 $Fields0003!\cf1  from \cf2 $Table!\cf1  where \cf2 $wField!\cf1 ='_$$$_002_$$$_ + txt\cf2 $wField!\cf1 .Text + _$$$_002_$$$_'_$$$_002_$$$_;
\par             SqlDataReader oReader = getDatareader(sSQL);
\par             oReader.Read();
\par             txt\cf2 $Fields0001!\cf1 .Text = oReader.GetValue(1).ToString();
\par txt\cf2 $Fields0002!\cf1 .Text = oReader.GetValue(1).ToString();
\par txt\cf2 $Fields0003!\cf1 .Text = oReader.GetValue(1).ToString();
\par             oReader.Close();
\par         \}
\par 
\par 
\par         protected void cmdSave_onClick(object sender, EventArgs e)
\par         \{
\par             try
\par             \{
\par                 if (ViewState[_$$$_002_$$$_Mode_$$$_002_$$$_].Equals(_$$$_002_$$$_Add_$$$_002_$$$_))
\par                 \{
\par                    sSQL = _$$$_002_$$$_Insert Into \cf2 $Table!\cf1 (\cf2 $Fields0001!\cf1 ,
\par \cf2 $Fields0002!\cf1 ,
\par \cf2 $Fields0003!\cf1 ) Values('_$$$_002_$$$_ + txt\cf2 $Fields0001!\cf1 .Text+ _$$$_002_$$$_','_$$$_002_$$$_ +
\par txt\cf2 $Fields0002!\cf1 .Text+ _$$$_002_$$$_','_$$$_002_$$$_ +
\par txt\cf2 $Fields0003!\cf1 .Text + _$$$_002_$$$_')_$$$_002_$$$_;
\par                    ExecuteSQL(sSQL);
\par                 \}
\par                 else if (ViewState[_$$$_002_$$$_Mode_$$$_002_$$$_].Equals(_$$$_002_$$$_Edit_$$$_002_$$$_))
\par                 \{
\par \tab\tab\tab sSQL = _$$$_002_$$$_Update \cf2 $Table!\cf1  set \cf2 $Fields0001!\cf1 ='_$$$_002_$$$_ + txt\cf2 $Fields0001!\cf1 .Text  + _$$$_002_$$$_',
\par \cf2 $Fields0002!\cf1 ='_$$$_002_$$$_ + txt\cf2 $Fields0002!\cf1 .Text  + _$$$_002_$$$_',
\par \cf2 $Fields0003!\cf1 ='_$$$_002_$$$_ + txt\cf2 $Fields0003!\cf1 .Text  + _$$$_002_$$$_' where \cf2 $wField!\cf1 ='_$$$_002_$$$_ + txt\cf2 $wField!\cf1 .Text + _$$$_002_$$$_'_$$$_002_$$$_;
\par                     ExecuteSQL(sSQL);
\par 
\par                 \}
\par                 lblStatus.Text = _$$$_002_$$$_Record Saved Successfully..._$$$_002_$$$_;
\par             \}
\par             catch (Exception exp)
\par             \{ lblStatus.Text = exp.Message.ToString(); \}
\par 
\par         \}
\par 
\par         protected void cmdCancel_onClick(object sender, EventArgs e)
\par         \{
\par             ClearForm();
\par         \}
\par 
\par         protected void ClearForm()
\par         \{
\par             txt\cf2 $Fields0001!\cf1 .Text = _$$$_002_$$$__$$$_002_$$$_;
\par txt\cf2 $Fields0002!\cf1 .Text = _$$$_002_$$$__$$$_002_$$$_;
\par txt\cf2 $Fields0003!\cf1 .Text = _$$$_002_$$$__$$$_002_$$$_;
\par         \}
\par 
\par         public SqlDataReader getDatareader(String pSQL)
\par         \{ 
\par             SqlDataReader rdr;
\par             cmd = new SqlCommand(pSQL, con);
\par             rdr = cmd.ExecuteReader();
\par             cmd.Dispose();
\par             return rdr;
\par         \}
\par 
\par         public void ExecuteSQL(String pSQL)
\par         \{
\par             cmd = new SqlCommand(pSQL, con);
\par             cmd.ExecuteNonQuery();
\par         \}
\par 
\par 
\par \}
\par 
\par \cf0 
\par }
"
