protected void gvClaimUploadDtl_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
GridViewRow gvrow = (GridViewRow)(((ImageButton)e.CommandSource).NamingContainer);
string DataUniqueId = gvClaimUploadDtl.DataKeys[gvrow.RowIndex].Value.ToString();
if (e.CommandName == "PrintEntry")
{
clsInputParameter objInputParameter = new clsInputParameter();
objInputParameter.DataUniqueId = Convert.ToInt64(DataUniqueId);
objInputParameter.RequestUrl = Request.QueryString["ID"].Trim();
Session["InputParameter"] = objInputParameter;
Session["ReportName"] = "VariableClaimPrize";
Response.Redirect("rptViewAppReport.aspx");
}
else if (e.CommandName == "DeleteEntry")
{
bool isDeleted = objLtmsService.DeleteInVariableClaimByVoucherId(Convert.ToInt64(DataUniqueId));
if (isDeleted == true)
{
BindClaimGvData();
ScriptManager.RegisterStartupScript(this, GetType(), "MyMsg", "alert('Claim information deleted.');", true);
}
}
}
catch (Exception Ex)
{
objValidateData.SaveSystemErrorLog(Ex, Request.UserHostAddress);
var message = new JavaScriptSerializer().Serialize("Some Error has occurred while performing your activity. Please contact the System Administrator for further assistance.");
var script = string.Format("alert({0});", message);
ScriptManager.RegisterClientScriptBlock(this, GetType(), "", script, true);
}
}
protected void GvData_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
DataTable dtInfo = new DataTable();
GridViewRow gvrow = (GridViewRow)(((ImageButton)e.CommandSource).NamingContainer);
hdUniqueId.Value = GvData.DataKeys[gvrow.RowIndex].Value.ToString();
if (e.CommandName == "PrintEntry")
{
Session["Allow"] = false;
Session["UserInfo"] = null;
clsInputParameter objInputParameter = new clsInputParameter();
objInputParameter.DataUniqueId = Convert.ToInt64(hdUniqueId.Value);
// objInputParameter.RequestUrl = Request.QueryString["ID"].Trim();
Session["InputParameter"] = objInputParameter;
Session["ReportName"] = "WinneListDtlById";
Response.Redirect("rptViewAppReport.aspx");
}
dtInfo.Dispose();
}
catch (Exception Ex)
{
objValidateData.SaveSystemErrorLog(Ex, Request.UserHostAddress);
var message = new JavaScriptSerializer().Serialize("Some Error has occurred while performing your activity. Please contact the System Administrator for further assistance.");
var script = string.Format("alert({0});", message);
ScriptManager.RegisterClientScriptBlock(this, GetType(), "", script, true);
}
}
private void BindGvData()
{
try
{
int GovIdId = Convert.ToInt16(ddlGovernmentOrder.SelectedValue);
int ClaimType = Convert.ToInt16(ddlClaimType.SelectedValue);
clsInputParameter objInputParameter = new clsInputParameter();
objInputParameter.InFromDate = Convert.ToDateTime(txtFromDate.Text.Trim() + " 00:00:00.000");
objInputParameter.InToDate = Convert.ToDateTime(txtToDate.Text.Trim() + " 23:59:59.999");
objInputParameter.InStatus = Convert.ToInt16(ddlStatus.SelectedValue);
GvData.DataSource = objLtmsService.GetLotteryClaimSendToGovDtlByStatus(objInputParameter, ClaimType, GovIdId);
GvData.DataBind();
gridDiv.Visible = objMenuOptions.AllowView;
btnPrint.Visible = (GvData.Rows.Count > 0 ? true : false);
btnSave.Visible = (ddlClaimType.SelectedIndex > 0 ? true : false);
}
catch (Exception Ex)
{
objValidateData.SaveSystemErrorLog(Ex, Request.UserHostAddress);
var message = new JavaScriptSerializer().Serialize("Some Error has occurred while performing your activity. Please contact the System Administrator for further assistance.");
var script = string.Format("alert({0});", message);
ScriptManager.RegisterClientScriptBlock(this, GetType(), "", script, true);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
if (ddlReportType.SelectedIndex == 0)
{
ScriptManager.RegisterStartupScript(this, GetType(), "MyMsg", "alert('Please report type.');", true);
ddlReportType.Focus();
return;
}
clsInputParameter objInputParameter = new clsInputParameter();
objInputParameter.InFromDate = Convert.ToDateTime(txtFromDate.Text.Trim() + " 00:00:00.000");
objInputParameter.InToDate = Convert.ToDateTime(txtToDate.Text.Trim() + " 23:59:59.999");
objInputParameter.InStatus = Convert.ToInt16("-10");
objInputParameter.RequestUrl = Request.QueryString["ID"].Trim();
Session["InputParameter"] = objInputParameter;
Session["ReportName"] = ddlReportType.SelectedValue.ToString();
Response.Redirect("rptViewAppReport.aspx");
}
catch (Exception Ex)
{
objValidateData.SaveSystemErrorLog(Ex, Request.UserHostAddress);
var message = new JavaScriptSerializer().Serialize("Some Error has occurred while performing your activity. Please contact the System Administrator for further assistance. The error is as below " + Ex.Message + "");
var script = string.Format("alert({0});", message);
ScriptManager.RegisterClientScriptBlock(this, GetType(), "", script, true);
}
}
protected void btnPrint_Click(object sender, EventArgs e)
{
clsInputParameter objInputParameter = new clsInputParameter();
objInputParameter.RequestUrl = Request.QueryString["ID"].Trim();
Session["InputParameter"] = objInputParameter;
Session["ReportName"] = "Prize";
Response.Redirect("rptViewAppReport.aspx");
}
protected void GvData_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
int SaveStatus = 0;
DataTable dtInfo = new DataTable();
GridViewRow gvrow = (GridViewRow)(((ImageButton)e.CommandSource).NamingContainer);
hdUniqueId.Value = GvData.DataKeys[gvrow.RowIndex].Value.ToString();
// fill the Location information for edit
if (e.CommandName == "EditEntry")
{
objValidateData.ClearAllInputField(pnlDataEntry);
dtInfo = objLtmsService.GetRequisitionTransactionDtlById(Convert.ToInt64(hdUniqueId.Value));
if (dtInfo.Rows.Count > 0)
{
txtDrawNo.Text = dtInfo.Rows[0]["DrawNo"].ToString();
txtDrawDate.Text = Convert.ToDateTime(dtInfo.Rows[0]["DrawDate"]).ToString("dd-MMM-yyyy");
txtLotteryType.Text = dtInfo.Rows[0]["LotteryType"].ToString();
txtLotteryName.Text = dtInfo.Rows[0]["LotteryName"].ToString();
txtDrawNo.Text = dtInfo.Rows[0]["DrawNo"].ToString();
txtQuantity.Text = dtInfo.Rows[0]["Qty"].ToString();
txtAmount.Text = dtInfo.Rows[0]["TotAmount"].ToString();
txtClaimQuantity.Text = dtInfo.Rows[0]["ClaimedCount"].ToString();
txtClaimAmount.Text = (Convert.ToDouble(dtInfo.Rows[0]["ClaimedCountAmount"])).ToString();
txtUnSoldQty.Text = dtInfo.Rows[0]["CountOfUnSoldTicket"].ToString();
txtUnSoldAmount.Text = (Convert.ToDouble(dtInfo.Rows[0]["AmountOfUnSoldTicket"])).ToString();
txtDealerAdjustAmount.Text = (Convert.ToDouble(txtClaimAmount.Text) + Convert.ToDouble(txtUnSoldAmount.Text)).ToString("0.00");
btnConfirm.Visible = true;
}
dtInfo.Dispose();
pnlDataEntry.Visible = true;
pnlDataDisplay.Visible = false;
}
if (e.CommandName == "PrintEntry")
{
clsInputParameter objInputParameter = new clsInputParameter();
objInputParameter.DataUniqueId = Convert.ToInt64(hdUniqueId.Value);
objInputParameter.RequestUrl = Request.QueryString["ID"].Trim();
Session["InputParameter"] = objInputParameter;
Session["ReportName"] = "UnsoldPrize";
Response.Redirect("rptViewAppReport.aspx");
}
dtInfo.Dispose();
}
catch (Exception Ex)
{
objValidateData.SaveSystemErrorLog(Ex, Request.UserHostAddress);
var message = new JavaScriptSerializer().Serialize("Some Error has occurred while performing your activity. Please contact the System Administrator for further assistance.");
var script = string.Format("alert({0});", message);
ScriptManager.RegisterClientScriptBlock(this, GetType(), "", script, true);
}
}
protected void btnPrint_Click(object sender, EventArgs e)
{
clsInputParameter objInputParameter = new clsInputParameter();
objInputParameter.InFromDate = Convert.ToDateTime(txtFromDate.Text.Trim());
objInputParameter.InToDate = Convert.ToDateTime(txtToDate.Text.Trim());
objInputParameter.InStatus = Convert.ToInt16(ddlStatus.SelectedValue);
Session["InputParameter"] = objInputParameter;
Session["ReportName"] = "DealerDepositReconByDirViewDtl";
Response.Redirect("rptViewAppReport.aspx");
}
protected void btnPrint_Click(object sender, EventArgs e)
{
clsInputParameter objInputParameter = new clsInputParameter();
objInputParameter.InFromDate = Convert.ToDateTime(txtFromDate.Text.Trim() + " 00:00:00.000");
objInputParameter.InToDate = Convert.ToDateTime(txtToDate.Text.Trim() + " 23:59:59.999");
objInputParameter.InStatus = Convert.ToInt16(ddlStatus.SelectedValue);
objInputParameter.RequestUrl = Request.QueryString["ID"].Trim();
Session["InputParameter"] = objInputParameter;
Session["ReportName"] = "RequisitionApprovalDtl";
Response.Redirect("rptViewAppReport.aspx");
}
private void BindGvData()
{
try
{
clsInputParameter objInputParameter = new clsInputParameter();
objInputParameter.InFromDate = Convert.ToDateTime(DateTime.Now.AddMonths(-2).ToString("dd-MMM-yyyy") + " 00:00:00.000");
objInputParameter.InToDate = Convert.ToDateTime(DateTime.Now.ToString("dd-MMM-yyyy") + " 23:59:59.999");
objInputParameter.InStatus = Convert.ToInt16(-150);
GvData.DataSource = objLtmsService.GetRequisitionDtlByStatus(objInputParameter);
GvData.DataBind();
}
catch (Exception Ex)
{
objValidateData.SaveSystemErrorLog(Ex, Request.UserHostAddress);
var message = new JavaScriptSerializer().Serialize("Some Error has occurred while performing your activity. Please contact the System Administrator for further assistance.");
var script = string.Format("alert({0});", message);
ScriptManager.RegisterClientScriptBlock(this, GetType(), "", script, true);
}
}
private void BindGvData()
{
try
{
clsInputParameter objInputParameter = new clsInputParameter();
objInputParameter.InFromDate = Convert.ToDateTime(txtFromDate.Text.Trim() + " 00:00:00.000");
objInputParameter.InToDate = Convert.ToDateTime(txtToDate.Text.Trim() + " 23:59:59.999");
objInputParameter.InStatus = Convert.ToInt16(ddlStatus.SelectedValue);
GvData.DataSource = objLtmsService.GetRequisitionDtlByStatus(objInputParameter);
GvData.DataBind();
GvData.Columns[0].Visible = objMenuOptions.AllowEdit;
gridDiv.Visible = objMenuOptions.AllowView;
}
catch (Exception Ex)
{
objValidateData.SaveSystemErrorLog(Ex, Request.UserHostAddress);
var message = new JavaScriptSerializer().Serialize("Some Error has occurred while performing your activity. Please contact the System Administrator for further assistance.");
var script = string.Format("alert({0});", message);
ScriptManager.RegisterClientScriptBlock(this, GetType(), "", script, true);
}
}
public DataTable GetLotteryClaimSendToGovDtlByStatus(clsInputParameter objInputParameter, int InClaimType, int GovId)
{
return(objBusinessLogicDbTrx.GetLotteryClaimSendToGovDtlByStatus(objInputParameter, InClaimType, GovId));
}
public DataTable GetDealerDepositViewForApprovalDtl(clsInputParameter objInputParameter, int DepositToId)
{
return(objBusinessLogicDbTrx.GetDealerDepositViewForApprovalDtl(objInputParameter, DepositToId));
}
public DataTable GetDealerDepositViewDtl(clsInputParameter objInputParameter)
{
return(objBusinessLogicDbTrx.GetDealerDepositViewDtl(objInputParameter));
}
public void ViewReport(string ReportName)
{
try
{
//ReportName
clsInputParameter objInputParameter = new clsInputParameter();
objInputParameter.InFromDate = Convert.ToDateTime(((clsInputParameter)Session["InputParameter"]).InFromDate);
objInputParameter.InToDate = Convert.ToDateTime(((clsInputParameter)Session["InputParameter"]).InToDate);
objInputParameter.InStatus = Convert.ToInt16(((clsInputParameter)Session["InputParameter"]).InStatus);
string DataSource = "", ReportPath = "";
DataTable dtReport = new DataTable();
#region Fill the dataset
switch (ReportName)
{
case "DealerDepositViewDtl":
lblReport.Text = "Dealer Deposit Report for the period: " + Convert.ToDateTime(objInputParameter.InFromDate).ToString("dd-MMM-yyyy") + " To " + Convert.ToDateTime(objInputParameter.InToDate).ToString("dd-MMM-yyyy");
dtReport = objLtmsService.GetDealerDepositViewDtl(objInputParameter);
DataSource = "dsDealerDepositViewDtl";
ReportPath = @"~/ReportTemplate/rptDealerDepositViewDtl.rdlc";
break;
case "DealerDepositReconByDirViewDtl":
lblReport.Text = "Dealer Deposit Reconcilation Report for the period: " + Convert.ToDateTime(objInputParameter.InFromDate).ToString("dd-MMM-yyyy") + " To " + Convert.ToDateTime(objInputParameter.InToDate).ToString("dd-MMM-yyyy");
dtReport = objLtmsService.GetDealerDepositViewForApprovalDtl(objInputParameter, 1);
DataSource = "dsDealerDepositViewDtl";
ReportPath = @"~/ReportTemplate/rptDealerDepositViewDtl.rdlc";
break;
case "DealerDepositReconBySplViewDtl":
lblReport.Text = "Dealer Deposit Reconcilation Report for the period: " + Convert.ToDateTime(objInputParameter.InFromDate).ToString("dd-MMM-yyyy") + " To " + Convert.ToDateTime(objInputParameter.InToDate).ToString("dd-MMM-yyyy");
dtReport = objLtmsService.GetDealerDepositViewForApprovalDtl(objInputParameter, 2);
DataSource = "dsDealerDepositViewDtl";
ReportPath = @"~/ReportTemplate/rptDealerDepositViewDtl.rdlc";
break;
case "DealerDepositApprovalByDir":
lblReport.Text = "Dealer Deposit Report for the period: " + Convert.ToDateTime(objInputParameter.InFromDate).ToString("dd-MMM-yyyy") + " To " + Convert.ToDateTime(objInputParameter.InToDate).ToString("dd-MMM-yyyy");
dtReport = objLtmsService.GetDealerDepositViewForApprovalDtl(objInputParameter, 1);
DataSource = "dsDealerDepositViewDtl";
ReportPath = @"~/ReportTemplate/rptDealerDepositViewDtl.rdlc";
break;
case "DealerDepositApprovalBySpl":
lblReport.Text = "Dealer Deposit Report for the period: " + Convert.ToDateTime(objInputParameter.InFromDate).ToString("dd-MMM-yyyy") + " To " + Convert.ToDateTime(objInputParameter.InToDate).ToString("dd-MMM-yyyy");
dtReport = objLtmsService.GetDealerDepositViewForApprovalDtl(objInputParameter, 2);
DataSource = "dsDealerDepositViewDtl";
ReportPath = @"~/ReportTemplate/rptDealerDepositViewDtl.rdlc";
break;
case "RequisitionViewDtl":
lblReport.Text = "Requisition Report";
dtReport = objLtmsService.GetRequisitionDtl(objInputParameter);
DataSource = "dsRequisitionViewDtl";
ReportPath = @"~/ReportTemplate/rptRequisitionViewDtl.rdlc";
break;
case "RequisitionApprovalDtl":
lblReport.Text = "Requisition Report";
dtReport = objLtmsService.GetRequisitionDtlByStatus(objInputParameter);
DataSource = "dsRequisitionViewDtl";
ReportPath = @"~/ReportTemplate/rptRequisitionApprovalViewDtl.rdlc";
break;
case "LotteryType":
lblReport.Text = "Lottery Type Master Report";
dtReport = objLtmsService.GetLotteryTypeDtl();
DataSource = "dsMstLotteryType";
ReportPath = @"~/ReportTemplate/rptLotteryType.rdlc";
break;
case "Lottery":
lblReport.Text = "Lottery Master Report";
dtReport = objLtmsService.GetLotteryDtl();
DataSource = "dsLottery";
ReportPath = @"~/ReportTemplate/rptLottery.rdlc";
break;
case "Prize":
lblReport.Text = "Prize Master Report";
dtReport = objLtmsService.GetPrizeDtl();
DataSource = "dsPrizeMaster";
ReportPath = @"~/ReportTemplate/rptPrizeMaster.rdlc";
break;
case "WinneListDtlById":
lblReport.Text = "Winne List Details";
dtReport = objLtmsService.GetWinneListDtlById(Convert.ToInt64(((clsInputParameter)Session["InputParameter"]).DataUniqueId));
DataSource = "dsWinneListDtl";
ReportPath = @"~/ReportTemplate/rptWinneListDtl.rdlc";
break;
case "UnSoldSummary":
lblReport.Text = "Un-Sold Summary";
dtReport = objLtmsService.GetUnSoldSummaryById(Convert.ToInt64(((clsInputParameter)Session["InputParameter"]).DataUniqueId));
DataSource = "dsUnSoldSummary";
ReportPath = @"~/ReportTemplate/rptUnSoldSummary.rdlc";
break;
case "SendToGovAnnextureIII":
lblReport.Text = "Send To Gov. Annexture-III";
dtReport = objLtmsService.GetSendToGovAnnextureIIIByID(Convert.ToInt64(((clsInputParameter)Session["InputParameter"]).DataUniqueId));
DataSource = "dsSendToGovAnnextureIII";
ReportPath = @"~/ReportTemplate/rptSendToGovAnnextureIII.rdlc";
break;
case "VariableClaimPrize":
lblReport.Text = "Variable Claim Prize";
dtReport = objLtmsService.GetVariableClaimByClaimId(Convert.ToInt64(((clsInputParameter)Session["InputParameter"]).DataUniqueId));
DataSource = "dsVariableClaimPrize";
ReportPath = @"~/ReportTemplate/rptVariableClaimPrize.rdlc";
break;
case "UnsoldPrize":
lblReport.Text = "Unsold Prize";
dtReport = objLtmsService.GetLotteryUnsold(Convert.ToInt64(((clsInputParameter)Session["InputParameter"]).DataUniqueId));
DataSource = "DsUnsoldReport";
ReportPath = @"~/ReportTemplate/RptUnsoldReport.rdlc";
break;
case "VariableClaimSuper":
lblReport.Text = "VariableClaimSuper";
dtReport = objLtmsService.GetVariableIncentiveByReqId(Convert.ToInt64(((clsInputParameter)Session["InputParameter"]).DataUniqueId), "SUPER");
DataSource = "dsVariableClaimSuper";
ReportPath = @"~/ReportTemplate/rptVariableClaimSuper.rdlc";
break;
case "VariableClaimSpecial":
lblReport.Text = "VariableClaimSpecial";
dtReport = objLtmsService.GetVariableIncentiveByReqId(Convert.ToInt64(((clsInputParameter)Session["InputParameter"]).DataUniqueId), "SPECIAL");
DataSource = "dsVariableClaimSpecial";
ReportPath = @"~/ReportTemplate/rptVariableClaimSpecial.rdlc";
break;
case "PrintOrder":
lblReport.Text = "PrintOrder";
dtReport = objLtmsService.GetPrintOrderDtlById(Convert.ToInt64(((clsInputParameter)Session["InputParameter"]).DataUniqueId));
DataSource = "dsPrintingOrder";
ReportPath = @"~/ReportTemplate/rptPrintOrder.rdlc";
break;
case "TicketInventoryAdjustment":
lblReport.Text = "Ticket Inventory Adjustment";
dtReport = objLtmsService.GetDealerListOfTransactionDtl();
DataSource = "dsTicketInventoryAdjustment";
ReportPath = @"~/ReportTemplate/rptTicketInventoryAdjustment.rdlc";
break;
case "UnsoldPrizeDistributor":
lblReport.Text = "Unsold Prize Distributor";
dtReport = objLtmsService.GetLotteryUnsold(Convert.ToInt64(((clsInputParameter)Session["InputParameter"]).DataUniqueId));
DataSource = "DsUnsoldReport";
ReportPath = @"~/ReportTemplate/RptUnsoldReportfrormDistributor.rdlc";
break;
case "UnsoldPrizeRemain":
lblReport.Text = "Unsold Prize Remain";
dtReport = objLtmsService.GetLotteryUnsold(Convert.ToInt64(((clsInputParameter)Session["InputParameter"]).DataUniqueId));
DataSource = "DsUnsoldReport";
ReportPath = @"~/ReportTemplate/RptUnsoldReportRemain.rdlc";
break;
case "ProfitLossDtlByReqId":
lblReport.Text = "Ticket Inventory Profit And Loss";
dtReport = objLtmsService.GetProfitLossDtlByReqId(Convert.ToInt64(((clsInputParameter)Session["InputParameter"]).DataUniqueId));
DataSource = "dsTicketInventoryAdjustment";
ReportPath = @"~/ReportTemplate/rptProfitLossDtlByReqId.rdlc";
break;
case "BankGuranteeLedger":
lblReport.Text = "Bank Gurantee Ledger";
dtReport = objLtmsService.GetBankGuranteeLedger(objInputParameter);
DataSource = "dsBankGuranteeLedger";
ReportPath = @"~/ReportTemplate/rptBankGuranteeLedger.rdlc";
break;
case "DrawwisePrintingCostOfLotteryTicket":
lblReport.Text = "Drawwise Printing Cost of Lottery Ticket";
dtReport = objLtmsService.GetPrintOrderDtlById(Convert.ToInt64(((clsInputParameter)Session["InputParameter"]).DataUniqueId));
DataSource = "dsDrawwisePrintingCostOfLotteryTicket";
ReportPath = @"~/ReportTemplate/rptDrawwisePrintingCostOfLotteryTicket.rdlc";
break;
case "DrawwiseSalesReport":
lblReport.Text = "Draw wise Sales Report";
dtReport = objLtmsService.GetRequisitionDtlByStatus(objInputParameter);
DataSource = "dsReqDtl";
ReportPath = @"~/ReportTemplate/rptDrawWiseSalesReport.rdlc";
break;
default:
dtReport = null;
break;
}
#endregion
rptViewer.Visible = true;
rptViewer.Style.Add("width", "99%");
rptViewer.Height = (Unit)480;
rptViewer.BorderStyle = BorderStyle.Solid;
rptViewer.BorderColor = System.Drawing.Color.Gray;
rptViewer.BorderWidth = (Unit)1;
rptViewer.ShowRefreshButton = false;
rptViewer.ShowFindControls = false;
rptViewer.ShowPrintButton = true;
rptViewer.SizeToReportContent = false;
rptViewer.ShowExportControls = true;
rptViewer.AsyncRendering = true;
rptViewer.Reset();
rptViewer.ProcessingMode = ProcessingMode.Local;
rptViewer.LocalReport.DataSources.Clear();
this.rptViewer.LocalReport.ReportPath = Server.MapPath(ReportPath);
ReportDataSource rds = new ReportDataSource(DataSource, dtReport);
if (ReportName == "WinneListDtlById" && dtReport.Rows.Count > 0)
{
ReportParameter Param0 = new ReportParameter("DrawNo", objValidateData.ToOrdinal(Convert.ToInt16(dtReport.Rows[0]["DrawNo"].ToString())));
ReportParameter Param1 = new ReportParameter("DrawDate", Convert.ToDateTime(dtReport.Rows[0]["DrawDate"]).ToString("dd-MMM-yyyy"));
ReportParameter Param2 = new ReportParameter("LotteryName", dtReport.Rows[0]["LotteryName"].ToString());
rptViewer.LocalReport.SetParameters(new ReportParameter[] { Param0, Param1, Param2 });
}
this.rptViewer.LocalReport.DataSources.Clear();
this.rptViewer.LocalReport.DataSources.Add(rds);
this.rptViewer.DataBind();
this.rptViewer.LocalReport.Refresh();
if (ReportName == "WinneListDtlById" ||
ReportName == "UnSoldSummary" ||
ReportName == "SendToGovAnnextureIII" ||
// ReportName=="VariableClaimPrize" ||
ReportName == "TicketInventoryAdjustment" ||
ReportName == "ProfitLossDtlByReqId"
)
{
byte[] Bytes = this.rptViewer.LocalReport.Render(format: "PDF", deviceInfo: "");
Warning[] warnings;
string[] streamIds;
string mimeType = string.Empty;
string encoding = string.Empty;
string extension = string.Empty;
string ReportFileName = ReportName;
if (ReportName == "WinneListDtlById" || ReportName == "UnSoldSummary" || ReportName == "VariableClaimPrize")
{
ReportFileName = ReportFileName + "_DrNo_" + dtReport.Rows[0]["DrawNo"].ToString() + "_DrDt_" + Convert.ToDateTime(dtReport.Rows[0]["DrawDate"].ToString()).ToString("dd-MMM-yyyy");
}
else if (ReportName == "SendToGovAnnextureIII")
{
ReportFileName = ReportFileName + "_" + dtReport.Rows[0]["SentToGovReqCode"].ToString().Replace('/', '_');
}
//SentToGovReqCode
byte[] bytes = rptViewer.LocalReport.Render("PDF", null, out mimeType, out encoding, out extension, out streamIds, out warnings);
Response.Buffer = true;
Response.Clear();
Response.ContentType = mimeType;
Response.AddHeader("content-disposition", "attachment; filename= " + ReportFileName + ".pdf");
Response.BinaryWrite(bytes); // create the file
Response.Flush();
}
}
catch (Exception Ex)
{
var message = new JavaScriptSerializer().Serialize("Some Error has occurred while performing your activity. Please contact the System Administrator for further assistance.");
var script = string.Format("alert({0});", message);
ScriptManager.RegisterClientScriptBlock(this, GetType(), "", script, true);
}
}
public DataTable GetRequisitionDtl(clsInputParameter objInputParameter)
{
return(objBusinessLogicDbTrx.GetRequisitionDtl(objInputParameter));
}
public DataTable GetClaimSendToGovApprovedDtl(clsInputParameter objInputParameter)
{
return(objBusinessLogicDbTrx.GetClaimSendToGovApprovedDtl(objInputParameter));
}
protected void GvData_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
DataTable dtInfo = new DataTable();
GridViewRow gvrow = (GridViewRow)(((ImageButton)e.CommandSource).NamingContainer);
hdUniqueId.Value = GvData.DataKeys[gvrow.RowIndex].Value.ToString();
// fill the Location information for edit
if (e.CommandName == "EditEntry")
{
objValidateData.ClearAllInputField(pnlDataEntry);
gvPrizeWinnerDetails.DataSource = null;
gvPrizeWinnerDetails.DataBind();
int Status = 0;
// dtInfo = objLtmsService.GetPrizeWinnerDtlById(Convert.ToInt64(hdUniqueId.Value));
dtInfo = objLtmsService.GetRequisitionDtlById(Convert.ToInt64(hdUniqueId.Value));
if (dtInfo.Rows.Count > 0)
{
txtReqCode.Text = dtInfo.Rows[0]["ReqCode"].ToString();
txtReqDate.Text = Convert.ToDateTime(dtInfo.Rows[0]["ReqDate"]).ToString("dd-MMM-yyyy");
txtLotteryType.Text = dtInfo.Rows[0]["LotteryType"].ToString();
txtLottery.Text = dtInfo.Rows[0]["LotteryName"].ToString();
txtDrawDate.Text = Convert.ToDateTime(dtInfo.Rows[0]["DrawDate"]).ToString("dd-MMM-yyyy");
txtDrawNo.Text = dtInfo.Rows[0]["DrawNo"].ToString();
txtClaimDate.Text = Convert.ToDateTime(dtInfo.Rows[0]["DrawDate"]).AddDays(Convert.ToInt16(dtInfo.Rows[0]["ClaimDays"])).ToString("dd-MMM-yyyy");
Status = Convert.ToInt16(dtInfo.Rows[0]["SaveStatus"].ToString());
btnSave.Visible = false;
btnConfirm.Visible = false;
if (Status == 56)
{
btnSave.Visible = true;
}
else if (Status == 61 || Status == 64)
{
btnSave.Visible = true;
btnConfirm.Visible = true;
}
DataTable dtPrizeInfo = objLtmsService.GetWinneEntryDtlByRequisitionId(Convert.ToInt64(hdUniqueId.Value));
if (dtPrizeInfo.Rows.Count > 0)
{
gvPrizeWinnerDetails.DataSource = dtPrizeInfo;
gvPrizeWinnerDetails.DataBind();
}
dtPrizeInfo.Dispose();
DataTable dtPrizeWinnerInfo = objLtmsService.GetWinnePrizeWinningSlNoDtlById(Convert.ToInt64(hdUniqueId.Value), 1);
if (dtPrizeWinnerInfo.Rows.Count > 0)
{
txtJudgesName1.Text = dtPrizeWinnerInfo.Rows[0]["JudgesName1"].ToString();
txtJudgesName2.Text = dtPrizeWinnerInfo.Rows[0]["JudgesName2"].ToString();
txtJudgesName3.Text = dtPrizeWinnerInfo.Rows[0]["JudgesName3"].ToString();
txtPlayingAddress.Text = dtPrizeWinnerInfo.Rows[0]["PlayingAddress"].ToString();
txtDrawTime.Text = dtPrizeWinnerInfo.Rows[0]["DrawTime"].ToString();
}
}
dtInfo.Dispose();
pnlDataEntry.Visible = true;
pnlDataDisplay.Visible = false;
btnSave.Text = "Update";
}
if (e.CommandName == "PrintEntry")
{
clsInputParameter objInputParameter = new clsInputParameter();
objInputParameter.DataUniqueId = Convert.ToInt64(hdUniqueId.Value);
objInputParameter.RequestUrl = Request.QueryString["ID"].Trim();
Session["InputParameter"] = objInputParameter;
Session["ReportName"] = "WinneListDtlById";
Response.Redirect("rptViewAppReport.aspx");
}
dtInfo.Dispose();
}
catch (Exception Ex)
{
objValidateData.SaveSystemErrorLog(Ex, Request.UserHostAddress);
var message = new JavaScriptSerializer().Serialize("Some Error has occurred while performing your activity. Please contact the System Administrator for further assistance.");
var script = string.Format("alert({0});", message);
ScriptManager.RegisterClientScriptBlock(this, GetType(), "", script, true);
}
}
public DataTable GetLotteryClaimEntryDtlByStatus(clsInputParameter objInputParameter, int InClaimType)
{
return(objBusinessLogicDbTrx.GetLotteryClaimEntryDtlByStatus(objInputParameter, InClaimType));
}
public DataTable GetRequisitionDealerDtlByStatus(clsInputParameter objInputParameter)
{
return(objBusinessLogicDbTrx.GetRequisitionDealerDtlByStatus(objInputParameter));
}
public DataTable GetBankGuranteeLedger(clsInputParameter objInputParameter)
{
return(objBusinessLogicDbTrx.GetBankGuranteeLedger(objInputParameter));
}
