public IActionResult Find(string area_no, string area_na, string search_type, string submitbutton, string singarea_state)
        {
            if (!LoginUtil.CheckIfLoggedIn(HttpContext))
            {
                return(View(nameof(Index)));
            }

            StateOfRequest mState;

            if (string.IsNullOrEmpty(singarea_state))
            {
                mState = new StateOfRequest("AreaNo");
            }
            else
            {
                mState = JsonUtil.GetObjectFromJsonString <StateOfRequest>(singarea_state);
            }
            mState.StartTime = DateTime.Now;
            string temp_state = JsonUtil.SetJsonStringFromObject(mState);

            if (string.IsNullOrEmpty(area_no))
            {
                area_no = string.Empty;
            }
            area_no = area_no.Trim();

            if (string.IsNullOrEmpty(area_na))
            {
                area_na = string.Empty;
            }
            area_na = area_na.Trim();

            string sButton = submitbutton.ToUpper();

            if (sButton == "CANCEL")
            {
                temp_state = JsonUtil.SetJsonStringFromObject(mState);
                return(RedirectToAction(nameof(SingareasList), new { singarea_state = temp_state }));
            }
            if (string.IsNullOrEmpty(search_type))
            {
                // search_type not defined
                return(View());
            }

            string searchType = search_type.Trim();

            mState.OrderBy = searchType;
            Singarea singarea = new Singarea(); // new object

            singarea.AreaNo = area_no;          // for order by "AreaNo"
            singarea.AreaNa = area_na;          // for order by "AreaNa"

            List <Singarea> singareasTemp = _singareasManager.FindOnePageOfSingareasForOneSingarea(mState, singarea, -1);

            temp_state            = JsonUtil.SetJsonStringFromObject(mState);
            ViewBag.SingareaState = temp_state;

            return(View(nameof(SingareasList), singareasTemp));
        }
        // GET: Singarea/Add
        // the view of adding singareas to Singarea table
        public IActionResult Add(string singarea_state)
        {
            if (!LoginUtil.CheckIfLoggedIn(HttpContext))
            {
                return(View(nameof(Index)));
            }

            StateOfRequest mState;

            if (string.IsNullOrEmpty(singarea_state))
            {
                mState = new StateOfRequest("AreaNo");
            }
            else
            {
                mState = JsonUtil.GetObjectFromJsonString <StateOfRequest>(singarea_state);
            }

            if ((mState.IsFirstAddRecord) || (mState.OrgId == 0))
            {
                // the first id of this page became the selected original id
                // or SateOfRequest.OrgId = 0
                mState.OrgId = mState.FirstId;
            }

            mState.StartTime = DateTime.Now;
            string temp_state = JsonUtil.SetJsonStringFromObject(mState);

            ViewBag.SingareaState = temp_state; // pass the Json string to View

            Singarea singarea = new Singarea(); // create a new Singarea object

            return(View(singarea));
        }
        // GET: Singarea/5
        public async Task <IActionResult> Details(string singarea_state)
        {
            if (!LoginUtil.CheckIfLoggedIn(HttpContext))
            {
                return(View(nameof(Index)));
            }

            StateOfRequest mState;

            if (string.IsNullOrEmpty(singarea_state))
            {
                mState = new StateOfRequest("AreaNo");
            }
            else
            {
                mState = JsonUtil.GetObjectFromJsonString <StateOfRequest>(singarea_state);
            }
            Singarea singarea = await _singareasManager.FindOneSingareaById(mState.OrgId);

            if (singarea == null)
            {
                // go to previous view (List view)
                return(Redirect(HttpContext.Request.Headers["Referer"]));
            }
            else
            {
                mState.OrgId = singarea.Id;
                mState.OrgNo = singarea.AreaNo;
                string temp_state = JsonUtil.SetJsonStringFromObject(mState);

                ViewBag.SingareaState = temp_state;
                return(View(singarea));
            }
        }
