protected void InvoiceDetails()
{
try
{
//ClearInvoiceControl();
UserName = Membership.GetUser().UserName;
ProductDivisionId = 13;
YearId = Convert.ToInt32(Ddlyear.SelectedValue);
if (ddlSerContractor.SelectedValue.Equals("0"))
{
spnSoldto.Visible = false;
}
if (!string.IsNullOrEmpty(ddlMonth.SelectedValue) && ddlMonth.SelectedValue != "0")
{
MonthId = Convert.ToInt32(ddlMonth.SelectedValue);
}
else
{
MonthId = DateTime.Now.Month;
ddlMonth.SelectedValue = DateTime.Now.Month.ToString();
}
hdnRawUrl.Value = "yId=" + YearId.ToString() + "&mId=" + MonthId.ToString();
if (!Roles.GetRolesForUser(objCommonMIS.EmpId).Any(x => (x.Contains("SC") || x.Contains("SC_SIMS"))))
{
AscId = Convert.ToInt32(ddlSerContractor.SelectedValue);
RegionId = Convert.ToInt32(ddlRegion.SelectedValue);
BranchId = Convert.ToInt32(ddlBranch.SelectedValue);
hdnRawUrl.Value = hdnRawUrl.Value + "&arb=" + ddlSerContractor.SelectedValue + "|" + ddlRegion.SelectedValue + "|" + ddlBranch.SelectedValue;
hdnRawUrl.Value = hdnRawUrl.Value + "&rbv=" + ddlRegion.SelectedItem.Text + "|" + ddlBranch.SelectedItem.Text;
}
else
{
AscId = 0;
RegionId = 0;
BranchId = 0;
hdnRawUrl.Value = hdnRawUrl.Value + "&arb=";
hdnRawUrl.Value = hdnRawUrl.Value + "&rbv=";
}
DataSet dsInvoice = GetInvoiceDetails();
if (dsInvoice != null)
{
if (dsInvoice.Tables[1].Rows.Count > 0)
{
lblCustomerName.Text = "<b>" + dsInvoice.Tables[1].Rows[0]["Sc_Name"].ToString() + "</b>";
lblAscAddress.Text = dsInvoice.Tables[1].Rows[0]["Addres"].ToString();
}
if (dsInvoice.Tables[2].Rows.Count > 0)
{
lblInvoiceNo.Text = dsInvoice.Tables[2].Rows[0]["InvoiceNo"].ToString();
lblInvoiceDate.Text = dsInvoice.Tables[2].Rows[0]["InvoiceDt"].ToString();
}
if (dsInvoice.Tables[0].Rows.Count > 0)
{
taxableAmt = Math.Round(Convert.ToDouble(dsInvoice.Tables[0].Compute("Sum(TaxableAmt)", "")), 2);
}
// callnew proc
calculate();
}
}
catch (Exception ex)
{
SIMSCommonClass.WriteErrorErrFile(Request.RawUrl.ToString(), ex.StackTrace.ToString() + "-->" + ex.Message.ToString());
}
}
protected void InvoiceDetails()
{
//ClearInvoiceControl();
UserName = ddlSerContractor.SelectedValue;
ProductDivisionId = 18;
YearId = Convert.ToInt32(Ddlyear.SelectedValue);
if (ddlSerContractor.SelectedValue.Equals("0"))
{
spnSoldto.Visible = false;
}
if (!string.IsNullOrEmpty(ddlMonth.SelectedValue) && ddlMonth.SelectedValue != "0")
{
MonthId = Convert.ToInt32(ddlMonth.SelectedValue);
}
else
{
MonthId = DateTime.Now.Month;
ddlMonth.SelectedValue = DateTime.Now.Month.ToString();
}
hdnRawUrl.Value = "yId=" + YearId.ToString() + "&mId=" + MonthId.ToString();
if (!Roles.GetRolesForUser(objCommonMIS.EmpId).Any(x => (x.Contains("SC") || x.Contains("SC_SIMS"))))
{
AscId = Convert.ToInt32(ddlSerContractor.SelectedValue);;
RegionId = Convert.ToInt32(ddlRegion.SelectedValue);
BranchId = Convert.ToInt32(ddlBranch.SelectedValue);
hdnRawUrl.Value = hdnRawUrl.Value + "&arb=" + ddlSerContractor.SelectedValue + "|" + ddlRegion.SelectedValue + "|" + ddlBranch.SelectedValue;
hdnRawUrl.Value = hdnRawUrl.Value + "&rbv=" + ddlRegion.SelectedItem.Text + "|" + ddlBranch.SelectedItem.Text;
}
else
{
//objsimsinvoice.AscId = 0;
RegionId = 0;
BranchId = 0;
hdnRawUrl.Value = hdnRawUrl.Value + "&arb=";
hdnRawUrl.Value = hdnRawUrl.Value + "&rbv=";
}
DataSet dsInvoice = GetInvoiceDetails();
if (dsInvoice != null)
{
if (dsInvoice.Tables[1].Rows.Count > 0)
{
lblCustomerName.Text = "<b>" + dsInvoice.Tables[1].Rows[0]["Sc_Name"].ToString() + "</b>";
lblAscAddress.Text = dsInvoice.Tables[1].Rows[0]["Addres"].ToString();
}
if (dsInvoice.Tables[2].Rows.Count > 0)
{
lblInvoiceNo.Text = dsInvoice.Tables[2].Rows[0]["InvoiceNo"].ToString();
lblInvoiceDate.Text = dsInvoice.Tables[2].Rows[0]["InvoiceDt"].ToString();
}
if (dsInvoice.Tables[0].Rows.Count > 0)
{
taxableAmt = Math.Round(Convert.ToDouble(dsInvoice.Tables[0].Compute("Sum(TaxableAmt)", "")), 2);
}
if (dsInvoice.Tables[3].Rows.Count > 0)
{
int countL = 0;
int countO = 0;
foreach (DataRow dr in dsInvoice.Tables[3].Rows)
{
if (dr["Activity"].ToString().Equals("L"))
{
countL = countL + 1;
}
if (dr["Activity"].ToString().Equals("O"))
{
countO = countO + 1;
}
}
lblRepLoQ.Text = countL.ToString();
lblRepLoA.Text = Convert.ToString(Convert.ToDouble(countL) * Convert.ToDouble(lblRepLoU.Text));
lblRepOoQ.Text = countO.ToString();
lblRepOoA.Text = Convert.ToString(Convert.ToDouble(countO) * Convert.ToDouble(lblRepOoU.Text));
}
foreach (DataRow dr in dsInvoice.Tables[0].Rows)
{
if (dr["ActivityParameter_SNo"].ToString().Equals("0"))
{
lblQuanityfd.Text = dr["Quantity"].ToString();
lblfdUnitPrice.Text = dr["UnitPrice"].ToString();
lblfdamount.Text = dr["Amount"].ToString();
}
}
calculate();
}
}
protected void InvoiceDetails()
{
try
{
//ClearInvoiceControl();
UserName = Membership.GetUser().UserName;
ProductDivisionId = 13;
YearId = Convert.ToInt32(Ddlyear.SelectedValue);
if (ddlSerContractor.SelectedValue.Equals("0"))
{
spnSoldto.Visible = false;
}
if (!string.IsNullOrEmpty(ddlMonth.SelectedValue) && ddlMonth.SelectedValue != "0")
{
MonthId = Convert.ToInt32(ddlMonth.SelectedValue);
}
else
{
MonthId = DateTime.Now.Month;
ddlMonth.SelectedValue = DateTime.Now.Month.ToString();
}
hdnRawUrl.Value = "yId=" + YearId.ToString() + "&mId=" + MonthId.ToString();
if (!Roles.GetRolesForUser(objCommonMIS.EmpId).Any(x => (x.Contains("SC") || x.Contains("SC_SIMS"))))
{
AscId = Convert.ToInt32(ddlSerContractor.SelectedValue);
RegionId = Convert.ToInt32(ddlRegion.SelectedValue);
BranchId = Convert.ToInt32(ddlBranch.SelectedValue);
hdnRawUrl.Value = hdnRawUrl.Value + "&arb=" + ddlSerContractor.SelectedValue + "|" + ddlRegion.SelectedValue + "|" + ddlBranch.SelectedValue;
hdnRawUrl.Value = hdnRawUrl.Value + "&rbv=" + ddlRegion.SelectedItem.Text + "|" + ddlBranch.SelectedItem.Text;
}
else
{
AscId = 0;
RegionId = 0;
BranchId = 0;
hdnRawUrl.Value = hdnRawUrl.Value + "&arb=";
hdnRawUrl.Value = hdnRawUrl.Value + "&rbv=";
}
DataSet dsInvoice = GetInvoiceDetails();
if (dsInvoice != null)
{
if (dsInvoice.Tables[1].Rows.Count > 0)
{
lblCustomerName.Text = "<b>" + dsInvoice.Tables[1].Rows[0]["Sc_Name"].ToString() + "</b>";
lblAscAddress.Text = dsInvoice.Tables[1].Rows[0]["Addres"].ToString();
}
if (dsInvoice.Tables[2].Rows.Count > 0)
{
lblInvoiceNo.Text = dsInvoice.Tables[2].Rows[0]["InvoiceNo"].ToString();
lblInvoiceDate.Text = dsInvoice.Tables[2].Rows[0]["InvoiceDt"].ToString();
}
if (dsInvoice.Tables[0].Rows.Count > 0)
{
taxableAmt = Math.Round(Convert.ToDouble(dsInvoice.Tables[0].Compute("Sum(TaxableAmt)", "")), 2);
}
// callnew proc
SqlParameter[] param =
{
new SqlParameter("@UserName", UserName),
new SqlParameter("@MonthId", ddlMonth.SelectedValue),
new SqlParameter("@YearId", Ddlyear.SelectedValue),
new SqlParameter("@type", "INS"),
new SqlParameter("@ProductDivisionSno", 13),
};
DataSet insdataset = objSqlDataAccessLayer.ExecuteDataset(CommandType.StoredProcedure, "GenerateInvoiceInstitutionalFan_Replica", param);
if (insdataset.Tables[0].Rows.Count > 0)
{
int countL = 0;
int countO = 0;
foreach (DataRow drs in insdataset.Tables[0].Rows)
{
if (drs["Activity"].ToString().Equals("L"))
{
countL = countL + 1;
}
if (drs["Activity"].ToString().Equals("O"))
{
countO = countO + 1;
}
}
lblRepLoQ.Text = countL.ToString();
lblRepLoA.Text = Convert.ToString(Convert.ToDouble(countL) * Convert.ToDouble(lblRepLoU.Text));
lblRepOoQ.Text = countO.ToString();
lblRepOoA.Text = Convert.ToString(Convert.ToDouble(countO) * Convert.ToDouble(lblRepOoU.Text));
}
foreach (DataRow dr in dsInvoice.Tables[0].Rows)
{
if (dr["ActivityParameter_SNo"].ToString().Equals("0"))
{
lblQuanityfd.Text = dr["Quantity"].ToString();
lblfdUnitPrice.Text = dr["UnitPrice"].ToString();
lblfdamount.Text = dr["Amount"].ToString();
}
}
calculate();
}
}
catch (Exception ex)
{
SIMSCommonClass.WriteErrorErrFile(Request.RawUrl.ToString(), ex.StackTrace.ToString() + "-->" + ex.Message.ToString());
}
}
