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