Exemplo n.º 1
0
    protected void ReportsTab_DelReportButton_only4Test_Click(object sender, EventArgs e)
    {
        string    connectionString = ConfigurationSettings.AppSettings["fleetnetbaseConnectionString"];
        DataBlock dataBlock        = new DataBlock(connectionString, ConfigurationManager.AppSettings["language"]);

        try
        {
            int orgId    = Convert.ToInt32(Session["CURRENT_ORG_ID"]);
            int reportId = Convert.ToInt32(Selected_ReportsDataGrid_Index.Value);
            dataBlock.reportsTable.OpenConnection();
            dataBlock.reportsTable.OpenTransaction();
            dataBlock.reportsTable.AddOrSetReportUserOrg_DEactivateReportForORG(reportId, orgId, 0);
            dataBlock.reportsTable.CommitTransaction();
            dataBlock.reportsTable.CloseConnection();
        }
        catch (Exception ex)
        {
            dataBlock.reportsTable.RollbackConnection();
            dataBlock.reportsTable.CloseConnection();
            RaiseException(ex);
        }
        LoadReportsTable();
        ReportsTab_AddReportButton.Enabled = false;
        AccessPanel1.Enabled = false;
        ReportsUpdatePanel.Update();
    }
Exemplo n.º 2
0
    protected void ReportsTab_AddReportButton_Click(object sender, EventArgs e)
    {
        string    connectionString = ConfigurationSettings.AppSettings["fleetnetbaseConnectionString"];
        DataBlock dataBlock        = new DataBlock(connectionString, ConfigurationManager.AppSettings["language"]);

        try
        {
            dataBlock.OpenConnection();
            dataBlock.OpenTransaction();
            int curUserId = dataBlock.usersTable.Get_UserID_byName(Page.User.Identity.Name);
            int orgId     = Convert.ToInt32(Session["CURRENT_ORG_ID"]);
            int reportId  = Convert.ToInt32(Selected_ReportsDataGrid_Index.Value);

            dataBlock.reportsTable.AddOrSetReportUserOrg_ActivateReportForORG(reportId, orgId, curUserId);
            string billName = @"Invoice for report """ + dataBlock.reportsTable.GetReportName(reportId) + @"""";
            ///Выставляем счет, когда добавляем отчет. Потом по-любому все убрать!!!!
            dataBlock.invoiceTable.AddInvoice(dataBlock.invoiceTable.InvoiceType_addReportInvoice, dataBlock.invoiceTable.Status_NotPaid,
                                              orgId, billName, DateTime.Now, DateTime.Now.AddDays(7), new DateTime());
            /////////////////////////////////////////////////////
            dataBlock.CommitTransaction();
            dataBlock.CloseConnection();
        }
        catch (Exception ex)
        {
            dataBlock.RollbackConnection();
            dataBlock.CloseConnection();

            RaiseException(ex);
        }
        LoadReportsTable();
        ReportsTab_AddReportButton.Enabled = false;
        AccessPanel1.Enabled = false;
        ReportsUpdatePanel.Update();
    }
Exemplo n.º 3
0
    protected void ReportsDataGrid_RadioButton_Checked(object sender, EventArgs e)
    {
        string    connectionString = ConfigurationSettings.AppSettings["fleetnetbaseConnectionString"];
        DataBlock dataBlock        = new DataBlock(connectionString, ConfigurationManager.AppSettings["language"]);

        try
        {
            int orgId = Convert.ToInt32(Session["CURRENT_ORG_ID"]);

            /*  foreach (DataGridItem oldrow in ReportsDataGrid.Items)
             * {
             *    ((RadioButton)oldrow.FindControl("ReportsDataGrid_RadioButton")).Checked = false;
             * }*/
            //Set the new selected row
            RadioButton  rb  = (RadioButton)sender;
            DataGridItem row = (DataGridItem)rb.NamingContainer;
            ((RadioButton)row.FindControl("ReportsDataGrid_RadioButton")).Checked = true;
            int reportId = ((List <int>)Session["ReportsTab_UserControl_ReportsIds"])[row.DataSetIndex];
            Selected_ReportsDataGrid_Index.Value = reportId.ToString();

            dataBlock.OpenConnection();
            //Загружаем описание отчета
            LoadReportNote(reportId, dataBlock);
            //делает кнопку добавить неактивной, если отчет уже добавлен и наоборот
            DateTime outdatetime = new DateTime();
            if (DateTime.TryParse(dataBlock.reportsTable.GetReportUserOrg_BDATE(reportId, orgId), out outdatetime))
            {
                ReportsTab_AddReportButton.Enabled = false;
                AccessPanel1.Enabled = true;
                //Загружаем закладку доступа
                LoadReportsAccessInfo(reportId, orgId, dataBlock);
                AccessTab_SaveButton.Enabled              = true;
                AccessTab_AvailableForAllButton.Enabled   = true;
                AccessTab_UnAvailableForAllButton.Enabled = true;
            }
            else
            {
                AccessPanel1.Enabled = false;
                ReportsTab_AddReportButton.Enabled = true;
            }
            ///////////////////////
            ReportsUpdatePanel.Update();

            /*ReportsTab_ButtonsUpdateTable.Update();
             * ReportsDataGridUpdatePanel.Update();
             * AccessTab_DataGridUpdateTable.Update();
             * AccessTab_ButtonsUpdateTable.Update();*/
            //////////////////////
            dataBlock.CloseConnection();
        }
        catch (Exception ex)
        {
            dataBlock.CloseConnection();
            RaiseException(ex);
        }
    }