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