private void CompanySelect() { if (Grid.Rows.Count > 0) { ClsGlobal.Initial = Grid.Rows[Convert.ToInt32(Grid.CurrentRow.Index)].Cells["IniTial"].Value.ToString(); ClsGlobal.CompanyName = Grid.Rows[Convert.ToInt32(Grid.CurrentRow.Index)].Cells["Company Name"].Value.ToString(); ClsGlobal.CompanyStartDate = Convert.ToDateTime(Grid.Rows[Convert.ToInt32(Grid.CurrentRow.Index)].Cells["Start Date"].Value.ToString()).ToShortDateString(); ClsGlobal.CompanyEndDate = Convert.ToDateTime(Grid.Rows[Convert.ToInt32(Grid.CurrentRow.Index)].Cells["End Date"].Value.ToString()).ToShortDateString(); ClsGlobal.DatabaseName = Grid.Rows[Convert.ToInt32(Grid.CurrentRow.Index)].Cells["Db Name"].Value.ToString(); DataAccessLayer.Database._CompDatabaseName = Grid.Rows[Convert.ToInt32(Grid.CurrentRow.Index)].Cells["Db Name"].Value.ToString(); this.Close(); DataAccessLayer.SystemSetting.ClsCompany _objCompany = new DataAccessLayer.SystemSetting.ClsCompany(); DataTable dt = _objCompany.GetDataCompany(ClsGlobal.Initial); StringBuilder strSql = new StringBuilder(); strSql.Append(dt.Rows[0]["Address"].ToString()); if (!string.IsNullOrEmpty(dt.Rows[0]["City"].ToString())) { strSql.Append(", " + dt.Rows[0]["City"].ToString()); } if (!string.IsNullOrEmpty(dt.Rows[0]["Country"].ToString())) { strSql.Append(", " + dt.Rows[0]["Country"].ToString()); } ClsGlobal.CompanyAddress = strSql.ToString(); strSql.Clear(); if (!string.IsNullOrEmpty(dt.Rows[0]["PhoneNo"].ToString())) { strSql.Append("Phone No : " + dt.Rows[0]["PhoneNo"].ToString()); } if (!string.IsNullOrEmpty(dt.Rows[0]["AltPhoneNo"].ToString())) { strSql.Append(", " + dt.Rows[0]["AltPhoneNo"].ToString()); } ClsGlobal.CompanyPhoneNo = strSql.ToString(); ClsDateMiti _objDate = new ClsDateMiti(); if (ClsGlobal.DateType == "D") { ClsGlobal.CompanyFiscalYear = Convert.ToDateTime(dt.Rows[0]["StartDate"].ToString()).ToShortDateString() + " - " + Convert.ToDateTime(dt.Rows[0]["EndDate"].ToString()).ToShortDateString(); } else { ClsGlobal.CompanyStartMiti = _objDate.GetMiti(Convert.ToDateTime(dt.Rows[0]["StartDate"].ToString())); ClsGlobal.CompanyEndMiti = _objDate.GetMiti(Convert.ToDateTime(dt.Rows[0]["EndDate"].ToString())); ClsGlobal.CompanyFiscalYear = ClsGlobal.CompanyStartMiti + " - " + ClsGlobal.CompanyEndMiti; } //---------START UPDATE COMPANY ------------ Version versionInfo = System.Reflection.Assembly.GetExecutingAssembly().GetName().Version; ClsUpdateCompany _objUpdateCompany = new ClsUpdateCompany(); if (_objUpdateCompany.GetCompanyVersionNo() != versionInfo.ToString()) { _objUpdateCompany.UpdateCompanyVersionNo(versionInfo.ToString()); _objUpdateCompany.CreateView(); _objUpdateCompany.InsertDefaultData(); } //---------END UPDATE COMPANY ------------ ClsGlobal.TodayDateTime = _objDate.GetServerDateTime(); ClsGlobal.TodayDate = _objDate.GetServerDate(); ClsGlobal.EntryControl(""); ClsGlobal.UserRestriction(ClsGlobal.LoginUserCode, ClsGlobal.Initial); } }
private void SelectMaster() { ToolStripInitial.Text = ClsGlobal.Initial; ToolStripCompany.Text = ClsGlobal.CompanyName; if (ClsGlobal.DateType == "D") { ToolStripStartDate.Text = ClsGlobal.CompanyStartDate; ToolStripEndDate.Text = ClsGlobal.CompanyEndDate; } else { ToolStripStartDate.Text = ClsGlobal.CompanyStartMiti; ToolStripEndDate.Text = ClsGlobal.CompanyEndMiti; } DataAccessLayer.SystemSetting.ClsCompany _company = new DataAccessLayer.SystemSetting.ClsCompany(); DataAccessLayer.SystemSetting.ClsBranch _branch = new DataAccessLayer.SystemSetting.ClsBranch(); DataAccessLayer.SystemSetting.ClsCompanyUnit _companyunit = new DataAccessLayer.SystemSetting.ClsCompanyUnit(); DataAccessLayer.Interface.MasterSetup.ICounter _counter = new DataAccessLayer.MasterSetup.ClsCounter(); //----------- Choose Software Focus---------- try { DataTable dtCompanyInfo = _company.CompanyInfo(); if (dtCompanyInfo.Rows.Count > 0) { ClsGlobal.SoftwareFocus = dtCompanyInfo.Rows[0]["SoftwareFocus"].ToString(); if (string.IsNullOrEmpty(ClsGlobal.SoftwareFocus)) { FrmSoftwareFocus frm = new FrmSoftwareFocus(); frm.ShowDialog(); } else if (ClsGlobal.SoftwareFocus == "Restaurant") { MnuProductGroup1.Text = "Used/UnUsed"; MnuProductGroup2.Text = "Preparation Center"; } } //-----------Choose Branch-------------- var frm3 = new FrmBranchList { StartPosition = FormStartPosition.CenterScreen, WindowState = FormWindowState.Normal }; DataTable dtbranch = _branch.GetDataBranch(0); if (dtbranch.Rows.Count > 0) { frm3.ShowDialog(); } //---------Choose CompanyUnit---------------- var frm1 = new FrmCompanyUnitList { StartPosition = FormStartPosition.CenterScreen, WindowState = FormWindowState.Normal }; DataTable dtCompanyUnit = _companyunit.GetDataCompanyUnit(Convert.ToInt32(ClsGlobal.BranchId)); if (dtCompanyUnit.Rows.Count > 0) { frm1.ShowDialog(); } //---------Choose Counter---------------- if (ClsGlobal.SoftwareFocus == "Restaurant" || ClsGlobal.SoftwareFocus == "POS") { var frm2 = new FrmCounterList { StartPosition = FormStartPosition.CenterScreen, WindowState = FormWindowState.Normal }; DataTable dtCounter = _counter.GetDataCounter(0); if (dtCounter.Rows.Count > 0) { frm2.ShowDialog(); } } } catch { } }