/// <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;
}
