private void wizardControl1_SelectedPageChanged(object sender, WizardPageChangedEventArgs e) { if (e.Page == pageCreateDatabase) { Splash = new DevExpress.XtraSplashScreen.SplashScreenManager(this, typeof(Waiting.Wait), true, true); Splash.WaitForSplashFormClose(); if (!Splash.IsSplashFormVisible) { Splash.ShowWaitForm(); } do_SQLSettings(); if (DataBaseControl) { e.Page.AllowNext = true; do_CreateTable(); if (Splash.IsSplashFormVisible) { Splash.CloseWaitForm(); } } else { e.Page.AllowNext = false; do_CreateDatabese(); if (Splash.IsSplashFormVisible) { Splash.CloseWaitForm(); } } } if (e.Page == pageLisansDemo) { dt_RecordDate.EditValue = DateTime.Now; } }
private void do_FirstRecord() { if (Convert.ToString(txtKullaniciAdi.EditValue) == "") { XtraMessageBox.Show("Kullanıcı Adı Giriniz."); return; } if (Convert.ToString(txtUserParola.EditValue) == "") { XtraMessageBox.Show("Parola Giriniz."); return; } if (Convert.ToString(txtSirketAdi.EditValue) == "") { XtraMessageBox.Show("Şirket Adı Giriniz."); return; } if (Convert.ToString(txtDepotAdi.EditValue) == "") { XtraMessageBox.Show("Depo Adı Giriniz."); return; } try { Splash = new DevExpress.XtraSplashScreen.SplashScreenManager(this, typeof(Waiting.Wait), true, true); Splash.WaitForSplashFormClose(); if (!Splash.IsSplashFormVisible) { Splash.ShowWaitForm(); } SqlCommand sCommand = SqlCreateCommandFront(SqlConnectionString); sCommand.CommandText = "SELECT [TableName] = so.name FROM sysobjects so WHERE so.xtype = 'U' GROUP BY so.name "; DataTable tblTableList = ExecuteSelectCommand(sCommand); DataColumn[] KeysTableList = new DataColumn[1]; KeysTableList[0] = tblTableList.Columns["TableName"]; tblTableList.PrimaryKey = KeysTableList; #region Users if (tblTableList.Rows.Contains("Users") == false) { sCommand.CommandText = "CREATE TABLE [dbo].[Users]( " + " [id][int] IDENTITY(1, 1) NOT NULL, " + " [username] [nvarchar] (50) NOT NULL, " + " [password] [nvarchar] (50) NULL, " + " [note] [text] NULL, " + " [date] [datetime] NULL, " + " [Active] [bit] NULL, " + " [HaspPassword] [nvarchar] (50) NULL, " + " [Email] [nvarchar] (50) NULL, " + " [DefaultTheme] " + " [nvarchar] " + " (max) NULL, " + " [DefaultTheme2] [nvarchar] " + " (max) NULL, " + " [AdminAuthority] [bit] NULL, " + " [ReportPrint][bit] NULL, " + " [ExportExcelPdf] [bit] NULL, " + " [DailyEndOperation] [bit] NULL, " + " [EnvanterEntry] [bit] NULL, " + " [VeresiyeDefterClosed] [bit] NULL, " + " CONSTRAINT[PK_users] PRIMARY KEY CLUSTERED " + " ( " + " [username] ASC " + " )WITH(PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON[PRIMARY] " + " ) ON[PRIMARY] TEXTIMAGE_ON[PRIMARY]"; ExecuteNonQuery(sCommand); } sCommand.CommandText = "INSERT INTO [dbo].[Users] " + " ([username] " + " ,[password] " + " ,[date] " + " ,[Active] " + " ,[HaspPassword]) " + " VALUES " + " ('Admin' " + " ,@Password " + " ,@date " + " ,'True' " + " ,@HashPassword)"; sCommand.Parameters.Clear(); sCommand.Parameters.Add("Password", SqlDbType.NVarChar).Value = SecurityExtension.Sifrele("c4e128b141aFb"); sCommand.Parameters.Add("date", SqlDbType.DateTime).Value = DateTime.Now; sCommand.Parameters.Add("HashPassword", SqlDbType.NVarChar).Value = SecurityExtension.ConvertStringToMD5("c4e128b141aFb"); ExecuteNonQuery(sCommand); sCommand.CommandText = "INSERT INTO [dbo].[Users] " + " ([username] " + " ,[password] " + " ,[date] " + " ,[Active] " + " ,[HaspPassword]) " + " VALUES " + " (@userName " + " ,@Password " + " ,@date " + " ,'True' " + " ,@HashPassword)"; sCommand.Parameters.Clear(); sCommand.Parameters.Add("userName", SqlDbType.NVarChar).Value = txtKullaniciAdi.EditValue; sCommand.Parameters.Add("Password", SqlDbType.NVarChar).Value = SecurityExtension.Sifrele(txtUserParola.EditValue.ToString()); sCommand.Parameters.Add("date", SqlDbType.DateTime).Value = DateTime.Now; sCommand.Parameters.Add("HashPassword", SqlDbType.NVarChar).Value = SecurityExtension.ConvertStringToMD5(txtUserParola.EditValue.ToString()); ExecuteNonQuery(sCommand); #endregion #region Company if (tblTableList.Rows.Contains("Company") == false) { sCommand.CommandText = "CREATE TABLE [dbo].[Company]( " + " [RecId][int] IDENTITY(1, 1) NOT NULL, " + " [CompanyCode] [nvarchar] (50) NULL, " + " [CompanyName] [nvarchar] (50) NULL, " + " [Logo] [image] NULL, " + " [Adress1] [nvarchar] (50) NULL, " + " [Adress2] [nvarchar] (50) NULL, " + " [BulvarCadde] [nvarchar] (50) NULL, " + " [TelNo] [int] NULL, " + " [BinaAdi] [nvarchar] (50) NULL, " + " [BinaNo] [nvarchar] (50) NULL, " + " [MahalleSemt] [nvarchar] (50) NULL, " + " [Sehir] [nvarchar] (50) NULL, " + " [PostaKodu] [int] NULL, " + " [Ulke] [nvarchar] (50) NULL, " + " CONSTRAINT[PK_Company] PRIMARY KEY CLUSTERED " + " ( " + " [RecId] ASC " + " )WITH(PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON[PRIMARY] " + " ) ON[PRIMARY] TEXTIMAGE_ON[PRIMARY]"; ExecuteNonQuery(sCommand); } sCommand.CommandText = "INSERT INTO [dbo].[Company] ([CompanyCode], [CompanyName]) VALUES ('001', @companyName);SELECT SCOPE_IDENTITY();"; sCommand.Parameters.Clear(); sCommand.Parameters.Add("companyName", SqlDbType.NVarChar).Value = txtSirketAdi.EditValue; int CompanyRecId = Convert.ToInt32(ExecuteScalar(sCommand)); //ExecuteNonQuery(sCommand); #endregion #region Depo if (tblTableList.Rows.Contains("Depot") == false) { sCommand.CommandText = "CREATE TABLE [dbo].[Depot]( " + " [DID][int] IDENTITY(1, 1) NOT NULL, " + " [DepName] [nvarchar] (50) NULL, " + " [DepAddress] [nvarchar] (50) NULL, " + " [DepDistrict] [nvarchar] (50) NULL, " + " [DepCity] [nvarchar] (50) NULL, " + " [DepAuthPerson] [nvarchar] (50) NULL, " + " [DepPhoneOne] [nvarchar] (50) NULL, " + " [DepPhoneTwo] [nvarchar] (50) NULL, " + " [DepTaxAdministration] [nvarchar] (50) NULL, " + " [DepTaxNo] [nvarchar] (50) NULL, " + " [DepActive] [bit] NULL, " + " [DepDate] [datetime] NULL, " + " [CompanyRecId] [int] NULL, " + " CONSTRAINT[PK_Depot] PRIMARY KEY CLUSTERED " + " ( " + " [DID] ASC " + " )WITH(PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON[PRIMARY] " + " ) ON[PRIMARY]"; ExecuteNonQuery(sCommand); } sCommand.CommandText = "INSERT INTO [dbo].[Depot] ([DepName],[CompanyRecId]) VALUES (@DepName, @CompanyRecId)"; sCommand.Parameters.Clear(); sCommand.Parameters.Add("DepName", SqlDbType.NVarChar).Value = txtDepotAdi.EditValue; sCommand.Parameters.Add("CompanyRecId", SqlDbType.Int).Value = CompanyRecId; ExecuteNonQuery(sCommand); #endregion #region ApplicatonServer if (tblTableList.Rows.Contains("ApplicationServer") == false) { sCommand.CommandText = "CREATE TABLE [dbo].[ApplicationServer]( " + " [Id][int] IDENTITY(1, 1) NOT NULL, " + " " + " [Server] [nvarchar] " + " (max) NULL, " + " " + " [ServerName] [nvarchar] " + " (max) NULL, " + " " + " [UserName] [nvarchar] (200) NULL, " + " [Password] " + " [nvarchar] " + " (max) NULL, " + " " + " [DataBase] [nvarchar] (50) NULL, " + " CONSTRAINT[PK_ApplicationServer] PRIMARY KEY CLUSTERED " + " ( " + " [Id] ASC " + " )WITH(PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON[PRIMARY] " + " ) ON[PRIMARY] TEXTIMAGE_ON[PRIMARY]"; ExecuteNonQuery(sCommand); } string[] conArry; conArry = SqlConnectionString.Split(';'); List <string> conn = new List <string>(); foreach (var item in conArry) { int position = item.IndexOf("="); if (position < 0) { continue; } conn.Add(item.Substring(position + 1)); } if (SqlLocal) { sCommand.CommandText = "INSERT INTO [dbo].[ApplicationServer] " + " ([Server] " + " ,[ServerName] " + " ,[UserName] " + " ,[Password] " + " ,[DataBase])" + " VALUES " + " (@server " + " ,@serverName " + " ,'' " + " ,'' , @DataBase)"; sCommand.Parameters.Clear(); sCommand.Parameters.Add("server", SqlDbType.NVarChar).Value = "(localdb)\\MSSQLLocalDB"; sCommand.Parameters.Add("serverName", SqlDbType.NVarChar).Value = "SQLLocal"; sCommand.Parameters.Add("DataBase", SqlDbType.NVarChar).Value = "Msp"; ExecuteNonQuery(sCommand); } else { //sCommand.CommandText = "INSERT INTO [dbo].[ApplicationServer] " // + " ([Server] " // + " ,[ServerName] " // + " ,[UserName] " // + " ,[Password] " // + " ,[DataBase])" // + " VALUES " // + " (@server " // + " ,@serverName " // + " ,'' " // + " ,'' , @DataBase)"; //sCommand.Parameters.Clear(); //sCommand.Parameters.Add("server", SqlDbType.NVarChar).Value = "(localdb)\\MSSQLLocalDB"; //sCommand.Parameters.Add("serverName", SqlDbType.NVarChar).Value = "SQLLocal"; //sCommand.Parameters.Add("DataBase", SqlDbType.NVarChar).Value = "Msp"; //ExecuteNonQuery(sCommand); } #endregion #region Parameter if (tblTableList.Rows.Contains("Parameters") == false) { sCommand.CommandText = "CREATE TABLE [dbo].[Parameters]( " + " [RecId][int] IDENTITY(1, 1) NOT NULL, " + " [NumaratorShow] [bit] NULL, " + " [SaleApproval] [bit] NULL, " + " [SaleOutOfStock] [bit] NULL, " + " [SaleCahnge] [bit] NULL, " + " [SaleInformationSlip] [bit] NULL, " + " [MainSaleForm] [bit] NULL, " + " [AutoCurrency] [bit] NULL, " + " [UserRecordMy] [bit] NULL, " + " [PaymentLock] [bit] NULL, " + " [PaymentyForced] [bit] NULL, " + " [SaleNewRecord] [bit] NULL, " + " [SaleProductEndDate] [bit] NULL, " + " [ProductEndDateDay] [int] NULL, " + " CONSTRAINT[PK_Parameters] PRIMARY KEY CLUSTERED " + " ( " + " [RecId] ASC " + " )WITH(PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON[PRIMARY] " + " ) ON[PRIMARY]"; ExecuteNonQuery(sCommand); } sCommand.CommandText = "INSERT INTO [dbo].[Parameters] " + " ([NumaratorShow] " + " ,[SaleApproval] " + " ,[SaleOutOfStock] " + " ,[SaleCahnge] " + " ,[SaleInformationSlip] " + " ,[MainSaleForm] " + " ,[AutoCurrency] " + " ,[UserRecordMy] " + " ,[PaymentLock] " + " ,[PaymentyForced] " + " ,[SaleNewRecord] " + " ,[SaleProductEndDate] " + " ,[ProductEndDateDay]) " + " VALUES " + " ('True' " + " ,'False' " + " ,'False' " + " ,'False' " + " ,'False' " + " ,'False' " + " ,'False' " + " ,'False' " + " ,'False' " + " ,'True' " + " ,'True' " + " ,'False' " + " ,10)"; sCommand.Parameters.Clear(); ExecuteNonQuery(sCommand); #endregion #region Currency if (tblTableList.Rows.Contains("CurrencyType") == false) { sCommand.CommandText = "CREATE TABLE [dbo].[CurrencyType]( " + " [RecId][int] IDENTITY(1, 1) NOT NULL, " + " [CurrencyCode] [varchar] (3) NOT NULL, " + " [Remark] [varchar] (50) NULL, " + " [CompanyRecId] [int] NULL, " + " CONSTRAINT[PK_CurrencyType] PRIMARY KEY CLUSTERED " + "( " + " [CurrencyCode] ASC " + ")WITH(PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON[PRIMARY] " + ") ON[PRIMARY]"; ExecuteNonQuery(sCommand); } sCommand.CommandText = "INSERT INTO [dbo].[CurrencyType] ([CurrencyCode],[Remark],[CompanyRecId]) VALUES ('TL','TL',@CompanyRecId) "; sCommand.Parameters.Clear(); sCommand.Parameters.Add("CompanyRecId", SqlDbType.Int).Value = CompanyRecId; ExecuteNonQuery(sCommand); sCommand.CommandText = "INSERT INTO [dbo].[CurrencyType] ([CurrencyCode],[Remark],[CompanyRecId]) VALUES ('USD','USD',@CompanyRecId) "; sCommand.Parameters.Clear(); sCommand.Parameters.Add("CompanyRecId", SqlDbType.Int).Value = CompanyRecId; ExecuteNonQuery(sCommand); #endregion #region ProgramsControl if (tblTableList.Rows.Contains("ProgramsControl") == false) { sCommand.CommandText = "CREATE TABLE [dbo].[ProgramsControl]( " + " [RecId][int] IDENTITY(1, 1) NOT NULL, " + " [MspVersion] [nvarchar] (50) NULL, " + " [Licence] [nvarchar] (50) NULL, " + " [FirstDate] [datetime] NULL, " + " [MacAdress] [nvarchar] (50) NULL, " + " [IpAdress] [nvarchar] (50) NULL, " + " [LocalIpAdress] [nvarchar] (50) NULL, " + " [IsDemo] [bit] NULL, " + " CONSTRAINT[PK_ProgramsControl] PRIMARY KEY CLUSTERED " + " ( " + " [RecId] ASC " + " )WITH(PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON[PRIMARY] " + " ) ON[PRIMARY]"; ExecuteNonQuery(sCommand); } sCommand.CommandText = "INSERT INTO [dbo].[ProgramsControl]([MspVersion],[Licence],[FirstDate],[IsDemo]) VALUES ('1.0.0.0','',@date,@Demo)"; sCommand.Parameters.Clear(); sCommand.Parameters.Add("Demo", SqlDbType.Bit).Value = IsDemo; sCommand.Parameters.Add("date", SqlDbType.DateTime).Value = dt_RecordDate.DateTime; //sCommand.Parameters.Add("MacAdress", SqlDbType.NVarChar).Value = AppMain.MAcAdress; //sCommand.Parameters.Add("IpAdress", SqlDbType.NVarChar).Value = AppMain.IpAdress; //sCommand.Parameters.Add("LocalIp", SqlDbType.NVarChar).Value = AppMain.LocalIpAdress; ExecuteNonQuery(sCommand); #endregion #region PaymentType if (tblTableList.Rows.Contains("PaymentType") == false) { sCommand.CommandText = "CREATE TABLE [dbo].[PaymentType]( " + " [RecId][int] IDENTITY(1, 1) NOT NULL, " + " [Remark] [nvarchar] (50) NULL, " + " CONSTRAINT[PK_PaymentType] PRIMARY KEY CLUSTERED " + " ( " + " [RecId] ASC " + " )WITH(PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON[PRIMARY] " + " ) ON[PRIMARY]"; ExecuteNonQuery(sCommand); } sCommand.CommandText = "INSERT INTO [dbo].[PaymentType] ([Remark]) VALUES ('Nakit')"; sCommand.Parameters.Clear(); ExecuteNonQuery(sCommand); sCommand.CommandText = "INSERT INTO [dbo].[PaymentType] ([Remark]) VALUES ('Pos')"; sCommand.Parameters.Clear(); ExecuteNonQuery(sCommand); sCommand.CommandText = "INSERT INTO [dbo].[PaymentType] ([Remark]) VALUES ('Pos & Nakit')"; sCommand.Parameters.Clear(); ExecuteNonQuery(sCommand); #endregion } catch (Exception ex) { XtraMessageBox.Show(ex.Message); } finally { if (Splash.IsSplashFormVisible) { Splash.CloseWaitForm(); } string path = @"C:\Msp\ConnectString.txt"; if (!File.Exists(path)) { using (StreamWriter sw = File.CreateText(path)) { string sifrele = SecurityExtension.Sifrele(SqlConnectionString); sw.WriteLine(sifrele); } } pageLisansDemo.AllowNext = true; } }