// STORE PROCEEDURE public IEnumerable <Sermon> GetAllBibleTest(/*string bibleTest*/ SermonModel model) { using (ApplicationDbContext context = new ApplicationDbContext()) { var param1 = new SqlParameter { ParameterName = "@SermonText", SqlDbType = SqlDbType.Text, Direction = ParameterDirection.Output, Value = model.SermonText }; return(context.Database.SqlQuery <Sermon>("exec SelectSermonTest @SermonText", param1).ToList()); }; }
public HttpResponseMessage AddSermon([FromBody] SermonModel s) { IEnumerable <SermonModel> sermon = _sermonServices.GetSermons(); var checksermon = sermon.FirstOrDefault(se => se.SermonTitle == s.SermonTitle); if (checksermon != null) { return(this.Request.CreateResponse(HttpStatusCode.Conflict, "Sermon with the title exist ")); } var model = s.Create(s); _context.Sermons.Add(model); _context.SaveChanges(); return(this.Request.CreateResponse(HttpStatusCode.Created, "Successful")); }
public bool UpdateSerm(SermonModel model) { //var isExist = _context.Departments.Where(n => n.DeptId == model.DeptId).FirstOrDefault(); //if (isExist == null) throw new Exception("user not found"); var deptInDb = _context.Sermons.Find(model.SermId); if (deptInDb == null) { throw new Exception("not found"); } var entity = model.Edit(deptInDb, model); _context.Entry(entity); _context.SaveChanges(); return(true); }
public bool CreatSermon(SermonModel model) { try { //var isExist = _context.Sermons.Where(x => x. == model.DeptName).FirstOrDefault(); //if (isExist != null) throw new Exception("Department already exist"); //since a message can be preach twice var entity = model.Create(model); _context.SaveChanges(); } catch (Exception xe) { throw xe; } return(true); }
public ActionResult PrintPdf(SermonModel model) { var svm = new SermonIndexViewModel { sermon = model }; var pdfView = new ViewAsPdf("SermonDetails", svm) { FileName = "File.pdf", PageSize = Rotativa.Options.Size.A4, PageMargins = { Left = 0, Right = 0 } }; return(pdfView); }
public ActionResult AddSermon(SermonModel model) { if (ModelState.IsValid) { var sermoncat = _context.SermonCategories.Where(s => s.SermonName == model.SermonCategoryName).FirstOrDefault(); string fileName = Path.GetFileNameWithoutExtension(model.ImageFile.FileName); string extension = Path.GetExtension(model.ImageFile.FileName); fileName = fileName + DateTime.Now.ToString("yymmssffff") + extension; model.ImageUrl = fileName; fileName = Path.Combine(Server.MapPath("~/Content/Images/"), fileName); model.ImageFile.SaveAs(fileName); // var addsermon = new Sermon { SermonDate = model.SermonDate, CatId = model.CatId, SermonTitle = model.SermonTitle, SermonText = model.SermonText, PreacherName = model.PreacherName, LongDescription = model.LongDescription, ShortDescription = model.ShortDescription, SermonCategory = sermoncat, ImageUrl = model.ImageUrl, ImageThumbnailUrl = model.ImageUrl, //SermonvideoUrl=sv.SermonvideoUrl, //SermonvideoThumbnail=sv.SermonvideoUrl }; _context.Sermons.Add(addsermon); _context.SaveChanges(); TempData["message"] = string.Format("{0} has been saved.", model.SermonTitle); return(RedirectToAction("SermonList")); // var result = _sermonServices.CreatSermon(model); } else { var sermoncategory = _context.SermonCategories.Select(r => r.SermonName); ViewBag.SermonCategory = new SelectList(sermoncategory); return(View(model)); } }
public ActionResult EditSermon(SermonModel svm) { if (ModelState.IsValid) { var sermon = _context.Sermons.Find(svm.SermId); var sermoncat = _context.SermonCategories.Where(s => s.SermonName == svm.SermonCategoryName).FirstOrDefault(); if (sermon != null) { string fileName = Path.GetFileNameWithoutExtension(svm.ImageFile.FileName); string extension = Path.GetExtension(svm.ImageFile.FileName); fileName = fileName + DateTime.Now.ToString("yymmssffff") + extension; svm.ImageUrl = fileName; fileName = Path.Combine(Server.MapPath("~/Content/Images/"), fileName); sermon.SermonText = svm.SermonText; sermon.SermonTitle = svm.SermonTitle; sermon.SermonDate = svm.SermonDate; sermon.PreacherName = svm.PreacherName; sermon.LongDescription = svm.LongDescription; sermon.ShortDescription = svm.ShortDescription; sermon.ImageUrl = svm.ImageUrl; sermon.ImageThumbnailUrl = svm.ImageUrl; if (svm.ImageFile != null && svm.ImageFile.ContentLength > 0) { svm.ImageFile.SaveAs(fileName); } sermon.SermonCategory = sermoncat; _context.SaveChanges(); TempData["message"] = $"{sermon.SermonTitle} was successfully edited "; } return(RedirectToAction("SermonList")); } else { return(View(svm)); } }
public ActionResult EditSermon(int id) { var _sermon = _context.Sermons.Find(id); var sermoncategories = _context.SermonCategories.ToList(); var sermoncat = _sermon.SermonCategory; ViewBag.SermonCategories = new SelectList(sermoncategories, "SermonName", "SermonName", sermoncat.SermonName); var svm = new SermonModel { LongDescription = _sermon.LongDescription, ShortDescription = _sermon.ShortDescription, PreacherName = _sermon.PreacherName, SermonCategoryName = _sermon.SermonCategory.SermonName, SermonDate = _sermon.SermonDate, SermonText = _sermon.SermonText, SermonTitle = _sermon.SermonTitle, SermId = _sermon.SermId, ImageUrl = _sermon.ImageUrl }; return(View(svm)); }
public ActionResult BibleTestss(SermonModel model) { var results = _sermonServices.GetAllBibleTest(model); return(View(results)); }