public IHttpActionResult Post(StudentMaster model)
{
try
{
//bool isExist = db.StudentMasters.Any(x => x.StudentName.Trim() == model.StudentName.Trim() && x.ParentsName.Trim() == model.ParentsName.Trim());
//if (isExist)
//{
// return BadRequest(Message.AlreadyExist);
//}
//bool isExistEmail = db.StudentMasters.Any(x => x.StudentEmail.Trim() == model.StudentEmail.Trim());
//if (isExistEmail)
//{
// return BadRequest("Email Alrady Exist");
//}
// model.ParentsName = model.ParentsName.Trim();
model.StudentName = model.StudentName.Trim();
// model.StudentEmail = model.StudentEmail.Trim();
db.StudentMasters.Add(model);
db.SaveChanges();
string output = string.Empty;
return(Ok(new ResponseViewModel(Message.Add, HttpStatusCode.OK, output)));
}
catch (Exception e)
{
throw;
}
}
public IHttpActionResult PutStudentMaster(int id, StudentMaster studentMaster)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != studentMaster.ID)
{
return(BadRequest());
}
db.Entry(studentMaster).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!StudentMasterExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public List <StudentMaster> GetStudents()
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["InstituteSystem"].ConnectionString);
SqlCommand comm = new SqlCommand("ReadStudents", conn);
List <StudentMaster> students = new List <StudentMaster>();
comm.CommandType = CommandType.StoredProcedure;
try
{
conn.Open();
comm.ExecuteNonQuery();
SqlDataReader dataReader = comm.ExecuteReader();
while (dataReader.Read())
{
StudentMaster studentMaster = new StudentMaster();
studentMaster.StudentId = dataReader.GetInt32(0);
studentMaster.FirstName = dataReader.GetString(1);
studentMaster.MiddleName = dataReader.GetString(2);
studentMaster.LastName = dataReader.GetString(3);
studentMaster.TotalFees = dataReader.GetInt64(11);
studentMaster.IsStudentActive = dataReader.GetString(14);
students.Add(studentMaster);
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
finally
{
conn.Close();
}
return(students);
}
public async Task <IActionResult> Edit(int id, [Bind("ID,Name,Age,Gender,Email,FatherName,ExhibitionID,ClassMasterID")] StudentMaster studentMaster)
{
if (id != studentMaster.ID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(studentMaster);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!StudentMasterExists(studentMaster.ID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["ClassMasterID"] = new SelectList(_context.ClassMasters, "ID", "ClassName", studentMaster.ClassMasterID);
ViewData["ExhibitionID"] = new SelectList(_context.ExhibitionCoordinatorMasters, "ID", "Name", studentMaster.ExhibitionID);
return(View(studentMaster));
}
private void LoadAllCourses()
{
try
{
StudentMaster objSM = db.StudentMasters.Where(aa => aa.S_AYN == "Y" && aa.S_USERNAME == objUser.U_USERNAME).FirstOrDefault();
List <CourseMaster> lstCourses = db.CourseMasters.Where(aa => aa.C_AYN == "Y").ToList();
List <StudentEnrollCourseTran> lstStudentCourses = db.StudentEnrollCourseTrans.Where(aa => aa.SEC_AYN == "Y" && aa.SEC_STUDENT_ID == objSM.S_ID).ToList();
foreach (var SECT in lstStudentCourses)
{
for (int i = lstCourses.Count() - 1; i >= 0; i--)
{
if (SECT.SEC_COURSE_ID == lstCourses[i].C_ID)
{
lstCourses.RemoveAt(i);
}
}
}
gvCourses.DataSource = lstCourses;
gvCourses.DataBind();
}
catch (Exception ee)
{
}
}
public void Test_Podaci()
{
StudentMaster sM = new StudentMaster("Janis*1", "/1Joplin", new DateTime(1995, 12, 27), "2712995177657", DateTime.Now, "PFSA");
StudentBachelor sB = new StudentBachelor("Norah", "Jones321", new DateTime(1995, 12, 27), "2712995177657", new DateTime(2014, 10, 10));
//ocekivano je padanje jer format imena i prezimena nije tacan
}
public ActionResult Index(StudentViewModel objStudentViewModel)
{
StudentMaster objStudentMaster = new StudentMaster()
{
Name = objStudentViewModel.StudentName,
ClassName = objStudentViewModel.ClassName,
ExamId = objStudentViewModel.ExamId,
RollNumber = objStudentViewModel.RollNumber
};
objStudentDBEntities.StudentMasters.Add(objStudentMaster);
objStudentDBEntities.SaveChanges();
foreach (var item in objStudentViewModel.ListOfStudentMarks)
{
StudentDetail objStudentDetail = new StudentDetail()
{
MarksObtained = item.ObtainedMarks,
Percentage = Convert.ToInt32(item.Percentage), ///to check conversion
StudentId = objStudentMaster.StudentId,
TotalMarks = item.TotalMarks,
SubjectId = item.SubjectId
};
objStudentDBEntities.StudentDetails.Add(objStudentDetail);
objStudentDBEntities.SaveChanges();
}
return(Json(new { message = "Data successfully added", status = true }, JsonRequestBehavior.AllowGet));
}
public void Test_FormatIndexMaster()
{
StudentMaster s = new StudentMaster("Janis", "Joplin", new DateTime(1995, 12, 27), "2712995177657", DateTime.Now, "PFSA");
Regex r = new Regex(@"^[0-9]{3}/[0-9]{6}");
StringAssert.Matches(s.BrojIndeks, r);
}
public string Create([Bind(Exclude = "Id")] StudentMaster Model)
{
ApplicationDbContext db = new ApplicationDbContext();
string msg;
try
{
if (ModelState.IsValid)
{
Model.ID = Guid.NewGuid().ToString();
db.Students.Add(Model);
db.SaveChanges();
msg = "Saved Successfully";
}
else
{
msg = "Validation data not successfully";
}
}
catch (Exception ex)
{
msg = "Error occured:" + ex.Message;
}
return(msg);
}
public ActionResult StudentRegistration(StudentMaster student)
{
StudentService add = new StudentService();
add.AddStudent(student);
return(RedirectToAction("AllStudents"));
}
public IHttpActionResult Put(int id, StudentMaster model)
{
try
{
//bool isExist = db.StudentMasters.Any(x => x.StudentName.Trim() == model.StudentName.Trim() && x.ParentsName.Trim() == model.ParentsName.Trim() && x.StudentId != model.StudentId);
//if (isExist)
//{
// return BadRequest(Message.AlreadyExist);
//}
//bool isExistEmail = db.StudentMasters.Any(x => x.StudentEmail.Trim() == model.StudentEmail.Trim() && x.StudentId != model.StudentId);
//if (isExistEmail)
//{
// return BadRequest("Email Alrady Exist");
//}
// model.ParentsName = model.ParentsName.Trim();
model.StudentName = model.StudentName.Trim();
// model.StudentEmail = model.StudentEmail.Trim();
db.Entry(model).State = EntityState.Modified;
// db.Entry(model.StudentCoursesMappings.)
db.SaveChanges();
return(Ok(new ResponseViewModel(Message.Updated, HttpStatusCode.OK, null)));
}
catch (Exception e)
{
throw;
}
}
public ActionResult DeleteConfirmed(int id)
{
StudentMaster studentMaster = db.StudentMasters.Find(id);
db.StudentMasters.Remove(studentMaster);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public int Update(StudentModel model)
{
Mapper.CreateMap <StudentModel, StudentMaster>();
StudentMaster objUser = Dbcontext.StudentMasters.SingleOrDefault(m => m.StudID == model.StudID);
objUser = Mapper.Map(model, objUser);
return(Dbcontext.SaveChanges());
}
public string Delete(string Id)
{
ApplicationDbContext db = new ApplicationDbContext();
StudentMaster student = db.Students.Find(Id);
db.Students.Remove(student);
db.SaveChanges();
return("Deleted successfully");
}
public long Save(StudentMaster master)
{
if (master.StudentId == 0)
{
db.StudentMasters.Add(master);
}
db.SaveChanges();
return(master.StudentId);
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
StudentMaster objStudentCheck = db.StudentMasters.Where(aa => aa.S_AYN == "Y" && aa.S_USERNAME == txtUserName.Text.Trim()).FirstOrDefault();
if (objStudentCheck != null)
{
lblErrMsg.Text = "User name already exits, Please try another name";
}
else
{
StudentMaster objNewStudent = new StudentMaster();
objNewStudent.S_USERNAME = txtUserName.Text.Trim();
objNewStudent.S_PWD = txtPwd.Text.Trim();
objNewStudent.S_NAME = txtStudentName.Text.Trim();
objNewStudent.S_DESCRIPTION = txtDescription.Text.Trim();
objNewStudent.S_QUALIFICATION = txtQualification.Text.Trim();
objNewStudent.S_EMAIL = txtEmail.Text.Trim();
objNewStudent.S_PHNUM = txtPhNum.Text.Trim();
objNewStudent.S_ADDRESS = txtAddress.Text.Trim();
objNewStudent.S_AYN = "Y";
objNewStudent.CDATE = DateTime.Now.ToString("yyyyMMddHHmmss");
objNewStudent.CUSER = "******";
db.StudentMasters.Add(objNewStudent);
User objUser = new Models.User();
objUser.U_USERNAME = txtUserName.Text.Trim();
objUser.U_PASSWORD = txtPwd.Text.Trim();
objUser.U_FIRSTNAME = txtStudentName.Text.Trim();
objUser.U_LASTNAME = txtDescription.Text.Trim();
objUser.U_EMAIL = txtEmail.Text.Trim();
objUser.U_PHNUM = txtPhNum.Text.Trim();
objUser.U_ADDRESS = txtAddress.Text.Trim();
objUser.U_ROLE_ID = 3;
objUser.U_ROLE_NAME = "Student";
objUser.U_ISACTIVE = "Y";
objUser.CDATE = DateTime.Now.ToString("yyyyMMddHHmmss");
objUser.CUSER = "******";
db.Users.Add(objUser);
db.SaveChanges();
Response.Redirect("~/Admin/StudentsList.aspx");
}
}
catch (Exception ee)
{
}
}
protected void submitButton_Click(object sender, EventArgs e)
{
try
{
if (lblLoginUser.Text.Trim().Length > 0)
{
int iUserid = Convert.ToInt32(lblLoginUser.Text.Trim());
User objUpdateUser = db.Users.Where(aa => aa.U_ID == iUserid && aa.U_ISACTIVE == "Y").SingleOrDefault();
if (objUpdateUser != null)
{
objUpdateUser.U_FIRSTNAME = txtFirstName.Text;
objUpdateUser.U_LASTNAME = txtLastName.Text;
objUpdateUser.U_EMAIL = txtEmail.Text;
objUpdateUser.U_PHNUM = txtPhNum.Text;
objUpdateUser.U_ADDRESS = txtAddress.Text;
objUpdateUser.MUSER = strLoginUser;
objUpdateUser.MDATE = DateTime.Now.ToString("yyyyMMddHHmmss");
StudentMaster objUpdateStudent = db.StudentMasters.Where(aa => aa.S_USERNAME == objUpdateUser.U_USERNAME && aa.S_AYN == "Y").SingleOrDefault();
objUpdateStudent.S_NAME = txtFirstName.Text.Trim();
objUpdateStudent.S_DESCRIPTION = txtLastName.Text.Trim();
objUpdateStudent.S_EMAIL = txtEmail.Text.Trim();
objUpdateStudent.S_PHNUM = txtPhNum.Text.Trim();
objUpdateStudent.S_ADDRESS = txtAddress.Text.Trim();
db.SaveChanges();
txtFirstName.Text = "";
txtLastName.Text = "";
txtEmail.Text = "";
txtPhNum.Text = "";
txtAddress.Text = "";
lblResult.Text = "Profile updated successfully";
Session["LoginUser"] = objUpdateUser;
}
}
/*
* txtFirstName.Text = objViewUser.U_FIRSTNAME;
* txtLastName.Text = objViewUser.U_LASTNAME;
* txtEmail.Text = objViewUser.U_EMAIL;
* txtPhNum.Text = objViewUser.U_PHNUM;
* txtAddress.Text = objViewUser.U_ADDRESS;
*
* lblLoginUser.Text =
*/
}
catch (Exception ee)
{
lblResult.Text = "";
}
}
public ActionResult AddStudent(StudentMaster data)
{
if (ModelState.IsValid)
{
dbContext.StudentMasters.Add(data);
dbContext.SaveChanges();
return(RedirectToAction("StudentsList"));
}
return(View(data));
}
protected void submitButton_Click(object sender, EventArgs e)
{
try
{
var objCheckUser = db.Users.Where(aa => aa.U_ISACTIVE == "Y" && aa.U_USERNAME == txtUserName.Text.Trim()).FirstOrDefault();
if (objCheckUser == null)
{
User objUser = new User();
objUser.U_USERNAME = txtUserName.Text.Trim();
objUser.U_PASSWORD = txtPwd.Text.Trim();
objUser.U_FIRSTNAME = txtFirstName.Text.Trim();
objUser.U_LASTNAME = txtLastName.Text.Trim();
objUser.U_EMAIL = txtEmail.Text.Trim();
objUser.U_PHNUM = txtPhNum.Text.Trim();
objUser.U_ADDRESS = txtAddress.Text.Trim();
objUser.U_ISACTIVE = "Y";
objUser.CUSER = txtUserName.Text.Trim();
objUser.CDATE = DateTime.Now.ToString("yyyyMMddHHmmss");
objUser.U_ROLE_ID = 3;
objUser.U_ROLE_NAME = "Student";
db.Users.Add(objUser);
StudentMaster objNewStudent = new StudentMaster();
objNewStudent.S_USERNAME = txtUserName.Text.Trim();
objNewStudent.S_PWD = txtPwd.Text.Trim();
objNewStudent.S_NAME = txtFirstName.Text.Trim();
objNewStudent.S_DESCRIPTION = txtLastName.Text.Trim();
objNewStudent.S_EMAIL = txtEmail.Text.Trim();
objNewStudent.S_PHNUM = txtPhNum.Text.Trim();
objNewStudent.S_ADDRESS = txtAddress.Text.Trim();
objNewStudent.S_AYN = "Y";
objNewStudent.CDATE = DateTime.Now.ToString("yyyyMMddHHmmss");
objNewStudent.CUSER = txtUserName.Text.Trim();
db.StudentMasters.Add(objNewStudent);
db.SaveChanges();
Session["role"] = "3";
Response.Redirect("~/frmlogin.aspx");
}
else
{
resultLabel.Text = "Username already exits....! Please try some other username";
txtUserName.Focus();
}
}
catch (Exception ee)
{
}
}
public void Test_JedinstvenIndeksMaster()
{
StudentMaster sM = new StudentMaster("Janis", "Joplin", new DateTime(1995, 12, 27), "2712995177657", DateTime.Now, "PFSA");
fax.upisiMasterDrugiFaks(sM);
List <String> indeksi = fax.dajSveIndekse();
String iM = sM.BrojIndeks.Substring(4, 6);
CollectionAssert.DoesNotContain(indeksi, iM); //test ne bi trebao pasti
}
public ActionResult result(tbl_StudentView objstudentViewModel)
{
int teacherid = Convert.ToInt32(Session["Teacher"]);
int schoolid;
var data = db.Teachers.Find(teacherid);
schoolid = data.School_Id;
string RegNo = Session["Regno"].ToString();
CourseDBHandle gc = new CourseDBHandle();
List <tbl_CourseAssigntoTeacherValidation> list = gc.GetTeacherStudentSimilarCourse(teacherid, RegNo);
ViewBag.course = new SelectList(list, "courseId", "courseName");
StudentMaster objStudentMaster = new StudentMaster()
{
Name = objstudentViewModel.Name,
ClassName = objstudentViewModel.ClassName,
CreatedBy = teacherid,
SectionName = objstudentViewModel.SectionName,
Exam_Id = Convert.ToInt32(objstudentViewModel.Exam_Id),
RegNo = objstudentViewModel.RegNo
};
db.StudentMasters.Add(objStudentMaster);
db.SaveChanges();
foreach (var item in objstudentViewModel.ListofStudentMarks)
{
StudentResult objstudentResult = new StudentResult()
{
CourseId = item.CourseId,
TotalMarks = item.TotalMarks,
MarksObtained = item.MarksObtained,
SchoolId = schoolid,
Percentage = item.Percentage,
Exam_Id = Convert.ToInt32(objstudentViewModel.Exam_Id),
ClassId = objstudentViewModel.ClassId,
CreatedDate = DateTime.Now,
StudentMasterId = objStudentMaster.Id,
StudentId = objstudentViewModel.StudentIdtable,
SectionId = objstudentViewModel.SectionId
};
db.StudentResults.Add(objstudentResult);
db.SaveChanges();
}
return(Json(new { message = "Data Successfully Added", status = true }, JsonRequestBehavior.AllowGet));
}
public IHttpActionResult GetStudentMaster(int id)
{
StudentMaster studentMaster = db.StudentMasters.Find(id);
if (studentMaster == null)
{
return(NotFound());
}
return(Ok(studentMaster));
}
public ActionResult Edit([Bind(Include = "StudentId,StudentName,ClassId,TeacherId,Address,Mobile,Gender,Email")] StudentMaster studentMaster)
{
if (ModelState.IsValid)
{
db.Entry(studentMaster).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ClassId = new SelectList(db.ClassMasters, "ClassId", "ClassName", studentMaster.ClassId);
ViewBag.TeacherId = new SelectList(db.TeacherMasters, "TeacherId", "TeacherName", studentMaster.TeacherId);
return(View(studentMaster));
}
public async Task <IActionResult> Create([Bind("ID,Name,ClassMasterID")] StudentMaster studentMaster)
{
if (ModelState.IsValid)
{
_context.Add(studentMaster);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["ClassMasterID"] = new SelectList(_context.ClassMasters, "ID", "ClassName", studentMaster.ClassMasterID);
return(View(studentMaster));
}
public void Test_IspravanIndeks()
{
StudentBachelor s1 = new StudentBachelor("Dzana", "Hanic", new DateTime(1995, 12, 27), "2712995177657", new DateTime(2014, 10, 10));
String iB = s1.BrojIndeks;
StudentMaster s2 = new StudentMaster("Dzana", "Hanic", new DateTime(1995, 12, 27), "2712995177657", new DateTime(2017, 10, 10));
String iM = s2.BrojIndeks;
fax.upisiStudenta(s1);
fax.upisiStudenta(s2);
Assert.AreEqual(iB, iM.Substring(4, 6));
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
StudentMaster Obj_Add_Stu = new StudentMaster
{
StudentName = studentName.Text,
ClassMasterID = Convert.ToInt32(ddl_Class.SelectedValue),
ExhibitionCoordinatorMasterID = Convert.ToInt32(ddl_Exhibition.SelectedValue)
};
StudentMasterBuss.SaveStudents(Obj_Add_Stu);
StudentFill();
}
public IHttpActionResult PostStudentMaster(StudentMaster studentMaster)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.StudentMasters.Add(studentMaster);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = studentMaster.ID }, studentMaster));
}
public async Task <IActionResult> Create([Bind("ID,Name,Age,Gender,Email,FatherName,ExhibitionID,ClassMasterID")] StudentMaster studentMaster)
{
if (ModelState.IsValid)
{
_context.Add(studentMaster);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["ClassMasterID"] = new SelectList(_context.ClassMasters, "ID", "ClassName", studentMaster.ClassMasterID);
ViewData["ExhibitionID"] = new SelectList(_context.ExhibitionCoordinatorMasters, "ID", "Name", studentMaster.ExhibitionID);
return(View(studentMaster));
}
public static string[] GetCompletionListStudent(string prefixText, int count, string contextKey)
{
StudentMaster objStudent = new StudentMaster();
DataTable dt = new DataView(objStudent.GetStudentMaster(HttpContext.Current.Session["CompId"].ToString()), "Student like '" + prefixText.ToString() + "%'", "", DataViewRowState.CurrentRows).ToTable();
string[] txt = new string[dt.Rows.Count];
for (int i = 0; i < dt.Rows.Count; i++)
{
txt[i] = dt.Rows[i]["Student"].ToString();
}
return(txt);
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
StudentMaster _Stu = new StudentMaster
{
ID = Convert.ToInt32(ddl_Student.SelectedValue),
StudentName = studentName.Text,
ExhibitionCoordinatorMasterID = Convert.ToInt32(ddl_Exhibition.SelectedValue),
ClassMasterID = Convert.ToInt32(ddl_Class.SelectedValue)
};
StudentMasterBuss.UpdateStudent(_Stu);
StudentFill();
}
