public static void CreateNew(classModel klass) { 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 <classModel>("insert into Class(TeacherId, topic, grade) values(@TeacherId, @topic, @grade)", klass); } }
public static void CreateNew(classModel grade) { 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 <classModel>("insert into ninthGrade(StudentId, ClassId, dateOfEntry, finalGrade, comments) values(@StudentId, @ClassId, @dateOfEntry, @finalGrade, @comments", grade); } }
public IActionResult ClassCreate(classModel m) { ClassDataAccess.CreateNew(m); return(RedirectToAction("Index")); }