public ActionResult Create(Topic tp)
{
ViewBag.FacultyID = new SelectList(db.Faculties, "FacultyID", "FacultyName", tp.FacultyID);
if (tp.EndDate > tp.StartDate)
{
if (ModelState.IsValid)
{
try
{
db.Topics.Add(tp);
db.SaveChanges();
return(RedirectToAction("index"));
}
catch (Exception ex)
{
ModelState.AddModelError("", ex);
ModelState.AddModelError("", "Error inserting Content. ID is already existed");
return(View(tp));
}
}
}
else
{
TempData["message"] = "The End Date must come after the Start Date";
return(View());
}
return(RedirectToAction("index"));
}
public ActionResult ehee([Bind(Include = "TopicID,CommentA,CTID,MCID,StatusID,CTassignID")] ContentAssign contentAssign, int id)
{
contentAssign.CTassignID = contentAssign.CTassignID;
ViewBag.StatusID = new SelectList(db.Status, "StatusID", "GiveStatus");
var tpid = (from tp in db.Topics join t in db.ContentAssigns on tp.TopicID equals t.TopicID where t.CTassignID == id select new { Name = tp.TopicID }).FirstOrDefault();
contentAssign.TopicID = tpid.Name;
var cid = (from c in db.Contents join t in db.ContentAssigns on c.CTID equals t.CTID where t.CTassignID == id select new { ID = c.CTID }).FirstOrDefault();
contentAssign.CTID = cid.ID;
var m = (from s in db.MarketingCoordinators
where s.UserName.Equals(User.Identity.Name)
select s).FirstOrDefault();
contentAssign.MCID = m.MCID;
if (ModelState.IsValid)
{
db.Entry(contentAssign).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(contentAssign));
}
public ActionResult Create(Guest guest)
{
if (ModelState.IsValid)
{
db.Guests.Add(guest);
db.SaveChanges();
AuthenController.CreateAccount(guest.UserName, "123456", "Guest");
return(RedirectToAction("Index"));
}
return(View(guest));
}
public ActionResult Create([Bind(Include = "MCEmail,MCID,MCName,MCAddress,MCPhone,FacultyID,UserName")] MarketingCoordinator marketingCoordinator)
{
if (ModelState.IsValid)
{
db.MarketingCoordinators.Add(marketingCoordinator);
db.SaveChanges();
AuthenController.CreateAccount(marketingCoordinator.UserName, "123456", "MarketingCoordinator");
return(RedirectToAction("Index"));
}
ViewBag.CTTagID = new SelectList(db.Faculties, "FacultyID", "FacultyName", marketingCoordinator.FacultyID);
return(View(marketingCoordinator));
}
public ActionResult Create(MarketingManager marketingmanager)
{
if (ModelState.IsValid)
{
db.MarketingManagers.Add(marketingmanager);
db.SaveChanges();
AuthenController.CreateAccount(marketingmanager.UserName, "123456", "ManagerMarketing");
return(RedirectToAction("Index", "Home"));
}
return(View(marketingmanager));
}
public ActionResult Create([Bind(Include = "StudentEmail,StudentID,StudentName,StudentAddress,DOB,UserName,FacultyID")] Student student)
{
if (ModelState.IsValid)
{
db.Students.Add(student);
db.SaveChanges();
AuthenController.CreateAccount(student.UserName, "123456", "Student");
return(RedirectToAction("Index"));
}
ViewBag.FacultyID = new SelectList(db.Faculties, "FacultyID", "FacultyName", student.FacultyID);
return(View(student));
}
public ActionResult Index(HttpPostedFileBase postedFile)
{
byte[] bytes;
using (BinaryReader br = new BinaryReader(postedFile.InputStream))
{
bytes = br.ReadBytes(postedFile.ContentLength);
}
db.tblFiles.Add(new tblFile
{
Name = Path.GetFileName(postedFile.FileName),
ContentType = postedFile.ContentType,
Data = bytes
});
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "StudentEmail,StudentName,StudentID,StudentAddress,FacultyID,DOB,UserName")] Student student)
{
var stdID = (from i in db.Students where i.UserName == User.Identity.Name select i.StudentID).FirstOrDefault();
var uName = (from m in db.Students where m.UserName == User.Identity.Name select m.UserName).FirstOrDefault();
var facID = (from c in db.Students where c.UserName == User.Identity.Name select c.FacultyID).FirstOrDefault();
if (ModelState.IsValid)
{
student.StudentID = stdID;
student.FacultyID = facID;
student.UserName = uName;
db.Entry(student).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("StdProfile"));
}
return(View(student));
}
public ActionResult Edit([Bind(Include = "MCEmail,MCID,MCName,MCAddress,MCPhone,FacultyID,UserName")] MarketingCoordinator marketingCoordinator)
{
var mID = (from i in db.MarketingCoordinators where i.UserName == User.Identity.Name select i.MCID).FirstOrDefault();
var uName = (from m in db.MarketingCoordinators where m.UserName == User.Identity.Name select m.UserName).FirstOrDefault();
var facID = (from c in db.MarketingCoordinators where c.UserName == User.Identity.Name select c.FacultyID).FirstOrDefault();
if (ModelState.IsValid)
{
marketingCoordinator.MCID = mID;
marketingCoordinator.FacultyID = facID;
marketingCoordinator.UserName = uName;
db.Entry(marketingCoordinator).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("MCProfile"));
}
//ViewBag.FacultyID = new SelectList(db.Faculties, "FacultyID", "FacultyName", marketingCoordinator.FacultyID);
return(View(marketingCoordinator));
}
public ActionResult Create(Content ct, HttpPostedFileBase postedImg, HttpPostedFileBase postedPDF, string id, ContentAssign contentAssign)
{
var student = (from s in db.Students
where s.UserName.Equals(User.Identity.Name)
select s).FirstOrDefault();
ct.StudentID = student.StudentID; //LINQ+ ENtityframework
var tpid = (from t in db.Topics
where t.TopicID == id
select t).FirstOrDefault();
ct.FacultyID = tpid.FacultyID;
byte[] bytes;
byte[] byte2s;
using (BinaryReader br = new BinaryReader(postedImg.InputStream))
{
bytes = br.ReadBytes(postedImg.ContentLength);
}
using (BinaryReader br2 = new BinaryReader(postedPDF.InputStream))
{
byte2s = br2.ReadBytes(postedPDF.ContentLength);
}
if (DateTime.Now < tpid.EndDate)
{
db.Contents.Add(new Content
{
Name2 = Path.GetFileName(postedImg.FileName),
ContentType2 = postedImg.ContentType,
Data2 = bytes,
CTName = ct.CTName,
CTDescription = ct.CTDescription,
FacultyID = ct.FacultyID,
StudentID = ct.StudentID,
Name = Path.GetFileName(postedPDF.FileName),
ContentType = postedPDF.ContentType,
Data = byte2s,
TopicID = id
});
var mcmail = (from m in db.MarketingCoordinators where m.FacultyID == ct.FacultyID select m.MCEmail).FirstOrDefault();
var mcid = (from m in db.MarketingCoordinators where m.FacultyID == ct.FacultyID select m.MCID).FirstOrDefault();
using (MailMessage mm = new MailMessage("*****@*****.**", mcmail))
{
//ct.To = ViewBag.McMail;
mm.Subject = "Grade content";
mm.Body = "You have a new content from student: " + student.StudentName + "--- Stduent ID: " + student.StudentID;
mm.IsBodyHtml = false;
using (SmtpClient smtp = new SmtpClient())
{
smtp.Host = "smtp.gmail.com";
smtp.EnableSsl = true;
NetworkCredential NetworkCred = new NetworkCredential("*****@*****.**", "tsuna2000");
smtp.UseDefaultCredentials = true;
smtp.Credentials = NetworkCred;
smtp.Port = 587;
smtp.Send(mm);
ViewBag.Message = "Email sent.";
}
db.ContentAssigns.Add(new ContentAssign
{
CTID = ct.CTID,
TopicID = id,
MCID = mcid
});
}
}
else
{
TempData["message"] = "this topic is expired, Try another or wait for the next topic ";
return(View());
}
db.SaveChanges();
return(RedirectToAction("Uploaded"));
}