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(); }
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(); }
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); } }