public async Task <IActionResult> Edit(int id, [Bind("Id,Name,ClassId,DateOfBirth")] StudentsModel studentsModel) { if (id != studentsModel.Id) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(studentsModel); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!StudentsModelExists(studentsModel.Id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["ClassId"] = new SelectList(_context.Classes, "Id", "Id", studentsModel.ClassId); return(View(studentsModel)); }
public async Task <IActionResult> PutStudent(int id, [FromBody] StudentsModel studentsModel) { if (ModelState.IsValid) { Student student = dataBaseContext.Students.Where(e => e.Id == id).FirstOrDefault(); if (student == null) { return(BadRequest("группа не существует")); } else { student.Name = studentsModel.Name; student.Address = studentsModel.Address; student.Group = dataBaseContext.Group.Where(e => e.Name == studentsModel.GroupName).FirstOrDefault(); student.LastName = studentsModel.LastName; student.MidleName = studentsModel.MidleName; student.NumberOfBook = studentsModel.NumberOfBook; dataBaseContext.Students.Update(student); await dataBaseContext.SaveChangesAsync(); return(StatusCode(StatusCodes.Status201Created)); } } return(BadRequest(ModelState)); }
public ActionResult <StudentsModel> Get() { Students result = studentBL.GetStudents(); StudentsModel students = StudentsModel.ToStudentsModel(result); return(students); }
public IActionResult UpdateStudent([FromBody] StudentsModel student) { try { TestModel g = new TestModel(); g.Test1(); using (SqlConnection connection = new SqlConnection("Data Source=dev;Initial Catalog=Test;Persist Security Info=True;User ID=sa;Password=admin@123")) { using (SqlCommand cmd = new SqlCommand("SP_UpdateStudent", connection)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@name", student.NAME); cmd.Parameters.AddWithValue("@age", student.AGE); cmd.Parameters.AddWithValue("@id", student.ID); connection.Open(); cmd.ExecuteNonQuery(); connection.Close(); } } return(Ok("updated successfully")); } catch (Exception) { throw; } }
[HttpGet("GetStudents")]//methoad name or action public IActionResult GetStudents() { List <StudentsModel> students = new List <StudentsModel>(); //list try { using (SqlConnection connection = new SqlConnection("Data Source=dev;Initial Catalog=Test;Persist Security Info=True;User ID=sa;Password=admin@123")) { connection.Open(); SqlCommand command = new SqlCommand("SP_GetStudents", connection); using (SqlDataReader dataReader = command.ExecuteReader()) { while (dataReader.Read()) { StudentsModel student = new StudentsModel(); // model name(same table coloumn) student.ID = new Guid(dataReader["ID"].ToString()); student.NAME = Convert.ToString(dataReader["NAME"]); student.AGE = Convert.ToInt32(dataReader["AGE"]); student.DATE = Convert.ToDateTime(dataReader["DATE"]); students.Add(student); //add each row to list } } } } catch (Exception ex) { throw; } return(Ok(students)); //return the list }
public ActionResult Edit(int id) { StudentsModel studentsModel = new StudentsModel(new StudentsService(new StudentsRepository(new StudentsContext()))); var studentViewModel = studentsModel.GetStudentById(id); return(View("EditStudent", studentViewModel)); }
public IActionResult Index() { StudentsModel sm = new StudentsModel("wwwlab.iki.his.se-dbsk"); ViewBag.AllStudentsTable = sm.GetAllStudents(); return(View()); }
public ActionResult MonthlyFee(int StudentID) { List <FeeRecord> lst = new StudentsModel().GetFeeRecordByStudentID(StudentID); ViewBag.Student = new StudentsModel().GetByID(StudentID); return(View(lst)); }
public async Task <IActionResult> AddStudents(StudentsModel studentsModel) { if (ModelState.IsValid) { Student student = _context.Students.Where(e => e.NumberOfBook == studentsModel.NumberOfBook).FirstOrDefault(); if (student == null) { _context.Students.Add(new Student { Name = studentsModel.Name, Address = studentsModel.Address, Group = _context.Group.Where(e => e.Name == studentsModel.GroupName).FirstOrDefault(), LastName = studentsModel.LastName, MidleName = studentsModel.MidleName, NumberOfBook = studentsModel.NumberOfBook }); await _context.SaveChangesAsync(); return(RedirectToAction("Students", "Admin")); } else { } } return(View(studentsModel)); }
public StudentsModel CreateStudent() { StudentsModel st = new StudentsModel(); Console.WriteLine("RollNumber: "); st.RollNumber = Console.ReadLine(); Console.WriteLine("Full Name: "); st.FullName = Console.ReadLine(); Console.WriteLine("BirthDay(dd/mm/yyyy): "); //string bd = Console.ReadLine(); var bd = Console.ReadLine(); st.BirthDay = DateTime.Parse(bd); Console.WriteLine("Email: "); st.Email = Console.ReadLine(); Console.WriteLine("Phone: "); st.Phone = Console.ReadLine(); //var CreatedAt = DateTime.Now; Console.WriteLine("CreatedAt(dd/mm/yyyy): "); st.CreatedAt = DateTime.Parse(Console.ReadLine()); //Console.WriteLine("Status: "); //st.Status = return(st); }
public async Task <ActionResult <StudentsModel> > Put(string studno, StudentsModel model) { //try //{ var oldStud = await _repo.GetStudentsRec(studno); if (oldStud == null) { return(NotFound($"Could not find Student with Student No. of {studno}")); } _mapper.Map(model, oldStud); if (await _repo.SaveChangesAsync()) { return(_mapper.Map <StudentsModel>(oldStud)); } //} //catch (Exception) //{ // return this.StatusCode(StatusCodes.Status500InternalServerError, "Database Failure -PUT"); //} return(BadRequest()); }
public async Task <IActionResult> AddStudent([FromBody] StudentsModel studentsModel) { if (ModelState.IsValid) { Student student = dataBaseContext.Students.Where(e => e.NumberOfBook == studentsModel.NumberOfBook).FirstOrDefault(); if (student == null) { dataBaseContext.Students.Add(new Student { Name = studentsModel.Name, Address = studentsModel.Address, Group = dataBaseContext.Group.Where(e => e.Name == studentsModel.GroupName).FirstOrDefault(), LastName = studentsModel.LastName, MidleName = studentsModel.MidleName, NumberOfBook = studentsModel.NumberOfBook }); await dataBaseContext.SaveChangesAsync(); return(StatusCode(StatusCodes.Status201Created)); } else { return(BadRequest(ModelState)); } } return(BadRequest(ModelState)); }
private async void radButton2_Click_1(object sender, EventArgs e) { this.Enabled = false; RadControl[] cont = { radTextBox1, radTextBox3, radTextBox4, radTextBox5, radTextBox6 }; if (radTextBox1.Text == string.Empty || radTextBox3.Text == string.Empty || radTextBox4.Text == string.Empty || radTextBox5.Text == string.Empty || radTextBox6.Text == string.Empty) { foreach (RadTextBox item in cont) { if (item.Text == string.Empty) { item.BackColor = Color.Pink; } } this.Enabled = true; } else { var studentRequested = new StudentsModel { MatricNo = radTextBox1.Text, Name = radTextBox3.Text, BloodGroup = radTextBox4.Text, School = radTextBox3.Text, Programme = radTextBox6.Text, ProfilePicture = Google.Protobuf.ByteString.FromBase64(ConvertImageToBase64(pictureBox1.Image, ImageFormat.Png)) }; var response = await client.AddStudentAsync(studentRequested); if (response.Prompt == "Success") { foreach (RadTextBox item in cont) { item.Text = string.Empty; } pictureBox1.Image = Properties.Resources.utilities_user_info; } this.Enabled = true; RadMessageBox.Show(response.Prompt); } }
public ActionResult ChangeCat() { try { if (!Authen.Certification(Session["UserClass"].ToString(), Authen.UserClass.Student)) { return(RedirectToAction("PermitionEr", "Error")); } string text1 = System.IO.File.ReadAllText(Server.MapPath("~/ClassData.json")); JObject text = JObject.Parse(text1); Grade b = new Grade( (int)text["Class1"], (int)text["Class2"], (int)text["Class3"] ); StudentsModel model = new StudentsModel() { category = db2.Category.ToList(), userCategory = from a in db.Categories.ToList() where a.CatUName == int.Parse(Session["UserNo"].ToString()) select a, grade = b }; return(View(model)); } catch { return(RedirectToAction("LoginEr", "Error")); } }
public ActionResult <StudentsModel> GetByName(string name) { Students result = studentBL.GetStudentsByName(name); StudentsModel student = StudentsModel.ToStudentsModel(result); return(student); }
public ActionResult GetStudents() { var model = new StudentsModel(); var studentsEndpoint = "/ims/oneroster/v1p1/students"; var response = string.Empty; if (!string.IsNullOrEmpty(ConfigurationManager.AppSettings["api-uri"])) { var accessToken = string.Empty; if (User is ClaimsPrincipal claimsPrincipal) { accessToken = claimsPrincipal.Claims.FirstOrDefault(c => c.Type == "access_token")?.Value; } var baseAddress = new Uri(ConfigurationManager.AppSettings["api-uri"]); var client = new HttpClient { BaseAddress = baseAddress }; client.SetBearerToken(accessToken); model.Students = client.GetStringAsync(studentsEndpoint).Result; } return(View(model)); }
public string StudentDetail(StudentsModel Model) { string returnMessage = null; if (string.IsNullOrEmpty(Model.StudentName)) { returnMessage = "Student Name is required"; } else { if (string.IsNullOrEmpty(Model.Gender)) { returnMessage = "gender is required"; } else { if (Model.Gender == "-1") { returnMessage = "gender is required"; } else { returnMessage = "Student Added Successfully"; } } } return(returnMessage); ; }
public ActionResult StudentList() { StudentsModel theModel = GetStudentModelFromSession(); ViewData["Students"] = theModel.GetStudents(); return(View()); }
public async Task <IActionResult> Edit(int id, [Bind("Id,Name,Family,NationalId,BirthDate,EnteredBy")] StudentsModel studentsModel) { if (id != studentsModel.Id) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(studentsModel); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!StudentsModelExists(studentsModel.Id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(studentsModel)); }
public DataTable GetStudentByName(StudentsModel model) { string sql = "select * from Students where Student_Name=@0"; DataTable dt = SqlHelper.GetDataTable(sql, model.Student_Name); return(dt); }
private StudentsModel encrypt(StudentsModel student) { var text = "Hello World"; var buffer = Encoding.UTF8.GetBytes(text); var iv = "1233321"; var keyAes = GetRandomData(256); byte[] result; using (var aes = Aes.Create()) { aes.Key = keyAes; aes.IV = iv; using (var encryptor = aes.CreateEncryptor(aes.Key, aes.IV)) using (var resultStream = new MemoryStream()) { using (var aesStream = new CryptoStream(resultStream, encryptor, CryptoStreamMode.Write)) using (var plainStream = new MemoryStream(buffer)) { plainStream.CopyTo(aesStream); } result = resultStream.ToArray(); } } return(student); }
public ActionResult Add(StudentViewModel studentModel) { StudentsModel studentsModel = new StudentsModel(new StudentsService(new StudentsRepository(new StudentsContext()))); var createdStudent = studentsModel.AddStudent(studentModel); return(View("StudentDetails", createdStudent)); }
// GET: Students public ActionResult Index(int page = 1) { StudentsModel studentsModel = new StudentsModel(new StudentsService(new StudentsRepository(new StudentsContext())), page); studentsModel.HandleRequest(); return(View("Students", studentsModel)); }
public ActionResult Add() { StudentsModel studentsModel = new StudentsModel(new StudentsService(new StudentsRepository(new StudentsContext()))); var newStudent = studentsModel.CreateNewStudent(); return(View("AddStudent", newStudent)); }
public StudentsModel Update(StudentsModel employeeChanges) { var employee = _context.Students.Attach(employeeChanges); employee.State = Microsoft.EntityFrameworkCore.EntityState.Modified; _context.SaveChanges(); return(employeeChanges); }
public ActionResult Edit(StudentViewModel studentModel) { StudentsModel studentsModel = new StudentsModel(new StudentsService(new StudentsRepository(new StudentsContext()))); var updatedStudent = studentsModel.UpdateStudent(studentModel); return(View("StudentDetails", updatedStudent)); }
public void delete(StudentsModel student) { var id = ObjectId.Parse(student._id); BsonDocument document = new BsonDocument(); document["_id"] = id; _collection.FindOneAndDeleteAsync(document); }
public ActionResult DeleteConfirmed(Guid id) { StudentsModel studentsModel = db.StudentsModels.Find(id); db.StudentsModels.Remove(studentsModel); db.SaveChanges(); return(RedirectToAction("Index")); }
public PortManager() { using (StudentsModel db = new StudentsModel()) { } OpenPorts = new List <int>(); ListAvailableTCPPort(ref OpenPorts); }
/// <summary> /// 检查学生编号 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool CheckStudent(StudentsModel model) { string sql = "select * from Students where StudentNum=@0"; SqlDataReader dr = SqlHelper.ExReader(sql, model.StudentNum); bool b = dr.Read(); dr.Close(); return(b); }