public ActionResult Create(User user, string password, HttpPostedFileBase Picture)
{
if (ModelState.IsValid)
{
if (Picture != null)
{
WebImage img = new WebImage(Picture.InputStream);
FileInfo imginfo = new FileInfo(Picture.FileName);
string picid = Picture.FileName + imginfo.Extension;
img.Resize(100, 100);
img.Save("~/Uploads/Users/" + picid);
user.Picture = "/Uploads/Users/" + picid;
}
user.Password = Crypto.Hash(password, "MD5");
db.Users.Add(user);
db.SaveChanges();
logger.Info($" AN ADMIN CREATE A USER =>USER NAME : {user.UserName}-- ID:{user.ID}--------ADMIN NAME:{Session["UserName"]}");
return(RedirectToAction("Index"));
}
return(View());
}
public IHttpActionResult PutPinLocation(short lid, PinLocation pinLocation)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (lid != pinLocation.PinId)
{
return(BadRequest());
}
db.Entry(pinLocation).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!PinLocationExists(lid))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public HttpResponseMessage Create(User user)
{
if (!ModelState.IsValid)
{
return(new HttpResponseMessage(HttpStatusCode.BadRequest));
}
if (user.UID == 0)
{
try
{
_context.Users.Add(user);
_context.SaveChanges();
return(new HttpResponseMessage(HttpStatusCode.Created));
}
catch (DbUpdateException e)
{
Debug.WriteLine(e.Message);
return(new HttpResponseMessage(HttpStatusCode.Conflict));
}
}
else
{
var _user = _context.Users.Single(u => u.UID == user.UID);
_user.Uname = user.Uname;
_user.Password = user.Password;
_context.SaveChanges();
return(new HttpResponseMessage(HttpStatusCode.Created));
}
}
public IHttpActionResult UpdateTrain(short id, Train train)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != train.TID)
{
return(BadRequest());
}
_context.Entry(train).State = EntityState.Modified;
try
{
_context.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!TrainExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult PutProduct(int id, Product product)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != product.Id)
{
return(BadRequest());
}
db.Entry(product).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!ProductExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult PutStation(short id, Station station)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != station.SID)
{
return(BadRequest());
}
_context.Entry(station).State = EntityState.Modified;
try
{
_context.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!StationExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.Created));
}
public HttpResponseMessage CreateRoute(Route route)
{
if (ModelState.IsValid)
{
if (route.RID == 0)
{
_context.Routes.Add(route);
}
else
{
var routeTemp = _context.Routes.Single(r => r.RID == route.RID);
routeTemp.Distance = route.Distance;
routeTemp.Name = route.Name;
routeTemp.Sstation = route.Sstation;
routeTemp.Estation = route.Estation;
routeTemp.Description = route.Description;
}
_context.SaveChanges();
var res = new HttpResponseMessage(HttpStatusCode.Created)
{
Content = new StringContent(route.RID.ToString())
};
return(res);
}
return(new HttpResponseMessage(HttpStatusCode.BadRequest));
}
public ActionResult AddCourse([Bind(Include = "Course_code,Course_title,Credit_hour,Semester,UnderFaculty,UnderDepartment,CourseTeacherID")] Course course)
{
if (!HasSession()) return RedirectToAction("Index", "Home");
course.Course_code = course.Course_code.Trim().Replace(" ", "_").Replace("-", "_").ToUpper();
Course crs = db.Courses.Where(a => a.Course_code == course.Course_code).FirstOrDefault();
string message = course.Course_code + " Course Already Exsist.";
if (crs == null)
{
CreateDatabaseAndTable cdt = new CreateDatabaseAndTable(course.UnderFaculty);
message = cdt.AddCourse(course.Course_code, course.Semester);
Teacher tcr = db.Teacher.Where(dp => dp.TeacherID == course.CourseTeacherID).FirstOrDefault();
if (tcr != null)
{
course.CourseTeacherName = tcr.Name;
course.CourseTeacherDepartment = tcr.Department;
course.CourseTeacherFaculty = tcr.Faculty;
}
db.Courses.Add(course);
db.SaveChanges();
}
ViewBag.Message = message + " Under "
+ course.UnderFaculty + " faculty, under " + course.UnderDepartment + " department.";
//ViewBag.Message = course.Course_code + " added failed or already exists.";
ViewBag.faculties = db.Faculty.ToList();
return View();
}
public IHttpActionResult PutStopAt(short sid, short tid, StopAt stopAt)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (sid != stopAt.SID || tid != stopAt.TID)
{
return(BadRequest());
}
_dbContext.Entry(stopAt).State = EntityState.Modified;
try
{
_dbContext.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!StopAtExists(sid) || !StopAtExists(tid))
{
return(NotFound());
}
else
{
return(Conflict());
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult AddDepartment([Bind(Include = "DepartmentName,ShortForm,Faculty")] Department department)
{
db.Department.Add(department);
db.SaveChanges();
ViewBag.faculties = db.Faculty.ToList();
return(View());
}
public ActionResult SavePost(FormCollection formCollection, string savePost, string saveAndPublish)
{
if (savePost != null)
{
//Session["userId"] = 1;
Post aPost = new Post();
aPost.Title = formCollection["Title"];
aPost.Description = Server.HtmlDecode(formCollection["Description"]);
aPost.PostDate = DateTime.Now;
aPost.NoOfView = 0;
aPost.UserID = 1;
//aPost.UserID = (int)Session["userId"];
aPost.IsPublished = false;
db.Posts.Add(aPost);
db.SaveChanges();
return(View());
}
if (saveAndPublish != null)
{
//Session["userId"] = 1;
Post aPost = new Post();
aPost.Title = formCollection["Title"];
aPost.Description = Server.HtmlDecode(formCollection["Description"]);
aPost.PostDate = DateTime.Now;
aPost.NoOfView = 0;
aPost.UserID = 1;
//aPost.UserID = (int)Session["userId"];
aPost.IsPublished = true;
db.Posts.Add(aPost);
db.SaveChanges();
return(View());
}
return(View());
}
public ActionResult AddTeacher(string fullanme, string emailid, string mobile, string faculty, string department)
{
if (!HasSession())
{
return(RedirectToAction("Index", "Home"));
}
ViewBag.faculties = db.Faculty.ToList();
if (fullanme != null & emailid != null & mobile != null & faculty != null & department != null)
{
Teacher teacher = new Teacher(fullanme, emailid, mobile, faculty.ToUpper(), department.ToUpper(), new FacultyDepartmentInfo().createRandomPassword());
if (db.Teacher.Where(a => a.Email == teacher.Email).FirstOrDefault() == null)
{
db.Teacher.Add(teacher);
db.SaveChanges();
string Message = "<p>Now you are registered at PSTU Result Management System </p>";
Message += "<p>Username : "******"</p>";
Message += "<p>Password : "******"</p>";
Message += "<p>Please Change The password to Secure the System.</p>";
Utils.SendMail(teacher.Name, teacher.Email, Messasges.MailRegistrationInfo, Message);
ViewBag.Message = "Successfully Registered.. Please check the Mail.";
}
else
{
ViewBag.ErrorMessage = teacher.Email + " Already Exsist in the Teacher List..!";
}
}
return(View());
}
public ActionResult AddFaculty([Bind(Include = "FacultyName,ShortForm")] Faculty faculty)
{
if (!HasSession())
{
return(RedirectToAction("Index", "Home"));
}
faculty.ShortForm = faculty.ShortForm.ToUpper();
if (db.Faculty.Where(a => a.ShortForm == faculty.ShortForm || a.FacultyName == faculty.FacultyName).FirstOrDefault() == null)
{
CreateDatabaseAndTable cdt = new CreateDatabaseAndTable(faculty.ShortForm);
cdt.CreateDatabase(faculty.ShortForm);
db.Faculty.Add(faculty);
db.SaveChanges();
ViewBag.Message = "Successfully Faculty Added..! ";
}
else
{
ViewBag.ErrorMessage = "Faculty Already Exists..!";
}
return(View());
}
public ActionResult Create([Bind(Include = "id,Name,age")] User user)
{
if (ModelState.IsValid)
{
db.Users.Add(user);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(user));
}
public ActionResult Create(About about)
{
if (ModelState.IsValid)
{
db.Abouts.Add(about);
db.SaveChanges();
logger.Info($" AN ADMIN CREATE AN ABOUTS : {about.aboutID}-- :{about.Description}--------ADMIN :{Session["UserName"]}--ID:{Session["ID"]}");
return(RedirectToAction("Index"));
}
return(View());
}
public ActionResult Create([Bind(Include = "DepartmentCourseID,CourseID")] DepartmentCourse departmentCourse)
{
if (ModelState.IsValid)
{
db.DepartmentCourses.Add(departmentCourse);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(departmentCourse));
}
public ActionResult Create([Bind(Include = "DepartmentID,Name,Code")] Department department)
{
if (ModelState.IsValid)
{
db.Departments.Add(department);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(department));
}
public ActionResult Create([Bind(Include = "Id,BrandName,Code,BrandDescription")] Product product)
{
if (ModelState.IsValid)
{
db.Products.Add(product);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(product));
}
public ActionResult Create(Category category)
{
if (ModelState.IsValid)
{
db.Categories.Add(category);
db.SaveChanges();
logger.Info($" AN ADMIN CREATE A CATEGORY : {category.categoryID}-- :{category.categoryname}--------ADMIN :{Session["UserName"]}--ID:{Session["ID"]}");
return(RedirectToAction("Index"));
}
return(View());
}
public ActionResult Create([Bind(Include = "Id,ProductName,ProductCode,ProductPrice,ProductDescription,ProductId")] ProductItem productItem)
{
if (ModelState.IsValid)
{
db.ProductItems.Add(productItem);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ProductId = new SelectList(db.Products, "Id", "BrandName", productItem.ProductId);
return(View(productItem));
}
public ActionResult Create([Bind(Include = "contactID,Adress,phone")] Contact contact)
{
if (ModelState.IsValid)
{
db.Contacts.Add(contact);
db.SaveChanges();
logger.Info($" AN ADMIN CREATE A CONTACTS : {contact.contactID}--------ADMIN :{Session["UserName"]}--ID:{Session["ID"]}");
return(RedirectToAction("Index"));
}
return(View(contact));
}
public ActionResult Create([Bind(Include = "CommentID,UserName,Email,Comment1,blogID,UserID,validation")] Comment comment)
{
if (ModelState.IsValid)
{
db.Comments.Add(comment);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CommentID = new SelectList(db.Blogs, "blogID", "title", comment.CommentID);
ViewBag.CommentID = new SelectList(db.Users, "ID", "Name", comment.CommentID);
logger.Info($" AN ADMIN CREATE COMMENTS :COMMENT ID {comment.CommentID}-- BLOG ID:{comment.blogID}--------ADMIN :{Session["UserName"]}--ID:{Session["ID"]}");
return(View(comment));
}
public ActionResult ChangePassword(int?TeacherID, String oldpassword, String newpassword, String retypenewpassword)
{
if (!HasSession())
{
return(RedirectToAction("Index", "Home"));
}
Teacher teacher = db.Teacher.Find(TeacherID);
if (newpassword.Equals(retypenewpassword))
{
if (teacher.Password.Equals(oldpassword))
{
teacher.Password = newpassword;
db.Entry(teacher).State = EntityState.Modified;
db.SaveChanges();
ViewBag.Message = "Successfully password changed";
//return RedirectToAction("index", "Teacher");
return(View(teacher));
}
else
{
ViewBag.Message = "Invalid Old Password..!";
return(View(teacher));
}
}
else
{
ViewBag.Message = "Miss Match new Password..!";
return(View(teacher));
}
}
private void btnSave_Click(object sender)
{
if (ProjectDB.SaveChanges() > 0)
{
ProjectViewSource.View.Refresh();
toolBar.msgSaved(ProjectDB.NumberOfRecords);
}
}
public ActionResult AddTeacher(string fullanme, string emailid, string mobile, string faculty, string department)
{ // [Bind(Include="TeacherID,Name,Email,Mobile,Faculty,Department")] Teacher teacher
ViewBag.faculties = db.Faculty.ToList();
if (fullanme != null & emailid != null & mobile != null & faculty != null & department != null)
{
Teacher teacher = new Teacher(fullanme, emailid, mobile, faculty, department, new FacultyDepartmentInfo().createRandomPassword());
db.Teacher.Add(teacher);
db.SaveChanges();
}
return(View());
}
public JsonResult Delete(int id)
{
var data = mydb.UploadTables.Find(id);
System.IO.File.Delete(HttpContext.Server.MapPath(data.Url)); // dosyadan sil
mydb.UploadTables.Remove(data);
mydb.SaveChanges(); // db den sil
return(Json("OK"));
}
public ActionResult Create(Identity identity, HttpPostedFileBase LogoURL)
{
if (ModelState.IsValid)
{
if (LogoURL != null)
{
WebImage img = new WebImage(LogoURL.InputStream);
FileInfo imginfo = new FileInfo(LogoURL.FileName);
string picid = LogoURL.FileName + imginfo.Extension;
img.Resize(100, 100);
img.Save("~/UploadS/Identities/" + picid);
identity.LogoURL = "/Uploads/Identities/" + picid;
}
db.Identities.Add(identity);
db.SaveChanges();
logger.Info($" AN ADMIN CREATE AN IDENTITIES : {identity.IdentityID}-- :{identity.Title}--------ADMIN :{Session["UserName"]}--ID:{Session["ID"]}");
return(RedirectToAction("Index"));
}
return(View());
}
public JsonResult MakeAComment(string UserName, string Email, string Comment1, int blogID)
{
ViewBag.Identities = db.Identities.SingleOrDefault();
if (Comment1 == null)
{
return(Json(true, JsonRequestBehavior.AllowGet));
}
db.Comments.Add(new Comment {
UserName = UserName, Email = Email, Comment1 = Comment1, blogID = blogID, validation = "false"
});
logger.Info($" SOMEBODY MAKE COMMENTS INTO => BLOGS NAME:{Session["UserName"]}-- --ID {Session["ID"]}---ROLE: {Session["Role"]} ////// BLOG :{blogID}");
db.SaveChanges();
return(Json(false, JsonRequestBehavior.AllowGet));
}
public ActionResult Create(Blog blog, HttpPostedFileBase pictureURL)
{
if (ModelState.IsValid)
{
if (pictureURL != null)
{
WebImage img = new WebImage(pictureURL.InputStream);
FileInfo imginfo = new FileInfo(pictureURL.FileName);
string picid = pictureURL.FileName + imginfo.Extension;
img.Resize(100, 100);
img.Save("~/Uploads/Blogs/" + picid);
blog.pictureURL = "/Uploads/Blogs/" + picid;
}
db.Blogs.Add(blog);
db.SaveChanges();
logger.Info($" AN ADMIN CREATE BLOGS : {blog.blogID}-- :{blog.title}--------ADMIN :{Session["UserName"]}--ID:{Session["ID"]}");
return(RedirectToAction("Index"));
}
return(View());
}
public ActionResult Create(Slider slider, HttpPostedFileBase pictureURL)
{
if (ModelState.IsValid)
{
if (pictureURL != null)
{
WebImage img = new WebImage(pictureURL.InputStream);
FileInfo imginfo = new FileInfo(pictureURL.FileName);
string picid = pictureURL.FileName + imginfo.Extension;
img.Resize(1024, 360);
img.Save("~/Uploads/Sliders/" + picid);
slider.pictureURL = "/Uploads/Sliders/" + picid;
}
db.Sliders.Add(slider);
db.SaveChanges();
logger.Info($" AN ADMIN CREATE SLIDERS : {slider.sliderID}-- :{slider.title}--------ADMIN :{Session["UserName"]}--ID:{Session["ID"]}");
return(RedirectToAction("Index"));
}
return(View());
}
