protected void btnSaveData_Click(object sender, EventArgs e) { string InsertedId = string.Empty; long id = default(long); try { if (IsValidEntry() == false) { return; } ClsSeriesGeneration obj = new ClsSeriesGeneration(); if (!string.IsNullOrWhiteSpace(hdnID.Value)) { long.TryParse(hdnID.Value, out id); } obj.ID = id; obj.Series1Start = Convert.ToInt64(txtSeries1Start.Text.Trim()); obj.Series1End = Convert.ToInt64(txtSeries1End.Text.Trim()); obj.Series2Start = txtSeries2Start.Text.Trim().ToUpper(); obj.Series2End = txtSeries2End.Text.Trim().ToUpper(); obj.NumStart = Convert.ToInt64(txtStartNumber.Text.Trim()); obj.NumEnd = Convert.ToInt64(txtEndNumber.Text.Trim()); obj.ReqId = Convert.ToInt32(ddlReqNo.SelectedItem.Value); bool insertResult = obj.ID == default(long) ? objLtmsService.InsertInSeriesGeneration(obj, out InsertedId) : objLtmsService.UpdateInSeriesGeneration(obj); if (insertResult) { ScriptManager.RegisterStartupScript(this, GetType(), "MyMsg", string.Format("alert('Lot information have been {0} successfully.');", (obj.ID == default(long) ? "saved" : "updated")), true); btnCancel_Click(sender, e); btnGo_Click(sender, e); } else { throw new Exception("Unable to save data"); } } 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); btnCancel_Click(sender, e); } }
public bool UpdateInSeriesGeneration(ClsSeriesGeneration obj) { return(objBusinessLogicDbTrx.UpdateInSeriesGeneration(obj)); }
public bool InsertInSeriesGeneration(ClsSeriesGeneration obj, out string InsertedID) { return(objBusinessLogicDbTrx.InsertInSeriesGeneration(obj, out InsertedID)); }
public string ValidateTicketNo(ClsTicketInventory objGeneratedNo, string Ticketno, DataTable dt = null) { string ErrorMsg = "", AlphabetSeries = ""; int TicketLength = 0, FnEndLength = 0, AlphabetSeriesLength = 0, TnEndLength = 0; string StartNo = "", Alphabet = "", EndNo = ""; // Check for Ticket Length AlphabetSeries = objGeneratedNo.AlphabetSeries; string[] values = AlphabetSeries.Split(','); string finTktAlphabet = string.Empty; long finTktLastSeries = default(long); List <ClsSeriesGeneration> lst = new List <ClsSeriesGeneration>(); List <ClsSeriesGeneration> fltr1 = new List <ClsSeriesGeneration>(); FnEndLength = (objGeneratedNo.FnEnd == 0 ? 0 : objGeneratedNo.FnEnd.ToString().Length);//objGeneratedNo.FnEnd.ToString().Length; TnEndLength = objGeneratedNo.TnEnd.ToString().Length; AlphabetSeriesLength = values[values.Length - 1].ToString().Trim().Length; if (Ticketno.Trim().Length > 0) { try { finTktAlphabet = Ticketno.Substring(FnEndLength, AlphabetSeriesLength); long.TryParse(Ticketno.Substring((FnEndLength + AlphabetSeriesLength), (Ticketno.Trim().Length - (FnEndLength + AlphabetSeriesLength))), out finTktLastSeries); /*var res = from row in dt.AsEnumerable() * where row.Field<long>("NumStart") <= finTktLastSeries && row.Field<long>("NumEnd") > finTktLastSeries * select row;*/ if (dt != null) { for (int i = 0; i < dt.Rows.Count; i++) { var obj = new ClsSeriesGeneration(); obj.ID = Convert.ToInt64(dt.Rows[i]["ID"]); obj.ReqId = Convert.ToInt32(dt.Rows[i]["ReqId"]); obj.Series1Start = Convert.ToInt64(dt.Rows[i]["Series1Start"]); obj.Series1End = Convert.ToInt64(dt.Rows[i]["Series1End"]); obj.Series2Start = Convert.ToString(dt.Rows[i]["Series2Start"]); obj.Series2End = Convert.ToString(dt.Rows[i]["Series2End"]); obj.NumStart = Convert.ToInt64(dt.Rows[i]["NumStart"]); obj.NumEnd = Convert.ToInt64(dt.Rows[i]["NumEnd"]); lst.Add(obj); } fltr1 = lst.Where(l => l.NumStart <= finTktLastSeries && l.NumEnd >= finTktLastSeries).ToList(); if (fltr1.Count() > default(int)) { foreach (var item in fltr1) { var alpSries = values.Slice(Array.FindIndex(values, m => m == item.Series2Start), (Array.FindIndex(values, m => m == item.Series2End) + 1)); var results = Array.FindAll(alpSries, s => s.Equals(finTktAlphabet)); if (results != null && results.Length > default(int)) { objGeneratedNo.FnStart = Convert.ToInt32(item.Series1Start); objGeneratedNo.FnEnd = Convert.ToInt32(item.Series1End); objGeneratedNo.TnStart = item.NumStart; objGeneratedNo.TnEnd = item.NumEnd; FnEndLength = (objGeneratedNo.FnEnd == 0 ? 0 : objGeneratedNo.FnEnd.ToString().Length); TnEndLength = objGeneratedNo.TnEnd.ToString().Length; break; } } } } } catch { } TicketLength = (objGeneratedNo.FnEnd == 0 ? 0 : FnEndLength) + AlphabetSeriesLength + TnEndLength; if (Ticketno.Trim().Length != TicketLength) { ErrorMsg = "Invalid Ticket No. No of characters in Ticket should be " + TicketLength + " for ticket no " + Ticketno; return(ErrorMsg); } if (objGeneratedNo.FnEnd > 0) { StartNo = Ticketno.Substring(0, FnEndLength); if (IsIntegerWithZero(StartNo) == false) { ErrorMsg = "Invalid Ticket No. First " + FnEndLength + " No sholud be should numeric and less thar or equal to " + objGeneratedNo.FnEnd + " for ticket no " + Ticketno; return(ErrorMsg); } if ((Convert.ToInt16(StartNo) <= objGeneratedNo.FnEnd) == false) { ErrorMsg = "Invalid Ticket No. First " + FnEndLength + " No sholud be should be less than or equal to " + objGeneratedNo.FnEnd + " for ticket no " + Ticketno; return(ErrorMsg); } } bool IsFound = false; for (int aCnt = 0; aCnt < values.Length; aCnt++) { Alphabet = Ticketno.Substring(FnEndLength, (TicketLength - (FnEndLength + TnEndLength))); if (Alphabet == values[aCnt].ToString().Trim() == true) { IsFound = true; break; } } if (IsFound == false) { ErrorMsg = "Invalid Ticket No. Alphabet charcter sholud be among " + AlphabetSeries + " for ticket no " + Ticketno; return(ErrorMsg); } EndNo = Ticketno.Substring(Ticketno.Length - TnEndLength, TnEndLength); if (IsLongIntegerWithZero(EndNo) == false) { ErrorMsg = "Invalid Ticket No. Last " + TnEndLength + " No sholud be should numeric and less thar or equal to " + objGeneratedNo.TnEnd + " for ticket no " + Ticketno; return(ErrorMsg); } if ((Convert.ToInt64(EndNo) <= objGeneratedNo.TnEnd) == false) { ErrorMsg = "Invalid Ticket No. Last " + TnEndLength + " No sholud be should be less than or equal to " + objGeneratedNo.TnEnd + " for ticket no " + Ticketno; return(ErrorMsg); } } return(ErrorMsg); }