public ActionResult EditTeacher(string id) { CMSEntities db = new CMSEntities(); Teacher model = db.Teachers.Find(id); return(View(model)); }
public JsonResult isExist(string username) { CMSEntities db = new CMSEntities(); JavaScript("gotoParent()"); return(Json(!db.logins.Any(x => x.username == username), JsonRequestBehavior.AllowGet)); }
public Res_Role Create(Req_Role item) { try { using (CMSEntities _context = new CMSEntities()) { if (!_context.Roles.Any(x => x.Code.Equals(item.Code))) { var role = new Role(); role.Code = item.Code; role.Name = item.Name; role.Active = item.Active == null ? false : item.Active; role.DateCreated = DateTime.UtcNow; _context.Roles.Add(role); _context.SaveChanges(); return(_context.Roles.Where(x => x.Code.Equals(item.Code)).Select(y => new Res_Role { ID = y.ID, Active = (Boolean)y.Active, Code = y.Code, DateCreated = (DateTime)y.DateCreated, Name = y.Name }).SingleOrDefault()); } else { return(null); } } } catch (Exception e) { return(null); } }
public ActionResult LogOn(ViewModel model) { var password = EncriptionController.Encrypt(model.user_pwd, model.user_email); var email = model.user_email; using (CMSEntities db = new CMSEntities()) { var v = db.users.Where(x => x.user_email == model.user_email & x.user_epwd == password).FirstOrDefault(); if (v != null) { Session["Active"] = v.user_active.ToString(); Session["id"] = v.user_id.ToString(); Session["name"] = v.user_name.ToString(); Session["email"] = v.user_email.ToString(); Session["image"] = v.user_image.ToString(); Session["mobile"] = v.user_mobile; Session["accounttype"] = v.user_type.ToString(); Session["pwd"] = v.user_pwd.ToString(); } else { Equals("Invalid Request"); } } return(RedirectToAction("Index")); }
public Res_Product Get(string SKU) { try { using (CMSEntities _context = new CMSEntities()) { return(_context.Products.Where(x => x.SKU.Equals(SKU)).Select(y => new Res_Product { Active = (Boolean)y.Active, BestSeller = (Boolean)y.BestSeller, Content = y.Content, DateCreated = (DateTime)y.DateCreated, Description = y.Description, DiscountPrice = (Decimal)y.DiscountPrice, HashTag = y.HashTag, ID = y.ID, Name = y.Name, Newest = (Boolean)y.Newest, ProductTypeName = y.ProductType.Name, Selling = (Decimal)y.SellingPrice, ShortDescription = y.ShortDescription, SKU = y.SKU, Thumbnail = y.Thumbnail }).SingleOrDefault()); } } catch (Exception e) { return(null); } }
public Res_Role Get(string Code) { try { using (CMSEntities _context = new CMSEntities()) { if (string.IsNullOrEmpty(Code)) { return(null); } return(_context.Roles.Where(x => x.Code.Equals(Code)).Select(y => new Res_Role { ID = y.ID, Active = (Boolean)y.Active, Code = y.Code, DateCreated = (DateTime)y.DateCreated, Name = y.Name }).SingleOrDefault()); } } catch (Exception e) { return(null); } }
public Res_Category Create(Req_Category item) { try { using (CMSEntities _context = new CMSEntities()) { if (!_context.Categories.Any(x => x.Code.Equals(item.Code))) { var category = new Category(); category.Code = item.Code; category.Name = item.Name; category.Description = item.Description; category.Active = item.Active; category.DateCreated = DateTime.UtcNow; _context.Categories.Add(category); _context.SaveChanges(); return(_context.Categories.Where(x => x.Code.Equals(item.Code)).Select(y => new Res_Category { Active = (Boolean)y.Active, Code = y.Code, DateCreated = (DateTime)y.DateCreated, Description = y.Description, Name = y.Name, Thumbnail = y.Thumbnail }).SingleOrDefault()); } return(null); } } catch (Exception e) { return(null); } }
public Res_Group_User Update(string Code, Req_Group_User item) { try { using (CMSEntities _context = new CMSEntities()) { if (_context.GroupUsers.Any(x => x.Code.Equals(Code))) { var Group_User = _context.GroupUsers.SingleOrDefault(x => x.Code.Equals(Code)); Group_User.Name = item.Name; Group_User.Active = item.Active; _context.SaveChanges(); return(_context.GroupUsers.Where(x => x.Code.Equals(Group_User.Code)).Select(y => new Res_Group_User { Code = y.Code, Name = y.Name, Active = (bool)y.Active, DateCreated = (DateTime)y.DateCreated }).SingleOrDefault()); } return(null); } } catch (Exception e) { return(null); } }
public ActionResult saveHomePageContent(string htmlContent) { if (!string.IsNullOrEmpty(htmlContent)) { try { CMSEntities m_context = new CMSEntities(); m_context.Configuration.ProxyCreationEnabled = false; var query = from rows in m_context.HOMEPAGE_CONTENT select rows; foreach (var item in query) { m_context.HOMEPAGE_CONTENT.Remove(item); } m_context.HOMEPAGE_CONTENT.Add(new HOMEPAGE_CONTENT { HTML_CONTENT = htmlContent }); m_context.SaveChanges(); return(Json(new object[] { 1 }, JsonRequestBehavior.AllowGet)); } catch (Exception) { return(Json(new object[] { 0 }, JsonRequestBehavior.AllowGet)); } } else { return(Json(new object[] { 0 }, JsonRequestBehavior.AllowGet)); } }
public ActionResult EditCraft([Bind(Include = "craft_id,craft_name,craft_size,craft_weight,craft_specification")] craft craft, HttpPostedFileBase craft_image) { CMSEntities db = new CMSEntities(); Random r = new Random(); int k = r.Next(200, 5000); craft obj = new craft(); if (ModelState.IsValid) { if (craft_image != null) { string filename = EncriptionController.Encrypt(Path.GetFileNameWithoutExtension(craft_image.FileName) + k, craft.craft_name); string extention = Path.GetExtension(craft_image.FileName); string filenamewithoutextention = Path.GetFileNameWithoutExtension(craft_image.FileName); filename = filename + DateTime.Now.ToString("yymmssff") + extention; filename.Replace(@"/", ""); craft_image.SaveAs(Server.MapPath("~/uploads/" + filename)); obj.craft_name = filename; } db.Entry(craft).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(craft)); }
public ActionResult Contact() { ViewBag.Message = "Your contact page."; List <Articles> articlelist = new List <Articles>(); using (CMSEntities context = new CMSEntities()) { foreach (Articles articles in context.Articles) { var a = new Articles(); a.Title = articles.Title; a.Contents = articles.Contents; a.Category = articles.Category; a.PostID = articles.PostID; if (a.Category == "contact") { articlelist.Add(a); } else { continue; } } ViewBag.contactarticles = articlelist; return(View()); } }
public ActionResult Index() { List <Articles> articlelist = new List <Articles>(); using (CMSEntities context = new CMSEntities()) { foreach (Articles articles in context.Articles) { var a = new Articles(); a.Title = articles.Title; a.Contents = articles.Contents; a.Category = articles.Category; a.PostID = articles.PostID; if (a.Category == "index") { articlelist.Add(a); } else { continue; } } ViewBag.indexarticles = articlelist; } return(View()); }
public ActionResult validate(login users) { using (CMSEntities db = new CMSEntities()) { var userDetails = db.logins.Where(x => x.username == users.username && x.password == users.password).FirstOrDefault(); if (userDetails == null) { users.LoginErrorMessage = "Wrong username or password."; return(View("Login", users)); } else { Session["username"] = userDetails.username; if (userDetails.type == "t") { return(RedirectToAction("Teacher", "Teacher")); } else if (userDetails.type == "a") { return(RedirectToAction("Admin", "Admin")); } else if (userDetails.type == "s") { return(RedirectToAction("Student", "Student")); } else { return(View("Login", users)); } } } return(View()); }
public HttpResponseMessage AddStandard(StandardDetail standard) { try { if (!ModelState.IsValid) { return(Request.CreateResponse(HttpStatusCode.BadRequest)); } else { using (CMSEntities _db = new CMSEntities()) { Standard std = new Standard(); std.Name = standard.Name; std.DateCreated = DateTime.UtcNow; std.IsDeleted = false; _db.Standards.Add(std); _db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, std)); } } } catch (Exception ex) { return(Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message)); } }
public void BeforeScenario() { _ArticleRepository = new ArticleRepository(); _CmsEntitiesTest = new CMSEntities(); _CmsEntitiesTest.Articles.RemoveRange(_CmsEntitiesTest.Articles); _CmsEntitiesTest.SaveChanges(); }
public ActionResult RecoverPassword(user u) { if (ModelState.IsValid) // this is check validity { using (CMSEntities cm = new CMSEntities()) { var v = cm.users.Where(a => a.email_id.Equals(u.email_id)).FirstOrDefault(); if (v != null) { var email = cm.users.Where(a => a.email_id.Equals(u.email_id)).FirstOrDefault(); string pwd = email.password; try { if (ModelState.IsValid) { MailMessage mail = new MailMessage(); mail.To.Add(u.email_id); TempData["notice"] = "Check your mail password is" + " " + pwd.ToString(); mail.From = new MailAddress("*****@*****.**"); mail.Subject = "Recover Password"; string Body = "Your password is" + " " + pwd.ToString(); mail.Body = Body; mail.IsBodyHtml = true; SmtpClient smtp = new SmtpClient(); smtp.Host = "smtp.gmail.com"; smtp.Port = 587; smtp.UseDefaultCredentials = false; smtp.DeliveryMethod = SmtpDeliveryMethod.Network; smtp.Credentials = new System.Net.NetworkCredential("ranjaraman5", "ranja123");// Enter seders User name and password smtp.EnableSsl = true; smtp.Send(mail); TempData["notice1"] = "Sucessfully Send"; return(View("Login")); } } catch (Exception ex) { } TempData["notice"] = "Check your mail password is" + pwd; return(View(u)); } else { TempData["Message"] = "Invalid Email Address"; return(View(u)); } } } return(View(u)); }
public ActionResult Register(user u) { if (ModelState.IsValid) { using (CMSEntities cm = new CMSEntities()) { //you should check duplicate registration here // if (db.A.Any(ac => ac.Name.Equals(a.Name)) if (cm.users.Any(a => a.email_id.Equals(u.email_id) && a.username.Equals(u.username) && a.fullname.Equals(u.fullname))) { ViewBag.Message = "Already Registration Done"; } else { cm.users.Add(u); cm.SaveChanges(); ModelState.Clear(); u = null; ViewBag.Message = "Successfully Registration Done"; } } } return(View(u)); }
public ActionResult AddAttendence(List <attendence> model) { CMSEntities db = new CMSEntities(); int id = model[0].ass_course_id; System.DateTime date = model[0].date; assigned_course assCourse = db.assigned_course.Where(x => x.Id == id).FirstOrDefault(); List <attendence> atten = db.attendences.Where(x => x.ass_course_id == id && x.date == date).ToList(); if (atten.Count == 0) { foreach (attendence item in model) { student s = db.students.Where(x => x.rollno == item.rollno).FirstOrDefault(); item.assigned_course = assCourse; item.student = s; db.attendences.Add(item); } db.SaveChanges(); return(JavaScript("Attendence Submitted!")); } return(JavaScript("Error: Attendence for this date already submitted!")); }
public Res_ProductType Create(Req_ProductType item) { try { using (CMSEntities _context = new CMSEntities()) { if (!_context.ProductTypes.Any(x => x.Code.Equals(item.Code))) { var productType = new ProductType(); productType.Code = item.Code; productType.Name = item.Name; productType.Description = item.Description; productType.Active = item.Active; productType.DateCreated = DateTime.UtcNow; _context.ProductTypes.Add(productType); _context.SaveChanges(); return(_context.ProductTypes.Where(x => x.Code.Equals(item.Code)).Select(y => new Res_ProductType { Code = y.Code, Name = y.Name, Description = y.Description, Thumbnail = y.Thumbnail, DateCreated = (DateTime)y.DateCreated, Active = (Boolean)y.Active }).SingleOrDefault()); } return(null); } } catch (Exception e) { return(null); } }
public JsonResult SendMail(ViewModel model) { invite obj = new invite(); CMSEntities db = new CMSEntities(); bool result = false; result = SendEmail(model.email_invite, model.email_subject, model.email_message); try { obj.email_invite = model.email_invite; obj.email_subject = model.email_subject; obj.email_message = model.email_message; db.invites.Add(obj); db.SaveChanges(); } catch (Exception e) { throw e; } return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult AddAttendence(string course, string degree, string batch) { using (CMSEntities db = new CMSEntities()) { assigned_course assCourse = db.assigned_course.Where(x => x.course == course && x.degree1.title == degree && x.batch1.name == batch).FirstOrDefault(); if (assCourse != null) { List <student> studentList = db.students.Where(x => x.degree1.title == degree && x.batch1.name == batch).ToList(); List <attendence> model = new List <attendence>(); for (int i = 0; i < studentList.Count; i++) { attendence atten = new attendence(); atten.ass_course_id = assCourse.Id; atten.rollno = studentList[i].rollno; atten.status = false; atten.assigned_course = assCourse; atten.student = studentList[i]; atten.date = DateTime.Now; model.Add(atten); } return(View(model)); } } return(View()); }
public bool ForgotPassword(string Username) { try { using (CMSEntities _context = new CMSEntities()) { if (_context.Users.Any(x => x.Username.Equals(Username))) { var acc = _context.Users.SingleOrDefault(x => x.Username.Equals(Username)); var NewPassword = CMS_Helpers.GeneratePassword(); acc.Password = CMS_Helpers.MD5(NewPassword); if (string.IsNullOrEmpty(acc.Email)) { CMS_Helpers.SendEmail(acc.Email, "Quên mật khẩu", "Mật khẩu mới là: " + NewPassword); return(true); } return(false); } return(false); } } catch (Exception e) { return(false); } }
public List <Res_User> GetList() { try { using (CMSEntities _context = new CMSEntities()) { return(_context.Users.Select(y => new Res_User { GUID = y.GUID, FirstName = y.FirstName, LastName = y.LastName, FullName = y.FullName, Username = y.Username, Email = y.Email, PhoneNumber = y.PhoneNumber, Address = y.Address, DateOfBirth = (DateTime)y.DateOfBirth, TokenLogin = y.TokenLogin, Active = (Boolean)y.Active }).ToList()); } } catch (Exception e) { return(null); } }
public bool UpdateStatus(string GUID) { try { using (CMSEntities _context = new CMSEntities()) { if (_context.Users.Any(x => x.GUID.Equals(GUID))) { var acc = _context.Users.SingleOrDefault(x => x.GUID.Equals(GUID)); acc.Active = !acc.Active; _context.SaveChanges(); return(true); } else { return(false); } } } catch (Exception e) { return(false); } }
public bool Delete(string GUID) { try { using (CMSEntities _context = new CMSEntities()) { if (_context.Users.Any(x => x.GUID.Equals(GUID))) { var acc = _context.Users.SingleOrDefault(x => x.GUID.Equals(GUID)); _context.Users.Remove(acc); _context.SaveChanges(); return(true); } else { return(false); } } } catch (Exception e) { return(false); } }
public bool ChangePassword(string TokenLogin, string NewPassword) { try { using (CMSEntities _context = new CMSEntities()) { if (_context.Users.Any(x => x.TokenLogin.Equals(TokenLogin))) { var acc = _context.Users.SingleOrDefault(x => x.TokenLogin.Equals(TokenLogin)); acc.Password = CMS_Helpers.MD5(NewPassword); _context.SaveChanges(); return(true); } else { return(false); } } } catch (Exception e) { return(false); } }
public Res_User Get(string GUID) { try { using (CMSEntities _context = new CMSEntities()) { return(_context.Users.Where(x => x.GUID.Equals(GUID)).Select(y => new Res_User { GUID = y.GUID, FirstName = y.FirstName, LastName = y.LastName, FullName = y.FullName, Username = y.Username, Email = y.Email, PhoneNumber = y.PhoneNumber, Address = y.Address, DateOfBirth = (DateTime)y.DateOfBirth, TokenLogin = y.TokenLogin, Active = (Boolean)y.Active }).SingleOrDefault()); } } catch (Exception e) { return(null); } }
public Res_Group Create(Req_Group item) { try { using (CMSEntities _context = new CMSEntities()) { if (!_context.Groups.Any(x => x.Code.Equals(item.Code))) { var group = new Group(); group.Code = item.Code; group.Name = item.Name; group.Active = item.Active; group.DateCreated = DateTime.UtcNow; _context.Groups.Add(group); _context.SaveChanges(); return(_context.Groups.Where(x => x.Code.Equals(group.Code)).Select(y => new Res_Group { Code = y.Code, Name = y.Name, Active = (bool)y.Active, DateCreated = (DateTime)y.DateCreated }).SingleOrDefault()); } return(null); } } catch (Exception e) { return(null); } }
public void BeforeScenario() { _CategoryRepository = new CategoryRepository(); _CmsEntitiesTest = new CMSEntities(); _CmsEntitiesTest.Categories.RemoveRange(_CmsEntitiesTest.Categories); _CmsEntitiesTest.SaveChanges(); }
public bool IsEmailExist(string emailID) { using (CMSEntities dc = new CMSEntities()) { var v = dc.Users.Where(a => a.EmailID == emailID).FirstOrDefault(); return(v != null); } }