// GET: Contact public ActionResult Index() { using (IHoneyMustardDataSource ds = DataSourceFactory.GetDataSource()) { ContactModel model = new ContactModel { Contacts = ds.Contacts //.Include(c => c.ContactType) .Select(x => new ContactCenterModel { ContactID = x.ContactID, FirstMidName = x.FirstMidName, LastName = x.LastName, EmailAddress = x.EmailAddress, Address = x.Address, TeudatZehutPassport = x.TeudatZehutPassport, CountryID = x.CountryID, Phone = x.Phone, CellPhone = x.CellPhone, }).ToList() }; return(View(model)); } }
public ActionResult GuidancePlan(NewGuidancePlanHeadPostModel model) { using (IHoneyMustardDataSource ds = HoneyMustard.Factories.DataSourceFactory.GetDataSource()) { if (ModelState.IsValid) { GuidancePlan gp = ds.GuidancePlan.SingleOrDefault(x => x.GuidancePlanID == model.GuidancePlanID); gp.IsSaved = true; gp.AuthorID = model.AuthorID; gp.DegreeID = model.DegreeID; gp.PeriodStart = model.PeriodFrom; gp.PeriodStartYear = model.YearFrom; gp.PeriodEnd = model.PeriodEnd; gp.PeriodEndYear = model.YearEnd; ds.GuidancePlan.Add(gp); ds.SaveChanges(); } else { Response.Write("modelstate not valid"); Response.End(); } return(RedirectToAction("GuidancePlan", "NewGuidancePlan")); } }
// GET: contact/Details/5 public ActionResult Details(int id) { using (IHoneyMustardDataSource ds = DataSourceFactory.GetDataSource()) { var contact = ds.Contacts.SingleOrDefault(x => x.ContactID == id); ContactCenterModel model = new ContactCenterModel { ContactID = contact.ContactID, FirstMidName = contact.FirstMidName, LastName = contact.LastName, EmailAddress = contact.EmailAddress, Address = contact.Address, CountryID = contact.CountryID, CellPhone = contact.CellPhone, Phone = contact.Phone, TeudatZehutPassport = contact.TeudatZehutPassport, contactType = ds.ContactType.Where(x => x.ContactTypeID == contact.ContactType) .Select(x => new ContactTypeModel { ContactTypeID = x.ContactTypeID, TypeDescription = x.TypeDescription }).ToList() }; return(View(model)); } }
public ActionResult ReminderDetails(int id) { using (IHoneyMustardDataSource ds = DataSourceFactory.GetDataSource()) { var reminder = ds.Reminder.SingleOrDefault(x => x.ReminderID == id); ReminderCenter model = new ReminderCenter { ReminderID = reminder.ReminderID, Subject = reminder.Subject, Details = reminder.Details, ReminderDateTime = reminder.AlertDateTime, From = ds.Contacts.Where(x => x.ContactID == reminder.From) .Select(x => new FromReminderListTableRow { ContactID = x.ContactID, FirstMidName = x.FirstMidName, LastName = x.LastName }).ToList(), To = ds.Contacts.Where(x => x.ContactID == reminder.To) .Select(x => new ToReminderListTableRow { ContactID = x.ContactID, FirstMidName = x.FirstMidName, LastName = x.LastName }).ToList() }; return(View(model)); } }
public ActionResult ContactEdit(int id, ContactCenterModel model) { using (IHoneyMustardDataSource ds = DataSourceFactory.GetDataSource()) { if (ModelState.IsValid) { foreach (ContactTypeModel contactType in model.contactType) { ds.ContactType.Single(x => x.ContactTypeID == contactType.ContactTypeID); // .TypeDescription = contactType.TypeDescription; ds.SaveChanges(); } return(RedirectToAction("DisplayContactList")); } else { var errors = ModelState.SelectMany(x => x.Value.Errors.Select(z => z.Exception)); return (RedirectToAction("Options/" + id)); } //return new HttpStatusCodeResult(HttpStatusCode.BadRequest); } }
// Post: /Finance/Employee/id public ActionResult Employee(int id) { using (IHoneyMustardDataSource ds = Factories.DataSourceFactory.GetDataSource()) { EmployeeFinanceModel model = (from employee in ds.Contacts where employee.ContactID == id select new EmployeeFinanceModel { Name = employee.FirstMidName + " " + employee.LastName, Address = employee.Address, EmailAddress = employee.EmailAddress, Phone = employee.Phone, CellPhone = employee.CellPhone, ContactID = employee.ContactID }).SingleOrDefault(); { model.Payments = ds.PayBill.Where(x => x.Contact.ContactID == id) .Select(x => new EmployeeTableRowModels { PaymentMethod = x.PaymentMethod.Method, AmountPaid = x.AmountPaid, Date = x.Date, }).ToList(); model.PaymentTypes = (from paymentMethod in ds.PaymentMethod select new SelectListItem { Value = paymentMethod.PaymentMethodID.ToString(), Text = paymentMethod.Method }).ToList(); return(View(model)); } } }
public ActionResult CreateReminder() { using (IHoneyMustardDataSource ds = DataSourceFactory.GetDataSource()) { return(View()); } }
public ActionResult Index() { using (IHoneyMustardDataSource ds = DataSourceFactory.GetDataSource()) { CourseModels model = new CourseModels { Coursess = ds.Courses.Include(c => c.Contact) .Select(x => new CourseModelsTableRow { CourseID = x.CoursesID, CourseName = x.CourseName, Module = x.Module, StartDate = x.StartDate, EndDate = x.EndDate, Credit = x.Credit, Price = x.Price, activated_date = x.activated_date, ParticapantsGender = (CourseModelsTableRow.Gender)x.Gender, Format = (CourseModelsTableRow.Location)x.Location, DayOfWeek = (CourseModelsTableRow.DaysOfWeek)x.DayOfWeek, Comment = x.Comment, TimeClassBegins = x.TimeClassBegins, TimeClassEnds = x.TimeClassEnds }).ToList() }; return(View(model)); } }
// GET: NewGuidancePlan public ActionResult GuidancePlan(int id) { using (IHoneyMustardDataSource ds = HoneyMustard.Factories.DataSourceFactory.GetDataSource()) { GuidancePlan gp = ds.GuidancePlan.Create(); gp.StudentID = id; gp.DateCreated = DateTime.Now; gp.IsSaved = false; gp.AuthorID = 1; //This is No Author in database. Number needs to change depending on ContctID for this name. gp.DegreeID = 1; //This is None in database. Number needs to change depending on DegreeID for this name. gp.PeriodStartYear = 2000; gp.PeriodEndYear = 2000; ds.GuidancePlan.Add(gp); ds.SaveChanges(); NewGuidancePlanHeadModels model = new NewGuidancePlanHeadModels { TeudatZehutPassport = gp.Student.TeudatZehutPassport, StudentName = gp.Student.LastName + ", " + gp.Student.FirstMidName, DateCreated = gp.DateCreated, GuidancePlanID = gp.GuidancePlanID }; return(View(model)); } }
public ActionResult Practising() { using (IHoneyMustardDataSource ds = DataSourceFactory.GetDataSource()) { return(View()); } }
// GET: Coursestryout/Create public ActionResult Create() { using (IHoneyMustardDataSource ds = DataSourceFactory.GetDataSource()) { ViewBag.ContactID = new SelectList(ds.Contacts, "ContactID", "FirstMidName"); return(View()); } }
public ActionResult DeleteReminderConfirmed(int id) { using (IHoneyMustardDataSource ds = DataSourceFactory.GetDataSource()) { Reminder reminder = ds.Reminder.Find(id); ds.Reminder.Remove(reminder); ds.SaveChanges(); return(RedirectToAction("DisplayReminderList")); } }
public ActionResult DeleteConfirmed(int id) { using (IHoneyMustardDataSource ds = DataSourceFactory.GetDataSource()) { Courses course = ds.Courses.Find(id); ds.Courses.Remove(course); ds.SaveChanges(); return(RedirectToAction("Index")); } }
public ActionResult DeleteConfirmed(int id) { using (IHoneyMustardDataSource ds = DataSourceFactory.GetDataSource()) { Contact contact = ds.Contacts.Find(id); ds.Contacts.Remove(contact); ds.SaveChanges(); return(RedirectToAction("DisplayContactList")); } }
protected override void Dispose(bool disposing) { using (IHoneyMustardDataSource ds = DataSourceFactory.GetDataSource()) { if (disposing) { ds.Dispose(); } base.Dispose(disposing); } }
private Courses GetDailyDeal() { using (IHoneyMustardDataSource ds = DataSourceFactory.GetDataSource()) { var course = ds.Courses .OrderBy(a => System.Guid.NewGuid()) .First(); course.Price *= 0.5m; return(course); } }
public ActionResult EditReminder(int id, EditReminderModel model) { using (IHoneyMustardDataSource ds = DataSourceFactory.GetDataSource()) { if (ModelState.IsValid) { ds.SaveChanges(); } return(RedirectToAction("DisplayReminderList")); } }
public ActionResult ContactTypesList() { using (IHoneyMustardDataSource ds = HoneyMustard.Factories.DataSourceFactory.GetDataSource()) { var contactType = ds.ContactType.Select(x => new ContactTypeModel { ContactTypeID = x.ContactTypeID, TypeDescription = x.TypeDescription, }); return(Json(contactType.ToList())); } }
public ActionResult AuthorList() { using (IHoneyMustardDataSource ds = HoneyMustard.Factories.DataSourceFactory.GetDataSource()) { var contacts = ds.ContactJoin.Where(x => x.ContactType.TypeDescription == "Administrator" || x.ContactType.TypeDescription == "Teacher").Select(x => new AuthorComboBoxRowModel { ContactID = x.ContactID, Name = x.Contact.LastName + ", " + x.Contact.FirstMidName, }); return(Json(contacts.ToList())); } }
public ActionResult ContactList() { using (IHoneyMustardDataSource ds = HoneyMustard.Factories.DataSourceFactory.GetDataSource()) { var contacts = ds.Contacts.Select(x => new ContactListTableRow { ContactID = x.ContactID, FirstMidName = x.FirstMidName + " " + x.LastName, }); return(Json(contacts.ToList())); } }
public ActionResult DegreeList() { using (IHoneyMustardDataSource ds = HoneyMustard.Factories.DataSourceFactory.GetDataSource()) { var degrees = ds.Degree.Select(x => new DegreeComboBoxRowModel { DegreeID = x.DegreeID, Name = x.Name, TotalCredit = x.TotalCredits }); return(Json(degrees.ToList())); } }
public ActionResult Edit([Bind(Include = "CourseID,CourseName,Module,StartDate,EndDate,Credit,DayOfWeek,ContactID,activated_date,TimeClassBegins,TimeClassEnds,Location,Gender,Price,Comment")] Courses course) { using (IHoneyMustardDataSource ds = DataSourceFactory.GetDataSource()) { if (ModelState.IsValid) { //ds.Entry(course).State = EntityState.Modified; ds.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ContactID = new SelectList(ds.Contacts, "ContactID", "FirstMidName", course.ContactID); return(View(course)); } }
public ActionResult CoursesList() { using (IHoneyMustardDataSource ds = HoneyMustard.Factories.DataSourceFactory.GetDataSource()) { var degrees = ds.Courses.Select(x => new CoursesComboBoxRowModel { CoursesID = x.CoursesID, CourseName = x.CourseName, Credit = x.Credit }); return(Json(degrees.ToList())); } }
public ActionResult CreateReminder([Bind(Include = "ReminderID,From,To,Subject,Details,AlertDateTime")] Reminder reminder) { using (IHoneyMustardDataSource ds = DataSourceFactory.GetDataSource()) { if (ModelState.IsValid) { ds.Reminder.Add(reminder); ds.SaveChanges(); return(RedirectToAction("DisplayReminderList")); } return(View(reminder)); } }
public ActionResult ReminderContactList() { using (IHoneyMustardDataSource ds = HoneyMustard.Factories.DataSourceFactory.GetDataSource()) { var contacts = ds.Contacts.Select(x => new FromReminderListTableRow { ContactID = x.ContactID, FirstMidName = x.FirstMidName + " " + x.LastName + "[ID = " + x.TeudatZehutPassport + "]", }); return(Json(contacts.ToList())); } }
public ActionResult ContactList() { using (IHoneyMustardDataSource ds = HoneyMustard.Factories.DataSourceFactory.GetDataSource()) { var contacts = ds.ContactJoin.Where(x => x.ContactType.TypeDescription == "Student").Select(x => new ContactComboBoxRowModel { ContactID = x.ContactID, TeudatZehutPassport = x.Contact.TeudatZehutPassport, Name = x.Contact.LastName + ", " + x.Contact.FirstMidName, }); return(Json(contacts.ToList())); } }
public ActionResult Edit([Bind(Include = "FirstMidName,ContactType,LastName,EmailAddress,Address,TeudatZehutPassport,CountryID,Phone,CellPhone")] Contact contact) { using (IHoneyMustardDataSource ds = DataSourceFactory.GetDataSource()) { if (ModelState.IsValid) { //ds.Entry(course).State = EntityState.Modified; ds.SaveChanges(); return(RedirectToAction("DisplayContactList")); } ViewBag.ContactID = new SelectList(ds.Contacts, "ContactID", "FirstMidName", contact.ContactID); return(View(contact)); } }
public ActionResult DeleteReminder(int?id) { using (IHoneyMustardDataSource ds = DataSourceFactory.GetDataSource()) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Reminder reminder = ds.Reminder.Find(id); if (reminder == null) { return(HttpNotFound()); } return(View(reminder)); } }
// GET: Courses/Delete/5 public ActionResult Delete(int?id) { using (IHoneyMustardDataSource ds = DataSourceFactory.GetDataSource()) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Courses course = ds.Courses.Find(id); if (course == null) { return(HttpNotFound()); } return(View(course)); } }
// Get: /Finance/Student/ public ActionResult Student(int id) { using (IHoneyMustardDataSource ds = Factories.DataSourceFactory.GetDataSource()) { StudentFinanceModel model = (from student in ds.Contacts where student.ContactID == id select new StudentFinanceModel { Name = student.FirstMidName + " " + student.LastName, Address = student.Address, EmailAddress = student.EmailAddress, Phone = student.Phone, CellPhone = student.CellPhone, ContactID = student.ContactID }).SingleOrDefault(); { model.Payments = ds.ReceivePayment.Where(x => x.Participant.ContactID == id) .Select(x => new StudentTableRowModels { CourseName = x.Courses.CourseName, AgreedPrice = x.Participant.AgreedPrice, AmountPaid = x.AmountPaid, PaymentMethod = x.PaymentMethod.Method, Date = x.Date }).ToList(); }; model.Courses = (from Participant in ds.Participant where Participant.ContactID == id select new SelectListItem { Value = Participant.CoursesID.ToString(), Text = Participant.Courses.CourseName }).ToList(); model.PaymentMethod = (from paymentMethod in ds.PaymentMethod select new SelectListItem { Value = paymentMethod.PaymentMethodID.ToString(), Text = paymentMethod.Method }).ToList(); decimal totalAgreedPrice = ds.Participant.Where(x => x.ContactID == id).Sum(x => x.AgreedPrice); decimal totatPaid = model.Payments.Sum(x => x.AmountPaid); model.Balance = totalAgreedPrice - totatPaid; return(View(model)); } }