public IEnumerable <Student> Get()
{
using (StudentsEntities entities = new StudentsEntities())
{
return(entities.Students.ToList());
}
}
public JsonResult <object> MailVarify([FromBody] JObject json)
{
StudentVM re = JsonConvert.DeserializeObject <StudentVM>(json.ToString());
var obj = new object();
Dictionary <string, object> dic = new Dictionary <string, object>();
try
{
if (!string.IsNullOrWhiteSpace(re.EmailId))
{
using (StudentsEntities context = new StudentsEntities())
{
var result = context.MailVarify(re.EmailId).ToList();
if (result.Count <= 0)
{
dic.Add("Status", "1");
dic.Add("Message", "Varifyed");
}
else
{
dic.Add("Status", "2");
dic.Add("Message", "Already Registered!");
}
}
}
}
catch (Exception E)
{
dic.Add("Message", E.Message);
dic.Add("Status", "0");
}
obj = dic;
return(Json(obj));
}
public Student Get(int id)
{
using (StudentsEntities entities = new StudentsEntities())
{
return(entities.Students.FirstOrDefault(e => e.ID == id));
}
}
public JsonResult <object> DeleteUserbyId([FromBody] JObject json)
{
Allstd UserId = JsonConvert.DeserializeObject <Allstd>(json.ToString());
var obj = new object();
Dictionary <string, object> dic = new Dictionary <string, object>();
int DeleteId = Convert.ToInt32(UserId.StudentId);
try
{
using (StudentsEntities context = new StudentsEntities())
{
int Deleteduser = context.DeletebyId(DeleteId);
if (Deleteduser >= 1)
{
dic.Add("Message", "Deleted Successfully.");
dic.Add("Status", "1");
}
else
{
dic.Add("Message", "No Data available");
dic.Add("Status", "2");
}
}
}
catch (Exception E)
{
dic.Add("Message", E.Message);
dic.Add("Status", "0");
}
obj = dic;
return(Json(obj));
}
public bool IsEmailExist(string EmailId)
{
using (StudentsEntities DB = new StudentsEntities())
{
var email = DB.tbl_user.Where(a => a.EmailId == EmailId).FirstOrDefault();
return(email != null);
}
}
// GET: Menus
public ActionResult Index()
{
List <Student> m;
using (var r = new StudentsEntities())
{
m = r.Students.ToList();
}
return(View(m));
}
public ActionResult Index(LoginCheckVM log)
{
if (string.IsNullOrEmpty(log.EmailId))
{
ModelState.AddModelError("EmailId", "EmailId is required!");
}
if (string.IsNullOrEmpty(log.Password))
{
ModelState.AddModelError("Password", "Password is required!");
}
if (ModelState.IsValid)
{
List<LoginCheckVM> SubList = new List<LoginCheckVM>();
using (StudentsEntities context = new StudentsEntities())
{
var result = context.LoginCheck(log.EmailId.Trim(), log.Password.Trim()).ToList();
if (result.Count > 0)
{
foreach (var item in result.ToList())
{
SubList.Add(new LoginCheckVM
{
StudentId = item.StudentId,
FirstName = item.FirstName,
LastName = item.LastName,
EmailId = item.EmailId,
Role = item.Role
});
}
Session["StudentId"] = SubList[0].StudentId <= 0 ? 0 : SubList[0].StudentId;
Session["FirstName"] = SubList[0].FirstName;
Session["LastName"] = SubList[0].LastName;
Session["EmailId"] = SubList[0].EmailId;
Session["Role"] = SubList[0].Role;
TempData["UserName"] = SubList[0].FirstName + " " + SubList[0].LastName;
TempData["StudentId"] = SubList[0].StudentId;
if (SubList[0].Role.Contains("Admin"))
{
return RedirectToAction("AdminDeshBoard", "Home");
}
else
{
return RedirectToAction("UserProfile", "Home");
}
}
else
{
return RedirectToAction("index", "Home");
}
}
}
return View();
}
public ActionResult Delete_Get(int Id)
{
var menumodel = new Student();
TryUpdateModel(menumodel);
using (var r = new StudentsEntities())
{
menumodel = r.Students.FirstOrDefault(x => x.Id == Id);
}
return(View(menumodel));
}
public ActionResult Create_Post()
{
var menusmodel = new Student();
TryUpdateModel(menusmodel);
using (var r = new StudentsEntities())
{
r.Students.Add(menusmodel);
r.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult Edit_Post(int Id)
{
var menumodel = new Student();
TryUpdateModel(menumodel);
using (var r = new StudentsEntities())
{
var m = r.Students.Where(x => x.Id == Id).FirstOrDefault();
TryUpdateModel(m);
r.SaveChanges();
}
return(RedirectToAction("Index"));
}
public JsonResult <object> EditUserbyId([FromBody] JObject json)
{
StudentVM request = JsonConvert.DeserializeObject <StudentVM>(json.ToString());
var obj = new object();
int UserIdEdit = Convert.ToInt32(request.StudentId);
Dictionary <string, object> dic = new Dictionary <string, object>();
StudentVM StudentDetail = new StudentVM();
using (StudentsEntities context = new StudentsEntities())
{
Student re = context.UserDetailbyId(UserIdEdit).FirstOrDefault();
StudentDetail.StudentId = re.StudentId;
StudentDetail.FirstName = re.FirstName;
StudentDetail.LastName = re.LastName;
StudentDetail.DOB = (re.DOB);
StudentDetail.EmailId = re.EmailId;
StudentDetail.PhoneNo = re.PhoneNo;
StudentDetail.Address = re.Address;
StudentDetail.FatherName = re.FatherName;
StudentDetail.BloodGroup = re.BloodGroup;
StudentDetail.MainSubject = re.MainSubject;
StudentDetail.Obtional1 = re.Obtional1;
StudentDetail.Obtional2 = re.Obtional2;
StudentDetail.Obtional3 = re.Obtional3;
StudentDetail.Obtional4 = re.Obtional4;
StudentDetail.category = re.category;
StudentDetail.ProfilePic = re.ProfilePic;
StudentDetail.Document1 = re.Document1;
StudentDetail.Document2 = re.Document2;
StudentDetail.Password = re.Password;
StudentDetail.SubjectId = Convert.ToInt32(re.SubjectId);
StudentDetail.BloodGroupId = Convert.ToInt32(re.BloodGroupId);
if (StudentDetail != null)
{
dic.Add("result", StudentDetail);
dic.Add("Message", "UserDetail");
dic.Add("Status", "1");
}
else
{
dic.Add("Message", "No Data available");
dic.Add("Status", "2");
}
obj = dic;
return(Json(obj));
}
}
public IList <SubjectVM> GetSubjectList()
{
List <SubjectVM> SubList = new List <SubjectVM>();
using (StudentsEntities context = new StudentsEntities())
{
var result = context.SubjectList().ToList();
foreach (var item in result.ToList())
{
SubList.Add(new SubjectVM {
SubjectId = item.SubjectId,
SubjectName = item.SubjectName
});
}
return(SubList);
}
}
public ActionResult LogIn(StudentModel id)
{
if (ModelState.IsValid)
{
using (StudentsEntities DB = new StudentsEntities())
{
var ID = DB.tbl_user.Where(a => a.EmailId.Equals(id.EmailId) && a.Password.Equals(id.Password)).FirstOrDefault();
if (ID != null)
{
Session["LoggedEmailID"] = ID.EmailId.ToString();
Session["LoggedUserFirstName"] = ID.FirstName.ToString();
return(RedirectToAction("Registration"));
}
}
}
return(View(id));
}
public JsonResult <object> ProfilePicUpdate([FromBody] JObject json)
{
StudentVM re = JsonConvert.DeserializeObject <StudentVM>(json.ToString());
var obj = new object();
Dictionary <string, object> dic = new Dictionary <string, object>();
string Image1 = re.ProfilePic;
string SavePath1 = "";
try
{
if (!string.IsNullOrWhiteSpace(Image1))
{
var postedFile = Image1;
if (!Directory.Exists(HttpContext.Current.Server.MapPath("~/Document/ProfilePic/")))
{
Directory.CreateDirectory(HttpContext.Current.Server.MapPath("~/Document/ProfilePic/"));
}
string ImagePath1 = HttpContext.Current.Server.MapPath("~/Document/ProfilePic/") + re.FirstName + re.LastName + ".jpg";
SavePath1 = "/Document/ProfilePic/" + re.FirstName + re.LastName + ".jpg";
if (File.Exists(ImagePath1))
{
File.Delete(ImagePath1);
}
byte[] Image1D = Convert.FromBase64String(Image1.ToString());
Stream stmImage1D = new MemoryStream(Image1D);
Bitmap originalBMP1 = new Bitmap(stmImage1D);
originalBMP1.Save(ImagePath1);
}
using (StudentsEntities context = new StudentsEntities())
{
var result = context.ProfilePicUpdate(re.StudentId, SavePath1);
dic.Add("Status", "1");
dic.Add("Message", "Success");
}
}
catch (Exception E)
{
dic.Add("Message", E.Message);
dic.Add("Status", "0");
}
obj = dic;
return(Json(obj));
}
public IList <BloodGroupVM> GetBloodGroupList()
{
List <BloodGroupVM> BloodGroupList = new List <BloodGroupVM>();
using (StudentsEntities context = new StudentsEntities())
{
var result = context.BloodGroupList().ToList();
foreach (var item in result.ToList())
{
BloodGroupList.Add(new BloodGroupVM
{
BloodGroupId = item.BloodGroupId,
BloodGroupName = item.BloodGroupName
});
}
return(BloodGroupList);
}
}
public ActionResult SearchGrade(StudentVM vm)
{
using (var context = new StudentsEntities())
{
var st = context.StudentsTable
.Where(s => s.StudentID == vm.StudentID)
.FirstOrDefault();
if (st == null)
{
StudentsTable StudentNotFound = new StudentsTable();
StudentNotFound.GradeInEnglishCourse = null;
st = StudentNotFound;
}
ViewData["student"] = st;
return(View());
}
}
public ActionResult Login(Login lg)
{
if (ModelState.IsValid)
{
using (StudentsEntities se = new StudentsEntities()) {
var log = se.students.Where(a => a.Username.Equals(lg.username) && a.Password.Equals(lg.password)).FirstOrDefault();
if (log != null)
{
Session["username"] = log.Username;
return(RedirectToAction("StudentHome", "Home"));
}
else
{
lg.Err = true;
return(RedirectToAction("DoSomething", "Home"));
}
}
}
return(View());
}
public IList <Allstd> GetAllStudents()
{
List <Allstd> StudentList = new List <Allstd>();
using (StudentsEntities context = new StudentsEntities())
{
var result = context.StudentRecord().ToList();
foreach (var item in result.ToList())
{
StudentList.Add(new Allstd
{
StudentId = item.StudentId,
Name = item.FirstName,
LastName = item.LastName,
EmailId = item.EmailId,
PhoneNo = item.PhoneNo,
ImgProfile = item.ProfilePic
});
}
return(StudentList);
}
}
public CoursesController()
{
_DbContext = new StudentsEntities();
}
public JsonResult <object> UpdateUserDetail([FromBody] JObject json)
{
StudentVM re = JsonConvert.DeserializeObject <StudentVM>(json.ToString());
var obj = new object();
Dictionary <string, object> dic = new Dictionary <string, object>();
string Image1 = re.ProfilePic;
string Image2 = re.Document1;
string Image3 = re.Document2;
string SavePath1 = "";
string SavePath2 = "";
string SavePath3 = "";
try
{
if (!string.IsNullOrEmpty(Image1))
{
var postedFile = Image1;
if (!Directory.Exists(HttpContext.Current.Server.MapPath("~/Document/ProfilePic/")))
{
Directory.CreateDirectory(HttpContext.Current.Server.MapPath("~/Document/ProfilePic/"));
}
string ImagePath1 = HttpContext.Current.Server.MapPath("~/Document/ProfilePic/") + re.FirstName + re.LastName + ".jpg";
SavePath1 = "/Document/ProfilePic/" + re.FirstName + re.LastName + ".jpg";
if (File.Exists(ImagePath1))
{
File.Delete(ImagePath1);
}
byte[] Image1D = Convert.FromBase64String(Image1.ToString());
Stream stmImage1D = new MemoryStream(Image1D);
Bitmap originalBMP1 = new Bitmap(stmImage1D);
originalBMP1.Save(ImagePath1);
}
if (!string.IsNullOrEmpty(Image2))
{
var postedFile = Image2;
if (!Directory.Exists(HttpContext.Current.Server.MapPath("~/Document/Documents/")))
{
Directory.CreateDirectory(HttpContext.Current.Server.MapPath("~/Document/Documents/"));
}
string ImagePath2 = HttpContext.Current.Server.MapPath("~/Document/Documents/") + re.FirstName + re.LastName + "Doc1.jpg";
SavePath2 = "/Document/Documents/" + re.FirstName + re.LastName + "Doc1.jpg";
if (File.Exists(ImagePath2))
{
File.Delete(ImagePath2);
}
byte[] Image2D = Convert.FromBase64String(Image2.ToString());
Stream stmImage2D = new MemoryStream(Image2D);
Bitmap originalBMP2 = new Bitmap(stmImage2D);
originalBMP2.Save(ImagePath2);
}
if (!string.IsNullOrEmpty(Image3))
{
var postedFile = Image3;
if (!Directory.Exists(HttpContext.Current.Server.MapPath("~/Document/Documents/")))
{
Directory.CreateDirectory(HttpContext.Current.Server.MapPath("~/Document/Documents/"));
}
string ImagePath3 = HttpContext.Current.Server.MapPath("~/Document/Documents/") + re.FirstName + re.LastName + "Doc2.jpg";
SavePath3 = "/Document/Documents/" + re.FirstName + re.LastName + "Doc2.jpg";
if (File.Exists(ImagePath3))
{
File.Delete(ImagePath3);
}
byte[] Image3D = Convert.FromBase64String(Image3.ToString());
Stream stmImage3D = new MemoryStream(Image3D);
Bitmap originalBMP3 = new Bitmap(stmImage3D);
originalBMP3.Save(ImagePath3);
}
using (StudentsEntities context = new StudentsEntities())
{
var result = context.StudentUpdate(re.StudentId, re.FirstName, re.LastName, re.DOB, re.PhoneNo, re.Address, re.BloodGroup, SavePath1, re.FatherName, re.category, re.MainSubject, SavePath2, SavePath3, re.Password, re.Obtional1, re.Obtional2, re.Obtional3, re.Obtional4, re.Role, Convert.ToBoolean(0), re.SubjectId, re.BloodGroupId);
dic.Add("Status", "1");
dic.Add("Message", "Success");
}
}
catch (Exception E)
{
dic.Add("Message", E.Message);
dic.Add("Status", "0");
}
obj = dic;
return(Json(obj));
}
