// GET: Pages/ContactInfo/Create public ActionResult Create(int?contactid, int?contactTypeID) { var siteCoID = siteusercompanyid; ViewBag.ContactCo = new SelectList(db.GetContactCompaniesBySiteCoID(siteCoID), "ViewID", "Company", siteCoID); ViewBag.Country = new SelectList(new CommonRepository().GetCountries(), "CountryID", "Country"); ViewBag.ContactType = new SelectList(db.GetPeopleTypesBySiteCoID(siteCoID), "ViewID", "Name", siteCoID); ViewBag.ContactSubType = new SelectList(db.GetContactSubTypesBySiteCoID(siteCoID), "ViewID", "Type", siteCoID); ViewBag.ContactStatus = new SelectList(db.SiteContactStatus.OrderBy(p => p.StatusOrder), "StatusID", "Status"); ViewBag.Owner = new SelectList(db.GetCoUsersBySiteCoID(siteCoID), "UserID", "User", siteCoID); ViewBag.ContactCustoms = db.GetContactCustomFieldsBySiteCoID(siteCoID).FirstOrDefault(); ViewBag.siteuserid = siteuserid; qbModels = new QBModels(); qbModels.SyncObjectsModel = new QBSyncdto(); qbModels.OAuthorizationModel = new QBAuthorizationdto(); qbModels.IsReadySync = false; var oAuthModel = new QBOAuthService(qbModels.OAuthorizationModel).IsTokenAvailable(this, siteusercompanyid); ViewBag.IsQBConnected = "false"; if (oAuthModel.IsConnected) { qbModels.IsReadySync = true; qbModels.OAuthorizationModel = oAuthModel; qbModels.IsConnected = oAuthModel.IsConnected; var syncService = new QBSyncService(oAuthModel); qbModels.SyncObjectsModel.OauthToken = oAuthModel; Random random = new Random(); SyncObjectsModelId = random.Next(1, 100); ViewBag.IsQBConnected = "true"; //SyncObjectsModelId = qbModels.SyncObjectsModel.Id; } GetContactInfoByContactID_Result Model = new GetContactInfoByContactID_Result(); Model.ViewID = 0; return(View(Model)); }
// GET: Sections/People public ActionResult Index() { //ViewBag.Sorting = new string[] { "Last", "First", "Company" }; //ViewBag.Company=new SelectList(db.GetContactCompaniesBySiteCoID(siteusercompanyid).ToList(),nameof(GetContactCompaniesBySiteCoID_Result.ViewID), nameof(GetContactCompaniesBySiteCoID_Result.Company)); ViewBag.CompanyList = db.GetContactCompaniesBySiteCoID(siteusercompanyid).Where(s => s.Company != null && s.Company.Trim() != "").ToList(); //ViewBag.ContactType = new SelectList(db.CoContactTypes.Where(p => p.SiteCoID == siteusercompanyid).OrderBy(p => p.ContactTypeOrder), "ContactTypeID", "ContactTypeName"); ViewBag.ContactTypeList = db.CoContactTypes.Where(p => p.SiteCoID == siteusercompanyid).OrderBy(p => p.ContactTypeOrder).ToList(); int siteCoID = base.siteusercompanyid; //var coContacts = db.CoContacts // .Where(p => p.SiteCoID == siteCoID) // .Include(c => c.CoContactCompanies) // .Include(p=>p.CoContactPhones) // .Include(p=>p.CoContactEmails) // //.Include(c => c.CoContactSubtypes) // .Include(c => c.CoContactTypes) // .Include(c => c.SiteContactStatus) // .OrderBy(p => p.ContactLastName).ThenBy(p => p.ContactFirstName).ThenBy(p=>p.CoContactCompanies.ContactCoName); CoQuickBooks cqb = db.CoQuickBooks.Where(p => p.SiteCoID == siteusercompanyid).FirstOrDefault(); if (cqb != null) { ViewBag.IsConnected = true; } qbModels = new QBModels(); //var q = coContacts.Where(p => p.ContactManager == siteuserid); // ViewBag.TotalRecords = q.Count(); //ViewBag.CurrentPage = 1; // ViewBag.CurrentSort = "Last"; // ViewBag.PageCount = Math.Ceiling(Convert.ToDouble(ViewBag.TotalRecords) / Convert.ToDouble(CommonCls.PageSize)); // List<CoContacts> listcontact = q.OrderBy(s=>s.ContactLastName).ToList(); //foreach (var item in listcontact) //{ // if (item.CoContactCompanies == null) // { // item.CoContactCompanies = new CoContactCompanies(); // } // if (item.CoContactTypes == null) // { // item.CoContactTypes = new CoContactTypes(); // } // if (item.CoContactSubtypes == null) // { // item.CoContactSubtypes = new CoContactSubtypes(); // } //} //List<ContactList> Contact = new List<ContactList>(); //Int64 Id = 0; //foreach (var C in listcontact) //{ // Id++; // ContactList Contact1 = new ContactList(); // Contact1.Id = Id; // Contact1.ContactFirstName = C.ContactFirstName; // Contact1.ContactLastName = C.ContactLastName; // Contact1.ContactCoName = C.CoContactCompanies.ContactCoName; // Contact1.ContactTypeName = C.CoContactTypes.ContactTypeName; // Contact1.SubtypeName = C.CoContactSubtypes.SubtypeName; // Contact.Add(Contact1); //} //ViewBag.ContactsList = Contact; //qbModels.coContacts = listcontact;//coContacts.Where(p=>p.ContactManager==siteuserid).ToList().ForEach(s=>s.CoContactCompanies==null ? s.CoContactCompanies = new CoContactCompanies() : s.CoContactCompanies = s.CoContactCompanies); qbModels.SyncObjectsModel = new QBSyncdto(); qbModels.OAuthorizationModel = new QBAuthorizationdto(); qbModels.IsReadySync = false; var oAuthModel = new QBOAuthService(qbModels.OAuthorizationModel).IsTokenAvailable(this, siteCoID); if (oAuthModel.IsConnected) { qbModels.IsReadySync = true; qbModels.OAuthorizationModel = oAuthModel; qbModels.IsConnected = oAuthModel.IsConnected; var syncService = new QBSyncService(oAuthModel); qbModels.SyncObjectsModel.OauthToken = oAuthModel; // qbModels.SyncObjectsModel = syncService.IsCustSync(qbModels.SyncObjectsModel, syncService, siteusercompanyid); qbModels.SyncObjectsModel.CompanyId = oAuthModel.Realmid; qbModels.SyncObjectsModel = Save(this, qbModels.SyncObjectsModel); qbModels.IsReadyTimeentry = qbModels.SyncObjectsModel.IsCustomerSync; qbModels.IsReadytoInvoice = false; return(View(qbModels)); } else { return(View(qbModels)); } }