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