Beispiel #4
0
        public static JObject ConvertSingerTypeToJsongObject(Singarea singarea, string sex)
        {
            JObject jObject = ConvertSingareaToJsongObject(singarea);

            jObject.Add("sex", sex);

            return(jObject);
        }
        public async Task <IActionResult> Edit(string submitbutton, string singarea_state, [Bind("Id", "AreaNo, AreaNa, AreaEn")] Singarea singarea)
        {
            if (!LoginUtil.CheckIfLoggedIn(HttpContext))
            {
                return(View(nameof(Index)));
            }

            StateOfRequest mState;

            if (string.IsNullOrEmpty(singarea_state))
            {
                mState = new StateOfRequest("AreaNo");
            }
            else
            {
                mState = JsonUtil.GetObjectFromJsonString <StateOfRequest>(singarea_state);
            }
            mState.StartTime = DateTime.Now;
            string temp_state = JsonUtil.SetJsonStringFromObject(mState);

            int    orgId   = mState.OrgId; // = Singarea.Id
            string sButton = submitbutton.ToUpper();

            if (sButton == "CANCEL")
            {
                temp_state = JsonUtil.SetJsonStringFromObject(mState);
                return(RedirectToAction(nameof(SingareasList), new { singarea_state = temp_state }));
            }
            if (ModelState.IsValid)
            {
                // start updating table
                int result = await _singareasManager.UpdateOneSingareaById(orgId, singarea);

                if (result == ErrorCodeModel.Succeeded)
                {
                    // succeeded to update
                    Singarea        newSingarea   = new Singarea();
                    List <Singarea> singareasTemp = _singareasManager.FindOnePageOfSingareasForOneSingarea(mState, newSingarea, orgId);
                    temp_state = JsonUtil.SetJsonStringFromObject(mState);

                    ViewBag.SingareaState = temp_state;
                    return(View(nameof(SingareasList), singareasTemp));
                }
                else
                {
                    ViewData["ErrorMessage"] = ErrorCodeModel.GetErrorMessage(result);
                }
            }
            else
            {
                // Model.IsValid = false
                ViewData["ErrorMessage"] = ErrorCodeModel.GetErrorMessage(ErrorCodeModel.ModelBindingFailed);
            }

            ViewBag.SingareaState = temp_state;
            return(View(singarea));
        }
Beispiel #6
0
        public async Task <string> Get(int id)
        {
            // get one Singarea
            Singarea singarea = await _singareasManager.FindOneSingareaById(id);

            JObject jObject = JsonUtil.ConvertSingareaToJsongObject(singarea);

            JObject returnJSON = new JObject();

            returnJSON.Add("singarea", jObject);

            return(returnJSON.ToString());
        }
Beispiel #7
0
        public static JObject ConvertSingareaToJsongObject(Singarea singarea)
        {
            JObject jObject = new JObject();

            if (singarea == null)
            {
                return(jObject);
            }

            jObject.Add("id", singarea.Id);
            jObject.Add("areaNo", singarea.AreaNo);
            jObject.Add("areaNa", singarea.AreaNa);
            jObject.Add("areaEn", singarea.AreaEn);

            return(jObject);
        }
Beispiel #8
0
        /// <summary>
        /// Adds the one singarea to table.
        /// </summary>
        /// <returns>Return the error code.</returns>
        /// <param name="singarea">Singarea.</param>
        public async Task <int> AddOneSingareaToTable(Singarea singarea)
        {
            int result = ErrorCodeModel.ErrorBecauseBugs;

            if (singarea == null)
            {
                // the data for updating is empty
                result = ErrorCodeModel.SingareaIsNull;
                return(result);
            }
            if (string.IsNullOrEmpty(singarea.AreaNo))
            {
                // the singarea no that input by user is empty
                result = ErrorCodeModel.SingareaNoIsEmpty;
                return(result);
            }
            Singarea oldSingarea = await FindOneSingareaByAreaNo(singarea.AreaNo);

            if (oldSingarea != null)
            {
                // singarea no is duplicate
                result = ErrorCodeModel.SingareaNoDuplicate;
                return(result);
            }

            using (var dbTransaction = _context.Database.BeginTransaction())
            {
                try
                {
                    _context.Add(singarea);
                    await _context.SaveChangesAsync();

                    dbTransaction.Commit();
                    result = ErrorCodeModel.Succeeded;
                }
                catch (DbUpdateException ex)
                {
                    string errorMsg = ex.ToString();
                    Console.WriteLine("Failed to add one singarea: \n" + errorMsg);
                    dbTransaction.Rollback();
                    result = ErrorCodeModel.DatabaseError;
                }
            }

            return(result);
        }
        // private methods

        /// <summary>
        /// Verifies the singer.
        /// </summary>
        /// <returns>The singer.</returns>
        /// <param name="singer">Singer.</param>
        private async Task <int> VerifySinger(Singer singer)
        {
            // int result = 1; // valid by verification
            int result = ErrorCodeModel.SingareaNoNotFound;

            if (singer.AreaId >= 0)
            {
                Singarea area = await _context.Singarea.Where(x => x.Id == singer.AreaId).SingleOrDefaultAsync();

                if (area != null)
                {
                    result = 1; // found singarea
                }
            }

            return(result);
        }
