public Sync()
{
this.snackthatClient = new SnackthatServiceClient.SnackthatServiceSoapClient();
this.aR = new ActiveRecord();
}
public void receiveData(int idSeller)
{
try
{
Clients.addMessage(0);
this.snackthatClient = new SnackthatServiceClient.SnackthatServiceSoapClient();
this.aR = new ActiveRecord();
Clients.addMessage(5);
DataTable dtUsers = this.snackthatClient.getSellers();
if (dtUsers != null)
{
this.aR.callProcedure("deleteUsers");
for (int i = 0; i < dtUsers.Rows.Count; i++)
{
ArrayList parametersUser = new ArrayList();
parametersUser.Add(dtUsers.Rows[i].ItemArray[0].ToString());
parametersUser.Add(dtUsers.Rows[i].ItemArray[1].ToString());
parametersUser.Add(dtUsers.Rows[i].ItemArray[2].ToString());
parametersUser.Add(dtUsers.Rows[i].ItemArray[3].ToString());
parametersUser.Add(dtUsers.Rows[i].ItemArray[4].ToString());
parametersUser.Add(dtUsers.Rows[i].ItemArray[5].ToString());
parametersUser.Add(dtUsers.Rows[i].ItemArray[6].ToString());
parametersUser.Add(dtUsers.Rows[i].ItemArray[7].ToString());
parametersUser.Add(dtUsers.Rows[i].ItemArray[8].ToString());
parametersUser.Add(dtUsers.Rows[i].ItemArray[9].ToString());
this.aR.callProcedure("setUser", parametersUser);
}
}
Clients.addMessage(15);
DataTable dtProducts = this.snackthatClient.getProductsBySeller(idSeller);
Clients.addMessage(25);
if (dtProducts != null)
{
this.aR.callProcedure("deleteProductsContent");
Clients.addMessage(30);
for (int i = 0; i < dtProducts.Rows.Count; i++)
{
ArrayList parametersProduct = new ArrayList();
parametersProduct.Add(dtProducts.Rows[i].ItemArray[0].ToString()); //ID
parametersProduct.Add(dtProducts.Rows[i].ItemArray[2].ToString()); //Presentation
parametersProduct.Add(dtProducts.Rows[i].ItemArray[1].ToString()); //Name
parametersProduct.Add(dtProducts.Rows[i].ItemArray[5].ToString()); //Amount
parametersProduct.Add(dtProducts.Rows[i].ItemArray[3].ToString()); //Price
parametersProduct.Add(HttpUtility.HtmlDecode(dtProducts.Rows[i].ItemArray[4].ToString())); //Description
this.aR.callProcedure("setProduct", parametersProduct);
}
}
Clients.addMessage(50);
DataTable dtRoute = this.snackthatClient.getRouteBySeller(idSeller); //id
ArrayList parametersRoute = new ArrayList();
Clients.addMessage(65);
if (dtRoute != null)
{
parametersRoute.Add(dtRoute.Rows[0].ItemArray[0].ToString()); //ID
parametersRoute.Add(dtRoute.Rows[0].ItemArray[1].ToString()); //Name
this.aR.callProcedure("setRoute", parametersRoute);
}
Clients.addMessage(75);
DataTable dtCustomers = this.snackthatClient.getCustomersByRoute(int.Parse(parametersRoute[0].ToString())); //id
Clients.addMessage(80);
if (dtCustomers != null)
{
for (int i = 0; i < dtCustomers.Rows.Count; i++)
{
ArrayList parametersCustomer = new ArrayList();
parametersCustomer.Add(dtCustomers.Rows[i].ItemArray[0].ToString()); //IdCustomer
parametersCustomer.Add(dtCustomers.Rows[i].ItemArray[1].ToString()); //Name
parametersCustomer.Add(dtCustomers.Rows[i].ItemArray[2].ToString()); //LastName
parametersCustomer.Add(dtCustomers.Rows[i].ItemArray[3].ToString()); //eMail
parametersCustomer.Add(dtCustomers.Rows[i].ItemArray[4].ToString()); //RFC
//Parametros de la tabla addressescustomer
ArrayList parametersCustomerAddresses = new ArrayList();
parametersCustomerAddresses.Add(dtCustomers.Rows[i].ItemArray[5].ToString()); //IdAddressCustomer
parametersCustomerAddresses.Add(dtCustomers.Rows[i].ItemArray[6].ToString()); //IdCustomer
parametersCustomerAddresses.Add(dtCustomers.Rows[i].ItemArray[7].ToString()); //Address
parametersCustomerAddresses.Add(dtCustomers.Rows[i].ItemArray[8].ToString()); //Phone
//Parametros de la tabla customersroutes
ArrayList parametersRouteCustomers = new ArrayList();
parametersRouteCustomers.Add(dtCustomers.Rows[i].ItemArray[9].ToString()); //IdCustomerRoute
parametersRouteCustomers.Add(dtCustomers.Rows[i].ItemArray[10].ToString()); //IdRoute
parametersRouteCustomers.Add(dtCustomers.Rows[i].ItemArray[11].ToString()); //IdAddressCustomer
parametersRouteCustomers.Add(dtCustomers.Rows[i].ItemArray[12].ToString()); //EstimatedTime
try
{
parametersRouteCustomers[parametersRouteCustomers.Count - 1] = Convert.ToDateTime(parametersRouteCustomers[parametersRouteCustomers.Count - 1].ToString());
}
catch (Exception ex)
{
parametersRouteCustomers[parametersRouteCustomers.Count - 1] = null;
}
//Se llenan las tablas de customer, addressescustomers y customersroutes
this.aR.callProcedure("setCustomer", parametersCustomer);
this.aR.callProcedure("setAddressesCustomer", parametersCustomerAddresses);
this.aR.callProcedure("setCustomersRoutes", parametersRouteCustomers);
}
Clients.addMessage(100);
}
}
catch (System.ServiceModel.EndpointNotFoundException ex)
{
Clients.addMessage(1000);
}
catch (Exception ex)
{
Clients.addMessage(3000);
}
}
public void sendData()
{
try
{
Clients.addMessage(0);
this.snackthatClient = new SnackthatServiceClient.SnackthatServiceSoapClient();
this.aR = new ActiveRecord();
Clients.addMessage(25);
DataTable dt = new Customers().getAllCustomers(1);
DataTable route = new Routes().getAllRoutes();
Clients.addMessage(50);
dt.TableName = "ClientesChofer";
this.snackthatClient.setCustomers(dt, Convert.ToInt16(route.Rows[0].ItemArray[0].ToString()));
DataTable dtProducts = new Products().getAllProducts(), dtSells = this.aR.callProcedure("getAllSells"), dtProductsSells = this.aR.callProcedure("getAllProductsSell");
Clients.addMessage(75);
dtProducts.TableName = "Productos";
dtSells.TableName = "RegistroVentas";
dtProductsSells.TableName = "ProductsSells";
this.snackthatClient.setSells(dtProducts, dtSells, dtProductsSells, Convert.ToInt16(route.Rows[0].ItemArray[0].ToString()));
Clients.addMessage(90);
this.aR.callProcedure("cleanAll");
Clients.addMessage(100);
}
catch (System.ServiceModel.EndpointNotFoundException ex)
{
Clients.addMessage(1000);
}
catch (Exception ex)
{
Clients.addMessage(2000);
}
}
