public CustomerList(CustomerListParameters clp)
{
//if (clp.SalesID ==(int)EmployeeEN .NEmployeeIDDefault .Other )
//{
// _customerTable = GetCustomerListOther(clp);
//}
//else
//{
_customerTable = GetCustomerList(clp);
// }
}
//private DataTable GetCustomerListOther(CustomerListParameters clp)
//{
// //all Ae
// //find ae in quota table
// //delete ae in quota table
// //return other
// clp.SalesID = (int) EmployeeEN.NEmployeeIDDefault.All;
// var allAEs = GetCustomerList(clp);
// var quota = new SalesQuotaOriginalData(DateTime.Today.Year);
// var quotaAEs = quota.QuataDatatable;
// foreach (DataRow row in allAEs.Rows)
// {
// var allAE = Convert.ToInt32(row["SalesID"]);
// foreach (DataRow rowQuota in quotaAEs.Rows)
// {
// var quotaAe = Convert.ToInt32(rowQuota["SalesID"]);
// if (allAE == quotaAe)
// {
// row.Delete();
// }
// }
// }
// allAEs.AcceptChanges();
// return allAEs;
//}
private DataTable GetCustomerList(CustomerListParameters clp)
{
DataTable t1 = null;
SqlConnection ConnectionSQL = new SqlConnection(CustomerDomainConfiguration.ConnectionString);
SqlCommand SelectCommand = new SqlCommand("GetCustomerList", ConnectionSQL);
//Stored Procedure
SelectCommand.CommandType = CommandType.StoredProcedure;
SqlDataAdapter adapter1 = new SqlDataAdapter(SelectCommand);
adapter1.SelectCommand.Parameters.Add("@Headoffice", SqlDbType.Bit).Value = clp.CbxHeadoffice;
adapter1.SelectCommand.Parameters.Add("@Franchisee", SqlDbType.Bit).Value = clp.CbxFranchisee;
adapter1.SelectCommand.Parameters.Add("@IndividualStore", SqlDbType.Bit).Value = clp.CbxIndividualStore;
adapter1.SelectCommand.Parameters.Add("@Partner", SqlDbType.Bit).Value = clp.CbxPartner;
adapter1.SelectCommand.Parameters.Add("@TeamID", SqlDbType.Int).Value = clp.TeamID;
adapter1.SelectCommand.Parameters.Add("@salesID", SqlDbType.Int).Value = clp.SalesID;
adapter1.SelectCommand.Parameters.Add("@FirstCharacter", SqlDbType.NChar, 3).Value = clp.FirstCharacterOfName;
adapter1.SelectCommand.Parameters.Add("@CategoryID", SqlDbType.Int).Value = clp.IndustryID;
adapter1.SelectCommand.Parameters.Add("@CustomerID", SqlDbType.Int).Value = clp.CustomerrID;
DataSet ds1 = new DataSet();
ds1.Tables.Clear();
try
{
ConnectionSQL.Open();
int NumRowsAffected = adapter1.Fill(ds1, "t1");
if (NumRowsAffected != 0)
{
t1 = ds1.Tables["t1"];
}
}
catch (SqlException ex)
{
string errorLog = ex.Message;
}
finally
{
ConnectionSQL.Close();
}
return(t1);
}