public string updateRenewal(pt.Renewal aa)
{
string connectionString = Connect();
string str2 = "";
SqlConnection connection = new SqlConnection(connectionString);
SqlCommand command = connection.CreateCommand();
command.CommandText = "UPDATE renewal SET title=@title,type=@type,reg_no=@reg_no,app_no=@app_no,app_date=@app_date,xname=@xname ,xmobile=@xmobile ,xemail=@xemail,xaddy=@xaddy, ";
command.CommandText += " agt_code=@agt_code,agt_name=@agt_name,agt_addy=@agt_addy,agt_mobile=@agt_mobile,agt_email=@agt_email,last_rwl_date=@last_rwl_date ,reg_date=@reg_date ";
command.CommandText += " WHERE log_staff=@papp ";
connection.Open();
command.Parameters.Add("@title", SqlDbType.NVarChar);
command.Parameters.Add("@type", SqlDbType.NVarChar);
command.Parameters.Add("@reg_no", SqlDbType.NVarChar);
command.Parameters.Add("@app_no", SqlDbType.NVarChar);
command.Parameters.Add("@app_date", SqlDbType.NVarChar);
command.Parameters.Add("@xname", SqlDbType.NVarChar);
command.Parameters.Add("@xmobile", SqlDbType.NVarChar);
command.Parameters.Add("@xemail", SqlDbType.NVarChar);
command.Parameters.Add("@xaddy", SqlDbType.Text);
command.Parameters.Add("@agt_code", SqlDbType.NVarChar);
command.Parameters.Add("@agt_name", SqlDbType.NVarChar);
command.Parameters.Add("@agt_addy", SqlDbType.Text);
command.Parameters.Add("@agt_mobile", SqlDbType.NVarChar);
command.Parameters.Add("@agt_email", SqlDbType.NVarChar);
command.Parameters.Add("@last_rwl_date", SqlDbType.NVarChar);
command.Parameters.Add("@reg_date", SqlDbType.NVarChar);
command.Parameters.Add("@papp", SqlDbType.NVarChar);
command.Parameters["@title"].Value = aa.title;
command.Parameters["@type"].Value = aa.type;
command.Parameters["@reg_no"].Value = aa.reg_no;
command.Parameters["@app_no"].Value = aa.app_no;
command.Parameters["@app_date"].Value = aa.app_date;
command.Parameters["@xname"].Value = aa.xname;
command.Parameters["@xmobile"].Value = aa.xmobile;
command.Parameters["@xemail"].Value = aa.xemail;
command.Parameters["@papp"].Value = aa.log_staff;
command.Parameters["@xaddy"].Value = aa.xaddy;
command.Parameters["@agt_code"].Value = aa.agt_code;
command.Parameters["@agt_name"].Value = aa.agt_name;
command.Parameters["@agt_addy"].Value = aa.agt_addy;
command.Parameters["@agt_mobile"].Value = aa.agt_mobile;
command.Parameters["@agt_email"].Value = aa.agt_email;
command.Parameters["@last_rwl_date"].Value = aa.last_rwl_date;
command.Parameters["@reg_date"].Value = aa.reg_date;
str2 = command.ExecuteNonQuery().ToString();
connection.Close();
string admin = Session["pwalletID"].ToString();
pt.XPwallet xxs = t.getXPwalletDetailsByID2(TextBox6.Text);
t.activity_log(admin, "Edit Renewal", "Update", xxs.ID, xxs.data_status, "", "", "", "", "", "");
return(str2);
}
