//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);
}
