示例#1
0
        /// <summary>
        /// Converted the database list to List<> formate to display in view
        /// </summary>
        /// <returns>list of country to GetCountryList() method</returns>
        public List <EmployeesCountry> GetCountryList()
        {
            sdirecttestdbEntities   dbEntities         = new sdirecttestdbEntities();
            List <EmployeesCountry> EmployeesCountries = dbEntities.EmployeesCountries.ToList();

            return(EmployeesCountries);
        }
示例#2
0
        public JsonResult GetStateList(int CountryId)
        {
            sdirecttestdbEntities dbEntities = new sdirecttestdbEntities();
            //getting the list of state where country table countryId is equal to state table countryId
            List <EmployeesState> StateList = dbEntities.EmployeesStates.Where(x => x.CountryID == CountryId).ToList();
            var stateList = new SelectList(StateList, "ID", "StateName");

            return(Json(new { data = stateList }, JsonRequestBehavior.AllowGet));
        }
示例#3
0
 public ActionResult Account(EmployeeData ED, HttpPostedFileBase ProfileImage)
 {
     try
     {
         if (ModelState.IsValid)
         {
             int NameID = 1;
             //created the Database Object
             sdirecttestdbEntities dbEntities = new sdirecttestdbEntities();
             //created the table object
             EmployeesDB edb = new EmployeesDB();
             edb.FullName    = ED.FullName;
             edb.Email       = ED.Email;
             edb.DateOfBirth = ED.DateOfBirth;
             edb.Address     = ED.Address;
             if (ProfileImage != null && ProfileImage.ContentLength > 0)
             {
                 //get the path where we want to store our image
                 string path = Path.Combine(Server.MapPath("~/uploads"), Path.GetFileName(ProfileImage.FileName));
                 //move the image to upload folder
                 ProfileImage.SaveAs(path);
                 ViewBag.message = "file uploaded";
             }
             edb.ImageActualName = Path.GetFileName(ProfileImage.FileName);
             string ptr = Convert.ToString(NameID + "1_");
             edb.ImageName = string.Concat(ptr, ED.ImageName);
             edb.CountryId = ED.CountryId;
             edb.StateId   = ED.StateId;
             //store the data into table
             dbEntities.EmployeesDBs.Add(edb);
             //update the table with new data
             dbEntities.SaveChanges();
             int ID = edb.UserId;
             NameID = NameID + 1;
         }
         ViewBag.CountryList = new SelectList(GetCountryList(), "ID", "CountryName");
         ModelState.Clear();
         return(View());
     }
     catch (Exception)
     {
         throw new Exception("Filed is not valid");
     }
 }