public void Post([FromBody] string value) { var person = new tbl_Person { // ... } return(helper.InsertPerson(person)); }
public int InsertPerson(tbl_Person person) { try { db.tbl_Person.Add(person); db.SaveChanges(); return(person.PersonID); } catch { return(0); } }
public ActionResult Edit(PersonVM viewModel) { try { var UserProfile = (UserProfileSessionData)this.Session["UserProfile"]; if (UserProfile != null) { if (ModelState.IsValid) { tbl_Person person = new tbl_Person() { ID = viewModel.ID, PIN = viewModel.PIN, Name = viewModel.FirstName, Surname = viewModel.LastName, Fathername = viewModel.FatherName, Gender = viewModel.GenderType, PersonType = viewModel.PersonType, Description = viewModel.Description, Address = viewModel.Address, UpdateDate = DateTime.Now, UpdateUser = UserProfile.UserId }; DataOperations operations = new DataOperations(); tbl_Person personDB = operations.UpdatePerson(person); if (personDB != null) { TempData["success"] = "Ok"; TempData["message"] = "Məlumatlar uğurla dəyişdirildi"; return(RedirectToAction("Index")); } else { TempData["success"] = "notOk"; TempData["message"] = "Məlumatlar dəyişdirilərkən xəta baş verdi"; return(RedirectToAction("Index")); } } } throw new ApplicationException("Invalid model"); } catch (ApplicationException ex) { return(View(viewModel)); } }
public ActionResult Create(PersonVM viewModel) { try { var UserProfile = (UserProfileSessionData)this.Session["UserProfile"]; if (UserProfile != null) { tbl_Person person = new tbl_Person() { PIN = viewModel.PIN, Name = viewModel.FirstName, Surname = viewModel.LastName, Fathername = viewModel.FatherName, Gender = viewModel.GenderType, Description = viewModel.Description, Address = viewModel.Address, PersonType = viewModel.PersonType, InsertDate = DateTime.Now, InsertUser = UserProfile.UserId }; DataOperations operations = new DataOperations(); tbl_Person personDB = operations.AddPerson(person); if (personDB != null) { TempData["success"] = "Ok"; TempData["message"] = "Məlumatlar uğurla əlavə olundu"; return(RedirectToAction("Index")); } else { TempData["success"] = "notOk"; TempData["message"] = "Məlumatlar əlavə olunarkən xəta baş verdi"; return(RedirectToAction("Index")); } } throw new ApplicationException("Invalid model"); } catch (ApplicationException ex) { viewModel = populateDropDownList(viewModel); return(View(viewModel)); } }
public ActionResult Edit(int id) { PersonVM viewModel = new PersonVM(); DataOperations dataOperations = new DataOperations(); RegionRepository regionRepository = new RegionRepository(); tbl_Person tblItem = dataOperations.GetPersonById(id); viewModel = populateDropDownList(viewModel); viewModel.ID = id; viewModel.PIN = tblItem.PIN; viewModel.FirstName = tblItem.Name; viewModel.LastName = tblItem.Surname; viewModel.FatherName = tblItem.Fathername; viewModel.GenderType = (int)tblItem.Gender; viewModel.PersonType = (int)tblItem.PersonType; viewModel.Address = tblItem.Address; viewModel.Description = tblItem.Description; return(View(viewModel)); }
public ActionResult PersonProfile(int personid) { var personinfo = new tbl_Person(); List <tbl_Person_Organization_Roles> personOrganizationRoles = new List <tbl_Person_Organization_Roles>(); List <tbl_Person_Degrees> Person_Degrees = new List <tbl_Person_Degrees>(); List <tbl_Person_Licenses> PersonLicenses = new List <tbl_Person_Licenses>(); List <tbl_Persons_Professions> Persons_Professions = new List <tbl_Persons_Professions>(); CeuEntities dbcontext = new CeuEntities(); var data = from p in dbcontext.tbl_Person where p.PersonID == personid select p; /*mapping for models*/ Mapper.CreateMap <tbl_Person, Models.PersonProfile>(); /*xxxxxxx*/ if (data.ToArray().Count() > 0) { personinfo = (tbl_Person)data.ToArray()[0]; } if (personinfo.tbl_Person_Organization_Roles.ToArray().Count() > 0) { personOrganizationRoles = (List <tbl_Person_Organization_Roles>)personinfo.tbl_Person_Organization_Roles.ToList(); } if (personinfo.tbl_Person_Degrees.ToArray().Count() > 0) { Person_Degrees = (List <tbl_Person_Degrees>)personinfo.tbl_Person_Degrees.ToList(); } if (personinfo.tbl_Person_Licenses.ToArray().Count() > 0) { PersonLicenses = (List <tbl_Person_Licenses>)personinfo.tbl_Person_Licenses.ToList(); } if (personinfo.tbl_Persons_Professions.ToArray().Count() > 0) { Persons_Professions = (List <tbl_Persons_Professions>)personinfo.tbl_Persons_Professions.ToList(); } Models.PersonProfile pp = new PersonProfile(); pp = Mapper.Map <tbl_Person, Models.PersonProfile>(personinfo); #region PersonDegrees List <PersonDegrees> PersonDegreeList = (from pd in dbcontext.tbl_Person_Degrees join d in dbcontext.tbl_Degrees on pd.DegreeID equals d.DegreeID where pd.PersonID == personid select new PersonDegrees { DegreeDesc = d.DegreeDesc, DegreeID = d.DegreeID, PersonID = GlobalInfo.PersonID, PersonDegreeID = pd.PersonDegreeID, selected = false }).ToList <PersonDegrees>(); #endregion #region States&Cities List <states> StatesList = ( from s in dbcontext.tbl_States select new states { Name = s.Name, ID = s.ID }).ToList <states>(); int UserStateID = Convert.ToInt32(pp.Residence_StateID); List <cities> CitiesLists = (from c in dbcontext.tbl_Cities where c.StateID == UserStateID select new cities { Name = c.Name, ID = c.ID }).ToList <cities>(); #endregion #region DOBCalendar /*loading Calenders dropdownlist*/ List <SelectListItem> year = new List <SelectListItem>(); for (int jLoop = 1900; jLoop <= DateTime.Now.Year; jLoop++) { SelectListItem sl = new SelectListItem(); sl.Text = Convert.ToString(jLoop); sl.Value = Convert.ToString(jLoop); year.Add(sl); } /*xx*/ /**/ /*fill months ddl*/ int months = CultureInfo.CurrentUICulture.DateTimeFormat.Calendar.GetMonthsInYear(pp.DateOfBirth.Value.Year); List <SelectListItem> monthscoll = new List <SelectListItem>(); for (int m = 0; m <= months; m++) { SelectListItem sl = new SelectListItem(); sl.Text = Convert.ToString(m); sl.Value = Convert.ToString(m); monthscoll.Add(sl); } /*fill Months ddl*/ int Days = CultureInfo.CurrentUICulture.DateTimeFormat.Calendar.GetDaysInMonth(pp.DateOfBirth.Value.Year, pp.DateOfBirth.Value.Month); List <SelectListItem> dayscoll = new List <SelectListItem>(); for (int d = 0; d <= Days; d++) { SelectListItem sl = new SelectListItem(); sl.Text = Convert.ToString(d); sl.Value = Convert.ToString(d); dayscoll.Add(sl); } #endregion #region GenderInfo /*Suffix ddl*/ IEnumerable <SelectListItem> Suffixcoll = from s in dbcontext.tbl_Suffixes select new SelectListItem { Text = s.SuffixDesc, Value = SqlFunctions.StringConvert((decimal?)s.SuffixID) }; /*Sex Coll*/ IEnumerable <SelectListItem> Sexcoll = from s in dbcontext.tbl_Sex select new SelectListItem { Text = s.SexDesc, Value = SqlFunctions.StringConvert((decimal?)s.SexID) }; #endregion #region Professions IEnumerable <SelectListItem> ProfList = from p in dbcontext.tbl_professions select new SelectListItem { Text = p.Profession_description, Value = SqlFunctions.StringConvert((decimal?)p.Profession_ID) }; var professionsList = new SelectList(ProfList, "Value", "Text"); #endregion #region OrganizationRoles IEnumerable <SelectListItem> Orgroles = from r in dbcontext.tbl_Roles select new SelectListItem { Text = r.RoleDesc, Value = SqlFunctions.StringConvert((decimal?)r.RoleID) }; var OrgrolesList = new SelectList(Orgroles, "Value", "Text"); #endregion #region PersonOrganization var PersonOrg = from r in dbcontext.tbl_Person_Organization_Roles join o in dbcontext.tbl_Organizations on r.OrganizationID equals o.OrganizationID where r.PersonID == personid && r.RoleTypeID == 2 select new SelectListItem { Text = o.OrganizationName, Value = SqlFunctions.StringConvert((decimal?)r.OrganizationID) }; var PersonOrgnization = new SelectList(PersonOrg, "Value", "Text"); #endregion #region SecretQuestion IEnumerable <SelectListItem> SecretQuestionList = from q in dbcontext.tbl_Secret_Questions select new SelectListItem { Text = q.SecretQuestionDesc, Value = SqlFunctions.StringConvert((decimal?)q.SecretQuestionID) }; var SecretQList = new SelectList(SecretQuestionList, "Value", "Text"); #endregion #region Organization-Specific-Security List <OrganizationSpecificSecurityInfo> dataOrgSpec = (from s in dbcontext.tbl_Person_Organization_Roles join o in dbcontext.tbl_Organizations on s.OrganizationID equals o.OrganizationID join l in dbcontext.tbl_PersonOrganizationMemberships on s.PersonID equals l.PersonID where s.PersonID == personid && s.RoleTypeID == 2 && l.OrganizationID == s.OrganizationID select new OrganizationSpecificSecurityInfo { JoinDate = l.JoinOnDate, PaidOnDate = l.PaidOnDate, IsMemberAreAllowed = (bool)(o.MembersAreAllowed), IsMemberDuesAreAllowed = (bool)(o.MembersDuesAreAllowed), ExpiryDate = l.DateMembershipExpires, Dues = l.Dues, MemberShipID = l.MembershipID, IsAdministrator = (bool)(s.RoleID == 8 ? true : false), IsRegisterUser = (bool)(s.RoleID == 7 ? true : false), isSuperUser = (bool)(s.RoleID == 9 ? true : false), OrganizationID = s.OrganizationID, Password = s.Pwd }).ToList <OrganizationSpecificSecurityInfo>(); /*Store OSSI into tempdata for later use*/ //TempData.Add("OSSIList",dataOrgSpec); Session.Add("OSSIList", dataOrgSpec); /**/ OrganizationSpecificSecurityInfo Orgspec = dataOrgSpec.Where(x => x.OrganizationID == 1).First(); pp.selectedOrganizationspecificSecurity = new OrganizationSpecificSecurityInfo(); pp.selectedOrganizationspecificSecurity = Orgspec; //pp.selectedOrganizationspecificSecurity.Dues = Convert.ToDecimal(10.2); //pp.selectedOrganizationspecificSecurity.ExpiryDate = DateTime.Now; //pp.selectedOrganizationspecificSecurity.isSuperUser = true; //pp.selectedOrganizationspecificSecurity.IsAdministrator = false; //pp.selectedOrganizationspecificSecurity.IsMember = true; //pp.selectedOrganizationspecificSecurity.JoinDate = DateTime.Now; //pp.selectedOrganizationspecificSecurity.PaidOnDate = DateTime.Now; #endregion // DataTable Dt = sinfo.CopyToDataTable(); #region ViewBags ViewBag.SuffixColl = Suffixcoll; ViewBag.SexColl = Sexcoll; ViewBag.DOBYear = year; ViewBag.DOBMonth = monthscoll; ViewBag.DOBDay = dayscoll; ViewBag.Professions = professionsList; ViewBag.Orgroles = OrgrolesList; ViewBag.SecretQuesList = SecretQList; ViewBag.PersonOrganization = PersonOrgnization; // ViewBag.PersonDegreesColl = PersonDegrees; pp.Stateslist = new SelectList(StatesList, "ID", "Name", pp.Residence_StateID); pp.CitiesList = new SelectList(CitiesLists, "ID", "Name"); pp.PersonDegreesColl = PersonDegreeList; #endregion //tbl_Person persons = dbcontext.tbl_Person.FirstOrDefault<tbl_Person>(); //personinfo.FName = "SaifIqbal"; //dbcontext.Entry(personinfo).State = System.Data.EntityState.Modified; //dbcontext.SaveChanges(); return(View(pp)); } [HttpPost] public ActionResult PersonProfile(Models.PersonProfile modeldata, List <string> PersonDegreesChkList, Models.OrganizationSpecificSecurityInfo spec) { // return View(modeldata); // CreateViewBags(GlobalInfo.PersonID,modeldata); CeuEntities ceu = new CeuEntities(); tbl_Person tbn = new tbl_Person(); ceu.tbl_Person.AddOrUpdate(t => t.PersonID, new tbl_Person { PersonID = 1, FName = "saif" }); ceu.tbl_Person.SqlQuery("update tbl_person set FName='BB' where PersonID=1", null); ceu.SaveChanges(); return(View("PersonProfile", modeldata)); } [HttpGet] public JsonResult GetCities(int?stateid) { CeuEntities dbcontext = new CeuEntities(); var citieslist = (from s in dbcontext.tbl_Cities where s.StateID == stateid select new { s.ID, s.Name }).ToList(); return(Json(citieslist, JsonRequestBehavior.AllowGet)); } [HttpGet] public JsonResult GetDays(int year, int month) { CeuEntities dbcontext = new CeuEntities(); int Days = CultureInfo.CurrentUICulture.DateTimeFormat.Calendar.GetDaysInMonth(year, month); List <SelectListItem> dayscoll = new List <SelectListItem>(); for (int d = 0; d <= Days; d++) { SelectListItem sl = new SelectListItem(); sl.Text = Convert.ToString(d); sl.Value = Convert.ToString(d); dayscoll.Add(sl); } return(Json(dayscoll, JsonRequestBehavior.AllowGet)); } public ActionResult GetProfessionDegrees(Models.PersonProfile modeldata) { //CeuEntities dbcontext = new CeuEntities(); //var profdeglist = (from s in dbcontext.tbl_Profession_Degrees // join d in dbcontext.tbl_Degrees on s.Degree_ID equals d.DegreeID // where s.Profession_ID == Profid // select new PersonDegrees {DegreeDesc = d.DegreeDesc,PersonDegreeID = s.Profession_Degree_ID,PersonID =GlobalInfo.PersonID,DegreeID = d.DegreeID,selected = false}).ToList(); //return Json(profdeglist, JsonRequestBehavior.AllowGet); return(View(modeldata)); } [HttpGet] public string checkusername(string username) { CeuEntities dbcontext = new CeuEntities(); int count = (from s in dbcontext.tbl_Person where s.UserName == username && s.PersonID != GlobalInfo.PersonID select s).Count(); string data = ""; if (count == 0) { return("Available"); } else { return("NotAvailable"); } return(data); } public ActionResult UpdateOrganizationSpecSec(Models.PersonProfile modelData, string Organization) { List <OrganizationSpecificSecurityInfo> OrgSSIList = (List <OrganizationSpecificSecurityInfo>)Session["OSSIList"]; for (int i = 0; i < OrgSSIList.Count(); i++) { if (OrgSSIList[i].OrganizationID == Convert.ToInt32(Organization)) { Mapper.CreateMap <OrganizationSpecificSecurityInfo, Models.OrganizationSpecificSecurityInfo>(); Models.OrganizationSpecificSecurityInfo org = new OrganizationSpecificSecurityInfo(); OrgSSIList[i] = Mapper.Map <OrganizationSpecificSecurityInfo, Models.OrganizationSpecificSecurityInfo>( modelData.selectedOrganizationspecificSecurity); } } return(View(modelData)); } public void CreateViewBags(int personid, PersonProfile pp) { CeuEntities dbcontext = new CeuEntities(); //#region DOBCalendar ///*loading Calenders dropdownlist*/ //List<SelectListItem> year = new List<SelectListItem>(); //for (int jLoop = 1900; jLoop <= DateTime.Now.Year; jLoop++) //{ // SelectListItem sl = new SelectListItem(); // sl.Text = Convert.ToString(jLoop); // sl.Value = Convert.ToString(jLoop); // year.Add(sl); //} ///*xx*/ ///**/ ///*fill months ddl*/ //int months = CultureInfo.CurrentUICulture.DateTimeFormat.Calendar.GetMonthsInYear(pp.DateOfBirth.Value.Year); //List<SelectListItem> monthscoll = new List<SelectListItem>(); //for (int m = 0; m <= months; m++) //{ // SelectListItem sl = new SelectListItem(); // sl.Text = Convert.ToString(m); // sl.Value = Convert.ToString(m); // monthscoll.Add(sl); //} ///*fill Months ddl*/ //int Days = CultureInfo.CurrentUICulture.DateTimeFormat.Calendar.GetDaysInMonth(pp.DateOfBirth.Value.Year, pp.DateOfBirth.Value.Month); //List<SelectListItem> dayscoll = new List<SelectListItem>(); //for (int d = 0; d <= Days; d++) //{ // SelectListItem sl = new SelectListItem(); // sl.Text = Convert.ToString(d); // sl.Value = Convert.ToString(d); // dayscoll.Add(sl); //} //#endregion #region GenderInfo /*Suffix ddl*/ IEnumerable <SelectListItem> Suffixcoll = from s in dbcontext.tbl_Suffixes select new SelectListItem { Text = s.SuffixDesc, Value = SqlFunctions.StringConvert((decimal?)s.SuffixID) }; /*Sex Coll*/ IEnumerable <SelectListItem> Sexcoll = from s in dbcontext.tbl_Sex select new SelectListItem { Text = s.SexDesc, Value = SqlFunctions.StringConvert((decimal?)s.SexID) }; #endregion #region Professions IEnumerable <SelectListItem> ProfList = from p in dbcontext.tbl_professions select new SelectListItem { Text = p.Profession_description, Value = SqlFunctions.StringConvert((decimal?)p.Profession_ID) }; var professionsList = new SelectList(ProfList, "Value", "Text"); #endregion #region OrganizationRoles IEnumerable <SelectListItem> Orgroles = from r in dbcontext.tbl_Roles select new SelectListItem { Text = r.RoleDesc, Value = SqlFunctions.StringConvert((decimal?)r.RoleID) }; var OrgrolesList = new SelectList(Orgroles, "Value", "Text"); #endregion #region PersonOrganization var PersonOrg = from r in dbcontext.tbl_Person_Organization_Roles join o in dbcontext.tbl_Organizations on r.OrganizationID equals o.OrganizationID where r.PersonID == personid && r.RoleTypeID == 2 select new SelectListItem { Text = o.OrganizationName, Value = SqlFunctions.StringConvert((decimal?)r.OrganizationID) }; var PersonOrgnization = new SelectList(PersonOrg, "Value", "Text"); #endregion #region SecretQuestion IEnumerable <SelectListItem> SecretQuestionList = from q in dbcontext.tbl_Secret_Questions select new SelectListItem { Text = q.SecretQuestionDesc, Value = SqlFunctions.StringConvert((decimal?)q.SecretQuestionID) }; var SecretQList = new SelectList(SecretQuestionList, "Value", "Text"); #endregion #region ViewBags ViewBag.SuffixColl = Suffixcoll; ViewBag.SexColl = Sexcoll; //ViewBag.DOBYear = year; //ViewBag.DOBMonth = monthscoll; //ViewBag.DOBDay = dayscoll; ViewBag.Professions = professionsList; ViewBag.Orgroles = OrgrolesList; ViewBag.SecretQuesList = SecretQList; ViewBag.PersonOrganization = PersonOrgnization; #endregion }