public string deleteForm(Int64?Id) { string message = string.Empty; try { TblForm form = _context.TblForm.Where(i => i.Id == Id).FirstOrDefault(); if (form != null) { _context.TblForm.Remove(form); } _context.SaveChanges(); message = Constants.templateDelete; } catch (SqlException sqlEx) { //sqlEx. } catch (Exception ex) { message = "form is used within this system"; // other exception... } return(message); }
public bool UpdateForm(TblForm form) { TblForm oldForm = _context.TblForm.Where(i => i.Id == form.Id).FirstOrDefault(); if (oldForm != null) { oldForm.Name = form.Name; oldForm.CreatedDate = form.CreatedDate; oldForm.Url = form.Url; } return(_context.SaveChanges() > 0 ? true : false); }
public IActionResult SaveUpdate(Int64?Id, string Name, string CreatedDate, string Url) { TblForm form = new TblForm(); form.Name = Name; form.CreatedDate = Convert.ToDateTime(CreatedDate); form.Url = Url; if (Id > 0) { form.Id = Convert.ToInt64(Id); if (_user.UpdateForm(form)) { TempData["Success"] = Constants.FormUpdated; } } else { if (_user.SaveForm(form)) { TempData["Success"] = Constants.FormSaved; } } return(View("Index")); }
public bool SaveForm(TblForm form) { form.IsActive = 1; _context.TblForm.Add(form); return(_context.SaveChanges() > 0 ? true : false); }
public string GetDriveData() { try { UserCredential credential; using (var stream = new FileStream("credentials.json", FileMode.Open, FileAccess.Read)) { // The file token.json stores the user's access and refresh tokens, and is created // automatically when the authorization flow completes for the first time. string credPath = "token.json"; credential = GoogleWebAuthorizationBroker.AuthorizeAsync( GoogleClientSecrets.Load(stream).Secrets, Scopes, "user", CancellationToken.None, new FileDataStore(credPath, true)).Result; Console.WriteLine("Credential file saved to: " + credPath); } // Create Drive API service. var service = new DriveService(new BaseClientService.Initializer() { HttpClientInitializer = credential, ApplicationName = ApplicationName, }); // Define parameters of request. FilesResource.ListRequest listRequest = service.Files.List(); listRequest.PageSize = 10; listRequest.Fields = "nextPageToken, files(id, name,fullFileExtension,fileExtension,exportLinks,mimeType,viewersCanCopyContent,webContentLink,webViewLink,originalFilename,properties,shared)"; // listRequest.Fields = "nextPageToken, files(appProperties,capabilities,contentHints,contentRestrictions,copyRequiresWriterPermission,createdTime,createdTimeRaw,description,driveId, eTag, explicitlyTrashed,exportLinks,fileExtension,folderColorRgb,fullFileExtension,hasAugmentedPermissions,hasThumbnail,headRevisionId,iconLink,id,imageMediaMetadata,isAppAuthorized,kind,lastModifyingUser,md5Checksum,mimeType,modifiedByMe,modifiedByMeTime,modifiedByMeTimeRaw,modifiedTime,modifiedTimeRaw,name,originalFilename,ownedByMe,owners,parents,permissionIds,permissions,properties,quotaBytesUsed,shared,sharedWithMeTime,sharedWithMeTimeRaw,sharingUser,shortcutDetails,size,spaces,starred,teamDriveId,thumbnailLink,thumbnailVersion,trashed,trashedTime,trashedTimeRaw,trashingUser,version,videoMediaMetadata,viewedByMe,viewedByMeTime,viewedByMeTimeRaw,viewersCanCopyContent,webContentLink,webViewLink,writersCanShare)"; // List files. IList <Google.Apis.Drive.v3.Data.File> files = listRequest.Execute() .Files; Console.WriteLine("Files:"); List <TblForm> tblForms = new List <TblForm>(); TblForm tblForm; if (files != null && files.Count > 0) { foreach (var file in files) { string link; if (file.MimeType.Contains("google-apps.form")) { tblForm = new TblForm(); link = ESS.SFS.Helper.Constants.GooglePageIFrame; link = link.Replace("<<url>>", file.WebViewLink.Replace("edit?usp=drivesdk", "")); tblForm.CreatedDate = DateTime.Now; tblForm.Name = file.Name; tblForm.IsActive = 1; tblForm.Url = link; tblForm.GoogleFormId = file.Id; tblForms.Add(tblForm); } } if (tblForms.Count > 0) { error = _form.ImportData(tblForms); } } return(error = ""); } catch (Exception ex) { StringBuilder sb = new StringBuilder(); sb.Append(ex.InnerException); sb.Append(ex.Message); // flush every 20 seconds as you do it System.IO.File.AppendAllText(AppDomain.CurrentDomain.BaseDirectory + "log.txt", sb.ToString()); // System.IO.File.AppendAllText(Path.Combine(_webHostEnvironment.WebRootPath + "/App_Shared/log.txt") , sb.ToString()); sb.Clear(); throw; } }
public void addFormForTesting(TblForm tblForm) { _context.TblForm.Add(tblForm); _context.SaveChanges(); }