Esempio n. 1
0
        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);
            }
        }
Esempio n. 2
0
 public bool UpdateInSeriesGeneration(ClsSeriesGeneration obj)
 {
     return(objBusinessLogicDbTrx.UpdateInSeriesGeneration(obj));
 }
Esempio n. 3
0
 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);
        }