// [Conditional("max")]
protected void ShowReport()
{
SetData();
Ob.DatasetMain = BAL.BALFactory.Instance.Bal_Report.GetProcessWiseSummary(Ob);
grdReport.DataSource = Ob.DatasetMain;
grdReport.DataBind();
AppClass.CalcuateAndSetGridFooter(ref grdReport);
//SetCoputedDataSet(Ob, grdReport);
btnExportExcel.Visible = grdReport.Rows.Count > 1;
if (grdReport.Rows.Count > 0)
{
blnRight = AppClass.CheckExportToExcelRightOnPage();
if (blnRight)
{
btnExportExcel.Visible = true;
}
else
{
btnExportExcel.Visible = false;
}
}
}
protected void ShowReport()
{
grdReport.DataSource = null;
grdReport.DataBind();
Ob.DatasetMain = BAL.BALFactory.Instance.Bal_Report.GetDurationWiseReport(Ob);
if (Ob.DatasetMain == null || Ob.DatasetMain.Tables.Count == 0 || Ob.DatasetMain.Tables[0].Rows.Count == 0)
{
return;
}
// SetComputedColumn(Ob, grdReport);
grdReport.DataSource = Ob.DatasetMain;
grdReport.DataBind();
blnRight = AppClass.CheckExportToExcelRightOnPage();
if (blnRight)
{
btnExport.Visible = true;
}
else
{
btnExport.Visible = false;
}
AppClass.CalcuateAndSetGridFooter(ref grdReport);
}
protected void btnShowReport_Click(object sender, EventArgs e)
{
string res = BAL.BALFactory.Instance.BAL_RemoveReason.GetDateTime(Globals.BranchID);
DTO.Report Ob = new DTO.Report();
Ob = SetValue();
DataSet ds = new DataSet();
if (txtInvoiceNo.Text.Trim() != "")
{
if (drpSelectOption.SelectedValue == "1")
{
ds = BAL.BALFactory.Instance.Bal_Report.GetDeliveryByInvoiceNo(Ob);
}
if (drpSelectOption.SelectedValue == "2")
{
ds = BAL.BALFactory.Instance.Bal_Report.GetSaleByInvoiceNo(Ob);
}
if (drpSelectOption.SelectedValue == "3")
{
ds = BAL.BALFactory.Instance.Bal_Report.GetDeliveryAndSalesInvoiceNo(Ob);
}
}
else
{
var DateFromAndToTmp = hdnDateFromAndTo.Value.Split('-');
Ob.FromDate = DateFromAndToTmp[0].Trim();
Ob.UptoDate = DateFromAndToTmp[1].Trim();
ds = GetData(Ob);
}
ReportViewer1.Reset();
if (ds.Tables[0].Rows.Count > 0)
{
ReportViewer1.Visible = true;
blnRight = AppClass.CheckExportToExcelRightOnPage();
if (blnRight)
{
ReportViewer1.ShowExportControls = true;
}
else
{
ReportViewer1.ShowExportControls = false;
}
btnPrint.Visible = true;
if (drpSelectOption.SelectedValue == "1")
{
ReportViewer1.LocalReport.ReportPath = "RDLC/DeliveryReport.rdlc";
}
if (drpSelectOption.SelectedValue == "2")
{
ReportViewer1.LocalReport.ReportPath = "RDLC/SalesReport.rdlc";
}
if (drpSelectOption.SelectedValue == "3")
{
ReportViewer1.LocalReport.ReportPath = "RDLC/SalesDel.rdlc";
}
ReportViewer1.LocalReport.EnableHyperlinks = true;
bool rights = AppClass.GetShowFooterRightsUser();
string rvalue = string.Empty;
if (rights == true)
{
rvalue = "1";
}
else
{
rvalue = "0";
}
ReportParameter[] parameters = new ReportParameter[7];
string str = Request.Url.Authority;
string newstr = str + Request.ApplicationPath;
parameters[0] = new ReportParameter("FromDate", Ob.FromDate);
parameters[1] = new ReportParameter("ToDate", Ob.UptoDate);
parameters[2] = new ReportParameter("StrLink", newstr);
parameters[3] = new ReportParameter("UserName", Globals.UserName);
parameters[4] = new ReportParameter("GeneratedDate", "@" + " " + DateTime.Today.ToString("dd MMM yyyy") + " " + res);
parameters[5] = new ReportParameter("UserTypeId", Globals.UserType);
parameters[6] = new ReportParameter("TotalFooter", rvalue);
ReportViewer1.LocalReport.SetParameters(parameters);
ReportDataSource rds = new ReportDataSource();
if (drpSelectOption.SelectedValue == "1")
{
rds.Name = "ReportDelivery_Delivery";
}
if (drpSelectOption.SelectedValue == "2")
{
rds.Name = "ReportDelivery_Sales";
}
if (drpSelectOption.SelectedValue == "3")
{
rds.Name = "ReportDelivery_SalesDel";
}
rds.Value = ds.Tables[0];
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(rds);
ReportViewer1.DataBind();
ReportViewer1.LocalReport.Refresh();
string drpvalue = drpSelectOption.SelectedValue;
hdp_arr.Value = "";
hdd_arr.Value = "";
hdDateB.Value = "";
hdAmountB.Value = "";
for (int i = 0; i < ds.Tables["table"].Rows.Count; i++)
{
if (drpvalue == "1")
{
hdp_arr.Value += (Convert.ToDateTime(ds.Tables["table"].Rows[i][7].ToString())).ToString("dd/MM/yyyy") + ',';
hdd_arr.Value += ds.Tables["table"].Rows[i][5].ToString() + ',';
}
else if (drpvalue == "2")
{
hdp_arr.Value += (Convert.ToDateTime(ds.Tables["table"].Rows[i][6].ToString())).ToString("dd/MM/yyyy") + ',';
hdd_arr.Value += ds.Tables["table"].Rows[i][5].ToString() + ',';
}
else if (drpvalue == "3")
{
hdp_arr.Value += ds.Tables["table"].Rows[i][12].ToString() + ',';
hdd_arr.Value += ds.Tables["table"].Rows[i][5].ToString() + ',';
hdDateB.Value += ds.Tables["table"].Rows[i][12].ToString() + ',';
hdAmountB.Value += ds.Tables["table"].Rows[i][10].ToString() + ',';
}
}
}
else
{
lblMsg.Text = "No delivery and sales entry found.";
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "ScriptRegistration", "setDivMouseOver('Red', '#999999');", true);
ReportViewer1.Visible = false;
btnPrint.Visible = false;
}
}
protected void btnShowReport_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
Grdpayment.DataSource = null;
Grdpayment.DataBind();
var DateFromAndTo = hdnDateFromAndTo.Value.Split('-');
strFromDate = DateFromAndTo[0].Trim();
strToDate = DateFromAndTo[1].Trim();
hdnFromDate.Value = strFromDate;
hdnToDate.Value = strToDate;
btnExportExcel.Visible = false;
DTO.Report Ob = new DTO.Report();
Ob.FromDate = strFromDate;
Ob.UptoDate = strToDate;
Ob.CustId = hdnCustId.Value.Trim();
Ob.BranchId = Globals.BranchID;
if (txtCName.Text.Trim() != "")
{
if (drpSelectOption.SelectedValue == "1")
{
ds = BAL.BALFactory.Instance.Bal_Report.GetMultipleDeliveryByCustomer(Ob);
btnDeliverClothes.Visible = true;
btnAcceptPayment.Visible = false;
btnDeliverAndPayment.Visible = false;
}
if (drpSelectOption.SelectedValue == "2")
{
ds = BAL.BALFactory.Instance.Bal_Report.GetMultiplePaymentByCustomer(Ob);
btnDeliverClothes.Visible = false;
btnAcceptPayment.Visible = true;
btnDeliverAndPayment.Visible = false;
}
if (drpSelectOption.SelectedValue == "3")
{
ds = BAL.BALFactory.Instance.Bal_Report.GetMultipleBothOutPutByCustomer(Ob);
btnDeliverClothes.Visible = false;
btnAcceptPayment.Visible = false;
btnDeliverAndPayment.Visible = true;
}
if (drpSelectOption.SelectedValue == "4")
{
ds = BAL.BALFactory.Instance.Bal_Report.GetMultipleOutstandingGarmentByCustomer(Ob);
btnDeliverClothes.Visible = true;
btnAcceptPayment.Visible = false;
btnDeliverAndPayment.Visible = false;
}
if (drpSelectOption.SelectedValue == "5")
{
ds = BAL.BALFactory.Instance.Bal_Report.GetOutstandingPaymentByCustomer(Ob);
btnDeliverClothes.Visible = false;
btnAcceptPayment.Visible = true;
btnDeliverAndPayment.Visible = false;
}
}
else
{
if (drpSelectOption.SelectedValue == "1")
{
ds = BAL.BALFactory.Instance.Bal_Report.GetMultipleDeliveryByFromToUptoDate(Ob);
btnDeliverClothes.Visible = true;
btnAcceptPayment.Visible = false;
btnDeliverAndPayment.Visible = false;
}
if (drpSelectOption.SelectedValue == "2")
{
ds = BAL.BALFactory.Instance.Bal_Report.GetMultiplePaymentByFromToUptoDate(Ob);
btnDeliverClothes.Visible = false;
btnAcceptPayment.Visible = true;
btnDeliverAndPayment.Visible = false;
}
if (drpSelectOption.SelectedValue == "3")
{
ds = BAL.BALFactory.Instance.Bal_Report.GetMultipleBothOutPutFromToUptoDate(Ob);
btnDeliverClothes.Visible = false;
btnAcceptPayment.Visible = false;
btnDeliverAndPayment.Visible = true;
}
if (drpSelectOption.SelectedValue == "4")
{
ds = BAL.BALFactory.Instance.Bal_Report.GetOutstandinGarmentFromToUptoDate(Ob);
btnDeliverClothes.Visible = true;
btnAcceptPayment.Visible = false;
btnDeliverAndPayment.Visible = false;
}
if (drpSelectOption.SelectedValue == "5")
{
ds = BAL.BALFactory.Instance.Bal_Report.GetPendingPaymentFromToUptoDate(Ob);
btnDeliverClothes.Visible = false;
btnAcceptPayment.Visible = true;
btnDeliverAndPayment.Visible = false;
}
}
if (ds.Tables[0].Rows.Count > 0)
{
Grdpayment.DataSource = ds;
Grdpayment.DataBind();
txtCName.Text = "";
txtSearchInoviceNo.Focus();
// btnExportExcel.Visible = true;
bool blnRight = AppClass.CheckExportToExcelRightOnPage();
if (blnRight)
{
btnExportExcel.Visible = true;
}
else
{
btnExportExcel.Visible = false;
}
CalculateGridReport();
// tblBarcode.Visible = true;
}
else
{
btnDeliverClothes.Visible = false;
btnAcceptPayment.Visible = false;
btnDeliverAndPayment.Visible = false;
// tblBarcode.Visible = false;
}
ButtonTrueFalse(drpSelectOption.SelectedValue);
}
private void ShowBookingDetails(string strStartDate, string strToDate, bool bIsBooking = true)
{
DataSet ds = new DataSet();
grdReport.DataSource = null;
grdReport.DataBind();
ob.BranchId = Globals.BranchID;
ob.FromDate = strStartDate;
ob.UptoDate = strToDate;
hdnFromDate.Value = ob.FromDate;
hdnToDate.Value = ob.UptoDate;
ob.InvoiceNo = (bIsBooking) ? "1" : "2";
if (drpReportFrom.SelectedItem.Value == "Summarised Booking")
{
ob.InvoiceNo = "3";
}
else if (drpReportFrom.SelectedItem.Value == "Summarised Delivery")
{
ob.InvoiceNo = "4";
}
ds = BAL.BALFactory.Instance.Bal_Report.BindServiceTax(ob);
if (ob.InvoiceNo == "3" || ob.InvoiceNo == "4")
{
grdReportSummary.DataSource = ds;
grdReport.DataSource = null;
grdReport.Visible = false;
grdReportSummary.Visible = true;
}
else
{
grdReportSummary.DataSource = null;
grdReport.DataSource = ds;
grdReport.Visible = true;
grdReportSummary.Visible = false;
}
grdReportSummary.DataBind();
grdReport.DataBind();
blnRight = AppClass.CheckExportToExcelRightOnPage();
if (blnRight)
{
btnExport.Visible = true;
if (ds.Tables[0].Rows.Count > 0)
{
btnExport.Visible = true;
}
else
{
btnExport.Visible = false;
}
}
else
{
btnExport.Visible = false;
}
if (ds.Tables[0].Rows.Count > 0)
{
btnPrint.Visible = true;
}
else
{
btnPrint.Visible = false;
}
ds = BAL.BALFactory.Instance.Bal_Report.BindServiceTax(ob);
string res = BAL.BALFactory.Instance.BAL_RemoveReason.GetDateTime(Globals.BranchID);
if (grdReport.Rows.Count > 0)
{
//CalculateGridReport();
AppClass.CalcuateAndSetGridFooter(ref grdReport);
}
else if (grdReportSummary.Rows.Count > 0)
{
//CalculateGridReportSummary();
AppClass.CalcuateAndSetGridFooter(ref grdReportSummary, 0, drpReportFrom.SelectedItem.Value == "Summarised Booking" ? 1 : 2);
}
if (ds.Tables[0].Rows.Count > 0)
{
if (ob.InvoiceNo == "1")
{
ReportViewer1.LocalReport.ReportPath = "RDLC/BookingServiceTax.rdlc";
}
else
if (ob.InvoiceNo == "2")
{
ReportViewer1.LocalReport.ReportPath = "RDLC/DeliveryServiceTax.rdlc";
}
else
if (ob.InvoiceNo == "3")
{
ReportViewer1.LocalReport.ReportPath = "RDLC/SumBookingServiceTax.rdlc";
}
else
{
ReportViewer1.LocalReport.ReportPath = "RDLC/SumDeliveryServiceTax.rdlc";
}
ReportDataSource rds = new ReportDataSource();
ReportParameter[] parameters = new ReportParameter[7];
parameters[0] = new ReportParameter("UserName", Globals.UserName);
parameters[1] = new ReportParameter("GeneratedDate", "@" + " " + DateTime.Today.ToString("dd MMM yyyy") + " " + res);
parameters[2] = new ReportParameter("FromDate", ob.FromDate);
parameters[3] = new ReportParameter("ToDate", ob.UptoDate);
parameters[4] = new ReportParameter("Tax1", _LabelTax1);
parameters[5] = new ReportParameter("Tax2", _LabelTax2);
parameters[6] = new ReportParameter("Tax3", _LabelTax3);
//parameters[2] = new ReportParameter("Link", str);
ReportViewer1.LocalReport.SetParameters(parameters);
rds.Name = "DataSet1";
rds.Value = ds.Tables[0];
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(rds);
ReportViewer1.LocalReport.Refresh();
}
}
private void ShowBookingDetails(string strStartDate, string strToDate)
{
grdReport.DataSource = null;
grdReport.DataBind();
btnExport.Visible = false;
DTO.Report.BFlag = false;
if (!HttpContext.Current.Items.Contains("IsPrintingForMany"))
{
HttpContext.Current.Items.Add("IsPrintingForMany", "false");
}
else
{
HttpContext.Current.Items["IsPrintingForMany"] = "false";
}
hdnDTOReportsBFlag.Value = "false";
DTO.Report ObMain = new DTO.Report();
ObMain.FromDate = strStartDate;
ObMain.UptoDate = strToDate;
ObMain.InvoiceNo = txtInvoiceNo.Text;
ObMain.BranchId = Globals.BranchID;
if (txtInvoiceNo.Text != "")
{
ObMain.Description = "6";
}
else
{
ObMain.Description = "5";
}
DataSet dsMain = new DataSet();
dsMain = BAL.BALFactory.Instance.Bal_Report.GetDataMainReport(ObMain);
try
{
if (dsMain.Tables.Count > 0)
{
if (dsMain.Tables[0].Rows.Count > 0)
{
if (dsMain.Tables[0].Columns[0].ColumnName == "Error")
{
throw new Exception(dsMain.Tables[0].Rows[0][1].ToString());
}
grdReport.DataSource = dsMain.Tables[0];
grdReport.DataBind();
DTO.Report.BFlag = false;
if (!HttpContext.Current.Items.Contains("IsPrintingForMany"))
{
HttpContext.Current.Items.Add("IsPrintingForMany", "false");
}
else
{
HttpContext.Current.Items["IsPrintingForMany"] = "false";
}
hdnDTOReportsBFlag.Value = "false";
ViewState["SavedDS"] = dsMain;
AppClass.CalcuateAndSetGridFooter(ref grdReport);
bool blnRight = AppClass.CheckExportToExcelRightOnPage();
if (blnRight)
{
btnExport.Visible = true;
}
else
{
btnExport.Visible = false;
}
}
}
}
catch (Exception excp)
{
lblErr.Text = "Error : " + excp.Message;
}
finally
{
txtInvoiceNo.Focus();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ArrayList Date = BAL.BALFactory.Instance.BAL_DateAndTime.getDateAndTimeAccordingToZoneTime(Session["BID"].ToString());
if (Request.QueryString["Acess"] != null)
{
Session["ReturnMsg"] = "You are not authorized !";
return;
}
if (Request.QueryString["Tab"] != null)
{
Session["ReturnMsg"] = "Stock reconcilliation is already open.";
return;
}
bool status = DAL.DALFactory.Instance.DAL_NewChallan.DefaultFactory(Globals.BranchID);
strCurrentDate = Date[0].ToString();
if (status == true)
{
grdReport.Visible = false;
grdDelivery.Visible = false;
grdHomeDelivery.Visible = false;
grdCustomerAnniversary.Visible = false;
grdCustomerBirthDay.Visible = false;
btnUrgentBookingShow.Visible = false;
btnTodayDelivered.Visible = false;
btnHomeDelivery.Visible = false;
btnCustomerBirthday.Visible = false;
btnAnniversary.Visible = false;
lblCustAni.Visible = false;
Label4.Visible = false;
lblCustBirt.Visible = false;
Label3.Visible = false;
lblHomDel.Visible = false;
Label2.Visible = false;
Label6.Visible = false;
LblUBook.Visible = false;
Label1.Visible = false;
}
else
{
strFromDate = strCurrentDate;
ShowBookingDetails1(strFromDate);
ShowBookingDetails2(strFromDate);
ShowCustomerBirthday(strFromDate);
ShowCustomerAnniversary(strFromDate);
ShowBookingDetails(strFromDate);
blnRight = AppClass.CheckExportToExcelRightOnPage();
if (blnRight)
{
btnHomeDelivery.Visible = true;
btnCustomerBirthday.Visible = true;
btnAnniversary.Visible = true;
btnTodayDelivered.Visible = true;
btnUrgentBookingShow.Visible = true;
}
else
{
btnHomeDelivery.Visible = false;
btnCustomerBirthday.Visible = false;
btnAnniversary.Visible = false;
btnTodayDelivered.Visible = false;
btnUrgentBookingShow.Visible = false;
}
}
if (Request.QueryString["Backup"] != null)
{
SetBackup();
}
}
}