protected void imageButtonSearchClick(object sender, EventArgs e)
{
GridViewSearchResults.DataBind();
GridViewSearchResults.PageIndex = 0;
GridViewSearchResults.Visible = true;
ImageButtonResetColumnWidths.Visible = true;
}
protected void PopulateGridView()
{
string query = Request.QueryString["query"];
if (string.IsNullOrWhiteSpace(query))
{
throw new HttpException(400, "Bad Request");
}
LabelQuery.Text = query;
BLMember blMember = new BLMember();
List <Member> results = blMember.FindMembersByName(query);
GridViewSearchResults.DataSource = results;
GridViewSearchResults.DataBind();
}
protected void LinkButtonUpdate_Click(object sender, EventArgs e)
{
try
{
String JapaneseMatterNameOld = "";
String JapaneseClientNameOld = "";
int OverseasMatterOld = 0;
if (Session["JapaneseMatterNameOld"] != null)
{
JapaneseMatterNameOld = Session["JapaneseMatterNameOld"].ToString();
}
if (Session["JapaneseClientNameOld"] != null)
{
JapaneseClientNameOld = Session["JapaneseClientNameOld"].ToString();
}
if (Session["OverseasMatterOld"] != null)
{
if (Session["OverseasMatterOld"].ToString().Equals("1"))
{
OverseasMatterOld = 1;
}
else
{
OverseasMatterOld = 0;
}
}
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["eliteConnectionString"].ConnectionString);
con.Open();
SqlCommand command = con.CreateCommand();
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "uspBMcBEARSearchTokyoClientMatterUpdate";
command.Parameters.AddWithValue("@clientNumber", LabelSelectedClientNumber.Text.Trim());
if (CheckBoxOverseasMatter.Checked)
{
command.Parameters.AddWithValue("@overseasMatterNew", 1);
}
else
{
command.Parameters.AddWithValue("@overseasMatterNew", 0);
}
command.Parameters.AddWithValue("@overseasMatterOld", 0);
if (TextBoxSelectedJapaneseClientName.Text.Equals(""))
{
command.Parameters.AddWithValue("@clientNameJapanese", DBNull.Value);
}
else
{
command.Parameters.AddWithValue("@clientNameJapanese", TextBoxSelectedJapaneseClientName.Text);
}
command.Parameters.AddWithValue("@JapaneseClientNameOld", JapaneseClientNameOld);
command.Parameters.AddWithValue("@matterNumber", LabelSelectedMatterNumber.Text.Trim());
if (TextBoxSelectedJapaneseMatterDescription.Text.Equals(""))
{
command.Parameters.AddWithValue("@matterDescriptionJapanese", DBNull.Value);
}
else
{
command.Parameters.AddWithValue("@matterDescriptionJapanese", TextBoxSelectedJapaneseMatterDescription.Text);
}
command.Parameters.AddWithValue("@JapaneseMatterNameOld", JapaneseMatterNameOld);
command.Parameters.AddWithValue("@changeDate", DateTime.Now);
command.Parameters.AddWithValue("@userId", Page.User.Identity.Name.ToString().Substring(8));
command.ExecuteNonQuery();
}
catch (SqlException sqle)
{
Logger.QuickLog(VariablesSearchToykoClientMatter.ERROR_LOG_FILE_NAME, "LinkButtonUpdate_Click()", sqle.Message, "");
}
Session["JapaneseMatterNameOld"] = TextBoxSelectedJapaneseMatterDescription.Text;
Session["JapaneseClientNameOld"] = TextBoxSelectedJapaneseClientName.Text;
Session["OverseasMatterOld"] = CheckBoxOverseasMatter.Checked ? "1" : "0";
GridViewSearchResults.DataBind();
}
protected void imageButtonSearchClick(object sender, EventArgs e)
{
GridViewSearchResults.DataBind();
GridViewSearchResults.Visible = true;
}
