// 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));
}
}
