public DataTable UpdateStreet(EditStreetModel entity)
        {
            SqlParameter[] _SqlParameter = new SqlParameter[2];

            _SqlParameter[0]       = new SqlParameter("@StreetId", SqlDbType.VarChar);
            _SqlParameter[0].Value = Convert.ToString(entity.StreetId);
            _SqlParameter[1]       = new SqlParameter("@StreetName", SqlDbType.VarChar);
            _SqlParameter[1].Value = Convert.ToString(entity.StreetName);

            DataTable ds = conn.executeSelectQueryWithSPNew("NSP_UpdateStreet", _SqlParameter);

            return(ds);
        }//..End UpdateCustomer
        }//..Update User

        public ActionResult EditStreet(int id)
        {
            if (Session["Email"] != null && Session["UserID"] != null)
            {
                ViewBag.ActiveMenu = "AddStreet";
                String    userEmail = Session["Email"].ToString();
                DataTable dt        = _StreetService.ViewStreetList();
                List <EditStreetModel> StreetList       = CommonService.ConvertToList <EditStreetModel>(dt);
                EditStreetModel        _EditStreetModel = StreetList.Find(uid => uid.StreetId == id);

                return(View(_EditStreetModel));
            }
            else
            {
                return(RedirectToAction("Login", "Account"));
            }
        }//..End of Edit Customer
        }//..End CustomerList

        public ActionResult UpdateStreet(EditStreetModel model)
        {
            if (ModelState.IsValid)
            {
                try
                {
                    _StreetService.UpdateStreet(model);
                    TempData["Success"] = "Success";
                    return(RedirectToAction("StreetList"));
                }
                catch (Exception e)
                {
                    Response.StatusCode = (int)HttpStatusCode.BadRequest;
                    ModelState.AddModelError("", e.Message);
                    TempData["Fail"] = "Fail";
                    return(View("StreetList", model));
                }
            }
            else
            {
                TempData["ModelsError"] = "Error";
                return(RedirectToAction("StreetList"));
            }
        }//..Update User