public JsonResult DeleteKidStory(int storyid)
{
bool resul = false;
KidsStory sc = db.KidsStories.SingleOrDefault(x => x.StoryId == storyid);
if (sc != null)
{
db.KidsStories.Remove(sc);
db.SaveChanges();
resul = true;
}
return(Json(resul, JsonRequestBehavior.AllowGet));
}
public ActionResult kidstor(tbl_KidStory kid)
{
try
{
List <KidsStoryType> list = db.KidsStoryTypes.ToList();
ViewBag.storytypelist = new SelectList(list, "KidsStoryTypeId", "KidsStoryName");
int studenid = Convert.ToInt32(Session["Student"]);
int schoolid;
var data = db.Students.Find(studenid);
schoolid = data.School_Id;
KidsStory kd = new KidsStory();
string filename = Path.GetFileNameWithoutExtension(kid.UserImageFIle.FileName);
string extension = Path.GetExtension(kid.UserImageFIle.FileName);
filename = DateTime.Now.ToString("yymmssff") + extension;
kd.imgPath = "~/FrontEnd/Images/KidStoryImage/" + filename;
//image ko folder me save krwanay ke leye
filename = Path.Combine(Server.MapPath("~/FrontEnd/Images/KidStoryImage/"), filename);
kid.UserImageFIle.SaveAs(filename);
kd.CreatedDate = DateTime.Now;
kd.longDes = kid.longDes;
kd.shortDes = kid.shortDes;
kd.StoryTypeId = kid.StoryTypeId;
kd.RoleId = Convert.ToInt32(Session["RoleId"]);
kd.UserId = Convert.ToInt32(Session["Student"]);
kd.statusId = 1;
kd.SchoolId = schoolid;
kd.StoryTitle = kid.StoryTitle;
db.KidsStories.Add(kd);
db.SaveChanges();
ModelState.Clear();
ViewBag.Message = "Data Submitted";
}
catch (Exception ex)
{
ViewBag.Message = "Not Submitted";
return(View());
}
return(View());
}
public ActionResult updateKidStory(tbl_KidStory sa, int id)
{
if (Session["Ad"] == null)
{
return(RedirectToAction("Login", "Account", new { area = "" }));
}
List <KidsStoryType> list = db.KidsStoryTypes.ToList();
ViewBag.storytypelist = new SelectList(list, "KidsStoryTypeId", "KidsStoryName");
try
{
KidsStory kid = new KidsStory();
//int userid = Convert.ToInt32((Session["Ad"]));
//var l = db.loginTables.FirstOrDefault(t => t.UserId == userid);
if (ModelState.IsValid)
{
if (sa.UserImageFIle != null)
{
//if (l != null)
//{
// l.UserId = userid;
// l.Name = sa.ad_name;
// l.Password = sa.password;
// l.Email = sa.ad_email;
// l.RoleID = 1;
// db.Entry(l).State = EntityState.Modified;
// db.SaveChanges();
//}
string filename = Path.GetFileNameWithoutExtension(sa.UserImageFIle.FileName);
string extension = Path.GetExtension(sa.UserImageFIle.FileName);
filename = DateTime.Now.ToString("yymmssff") + extension;
kid.imgPath = "~/FrontEnd/Images/KidStoryImage/" + filename;
kid.StoryId = id;
kid.StoryTitle = sa.StoryTitle;
kid.shortDes = sa.shortDes;
kid.longDes = sa.longDes;
kid.RoleId = Convert.ToInt32(Session["RoleId"]);
kid.UserId = Convert.ToInt32(Session["Ad"]);
kid.statusId = 2;
kid.StoryTypeId = sa.StoryTypeId;
kid.CreatedDate = DateTime.Now;
if (extension.ToLower() == ".jpg" || extension.ToLower() == ".jpeg" || extension.ToLower() == ".png")
{
if (sa.UserImageFIle.ContentLength <= 1000000)
{
db.Entry(kid).State = EntityState.Modified;
string oldImgPath = Request.MapPath(Session["imgPath"].ToString());
if (db.SaveChanges() > 0)
{
filename = Path.Combine(Server.MapPath("~/FrontEnd/Images/KidStoryImage/"), filename);
sa.UserImageFIle.SaveAs(filename);
if (System.IO.File.Exists(oldImgPath))
{
System.IO.File.Delete(oldImgPath);
}
ViewBag.Message = "Data Updated";
return(RedirectToAction("viewKidStory"));
}
}
else
{
ViewBag.msg = "File Size must be Equal or less than 1mb";
}
}
else
{
ViewBag.msg = "Inavlid File Type";
}
}
//}
else
{
kid.imgPath = Session["imgPath"].ToString();
//if (l != null)
//{
// Session["name"] = sa.ad_name;
// l.UserId = userid;
// l.Name = sa.ad_name;
// l.Password = sa.password;
// l.Email = sa.ad_email;
// l.RoleID = 1;
// db.Entry(l).State = EntityState.Modified;
// db.SaveChanges();
//}
//superadmin.ad_name = sa.ad_name;
//superadmin.ad_email = sa.ad_email;
//superadmin.ad_password = sa.password;
//superadmin.ad_Id = userid;
kid.StoryTitle = sa.StoryTitle;
kid.shortDes = sa.shortDes;
kid.longDes = sa.longDes;
kid.statusId = 2;
kid.StoryTypeId = sa.StoryTypeId;
kid.RoleId = Convert.ToInt32(Session["RoleId"]);
kid.UserId = Convert.ToInt32(Session["Ad"]);
db.Entry(kid).State = EntityState.Modified;
if (db.SaveChanges() > 0)
{
ViewBag.Message = "Data Updated";
return(RedirectToAction("viewKidStory"));
}
}
}
}
catch (Exception ex)
{
ViewBag.Message = "Not Updated";
return(View());
}
return(View());
}
