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.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"); SaveStatus = Convert.ToInt16(dtInfo.Rows[0]["SaveStatus"].ToString().ToUpper()); btnSave.Visible = false; btnSubmit.Visible = false; gvAvailableInventory.DataSource = dtInfo; gvAvailableInventory.DataBind(); GetDealerDepositInHand(); CalculateBalence(); if (SaveStatus == 17) { btnSave.Visible = true; } if (SaveStatus == 31) { btnSave.Visible = true; btnSubmit.Visible = true; } } dtInfo.Dispose(); pnlDataEntry.Visible = true; pnlDataDisplay.Visible = false; } 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 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.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"); 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(); rwBankGuarantee.Visible = false; txtBankName.Text = ""; txtBankValidityDays.Text = ""; BindClaimGvData(); btnUpload.Visible = true; if (ddlDepositTo.Items.Count > 0) { ddlDepositTo.SelectedIndex = 1; } } pnlDataEntry.Visible = true; pnlDataDisplay.Visible = false; } 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 Page_Load(object sender, EventArgs e) { StringBuilder strTableReport = new StringBuilder(); StringBuilder strReport = new StringBuilder(); DataTable dtTicketInfo = new DataTable(); if (Session["InputParameter"].ToString().Trim() != "") { dtTicketInfo = objLtmsService.GetRequisitionDtlById(Convert.ToInt64(Session["InputParameter"])); if (dtTicketInfo.Rows.Count > 0) { strTableReport.AppendLine("<table border='1' >"); for (Int32 tktCnt = 0; tktCnt < dtTicketInfo.Rows.Count; tktCnt++) { strReport.AppendLine(" <tr>"); strReport.AppendLine(" <td>" + dtTicketInfo.Rows[tktCnt]["TicketNumber"].ToString() + "</td>"); strReport.AppendLine(" </tr>"); } strTableReport.AppendLine(strReport.ToString()); strTableReport.AppendLine("</table>"); Response.Clear(); Response.Buffer = true; Response.ContentType = "application/vnd.ms-excel"; String FileName = "LotteryTicket" + DateTime.Now.Year.ToString() + "_" + DateTime.Now.ToString("dd-MMM-yyyy") + ".xls"; Response.AddHeader("Content-Disposition", "inline;filename=" + FileName); String HTMLDataToExport = strTableReport.ToString(); Response.Write("<html><head><head>" + HTMLDataToExport.Replace("<BR>", "<br style='mso-data-placement:same-cell;'>") .Replace("<br>", "<br style='mso-data-placement:same-cell;'>") .Replace("<BR >", "<br style='mso-data-placement:same-cell;'>") .Replace("<BR />", "<br style='mso-data-placement:same-cell;'>") .Replace("<br />", "<br style='mso-data-placement:same-cell;'>") .Replace("<Br />", "<br style='mso-data-placement:same-cell;'>") .Replace("<Br>", "<br style='mso-data-placement:same-cell;'>") .Replace("<br >", "<br style='mso-data-placement:same-cell;'>") + "</html>"); Response.End(); } } }
protected void btnAddNew_Click(object sender, EventArgs e) { DataTable dtInfo = new DataTable(); objValidateData.ClearAllInputField(pnlDataEntry); 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"); 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(); } dtInfo.Dispose(); pnlDataEntry.Visible = true; dvChallanDtl.Visible = false; pnlDataDisplay.Visible = false; }
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.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"); 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(); SaveStatus = Convert.ToInt16(dtInfo.Rows[0]["SaveStatus"].ToString().ToUpper()); btnConfirm.Visible = true; double TotAmount = 0; DataTable dtReqTransaction = objLtmsService.GetAdjustmentDtlByRequisitionId(Convert.ToInt32(hdUniqueId.Value)); if (dtReqTransaction.Rows.Count > 0) { GvTransaction.DataSource = dtReqTransaction; GvTransaction.DataBind(); } CalculateRemainingBalence(); btnConfirm.Visible = true; if (SaveStatus == 1000) { btnConfirm.Visible = false; } } 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"] = "TicketInventoryAdjustment"; 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 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.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"); SaveStatus = Convert.ToInt16(dtInfo.Rows[0]["SaveStatus"].ToString()); txtDrawNo.Text = dtInfo.Rows[0]["DrawNo"].ToString(); txtDrawDate.Text = Convert.ToDateTime(dtInfo.Rows[0]["DrawDate"]).ToString("dd-MMM-yyyy"); ddlLotteryType.SelectedValue = dtInfo.Rows[0]["LotteryTypeId"].ToString(); ddlLotteryType_SelectedIndexChanged(ddlLotteryType, null); ddlLotteryName.SelectedValue = dtInfo.Rows[0]["GovermentOrderId"].ToString(); txtGovermentOrder.Text = dtInfo.Rows[0]["GovermentOrder"].ToString(); txtQty.Text = dtInfo.Rows[0]["Qty"].ToString(); txtFnStart.Text = dtInfo.Rows[0]["FnStart"].ToString(); txtFnEnd.Text = dtInfo.Rows[0]["FnEnd"].ToString(); txtSlabLimit.Text = dtInfo.Rows[0]["SlabLimit"].ToString(); //AlphabetSeries string AlphabetSeries = dtInfo.Rows[0]["AlphabetSeries"].ToString(); string[] values = AlphabetSeries.Split(','); for (int iCnt = 0; iCnt < values.Length; iCnt++) { for (int jCnt = 0; jCnt < chkLstAlphabetSeries.Items.Count; jCnt++) { if (chkLstAlphabetSeries.Items[jCnt].Text == values[iCnt].Trim()) { chkLstAlphabetSeries.Items[jCnt].Selected = true; } } } txtTnStart.Text = dtInfo.Rows[0]["TnStart"].ToString(); txtTnEnd.Text = dtInfo.Rows[0]["TnEnd"].ToString(); btnSave.Visible = false; btnConfirm.Visible = false; btnPrinted.Visible = false; if (SaveStatus < 16) { btnSave.Visible = true; foreach (System.Web.UI.Control ctrl in pnlDataEntry.Controls) { if (ctrl is TextBox) { ((TextBox)ctrl).ReadOnly = false; } else if (ctrl is DropDownList) { ((DropDownList)ctrl).Enabled = true; } else if (ctrl is CheckBoxList) { ((CheckBoxList)ctrl).Enabled = true; } } } if (SaveStatus == 11) { btnConfirm.Visible = true; } if (SaveStatus >= 16) { foreach (System.Web.UI.Control ctrl in pnlDataEntry.Controls) { if (ctrl is TextBox) { ((TextBox)ctrl).ReadOnly = true; } else if (ctrl is DropDownList) { ((DropDownList)ctrl).Enabled = false; } else if (ctrl is CheckBoxList) { ((CheckBoxList)ctrl).Enabled = false; } } btnPrinted.Visible = true; } } txtReqCode.ReadOnly = true; txtReqDate.ReadOnly = true; txtDrawNo.ReadOnly = true; txtDrawDate.ReadOnly = true; txtGovermentOrder.ReadOnly = true; txtQty.ReadOnly = true; ddlLotteryType.Enabled = false; ddlLotteryName.Enabled = false; dtInfo.Dispose(); pnlDataEntry.Visible = true; pnlDataDisplay.Visible = false; btnSave.Text = "Update"; } 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 Page_Load(object sender, EventArgs e) { try { if (!String.IsNullOrEmpty(Request.QueryString["JB"])) { string QueryString = Request.QueryString["JB"]; string LotteryNo = "", ReqId = "", ErrorMsg = "", RQDate = "", GenCheckDigit = ""; string UID = string.Empty; long uidl = default(long); int startIndex = QueryString.IndexOf("X_") + "X_".Length; int endIndex = QueryString.IndexOf("-"); LotteryNo = QueryString.Substring(startIndex, endIndex - startIndex); UID = !string.IsNullOrWhiteSpace(QueryString) ? (QueryString.Split('_').LastOrDefault() != null ? QueryString.Split('_').LastOrDefault() : default(long).ToString()) : default(long).ToString(); startIndex = QueryString.IndexOf("R_") + "R_".Length; endIndex = QueryString.IndexOf("~"); ReqId = QueryString.Substring(startIndex, endIndex - startIndex); startIndex = QueryString.IndexOf("M_") + "M_".Length; endIndex = QueryString.IndexOf(":"); RQDate = QueryString.Substring(startIndex, endIndex - startIndex); startIndex = QueryString.IndexOf("S_") + "S_".Length; endIndex = QueryString.IndexOf("!"); GenCheckDigit = QueryString.Substring(startIndex, endIndex - startIndex); CheckDigitCalculation objCheckDigitCalculation = new CheckDigitCalculation(); string CheckDigit = string.Empty; try { CheckDigit = objCheckDigitCalculation.GenCheckDigit(ReqId + RQDate + LotteryNo); } catch (Exception) { lblMessage.Text = " <font color='red'>Incorrect QR code</font>";; return; } if (CheckDigit != GenCheckDigit) { lblMessage.Text = " <font color='red'>" + LotteryNo + " Is Not Valid Ticket No</font>";; return; } objValidateData.ClearAllInputField(pnlDataEntry); ClsTicketInventory objGeneratedNo = new ClsTicketInventory(); DataTable dtLotteryInfo = new DataTable(); dtLotteryInfo = objLtmsService.GetRequisitionDtlById(Convert.ToInt32(ReqId)); long sr1End = default(long); try { long.TryParse(dtLotteryInfo.Rows[0]["FnEnd"].ToString(), out sr1End); } catch (Exception) { } DataTable newMultiTableData = objLtmsService.GetSeriesGenerationByReqIdAndSr1End(Convert.ToInt32(ReqId), sr1End); long.TryParse(UID, out uidl); DataTable newTableData = new DataTable(); if (uidl > default(long)) { newTableData = objLtmsService.GetSeriesGenerationByReqIdSpecific(Convert.ToInt32(ReqId), uidl); } else { newTableData = objLtmsService.GetSeriesGenerationByReqId(Convert.ToInt32(ReqId)); } if (dtLotteryInfo.Rows.Count > 0) { objGeneratedNo.DataUniqueId = Convert.ToInt64(dtLotteryInfo.Rows[0]["DataUniqueId"].ToString()); objGeneratedNo.DrawNo = Convert.ToInt16(dtLotteryInfo.Rows[0]["DrawNo"].ToString()); objGeneratedNo.DrawDate = Convert.ToDateTime(dtLotteryInfo.Rows[0]["DrawDate"].ToString()); objGeneratedNo.AlphabetSeries = dtLotteryInfo.Rows[0]["AlphabetSeries"].ToString(); if (newTableData.Rows.Count > default(int)) { objGeneratedNo.FnStart = Convert.ToInt16(newTableData.Rows[0]["Series1Start"].ToString()); objGeneratedNo.FnEnd = Convert.ToInt16(newTableData.Rows[0]["Series1End"].ToString()); objGeneratedNo.TnStart = Convert.ToInt64(newTableData.Rows[0]["NumStart"].ToString()); objGeneratedNo.TnEnd = Convert.ToInt64(newTableData.Rows[0]["NumEnd"].ToString()); } else { objGeneratedNo.FnStart = Convert.ToInt16(dtLotteryInfo.Rows[0]["FnStart"].ToString()); objGeneratedNo.FnEnd = Convert.ToInt16(dtLotteryInfo.Rows[0]["FnEnd"].ToString()); objGeneratedNo.TnStart = Convert.ToInt64(dtLotteryInfo.Rows[0]["TnStart"].ToString()); objGeneratedNo.TnEnd = Convert.ToInt64(dtLotteryInfo.Rows[0]["TnEnd"].ToString()); } ErrorMsg = objValidateData.ValidateTicketNo(objGeneratedNo, LotteryNo, newMultiTableData); if (ErrorMsg.Trim().Length > 0) { lblMessage.Text = " <font color='red'>" + LotteryNo + " Is Not Valid Ticket No</font>";; } else { txtLotteryType.Text = dtLotteryInfo.Rows[0]["LotteryType"].ToString(); txtLotteryName.Text = !string.IsNullOrWhiteSpace(dtLotteryInfo.Rows[0]["ModifiedLotteryName"].ToString()) ? dtLotteryInfo.Rows[0]["ModifiedLotteryName"].ToString() : dtLotteryInfo.Rows[0]["LotteryName"].ToString(); txtDrawNo.Text = dtLotteryInfo.Rows[0]["DrawNo"].ToString(); txtDrawDate.Text = Convert.ToDateTime(dtLotteryInfo.Rows[0]["DrawDate"]).ToString("dd-MMM-yyyy"); txtLotteryNo.Text = LotteryNo; lblMessage.Text = " <font color='green'>" + LotteryNo + " Is Valid Ticket No</font>";; } } } } catch (Exception ex) { lblMessage.Text = "Some Error occured. Please contact system administrator.";; } }
//Checking for valid data entry private bool IsValidEntry(DataTable dtExcelData, Int64 DatauNiqueId) { string ErrorMsg = ""; Int32 TotError = 0; StringBuilder strMsg = new StringBuilder(); ClsTicketInventory objGeneratedNo = new ClsTicketInventory(); DataTable dtLotteryInfo = new DataTable(); dtLotteryInfo = objLtmsService.GetRequisitionDtlById(DatauNiqueId); if (dtLotteryInfo.Rows.Count > 0) { objGeneratedNo.DataUniqueId = Convert.ToInt64(dtLotteryInfo.Rows[0]["DataUniqueId"].ToString()); objGeneratedNo.DrawNo = Convert.ToInt16(dtLotteryInfo.Rows[0]["DrawNo"].ToString()); objGeneratedNo.DrawDate = Convert.ToDateTime(dtLotteryInfo.Rows[0]["DrawDate"].ToString()); objGeneratedNo.FnStart = Convert.ToInt16(dtLotteryInfo.Rows[0]["FnStart"].ToString()); objGeneratedNo.FnEnd = Convert.ToInt16(dtLotteryInfo.Rows[0]["FnEnd"].ToString()); objGeneratedNo.AlphabetSeries = dtLotteryInfo.Rows[0]["AlphabetSeries"].ToString(); objGeneratedNo.TnStart = Convert.ToInt64(dtLotteryInfo.Rows[0]["TnStart"].ToString()); objGeneratedNo.TnEnd = Convert.ToInt64(dtLotteryInfo.Rows[0]["TnEnd"].ToString()); for (Int16 colCnt = 0; colCnt < dtExcelData.Columns.Count; colCnt++) { ErrorMsg = objValidateData.ValidateTicketNo(objGeneratedNo, dtExcelData.Columns[colCnt].ToString()); if (ErrorMsg.Trim().Length > 0) { TotError++; strMsg.AppendLine("Column " + (colCnt + 1) + " and Row No 1:" + ErrorMsg); } for (Int32 iCnt = 0; iCnt < dtExcelData.Rows.Count; iCnt++) { ErrorMsg = objValidateData.ValidateTicketNo(objGeneratedNo, dtExcelData.Rows[iCnt][colCnt].ToString()); if (ErrorMsg.Trim().Length > 0) { TotError++; if (TotError <= 10) { strMsg.AppendLine("Column " + (colCnt + 1) + " and Row No " + (iCnt + 1) + ": " + ErrorMsg); } if (TotError > 10) { break; } ; } } } } if (strMsg.ToString().Trim().Length > 0) { if (TotError > 10) { ErrorMsg = "There are more than 10 Error in the file first 10 error are as below " + strMsg.ToString(); } else { ErrorMsg = "There are " + TotError + " Error in the file as below " + strMsg.ToString(); } var message = new JavaScriptSerializer().Serialize(ErrorMsg); var script = string.Format("alert({0});", message); ScriptManager.RegisterClientScriptBlock(this, GetType(), "", script, true); return(false); } if (objValidateData.IsIntegerWithZero(txtDrawNo.Text.Trim()) == false) { ScriptManager.RegisterStartupScript(this, GetType(), "MyMsg", "alert('Draw No number should be numeric.');", true); txtDrawNo.Focus(); return(false); } if (objValidateData.isValidDate(txtDrawDate.Text.Trim()) == false) { ScriptManager.RegisterStartupScript(this, GetType(), "MyMsg", "alert('Please enter valid draw date');", true); txtDrawDate.Focus(); return(false); } return(true); }
protected void btnSave_Click(object sender, EventArgs e) { try { string ReqId = ""; string Status = ""; DataTable dtInfo = new DataTable(); if (IsValidEntry() == false) { return; } foreach (GridViewRow row in GvData.Rows) { CheckBox check = row.FindControl("chkSelect") as CheckBox; if (check.Checked) { ReqId = ReqId + GvData.DataKeys[row.RowIndex].Value.ToString() + ","; } } ReqId = ReqId.TrimEnd(','); if (((Button)sender).CommandName == "Approve") { Status = "Approved"; objRequisition.SaveStatus = 63; objRequisition.UploadStatus = 2; } else if (((Button)sender).CommandName == "Reject") { Status = "Rejected"; objRequisition.SaveStatus = 64; objRequisition.UploadStatus = 3; } DataTable dtTicket = new DataTable(); dtTicket.TableName = "dtTicket"; dtTicket.Columns.Add(new DataColumn("RequisitionId", typeof(Int64))); dtTicket.Columns.Add(new DataColumn("RowNo", typeof(string))); dtTicket.Columns.Add(new DataColumn("ClaimCount", typeof(string))); dtTicket.Columns.Add(new DataColumn("UnsoldCount", typeof(string))); dtTicket.Columns.Add(new DataColumn("DataCount", typeof(Int32))); dtTicket.Columns.Add(new DataColumn("WiningSerialNo", typeof(string))); dtTicket.Columns.Add(new DataColumn("Amount", typeof(double))); dtTicket.Columns.Add(new DataColumn("Remarks", typeof(string))); DataRow dtRw = null; Int64 ClaimCount = 0, UnsoldCount = 0, FinalClaimCnt = 0; foreach (GridViewRow row in GvData.Rows) { CheckBox check = row.FindControl("chkSelect") as CheckBox; if (check.Checked) { Int64 DataUniqueId = Convert.ToInt64(GvData.DataKeys[row.RowIndex].Value); DataTable dtRequisitionId = objLtmsService.GetRequisitionDtlById(DataUniqueId); if (dtRequisitionId.Rows.Count > 0) { DataSet dsPrizeInfo = objLtmsService.GetWinnigSlNoDtlByRequisitionId(DataUniqueId); DataTable dtUnsold = objLtmsService.GetUnSoldSummaryById(DataUniqueId); if (dsPrizeInfo.Tables[0].Rows.Count > 0) { for (int iRow = 0; iRow < dsPrizeInfo.Tables[0].Rows.Count; iRow++) { ClaimCount = GetVariableTicketCount(DataUniqueId, dsPrizeInfo.Tables[0].Rows[iRow]["WiningSerialNo"].ToString(), ref dtRequisitionId); UnsoldCount = 0; if (dsPrizeInfo.Tables[0].Rows[iRow]["ValidationForUnsold"].ToString().ToUpper() == "Y") { UnsoldCount = GetUnsoldTicketCount(dsPrizeInfo.Tables[0].Rows[iRow]["WiningSerialNo"].ToString(), ref dtUnsold); } if (ClaimCount > 0) { FinalClaimCnt = ClaimCount - UnsoldCount; } else { FinalClaimCnt = 0; } if (FinalClaimCnt > 0) { dtRw = dtTicket.NewRow(); dtRw["RequisitionId"] = dsPrizeInfo.Tables[0].Rows[iRow]["RequisitionId"].ToString(); dtRw["RowNo"] = dsPrizeInfo.Tables[0].Rows[iRow]["RowNo"].ToString(); dtRw["ClaimCount"] = ClaimCount.ToString(); dtRw["UnsoldCount"] = UnsoldCount.ToString(); dtRw["DataCount"] = FinalClaimCnt.ToString(); dtRw["WiningSerialNo"] = dsPrizeInfo.Tables[0].Rows[iRow]["WiningSerialNo"].ToString(); dtRw["Amount"] = (FinalClaimCnt * Convert.ToDouble(dsPrizeInfo.Tables[0].Rows[iRow]["PayableToSuperTicketWinner"])).ToString(); dtRw["Remarks"] = "SUPER"; dtTicket.Rows.Add(dtRw); dtRw = dtTicket.NewRow(); dtRw["RequisitionId"] = dsPrizeInfo.Tables[0].Rows[iRow]["RequisitionId"].ToString(); dtRw["RowNo"] = dsPrizeInfo.Tables[0].Rows[iRow]["RowNo"].ToString(); dtRw["ClaimCount"] = ClaimCount.ToString(); dtRw["UnsoldCount"] = UnsoldCount.ToString(); dtRw["DataCount"] = FinalClaimCnt.ToString(); dtRw["WiningSerialNo"] = dsPrizeInfo.Tables[0].Rows[iRow]["WiningSerialNo"].ToString(); dtRw["Amount"] = (FinalClaimCnt * Convert.ToDouble(dsPrizeInfo.Tables[0].Rows[iRow]["PayableToSpecialTicketWinner"])).ToString(); dtRw["Remarks"] = "SPECIAL"; dtTicket.Rows.Add(dtRw); } } } } } } objRequisition.UserId = ((ClsUserInfo)Session["UserInfo"]).UserId; objRequisition.IpAdd = Request.UserHostAddress; bool IsUpdated = objLtmsService.UpdateApprovalInVariableClaim(objRequisition, ReqId, dtTicket); if (IsUpdated == true) { ScriptManager.RegisterStartupScript(this, GetType(), "MyMsg", "alert('Selected information " + Status + " successfully.');", true); } BindGvData(); //btnCancel_Click(sender, e); } 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 { 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.GetRequisitionDtlById(Convert.ToInt64(hdUniqueId.Value)); if (dtInfo.Rows.Count > 0) { SaveStatus = Convert.ToInt16(dtInfo.Rows[0]["SaveStatus"].ToString().ToUpper()); txtReqCode.Text = dtInfo.Rows[0]["ReqCode"].ToString(); txtReqDate.Text = Convert.ToDateTime(dtInfo.Rows[0]["ReqDate"]).ToString("dd-MMM-yyyy"); txtDrawDate.Text = Convert.ToDateTime(dtInfo.Rows[0]["DrawDate"]).ToString("dd-MMM-yyyy"); txtDelivaryDate.Text = Convert.ToDateTime(dtInfo.Rows[0]["PressDeliveryDate"]).ToString("dd-MMM-yyyy"); ddlLotteryType.SelectedValue = dtInfo.Rows[0]["LotteryTypeId"].ToString(); txtQty.MaxLength = Convert.ToInt16(dtInfo.Rows[0]["NoOfDigit"].ToString()); ddlLotteryType_SelectedIndexChanged(ddlLotteryType, null); if (ddlLotteryName.Items.Count > 0) { txtSizeOfTicket.Text = dtInfo.Rows[0]["SizeOfTicket"].ToString(); txtPaperQuality.Text = dtInfo.Rows[0]["PaperQuality"].ToString(); ddlLotteryName.SelectedValue = dtInfo.Rows[0]["GovermentOrderId"].ToString(); if (SaveStatus == 0) { ddlLotteryName_SelectedIndexChanged(ddlLotteryName, null); } } ddlLotteryType.Enabled = false; ddlLotteryName.Enabled = false; txtDrawNo.ReadOnly = true; txtDrawNo.Text = dtInfo.Rows[0]["DrawNo"].ToString(); txtQty.Text = dtInfo.Rows[0]["Qty"].ToString(); txtGovermentOrder.Text = dtInfo.Rows[0]["GovermentOrder"].ToString(); txtSlabLimit.Text = dtInfo.Rows[0]["SlabLimit"].ToString(); btnSave.Visible = true; btnSubmit.Visible = true; if (SaveStatus == 1 || SaveStatus == 2 || SaveStatus == 4 || SaveStatus == 6 || SaveStatus > 7) { btnSave.Visible = false; btnSubmit.Visible = false; } } dtInfo.Dispose(); pnlDataEntry.Visible = true; pnlDataDisplay.Visible = false; btnSave.Text = "Update"; // lblSubHead.Text = "Update Location Information"; ddlLotteryType.Focus(); } //Delete the location information if (e.CommandName == "DeleteEntry") { if (objMenuOptions.AllowDelete == false) { ScriptManager.RegisterStartupScript(this, GetType(), "MyMsg", "alert('You do not have proper privilege for deleting a record.');", true); return; } bool isDeleted = objLtmsService.DeleteInRequisition(Convert.ToInt64(hdUniqueId.Value)); if (isDeleted == true) { ScriptManager.RegisterStartupScript(this, GetType(), "MyMsg", "alert('Requisition information deleted.');", true); BindGvData(); } } 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 Page_Load(object sender, EventArgs e) { string QRUrl = System.Web.Configuration.WebConfigurationManager.AppSettings["QRUrl"].ToString() + "?JB="; StringBuilder strReport = new StringBuilder(); StringBuilder strTableReport = new StringBuilder(); ClsTicketGenRequest objClsTicketGenRequest = new ClsTicketGenRequest(); objClsTicketGenRequest = (ClsTicketGenRequest)Session["TicketGenRequest"]; ClsTicketInventory objGeneratedNo = new ClsTicketInventory(); DataTable dtInfo = objLtmsService.GetRequisitionDtlById(objClsTicketGenRequest.DataUniqueId); if (dtInfo.Rows.Count > 0) { objGeneratedNo.DataUniqueId = Convert.ToInt64(dtInfo.Rows[0]["DataUniqueId"].ToString()); objGeneratedNo.ReqDate = Convert.ToDateTime(dtInfo.Rows[0]["ReqDate"].ToString()); objGeneratedNo.DrawNo = Convert.ToInt16(dtInfo.Rows[0]["DrawNo"].ToString()); objGeneratedNo.DrawDate = Convert.ToDateTime(dtInfo.Rows[0]["DrawDate"].ToString()); /*objGeneratedNo.FnStart = Convert.ToInt16(dtInfo.Rows[0]["FnStart"].ToString()); * objGeneratedNo.FnEnd = Convert.ToInt16(dtInfo.Rows[0]["FnEnd"].ToString()); * objGeneratedNo.AlphabetSeries = dtInfo.Rows[0]["AlphabetSeries"].ToString(); * objGeneratedNo.TnStart = Convert.ToInt64(dtInfo.Rows[0]["TnStart"].ToString()); * objGeneratedNo.TnEnd = Convert.ToInt64(dtInfo.Rows[0]["TnEnd"].ToString());*/ objGeneratedNo.ID = objClsTicketGenRequest.ID; objGeneratedNo.FnStart = objClsTicketGenRequest.FnStart; objGeneratedNo.FnEnd = objClsTicketGenRequest.FnEnd; objGeneratedNo.AlphabetSeries = objClsTicketGenRequest.AlphabetSeries; objGeneratedNo.TnStart = objClsTicketGenRequest.TnStart; objGeneratedNo.TnEnd = objClsTicketGenRequest.TnEnd; objGeneratedNo.ReqCode = dtInfo.Rows[0]["ReqCode"].ToString(); objGeneratedNo.StrReqDate = objGeneratedNo.ReqDate.Minute.ToString(); Int64 FnStartRange = objClsTicketGenRequest.TnStart; Int64 FnEndRange = objClsTicketGenRequest.TnEnd; //string FileName = objClsTicketGenRequest.RowNo.ToString()+ "_DR" + objGeneratedNo.DrawNo + "_" + Convert.ToDateTime(objGeneratedNo.DrawDate).ToString("ddMMMyyyy").ToUpper() + "_" + objGeneratedNo.ReqCode.Replace("/", "") + "_" + FnStartRange.ToString() + "_" + FnEndRange.ToString() + ".xls"; //string FileName = objClsTicketGenRequest.RowNo.ToString() + "_DR" + objGeneratedNo.DrawNo + "_" + Convert.ToDateTime(objGeneratedNo.DrawDate).ToString("ddMMMyyyy").ToUpper() + "_" + objGeneratedNo.ReqCode.Replace("/", "") + "_" + FnStartRange.ToString() + "_" + FnEndRange.ToString() + ".csv"; string FileName = objClsTicketGenRequest.RowNo.ToString() + "_DR" + objGeneratedNo.DrawNo + "_" + Convert.ToDateTime(objGeneratedNo.DrawDate).ToString("ddMMMyyyy").ToUpper() + "_" + objGeneratedNo.ReqCode.Replace("/", "") + "_" + FnStartRange.ToString() + "_" + FnEndRange.ToString() + ".xlsx"; int FnStart = objGeneratedNo.FnStart; int FnEnd = objGeneratedNo.FnEnd; string AlphabetSeries = objGeneratedNo.AlphabetSeries; string[] values = AlphabetSeries.Split(','); Int64 TnStart = objGeneratedNo.TnStart; bool IsStartNoRequire = false; Int64 TnEnd = objGeneratedNo.TnEnd; FnEnd = ((objGeneratedNo.FnStart == 0 && objGeneratedNo.FnEnd == 0) ? 1 : objGeneratedNo.FnEnd); FnStart = ((objGeneratedNo.FnStart == 0 && objGeneratedNo.FnEnd == 0) ? 1 : objGeneratedNo.FnStart); IsStartNoRequire = ((objGeneratedNo.FnStart == 0 && objGeneratedNo.FnEnd == 0) ? false : true); string AlphabetChar = "", LotteryNumber = ""; /*for (int sCnt = FnStart; sCnt <= FnEnd; sCnt++) * { * for (Int64 eCnt = FnEndRange; eCnt >= FnStartRange; eCnt--) * { * for (int aCnt =values.Length-1; aCnt >= 0; aCnt--) * { * AlphabetChar = values[aCnt].ToString().Trim(); * * strReport.AppendLine("<tr>"); * //LotteryNumber =(IsStartNoRequire==true? sCnt.ToString().PadLeft(FnEnd.ToString().Length,'0') :"") + AlphabetChar + eCnt.ToString().PadLeft(TnEnd.ToString().Length,'0'); * LotteryNumber = (IsStartNoRequire == true ? sCnt.ToString().PadLeft(FnEnd.ToString().Length, '0') : "") + AlphabetChar + eCnt.ToString().PadLeft(Convert.ToInt32(System.Configuration.ConfigurationManager.AppSettings["PadLeftCharCount"]), '0'); * strReport.AppendLine(" <td>" + LotteryNumber + "</td>"); * strReport.AppendLine(" <td>" + QRUrl + GenQRNo(objGeneratedNo, LotteryNumber) +"</td>"); * strReport.AppendLine("</tr>"); * } * } * }*/ DataTable dt = new DataTable(); dt.TableName = "dt"; dt.Columns.Add(new DataColumn("LotteryNumber", typeof(string))); dt.Columns.Add(new DataColumn("QRUrl", typeof(string))); DataRow dtRw = null; //StringBuilder builder = new StringBuilder(); //List<string> columnNames = new List<string>(); //List<string> rows = new List<string>(); //columnNames.Add("\"LotteryNumber\""); //columnNames.Add("\"QRUrl\""); //builder.Append(string.Join(",", columnNames.ToArray())).Append("\n"); for (Int64 eCnt = FnEndRange; eCnt >= FnStartRange; eCnt--) { //for (int sCnt = FnStart; sCnt <= FnEnd; sCnt++) for (int sCnt = FnEnd; sCnt >= FnStart; sCnt--) { for (int aCnt = values.Length - 1; aCnt >= 0; aCnt--) { AlphabetChar = values[aCnt].ToString().Trim(); /*strReport.AppendLine("<tr>"); * //LotteryNumber =(IsStartNoRequire==true? sCnt.ToString().PadLeft(FnEnd.ToString().Length,'0') :"") + AlphabetChar + eCnt.ToString().PadLeft(TnEnd.ToString().Length,'0'); * LotteryNumber = (IsStartNoRequire == true ? sCnt.ToString().PadLeft(FnEnd.ToString().Length, '0') : "") + AlphabetChar + eCnt.ToString().PadLeft(Convert.ToInt32(System.Configuration.ConfigurationManager.AppSettings["PadLeftCharCount"]), '0'); * //strReport.AppendLine(" <td>'" + LotteryNumber + "</td>"); * strReport.AppendLine(" <td>" + LotteryNumber + "</td>"); * strReport.AppendLine(" <td>" + QRUrl + GenQRNo(objGeneratedNo, LotteryNumber) + "</td>"); * strReport.AppendLine("</tr>");*/ dtRw = dt.NewRow(); LotteryNumber = (IsStartNoRequire == true ? sCnt.ToString().PadLeft(FnEnd.ToString().Length, '0') : "") + AlphabetChar + eCnt.ToString().PadLeft(Convert.ToInt32(System.Configuration.ConfigurationManager.AppSettings["PadLeftCharCount"]), '0'); dtRw["LotteryNumber"] = LotteryNumber; dtRw["QRUrl"] = QRUrl + GenQRNo(objGeneratedNo, LotteryNumber); dt.Rows.Add(dtRw); //List<string> currentRow = new List<string>(); //LotteryNumber = (IsStartNoRequire == true ? sCnt.ToString().PadLeft(FnEnd.ToString().Length, '0') : "") + AlphabetChar + eCnt.ToString().PadLeft(Convert.ToInt32(System.Configuration.ConfigurationManager.AppSettings["PadLeftCharCount"]), '0'); //currentRow.Add("\"" + LotteryNumber + "\""); //currentRow.Add("\"" + QRUrl + GenQRNo(objGeneratedNo, LotteryNumber) + "\""); //rows.Add(string.Join(",", currentRow.ToArray())); } } } dt.AcceptChanges(); //builder.Append(string.Join("\n", rows.ToArray())); /*strTableReport.AppendLine("<table border='1' >"); * strTableReport.AppendLine(" " + strReport.ToString()); * strTableReport.AppendLine("</table>");*/ Response.Clear(); Response.Buffer = true; //Response.ContentType = "application/vnd.ms-excel"; Response.ContentType = "application/application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; Response.AddHeader("Content-Disposition", "inline;filename=" + FileName); //Response.ContentType = "text/csv"; //Response.AddHeader("Content-Disposition", "attachment;filename=" + FileName); //Response.Write(builder.ToString()); //String HTMLDataToExport = strTableReport.ToString(); /*Response.Write("<html><head><head>" + * HTMLDataToExport.Replace("<BR>", "<br style='mso-data-placement:same-cell;'>") * .Replace("<br>", "<br style='mso-data-placement:same-cell;'>") * .Replace("<BR >", "<br style='mso-data-placement:same-cell;'>") * .Replace("<BR />", "<br style='mso-data-placement:same-cell;'>") * .Replace("<br />", "<br style='mso-data-placement:same-cell;'>") * .Replace("<Br />", "<br style='mso-data-placement:same-cell;'>") * .Replace("<Br>", "<br style='mso-data-placement:same-cell;'>") * .Replace("<br >", "<br style='mso-data-placement:same-cell;'>") + "</html>");*/ Response.BinaryWrite(GenerateExcel2007(dt)); Response.End(); } }
//Checking for valid data entry private bool IsValidEntry(DataTable dtExcelData, Int64 DatauNiqueId, ref DataTable dtTicketNumber) { string ErrorMsg = ""; Int32 TotError = 0; Int64 WinnerId = 0; //Int32 NoOfRecordSToBeUpload = 60; bool ValidationForUnsold = false; int errorCntForTkt = 0; StringBuilder strMsg = new StringBuilder(); ClsTicketInventory objGeneratedNo = new ClsTicketInventory(); DataTable dtLotteryInfo = new DataTable(); DataTable distinctTable = dtExcelData.DefaultView.ToTable(true); if (dtExcelData.Rows.Count != distinctTable.Rows.Count) { ScriptManager.RegisterStartupScript(this, GetType(), "MyMsg", "alert('Upload can not be complited.Duplicate Ticket No exist in file.');", true); return(false); } distinctTable.Clear(); distinctTable = null; DataRow dr = null; dtLotteryInfo = objLtmsService.GetRequisitionDtlById(DatauNiqueId); if (dtLotteryInfo.Rows.Count > 0) { objGeneratedNo.DataUniqueId = Convert.ToInt64(dtLotteryInfo.Rows[0]["DataUniqueId"].ToString()); objGeneratedNo.DrawNo = Convert.ToInt16(dtLotteryInfo.Rows[0]["DrawNo"].ToString()); objGeneratedNo.DrawDate = Convert.ToDateTime(dtLotteryInfo.Rows[0]["DrawDate"].ToString()); objGeneratedNo.FnStart = Convert.ToInt16(dtLotteryInfo.Rows[0]["FnStart"].ToString()); objGeneratedNo.FnEnd = Convert.ToInt16(dtLotteryInfo.Rows[0]["FnEnd"].ToString()); objGeneratedNo.AlphabetSeries = dtLotteryInfo.Rows[0]["AlphabetSeries"].ToString(); objGeneratedNo.TnStart = Convert.ToInt64(dtLotteryInfo.Rows[0]["TnStart"].ToString()); objGeneratedNo.TnEnd = Convert.ToInt64(dtLotteryInfo.Rows[0]["TnEnd"].ToString()); DataSet dtLotteryWiningSerialNoDtl = objLtmsService.GetLotteryWiningSerialNoDtlByLotteryNo(objGeneratedNo.DataUniqueId, ""); for (Int16 colCnt = 0; colCnt < dtExcelData.Columns.Count; colCnt++) { if (dtExcelData.Columns[colCnt].ToString().Trim().Length > 0) { errorCntForTkt = 0; WinnerId = 0; bool isValidTicketNo = true, IsCommonToAllSeries = false, isPartialTicket = false; ErrorMsg = objValidateData.ValidateTicketNo(objGeneratedNo, dtExcelData.Columns[colCnt].ToString()); if (ErrorMsg.Trim().Length > 0) { errorCntForTkt++; TotError++; strMsg.AppendLine("Column " + (colCnt + 1) + " and Row No 1:" + ErrorMsg); isValidTicketNo = false; } if (isValidTicketNo == true) { for (int rwCnt = 0; rwCnt < dtLotteryWiningSerialNoDtl.Tables[1].Rows.Count; rwCnt++) { if (dtExcelData.Columns[colCnt].ToString().ToUpper() == dtLotteryWiningSerialNoDtl.Tables[1].Rows[rwCnt]["WiningSerialNo"].ToString().ToUpper()) { IsCommonToAllSeries = true; } if (dtExcelData.Columns[colCnt].ToString().ToUpper().EndsWith(dtLotteryWiningSerialNoDtl.Tables[1].Rows[rwCnt]["WiningSerialNo"].ToString()) == true) { isPartialTicket = true; WinnerId = Convert.ToInt64(dtLotteryWiningSerialNoDtl.Tables[1].Rows[rwCnt]["WinnerId"].ToString()); ValidationForUnsold = (dtLotteryWiningSerialNoDtl.Tables[1].Rows[rwCnt]["ValidationForUnsold"].ToString().ToUpper() == "Y"?true:false); if (ValidationForUnsold == true) { int FnNo = 0; string Alphabet = ""; Int64 TnNo = 0; string AlphabetSeries = objGeneratedNo.AlphabetSeries; string[] values = AlphabetSeries.Split(','); int AlphabetLen = Convert.ToInt16(values[values.Length - 1].ToString().Length); FnNo = Convert.ToInt16(((objGeneratedNo.FnStart == 0 && objGeneratedNo.FnEnd == 0) ? "0" : dtExcelData.Columns[colCnt].ToString().ToUpper().Trim().Substring(0, objGeneratedNo.FnEnd.ToString().Length))); Alphabet = ((objGeneratedNo.FnStart == 0 && objGeneratedNo.FnEnd == 0) ? dtExcelData.Columns[colCnt].ToString().ToUpper().Trim().Substring(0, AlphabetLen) : dtExcelData.Columns[colCnt].ToString().ToUpper().Trim().Substring(objGeneratedNo.FnEnd.ToString().Length, AlphabetLen)); TnNo = Convert.ToInt64(dtExcelData.Columns[colCnt].ToString().ToUpper().Trim().Substring(dtExcelData.Columns[colCnt].ToString().ToUpper().Trim().Length - objGeneratedNo.TnEnd.ToString().Length, objGeneratedNo.TnEnd.ToString().Length)); DataSet dtLotteryDtl = objLtmsService.GetLotteryDtlInClaimAndUnSold(objGeneratedNo.DataUniqueId, dtExcelData.Columns[colCnt].ToString().ToUpper().Trim().ToUpper(), FnNo, Alphabet, TnNo); if (dtLotteryDtl != null) { if (dtLotteryDtl.Tables[1].Rows.Count > 0) { errorCntForTkt++; TotError++; strMsg.AppendLine("Column " + (colCnt + 1) + " and Row No 1: The Lottery Ticket " + dtExcelData.Columns[colCnt].ToString().ToUpper() + " is available in unsold ticket"); } } } } } } if (IsCommonToAllSeries == true) { errorCntForTkt++; TotError++; strMsg.AppendLine("Column " + (colCnt + 1) + " and Row No 1: The Lottery Ticket " + dtExcelData.Columns[colCnt].ToString().ToUpper() + " is type PWT So it will not uploded with this portal"); } if (isPartialTicket == false) { errorCntForTkt++; TotError++; strMsg.AppendLine("Column " + (colCnt + 1) + " and Row No 1: The Lottery Ticket " + dtExcelData.Columns[colCnt].ToString().ToUpper() + " is Not a Winning prize."); } if (errorCntForTkt == 0 && isPartialTicket == true) { dr = dtTicketNumber.NewRow(); dr["TicketNumber"] = dtExcelData.Columns[colCnt].ToString(); dr["WinnerId"] = WinnerId.ToString(); dtTicketNumber.Rows.Add(dr); } for (Int32 iCnt = 0; iCnt < dtExcelData.Rows.Count; iCnt++) { if (dtExcelData.Rows[iCnt][colCnt].ToString().Trim().Length > 0) { isValidTicketNo = true; IsCommonToAllSeries = false; isPartialTicket = false; errorCntForTkt = 0; WinnerId = 0; ErrorMsg = objValidateData.ValidateTicketNo(objGeneratedNo, dtExcelData.Rows[iCnt][colCnt].ToString()); if (ErrorMsg.Trim().Length > 0) { errorCntForTkt++; TotError++; if (TotError <= 10) { isValidTicketNo = false; strMsg.AppendLine("Column " + (colCnt + 1) + " and Row No " + (iCnt + 1) + ": " + ErrorMsg); } if (TotError > 10) { break; } ; } if (isValidTicketNo == true) { for (int rwCnt = 0; rwCnt < dtLotteryWiningSerialNoDtl.Tables[1].Rows.Count; rwCnt++) { if (dtExcelData.Rows[iCnt][colCnt].ToString().ToUpper() == dtLotteryWiningSerialNoDtl.Tables[1].Rows[rwCnt]["WiningSerialNo"].ToString().ToUpper()) { IsCommonToAllSeries = true; } if (dtExcelData.Rows[iCnt][colCnt].ToString().ToUpper().EndsWith(dtLotteryWiningSerialNoDtl.Tables[1].Rows[rwCnt]["WiningSerialNo"].ToString()) == true) { WinnerId = Convert.ToInt64(dtLotteryWiningSerialNoDtl.Tables[1].Rows[rwCnt]["WinnerId"].ToString()); isPartialTicket = true; ValidationForUnsold = (dtLotteryWiningSerialNoDtl.Tables[1].Rows[rwCnt]["ValidationForUnsold"].ToString().ToUpper() == "Y"?true:false); if (ValidationForUnsold == true) { int FnNo = 0; string Alphabet = ""; Int64 TnNo = 0; string AlphabetSeries = objGeneratedNo.AlphabetSeries; string[] values = AlphabetSeries.Split(','); int AlphabetLen = Convert.ToInt16(values[values.Length - 1].ToString().Length); FnNo = Convert.ToInt16(((objGeneratedNo.FnStart == 0 && objGeneratedNo.FnEnd == 0) ? "0" : dtExcelData.Rows[iCnt][colCnt].ToString().ToUpper().Trim().Substring(0, objGeneratedNo.FnEnd.ToString().Length))); Alphabet = ((objGeneratedNo.FnStart == 0 && objGeneratedNo.FnEnd == 0) ? dtExcelData.Rows[iCnt][colCnt].ToString().ToUpper().Trim().Substring(0, AlphabetLen) : dtExcelData.Rows[iCnt][colCnt].ToString().ToUpper().Trim().Substring(objGeneratedNo.FnEnd.ToString().Length, AlphabetLen)); TnNo = Convert.ToInt64(dtExcelData.Rows[iCnt][colCnt].ToString().ToUpper().Trim().Substring(dtExcelData.Rows[iCnt][colCnt].ToString().ToUpper().Trim().Length - objGeneratedNo.TnEnd.ToString().Length, objGeneratedNo.TnEnd.ToString().Length)); DataSet dtLotteryDtl = objLtmsService.GetLotteryDtlInClaimAndUnSold(objGeneratedNo.DataUniqueId, dtExcelData.Rows[iCnt][colCnt].ToString().ToUpper().Trim(), FnNo, Alphabet, TnNo); if (dtLotteryDtl != null) { if (dtLotteryDtl.Tables[1].Rows.Count > 0) { errorCntForTkt++; TotError++; strMsg.AppendLine("Column " + (colCnt + 1) + " and Row No 1: The Lottery Ticket " + dtExcelData.Rows[iCnt][colCnt].ToString().ToUpper() + " is available in unsold ticket"); } } } } } } if (IsCommonToAllSeries == true) { errorCntForTkt++; TotError++; strMsg.AppendLine("Column " + (colCnt + 1) + " and Row No " + (iCnt + 1) + ": The Lottery Ticket " + dtExcelData.Rows[iCnt][colCnt].ToString().ToUpper() + " is type PWT So it will not uploded with this portal"); } if (isPartialTicket == false) { errorCntForTkt++; TotError++; strMsg.AppendLine("Column " + (colCnt + 1) + " and Row No " + (iCnt + 1) + ": The Lottery Ticket " + dtExcelData.Rows[iCnt][colCnt].ToString().ToUpper() + " is Not a Winning prize."); } if (errorCntForTkt == 0 && isPartialTicket == true) { dr = dtTicketNumber.NewRow(); dr["TicketNumber"] = dtExcelData.Rows[iCnt][colCnt].ToString().ToUpper(); dr["WinnerId"] = WinnerId.ToString(); dtTicketNumber.Rows.Add(dr); } } if (TotError > 10) { break; } ; } } } } if (strMsg.ToString().Trim().Length > 0) { if (TotError > 10) { ErrorMsg = "There are more than 10 Error in the file first 10 error are as below " + strMsg.ToString(); } else { ErrorMsg = "There are " + TotError + " Error in the file as below " + strMsg.ToString(); } var message = new JavaScriptSerializer().Serialize(ErrorMsg); var script = string.Format("alert({0});", message); ScriptManager.RegisterClientScriptBlock(this, GetType(), "", script, true); return(false); } dtLotteryInfo = objLtmsService.GetVariableClaimPrizeById(DatauNiqueId); bool IsFound = false; int DuplicateTicketCount = 0; for (int iRwCnt = 0; iRwCnt < dtLotteryInfo.Rows.Count; iRwCnt++) { for (int jRwCnt = 0; jRwCnt < dtTicketNumber.Rows.Count; jRwCnt++) { if (dtTicketNumber.Rows[jRwCnt]["TicketNumber"].ToString().Trim() == dtLotteryInfo.Rows[iRwCnt]["TicketNumber"].ToString().Trim()) { DuplicateTicketCount += 1; IsFound = true; } } } if (IsFound == true) { ScriptManager.RegisterStartupScript(this, GetType(), "MyMsg", "alert('Upload can not be completed. Total " + DuplicateTicketCount + " duplicate ticket no exist in database.');", true); return(false); } if (objValidateData.IsIntegerWithZero(txtDrawNo.Text.Trim()) == false) { ScriptManager.RegisterStartupScript(this, GetType(), "MyMsg", "alert('Draw No number should be numeric.');", true); txtDrawNo.Focus(); return(false); } if (objValidateData.isValidDate(txtDrawDate.Text.Trim()) == false) { ScriptManager.RegisterStartupScript(this, GetType(), "MyMsg", "alert('Please enter valid draw date');", true); txtDrawDate.Focus(); return(false); } return(true); }
//Checking for valid data entry private bool IsValidEntry() { bool IsError = false; string ErrorMsg = "", Msg = ""; ClsTicketInventory objGeneratedNo = new ClsTicketInventory(); DataTable dtLotteryInfo = new DataTable(); dtLotteryInfo = objLtmsService.GetRequisitionDtlById(Convert.ToInt64(hdUniqueId.Value)); if (dtLotteryInfo.Rows.Count > 0) { objGeneratedNo.DataUniqueId = Convert.ToInt64(dtLotteryInfo.Rows[0]["DataUniqueId"].ToString()); objGeneratedNo.DrawNo = Convert.ToInt16(dtLotteryInfo.Rows[0]["DrawNo"].ToString()); objGeneratedNo.DrawDate = Convert.ToDateTime(dtLotteryInfo.Rows[0]["DrawDate"].ToString()); objGeneratedNo.FnStart = Convert.ToInt16(dtLotteryInfo.Rows[0]["FnStart"].ToString()); objGeneratedNo.FnEnd = Convert.ToInt16(dtLotteryInfo.Rows[0]["FnEnd"].ToString()); objGeneratedNo.AlphabetSeries = dtLotteryInfo.Rows[0]["AlphabetSeries"].ToString(); objGeneratedNo.TnStart = Convert.ToInt64(dtLotteryInfo.Rows[0]["TnStart"].ToString()); objGeneratedNo.TnEnd = Convert.ToInt64(dtLotteryInfo.Rows[0]["TnEnd"].ToString()); } else { ScriptManager.RegisterStartupScript(this, GetType(), "MyMsg", "alert('Lottery information not generated in inventory.');", true); return(false); } for (int iCtr = 0; iCtr < gvPrizeWinnerDetails.Rows.Count; iCtr++) { Label lblNoOfDigitInStatic = (Label)gvPrizeWinnerDetails.Rows[iCtr].Cells[0].FindControl("lblNoOfDigitInStatic"); CheckBox chkValidationForUnsold = (CheckBox)gvPrizeWinnerDetails.Rows[iCtr].Cells[0].FindControl("chkValidationForUnsold"); GridView gvWiningSerialNo = ((GridView)gvPrizeWinnerDetails.Rows[iCtr].Cells[0].FindControl("gvWiningSerialNo")); for (int jCnt = 0; jCnt < gvWiningSerialNo.Rows.Count; jCnt++) { TextBox txtWiningSerialNo = (TextBox)gvWiningSerialNo.Rows[jCnt].Cells[0].FindControl("txtWiningSerialNo"); if (txtWiningSerialNo.Text.Trim() == "") { IsError = true; ErrorMsg = (ErrorMsg != "" ? ErrorMsg + "\n" : "") + "Wining SerialNo name can not be balnk in row no. " + (iCtr + 1) + " for box" + (jCnt + 1); } else if (txtWiningSerialNo.Text.Trim() != "" && txtWiningSerialNo.Text.Trim().Length != Convert.ToInt16(lblNoOfDigitInStatic.Text)) { IsError = true; ErrorMsg = (ErrorMsg != "" ? ErrorMsg + "\n" : "") + "No of character in Wining Serial No. should be " + Convert.ToInt16(lblNoOfDigitInStatic.Text) + " in row no. " + (iCtr + 1) + " for box" + (jCnt + 1); } else if (txtWiningSerialNo.Text.Trim() != "" && txtWiningSerialNo.Text.Trim().Length == Convert.ToInt16(lblNoOfDigitInStatic.Text)) { if (dtLotteryInfo.Rows.Count > 0) { Msg = objValidateData.ValidatePartialTicketNo(objGeneratedNo, txtWiningSerialNo.Text); if (Msg.Length > 0) { IsError = true; ErrorMsg = (ErrorMsg != "" ? ErrorMsg + "\n" : "") + Msg + " in row no. " + (iCtr + 1) + " for box" + (jCnt + 1); } if (Msg.Length == 0 && chkValidationForUnsold.Checked == true) { int FnNo = 0, TicketLength = 0, FnEndLength = 0, AlphabetSeriesLength, TnEndLength = 0; string Alphabet = ""; Int64 TnNo = 0; string AlphabetSeries = objGeneratedNo.AlphabetSeries; string[] values = AlphabetSeries.Split(','); int AlphabetLen = Convert.ToInt16(values[values.Length - 1].ToString().Length); FnEndLength = (objGeneratedNo.FnEnd == 0 ? 0 : objGeneratedNo.FnEnd.ToString().Length); AlphabetSeriesLength = values[values.Length - 1].ToString().Trim().Length; TnEndLength = objGeneratedNo.TnEnd.ToString().Length; TicketLength = (objGeneratedNo.FnEnd == 0 ? 0 : FnEndLength) + AlphabetSeriesLength + TnEndLength; if (txtWiningSerialNo.Text.Trim().ToUpper().Length == TicketLength) { FnNo = Convert.ToInt16(((objGeneratedNo.FnStart == 0 && objGeneratedNo.FnEnd == 0) ? "0" : txtWiningSerialNo.Text.Trim().Substring(0, objGeneratedNo.FnEnd.ToString().Length))); Alphabet = ((objGeneratedNo.FnStart == 0 && objGeneratedNo.FnEnd == 0) ? txtWiningSerialNo.Text.Trim().Substring(0, AlphabetLen) : txtWiningSerialNo.Text.Trim().Substring(objGeneratedNo.FnEnd.ToString().Length, AlphabetLen)); TnNo = Convert.ToInt64(txtWiningSerialNo.Text.Trim().Substring(txtWiningSerialNo.Text.Trim().Length - objGeneratedNo.TnEnd.ToString().Length, objGeneratedNo.TnEnd.ToString().Length)); DataSet dtLotteryDtl = objLtmsService.GetLotteryDtlInClaimAndUnSold(objGeneratedNo.DataUniqueId, txtWiningSerialNo.Text.Trim().ToUpper(), FnNo, Alphabet, TnNo); if (dtLotteryDtl != null) { if (dtLotteryDtl.Tables[1].Rows.Count > 0) { IsError = true; ErrorMsg = (ErrorMsg != "" ? ErrorMsg + "\n" : "") + "The Wining Serial No. " + txtWiningSerialNo.Text.Trim().ToUpper() + " is available in unsold ticket in row no. " + (iCtr + 1) + " for box" + (jCnt + 1); } } } else if (txtWiningSerialNo.Text.Trim().ToUpper().Length <= TnEndLength && objValidateData.IsIntegerWithZero(txtWiningSerialNo.Text.Trim().ToUpper())) { if (Convert.ToInt32(txtWiningSerialNo.Text.Trim()) <= objGeneratedNo.TnEnd) { FnNo = 0; Alphabet = ""; TnNo = Convert.ToInt64(txtWiningSerialNo.Text.Trim()); DataSet dtLotteryDtl = objLtmsService.GetLotteryDtlInClaimAndUnSold(objGeneratedNo.DataUniqueId, txtWiningSerialNo.Text.Trim().ToUpper(), FnNo, Alphabet, TnNo); if (dtLotteryDtl != null) { if (dtLotteryDtl.Tables[2].Rows.Count > 0) { IsError = true; ErrorMsg = (ErrorMsg != "" ? ErrorMsg + "\n" : "") + "The Wining Serial No. " + txtWiningSerialNo.Text.Trim().ToUpper() + " is available in unsold ticket in row no. " + (iCtr + 1) + " for box" + (jCnt + 1); } } } } } } // } } } if (IsError == true) { var message = new JavaScriptSerializer().Serialize("Some errors in PrizeWinner details table as below.\n'" + ErrorMsg); var script = string.Format("alert({0});", message); ScriptManager.RegisterClientScriptBlock(this, GetType(), "", script, true); // ScriptManager.RegisterStartupScript(this, GetType(), "MyMsg", "alert('Some error in PrizeWinner details table as below.\n'"+ ErrorMsg +");", true); return(false); } if (txtJudgesName1.Text.Trim() == "") { ScriptManager.RegisterStartupScript(this, GetType(), "MyMsg", "alert('Judges Name 1 can not be left blank.');", true); txtJudgesName1.Focus(); return(false); } if (txtPlayingAddress.Text.Trim() == "") { ScriptManager.RegisterStartupScript(this, GetType(), "MyMsg", "alert('Playing Address can not be left blank.');", true); txtPlayingAddress.Focus(); return(false); } return(true); }
//Checking for valid data entry private bool IsValidEntry(DataTable dtExcelData, Int64 DatauNiqueId, out DataTable dtTicketRange) { string ErrorMsg = ""; Int32 TotError = 0; StringBuilder strMsg = new StringBuilder(); ClsTicketInventory objGeneratedNo = new ClsTicketInventory(); dtTicketRange = null; if (objValidateData.IsIntegerWithZero(txtDrawNo.Text.Trim()) == false) { ScriptManager.RegisterStartupScript(this, GetType(), "MyMsg", "alert('Draw No number should be numeric.');", true); txtDrawNo.Focus(); return(false); } if (objValidateData.isValidDate(txtDrawDate.Text.Trim()) == false) { ScriptManager.RegisterStartupScript(this, GetType(), "MyMsg", "alert('Please enter valid draw date');", true); txtDrawDate.Focus(); return(false); } Int32 ColCnt = 0; for (Int32 colCnt = 0; colCnt < dtExcelData.Columns.Count; colCnt++) { if (dtExcelData.Columns[colCnt].ToString().Trim() != "") { ColCnt++; } } if (ColCnt != 4) { ScriptManager.RegisterStartupScript(this, GetType(), "MyMsg", "alert('No of column in excel should be 4 in a sequence of Initial No, Alphabates, Start no , end no.');", true); return(false); } DataTable dtTicketRow = new DataTable(); dtTicketRow.TableName = "dtTicket"; DataRow dataRw = null; dtTicketRow.Columns.Add(new DataColumn("FnNo", typeof(int))); dtTicketRow.Columns.Add(new DataColumn("Alphabet", typeof(string))); dtTicketRow.Columns.Add(new DataColumn("StartNo", typeof(Int64))); dtTicketRow.Columns.Add(new DataColumn("EndNo", typeof(Int64))); DataTable dtLotteryInfo = objLtmsService.GetRequisitionDtlById(DatauNiqueId); if (dtLotteryInfo.Rows.Count > 0) { objGeneratedNo.DataUniqueId = Convert.ToInt64(dtLotteryInfo.Rows[0]["DataUniqueId"].ToString()); objGeneratedNo.DrawNo = Convert.ToInt16(dtLotteryInfo.Rows[0]["DrawNo"].ToString()); objGeneratedNo.DrawDate = Convert.ToDateTime(dtLotteryInfo.Rows[0]["DrawDate"].ToString()); objGeneratedNo.FnStart = Convert.ToInt16(dtLotteryInfo.Rows[0]["FnStart"].ToString()); objGeneratedNo.FnEnd = Convert.ToInt16(dtLotteryInfo.Rows[0]["FnEnd"].ToString()); objGeneratedNo.AlphabetSeries = dtLotteryInfo.Rows[0]["AlphabetSeries"].ToString(); objGeneratedNo.TnStart = Convert.ToInt64(dtLotteryInfo.Rows[0]["TnStart"].ToString()); objGeneratedNo.TnEnd = Convert.ToInt64(dtLotteryInfo.Rows[0]["TnEnd"].ToString()); bool IsError = false; for (Int32 iCnt = 0; iCnt < dtExcelData.Rows.Count; iCnt++) { string FirstInitialNo = dtExcelData.Rows[iCnt][0].ToString(); string exclAlphabetSeries = dtExcelData.Rows[iCnt][1].ToString(); string TnStart = dtExcelData.Rows[iCnt][2].ToString(); string TnEnd = dtExcelData.Rows[iCnt][3].ToString(); IsError = false; if (isValidStartNo(objGeneratedNo.FnStart, objGeneratedNo.FnEnd, FirstInitialNo) == false) { TotError++; IsError = true; strMsg.AppendLine("Column " + 1 + " and Row No " + (iCnt + 2) + ": Invalid First Initial No"); } if (isValidAlphabetSeries(objGeneratedNo.AlphabetSeries, exclAlphabetSeries) == false) { TotError++; IsError = true; strMsg.AppendLine("Column " + 2 + " and Row No " + (iCnt + 2) + ": Invalid Alphabets series"); } if (isValidEndSeries(objGeneratedNo.TnStart, objGeneratedNo.TnEnd, TnStart, TnEnd) == false) { TotError++; IsError = true; strMsg.AppendLine("Column " + 3 + " and Row No " + (iCnt + 2) + ": Invalid End Range"); } if (TotError > 10) { break; } ; if (IsError == false) { string[] excelValues = exclAlphabetSeries.TrimEnd(',').Split(','); for (int jCnt = 0; jCnt < excelValues.Length; jCnt++) { dataRw = dtTicketRow.NewRow(); dataRw["FnNo"] = FirstInitialNo; dataRw["Alphabet"] = excelValues[jCnt].ToString().Trim(); dataRw["StartNo"] = TnStart; dataRw["EndNo"] = TnEnd; dtTicketRow.Rows.Add(dataRw); } } } if (strMsg.ToString().Trim().Length > 0) { if (TotError > 10) { ErrorMsg = "There are more than 10 Error in the file first 10 error are as below " + strMsg.ToString(); } else { ErrorMsg = "There are " + TotError + " Error in the file as below " + strMsg.ToString(); } var message = new JavaScriptSerializer().Serialize(ErrorMsg); var script = string.Format("alert({0});", message); ScriptManager.RegisterClientScriptBlock(this, GetType(), "", script, true); return(false); } #region Duplicate Ticket Check dtTicketRow.DefaultView.Sort = "FnNo ASC,Alphabet ASC,StartNo ASC,EndNo ASC"; dtTicketRow = dtTicketRow.DefaultView.ToTable(); DataTable distinctTable = dtTicketRow.DefaultView.ToTable(true); if (dtTicketRow.Rows.Count != distinctTable.Rows.Count) { ScriptManager.RegisterStartupScript(this, GetType(), "MyMsg", "alert('Upload can not be completed.Duplicate Ticket No exist in file.');", true); return(false); } Int32 StratRowCnt = 0; Int32 EndRowCnt = 0; Int32 TicketCnt = 0; for (int iCnt = 0; iCnt < dtTicketRow.Rows.Count; iCnt++) { TicketCnt = TicketCnt + (Convert.ToInt32(dtTicketRow.Rows[iCnt][3].ToString()) - Convert.ToInt32(dtTicketRow.Rows[iCnt][2].ToString())) + 1; for (int jCnt = iCnt + 1; jCnt < dtTicketRow.Rows.Count; jCnt++) { if ((dtTicketRow.Rows[iCnt][0].ToString() == dtTicketRow.Rows[jCnt][0].ToString()) && (dtTicketRow.Rows[iCnt][1].ToString() == dtTicketRow.Rows[jCnt][1].ToString()) && ( ( (Convert.ToInt32(dtTicketRow.Rows[iCnt][2].ToString()) >= Convert.ToInt32(dtTicketRow.Rows[jCnt][2].ToString()) && Convert.ToInt32(dtTicketRow.Rows[iCnt][2].ToString()) <= Convert.ToInt32(dtTicketRow.Rows[jCnt][3].ToString()) ) || (Convert.ToInt32(dtTicketRow.Rows[iCnt][3].ToString()) >= Convert.ToInt32(dtTicketRow.Rows[jCnt][2].ToString()) && Convert.ToInt32(dtTicketRow.Rows[iCnt][3].ToString()) <= Convert.ToInt32(dtTicketRow.Rows[jCnt][3].ToString()) ) ) || ( (Convert.ToInt32(dtTicketRow.Rows[jCnt][2].ToString()) >= Convert.ToInt32(dtTicketRow.Rows[iCnt][2].ToString()) && Convert.ToInt32(dtTicketRow.Rows[jCnt][2].ToString()) <= Convert.ToInt32(dtTicketRow.Rows[iCnt][3].ToString()) ) || (Convert.ToInt32(dtTicketRow.Rows[jCnt][3].ToString()) >= Convert.ToInt32(dtTicketRow.Rows[iCnt][2].ToString()) && Convert.ToInt32(dtTicketRow.Rows[jCnt][3].ToString()) <= Convert.ToInt32(dtTicketRow.Rows[iCnt][3].ToString()) ) ) ) ) { StratRowCnt = iCnt; EndRowCnt = jCnt; break; } } if (StratRowCnt > 0 && EndRowCnt > 0) { break; } } if (StratRowCnt > 0 && EndRowCnt > 0) { ScriptManager.RegisterStartupScript(this, GetType(), "MyMsg", "alert('Upload can not be completed.Duplicate Ticket No exist within the range in file.');", true); return(false); } #endregion #region Unsold Percentage count Int64 Qty = Convert.ToInt64(txtQty.Text.Trim()); Int64 SoldCount = Convert.ToInt64(TicketCnt); double Percentage = 0; if (SoldCount > 0) { try { Percentage = Convert.ToDouble((Convert.ToDouble(SoldCount) / Convert.ToDouble(Qty)) * 100); if (Convert.ToDouble(txtUnSoldPercentage.Text.Trim()) > 0 && Percentage > Convert.ToDouble(txtUnSoldPercentage.Text.Trim())) { ScriptManager.RegisterStartupScript(this, GetType(), "MyMsg", "alert('No of ticket percentage cannot be more than the " + txtUnSoldPercentage.Text.Trim() + "%.');", true); return(false); } } catch (Exception ex) { objValidateData.SaveSystemErrorLog(ex, Request.UserHostAddress); ScriptManager.RegisterStartupScript(this, GetType(), "MyMsg", "alert('Some Error occured while calculating un-Sold persantage. Please contact system administrator');", true); return(false); } } #endregion dtTicketRange = dtTicketRow.Copy(); #region Validate ticker //for (Int16 colCnt = 0; colCnt < dtExcelData.Columns.Count; colCnt++) //{ // if (dtExcelData.Columns[colCnt].ToString().Trim() != "") // { // ErrorMsg = objValidateData.ValidateTicketNo(objGeneratedNo, dtExcelData.Columns[colCnt].ToString()); // if (ErrorMsg.Trim().Length > 0) // { // TotError++; // strMsg.AppendLine("Column " + (colCnt + 1) + " and Row No 1:" + ErrorMsg); // } // else { // TicketNo = dtExcelData.Columns[colCnt].ToString().Trim(); // dr = dtTicketNumber.NewRow(); // dr["FnNo"] = ((objGeneratedNo.FnStart == 0 && objGeneratedNo.FnEnd == 0) ? "0" : TicketNo.Substring(0, objGeneratedNo.FnEnd.ToString().Length)); // dr["Alphabet"] = ((objGeneratedNo.FnStart == 0 && objGeneratedNo.FnEnd == 0) ? TicketNo.Substring(0, AlphabetLen) : TicketNo.Substring(objGeneratedNo.FnEnd.ToString().Length, AlphabetLen)); // dr["TnNo"] = TicketNo.Substring(TicketNo.Length - objGeneratedNo.TnEnd.ToString().Length, objGeneratedNo.TnEnd.ToString().Length); // dtTicketNumber.Rows.Add(dr); // } // for (Int32 iCnt = 0; iCnt < dtExcelData.Rows.Count; iCnt++) // { // if (dtExcelData.Rows[iCnt][colCnt].ToString() != "") // { // ErrorMsg = objValidateData.ValidateTicketNo(objGeneratedNo, dtExcelData.Rows[iCnt][colCnt].ToString()); // if (ErrorMsg.Trim().Length > 0) // { // TotError++; // if (TotError <= 10) // { // strMsg.AppendLine("Column " + (colCnt + 1) + " and Row No " + (iCnt + 1) + ": " + ErrorMsg); // } // if (TotError > 10) { break; }; // } // else // { // TicketNo = dtExcelData.Rows[iCnt][colCnt].ToString(); // dr = dtTicketNumber.NewRow(); // dr["FnNo"] = ((objGeneratedNo.FnStart == 0 && objGeneratedNo.FnEnd == 0) ? "0" : TicketNo.Substring(0, objGeneratedNo.FnEnd.ToString().Length)); // dr["Alphabet"] = ((objGeneratedNo.FnStart == 0 && objGeneratedNo.FnEnd == 0) ? TicketNo.Substring(0, AlphabetLen) : TicketNo.Substring(objGeneratedNo.FnEnd.ToString().Length, AlphabetLen)); // dr["TnNo"] = TicketNo.Substring(TicketNo.Length - objGeneratedNo.TnEnd.ToString().Length, objGeneratedNo.TnEnd.ToString().Length); // dtTicketNumber.Rows.Add(dr); // } // } // } // } //} #endregion #region Bind ticket in range // dtTicketNumber.DefaultView.Sort = "FnNo ASC,Alphabet ASC,TnNo ASC"; // dtTicketNumber = dtTicketNumber.DefaultView.ToTable(); // DataTable dtTicket = new DataTable(); // dtTicket.TableName = "dtTicket"; // DataRow dtRw = null; // dtTicket.Columns.Add(new DataColumn("FnNo", typeof(int))); // dtTicket.Columns.Add(new DataColumn("Alphabet", typeof(string))); //// dtTicket.Columns.Add(new DataColumn("TnNo", typeof(string))); // dtTicket.Columns.Add(new DataColumn("StartNo", typeof(Int64))); // dtTicket.Columns.Add(new DataColumn("EndNo", typeof(Int64))); // Int32 tempEndNo=0,rowCounter=0; // int FnNo = 0; // string Alphabet = ""; // Int32 TnNo = 0; // bool isRowExist = true; // for (Int32 iCnt = 0; iCnt < dtTicketNumber.Rows.Count; iCnt++) // { // FnNo = Convert.ToInt16(dtTicketNumber.Rows[iCnt]["FnNo"].ToString()); // Alphabet = dtTicketNumber.Rows[iCnt]["Alphabet"].ToString(); // TnNo = Convert.ToInt32(dtTicketNumber.Rows[iCnt]["TnNo"].ToString()); // isRowExist = false; // if (dtTicket.Rows.Count > 0) // { // if ((FnNo == Convert.ToInt16(dtTicket.Rows[rowCounter]["FnNo"].ToString())) && // (Alphabet == dtTicket.Rows[rowCounter]["Alphabet"].ToString()) // ) // { // isRowExist = true; // } // } // if (isRowExist == false) // { // dtRw = dtTicket.NewRow(); // dtRw["FnNo"] = FnNo; // dtRw["Alphabet"] = Alphabet; // // dtRw["TnNo"] = TnNo; // dtRw["StartNo"] = TnNo; // dtRw["EndNo"] = TnNo; // dtTicket.Rows.Add(dtRw); // tempEndNo = TnNo + 1; // rowCounter = dtTicket.Rows.Count-1; // } // if (isRowExist == true && TnNo == tempEndNo) // { // dtTicket.Rows[rowCounter]["EndNo"] = tempEndNo; // tempEndNo = TnNo+1; // } // else if (isRowExist == true && TnNo > tempEndNo) // { // FnNo = Convert.ToInt16(dtTicketNumber.Rows[iCnt]["FnNo"].ToString()); // Alphabet = dtTicketNumber.Rows[iCnt]["Alphabet"].ToString(); // TnNo = Convert.ToInt32(dtTicketNumber.Rows[iCnt]["TnNo"].ToString()); // dtRw = dtTicket.NewRow(); // dtRw["FnNo"] = FnNo; // dtRw["Alphabet"] = Alphabet; // // dtRw["TnNo"] = TnNo; // dtRw["StartNo"] = TnNo; // dtRw["EndNo"] = TnNo; // dtTicket.Rows.Add(dtRw); // tempEndNo = TnNo + 1; // rowCounter = dtTicket.Rows.Count-1; // } // } // dtTicketRange = dtTicket.Copy(); //// dtTicketRange = dtTicket; // dtExcelData.Clear(); // dtExcelData = null; // dtTicket.Clear(); // dtTicket = null; #endregion } return(true); }