public DataTable GetCustomer(Models.CustomerSearch arg)
{
DataTable dt = new DataTable();
string sql = @"SELECT [CustomerID]
,[CompanyName]
,[ContactName]
,[ContactTitle]+'-'+B.CodeVal AS ContactTitle
,[CreationDate]
,[Address]
,[City]
,[Region]
,[PostalCode]
,[Country]
,[Phone]
,[Fax]
FROM [Sales].[Customers] AS A JOIN dbo.CodeTable AS B ON A.ContactTitle = B.CodeId AND B.CodeType='TITLE'
WHERE(A.CompanyName Like @CompanyName Or @CompanyName='') And
(A.CustomerID=@CustomerID Or @CustomerID='') And
(A.ContactName Like @ContactName Or @ContactName='') And
(A.ContactTitle = @ContactTitle Or @ContactTitle='')";
using (SqlConnection conn = new SqlConnection(this.GetDBConnectionString()))
{
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataAdapter sqlAdapter = new SqlDataAdapter(cmd);
cmd.Parameters.Add(new SqlParameter("@CustomerID", arg.CustomerID == null ? string.Empty : arg.CustomerID));
cmd.Parameters.Add(new SqlParameter("@CompanyName", arg.CompanyName == null ? string.Empty : '%' + arg.CompanyName + '%'));
cmd.Parameters.Add(new SqlParameter("@ContactName", arg.ContactName == null ? string.Empty : '%' + arg.ContactName + '%'));
cmd.Parameters.Add(new SqlParameter("@ContactTitle", arg.ContactTitle == null ? string.Empty : arg.ContactTitle));
sqlAdapter.Fill(dt);
conn.Close();
}
return(dt);
}
private static void CustomerWindowLogic(Models.CustomerSearch customerSearch)
{
var customer = ProjectManager.Instance.CoolIceProDBHelper.GetCustomer(customerSearch.Id);
var contact = ProjectManager.Instance.CoolIceProDBHelper.GetCustomerContacts(customerSearch.Id);
customer.Contact = contact;
var page = new CoolIcePro.Views.Customer(new CustomerViewModel(customer));
Windows.GenericWindow gw = new Windows.GenericWindow(685, 625, string.Format("{0}", customerSearch.CompanyName), page);
gw.ShowDialog();
}
public JsonResult Read(Models.CustomerSearch Arg)
{
try
{
Services.CustomerService CustomerService = new Services.CustomerService();
JsonResult result = this.Json(CustomerService.GetCustomer(Arg), JsonRequestBehavior.AllowGet);
return(result);
}
catch (Exception)
{
return(this.Json(false));
}
}
public List <Models.Customer> GetCustomer(Models.CustomerSearch arg)
{
DataTable dt = CustomerDao.GetCustomer(arg);
return(MapCustomer(dt));
}
