private void btnSave_Click(object sender, EventArgs e)
{
string vstrPassword = "", strDuplicate = "";
if (uctxtLogInName.Text == "")
{
MessageBox.Show("Name Cannot be Empty");
uctxtLogInName.Focus();
return;
}
if (uctxtPasswoed.Text == "")
{
MessageBox.Show("Name Cannot be Empty");
uctxtPasswoed.Focus();
return;
}
if (uctxtPasswoed.Text.Length < 6)
{
MessageBox.Show("Lenght Should be More then 6");
uctxtPasswoed.Focus();
return;
}
if (strFormName == "Change PassWord")
{
if (txtOldPassWord.Text == "")
{
MessageBox.Show("Old PassWord Cannot be Empty");
txtOldPassWord.Focus();
return;
}
string vstrOldPass = Utility.gstrGetOldPassWord(strComID, Utility.gstrUserName);
//vstrOldPass = Utility.Decrypt(strstring, Utility.gstrUserName);
//Utility.Decrypt(rsget["USER_PASS"].ToString(), rsget["USER_LOGIN_NAME"].ToString()).ToString();
if (vstrOldPass.Trim() != txtOldPassWord.Text.Trim())
{
MessageBox.Show("Old PassWord is Mismatch");
txtOldPassWord.Focus();
return;
}
}
//if (_strImageName != "")
//{
MemoryStream ms = new MemoryStream();
pbImage.Image.Save(ms, ImageFormat.Jpeg);
_imageData = new byte[ms.Length];
ms.Position = 0;
ms.Read(_imageData, 0, _imageData.Length);
// _imageData = pbImage.Image.ToByteArray();
//}
if (m_action == (int)Utility.ACTION_MODE_ENUM.ADD_MODE)
{
strDuplicate = Utility.mCheckDuplicateItem(strComID, "USER_CONFIG", "USER_LOGIN_NAME", uctxtLogInName.Text);
if (strDuplicate != "")
{
MessageBox.Show(strDuplicate);
uctxtLogInName.Text = "";
uctxtLogInName.Focus();
return;
}
vstrPassword = Utility.Encrypt(uctxtPasswoed.Text, uctxtLogInName.Text);
var strResponseInsert = MessageBox.Show("Do You want to Save?", "Save Button", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (strResponseInsert == DialogResult.Yes)
{
try
{
string strmsg = accms.mInsertUser(strComID, Utility.gCheckNull(uctxtLogInName.Text), Utility.gCheckNull(uctxtFullName.Text), Utility.gCheckNull(uctxtDepartment.Text), Utility.gCheckNull(uctxtDesignation.Text),
vstrPassword, cboAccessLevel.Text, cboStatus.Text, Utility.gCheckNull(uctxtcomments.Text), _imageData);
CreateDefaultdata.gInsertPrivilegesNew(uctxtLogInName.Text, Utility.Left(cboAccessLevel.Text, 1));
MessageBox.Show(strmsg);
mcLear();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}
else
{
if (txtOldUserName.Text != uctxtLogInName.Text)
{
strDuplicate = Utility.mCheckDuplicateItem(strComID, "USER_CONFIG", "USER_LOGIN_NAME", uctxtLogInName.Text);
if (strDuplicate != "")
{
MessageBox.Show(strDuplicate);
uctxtLogInName.Text = "";
uctxtLogInName.Focus();
return;
}
}
vstrPassword = uctxtPasswoed.Text;
//vstrPassword = Utility.Decrypt(uctxtPasswoed.Text, txtOldUserName.Text);
var strResponseInsert = MessageBox.Show("Do You Want to Update?", "Update Button", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (strResponseInsert == DialogResult.Yes)
{
try
{
string strmsg = accms.mUpdateInsertUser(strComID, txtOldUserName.Text, Utility.gCheckNull(uctxtLogInName.Text), Utility.gCheckNull(uctxtFullName.Text), Utility.gCheckNull(uctxtDepartment.Text), Utility.gCheckNull(uctxtDesignation.Text),
vstrPassword, cboAccessLevel.Text, cboStatus.Text, Utility.gCheckNull(uctxtcomments.Text), _imageData);
if (Utility.Left(cboAccessLevel.Text, 1).ToUpper() == "A")
{
CreateDefaultdata.gUpdatePrivilegesNew(txtOldUserName.Text, uctxtLogInName.Text, Utility.Left(cboAccessLevel.Text, 1));
}
if (Utility.gblnAccessControl)
{
if (Utility.gstrUserName == txtOldUserName.Text)
{
Utility.gstrUserName = uctxtLogInName.Text;
if (System.Windows.Forms.Application.OpenForms["frmMain"] as frmMain == null)
{
frmMain objfrm = new frmMain();
objfrm.mLoad(strComID);
objfrm.Focus();
}
else
{
frmMain objfrm = (frmMain)Application.OpenForms["frmMain"];
objfrm.mLoad(strComID);
objfrm.Focus();
}
}
}
MessageBox.Show(strmsg);
mcLear();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}
}
private void btnInstall_Click(object sender, EventArgs e)
{
string ServerName;
string strCompanyID = "0001", strCompanyName = "";
string strSQL;
if (txtCompanyName.Text == "")
{
MessageBox.Show("Company Name Cannot be empty");
txtCompanyName.Focus();
return;
}
RegistryKey regKey = Registry.CurrentUser.CreateSubKey("SOFTWARE\\SmartAccounts");
btnInstall.Enabled = true;
SqlDataReader Dr;
string conDb;
changeRegionalSetting();
if (lstCopyChartOfAcc.SelectedValue.ToString() == "")
{
MessageBox.Show("No Compnay Name Found", "Copy Chart Of Accounts", MessageBoxButtons.OK, MessageBoxIcon.Warning);
txtCopyChartOfAccount.Focus();
return;
}
strCompanyID = "0001";
Utility.strDataBase = "SMART" + strCompanyID;
regKey.SetValue("gstrDataBaseName", Utility.strDataBase);
regKey.SetValue("CompanyID", strCompanyID);
ServerName = Utility.gGetServerName();
conDb = "Data Source=" + ServerName + " ;Initial Catalog= master;User ID=" + Utility.gstDatabaserUserName + " ;Password="******" ";
strSQL = "SELECT NAME FROM master.dbo.sysdatabases WHERE NAME = '" + Utility.strDataBase + "' ";
using (SqlConnection gcnMain = new SqlConnection(conDb))
{
if (gcnMain.State == ConnectionState.Open)
{
gcnMain.Close();
}
gcnMain.Open();
strCompanyName = txtCompanyName.Text.Replace("'", "''");
SqlCommand cmd = new SqlCommand();
cmd.Connection = gcnMain;
cmd.CommandText = strSQL;
Dr = cmd.ExecuteReader();
if ((Dr.Read()) != true)
{
Utility.gstrCompanyID = txtCompanyID.Text.Trim();
Utility.gstrBranchID = txtBranchId.Text.Trim();
Utility.gstrCompanyName = strCompanyName;
Utility.gdteFinancialYearFrom = Utility.DateFormat(dtefinancialform.Value);
Utility.gdteFinancialYearTo = Utility.DateFormat(dteFinanicalTo.Value);
Utility.gstrFinicialYearFrom = Utility.gstrDateToStr(dtefinancialform.Text);
Utility.gstrFinicialYearTo = Utility.gstrDateToStr(dteFinanicalTo.Text);
Utility.gstrBusinessType = txtBusinessType.Text;
mstrCurSymbol = "BDT";
mstrCurFormallName = "BDT";
//mstrCurString = txtCurrency.Text.Replace("'","''");
//mlngCurDecimalPl = Replace(uctxtCurrencyDecimal.Text, "'", "''")
//uctxtDefaultCurrency.Text = mstrCurSymbol
mstrCurString = "";
mlngCurDecimalPl = 0;
gCreatedatabase(ServerName, strCompanyID);
// Utility.creaateWrite(strCompanyID);
basTableSchemaAccount.gCreateAccounts(txtBusinessType.Text.ToString());
proBar.Value = proBar.Value + 10;
basTableSchemaStock.gCreateStock();
proBar.Value = proBar.Value + 20;
basTableSchemaReport.gCreateTableReport();
proBar.Value = proBar.Value + 20;
basViewSchemaAccount.gCreateViewAccount();
basViewSchemaStock.gCreateViewStock();
basProcedure.gCreateAdavanceSP();
basTrigger.gCreateTrigger();
CreateDefaultdata.gInsertBaseCurrency(mstrCurSymbol, mstrCurFormallName, mstrCurString, mlngCurDecimalPl);
mSaveCompanyInfo();
//CreateDefaultdata.gInsertDefaultData(true, "BDT", txtBusinessType.Text, txtBranchId.Text, txtCompanyName.Text);
MemoryStream ms = new MemoryStream();
pbImage.Image.Save(ms, ImageFormat.Jpeg);
_imageData = new byte[ms.Length];
ms.Position = 0;
ms.Read(_imageData, 0, _imageData.Length);
CreateDefaultdata.gInsertAccessControl("Deeplaid", "Deeplaid", _imageData, txtBranchId.Text);
if (txtUserControl.Text.ToUpper() == "YES")
{
Utility.gblnAccessControl = true;
CreateDefaultdata.gInsertAccessControl(uctxtAdministrator.Text, uctxtPassword.Text, _imageData, txtBranchId.Text);
}
else
{
Utility.gblnAccessControl = false;
}
string strSourceDB = "";
strSourceDB = "SMART" + lstCopyChartOfAcc.SelectedValue.ToString();
Dr.Close();
gcnMain.Close();
string cnn = "";
SqlTransaction myTrans;
SqlCommand cmdInsert = new SqlCommand();
cnn = Utility.SQLConnstringComSwitch(strCompanyID);
using (SqlConnection gcnMainnew = new SqlConnection(cnn))
{
if (gcnMainnew.State == ConnectionState.Open)
{
gcnMainnew.Close();
}
gcnMainnew.Open();
myTrans = gcnMainnew.BeginTransaction();
cmdInsert.Connection = gcnMainnew;
cmdInsert.Transaction = myTrans;
//Accounts
strSQL = Utility.mInsertTableData(strCompanyID, strSourceDB, "ACC_VOUCHER_TYPE", 1);
cmdInsert.CommandText = strSQL;
cmdInsert.ExecuteNonQuery();
strSQL = Utility.mInsertTableData(strCompanyID, strSourceDB, "ACC_DESTINATION", 1);
cmdInsert.CommandText = strSQL;
cmdInsert.ExecuteNonQuery();
strSQL = Utility.mInsertTableData(strCompanyID, strSourceDB, "ACC_TERITORRY", 1);
cmdInsert.CommandText = strSQL;
cmdInsert.ExecuteNonQuery();
strSQL = Utility.mInsertTableData(strCompanyID, strSourceDB, "INV_GROUP_MASTER", 1);
cmdInsert.CommandText = strSQL;
cmdInsert.ExecuteNonQuery();
strSQL = Utility.mInsertTableData(strCompanyID, strSourceDB, "INV_GROUP_COMMISSION_MASTER", 0);
cmdInsert.CommandText = strSQL;
cmdInsert.ExecuteNonQuery();
strSQL = Utility.mInsertTableData(strCompanyID, strSourceDB, "INV_GROUP_COMMISSION_TRAN", 0);
cmdInsert.CommandText = strSQL;
cmdInsert.ExecuteNonQuery();
strSQL = Utility.mInsertTableData(strCompanyID, strSourceDB, "ACC_LEDGERGROUP", 1);
cmdInsert.CommandText = strSQL;
cmdInsert.ExecuteNonQuery();
strSQL = Utility.mInsertTableData(strCompanyID, strSourceDB, "ACC_GROUP_TO_LEDGER", 1);
cmdInsert.CommandText = strSQL;
cmdInsert.ExecuteNonQuery();
strSQL = Utility.mInsertTableDataBranch(strCompanyID, strSourceDB, "ACC_BRANCH", 1);
cmdInsert.CommandText = strSQL;
cmdInsert.ExecuteNonQuery();
strSQL = Utility.mInsertTableData(strCompanyID, strSourceDB, "ACC_LEDGER", 1);
cmdInsert.CommandText = strSQL;
cmdInsert.ExecuteNonQuery();
strSQL = Utility.mInsertTableData(strCompanyID, strSourceDB, "ACC_LEDGER_TO_GROUP", 1);
cmdInsert.CommandText = strSQL;
cmdInsert.ExecuteNonQuery();
strSQL = Utility.mInsertTableData(strCompanyID, strSourceDB, "VECTOR_CATEGORY", 1);
cmdInsert.CommandText = strSQL;
cmdInsert.ExecuteNonQuery();
strSQL = Utility.mInsertTableData(strCompanyID, strSourceDB, "VECTOR_MASTER", 1);
cmdInsert.CommandText = strSQL;
cmdInsert.ExecuteNonQuery();
strSQL = Utility.mInsertTableData(strCompanyID, strSourceDB, "ACC_BRANCH_LEDGER_OPENING", 1);
cmdInsert.CommandText = strSQL;
cmdInsert.ExecuteNonQuery();
//StockGroup
strSQL = Utility.mInsertTableData(strCompanyID, strSourceDB, "INV_UNIT_MEASUREMENT", 1);
cmdInsert.CommandText = strSQL;
cmdInsert.ExecuteNonQuery();
strSQL = Utility.mInsertTableData(strCompanyID, strSourceDB, "INV_STOCKGROUP", 1);
cmdInsert.CommandText = strSQL;
cmdInsert.ExecuteNonQuery();
strSQL = Utility.mInsertTableData(strCompanyID, strSourceDB, "INV_STOCKCATEGORY", 1);
cmdInsert.CommandText = strSQL;
cmdInsert.ExecuteNonQuery();
strSQL = Utility.mInsertTableData(strCompanyID, strSourceDB, "INV_STOCK_MATERIAL_TYPE", 0);
cmdInsert.CommandText = strSQL;
cmdInsert.ExecuteNonQuery();
strSQL = Utility.mInsertTableData(strCompanyID, strSourceDB, "INV_GROUP_TO_STOCKITEM", 1);
cmdInsert.CommandText = strSQL;
cmdInsert.ExecuteNonQuery();
strSQL = Utility.mInsertTableData(strCompanyID, strSourceDB, "INV_STOCKITEM", 1);
cmdInsert.CommandText = strSQL;
cmdInsert.ExecuteNonQuery();
strSQL = Utility.mInsertTableData(strCompanyID, strSourceDB, "INV_STOCKITEM_TO_GROUP", 1);
cmdInsert.CommandText = strSQL;
cmdInsert.ExecuteNonQuery();
strSQL = Utility.mInsertTableData(strCompanyID, strSourceDB, "INV_STOCKITEM_LEVEL", 1);
cmdInsert.CommandText = strSQL;
cmdInsert.ExecuteNonQuery();
strSQL = Utility.mInsertTableData(strCompanyID, strSourceDB, "INV_GODOWNS", 1);
cmdInsert.CommandText = strSQL;
cmdInsert.ExecuteNonQuery();
strSQL = Utility.mInsertTableData(strCompanyID, strSourceDB, "ACC_BRANCH_LEDGER_OPENING", 1);
cmdInsert.CommandText = strSQL;
cmdInsert.ExecuteNonQuery();
strSQL = Utility.mInsertTableData(strCompanyID, strSourceDB, "INV_STOCKITEM_CLOSING", 1);
cmdInsert.CommandText = strSQL;
cmdInsert.ExecuteNonQuery();
strSQL = Utility.mInsertTableData(strCompanyID, strSourceDB, "ACC_PRICE_LEVEL", 0);
cmdInsert.CommandText = strSQL;
cmdInsert.ExecuteNonQuery();
strSQL = Utility.mInsertTableData(strCompanyID, strSourceDB, "INV_SALES_PRICE", 1);
cmdInsert.CommandText = strSQL;
cmdInsert.ExecuteNonQuery();
strSQL = Utility.mInsertTableData(strCompanyID, strSourceDB, "ACC_EXPENSE_CONFIG_MASTER", 1);
cmdInsert.CommandText = strSQL;
cmdInsert.ExecuteNonQuery();
strSQL = Utility.mInsertTableData(strCompanyID, strSourceDB, "ACC_EXPENSE_CONFIG_TRAN", 0);
cmdInsert.CommandText = strSQL;
cmdInsert.ExecuteNonQuery();
strSQL = Utility.mInsertTableData(strCompanyID, strSourceDB, "ACC_FIXED_ASSET_ACCUMULATED_DEPRECIATION", 1);
cmdInsert.CommandText = strSQL;
cmdInsert.ExecuteNonQuery();
strSQL = Utility.mInsertTableData(strCompanyID, strSourceDB, "ACC_FIXED_ASSET_ADJUSTMENT_DEP", 1);
cmdInsert.CommandText = strSQL;
cmdInsert.ExecuteNonQuery();
strSQL = Utility.mInsertTableData(strCompanyID, strSourceDB, "ACC_FIXED_ASSET_PURCHASE_AMOUNT", 1);
cmdInsert.CommandText = strSQL;
cmdInsert.ExecuteNonQuery();
strSQL = Utility.mInsertTableData(strCompanyID, strSourceDB, "INV_MENU_PROCESS_MAIN", 1);
cmdInsert.CommandText = strSQL;
cmdInsert.ExecuteNonQuery();
strSQL = Utility.mInsertTableData(strCompanyID, strSourceDB, "INV_MANU_PROCESS", 1);
cmdInsert.CommandText = strSQL;
cmdInsert.ExecuteNonQuery();
strSQL = Utility.mInsertTableData(strCompanyID, strSourceDB, "USER_FORM_CONFIG", 1);
cmdInsert.CommandText = strSQL;
cmdInsert.ExecuteNonQuery();
strSQL = "UPDATE ACC_LEDGER SET LEDGER_OPENING_BALANCE=0,LEDGER_CLOSING_BALANCE=0,LEDGER_OPENING=0,";
strSQL = strSQL + "LEDGER_DEBIT=0,LEDGER_CREDIT=0,LEDGER_ON_ACCOUNT_VALUE=0";
cmdInsert.CommandText = strSQL;
cmdInsert.ExecuteNonQuery();
strSQL = "UPDATE ACC_LEDGERGROUP SET GR_OPENING_DEBIT=0,GR_OPENING_CREDIT=0,GR_DEBIT_TOTAL=0,";
strSQL = strSQL + "GR_CREDIT_TOTAL=0,GR_CLOSING_DEBIT=0,GR_CLOSING_CREDIT=0";
cmdInsert.CommandText = strSQL;
cmdInsert.ExecuteNonQuery();
strSQL = "UPDATE ACC_BRANCH_LEDGER_OPENING SET BRANCH_LEDGER_OPENING_BALANCE=0";
cmdInsert.CommandText = strSQL;
cmdInsert.ExecuteNonQuery();
strSQL = "UPDATE INV_STOCKITEM SET STOCKITEM_OPENING_BALANCE=0,STOCKITEM_OPENING_VALUE=0,STOCKITEM_OPENING_RATE=0,";
strSQL = strSQL + "STOCKITEM_CLOSING_BALANCE=0";
cmdInsert.CommandText = strSQL;
cmdInsert.ExecuteNonQuery();
strSQL = "UPDATE INV_STOCKITEM_CLOSING SET STOCKITEM_CLOSING_BALANCE=0,STOCKITEM_SALE_BALANCE=0";
cmdInsert.CommandText = strSQL;
cmdInsert.ExecuteNonQuery();
strSQL = "UPDATE ACC_VOUCHER_TYPE SET VOUCHER_TYPE_TOTAL_VOUCHER=0 ";
cmdInsert.CommandText = strSQL;
cmdInsert.ExecuteNonQuery();
proBar.Value = proBar.Value + 50;
cmdInsert.Transaction.Commit();
gcnMainnew.Close();
gcnMain.Close();
cmdInsert.Dispose();
cmd.Dispose();
Dr.Close();
}
this.Hide();
}
Dr.Close();
}
}
