public JsonResult GetmeHonda14()
{
StudentModel st = new Models.StudentModel();
st.StudentId = 1;
st.StudentName = "Prince";
StudentModel st1 = new Models.StudentModel();
st1.StudentId = 2;
st1.StudentName = "Vijaya";
StudentModel st2 = new Models.StudentModel();
st2.StudentId = 3;
st2.StudentName = "Nishikanth";
List <StudentModel> listObj = new List <StudentModel>();
listObj.Add(st);
listObj.Add(st1);
listObj.Add(st2);
return(Json(listObj, JsonRequestBehavior.AllowGet));
}
public ActionResult GetmeHonda9()
{
StudentModel st = new Models.StudentModel();
st.StudentId = 1;
st.StudentName = "Prince";
StudentModel st1 = new Models.StudentModel();
st1.StudentId = 2;
st1.StudentName = "Vijaya";
StudentModel st2 = new Models.StudentModel();
st2.StudentId = 3;
st2.StudentName = "Nishikanth";
List <StudentModel> listObj = new List <StudentModel>();
listObj.Add(st);
listObj.Add(st1);
listObj.Add(st2);
return(View(listObj));
}
public PartialViewResult GetmeHonda10()
{
StudentModel st = new Models.StudentModel();
st.StudentId = 1;
st.StudentName = "Prince";
StudentModel st1 = new Models.StudentModel();
st1.StudentId = 2;
st1.StudentName = "Vijaya";
StudentModel st2 = new Models.StudentModel();
st2.StudentId = 3;
st2.StudentName = "Nishikanth";
List <StudentModel> listObj = new List <StudentModel>();
listObj.Add(st);
listObj.Add(st1);
listObj.Add(st2);
return(PartialView("_MyPartialView", listObj));
}
public ActionResult BasicInfoPost(Models.StudentModel model)
{
var check = Data.Security.CheckForStudent(model.StudentId.Value, SessionItems.CurrentUser.UserId);
if (!check.Exists)
{
return(Json(new Helpers.JsonAjaxResult.result {
notFound = true, noAccess = false, errorList = new string[] { "" }, success = false
}));
}
if (!check.HasAccess)
{
return(Json(new Helpers.JsonAjaxResult.result {
notFound = false, noAccess = true, errorList = new string[] { "" }, success = false
}));
}
model.UserId = Helpers.SessionItems.CurrentUser.UserId;
if (!model.IsValid())
{
return(Json(new Helpers.JsonAjaxResult.result {
errorList = model.ValidationErrors.ToArray(), success = false
}));
}
else
{
Data.CRUD.UpdateStudent(model, Helpers.SessionItems.CurrentUser.UserId);
return(Json(new Helpers.JsonAjaxResult.result {
notFound = false, noAccess = false, errorList = new string[] { "" }, success = true
}));
}
}
public ActionResult StudentDetails(Models.StudentModel sm)
{
if (string.IsNullOrEmpty(sm.Name))
{
ModelState.AddModelError("Name", "Name Required");
}
if (sm.Age == 0 || sm.Age > 120)
{
ModelState.AddModelError("Age", "Please Enter Valid Age between 1-120");
}
if (!string.IsNullOrEmpty(sm.Email))
{
string emailRegex = @"^([a-zA-Z0-9_\-\.]+)@((\[[0-9]{1,3}" +
@"\.[0-9]{1,3}\.[0-9]{1,3}\.)|(([a-zA-Z0-9\-]+\" +
@".)+))([a-zA-Z]{2,4}|[0-9]{1,3})(\]?)$";
Regex re = new Regex(emailRegex);
if (!re.IsMatch(sm.Email))
{
ModelState.AddModelError("Email", "Email is not valid");
}
}
else
{
ModelState.AddModelError("Email", "Email is required");
}
if (!string.IsNullOrEmpty(sm.ConfirmEmail))
{
string emailRegex = @"^([a-zA-Z0-9_\-\.]+)@((\[[0-9]{1,3}" +
@"\.[0-9]{1,3}\.[0-9]{1,3}\.)|(([a-zA-Z0-9\-]+\" +
@".)+))([a-zA-Z]{2,4}|[0-9]{1,3})(\]?)$";
Regex re = new Regex(emailRegex);
if (!re.IsMatch(sm.ConfirmEmail))
{
ModelState.AddModelError("ConfirmEmail", "Email is not valid");
}
}
else
{
ModelState.AddModelError("ConfirmEmail", "Email is required");
}
if (ModelState.IsValid)
{
ViewBag.name = sm.Name;
ViewBag.email = sm.Email;
ViewBag.PhoneNumber = sm.PhoneNumber;
ViewBag.age = sm.Age;
return(View("Index"));
}
else
{
ViewBag.name = "No Data";
ViewBag.email = "No Data";
ViewBag.PhoneNumber = "No Data";
ViewBag.age = "No Data";
return(View("Index"));
}
}
public ActionResult PartialViewExample()
{
StudentModel std = new Models.StudentModel();
std.StudId = 1;
std.StudName = "Hari";
std.StudFees = 1000;
std.StudCourse = "Java";
return(View(std));
}
public ActionResult About()
{
studentA = new Models.StudentModel();
studentA.ID = 1;
studentA.FirstName = "Anas";
studentA.LastName = "Najaa";
studentA.Grade = "A+";
ViewBag.studentA = studentA;
return View();
}
public ActionResult HtmlHelper()
{
StudentModel st = new Models.StudentModel();
st.StudName = "Hari";
EmployeeEntities db = new EmployeeEntities();
ViewBag.Employess = new SelectList(db.employeeDetails, "EmpId", "EmpName", 17024);
return(View(st));
}
public PartialViewResult getPartialView()
{
StudentModel std = new Models.StudentModel();
std.StudId = 1;
std.StudName = "Hari";
std.StudFees = 1000;
std.StudCourse = "Java";
return(PartialView("_MyPartialView", std));
}
public ActionResult Student(Models.StudentModel objstu)
{
int i = obj.AddStudent(objstu);
if (i == 1)
{
Response.Write("Student Added");
}
else
{
Response.Write("Studenet Not Added");
}
return(View());
}
public ActionResult EditSkill(Models.StudentModel model, string btnSubmit)
{
switch (btnSubmit)
{
case "Submit":
// call update student SPROC
db.Update_student(model.StudentID, model.student.StudentID, model.student.Email, model.student.FirstName, model.student.LastName, model.student.ClassYear);
// return to student's profile page
break;
case ">>":
// rearrange lists and return to edit student page
try
{
foreach (var skill in model.skills.selectedSkills)
{
db.add_user_Skills(model.StudentID, Convert.ToInt32(skill));
}
}
catch
{
ModelState.AddModelError("Add Error", "You must select an extRec to be added");
}
return(RedirectToAction("EditStudent"));
case "<<":
// rearrange lists and return to edit student page
try
{
foreach (var skill in model.skills.selectedSkillsToRemove)
{
db.remove_user_Skills(model.StudentID, Convert.ToInt32(skill));
}
}
catch
{
ModelState.AddModelError("Remove Error", "You must select an extRec to be Removed");
}
return(RedirectToAction("EditStudent"));
default:
break;
}
return(RedirectToAction("Profile"));
}
public int AddStudent(Models.StudentModel objstu)
{
SqlConnection con = new SqlConnection(ConnectionStirng);
con.Open();
string query = "pro_student";
SqlCommand cmd = new SqlCommand(query, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@FirstName", SqlDbType.VarChar).Value = objstu.FirstName;
cmd.Parameters.Add("@SurName", SqlDbType.VarChar).Value = objstu.SurName;
cmd.Parameters.Add("@Email", SqlDbType.VarChar).Value = objstu.Email;
cmd.Parameters.Add("@IDNumber", SqlDbType.VarChar).Value = objstu.IDNumber;
int i = cmd.ExecuteNonQuery();
con.Close();
return(i);
}
public ActionResult Create(Models.StudentModel model)
{
model.UserId = Helpers.SessionItems.CurrentUser.UserId;
model.DoValidation();
if (!model.IsValid())
{
return(Json(new Helpers.JsonAjaxResult.result {
errorList = model.ValidationErrors.ToArray(), success = false
}));
}
else
{
model.UserId = SessionItems.CurrentUser.UserId;
Data.CRUD.InsertStudent(model, SessionItems.CurrentUser.UserId);
return(Json(new Helpers.JsonAjaxResult.result {
errorList = null, success = true
}));
}
}
public ActionResult EditStudent()
{
if (ExtFunctions.checkStudent())
{
MakerLabDBDataContext db = new MakerLabDBDataContext();
var student = db.get_Student_ByEmail(User.Identity.Name).FirstOrDefault();
var allskills = db.get_user_Skills(student.StudentID);
List <SelectListItem> selectList = new List <SelectListItem>();
List <SelectListItem> selectListActiveSkills = new List <SelectListItem>();
foreach (var skill in allskills)
{
if (skill.FLAG == 0)
{
selectList.Add(new SelectListItem()
{
Text = skill.Name, Value = skill.ID.ToString(), Selected = false
});
}
else
{
selectListActiveSkills.Add(new SelectListItem()
{
Text = skill.Name, Value = skill.ID.ToString(), Selected = false
});
}
}
var model = new Models.StudentModel()
{
StudentID = student.StudentID, student = student, skills = new Models.SkillModel()
{
Skills = selectList, CurrentSkills = selectListActiveSkills
}
};
return(View(model));
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
public ActionResult Index(Models.StudentModel student, int?id)
{
if (ModelState.IsValid)
{
if (id == null)
{
int iRecordsCreated = DataLibrary.BusinessLogic.StudentProcessor.CreateStudent(0, student.name, student.address, student.age, student.standard,
student.percent, student.addedOn, student.status);
}
else
{
DataLibrary.BusinessLogic.StudentProcessor.UpdateStudent(student.id, student.name, student.address, student.age, student.standard,
student.percent, student.addedOn, student.status);
}
//TempData["Result"] = createdId.Value == null ? result.Value : result.Value + " New Student Id is " + createdId.Value;
}
ViewBag.Operation = id == null ? "Add Student" : "Update Student";
BindStudent(0);
return(View());
}
public ActionResult getmePartialView()
{
StudentModel st = new Models.StudentModel();
st.sname = "Shoaib";
StudentModel st1 = new Models.StudentModel();
st1.sname = "prachi";
StudentModel st2 = new Models.StudentModel();
st2.sname = "Khader";
List <StudentModel> list = new List <Models.StudentModel>();
list.Add(st);
list.Add(st1);
list.Add(st2);
return(View(list));
}
public ActionResult Update(Models.StudentModel model, HttpPostedFileBase AvatarImage)
{
ViewBag.Levels = ShowLessonLevels();
var student = BLL.Data.StudentData.GetStudent(model.id);
if (AvatarImage != null)
{
student.avatarId = BLL.Data.AdditionalData.AddImage(model.id, new BLL.DTO.ImageWrapper(AvatarImage), false);
}
student.name = model.name;
student.email = model.email;
student.birthDate = model.birthDate;
student.Skype = model.Skype;
student.info = model.info;
student.adress = model.adress;
student.lessonsLevelId = model.lesonsLevel;
//student.regDate = model.regDate;
BLL.Data.StudentData.UpdateStudent(student);
return(Redirect("/Student/Index"));
}