Beispiel #10
0
        /// <summary>
        /// Updates the one singarea by identifier.
        /// </summary>
        /// <returns>Return the error code</returns>
        /// <param name="id">Identifier.</param>
        /// <param name="singarea">Singarea.</param>
        public async Task <int> UpdateOneSingareaById(int id, Singarea singarea)
        {
            int result = ErrorCodeModel.ErrorBecauseBugs;

            if (id == 0)
            {
                // its a bug, id of singarea cannot be 0
                result = ErrorCodeModel.ErrorBecauseBugs;
                return(result);
            }
            if (singarea == null)
            {
                // the data for updating is empty
                result = ErrorCodeModel.SingareaIsNull;
                return(result);
            }
            if (string.IsNullOrEmpty(singarea.AreaNo))
            {
                // the singarea no that input by user is empty
                result = ErrorCodeModel.SingareaNoIsEmpty;
                return(result);
            }
            Singarea newSingarea = await FindOneSingareaByAreaNo(singarea.AreaNo);

            if (newSingarea != null)
            {
                if (newSingarea.Id != id)
                {
                    // singarea no is duplicate
                    result = ErrorCodeModel.SingareaNoDuplicate;
                    return(result);
                }
            }

            Singarea orgSingarea = await FindOneSingareaById(id);

            if (orgSingarea == null)
            {
                // the original singarea does not exist any more
                result = ErrorCodeModel.OriginalSingareaNotExist;
                return(result);
            }
            else
            {
                orgSingarea.CopyColumnsFrom(singarea);

                // check if entry state changed
                if ((_context.Entry(orgSingarea).State) == EntityState.Modified)
                {
                    using (var dbTransaction = _context.Database.BeginTransaction())
                    {
                        try
                        {
                            await _context.SaveChangesAsync();

                            dbTransaction.Commit();
                            result = ErrorCodeModel.Succeeded; // succeeded to update
                        }
                        catch (DbUpdateException ex)
                        {
                            string msg = ex.ToString();
                            Console.WriteLine("Failed to update singarea table: \n" + msg);
                            dbTransaction.Rollback();
                            result = ErrorCodeModel.DatabaseError;
                        }
                    }
                }
                else
                {
                    result = ErrorCodeModel.SingareaNotChanged; // no changed
                }
            }

            return(result);
        }
Beispiel #11
0
        /// <summary>
        /// Finds the one singarea by identifier.
        /// </summary>
        /// <returns>The one singarea by identifier (Singarea.Id).</returns>
        /// <param name="id">the id of the singarea.</param>
        public async Task <Singarea> FindOneSingareaById(int id)
        {
            Singarea singarea = await _context.Singarea.Where(x => x.Id == id).SingleOrDefaultAsync();

            return(singarea);
        }
Beispiel #12
0
        /// <summary>
        /// Finds the one singarea by singarea no.
        /// </summary>
        /// <returns>The one singarea by singarea no.</returns>
        /// <param name="area_no">Singarea no.</param>
        public async Task <Singarea> FindOneSingareaByAreaNo(string area_no)
        {
            Singarea singarea = await _context.Singarea.Where(x => x.AreaNo == area_no).SingleOrDefaultAsync();

            return(singarea);
        }
