//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() { if (ddlLotteryType.SelectedIndex == 0) { ScriptManager.RegisterStartupScript(this, GetType(), "MyMsg", "alert('Please Select Lottery Type.');", true); ddlLotteryType.Focus(); return(false); } if (ddlLotteryName.SelectedIndex == 0) { ScriptManager.RegisterStartupScript(this, GetType(), "MyMsg", "alert('Please Select Lottery Name.');", true); ddlLotteryName.Focus(); return(false); } if (objValidateData.isValidDate(txtDrawDate.Text.Trim()) == false && txtDrawNo.Text.Trim() == "") { ScriptManager.RegisterStartupScript(this, GetType(), "MyMsg", "alert('Please enter valid draw date or Draw no.');", true); txtDrawNo.Focus(); return(false); } if (txtDrawDate.Text.Trim() != "") { if (objValidateData.isValidDate(txtDrawDate.Text.Trim()) == false) { ScriptManager.RegisterStartupScript(this, GetType(), "MyMsg", "alert('Please enter valid draw date.');", true); txtDrawDate.Focus(); return(false); } } if (txtDrawNo.Text.Trim() != "") { if (objValidateData.IsIntegerWithZero(txtDrawNo.Text.Trim()) == false) { ScriptManager.RegisterStartupScript(this, GetType(), "MyMsg", "alert('Please enter valid draw No.');", true); txtDrawNo.Focus(); return(false); } } if (txtLotteryNo.Text.Trim() == "") { ScriptManager.RegisterStartupScript(this, GetType(), "MyMsg", "alert('Please enter Lottery No.');", true); txtLotteryNo.Focus(); return(false); } ClsTicketInventory objGeneratedNo = new ClsTicketInventory(); DataTable dtLotteryInfo = new DataTable(); Int64 InLotteryId = Convert.ToInt64(ddlLotteryName.SelectedValue); int? InDrawNo = string.IsNullOrEmpty(txtDrawNo.Text.Trim()) ? (int?)null : int.Parse(txtDrawNo.Text.Trim()); DateTime?InDrawDate = string.IsNullOrEmpty(txtDrawDate.Text.Trim()) ? (DateTime?)null : DateTime.Parse(txtDrawDate.Text.Trim()); dtLotteryInfo = objLtmsService.GetLotteryDtlFromRequisitionDtl(InLotteryId, InDrawNo, InDrawDate); 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()); string ErrorMsg = objValidateData.ValidateTicketNo(objGeneratedNo, txtLotteryNo.Text); if (ErrorMsg.Trim().Length > 0) { lblValidTicket.Text = "<font color='red'><b>The Lottery Ticket " + txtLotteryNo.Text.Trim() + " is Not valid ticket</b></font>"; var message = new JavaScriptSerializer().Serialize(ErrorMsg); var script = string.Format("alert({0});", message); ScriptManager.RegisterClientScriptBlock(this, GetType(), "", script, true); txtLotteryNo.Focus(); return(false); } 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" : txtLotteryNo.Text.Trim().Substring(0, objGeneratedNo.FnEnd.ToString().Length))); Alphabet = ((objGeneratedNo.FnStart == 0 && objGeneratedNo.FnEnd == 0) ? txtLotteryNo.Text.Trim().Substring(0, AlphabetLen) : txtLotteryNo.Text.Trim().Substring(objGeneratedNo.FnEnd.ToString().Length, AlphabetLen)); TnNo = Convert.ToInt64(txtLotteryNo.Text.Trim().Substring(txtLotteryNo.Text.Trim().Length - objGeneratedNo.TnEnd.ToString().Length, objGeneratedNo.TnEnd.ToString().Length)); DataSet dtLotteryDtl = objLtmsService.GetLotteryDtlInClaimAndUnSold(objGeneratedNo.DataUniqueId, txtLotteryNo.Text.Trim().ToUpper(), FnNo, Alphabet, TnNo); if (dtLotteryDtl != null) { if (dtLotteryDtl.Tables[1].Rows.Count > 0) { lblValidTicket.Text = "<font color='red'><b>The Lottery Ticket No " + txtLotteryNo.Text.Trim() + " is not available for Prize.</b></font>"; return(false); } } DataSet dtLotteryWiningSerialNoDtl = objLtmsService.GetLotteryWiningSerialNoDtlByLotteryNo(objGeneratedNo.DataUniqueId, txtLotteryNo.Text.Trim()); if (dtLotteryWiningSerialNoDtl.Tables[0].Rows.Count > 0) { lblValidTicket.Text = "<font color='Green'><b>The Lottery Ticket " + txtLotteryNo.Text.Trim() + " is available for " + dtLotteryWiningSerialNoDtl.Tables[0].Rows[0]["NameOfPrize"].ToString() + " and Prize Amount is " + dtLotteryWiningSerialNoDtl.Tables[0].Rows[0]["PrizeAmount"].ToString() + "</b></font>"; return(false); } bool isFound = false; dtLotteryWiningSerialNoDtl = objLtmsService.GetLotteryWiningSerialNoDtlByLotteryNo(objGeneratedNo.DataUniqueId, ""); if (dtLotteryWiningSerialNoDtl.Tables[1].Rows.Count > 0) { for (int rwCnt = 0; rwCnt < dtLotteryWiningSerialNoDtl.Tables[1].Rows.Count; rwCnt++) { if (txtLotteryNo.Text.Trim().EndsWith(dtLotteryWiningSerialNoDtl.Tables[1].Rows[rwCnt]["WiningSerialNo"].ToString()) == true) { isFound = true; lblValidTicket.Text = "<font color='Green'><b>The Lottery Ticket " + txtLotteryNo.Text.Trim() + " is available for " + dtLotteryWiningSerialNoDtl.Tables[1].Rows[rwCnt]["NameOfPrize"].ToString() + " and Prize Amount is " + dtLotteryWiningSerialNoDtl.Tables[1].Rows[rwCnt]["PrizeAmount"].ToString() + "</b></font>"; return(false); } } } if (isFound == false) { lblValidTicket.Text = "<font color='red'><b>The Lottery Ticket No " + txtLotteryNo.Text.Trim() + " is not a Prize Winning Ticket.</b></font>"; // ScriptManager.RegisterStartupScript(this, GetType(), "MyMsg", "alert('Please Enter valid ticket no. The ticket no you entered is not available in any Wining Serial No.');", true); return(false); } } else { ScriptManager.RegisterStartupScript(this, GetType(), "MyMsg", "alert('Please Enter valid ticket no. The ticket no you entered is not correct for the date and draw no you specified');", true); return(false); } // GetLotteryDtlFromRequisitionDtl(Int64 InLotteryId, int InDrawNo, DateTime InDrawDate) 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); }