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;
}
}