Beispiel #13
0
        /// <summary>
        /// Finds the one page of singareas for one singarea.
        /// </summary>
        /// <returns>The one page of singareas for one singarea.</returns>
        /// <param name="mState">Singarea state.</param>
        /// <param name="singarea">Singarea.</param>
        /// <param name="id">Identifier.</param>
        public List <Singarea> FindOnePageOfSingareasForOneSingarea(StateOfRequest mState, Singarea singarea, int id)
        {
            if ((mState == null) || (singarea == null))
            {
                return(new List <Singarea>());
            }
            int pageSize = mState.PageSize;

            if (pageSize <= 0)
            {
                Console.WriteLine("The value of pageSize cannot be less than 0.");
                return(new List <Singarea>());
            }

            IQueryable <Singarea> totalSingareas = GetAllSingareasIQueryable(mState);

            if (totalSingareas == null)
            {
                return(new List <Singarea>());
            }

            List <Singarea>       singareas         = null;
            Singarea              singareaWithIndex = null;
            IQueryable <Singarea> singareasTempList = null;

            string orderByParam = mState.OrderBy.Trim();

            if (id >= 0)
            {
                // There was a selected singarea
                singareasTempList = totalSingareas.Where(x => x.Id == id);
            }
            else
            {
                // No singarea selected
                if (orderByParam == "")
                {
                    int area_id = singarea.Id;
                    singareasTempList = totalSingareas.Where(x => (x.Id == area_id));
                }
                else if (orderByParam.Equals("AreaNo", StringComparison.OrdinalIgnoreCase))
                {
                    string area_no = singarea.AreaNo.Trim();
                    int    len     = area_no.Length;
                    singareasTempList = totalSingareas.Where(x => x.AreaNo.Trim().Substring(0, len) == area_no);
                }
                else if (orderByParam.Equals("AreaNa", StringComparison.OrdinalIgnoreCase))
                {
                    string area_na = singarea.AreaNa.Trim();
                    int    len     = area_na.Length;
                    singareasTempList = totalSingareas.Where(x => x.AreaNa.Trim().Substring(0, len) == area_na);
                }
                else
                {
                    // not inside range of roder by then return empty lsit
                    return(new List <Singarea>());
                }
            }

            int totalRecords = totalSingareas.Count();  // the whole singarea table

            bool isFound = true;

            singareaWithIndex = singareasTempList.FirstOrDefault(); // the first one found
            if (singareaWithIndex == null)
            {
                isFound = false;    // singarea that was assigned is not found
                if (totalRecords == 0)
                {
                    // Singarea Table is empty
                    UpdateStateOfRequest(mState, singareaWithIndex, mState.CurrentPageNo, pageSize, 0, 0, true);
                    // return empty list
                    return(new List <Singarea>());
                }
                else
                {
                    // go to last page
                    singareaWithIndex = totalSingareas.LastOrDefault();
                }
            }

            singarea.CopyFrom(singareaWithIndex);

            // find the row number of singareaWithIndex
            int tempCount = 0;

            foreach (var singareaVar in totalSingareas)
            {
                ++tempCount;    // first row number is 1
                if (singareaVar.Id == singareaWithIndex.Id)
                {
                    break;
                }
            }
            int pageNo = tempCount / pageSize;

            if ((pageNo * pageSize) != tempCount)
            {
                pageNo++;
            }

            int recordNo = (pageNo - 1) * pageSize;

            singareas = totalSingareas.Skip(recordNo).Take(pageSize).ToList();

            int totalPages = totalRecords / pageSize;

            if ((totalPages * pageSize) != totalRecords)
            {
                totalPages++;
            }

            if (isFound)
            {
                // found
                mState.OrgId = singarea.Id; // chnaged OrgId to the singarea id found
            }
            else
            {
                // not found, then it is last page and last record
                mState.OrgId = 0;   // no singarea is selected
            }
            UpdateStateOfRequest(mState, singareas.FirstOrDefault(), pageNo, pageSize, totalRecords, totalPages, true);

            return(singareas);
        }