public ActionResult ImportBulkConnections(ImportConnectionListModel model)
        {
            long fid = model.selectedFolderID;

            User userObj = (User)Session["user"];
            Account accountObj = (Account)Session["account"];
            long numberOfConnections = 0;

            var folderName = CCFolderRepository.CCFolders.FirstOrDefault(f => f.FolderID == fid & f.AccountGUID == accountObj.AccountGUID).Name;
            ViewBag.foldername = folderName;
            ConnectionImportListSummaryModel connSummary = new ConnectionImportListSummaryModel();

            if (Request.Files.Count > 0)
            {
                var file = Request.Files[0];

                if (file != null && file.ContentLength > 0)
                {
                    var fileName = Path.GetFileName(file.FileName);
                    var path = Path.Combine(Server.MapPath("~/App_Data/uploads"), fileName);
                    string fileExtension = System.IO.Path.GetExtension(path);

                    if (fileExtension == ".xls" || fileExtension == ".xlsx")
                    {
                        ViewBag.MessageExtention = "";

                        file.SaveAs(path);

                        LimitationsViewModel limitationsObj = (LimitationsViewModel)Session["limitations"];

                        long maxConnectionImportCount = limitationsObj.availableCconnectionCount;

                        ConnectionImporter importConnection = new ConnectionImporter(CCConnectinRepository, CCFolderRepository, CCCredentialRepository, CCFieldMappingsRepository);
                        connSummary = importConnection.ImportConnections(fid, accountObj.AccountGUID, path, fileExtension, model.SelectedCredentialID, model.SelectedImporsanationOrDelegation, model.SyncDirection, maxConnectionImportCount);

                        if (System.IO.File.Exists(path))
                        {
                            System.IO.File.Delete(path);
                        }

                        //if (numberOfConnections > 0)
                        //{
                        //    ViewBag.MessagePass = "******" + (numberOfConnections - 1) + " contacts were imported.";
                        //    ViewBag.Message = "";
                        //}
                        //else
                        //{
                        //    ViewBag.Message = "No matching fields were found in the imported file. O contacts imported.";
                        //    ViewBag.MessagePass = "";
                        //}
                    }
                    else
                    {
                        ViewBag.MessageExtention = "Please select the .xls or .xlsx file";
                    }
                }
            }

            LimitationsViewModel limitationsObjMain = (LimitationsViewModel)Session["limitations"];
            HelperFunctions HF = new HelperFunctions();
            limitationsObjMain = HF.updateAccountLimitations(accountObj);
            Session["limitations"] = limitationsObjMain;

            Session["newConnections"] = connSummary;

            return RedirectToAction("ViewConnections", "Folder", new { id = fid });
        }
        public ActionResult ImportBulkConnections(int fid)
        {
            User userObj = (User)Session["user"];
            Account accountObj = (Account)Session["account"];
            var model = new ImportConnectionListModel();

            var folderName = CCFolderRepository.CCFolders.FirstOrDefault(f => f.FolderID == fid).Name;
            ViewBag.foldername = folderName;

            var FolderDetails = CCFolderRepository.CCFolders.Where(f => f.FolderID == fid).FirstOrDefault();

            model.ExistingCredentials = CCCredentialRepository.Credentials.Where(aguid => aguid.AccountGUID == accountObj.AccountGUID).ToList();
            model.selectedFolderID = FolderDetails.FolderID;

            if (FolderDetails.Type == 2)
            {
                model.ItemType = "Calendar";
            }
            else
            {
                model.ItemType = "Contacts";
            }

            return View(model);
        }