/// <summary> /// Render partial view for Initial Identification Page /// </summary> /// <param name="bookType">The type of booking School / Adult / University</param> /// <returns>Partial view with Model</returns> public PartialViewResult InitialIdentification(string bookType) { ViewBag.rootUrl = string.Format("{0}://{1}{2}", Request.Url.Scheme, Request.Url.Authority, Url.Content("~")); if (bookType.Equals(TOURCATEGORY.SCHOOL)) { Session["idList"] = new List <int>(); SchoolModel school = new SchoolModel(); school.SubjectList = jsonDataController.GetJsonData_SubjectAreaList(); school.YearList = jsonDataController.GetJsonData_YearGroupList(); school.type = bookType; return(PartialView(CONSTVALUE.PARTIAL_VIEW_SCHOOL_FOLDER + "_SchoolVisit.cshtml", school)); } else if (bookType.Equals(TOURCATEGORY.ADULT)) { AdultModel adult = new AdultModel(); adult.type = bookType; adult.ProgramList = jsonDataController.GetJsonData_EventNameList(TOURCATEGORY.ADULT); return(PartialView(CONSTVALUE.PARTIAL_VIEW_ADULT_FOLDER + "_AdultVisit.cshtml", adult)); } else if (bookType.Equals(TOURCATEGORY.UNIVERSITY)) { UniversityModel uni = new UniversityModel(); uni.type = bookType; uni.ProgramList = jsonDataController.GetJsonData_EventNameList(TOURCATEGORY.UNIVERSITY); return(PartialView(CONSTVALUE.PARTIAL_VIEW_UNIVERSITY_FOLDER + "_UniVisit.cshtml", uni)); } // Return page not found return(null); }
// update public bool UpdateUniversity(int id, UniversityModel university) { using (AttenderEntities ef = new AttenderEntities()) { University updateUniversity = ef.Universities.FirstOrDefault(a => a.Id == id); if (updateUniversity == null) { return(false); } //updateUniversity.Id = university.Id; updateUniversity.Name = university.Name; updateUniversity.Country = university.Country; updateUniversity.City = university.City; updateUniversity.Address = university.Address; updateUniversity.Zip = university.Zip; updateUniversity.Site = university.Site; updateUniversity.PhoneNumber = university.PhoneNumber; try{ // ef.Database.ExecuteSqlCommand($"UPDATE [dbo].[University] SET [Name] = {updateUniversity.Name}, [Country] = {updateUniversity.Country},[City] = { updateUniversity.City}, [Address] = { updateUniversity.Address}, [Zip] = { updateUniversity.Zip}, [Site] = { updateUniversity.Site}, [PhoneNumber] = { updateUniversity.PhoneNumber} WHERE [Id] = {id}"); ef.SaveChanges(); } catch { return(false); } } return(true); }
public ActionResult PostInvoice_University(UniversityModel uni) { if (ModelState.IsValid) { contentController.SetPostInvoice_University(uni); uni = contentController.GetModelById_University(uni.Id); //Create new contact with primary category as schools and contacttype as organisation uni.SerialNumber = jsonDataController.CreateNewOrganisationContactOnThankQ <UniversityModel>(uni); //Save Group Coordinator and Invoicee on ThankQ BD jsonDataController.CreateNewContactOnThankQ <UniversityModel>(uni); //Create new Tour Booking Record on ThankQ DB uni.TourBookingID = jsonDataController.CreateNewTourBookingOnThankQ <UniversityModel>(uni); //Create new Attendee Summary on ThankQ DB jsonDataController.CreateNewTourBookingAttendeeSummaryOnThankQ <UniversityModel>(uni); //Save booking record on Umbraco CMS contentController.SetPostAdditionalBooking_University(uni); NameValueCollection routeValues = new NameValueCollection(); routeValues.Add("mainBookingId", uni.Id.ToString()); routeValues.Add("type", TOURCATEGORY.UNIVERSITY); return(RedirectToUmbracoPage(CONSTVALUE.BOOK_COMPLETION_CONTENT_ID, routeValues)); } return(CurrentUmbracoPage()); }
public void CreateNewContactOnThankQ <T>(BaseModel model) { if (typeof(T).Equals(new SchoolModel().GetType())) { SchoolModel school = (SchoolModel)model; if (school.Event.IsSameContact) { school.Event.GroupCoordinator.SerialNumber = PostJsonData_NewContact <SchoolModel>(school, CONTACTTYPE.INDIVIDUAL, INDIVISUALTYPE.GROUPCOORDINATOR).Trim('"'); school.Event.Invoice.SerialNumber = school.Event.GroupCoordinator.SerialNumber; } else { school.Event.GroupCoordinator.SerialNumber = PostJsonData_NewContact <SchoolModel>(school, CONTACTTYPE.INDIVIDUAL, INDIVISUALTYPE.GROUPCOORDINATOR).Trim('"'); school.Event.Invoice.SerialNumber = PostJsonData_NewContact <SchoolModel>(school, CONTACTTYPE.INDIVIDUAL, INDIVISUALTYPE.INVOICEE).Trim('"'); } } else if (typeof(T).Equals(new AdultModel().GetType())) { AdultModel adult = (AdultModel)model; adult.Event.GroupCoordinator.SerialNumber = PostJsonData_NewContact <AdultModel>(adult, CONTACTTYPE.INDIVIDUAL, INDIVISUALTYPE.GROUPCOORDINATOR).Trim('"'); if (adult.Event.IsInvoiceOnly) { adult.Event.Invoice.SerialNumber = PostJsonData_NewContact <AdultModel>(adult, CONTACTTYPE.INDIVIDUAL, INDIVISUALTYPE.INVOICEE).Trim('"'); } } else if (typeof(T).Equals(new UniversityModel().GetType())) { UniversityModel uni = (UniversityModel)model; uni.Event.GroupCoordinator.SerialNumber = PostJsonData_NewContact <UniversityModel>(uni, CONTACTTYPE.INDIVIDUAL, INDIVISUALTYPE.GROUPCOORDINATOR).Trim('"'); uni.Event.Invoice.SerialNumber = PostJsonData_NewContact <UniversityModel>(uni, CONTACTTYPE.INDIVIDUAL, INDIVISUALTYPE.INVOICEE).Trim('"'); } }
// Create; public bool AddUniversity(UniversityModel newUniversity) { using (AttenderEntities ef = new AttenderEntities()) { University university = new University() { // Id = newUniversity.Id, Name = newUniversity.Name, Country = newUniversity.Country, City = newUniversity.City, Address = newUniversity.Address, Zip = newUniversity.Zip, Site = newUniversity.Site, PhoneNumber = newUniversity.PhoneNumber }; ef.Universities.Add(university); try{ //ef.Database.ExecuteSqlCommand($"INSERT INTO [dbo].[University] ([Name],[Country],[City],[Address],[Zip],[Site],[PhoneNumber]) VALUES ({university.Name} , {university.Country} , {university.City}, {university.Address} , {university.Zip}, {university.Site} , {university.PhoneNumber})"); ef.SaveChanges(); } catch { return(false); } } return(true); }
// GET: University public ActionResult Index() { if (Session["PERSONAL_NO"] != null) { UniversityModel model = new UniversityModel(); UniversityDS source = new UniversityDS(); DataSet ds = new DataSet(); List <UniversityModel> dataList = new List <UniversityModel>(); ds = source.GetListOfUniversities(); foreach (DataRow dr in ds.Tables[0].Rows) { UniversityModel u = new UniversityModel { UniversityCode = dr["UNIVERSITY_ID"].ToString(), UniversityName = dr["UNIVERSITY_NAME"].ToString(), UniversityArea = dr["CITY"].ToString() }; dataList.Add(u); } model.ListUniversity = dataList; return(View(model)); } else { return(RedirectToAction("Index", "Login", new { area = "" })); } }
private void MapInvoiceeContact_University(API_CONTACT contact, UniversityModel model) { contact.PRIMARYCATEGORY = CONTACTTYPE.INDIVIDUAL; contact.FIRSTNAME = model.Event.Invoice.FirstName; contact.KEYNAME = model.Event.Invoice.SureName; contact.TITLE = model.Event.Invoice.Title; contact.EMAILADDRESS = model.Event.Invoice.Email; }
/// <summary> /// Get the selected university program name id based on selected name name /// </summary> /// <param name="uni"></param> /// <returns>program id</returns> public int GetUniProgramDropdownList_SelectedID(UniversityModel uni) { return(ApplicationContext.Services.DataTypeService .GetPreValuesCollectionByDataTypeId(UNI_PROGRAM_DROPDOWNLIST_KEY) .PreValuesAsDictionary .Where(m => m.Value.Value.Equals(uni.Program)) .Select(m => m.Value.Id) .First()); }
public ActionResult PostConfirm_University(UniversityModel uni) { uni = contentController.GetModelById_University(uni.Id); NameValueCollection routeValues = new NameValueCollection(); routeValues.Add("id", uni.Id.ToString()); return(RedirectToUmbracoPage(contentController.GetContentIDByName("UniversityDetail"), routeValues)); }
public IHttpActionResult Get([FromUri] int id) { UniversityModel university = universityBll.GetUniversityById(id); if (university != null) { return(Ok(university)); } return(NotFound()); }
public IActionResult GuardarUniverity(UniversityModel model) { if (string.IsNullOrWhiteSpace(model.Address.Address1) || string.IsNullOrWhiteSpace(model.Communication.CommunicationEmail)) { EnviarMensaje.Enviar(TempData, "red", "Dirección 1 y el Email son requeridos"); ViewBag.Status = new SelectList(_status.Status, "StatusId", "StatusName"); ViewBag.AddressType = new SelectList(_addressType.addressTypes, "AddressTypeId", "AddressTypeName"); ViewBag.Country = new SelectList(_country.GetAll, "CountryId", "CountryName"); ViewBag.Province = new SelectList(_province.Provinces, "ProvinceId", "ProvinceName"); ViewBag.City = new SelectList(_city.Cities, "CityId", "CityName"); return(View("Crear")); } if (ModelState.IsValid) { var university = CopyPropierties.Convert <UniversityModel, University>(model); try { _university.Save(university); } catch (Exception e) { return(View("Index", _university.Universities)); } } else { var errors = ModelState.Select(x => x.Value.Errors).FirstOrDefault(x => x.Count > 0).First(); EnviarMensaje.Enviar(TempData, "red", errors.ErrorMessage); if (model.UniversityId != null) { return(RedirectToAction("Editar", new { id = model.UniversityId })); } ViewBag.Status = new SelectList(_status.Status, "StatusId", "StatusName"); ViewBag.AddressType = new SelectList(_addressType.addressTypes, "AddressTypeId", "AddressTypeName"); ViewBag.Country = new SelectList(_country.GetAll, "CountryId", "CountryName"); ViewBag.Province = new SelectList(_province.Provinces, "ProvinceId", "ProvinceName"); ViewBag.City = new SelectList(_city.Cities, "CityId", "CityName"); return(View("Crear")); } return(View("Index", _university.Universities)); }
internal void SetPostAdditionalBooking_University(UniversityModel uni) { var uniRecord = Services.ContentService.GetById(uni.Id); uniRecord.SetValue("tourBookingID", uni.TourBookingID); uniRecord.SetValue("groupCoordinatorSerialNumber", uni.Event.GroupCoordinator.SerialNumber); uniRecord.SetValue("invoiceeSerialNumber", uni.Event.Invoice.SerialNumber); uniRecord.SetValue("paymentFingerprint", uni.Payment.EPS_FINGERPRINT); uniRecord.SetValue("uniSerialNumber", uni.SerialNumber); Services.ContentService.Save(uniRecord); }
public ActionResult PostInitialPage_University(UniversityModel uni) { if (ModelState.IsValid) { contentController.SetPostInitialPage_University(uni, CurrentPage); NameValueCollection routeValues = new NameValueCollection(); routeValues.Add("id", uni.Id.ToString()); return(RedirectToUmbracoPage(contentController.GetContentIDByName("University Calendar Form"), routeValues)); } return(CurrentUmbracoPage()); }
public ActionResult PostCalendarForm_University(UniversityModel uni) { SetAttendeeDetail_School_Uni(uni); uni.Event.AdditionalInfo.StaffTotalCost = GetTotalPrice(uni.StaffNumber, uni.GetStaffAttendeeCost()).ToString("c2"); uni.Event.AdditionalInfo.TotalCost = GetTotalPrice(uni.StudentNumber, uni.GetStudentAttendeeCost()).ToString("c2"); contentController.SetPostCalendarForm_University(uni); NameValueCollection routeValues = new NameValueCollection(); routeValues.Add("id", uni.Id.ToString()); return(RedirectToUmbracoPage(contentController.GetContentIDByName("UniversityConfirm"), routeValues)); }
public IHttpActionResult GetByCode(string universityId) { UniversityModel university = uData.GetByCode(universityId); if (university == null) { return(NotFound()); } return(Ok(university)); }
public ActionResult Delete(int id, UniversityModel _delUniversityModel) { if (ModelState.IsValid) { _delUniversityModel = _dbContext.tbl_university.Find(id); _dbContext.tbl_university.Remove(_delUniversityModel); _dbContext.SaveChanges(); return(RedirectToAction("/University")); } ModelState.AddModelError("", "Cannot delete university info, please try again"); return(View(_delUniversityModel)); }
public IHttpActionResult GetUniversity(int id) { University university = db.University.Find(id); if (university == null) { return(NotFound()); } UniversityModel universityModel = _modelFactory.Create(university); return(Ok(universityModel)); }
public IHttpActionResult Put([FromUri] int id, [FromBody] UniversityModel value) { if (ModelState.IsValid) { bool succsess = universityBll.UpdateUniversity(id, value); if (succsess) { return(Ok()); } } return(BadRequest()); }
private ModelLocator() { SessionModel = new SessionModel(); CourseModel = new CourseModel(); ExamModel = new ExamModel(); FacultyModel = new FacultyModel(); PostModel = new PostModel(); ProgrammeModel = new ProgrammeModel(); UniversityModel = new UniversityModel(); UserModel = new UserModel(); SemesterModel = new SemesterModel(); LogModel = new LogModel(); }
internal void SetPostInvoice_University(UniversityModel uni) { var adultRecord = Services.ContentService.GetById(uni.Id); adultRecord.SetValue("invoiceTitle", uni.Event.Invoice.Title); adultRecord.SetValue("invoiceFirstName", uni.Event.Invoice.FirstName); adultRecord.SetValue("invoiceSurename", uni.Event.Invoice.SureName); adultRecord.SetValue("invoiceEmail", uni.Event.Invoice.Email); adultRecord.SetValue("invoiceJobTitle", uni.Event.Invoice.JobTitle); adultRecord.SetValue("invoiceInstitution", uni.Event.Invoice.Institution); adultRecord.SetValue("invoicePhone", uni.Event.Invoice.Phone); Services.ContentService.Save(adultRecord); }
public IHttpActionResult PostUniversity([FromBody] University university) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.University.Add(university); db.SaveChanges(); UniversityModel universityModel = _modelFactory.Create(university); return(CreatedAtRoute("GetUniversity", new { id = university.ID }, universityModel)); }
public string CreateNewTourBookingOnThankQ <T>(BaseModel model) { API_TOURBOOKING tourBooking = new API_TOURBOOKING(); tourBooking.REFERENCE = ""; tourBooking.TOURID = model.Event.id; tourBooking.STARTDATE = Convert.ToDateTime(model.Event.start).ToShortDateString(); tourBooking.STARTTIME = Convert.ToDateTime(model.Event.start).ToString("HH:mm:ffff"); tourBooking.ENDDATE = Convert.ToDateTime(model.Event.end).ToShortDateString(); tourBooking.ENDTIME = Convert.ToDateTime(model.Event.end).ToString("HH:mm:ffff"); tourBooking.STATUS = TOURBOOKINGSTATUS.BOOKED; tourBooking.BOOKERSERIALNUMBER = model.Event.GroupCoordinator.SerialNumber; tourBooking.INVOICEESERIALNUMBER = model.Event.Invoice.SerialNumber; tourBooking.BOOKINGCOMMENT = model.Comments; if (typeof(T).Equals(new SchoolModel().GetType())) { SchoolModel school = (SchoolModel)model; float totalCost = GetTotalPrice(school.StudentsNumber, school.GetStudentAttendeeCost()) + GetTotalPrice(school.StaffNumber, school.GetStaffAttendeeCost()); tourBooking.FORSERIALNUMBER = school.SerialNumber; tourBooking.TOTALCOST = totalCost; tourBooking.YEARGROUP = school.Year; tourBooking.SUBJECT = school.SubjectArea; return(PostJsonData_NewTourBooking(school.Event.id, tourBooking).Trim('"')); } else if (typeof(T).Equals(new AdultModel().GetType())) { AdultModel adult = (AdultModel)model; float totalCost = GetTotalPrice(adult.AdultNumber, adult.GetAdultAttendeeCost()); tourBooking.FORSERIALNUMBER = adult.Event.GroupCoordinator.SerialNumber; //Need Clarifiction tourBooking.TOTALCOST = totalCost; tourBooking.YEARGROUP = TOURCATEGORY.ADULT; return(PostJsonData_NewTourBooking(adult.Event.id, tourBooking).Trim('"')); } else if (typeof(T).Equals(new UniversityModel().GetType())) { UniversityModel uni = (UniversityModel)model; float totalCost = GetTotalPrice(uni.StudentNumber, uni.GetStudentAttendeeCost()) + GetTotalPrice(uni.StaffNumber, uni.GetStaffAttendeeCost()); tourBooking.FORSERIALNUMBER = uni.SerialNumber; tourBooking.TOTALCOST = totalCost; tourBooking.YEARGROUP = TOURCATEGORY.UNIVERSITY; return(PostJsonData_NewTourBooking(uni.Event.id, tourBooking).Trim('"')); } return(null); }
private void MapCoordinatorContact_University(API_CONTACT contact, UniversityModel model) { contact.PRIMARYCATEGORY = CONTACTTYPE.INDIVIDUAL; contact.FIRSTNAME = model.Event.GroupCoordinator.FirstName; contact.KEYNAME = model.Event.GroupCoordinator.SureName; contact.TITLE = model.Event.GroupCoordinator.Title; contact.EMAILADDRESS = model.Event.GroupCoordinator.Email; contact.MOBILENUMBER = model.Event.GroupCoordinator.Mobile; contact.DAYTELEPHONE = model.Event.GroupCoordinator.DaytimeNumber; contact.ADDRESSLINE1 = model.Event.GroupCoordinator.Address; contact.SUBURB = model.Event.GroupCoordinator.Suburb; contact.STATE = model.Event.GroupCoordinator.State; contact.POSTCODE = model.Event.GroupCoordinator.Postcode; }
public PartialViewResult BookCompletion(string type, string mainBookingId) { ViewBag.rootUrl = string.Format("{0}://{1}{2}", Request.Url.Scheme, Request.Url.Authority, Url.Content("~")); int result; if (!Int32.TryParse(mainBookingId, out result)) { return(contentController.GetPartialView_PageNotFound()); } if (type.Equals(TOURCATEGORY.SCHOOL)) { SchoolModel school = contentController.GetModelById_School(Convert.ToInt32(mainBookingId)); if (school == null) { return(contentController.GetPartialView_PageNotFound()); } List <SchoolModel> schoolList = new List <SchoolModel>(); schoolList.Add(school); var childIdList = Services.ContentService.GetChildren(Convert.ToInt32(mainBookingId)).Select(x => x.Id).ToList(); if (childIdList == null) { return(contentController.GetPartialView_PageNotFound()); } foreach (int id in childIdList) { schoolList.Add(contentController.GetModelById_School(id)); } return(PartialView(CONSTVALUE.PARTIAL_VIEW_SCHOOL_FOLDER + "_SchoolBookCompletion.cshtml", schoolList)); } else if (type.Equals(TOURCATEGORY.ADULT)) { AdultModel adult = contentController.GetModelById_Adult(Convert.ToInt32(mainBookingId)); if (adult == null) { return(contentController.GetPartialView_PageNotFound()); } return(PartialView(CONSTVALUE.PARTIAL_VIEW_ADULT_FOLDER + "_AdultBookCompletion.cshtml", adult)); } else if (type.Equals(TOURCATEGORY.UNIVERSITY)) { UniversityModel uni = contentController.GetModelById_University(Convert.ToInt32(mainBookingId)); if (uni == null) { return(contentController.GetPartialView_PageNotFound()); } return(PartialView(CONSTVALUE.PARTIAL_VIEW_UNIVERSITY_FOLDER + "_UniBookCompletion.cshtml", uni)); } return(null); }
public IActionResult GuardarUniverity(UniversityModel model) { var university = CopyPropierties.Convert <UniversityModel, University>(model); try { _university.Save(university); } catch (Exception e) { return(View("Index", _university.Universities)); } return(View("Index", _university.Universities)); }
public IHttpActionResult Delete(string universityId) { UniversityModel university = new UniversityModel() { Code = universityId }; bool deleted = uData.Delete(university); if (!deleted) { return(BadRequest(Constants.MsgError)); } return(Ok(Constants.MsgSuccess)); }
public IHttpActionResult Create([FromBody] UniversityModel university) { if (university == null) { return(BadRequest(Constants.MsgErrorArguments)); } bool inserted = uData.Insert(university); if (!inserted) { return(BadRequest(Constants.MsgError)); } return(Ok(Constants.MsgSuccess)); }
public string CreateNewOrganisationContactOnThankQ <T>(BaseModel model) { if (typeof(T).Equals(new SchoolModel().GetType())) { SchoolModel school = (SchoolModel)model; school.SerialNumber = PostJsonData_NewContact <SchoolModel>(school, CONTACTTYPE.ORGANISATION).Trim('"'); return(school.SerialNumber); } else if (typeof(T).Equals(new UniversityModel().GetType())) { UniversityModel uni = (UniversityModel)model; uni.SerialNumber = PostJsonData_NewContact <UniversityModel>(uni, CONTACTTYPE.ORGANISATION).Trim('"'); return(uni.SerialNumber); } return("Please Define your Model"); }
public ActionResult Create(UniversityModel _universityModel) { if (ModelState.IsValid) { _universityModel.AddedDate = DateTime.Now; _universityModel.ModifiedDate = null; _universityModel.DeleteFlag = false; _universityModel.DeletedDate = DateTime.Now; _dbContext.tbl_university.Add(_universityModel); _dbContext.SaveChanges(); return(RedirectToAction("Index")); } return(View(_universityModel)); }
// GET: Admin/University/Delete/5 public ActionResult Delete(int id) { if (id == 0) { return(RedirectToAction("University")); } UniversityModel _universityModel = _dbContext.tbl_university.Find(id); if (_universityModel == null) { return(RedirectToAction("University")); } return(View(_universityModel)); }