CloudCommands.cs 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298
  1. using FastReport.Auth;
  2. using FastReport.Cloud.FastReport;
  3. using FastReport.Cloud.FastReport.ListViewCloud;
  4. using FastReport.Cloud.FastReport.Models;
  5. using FastReport.Cloud.FastReport.Models.DataSource;
  6. using FastReport.Data;
  7. using FastReport.Forms;
  8. using FastReport.Utils;
  9. using System;
  10. using System.IO;
  11. using System.Net;
  12. using System.Threading.Tasks;
  13. using System.Windows.Forms;
  14. namespace FastReport.Design
  15. {
  16. internal static class CloudCommands
  17. {
  18. private static bool isAborted;
  19. private static AuthService.AppUser User => AuthService.Instance.User;
  20. private static void ShowWindowUntilAuthentificatedOrAborted()
  21. {
  22. while (!User.IsAuthentificatedAndActive && !isAborted)
  23. {
  24. ShowAuthWindow();
  25. }
  26. }
  27. private static void ShowAuthWindow()
  28. {
  29. using (AuthForm authPage = new AuthForm())
  30. {
  31. if (authPage.ShowDialog() == DialogResult.OK)
  32. {
  33. if (!User.IsAuthentificatedAndActive)
  34. {
  35. var localizator = new MyRes("Forms,ListViewForm");
  36. MessageBox.Show(localizator.Get("AuthError"),
  37. localizator.Get("AuthErrorCaption"), MessageBoxButtons.OK);
  38. }
  39. }
  40. else
  41. {
  42. isAborted = true;
  43. }
  44. }
  45. }
  46. private static void CheckAndSetReportProvider()
  47. {
  48. if (ProviderManager.Provider == null || ProviderManager.Subscriptions == null ||
  49. ProviderManager.Subscription == null || ProviderManager.Provider != ProviderManager.Provider.Templates)
  50. {
  51. ProviderManager.SetProvider(new FRCloudProvider(AuthService.Instance), Modes.CloudFilesMode.Templates);
  52. }
  53. }
  54. private static CreateDataSourceVM CreateCloudConnection(DataConnectionBase data)
  55. {
  56. CreateDataSourceVM dsVM = new CreateDataSourceVM();
  57. if (data.ClassName.StartsWith("MsSql"))
  58. dsVM.ConnectionType = DataSourceConnectionType.MSSQL;
  59. else if (data.ClassName.StartsWith("Firebird"))
  60. dsVM.ConnectionType = DataSourceConnectionType.FirebirdDB;
  61. else if (data.ClassName.StartsWith("Mongo"))
  62. dsVM.ConnectionType = DataSourceConnectionType.MongoDB;
  63. else if (data.ClassName.StartsWith("Postgres"))
  64. dsVM.ConnectionType = DataSourceConnectionType.Postgres;
  65. else if (data.ClassName.StartsWith("Oracle"))
  66. dsVM.ConnectionType = DataSourceConnectionType.OracleDB;
  67. else if (data.ClassName.StartsWith("MySql"))
  68. dsVM.ConnectionType = DataSourceConnectionType.MySQL;
  69. else if (data.ClassName.StartsWith("Json"))
  70. dsVM.ConnectionType = DataSourceConnectionType.JSON;
  71. else if (data.ClassName.StartsWith("Xml"))
  72. dsVM.ConnectionType = DataSourceConnectionType.XML;
  73. else if (data.ClassName.ToLower().StartsWith("CSV"))
  74. dsVM.ConnectionType = DataSourceConnectionType.CSV;
  75. else
  76. throw new Exception("Error in creating connection");
  77. dsVM.ConnectionString = data.ConnectionString;
  78. dsVM.Name = data.Name;
  79. dsVM.SubscriptionId = ProviderManager.Subscription.Id;
  80. return dsVM;
  81. }
  82. private static FileVM SaveFile(Report report, Modes.CloudFilesMode cloudFilesMode)
  83. {
  84. if (!CheckAuthentication())
  85. return null;
  86. if (AuthService.Instance.CanRefresh)
  87. {
  88. AuthService.Instance.Refresh();
  89. }
  90. using (ListViewCloudForm form = new ListViewCloudForm())
  91. {
  92. form.Mode = Modes.FormOpenMode.SaveMode;
  93. FilesModeItem.FilesMode = cloudFilesMode;
  94. form.SetReportTextBox(report.GetReportName + FilesModeItem.ToString());
  95. form.ReportToSave = report;
  96. if (!form.OnLoad(new FRCloudProvider(AuthService.Instance)))
  97. {
  98. return null;
  99. }
  100. form.ShowDialog();
  101. return form.CreatedFile;
  102. }
  103. }
  104. // loads file using dialog window. Can be used to load either template or a prepared report.
  105. private static OpeningInstance LoadFileDialog(Modes.CloudFilesMode cloudFilesMode)
  106. {
  107. if (!CheckAuthentication())
  108. return null;
  109. if (AuthService.Instance.CanRefresh)
  110. AuthService.Instance.Refresh();
  111. using (ListViewCloudForm form = new ListViewCloudForm())
  112. {
  113. form.Mode = Modes.FormOpenMode.OpenMode;
  114. FilesModeItem.FilesMode = cloudFilesMode;
  115. //form.FilesMode = CloudFilesMode; // error with creating report
  116. while (!form.OnLoad(new FRCloudProvider(AuthService.Instance)))
  117. {
  118. ShowAuthWindow();
  119. if (isAborted)
  120. return null;
  121. }
  122. form.ShowDialog();
  123. return form.Instance;
  124. }
  125. }
  126. public static bool CheckAuthentication()
  127. {
  128. isAborted = false;
  129. ShowWindowUntilAuthentificatedOrAborted();
  130. return User.IsAuthentificatedAndActive && !isAborted;
  131. }
  132. public static FileVM SaveReportFile(Report report) => SaveFile(report, Modes.CloudFilesMode.Templates);
  133. public static FileVM SavePreviewFile(Report report) => SaveFile(report, Modes.CloudFilesMode.Reports);
  134. public static bool Resave(Report report)
  135. {
  136. CheckAndSetReportProvider();
  137. return FileManager.ResaveCommand(report);
  138. }
  139. public static Stream LoadPreviewFile()
  140. {
  141. var instance = LoadFileDialog(Modes.CloudFilesMode.Reports);
  142. return instance?.ReportStream;
  143. }
  144. // loads report template file using dialog.
  145. public static OpeningInstance LoadFile()
  146. {
  147. return LoadFileDialog(Modes.CloudFilesMode.Templates);
  148. }
  149. // loads specified report template file. Throws an exception if load failed.
  150. // This method is used by recent file list. CheckAuthentication call is required beforehand
  151. public static async Task<OpeningInstance> LoadFile(string key, string id)
  152. {
  153. return await Task.Run(() =>
  154. {
  155. if (AuthService.Instance.CanRefresh)
  156. AuthService.Instance.Refresh();
  157. }).ContinueWith(_ =>
  158. {
  159. CheckAndSetReportProvider();
  160. return new OpeningInstance((FileManager.DownloadFileCommand(id)).Stream,
  161. key, id, null, FileManager.GetFileCommand(id).EditedTime);
  162. });
  163. }
  164. public static void PreviewReport(Report report)
  165. {
  166. XmlItem xi = Config.Root.FindItem("Auth").FindItem("ConnectionInfo");
  167. string serverFromConfig = xi.GetProp("Server");
  168. string host = string.IsNullOrEmpty(serverFromConfig) ? Res.Get("Forms,ServerWindow,DefaultServerHost") : serverFromConfig;
  169. string uri = host + @"/staticpreview/t/" + report.CloudFileInfo.FileId;
  170. ProcessHelper.StartProcess(uri);
  171. }
  172. public static DataConnectionBase GetDataConnection()
  173. {
  174. if (!CheckAuthentication())
  175. return null;
  176. if (AuthService.Instance.CanRefresh)
  177. AuthService.Instance.Refresh();
  178. using (CloudDataSourceForm form = new CloudDataSourceForm())
  179. {
  180. if (!form.SetProvider())
  181. return null;
  182. form.OnLoad();
  183. form.ShowDialog();
  184. if (form.dataConnection != null)
  185. {
  186. var connection = form.dataConnection;
  187. connection.TablesStructure = form.tableStructure;
  188. connection.CloudId = form.dataSourceId;
  189. connection.CloudInfo.Name = form.dataConnection.Name;
  190. connection.CloudInfo.ConnectionString = form.dataConnection.ConnectionString;
  191. return connection;
  192. }
  193. }
  194. return null;
  195. }
  196. public static void UploadDataConnection(DataConnectionBase data)
  197. {
  198. if (!CheckAuthentication())
  199. return;
  200. CheckAndSetReportProvider();
  201. if (AuthService.Instance.CanRefresh)
  202. AuthService.Instance.Refresh();
  203. var dsVM = CreateCloudConnection(data);
  204. if (ProviderManager.DataSourcesProvider == null)
  205. ProviderManager.DataSourcesProvider = new FRCloudDataSourcesProvider(AuthService.Instance);
  206. try
  207. {
  208. if (string.IsNullOrEmpty(data.CloudId))
  209. DataSourceManager.CreateDataSourceCommand(dsVM);
  210. else
  211. {
  212. try
  213. {
  214. DataSourceManager.FetchDataCommand(data.CloudId);
  215. DataSourceManager.UpdateDataSourceSubscriptionCommand(data.CloudId, new UpdateDataSourceSubcriptionVM()
  216. {
  217. SubscriptionId = ProviderManager.Subscription.Id
  218. });
  219. if (data.CloudInfo.Name != data.Name)
  220. DataSourceManager.RenameDataSourceCommand(data.CloudId, new RenameDataSourceVM() { Name = data.Name });
  221. if (data.CloudInfo.ConnectionString != data.ConnectionString)
  222. DataSourceManager.UpdateConnectionStringCommand(data.CloudId, new UpdateDataSourceConnectionStringVM()
  223. {
  224. ConnectionString = data.ConnectionString
  225. });
  226. }
  227. catch (WebException exception)
  228. {
  229. if (((HttpWebResponse)exception.Response).StatusCode == HttpStatusCode.BadRequest)
  230. {
  231. MessageBox.Show(Res.Get("Forms,DataWizard,MessageBox,ErrorInvalidID"),
  232. Res.Get("Forms,DataWizard,MessageBox,ErrorCaption"), MessageBoxButtons.OK, MessageBoxIcon.Error);
  233. }
  234. if (((HttpWebResponse)exception.Response).StatusCode == HttpStatusCode.NotFound)
  235. {
  236. MessageBox.Show(Res.Get("Forms,DataWizard,MessageBox,Error404"),
  237. Res.Get("Forms,DataWizard,MessageBox,ErrorCaption"), MessageBoxButtons.OK, MessageBoxIcon.Error);
  238. }
  239. return;
  240. }
  241. }
  242. if (string.IsNullOrEmpty(data.CloudId))
  243. MessageBox.Show(Res.Get("Forms,DataWizard,MessageBox,SuccessText"),
  244. Res.Get("Forms,DataWizard,MessageBox,SuccessCaption"), MessageBoxButtons.OK);
  245. else
  246. MessageBox.Show(Res.Get("Forms,DataWizard,MessageBox,SuccessUpdateText"),
  247. Res.Get("Forms,DataWizard,MessageBox,SuccessUpdateCaption"), MessageBoxButtons.OK);
  248. }
  249. catch (Exception exception)
  250. {
  251. MessageBox.Show(Res.Get("Forms,DataWizard,MessageBox,ErrorText"),
  252. Res.Get("Forms,DataWizard,MessageBox,ErrorCaption"), MessageBoxButtons.OK, MessageBoxIcon.Error);
  253. }
  254. }
  255. }
  256. }