protected void InvoicesTab_UNPayInvoiceButton_Click(object sender, EventArgs e) { string connectionString = ConfigurationSettings.AppSettings["fleetnetbaseConnectionString"]; DataBlock dataBlock = new DataBlock(connectionString, ConfigurationManager.AppSettings["language"]); try { int invoiceId = Convert.ToInt32(Selected_InvoicesDataGrid_Index.Value); dataBlock.OpenConnection(); dataBlock.OpenTransaction(); dataBlock.invoiceTable.UnPayABill(invoiceId); dataBlock.CommitTransaction(); dataBlock.CloseConnection(); /* dataBlock.invoiceTable.OpenConnection(); * dataBlock.invoiceTable.OpenTransaction(); * dataBlock.invoiceTable.UnPayABill(invoiceId); * dataBlock.invoiceTable.CommitTransaction(); * dataBlock.invoiceTable.CloseConnection();*/ LoadInvoicesTable(); InvoicesDataGridUpdatePanel.Update(); InvoicesTab_ButtonsUpdateTable.Update(); } catch (Exception ex) { dataBlock.RollbackConnection(); dataBlock.CloseConnection(); /*dataBlock.invoiceTable.RollbackConnection(); * dataBlock.invoiceTable.CloseConnection();*/ RaiseException(ex); } }
protected void InvoicesTab_PayInvoiceButton_Click(object sender, EventArgs e) { string currentLanguage = ConfigurationManager.AppSettings["language"]; string connectionString = ConfigurationSettings.AppSettings["fleetnetbaseConnectionString"]; DataBlock dataBlock = new DataBlock(connectionString, currentLanguage); try { dataBlock.OpenConnection(); dataBlock.OpenTransaction(); int curUserId = dataBlock.usersTable.Get_UserID_byName(Page.User.Identity.Name); int invoiceId = Convert.ToInt32(Selected_InvoicesDataGrid_Index.Value); //old version /* dataBlock.invoiceTable.OpenConnection(); * dataBlock.invoiceTable.OpenTransaction(); * dataBlock.invoiceTable.PayABill(invoiceId); * string invoiceName = dataBlock.invoiceTable.GetInvoiceName(invoiceId); * dataBlock.invoiceTable.CommitTransaction(); * dataBlock.invoiceTable.CloseConnection();*/ //test version dataBlock.invoiceTable.PayABill(invoiceId); string invoiceName = dataBlock.invoiceTable.GetInvoiceName(invoiceId); dataBlock.CommitTransaction(); dataBlock.CloseConnection(); // LoadInvoicesTable(); InvoicesDataGridUpdatePanel.Update(); InvoicesTab_ButtonsUpdateTable.Update(); //// добавление записи в журнал. потом возможно перенести куда надо(в логику). DB.SQL.SQLDB sqlDb = new DB.SQL.SQLDB(connectionString); HistoryTable history = new HistoryTable(connectionString, currentLanguage, sqlDb); sqlDb.OpenConnection(); history.AddHistoryRecord("FN_INVOICE", "INVOICE_STATUS_ID", dataBlock.invoiceTable.Status_Paid, curUserId, history.invoicePaid, "#" + invoiceId + @" :""" + invoiceName + @"""", sqlDb); sqlDb.CloseConnection(); //// } catch (Exception ex) { dataBlock.invoiceTable.RollbackConnection(); dataBlock.invoiceTable.CloseConnection(); RaiseException(ex); } }
protected void InvoicesDataGrid_RadioButton_Checked(object sender, EventArgs e) { string connectionString = ConfigurationSettings.AppSettings["fleetnetbaseConnectionString"]; DataBlock dataBlock = new DataBlock(connectionString, ConfigurationManager.AppSettings["language"]); try { /* foreach (DataGridItem oldrow in InvoicesDataGrid.Items) * { * ((RadioButton)oldrow.FindControl("InvoicesDataGrid_RadioButton")).Checked = false; * }*/ //Set the new selected row RadioButton rb = (RadioButton)sender; DataGridItem row = (DataGridItem)rb.NamingContainer; ((RadioButton)row.FindControl("InvoicesDataGrid_RadioButton")).Checked = true; int invoiceId = ((List <int>)Session["InvoicesTab_UserControl_UsersIds"])[row.DataSetIndex]; Selected_InvoicesDataGrid_Index.Value = invoiceId.ToString(); //LoadUserAdditionalInfo(userId); dataBlock.reportsTable.OpenConnection(); //dataBlock.invoiceTable.OpenConnection(); dataBlock.OpenConnection(); //делает кнопку Оплатить неактивной, если счет уже оплачен и наоборот DateTime outdatetime = new DateTime(); if (DateTime.TryParse(dataBlock.invoiceTable.GetDatePayment(invoiceId), out outdatetime)) { InvoicesTab_PayInvoiceButton.Enabled = false; } else { InvoicesTab_PayInvoiceButton.Enabled = true; } /////////////////////// InvoicesDataGridUpdatePanel.Update(); InvoicesTab_ButtonsUpdateTable.Update(); ////////////////////// //dataBlock.invoiceTable.CloseConnection(); dataBlock.CloseConnection(); } catch (Exception ex) { dataBlock.CloseConnection(); // dataBlock.invoiceTable.CloseConnection(); RaiseException(ex); } }