Esempio n. 1
0
        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);
            }
        }