/// <summary> /// Intitalise multiple models and kick start oauth/sync /// </summary> /// <returns></returns> public ActionResult Index() { multiplemodels = new Multiplemodels(); multiplemodels.SyncObjectsModel = new Syncdto(); multiplemodels.OAuthorizationModel = new OAuthorizationdto(); multiplemodels.TimeActivityModel = new TimeActivitydto(); multiplemodels.IsReadySync = false; var oAuthModel = new OAuthService(multiplemodels.OAuthorizationModel).IsTokenAvailable(this); if (oAuthModel.IsConnected) { multiplemodels.IsReadySync = true; multiplemodels.OAuthorizationModel = oAuthModel; multiplemodels.IsConnected = oAuthModel.IsConnected; var syncService = new SyncService(oAuthModel); multiplemodels.SyncObjectsModel.OauthToken = oAuthModel; multiplemodels.SyncObjectsModel = syncService.IsEmpSync(multiplemodels.SyncObjectsModel, syncService); multiplemodels.SyncObjectsModel = syncService.IsCustSync(multiplemodels.SyncObjectsModel, syncService); multiplemodels.SyncObjectsModel = syncService.IsServiceItemSync(multiplemodels.SyncObjectsModel, syncService); multiplemodels.SyncObjectsModel.CompanyId = oAuthModel.Realmid; multiplemodels.SyncObjectsModel = syncRepo.Save(this, multiplemodels.SyncObjectsModel); multiplemodels.IsReadyTimeentry = multiplemodels.SyncObjectsModel.IsEmployeeSync || multiplemodels.SyncObjectsModel.IsCustomerSync || multiplemodels.SyncObjectsModel.IsServiceItemSync; multiplemodels.IsReadytoInvoice = false; return View(multiplemodels); } else { return View(multiplemodels); } }
/// <summary> /// Sequence : /// -->Get Token /// -->Get data to be pushed to QBO /// -->Call the service /// /// </summary> /// <param name="id"></param> /// <returns>RedirectToAction</returns> public ActionResult Customer(Int64 id) { OAuthorizationdto oAuthDetails = new OAuthService(new OAuthorizationdto()).GetAccessToken(this); syncService = new SyncService(oAuthDetails); syncObjects = id > 0 ? syncService.GetSyncObjects(this, id) : new Syncdto(); syncObjects.OauthToken = oAuthDetails; syncObjects.CompanyId = oAuthDetails.Realmid; if (!syncService.IsCustSync(syncObjects, syncService).IsCustomerSync) { syncObjects = syncService.GetDatafromDBCustomer(syncObjects); if (syncObjects.CustomerList.Count>0) { syncObjects = syncService.SyncCustomer(this, syncObjects); } } return RedirectToAction("Sync", "Home", new { id = syncObjects.Id, isConnected = oAuthDetails.IsConnected }); }
/// <summary> /// check for employees /// </summary> /// <param name="syncObjects"></param> /// <param name="service"></param> /// <returns></returns> public Syncdto IsEmpSync(Syncdto syncObjects, SyncService service) { Dictionary <string, bool> isSync = new Dictionary <string, bool>(); var empDataInDb = service.GetDatafromDBEmployee(syncObjects); if (empDataInDb.EmployeeList.Count > 0) { empDataInDb.IsEmployeeNoData = false; for (int i = 0; i < empDataInDb.EmployeeList.Count; i++) { string EXISTING_EMPLOYEE_QUERY = string.Format("select * from employee where active = true and givenName='{0}' and familyName= '{1}'", empDataInDb.EmployeeList[i].GivenName.Trim(), empDataInDb.EmployeeList[i].FamilyName.Trim()); QueryService <Employee> queryService = new QueryService <Employee>(service.ServiceContext); Employee resultFound = queryService.ExecuteIdsQuery(EXISTING_EMPLOYEE_QUERY).FirstOrDefault <Employee>(); if (resultFound != null) { empDataInDb.EmployeeList[i].Id = resultFound.Id; //indexIterator = i+1; isSync.Add(empDataInDb.EmployeeList[i].GivenName, true); } else { isSync.Add(empDataInDb.EmployeeList[i].GivenName, false); } } if (isSync.Where(x => x.Value == false).Any()) { empDataInDb.IsEmployeeSync = false; } else { empDataInDb.IsEmployeeSync = true; } } else { empDataInDb.IsEmployeeNoData = true; empDataInDb.IsEmployeeSync = false; } return(empDataInDb); }
/// <summary> /// check for customer /// </summary> /// <param name="syncObjects"></param> /// <param name="service"></param> /// <returns></returns> public Syncdto IsCustSync(Syncdto syncObjects, SyncService service) { Dictionary <string, bool> isSync = new Dictionary <string, bool>(); var custDataInDb = service.GetDatafromDBCustomer(syncObjects); if (custDataInDb.CustomerList.Count > 0) { custDataInDb.IsCustomerNodata = false; for (int i = 0; i < custDataInDb.CustomerList.Count; i++) { string EXISTING_CUSTOMER_QUERY = string.Format("select * from customer where active = true and givenName = '{0}' and familyName = '{1}'", custDataInDb.CustomerList[i].GivenName.Trim(), custDataInDb.CustomerList[i].FamilyName.Trim()); QueryService <Customer> queryService = new QueryService <Customer>(service.ServiceContext); Customer resultFound = queryService.ExecuteIdsQuery(EXISTING_CUSTOMER_QUERY).FirstOrDefault <Customer>(); if (resultFound != null) { custDataInDb.CustomerList[i].Id = resultFound.Id; isSync.Add(custDataInDb.CustomerList[i].GivenName, true); } else { isSync.Add(custDataInDb.CustomerList[i].GivenName, false); } } if (isSync.Where(x => x.Value == false).Any()) { custDataInDb.IsCustomerSync = false; } else { custDataInDb.IsCustomerSync = true; } } else { custDataInDb.IsCustomerNodata = true; custDataInDb.IsCustomerSync = false; } return(custDataInDb); }
/// <summary> /// Check for service item. /// </summary> /// <param name="syncObjects"></param> /// <param name="service"></param> /// <returns></returns> public Syncdto IsServiceItemSync(Syncdto syncObjects, SyncService service) { Dictionary <string, bool> isSync = new Dictionary <string, bool>(); var itemDataInDb = service.GetDatafromDBItem(syncObjects); if (itemDataInDb.ItemList.Count > 0) { itemDataInDb.IsServiceItemNodata = false; for (int i = 0; i < itemDataInDb.ItemList.Count; i++) { string EXISTING_ITEM_QUERY = string.Format("select * from Item where active = true and name = '{0}'", itemDataInDb.ItemList[i].Name.Trim()); QueryService <Item> queryService = new QueryService <Item>(service.ServiceContext); Item resultFound = queryService.ExecuteIdsQuery(EXISTING_ITEM_QUERY).FirstOrDefault <Item>(); if (resultFound != null) { itemDataInDb.ItemList[i].Id = resultFound.Id; isSync.Add(itemDataInDb.ItemList[i].Name, true); } else { isSync.Add(itemDataInDb.ItemList[i].Name, false); } } if (isSync.Where(x => x.Value == false).Any()) { itemDataInDb.IsServiceItemSync = false; } else { itemDataInDb.IsServiceItemSync = true; } } else { itemDataInDb.IsServiceItemNodata = true; itemDataInDb.IsServiceItemSync = false; } return(itemDataInDb); }
/// <summary> /// check for customer /// </summary> /// <param name="syncObjects"></param> /// <param name="service"></param> /// <returns></returns> public Syncdto IsCustSync(Syncdto syncObjects, SyncService service) { Dictionary<string, bool> isSync = new Dictionary<string, bool>(); var custDataInDb = service.GetDatafromDBCustomer(syncObjects); if (custDataInDb.CustomerList.Count > 0) { custDataInDb.IsCustomerNodata = false; for (int i = 0; i < custDataInDb.CustomerList.Count; i++) { string EXISTING_CUSTOMER_QUERY = string.Format("select * from customer where active = true and givenName = '{0}' and familyName = '{1}'", custDataInDb.CustomerList[i].GivenName.Trim(), custDataInDb.CustomerList[i].FamilyName.Trim()); QueryService<Customer> queryService = new QueryService<Customer>(service.ServiceContext); Customer resultFound = queryService.ExecuteIdsQuery(EXISTING_CUSTOMER_QUERY).FirstOrDefault<Customer>(); if (resultFound != null) { custDataInDb.CustomerList[i].Id = resultFound.Id; isSync.Add(custDataInDb.CustomerList[i].GivenName, true); } else { isSync.Add(custDataInDb.CustomerList[i].GivenName, false); } } if (isSync.Where(x => x.Value == false).Any()) { custDataInDb.IsCustomerSync = false; } else { custDataInDb.IsCustomerSync = true; } } else { custDataInDb.IsCustomerNodata = true; custDataInDb.IsCustomerSync = false; } return custDataInDb; }
/// <summary> /// Check for service item. /// </summary> /// <param name="syncObjects"></param> /// <param name="service"></param> /// <returns></returns> public Syncdto IsServiceItemSync(Syncdto syncObjects, SyncService service) { Dictionary<string, bool> isSync = new Dictionary<string, bool>(); var itemDataInDb = service.GetDatafromDBItem(syncObjects); if (itemDataInDb.ItemList.Count>0) { itemDataInDb.IsServiceItemNodata = false; for (int i = 0; i < itemDataInDb.ItemList.Count; i++) { string EXISTING_ITEM_QUERY = string.Format("select * from Item where active = true and name = '{0}'", itemDataInDb.ItemList[i].Name.Trim()); QueryService<Item> queryService = new QueryService<Item>(service.ServiceContext); Item resultFound = queryService.ExecuteIdsQuery(EXISTING_ITEM_QUERY).FirstOrDefault<Item>(); if (resultFound != null) { itemDataInDb.ItemList[i].Id = resultFound.Id; isSync.Add(itemDataInDb.ItemList[i].Name, true); } else { isSync.Add(itemDataInDb.ItemList[i].Name, false); } } if (isSync.Where(x => x.Value == false).Any()) { itemDataInDb.IsServiceItemSync = false; } else { itemDataInDb.IsServiceItemSync = true; } } else { itemDataInDb.IsServiceItemNodata = true; itemDataInDb.IsServiceItemSync = false; } return itemDataInDb; }
/// <summary> /// check for employees /// </summary> /// <param name="syncObjects"></param> /// <param name="service"></param> /// <returns></returns> public Syncdto IsEmpSync(Syncdto syncObjects, SyncService service) { Dictionary<string, bool> isSync = new Dictionary<string, bool>(); var empDataInDb = service.GetDatafromDBEmployee(syncObjects); if (empDataInDb.EmployeeList.Count > 0) { empDataInDb.IsEmployeeNoData = false; for (int i = 0; i < empDataInDb.EmployeeList.Count; i++) { string EXISTING_EMPLOYEE_QUERY = string.Format("select * from employee where active = true and givenName='{0}' and familyName= '{1}'", empDataInDb.EmployeeList[i].GivenName.Trim(), empDataInDb.EmployeeList[i].FamilyName.Trim()); QueryService<Employee> queryService = new QueryService<Employee>(service.ServiceContext); Employee resultFound = queryService.ExecuteIdsQuery(EXISTING_EMPLOYEE_QUERY).FirstOrDefault<Employee>(); if (resultFound != null) { empDataInDb.EmployeeList[i].Id = resultFound.Id; //indexIterator = i+1; isSync.Add(empDataInDb.EmployeeList[i].GivenName, true); } else { isSync.Add(empDataInDb.EmployeeList[i].GivenName, false); } } if (isSync.Where(x => x.Value == false).Any()) { empDataInDb.IsEmployeeSync = false; } else { empDataInDb.IsEmployeeSync = true; } } else { empDataInDb.IsEmployeeNoData = true; empDataInDb.IsEmployeeSync = false; } return empDataInDb; }