private void btnSave_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { LB1.Focus(); MWDataManager.clsDataAccess _dbManSaveBudget = new MWDataManager.clsDataAccess(); _dbManSaveBudget.ConnectionString = _theConnection; _dbManSaveBudget.SqlStatement = ""; _dbManSaveBudget.SqlStatement = _dbManSaveBudget.SqlStatement + " BEGIN TRY insert into [tbl_BookingsDailyProblemsPump] values ( '" + DateLbl.Text + "', \r\n"; _dbManSaveBudget.SqlStatement = _dbManSaveBudget.SqlStatement + " '" + SectionLbl.Text + "', \r\n"; _dbManSaveBudget.SqlStatement = _dbManSaveBudget.SqlStatement + " '" + ExtractBeforeColon(ProbLbl.Text) + "', \r\n "; _dbManSaveBudget.SqlStatement = _dbManSaveBudget.SqlStatement + " '" + StartTime.EditValue.ToString() + "', '" + EndTime.EditValue.ToString() + "', '" + CommentsTxt.Text + "') END TRY \r\n "; _dbManSaveBudget.SqlStatement = _dbManSaveBudget.SqlStatement + " \r\n"; _dbManSaveBudget.SqlStatement = _dbManSaveBudget.SqlStatement + " BEGIN CATCH update [tbl_BookingsDailyProblemsPump] set \r\n"; _dbManSaveBudget.SqlStatement = _dbManSaveBudget.SqlStatement + " ProbID = '" + ExtractBeforeColon(ProbLbl.Text) + "', \r\n"; _dbManSaveBudget.SqlStatement = _dbManSaveBudget.SqlStatement + " StartTime = '" + StartTime.EditValue.ToString() + "', \r\n"; _dbManSaveBudget.SqlStatement = _dbManSaveBudget.SqlStatement + " EndTime = '" + EndTime.EditValue.ToString() + "', \r\n"; _dbManSaveBudget.SqlStatement = _dbManSaveBudget.SqlStatement + " Comments = '" + CommentsTxt.Text + "' \r\n"; _dbManSaveBudget.SqlStatement = _dbManSaveBudget.SqlStatement + " where Calendardate = '" + DateLbl.Text + "' \r\n "; _dbManSaveBudget.SqlStatement = _dbManSaveBudget.SqlStatement + " and Section = '" + SectionLbl.Text + "' \r\n"; _dbManSaveBudget.SqlStatement = _dbManSaveBudget.SqlStatement + " END CATCH\r\n"; _dbManSaveBudget.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement; _dbManSaveBudget.queryReturnType = MWDataManager.ReturnType.DataTable; _dbManSaveBudget.ExecuteInstruction(); //toastNotificationsManager1.ShowNotification(toastNotificationsManager1.Notifications[0]); this.Close(); }
private void calcularCustos(Regra regra) { Double txComissao = 0, alq1, alq2, custo, Vd1, Vd2, Frete, federal1, federal2, ICMSD1, ICMSD2, ICMSC, alICMSC, IPI, LB1, LB2, LL1, LL2, TXFixa1, TXFixa2, comissao1, comissao2; custo = Convert.ToDouble(txtCusto.Text.ToString()); alq1 = Convert.ToDouble(txtaliq1.Text.ToString()); Vd1 = Convert.ToDouble(txtvalor1.Text.ToString()); //Fazendo o valor 2 em relação ao desconto. Vd2 = (Convert.ToDouble(txtvalor1.Text.ToString()) - ((Convert.ToDouble(txtDesconto.Text.ToString()) / 100) * Convert.ToDouble(txtvalor1.Text.ToString()))); alq2 = (((Vd2 - custo) * 100) / custo); txtvalor2.Text = Vd2.ToString("N"); txtaliq2.Text = alq2.ToString("N"); Frete = Convert.ToDouble(txtCusto.Text.ToString()) * ((Convert.ToDouble(txtFrete.Text.ToString())) / 100); federal1 = Vd1 * (regra.getFederal() / 100); federal2 = Vd2 * (regra.getFederal() / 100); alICMSC = Convert.ToDouble(txtIcms.Text.ToString()); IPI = custo * (Convert.ToDouble(txtIPI.Text.ToString()) / 100); LB1 = custo * (alq1 / 100); LB2 = custo * (alq2 / 100); TXFixa1 = Vd1 * (regra.getTaxaDespesasFixas() / 100); TXFixa2 = Vd2 * (regra.getTaxaDespesasFixas() / 100); ICMSC = custo * ((18 - alICMSC) / 100); // Mudar quando não usar mais aliquotas negativas para ICMSC //Deve-se prepara a regra para Normal e SuperSimples, neste caso só apresentarei o superSimples ICMSD1 = 0; ICMSD2 = 0; txComissao = (txtComissao.Text.Equals("")) ? 0 : (Convert.ToDouble(txtComissao.Text) / 100); comissao1 = txComissao * Vd1; comissao2 = txComissao * Vd2; LL1 = Vd1 - (custo + Frete + federal1 + IPI + ICMSC + ICMSD1 + TXFixa1 + comissao1); LL2 = Vd2 - (custo + Frete + federal2 + IPI + ICMSC + ICMSD2 + TXFixa2 + comissao2); Labfrete1.Text = Frete.ToString("N"); Labfrete2.Text = Frete.ToString("N"); LabICMS0.Text = (ICMSC + ICMSD1).ToString("N"); LabICMS1.Text = (ICMSC + ICMSD2).ToString("N"); LabFederal1.Text = federal1.ToString("N"); LabFederal2.Text = federal2.ToString("N"); LabIPI1.Text = IPI.ToString("N"); LabIPI2.Text = IPI.ToString("N"); LabLB1.Text = LB1.ToString("N"); LabLB2.Text = LB2.ToString("N"); LabFixa1.Text = TXFixa1.ToString("N"); LabFixa2.Text = TXFixa2.ToString("N"); LabLL1.Text = (LL1 < 0)? "<font color ='red'>" + LL1.ToString("N") + "</font>" : LL1.ToString("N"); LabLL2.Text = (LL2 < 0) ? "<font color ='red'>" + LL2.ToString("N") + "</font>" : LL2.ToString("N"); labComissao1.Text = comissao1.ToString("N"); labComissao2.Text = comissao2.ToString("N"); }