public ActionResult Create([Bind(Include = "Key,Message,Coach,PhoneNumber")] ContactCoach contactCoach)
{
if (ModelState.IsValid)
{
string user = User.Identity.GetUserId();
var result = from row in db.Players where row.UserId == user select row;
var rowResult = result.FirstOrDefault();
//rowResult.CoachID = contactCoach.Coach;
var coachResult = from row in db.Coaches where row.CoachID == rowResult.CoachID select row;
var coachRowResult = coachResult.FirstOrDefault();
contactCoach.PhoneNumber = coachRowResult.PhoneNumber;
db.ContactCoaches.Add(contactCoach);
db.SaveChanges();
string lastPhone = (from n in db.ContactCoaches orderby n.PhoneNumber descending select n.PhoneNumber).FirstOrDefault();
string lastMassage = (from n in db.ContactCoaches orderby n.Message descending select n.Message).FirstOrDefault();
Message message = new Message();
HelperClasses.Twilio twilio = new HelperClasses.Twilio();
message.content = lastMassage;
message.recipient = lastPhone;
twilio.Send(message, lastPhone);
return(RedirectToAction("Home", "Players"));
}
return(View(contactCoach));
}
public ActionResult DeleteConfirmed(int id)
{
ContactCoach contactCoach = db.ContactCoaches.Find(id);
db.ContactCoaches.Remove(contactCoach);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Key,Message,Coach,PhoneNumber")] ContactCoach contactCoach)
{
if (ModelState.IsValid)
{
db.Entry(contactCoach).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(contactCoach));
}
// GET: ContactCoaches/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ContactCoach contactCoach = db.ContactCoaches.Find(id);
if (contactCoach == null)
{
return(HttpNotFound());
}
return(View(contactCoach));
}
