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);
}
