public void Insert(CS_TBCostFormation tcs)
{
try
{
string sql = @"INSERT INTO CS_TBCostFormation (Id, Id_Offer, OfferNo, SumIpiIcms, PIS,
COFINS, ICMS, Freight, IPI, Comission, DF_Percent, DV_Percent,
Margin, MarginVariable, ISS, IR, CSLL, Markup, TotalMarkup,
TotalSimulation, TBCreated, TBModified, TBCreatedID, Item) VALUES (" +
$"{tcs.Id}, {tcs.Id_Offer}, '{tcs.OfferNo}', '{tcs.SumIpiIcms}', " +
$"{tcs.PIS.ToString().Replace(",", ".")}, {tcs.COFINS.ToString().Replace(",", ".")}, " +
$"{tcs.ICMS.ToString().Replace(",", ".")}, {tcs.Freight.ToString().Replace(",", ".")}, " +
$"{tcs.IPI.ToString().Replace(",", ".")}, {tcs.Comission.ToString().Replace(",", ".")}, " +
$"{tcs.DF_Percent.ToString().Replace(",", ".")}, {tcs.DV_Percent.ToString().Replace(",", ".")}, " +
$"{tcs.Margin.ToString().Replace(",", ".")}, {tcs.MarginVariable.ToString().Replace(",", ".")}, " +
$"{tcs.ISS.ToString().Replace(",", ".")}, {tcs.IR.ToString().Replace(",", ".")}, " +
$"{tcs.CSLL.ToString().Replace(",", ".")}, {tcs.Markup.ToString().Replace(",", ".")}, " +
$"{tcs.TotalMarkup.ToString().Replace(",", ".")}, {tcs.TotalSimulation.ToString().Replace(",", ".")}, " +
$"'{tcs.TBCreated}', '{tcs.TBModified}', {tcs.TBCreatedID}, '{tcs.Item}'" +
")";
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
conn.Close();
}
catch (Exception ex)
{
conn.Close();
throw ex;
}
}
public CS_TBCostFormation GetAllWithParams(int idOffer, string offerNo, string item)
{
try
{
string sql = $"SELECT * FROM CS_TBCostFormation WHERE Id_Offer = {idOffer} AND OfferNo = '{offerNo}' AND Item = '{item}'";
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataReader reader = cmd.ExecuteReader();
reader.Read();
if (reader.HasRows)
{
CS_TBCostFormation tcs = new CS_TBCostFormation();
tcs.Id = Convert.ToInt32(reader["Id"]);
tcs.Id_Offer = Convert.ToInt32(reader["Id_Offer"]);
tcs.OfferNo = reader["OfferNo"].ToString();
tcs.Item = reader["Item"].ToString();
tcs.SumIpiIcms = reader["SumIpiIcms"].ToString();
tcs.PIS = string.IsNullOrEmpty(reader["PIS"].ToString()) ? 0 : Convert.ToDouble(reader["PIS"]);
tcs.COFINS = string.IsNullOrEmpty(reader["COFINS"].ToString()) ? 0 : Convert.ToDouble(reader["COFINS"]);
tcs.ICMS = string.IsNullOrEmpty(reader["ICMS"].ToString()) ? 0 : Convert.ToDouble(reader["ICMS"]);
tcs.Freight = string.IsNullOrEmpty(reader["Freight"].ToString()) ? 0 : Convert.ToDouble(reader["Freight"]);
tcs.Comission = string.IsNullOrEmpty(reader["Comission"].ToString()) ? 0 : Convert.ToDouble(reader["Comission"]);
tcs.IPI = string.IsNullOrEmpty(reader["IPI"].ToString()) ? 0 : Convert.ToDouble(reader["IPI"]);
tcs.DF_Percent = string.IsNullOrEmpty(reader["DF_Percent"].ToString()) ? 0 : Convert.ToDouble(reader["DF_Percent"]);
tcs.DV_Percent = string.IsNullOrEmpty(reader["DV_Percent"].ToString()) ? 0 : Convert.ToDouble(reader["DV_Percent"]);
tcs.Margin = string.IsNullOrEmpty(reader["Margin"].ToString()) ? 0 : Convert.ToDouble(reader["Margin"]);
tcs.MarginVariable = string.IsNullOrEmpty(reader["MarginVariable"].ToString()) ? 0 : Convert.ToDouble(reader["MarginVariable"]);
tcs.ISS = string.IsNullOrEmpty(reader["ISS"].ToString()) ? 0 : Convert.ToDouble(reader["ISS"]);
tcs.IR = string.IsNullOrEmpty(reader["IR"].ToString()) ? 0 : Convert.ToDouble(reader["IR"]);
tcs.CSLL = string.IsNullOrEmpty(reader["CSLL"].ToString()) ? 0 : Convert.ToDouble(reader["CSLL"]);
tcs.Markup = string.IsNullOrEmpty(reader["Markup"].ToString()) ? 0 : Convert.ToDouble(reader["Markup"]);
tcs.TotalMarkup = string.IsNullOrEmpty(reader["TotalMarkup"].ToString()) ? 0 : Convert.ToDouble(reader["TotalMarkup"]);
tcs.TotalSimulation = string.IsNullOrEmpty(reader["TotalSimulation"].ToString()) ? 0 : Convert.ToDouble(reader["TotalSimulation"]);
conn.Close();
return(tcs);
}
else
{
conn.Close();
return(null);
}
}
catch (Exception ex)
{
conn.Close();
throw ex;
}
}
private void BtnSaveAll_Click(object sender, RoutedEventArgs e)
{
try
{
//if (serviceCQ.ExistCostFormation(int.Parse(txtCustQuotaId.Text), cbItemGrid.Text))
//{
// MessageBox.Show("Já existe formação de custo para a simulãção selecionada!", "Aviso", MessageBoxButton.OK, MessageBoxImage.Warning);
// ClearFields();
// return;
//}
if (!serviceCompOp.ExistData(Convert.ToInt32(txtCustQuotaId.Text), cbItemGrid.Text))
{
MessageBox.Show("Não existe simulação para o item da oferta selecionada!", "Aviso", MessageBoxButton.OK, MessageBoxImage.Warning);
ClearFields();
return;
}
// calculo da formação de custo
int id = Convert.ToInt32(txtCustQuotaId.Text);
string item = cbItemGrid.Text;
CalculateFieldsView(Convert.ToDouble(unitValue));
double?costValue = Convert.ToDouble(txtTotalMarkup.Text);
if (serviceCQ.UpdateCostFormationCustQuatas(id, costValue))
{
try
{
if (tcsService.GetAllWithParams(Convert.ToInt32(txtCustQuotaId.Text), txtSelectItem.Text, cbItemGrid.Text) != null)
{
MessageBoxResult resultMessage = MessageBox.Show("Já existem dados salvos para essa formação de custo! Deseja sobrescrever os dados?", "Pergunta",
MessageBoxButton.YesNo, MessageBoxImage.Question);
if (resultMessage == MessageBoxResult.Yes)
{
tcsService.DeleteData(Convert.ToInt32(txtCustQuotaId.Text), txtSelectItem.Text, cbItemGrid.Text);
CS_TBCostFormation tcs = new CS_TBCostFormation();
tcs.Id = tcsService.GetMaxId();
tcs.Id_Offer = Convert.ToInt32(txtCustQuotaId.Text);
tcs.OfferNo = txtSelectItem.Text;
tcs.Item = cbItemGrid.Text;
if (ckSumIcmsIpi.IsChecked == true)
{
tcs.SumIpiIcms = "1";
}
else
{
tcs.SumIpiIcms = "0";
}
tcs.PIS = string.IsNullOrEmpty(txtPis.Text) ? 0 : Convert.ToDouble(txtPis.Text);
tcs.COFINS = string.IsNullOrEmpty(txtCofins.Text) ? 0 : Convert.ToDouble(txtCofins.Text);
tcs.ICMS = string.IsNullOrEmpty(txtIcms.Text) ? 0 : Convert.ToDouble(txtIcms.Text);
tcs.Freight = string.IsNullOrEmpty(txtFreightValue.Text) ? 0 : Convert.ToDouble(txtFreightValue.Text);
tcs.Comission = string.IsNullOrEmpty(txtComissions.Text) ? 0 : Convert.ToDouble(txtComissions.Text);
tcs.IPI = string.IsNullOrEmpty(txtIpi.Text) ? 0 : Convert.ToDouble(txtIpi.Text);
tcs.DF_Percent = string.IsNullOrEmpty(txtFixedExpenses.Text) ? 0 : Convert.ToDouble(txtFixedExpenses.Text);
tcs.DV_Percent = string.IsNullOrEmpty(txtVariableExpenses.Text) ? 0 : Convert.ToDouble(txtVariableExpenses.Text);
tcs.Margin = string.IsNullOrEmpty(txtMargin.Text) ? 0 : Convert.ToDouble(txtMargin.Text);
tcs.MarginVariable = string.IsNullOrEmpty(txtVariableMargin.Text) ? 0 : Convert.ToDouble(txtVariableMargin.Text);
tcs.ISS = string.IsNullOrEmpty(txtISS.Text) ? 0 : Convert.ToDouble(txtISS.Text);
tcs.IR = string.IsNullOrEmpty(txtIR.Text) ? 0 : Convert.ToDouble(txtIR.Text);
tcs.CSLL = string.IsNullOrEmpty(txtCSLL.Text) ? 0 : Convert.ToDouble(txtCSLL.Text);
tcs.Markup = string.IsNullOrEmpty(txtMarkup.Text) ? 0 : Convert.ToDouble(txtMarkup.Text);
tcs.TotalMarkup = string.IsNullOrEmpty(txtTotalMarkup.Text) ? 0 : Convert.ToDouble(txtTotalMarkup.Text);
tcs.TotalSimulation = string.IsNullOrEmpty(txtTotalSimulation.Text) ? 0 : Convert.ToDouble(txtTotalSimulation.Text);
tcs.TBCreated = DateTime.Now;
tcs.TBModified = DateTime.Now;
tcs.TBCreatedID = 1;
tcsService.Insert(tcs);
}
else
{
}
}
else
{
CS_TBCostFormation tcs = new CS_TBCostFormation();
tcs.Id = tcsService.GetMaxId();
tcs.Id_Offer = Convert.ToInt32(txtCustQuotaId.Text);
tcs.OfferNo = txtSelectItem.Text;
tcs.Item = cbItemGrid.Text;
if (ckSumIcmsIpi.IsChecked == true)
{
tcs.SumIpiIcms = "1";
}
else
{
tcs.SumIpiIcms = "0";
}
tcs.PIS = string.IsNullOrEmpty(txtPis.Text) ? 0 : Convert.ToDouble(txtPis.Text);
tcs.COFINS = string.IsNullOrEmpty(txtCofins.Text) ? 0 : Convert.ToDouble(txtCofins.Text);
tcs.ICMS = string.IsNullOrEmpty(txtIcms.Text) ? 0 : Convert.ToDouble(txtIcms.Text);
tcs.Freight = string.IsNullOrEmpty(txtFreightValue.Text) ? 0 : Convert.ToDouble(txtFreightValue.Text);
tcs.Comission = string.IsNullOrEmpty(txtComissions.Text) ? 0 : Convert.ToDouble(txtComissions.Text);
tcs.IPI = string.IsNullOrEmpty(txtIpi.Text) ? 0 : Convert.ToDouble(txtIpi.Text);
tcs.DF_Percent = string.IsNullOrEmpty(txtFixedExpenses.Text) ? 0 : Convert.ToDouble(txtFixedExpenses.Text);
tcs.DV_Percent = string.IsNullOrEmpty(txtVariableExpenses.Text) ? 0 : Convert.ToDouble(txtVariableExpenses.Text);
tcs.Margin = string.IsNullOrEmpty(txtMargin.Text) ? 0 : Convert.ToDouble(txtMargin.Text);
tcs.MarginVariable = string.IsNullOrEmpty(txtVariableMargin.Text) ? 0 : Convert.ToDouble(txtVariableMargin.Text);
tcs.ISS = string.IsNullOrEmpty(txtISS.Text) ? 0 : Convert.ToDouble(txtISS.Text);
tcs.IR = string.IsNullOrEmpty(txtIR.Text) ? 0 : Convert.ToDouble(txtIR.Text);
tcs.CSLL = string.IsNullOrEmpty(txtCSLL.Text) ? 0 : Convert.ToDouble(txtCSLL.Text);
tcs.Markup = string.IsNullOrEmpty(txtMarkup.Text) ? 0 : Convert.ToDouble(txtMarkup.Text);
tcs.TotalMarkup = string.IsNullOrEmpty(txtTotalMarkup.Text) ? 0 : Convert.ToDouble(txtTotalMarkup.Text);
tcs.TotalSimulation = string.IsNullOrEmpty(txtTotalSimulation.Text) ? 0 : Convert.ToDouble(txtTotalSimulation.Text);
tcs.TBCreated = DateTime.Now;
tcs.TBModified = DateTime.Now;
tcs.TBCreatedID = 1;
tcsService.Insert(tcs);
}
}
catch (Exception exc)
{
MessageBox.Show("Erro ao salvar dados completos da formação de custo" + "\n" + exc.Message, "Erro", MessageBoxButton.OK, MessageBoxImage.Error);
}
MessageBox.Show($"Formação de Custo (R$ { Math.Round(Convert.ToDouble(costValue), 2) }) e Simulação de Engenharia de Produtos salva com sucesso!",
"Informação", MessageBoxButton.OK, MessageBoxImage.Information);
MessageBoxResult resultDialog = MessageBox.Show("Deseja realizar outra simulação?", "Pergunta",
MessageBoxButton.YesNo, MessageBoxImage.Question);
if (resultDialog == MessageBoxResult.Yes)
{
ClearFields();
}
else
{
Environment.Exit(0);
}
}
else
{
MessageBox.Show("Não existe dados!", "Aviso", MessageBoxButton.OK, MessageBoxImage.Warning);
return;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + " - " + ex.StackTrace,
"Erro", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
