public void GetCustomerByProvider()
{
//Get related customers by Provider
CompanyCustomer.Models.Customer.CustomerModel oReturn =
CompanyCustomer.Controller.CompanyCustomer.GetCustomerByProvider("1CA3A147", null);
Assert.AreEqual(true, oReturn.RelatedProvider.Count >= 1 && oReturn.RelatedProvider != null);
}
public void GetCustomerInfoByProvider()
{
int TotalRows = 0;
CompanyCustomer.Models.Customer.CustomerModel oReturn =
CompanyCustomer.Controller.CompanyCustomer.GetCustomerInfoByProvider(118, true, 0, 1000000, out TotalRows);
Assert.AreEqual(true, oReturn.RelatedProvider.Count >= 1 && TotalRows > 0);
}
public CompanyCustomer.Models.Customer.CustomerModel GetCustomerInfoByProvider(int CustomerProviderId, bool Enable, int PageNumber, int RowCount, out int TotalRows)
{
TotalRows = 0;
List <System.Data.IDbDataParameter> lstParams = new List <IDbDataParameter>();
lstParams.Add(DataInstance.CreateTypedParameter("vCustomerProviderId", CustomerProviderId));
lstParams.Add(DataInstance.CreateTypedParameter("vEnable", Enable == true ? 1 : 0));
lstParams.Add(DataInstance.CreateTypedParameter("vPageNumber", PageNumber));
lstParams.Add(DataInstance.CreateTypedParameter("vRowCount", RowCount));
ADO.Models.ADOModelResponse response = DataInstance.ExecuteQuery(new ADO.Models.ADOModelRequest()
{
CommandExecutionType = ADO.Models.enumCommandExecutionType.DataTable,
CommandText = "CC_GetCustomerInfoByProvider",
CommandType = CommandType.StoredProcedure,
Parameters = lstParams,
});
CompanyCustomer.Models.Customer.CustomerModel oReturn = null;
if (response.DataTableResult != null &&
response.DataTableResult.Rows.Count > 0)
{
TotalRows = response.DataTableResult.Rows[0].Field <int>("TotalRows");
oReturn = new Models.Customer.CustomerModel()
{
RelatedProvider = new List <Models.Customer.CustomerProviderModel>()
{
new Models.Customer.CustomerProviderModel()
{
CustomerProviderId = response.DataTableResult.Rows[0].Field <int>("CustomerProviderId"),
CustomerProviderInfo =
(from cpi in response.DataTableResult.AsEnumerable()
where !cpi.IsNull("CustomerProviderInfoId")
group cpi by new
{
CustomerProviderInfoId = cpi.Field <int>("CustomerProviderInfoId"),
TrackingId = cpi.Field <int>("TrackingId"),
TrackingName = cpi.Field <string>("TrackingName"),
TrackingValue = cpi.Field <string>("TrackingValue"),
Enable = cpi.Field <UInt64>("Enable") == 1 ? true : false,
CreateDate = cpi.Field <DateTime>("CreateDate"),
} into cpinf
select new ProveedoresOnLine.Company.Models.Util.GenericItemInfoModel()
{
ItemInfoId = cpinf.Key.CustomerProviderInfoId,
ItemInfoType = new Company.Models.Util.CatalogModel()
{
ItemId = cpinf.Key.TrackingId,
ItemName = cpinf.Key.TrackingName,
},
LargeValue = cpinf.Key.TrackingValue,
Enable = cpinf.Key.Enable,
CreateDate = cpinf.Key.CreateDate,
}).ToList()
}
}
};
}
return(oReturn);
}
