public static void CreateNew(studentModel student)
{
using (IDbConnection cnn = new SqlConnection("Data Source=(localdb)\\MSSQLLocalDB;Initial Catalog=rockBottomHigh_DB;Integrated Security=True;Connect Timeout=60;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"))
{
cnn.Query <studentModel>("insert into students (fname, lname, dateOfEnrollment, age, grade, GPA) values(@fname, @lname, @dateOfEnrollment, @age, @grade, @GPA)", student);
}
}
public static void Update(studentModel student)
{
using (IDbConnection cnn = new SqlConnection("Data Source=(localdb)\\MSSQLLocalDB;Initial Catalog=rockBottomHigh_DB;Integrated Security=True;Connect Timeout=60;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"))
{
cnn.Query <studentModel>("update students set fname=(@fname), lname=(@lname), dateOfEnrollment=(@dateOfEnrollment), age=(@age), grade=(@grade), GPA=(@GPA) where StudentId=(@StudentId)", student);
}
}
public List <studentModel> GetListDelete()
{
List <studentModel> list = new List <studentModel>();
var sqlConnection = SQLiteConnect.CreateInstance().SQLiteConnection;
String querry = "select * from Student_2 where status=0";
using (var result = sqlConnection.Prepare(querry))
{
while (SQLiteResult.ROW == result.Step())
{
String rollNumber = result["rollNumber"].ToString();
String name = (string)result["name"];
String status = result["status"].ToString();;
var student = new studentModel()
{
rollNumber = Convert.ToInt32(rollNumber),
name = name,
status = Convert.ToInt32(status),
};
list.Add(student);
}
}
return(list);
}
// [ResponseType(typeof(student))]
public IHttpActionResult Deletestudent(int id)
{
studentModel studentModell = this._istudentrepository.Getstudent(id);
if (studentModell == null)
{
return(NotFound());
}
this._istudentrepository.Deletestudent(id);
return(Ok());
}
public bool Save(studentModel student)
{
var sqlConnection = SQLiteConnect.CreateInstance().SQLiteConnection;
var querry = "insert into Student_2 (rollNumber, name, status) values (?,?,?)";
using (var stt = sqlConnection.Prepare(querry))
{
stt.Bind(1, student.rollNumber);
stt.Bind(2, student.name);
stt.Bind(3, student.status);
var result = stt.Step();
Debug.WriteLine("result=" + result);
return(true);
}
}
public void Putstudent(studentModel studentModell)
{
student student = new student();
student.id = studentModell.id;
student.ime = studentModell.ime;
student.br_indexa = studentModell.br_indexa;
student.datum_rodjenja = studentModell.datum_rodjenja;
student.jmbg = studentModell.jmbg;
student.prezime = studentModell.prezime;
student.srednje_ime = studentModell.srednje_ime;
student.studentcol = studentModell.studentcol;
context.Entry(student).State = EntityState.Modified;
base.SaveChanges();
}
public void Poststudent(studentModel studentModell)
{
student student = new student();
student.id = studentModell.id;
student.ime = studentModell.ime;
student.br_indexa = studentModell.br_indexa;
student.datum_rodjenja = studentModell.datum_rodjenja;
student.jmbg = studentModell.jmbg;
student.prezime = studentModell.prezime;
student.srednje_ime = studentModell.srednje_ime;
student.studentcol = studentModell.studentcol;
context.student.Add(student);
base.SaveChanges();
}
private void Button_Click(object sender, RoutedEventArgs e)
{
int student_roll = Convert.ToInt32(txt_rollNumber.Text);
String student_name = txt_name.Text;
studentModel student = new studentModel()
{
rollNumber = Convert.ToInt32(student_roll),
name = student_name,
status = 1,
};
bool result = service.Save(student);
if (result == true)
{
txt_result.Text = "SUCESS";
}
}
public IHttpActionResult Poststudent([FromBody] student student)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
studentModel studentModell = new studentModel();
studentModell.id = student.id;
studentModell.ime = student.ime;
studentModell.br_indexa = student.br_indexa;
studentModell.datum_rodjenja = student.datum_rodjenja;
studentModell.jmbg = student.jmbg;
studentModell.prezime = student.prezime;
studentModell.srednje_ime = student.srednje_ime;
studentModell.studentcol = student.studentcol;
this._istudentrepository.Poststudent(studentModell);
return(Ok());
}
// [ResponseType(typeof(student))]
public IHttpActionResult Getstudent([FromUri] int id)
{
studentModel studentModell = this._istudentrepository.Getstudent(id);
if (studentModell == null)
{
return(NotFound());
}
else
{
student student = new student();
student.id = studentModell.id;
student.ime = studentModell.ime;
student.br_indexa = studentModell.br_indexa;
student.datum_rodjenja = studentModell.datum_rodjenja;
student.jmbg = studentModell.jmbg;
student.prezime = studentModell.prezime;
student.srednje_ime = studentModell.srednje_ime;
student.studentcol = studentModell.studentcol;
return(Ok(student));
}
}
public studentModel Getstudent(int id)
{
studentModel studentModell = new studentModel();
student student = context.student.Find(id);
if (student == null)
{
return(null);
}
else
{
studentModell.br_indexa = student.br_indexa;
studentModell.datum_rodjenja = student.datum_rodjenja;
studentModell.id = student.id;
studentModell.ime = student.ime;
studentModell.prezime = student.prezime;
studentModell.jmbg = student.jmbg;
studentModell.srednje_ime = student.srednje_ime;
studentModell.studentcol = student.studentcol;
return(studentModell);
}
}
public List <studentModel> Get()
{
var profesori = context.student.ToList();
List <studentModel> ListaStudenata = new List <studentModel>();
foreach (var profa in profesori)
{
studentModel model = new studentModel();
model.id = profa.id;
model.ime = profa.ime;
model.srednje_ime = profa.srednje_ime;
model.datum_rodjenja = profa.datum_rodjenja;
model.br_indexa = profa.br_indexa;
model.jmbg = profa.jmbg;
model.prezime = profa.prezime;
model.studentcol = profa.studentcol;
ListaStudenata.Add(model);
}
return(ListaStudenata);
}
public IActionResult StudentCreate(studentModel m)
{
StudentDataAccess.CreateNew(m);
return(RedirectToAction("Index"));
}
public IActionResult UpdateStudent(studentModel m)
{
StudentDataAccess.Update(m);
return(RedirectToAction("Index"));
}
public bool Save(studentModel student)
{
return(studentdao.Save(student));
}
