public IHttpActionResult GetList(PlotSearch search)
{
AuthDetails authdet = LoginUserDetails();
var filters = new List <MySqlParameter>
{
datatableService.CreateSqlParameter("@pUserId", authdet.UserId, MySqlDbType.Int32)
};
var result = service.GetList(search, filters);
return(Ok(result));
}
public DataTable <PlotDatatable> GetList(PlotSearch search, List <MySqlParameter> filters)
{
try
{
using (var ctx = new AppDb())
{
var result = datatableService.GetDataTableResult <PlotDatatable>("plot_list_sp", search, filters);
return(result);
}
}
catch (Exception ex)
{
throw ex;
}
}
public void LastNameSearch_TextChanged(object sender, TextChangedEventArgs e)
{
ClearData();
PlotSearch.TextChanged -= PlotSearch_TextChanged;
PlotSearch.Clear();
PlotSearch.TextChanged += PlotSearch_TextChanged;
grdList.ItemsSource = null;
if (LastNameSearch.Text != "")
{
sql1 = @"select OBJECTID as 'Id', Lot, Plot, [name_LAST] as 'LastName', [name_FIRST] as 'FirstName'
from CemeteryPlotsVets where
name_LAST like '" + LastNameSearch.Text.Replace("'", "''") + "%' order by name_LAST;";
PopGrid();
//btnSearch.Enabled = true;
}
}
private void LogOffClose_Click(object sender, RoutedEventArgs e)
{
try
{
cnn.Close();
cnn.Dispose();
Logoff_btn.IsEnabled = false;
SaveBtn.IsEnabled = false;
Logon_btn.IsEnabled = true;
Id_TextEntry.IsEnabled = true;
Pw_Box.IsEnabled = true;
Id_TextEntry.Clear();
Pw_Box.Clear();
LastNameSearch.Clear();
PlotSearch.Clear();
Logon_btn.IsEnabled = true;
SearchBtn.IsEnabled = false;
this.Title = "Logged Out";
}
catch { this.Close(); }
}
