public bool AddStudent(StudentModel sModel) { //TODO if user exist not insert StudentLogic studentLogicBL = new StudentLogic(); StudentsDetail studentsDetailList = new StudentsDetail(); studentsDetailList.UserName = sModel.UserName; //Encrypt Password var keyNew = EncryptUtility.GeneratePassword(10); var encryptPassword = EncryptUtility.EncodePassword(sModel.Password, keyNew); studentsDetailList.Password = encryptPassword; studentsDetailList.student_first_name = sModel.FirstName; studentsDetailList.student_last_name = sModel.LastName; studentsDetailList.student_middle_name = sModel.MiddleName; studentsDetailList.student_address1 = sModel.Address_Line1; studentsDetailList.student_city = sModel.City; studentsDetailList.student_country = sModel.Country; studentsDetailList.student_email = sModel.Email; studentsDetailList.student_graduation_year = sModel.GraduationYear; studentsDetailList.student_id = sModel.StudentId; studentsDetailList.is_international_student = sModel.isInternationStudent; studentsDetailList.date_created = DateTime.Now; return(studentLogicBL.AddStudent(studentsDetailList)); //return false; }
public ActionResult DeleteConfirmed(int id) { StudentsDetail studentsDetail = db.StudentsDetails.Find(id); db.StudentsDetails.Remove(studentsDetail); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "StudentsId,StudentsName,EmailId,Contact,YearOfPassing,Gender,StudentsCategory,StudentsBatchId,LastModifiedDate,LastModifiedBy,CreatedDate,CreatedBy")] StudentsDetail studentsDetail) { if (ModelState.IsValid) { db.Entry(studentsDetail).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.StudentsBatchId = new SelectList(db.BatchDetails, "StudentsBatchId", "StudentsBatchName", studentsDetail.StudentsBatchId); ViewBag.StudentsBatchId = new SelectList(db.BatchDetails, "StudentsBatchId", "StudentsBatchName", studentsDetail.StudentsBatchId); return(View(studentsDetail)); }
// GET: StudentsDetails/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } StudentsDetail studentsDetail = db.StudentsDetails.Find(id); if (studentsDetail == null) { return(HttpNotFound()); } return(View(studentsDetail)); }
// GET: StudentsDetails/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } StudentsDetail studentsDetail = db.StudentsDetails.Find(id); if (studentsDetail == null) { return(HttpNotFound()); } ViewBag.StudentsBatchId = new SelectList(db.BatchDetails, "StudentsBatchId", "StudentsBatchName", studentsDetail.StudentsBatchId); ViewBag.StudentsBatchId = new SelectList(db.BatchDetails, "StudentsBatchId", "StudentsBatchName", studentsDetail.StudentsBatchId); return(View(studentsDetail)); }
private void ViewStudents_SelectionChanged(object sender, SelectionChangedEventArgs e) { try { id = int.Parse(GetSelectedCellValue()); result = db.StudentsDetails.SingleOrDefault(x => x.ID == id); txtID.Text = result.tbStudent.ID.ToString(); txtName.Text = result.tbStudent.studentName; txtCourse.Text = result.tbCours.courseName; txtDate.Text = result.Date.ToString(); txtPrice.Text = result.tbCours.Price.ToString(); txtInstructor.Text = result.tbCours.Instructor; img.Source = (result.tbStudent.Image == null || result.tbStudent.Image == "") ? new BitmapImage(new Uri("C:\\Users\\iradi\\source\\repos\\Center Application\\Center Application\\Images\\imgStudents.png")) : new BitmapImage(new Uri(result.tbStudent.Image)); } catch { } }
//Get student detail by id public IEnumerable <StudentsDetail> GetStudentById(int id) { List <StudentsDetail> studentsDetailList = new List <StudentsDetail>(); string conStr = ConfigurationManager.ConnectionStrings["studentConn"].ToString(); using (var connection = new SqlConnection(conStr)) { using (SqlCommand command = connection.CreateCommand()) { command.CommandType = CommandType.StoredProcedure; command.CommandText = "sp_getStudentById"; command.Parameters.Add(new SqlParameter { ParameterName = "@id", Value = id }).SqlDbType = SqlDbType.Int; connection.Open(); using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { StudentsDetail studentDetail = new StudentsDetail(); studentDetail.Id = (reader["Id"] != DBNull.Value) ? Convert.ToInt32(reader["Id"]) : Null.NullInt; studentDetail.UserName = (reader["UserName"] != DBNull.Value) ? Convert.ToString(reader["UserName"]) : String.Empty; studentDetail.Password = (reader["Password"] != DBNull.Value) ? Convert.ToString(reader["Password"]) : String.Empty; studentDetail.student_first_name = (reader["student_first_name"] != DBNull.Value) ? Convert.ToString(reader["student_first_name"]) : String.Empty; studentDetail.student_middle_name = (reader["student_middle_name"] != DBNull.Value) ? Convert.ToString(reader["student_middle_name"]) : String.Empty; studentDetail.student_last_name = (reader["student_last_name"] != DBNull.Value) ? Convert.ToString(reader["student_last_name"]) : String.Empty; studentDetail.student_address1 = (reader["student_address1"] != DBNull.Value) ? Convert.ToString(reader["student_address1"]) : String.Empty; studentDetail.student_city = (reader["student_city"] != DBNull.Value) ? Convert.ToString(reader["student_city"]) : String.Empty; studentDetail.student_country = (reader["student_country"] != DBNull.Value) ? Convert.ToString(reader["student_country"]) : String.Empty; studentDetail.student_email = (reader["student_email"] != DBNull.Value) ? Convert.ToString(reader["student_email"]) : String.Empty; studentDetail.student_graduation_year = (reader["student_graduation_year"] != DBNull.Value) ? Convert.ToInt32(reader["student_graduation_year"]) : Null.NullInt; studentDetail.student_id = (reader["student_id"] != DBNull.Value) ? Convert.ToString(reader["student_id"]) : String.Empty; studentDetail.is_international_student = (reader["is_international_student"] != DBNull.Value) ? Convert.ToBoolean(reader["is_international_student"]) : false; studentDetail.date_created = (reader["date_created"] != DBNull.Value) ? Convert.ToDateTime(reader["date_created"]) : Null.NullDateTime; studentsDetailList.Add(studentDetail); } reader.Close(); } } connection.Close(); } return(studentsDetailList); }
//Add New Student public bool AddStudent(StudentsDetail studentsDetail) { int rowsAffected = 0; bool returnValue = false; string constring = ConfigurationManager.ConnectionStrings["studentConn"].ToString(); using (var connection = new SqlConnection(constring)) { using (SqlCommand command = connection.CreateCommand()) { command.CommandType = CommandType.StoredProcedure; command.CommandText = "sp_insertStudentData"; command.Parameters.Add(new SqlParameter { ParameterName = "@UserName", Value = studentsDetail.UserName }).SqlDbType = SqlDbType.VarChar; command.Parameters.Add(new SqlParameter { ParameterName = "@Password", Value = studentsDetail.Password }).SqlDbType = SqlDbType.VarChar; command.Parameters.Add(new SqlParameter { ParameterName = "@student_first_name", Value = studentsDetail.student_first_name }).SqlDbType = SqlDbType.VarChar; var param = new SqlParameter { ParameterName = "@student_middle_name", Value = studentsDetail.student_middle_name ?? string.Empty }; command.Parameters.Add(param); command.Parameters.Add(new SqlParameter { ParameterName = "@student_last_name", Value = studentsDetail.student_last_name }).SqlDbType = SqlDbType.VarChar; command.Parameters.Add(new SqlParameter { ParameterName = "@student_address1", Value = studentsDetail.student_address1 }).SqlDbType = SqlDbType.VarChar; command.Parameters.Add(new SqlParameter { ParameterName = "@student_city", Value = studentsDetail.student_city }).SqlDbType = SqlDbType.VarChar; command.Parameters.Add(new SqlParameter { ParameterName = "@student_country", Value = studentsDetail.student_country }).SqlDbType = SqlDbType.VarChar; command.Parameters.Add(new SqlParameter { ParameterName = "@student_email", Value = studentsDetail.student_email }).SqlDbType = SqlDbType.VarChar; command.Parameters.Add(new SqlParameter { ParameterName = "@student_graduation_year", Value = studentsDetail.student_graduation_year }).SqlDbType = SqlDbType.Int; //command.Parameters.Add(new SqlParameter { ParameterName = "@student_id", Value = studentsDetail.student_id }).SqlDbType = SqlDbType.VarChar; command.Parameters.Add(new SqlParameter { ParameterName = "@is_international_student", Value = studentsDetail.is_international_student }).SqlDbType = SqlDbType.Bit; command.Parameters.Add(new SqlParameter { ParameterName = "@date_created", Value = studentsDetail.date_created }); connection.Open(); rowsAffected += command.ExecuteNonQuery(); } } if (rowsAffected > 0) { returnValue = true; } return(returnValue); }
public bool AddStudent(StudentsDetail studentsDetail) { bool returnVal = studentAccountsDA.AddStudent(studentsDetail); return(returnVal); }