private void mdiBillingSystem_Load(object sender, EventArgs e)
{
this.Text = J_Var.J_pProjectName;
//--
//this.lblVerDate.Text = "Ver. Date : 31st Mar 2015(β)";
//this.lblVerDate.Text = "Ver. Date : 1st Apr 2015(β)";
//this.lblVerDate.Text = "Ver. Date : 2nd Apr 2015";
//this.lblVerDate.Text = "Ver. Date : 20th Apr 2015";
//this.lblVerDate.Text = "Ver. Date : 27th Apr 2015";
//this.lblVerDate.Text = "Ver. Date : 04th May 2015";
//this.lblVerDate.Text = "Ver. Date : 07th May 2015";
//this.lblVerDate.Text = "Ver. Date : 15th May 2015";
//this.lblVerDate.Text = "Ver. Date : 15th May 2015";
//this.lblVerDate.Text = "Ver. Date : 16th May 2015";
//this.lblVerDate.Text = "Ver. Date : 18th May 2015";
//this.lblVerDate.Text = "Ver. Date : 23th May 2015";
//this.lblVerDate.Text = "Ver. Date : 30th May 2015";
//this.lblVerDate.Text = "Ver. Date : 30rd JUN 2015";
//this.lblVerDate.Text = "Ver. Date : 10th JUN 2015";
//this.lblVerDate.Text = "Ver. Date : 22th JUN 2015";
//this.lblVerDate.Text = "Ver. Date : 26th JUN 2015*";
//this.lblVerDate.Text = "Ver. Date : 30th JUN 2015";
//this.lblVerDate.Text = "Ver. Date : 9th JULY 2015";
//this.lblVerDate.Text = "Ver. Date : 10th JULY 2015";
this.lblVerDate.Text = "Ver. Date : 18th FEB 2016";
//--
if (billingService.T_SystemMaintenance() == false)
{
return;
}
DataSet dsUserInfo = dmlService.J_ConvertXmlToDataSet(Application.StartupPath + "/" + J_Var.J_pXmlConnectionFileName);
if (dsUserInfo == null)
{
return;
}
// Server & Database Name
J_Var.J_pServerName = cmnService.J_Decode(dsUserInfo.Tables[0].Rows[0][cmnService.J_Encode("SERVERNAME")].ToString());
if (J_Var.J_pDatabaseType == J_DatabaseType.MsAccess)
{
if (J_Var.J_pApplicationType == J_ApplicationType.StandAlone_SingleMachine)
{
J_Var.J_pDatabaseName = cmnService.J_Decode(dsUserInfo.Tables[0].Rows[0][cmnService.J_Encode("DATABASENAME")].ToString());
}
else if (J_Var.J_pApplicationType == J_ApplicationType.StandAlone_SingleMachineBrowser)
{
J_Var.J_pDatabaseName = cmnService.J_Decode(dsUserInfo.Tables[0].Rows[0][cmnService.J_Encode("DATABASENAME")].ToString());
}
else if (J_Var.J_pApplicationType == J_ApplicationType.StandAlone_Network)
{
J_Var.J_pDatabaseName = cmnService.J_ConvertMsAccessDatabasePath(cmnService.J_Decode(dsUserInfo.Tables[0].Rows[0][cmnService.J_Encode("DATABASENAME")].ToString()), J_Colon.YES);
}
}
else
{
J_Var.J_pDatabaseName = cmnService.J_Decode(dsUserInfo.Tables[0].Rows[0][cmnService.J_Encode("DATABASENAME")].ToString());
}
cmnService.J_PanelMessage(J_PanelIndex.e00_DisplayText, "");
if (J_Var.J_pLoginScreen == J_LoginScreen.YES)
{
cmnService.J_PanelMessage(J_PanelIndex.e01_FAYear, J_Var.J_pFABegDate + " - " + J_Var.J_pFAEndDate);
cmnService.J_PanelMessage(J_PanelIndex.e02_BranchName, J_Var.J_pBranchCode + " " + J_Var.J_pBranchName);
}
else if (J_Var.J_pLoginScreen == J_LoginScreen.NO)
{
cmnService.J_PanelMessage(J_PanelIndex.e01_FAYear, "");
cmnService.J_PanelMessage(J_PanelIndex.e02_BranchName, "");
USep20.Visible = false;
mnuSwitchUser.Visible = false;
USep60.Visible = false;
mnuMenuRights.Visible = false;
}
cmnService.J_PanelMessage(J_PanelIndex.e03_ServerName, "");
if (J_Var.J_pDatabaseType == J_DatabaseType.MsAccess)
{
if (J_Var.J_pApplicationType == J_ApplicationType.StandAlone_SingleMachine)
{
cmnService.J_PanelMessage(J_PanelIndex.e04_Database, cmnService.J_Left(J_Var.J_pDatabaseName, 3) + "...\\" + J_Var.J_pMsAccessDatabaseName);
}
else if (J_Var.J_pApplicationType == J_ApplicationType.StandAlone_SingleMachineBrowser)
{
cmnService.J_PanelMessage(J_PanelIndex.e04_Database, cmnService.J_Left(J_Var.J_pDatabaseName, 3) + "...\\" + J_Var.J_pMsAccessDatabaseName);
}
else if (J_Var.J_pApplicationType == J_ApplicationType.StandAlone_Network)
{
cmnService.J_PanelMessage(J_PanelIndex.e04_Database, J_Var.J_pServerName + "\\\\" + cmnService.J_Left(J_Var.J_pDatabaseName, 3) + "...\\" + J_Var.J_pMsAccessDatabaseName);
}
}
else
{
cmnService.J_PanelMessage(J_PanelIndex.e03_ServerName, J_Var.J_pServerName);
cmnService.J_PanelMessage(J_PanelIndex.e04_Database, J_Var.J_pDatabaseName);
}
cmnService.J_PanelMessage(J_PanelIndex.e05_UserDisplayName, J_Var.J_pUserDisplayName);
// Dataset object is disposed
dsUserInfo.Dispose();
if (J_Var.J_pDatabaseType == J_DatabaseType.MsAccess)
{
if (J_Var.J_pApplicationType == J_ApplicationType.StandAlone_SingleMachine)
{
mnuChangeConfigInfo.Visible = false;
}
else if (J_Var.J_pApplicationType == J_ApplicationType.StandAlone_Network)
{
if (Environment.MachineName.ToUpper() != J_Var.J_pServerName.ToUpper())
{
mnuBackup.Visible = false;
UTSep10.Visible = false;
}
}
UTSep20.Visible = false;
mnuBuildIndex.Visible = false;
}
//this.MenuVisibility(true);
}
static void Main()
{
// set the application name
J_Var.J_pApplicationName = "BS v1.0";
// set the project name
J_Var.J_pProjectName = "Billing System";
//@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
// start block
// set some parameters
//@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
// set the Zip password
J_Var.J_pZipFilePassword = "******";
// set the Login Screen come or not
//J_Var.J_pLoginScreen = J_LoginScreen.NO;
#region FOR MOCROSOFT ACCESS DATABASE
// =========================================
// FOR MOCROSOFT ACCESS DATABASE
// =========================================
J_Var.J_pMsAccessDatabaseName = "BillingSystem.mdb";
J_Var.J_pMsAccessDatabasePassword = "";
J_Var.J_pApplicationType = J_ApplicationType.StandAlone_Network;
J_Var.J_pDatabaseType = J_DatabaseType.SqlServer;
J_Var.J_pConnectionProviderType = J_ConnectionProviderType.Sql;
// =========================================
// =========================================
#endregion
#region FOR MOCROSOFT SQL SERVER DATABASE
// =========================================
// FOR MOCROSOFT SQL SERVER DATABASE
// =========================================
//J_Var.J_pApplicationType = J_ApplicationType.StandAlone_Network;
//J_Var.J_pDatabaseType = J_DatabaseType.SqlServer;
//J_Var.J_pConnectionProviderType = J_ConnectionProviderType.Sql;
// =========================================
// =========================================
#endregion
// set the xml file name as connection to database
J_Var.J_pXmlConnectionFileName = "_JS_BS.xml";
// set the xml file name as Branch Information
J_Var.J_pXmlBranchInfoFileName = "_JS_BS_B.xml";
// set the command time-out
J_Var.J_pCommandTimeout = 99999;
//@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
// end block
//@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
// declare & initialization objects
DMLService dmlService = new DMLService();
CommonService cmnService = new CommonService();
DateService dtService = new DateService();
// set the Operating Syatem type [32 bit | 64 bit]
J_Var.J_pOSType = cmnService.J_GetOSType();
// declare & initialization variable
string strSQL = string.Empty;
// To Check the DateTime Format
if (dtService.J_SystemDateFormatCheck_dd_MM_yyyy() == false)
{
return;
}
// to check the application type as StandAlone & SingleMachine
if (J_Var.J_pApplicationType == J_ApplicationType.StandAlone_SingleMachine)
{
// to check the microsoft database file is exist or not
if (cmnService.J_IsFileExist(Application.StartupPath + "/" + J_Var.J_pMsAccessDatabaseName) == false)
{
dmlService.Dispose();
cmnService.J_UserMessage("Database file does not exist.\nPlease check the database file");
return;
}
// to check the connection is possible or not
if (dmlService.J_ValidateConnection() == false)
{
dmlService.Dispose();
cmnService.J_UserMessage("Invalid database.\nPlease check the database");
return;
}
// to check the MST_FAYEAR table is exist or not
if (dmlService.J_IsDatabaseObjectExist("MST_FAYEAR") == false)
{
dmlService.Dispose();
cmnService.J_UserMessage("Invalid database structure.\nPlease check the database");
return;
}
// declare & initialize the hashtable object to create the xml file
Hashtable nameValue = new Hashtable();
// store values to hashtable
nameValue.Add("SERVERNAME", "");
nameValue.Add("DATABASENAME", Application.StartupPath);
nameValue.Add("USERNAME", J_Var.J_pMsAccessDatabaseName);
nameValue.Add("PASSWORD", J_Var.J_pMsAccessDatabasePassword);
// declare & initialize the object of XMLService
XMLService objxml = new XMLService();
// create the xml file to connect to the database
objxml.J_CreateXMLFile(nameValue, Application.StartupPath + "/" + J_Var.J_pXmlConnectionFileName);
if (dmlService.J_IsRecordExist("MST_FAYEAR") == true)
{
dmlService.Dispose();
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
if (J_Var.J_pLoginScreen == J_LoginScreen.YES)
{
CmnLogin frm = new CmnLogin();
frm.ShowDialog();
frm.Dispose();
}
else if (J_Var.J_pLoginScreen == J_LoginScreen.NO)
{
J_Var.frmMain = new mdiBillingSystem();
J_Var.frmMain.ShowDialog();
}
}
else
{
dmlService.Dispose();
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
CmnCreate1stFAYear frm = new CmnCreate1stFAYear();
frm.ShowDialog();
frm.Dispose();
}
return;
}
// to check the application type as StandAlone, SingleMachine & Browser to Config window
if (J_Var.J_pApplicationType == J_ApplicationType.StandAlone_SingleMachineBrowser)
{
// to check the microsoft xml file is exist or not
if (cmnService.J_IsFileExist(Application.StartupPath + "/" + J_Var.J_pXmlConnectionFileName) == false)
{
dmlService.Dispose();
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
SysServerInfoLocalBrowser frmLocalBrowser = new SysServerInfoLocalBrowser();
frmLocalBrowser.ShowDialog();
frmLocalBrowser.Dispose();
return;
}
DataSet dsUserInfo = dmlService.J_ConvertXmlToDataSet(Application.StartupPath + "/" + J_Var.J_pXmlConnectionFileName);
if (dsUserInfo == null)
{
return;
}
J_Var.J_pDatabaseName = cmnService.J_Decode(dsUserInfo.Tables[0].Rows[0][cmnService.J_Encode("DATABASENAME")].ToString());
// to check the microsoft database file is exist or not
if (cmnService.J_IsFileExist(J_Var.J_pDatabaseName + "/" + J_Var.J_pMsAccessDatabaseName) == false)
{
dmlService.Dispose();
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
SysServerInfoLocalBrowser frmLocalBrowser = new SysServerInfoLocalBrowser();
frmLocalBrowser.ShowDialog();
frmLocalBrowser.Dispose();
return;
}
// to check the connection is possible or not
if (dmlService.J_ValidateConnection() == false)
{
dmlService.Dispose();
cmnService.J_UserMessage("Invalid database.\nPlease check the database");
return;
}
// to check the MST_FAYEAR table is exist or not
if (dmlService.J_IsDatabaseObjectExist("MST_FAYEAR") == false)
{
dmlService.Dispose();
cmnService.J_UserMessage("Invalid database structure.\nPlease check the database");
return;
}
// check atleast one fayear data exist or not.
if (dmlService.J_IsRecordExist("MST_FAYEAR") == true)
{
dmlService.Dispose();
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
if (J_Var.J_pLoginScreen == J_LoginScreen.YES)
{
CmnLogin frm = new CmnLogin();
frm.ShowDialog();
frm.Dispose();
}
else if (J_Var.J_pLoginScreen == J_LoginScreen.NO)
{
J_Var.frmMain = new mdiBillingSystem();
J_Var.frmMain.ShowDialog();
}
}
else
{
dmlService.Dispose();
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
CmnCreate1stFAYear frm = new CmnCreate1stFAYear();
frm.ShowDialog();
frm.Dispose();
}
return;
}
// to check the microsoft xml file is exist or not
if (cmnService.J_IsFileExist(Application.StartupPath + "/" + J_Var.J_pXmlConnectionFileName) == true)
{
if (dmlService.J_ValidateConnection() == true)
{
// check the MST_FAYEAR table exist or not
if (dmlService.J_IsDatabaseObjectExist("MST_FAYEAR") == true)
{
if (dmlService.J_IsRecordExist("MST_FAYEAR") == true)
{
dmlService.Dispose();
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
CmnLogin frm = new CmnLogin();
frm.ShowDialog();
frm.Dispose();
}
else
{
dmlService.Dispose();
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
CmnCreate1stFAYear frm = new CmnCreate1stFAYear();
frm.ShowDialog();
frm.Dispose();
}
return;
}
}
}
dmlService.Dispose();
if (J_Var.J_pDatabaseType == J_DatabaseType.MsAccess)
{
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
SysServerInfoLocal frmLocal = new SysServerInfoLocal();
frmLocal.ShowDialog();
frmLocal.Dispose();
}
else if (J_Var.J_pDatabaseType == J_DatabaseType.SqlServer)
{
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
SysServerInfoNetwork frmNetwork = new SysServerInfoNetwork();
frmNetwork.ShowDialog();
frmNetwork.Dispose();
}
return;
}