private void rptQuerKalkulation_DataSourceDemanded(object sender, EventArgs e)
{
try
{
this.p_Rpt_QuerCalculationTableAdapter.Connection.ConnectionString = SQLCon.ConnectionString();
this.p_Rpt_QuerCalculationTableAdapter.ClearBeforeFill = true;
this.p_Rpt_QuerCalculationTableAdapter.Fill(dsQuerKalculation1.P_Rpt_QuerCalculation, dtValue, _PID, _Type, _LVSection);
this.p_Rpt_QuerCalculation_SurchargePositionTableAdapter.Connection.ConnectionString = SQLCon.ConnectionString();
this.p_Rpt_QuerCalculation_SurchargePositionTableAdapter.ClearBeforeFill = true;
this.p_Rpt_QuerCalculation_SurchargePositionTableAdapter.Fill(dsSurchargeCalculation1.P_Rpt_QuerCalculation_SurchargePosition, dtValue, _PID, _Type, _LVSection);
DataTable dt = new DataTable();
dt = dsSurchargeCalculation1.P_Rpt_QuerCalculation_SurchargePosition;
if (dt != null)
{
decimal _result = 0;
if (decimal.TryParse(Convert.ToString(dt.Rows[0][0]), out _result))
{
if (_result == 0)
{
tblSurchargeresult.Text = string.Empty;
}
else
{
tblSurchargeresult.Text = _result.ToString("n2");
}
}
}
dsDiscountCalculation ds = new dsDiscountCalculation();
this.p_Rpt_QuerCalculation_DiscountPositionTableAdapter1.Connection.ConnectionString = SQLCon.ConnectionString();
this.p_Rpt_QuerCalculation_DiscountPositionTableAdapter1.ClearBeforeFill = true;
this.p_Rpt_QuerCalculation_DiscountPositionTableAdapter1.Fill(ds.P_Rpt_QuerCalculation_DiscountPosition, dtValue, _PID, _Type, _LVSection);
DataTable dtdiscount = new DataTable();
dtdiscount = ds.P_Rpt_QuerCalculation_DiscountPosition;
if (dtdiscount != null)
{
decimal _result = 0;
if (decimal.TryParse(Convert.ToString(dtdiscount.Rows[0][0]), out _result))
{
if (_result > 0)
{
tbDiscountResult.Text = _result.ToString("n2");
_Discount = Convert.ToDouble(_result);
}
else
{
tbDiscountResult.Text = string.Empty;
_Discount = 0;
}
}
}
}
catch (Exception ex)
{
Utility.ShowError(ex);
}
}
private void rptProposalCommon_DataSourceDemanded(object sender, EventArgs e)
{
try
{
dsDiscountCalculation ds = new dsDiscountCalculation();
this.p_Rpt_QuerCalculation_DiscountPositionTableAdapter.Connection.ConnectionString = SQLCon.ConnectionString();
this.p_Rpt_QuerCalculation_DiscountPositionTableAdapter.ClearBeforeFill = true;
this.p_Rpt_QuerCalculation_DiscountPositionTableAdapter.Fill(ds.P_Rpt_QuerCalculation_DiscountPosition, dtValue, _PID, _Type, _LVSection);
dsProposalCommon _dsCommon = new dsProposalCommon();
this.p_Rpt_PositionForProposalPriceForCommonTableAdapter.Connection.ConnectionString = SQLCon.ConnectionString();
this.p_Rpt_PositionForProposalPriceForCommonTableAdapter.ClearBeforeFill = true;
this.p_Rpt_PositionForProposalPriceForCommonTableAdapter.Fill(_dsCommon.P_Rpt_PositionForProposalPriceForCommon, dtValue, _PID, _Type, _LVSection);
dsProposalCommonTotalSummery _dsTotalSum = new dsProposalCommonTotalSummery();
this.p_Rpt_GetTotalSummeryTableAdapter.Connection.ConnectionString = SQLCon.ConnectionString();
this.p_Rpt_GetTotalSummeryTableAdapter.ClearBeforeFill = true;
this.p_Rpt_GetTotalSummeryTableAdapter.Fill(_dsTotalSum.P_Rpt_GetTotalSummery, dtValue, _PID, _Type, _LVSection);
DataTable dtdiscount = new DataTable();
dtdiscount = ds.P_Rpt_QuerCalculation_DiscountPosition;
if (dtdiscount != null)
{
decimal _result = 0;
if (decimal.TryParse(Convert.ToString(dtdiscount.Rows[0][0]), out _result))
{
if (_result != 0)
//&& !ISWithGB)
{
tbDiscount.Text = '-' + _result.ToString("n2");
_Discount = Convert.ToDouble(_result);
}
else
{
tbDiscount.Text = string.Empty;
_Discount = 0;
lblDiscount.Visible = false;
lblDiscountEuro.Visible = false;
}
}
}
}
catch (Exception ex)
{
Utility.ShowError(ex);
}
}
