OfficeVisitCollection PopulateAddOfficeVisit() { OfficeVisitCollection coll = new OfficeVisitCollection(); using (var connection = new MySqlConnection(ConfigurationManager.ConnectionStrings[Constants.ConnectionStringName].ConnectionString)) { var result = new StudentRepository(connection).GetStudents(); var result2 = new ContactRepository(connection).GetContacts(); var result3 = new ContentCourseRepository(connection).GetContentCourses(); var result4 = new CodeOfConductViolationRepository(connection).GetCodeOfConductViolations(); var result5 = new HomeRoomRepository(connection).GetHomeRooms(); var result6 = new RemedialActionRepository(connection).GetRemedialActions(); coll.allStudents = (IEnumerable<Models.Student>)result.Result.ToArray(); coll.allReporters = coll.allHandledBys = (IEnumerable<Models.Contact>)result2.Result.ToArray(); coll.allLocations = (IEnumerable<Models.ContentCourse>)result3.Result.ToArray(); coll.allCodeViolations = (IEnumerable<Models.CodeOfConductViolation>)result4.Result.ToArray(); coll.allHomeRooms = (IEnumerable<Models.HomeRoom>)result5.Result.ToArray(); coll.allRemedials = (IEnumerable<Models.RemedialAction>)result6.Result.ToArray(); coll.StudentSelectList = new SelectList(coll.allStudents, "student_id", "student_name", null); coll.ReportersSelectList = new SelectList(coll.allReporters, "contact_id", "contact_name", null); coll.HomeRoomSelectList = new SelectList(coll.allHomeRooms, "homeroom_id", "homeroom_name", null); coll.HandleBySelectList = new SelectList(coll.allHandledBys, "contact_id", "contact_name", null); coll.LocationSelectList = new SelectList(coll.allLocations, "content_course_id", "name", null); coll.RemedialSelectList = new SelectList(coll.allRemedials, "remedial_action_id", "name", null); coll.ViolationSelectList = new SelectList(coll.allCodeViolations, "code_of_conduct_violation_id", "name", null); Session["AddVisitModel"] = coll; } return coll; }
public ActionResult ImportContacts(HttpPostedFileBase file) { string path = null; string url = null; List<CSVContacts> ContactsToDisplay = new List<CSVContacts>(); try { if (file.ContentLength > 0) { var fileName = Path.GetFileName(file.FileName); path = AppDomain.CurrentDomain.BaseDirectory + "upload\\" + fileName; file.SaveAs(path); using (var sr = new StreamReader(path)) { var reader = new CsvReader(sr); reader.Configuration.Delimiter = "\t"; reader.Configuration.IgnoreHeaderWhiteSpace = true; var records = reader.GetRecords<CSVContacts>().ToList(); try { var result = ""; var connection = new MySqlConnection(ConfigurationManager.ConnectionStrings[Constants.ConnectionStringName].ConnectionString); ContactRepository snm = new ContactRepository(connection); result = snm.ImportContacts(records); if (result == "success") { url = this.Request.UrlReferrer.AbsolutePath + "/?error=fileloaded"; return Redirect(url); } else { //do something else here. url = this.Request.UrlReferrer.AbsolutePath + "/?error=invalidfile"; return Redirect(url); } } catch (Exception ex) { url = this.Request.UrlReferrer.AbsolutePath + "/?error=invalidfile"; return Redirect(url); } } } else { url = this.Request.UrlReferrer.AbsolutePath + "/?error=invalidfile"; return Redirect(url); } } catch { url = this.Request.UrlReferrer.AbsolutePath + "/?error=invalidfile"; return Redirect(url); } }
public async System.Threading.Tasks.Task<ActionResult> EditOfficeVisit(string id) { OfficeVisitCollection coll = new OfficeVisitCollection(); using (var connection = new MySqlConnection(ConfigurationManager.ConnectionStrings[Constants.ConnectionStringName].ConnectionString)) { await connection.OpenAsync(); var result = new StudentRepository(connection).GetStudents(); var result2 = new ContactRepository(connection).GetContacts(); var result3 = new ContentCourseRepository(connection).GetContentCourses(); var result4 = new CodeOfConductViolationRepository(connection).GetCodeOfConductViolations(); var result5 = new HomeRoomRepository(connection).GetHomeRooms(); var result6 = new RemedialActionRepository(connection).GetRemedialActions(); var result7 = new OfficeVisitRepository(connection).GetOfficeVisitByID(Convert.ToInt32(id)); coll.officeVisit = result7.Result; coll.allStudents = (IEnumerable<Models.Student>)result.Result.ToArray(); coll.allReporters = coll.allHandledBys = (IEnumerable<Models.Contact>)result2.Result.ToArray(); coll.allLocations = (IEnumerable<Models.ContentCourse>)result3.Result.ToArray(); coll.allCodeViolations = (IEnumerable<Models.CodeOfConductViolation>)result4.Result.ToArray(); coll.allHomeRooms = (IEnumerable<Models.HomeRoom>)result5.Result.ToArray(); coll.allRemedials = (IEnumerable<Models.RemedialAction>)result6.Result.ToArray(); coll.remedialAction = new OfficeVisitRepository(connection).GetOfficeVisitRemedyAction(coll.officeVisit.office_visit_id); coll.CodeViolation = new OfficeVisitRepository(connection).GetOfficeVisitCodeViolation(coll.officeVisit.office_visit_id); coll.office_visit_id = coll.officeVisit.office_visit_id; coll.arrival_dt = coll.officeVisit.arrival_dt; coll.office_visit_dt = coll.officeVisit.office_visit_dt; coll.nap = coll.officeVisit.nap; coll.comments = coll.officeVisit.comments; coll.StudentSelectList = new SelectList(coll.allStudents, "student_id", "student_name", coll.officeVisit.student_id); coll.ReportersSelectList = new SelectList(coll.allReporters, "contact_id", "contact_name", coll.officeVisit.sent_by_contact_id); coll.HomeRoomSelectList = new SelectList(coll.allHomeRooms, "homeroom_id", "homeroom_name", coll.officeVisit.homeroom_id); coll.HandleBySelectList = new SelectList(coll.allHandledBys, "contact_id", "contact_name", coll.officeVisit.handled_by_contact_id); coll.LocationSelectList = new SelectList(coll.allLocations, "content_course_id", "name", coll.officeVisit.content_course_id); coll.RemedialSelectList = new SelectList(coll.allRemedials, "remedial_action_id", "name", coll.remedialAction); coll.ViolationSelectList = new SelectList(coll.allCodeViolations, "code_of_conduct_violation_id", "name", coll.CodeViolation); Session["OfficeVisitId"] = id; } return View(coll); }
public async System.Threading.Tasks.Task<ActionResult> AddProfile() { ProfileCollection coll = new ProfileCollection(); using (var connection = new MySqlConnection(ConfigurationManager.ConnectionStrings[Constants.ConnectionStringName].ConnectionString)) { await connection.OpenAsync(); var result = new ContactRepository(connection).GetContacts(); coll.allContacts = (IEnumerable<Models.Contact>)result.Result.ToArray(); coll.profilecontactselectlist = new SelectList(result.Result.ToList(), "contact_id", "contact_name", new { @required = "required" }); } return View(coll); }
// GET: AddOfficeVisit public async System.Threading.Tasks.Task<ActionResult> EditProfile(int id) { ProfileCollection coll = new ProfileCollection(); using (var connection = new MySqlConnection(ConfigurationManager.ConnectionStrings[Constants.ConnectionStringName].ConnectionString)) { await connection.OpenAsync(); var result = new ProfileRepository(connection).GetProfile(id); var result2 = new ProfileRepository(connection).GetProfiles(); var result3 = new ContactRepository(connection).GetSortedContacts(result.Result.First().contact_id.ToString()); coll.singleProfile = (IEnumerable<Models.ProfileModel>)result.Result.ToArray(); coll.allProfiles = (IEnumerable<Models.ProfileModel>)result2.Result.ToArray(); coll.profilecontactselectlist = new SelectList(result3.Result.ToList(), "contact_id", "contact_name", new { id = "TxtContact", @required = "required" }); } return View(coll); }
// GET: AddOfficeVisit public async System.Threading.Tasks.Task<ActionResult> EditContact(int id) { ContactCollection coll = new ContactCollection(); using (var connection = new MySqlConnection(ConfigurationManager.ConnectionStrings[Constants.ConnectionStringName].ConnectionString)) { await connection.OpenAsync(); var result = new ContactRepository(connection).GetContact(id); var result2 = new ContactRepository(connection).GetContacts(); var result3 = new SchoolRepository(connection).GetSortedSchools(result.Result.First().school_id.ToString()); coll.singleContact = (IEnumerable<Models.Contact>)result.Result.ToArray(); coll.allContacts = (IEnumerable<Models.Contact>)result2.Result.ToArray(); coll.schoolselectlist = new SelectList(result3.Result.ToList(), "school_id", "name", new { id = "TxtSchool", @required = "required" }); } return View(coll); }