public ActionResult SecondHighestPocketMoneyStudent()
{
SqlServerDB sqlServerDB = new SqlServerDB();
var student = sqlServerDB.SecondHighestPocketMoneyStudent();
return(View(student));
}
private void addInParameters(List <DbParameter> parameters, DbCommand queryCmd)
{
foreach (DbParameter parameter in parameters)
{
SqlServerDB.AddInParameter(queryCmd, parameter.ParameterName, parameter.DbType, parameter.Value);
}
}
public ActionResult SaveStudent(Student clsStudentData)
{
SqlServerDB sqlServerDB = new SqlServerDB();
var students = sqlServerDB.SaveStudentData(clsStudentData);
return(View());
}
// GET: Student
public ActionResult Index()
{
SqlServerDB sqlServerDB = new SqlServerDB();
var students = sqlServerDB.StudentList();
return(View(students));
}
/// <summary>
/// StoredProcedure işlemleri için kullanılır.
/// </summary>
/// <param name="spName"></param>
/// <param name="parameters"></param>
protected object ExecuteByStoredProcedure(string spName, List <DbParameter> parameters)
{
using (DbCommand queryCmd = SqlServerDB.GetStoredProcCommand(spName))
{
addInParameters(parameters, queryCmd);
return(SqlServerDB.ExecuteDataSet(queryCmd));
}
}
/// <summary>
/// INSERT, UPDATE ve DELETE işlemleri için kullanılır.
/// </summary>
/// <param name="query"></param>
/// <param name="parameters"></param>
protected object ExecuteQuery(string query, List <DbParameter> parameters)
{
using (DbCommand queryCmd = SqlServerDB.GetSqlStringCommand(query))
{
addInParameters(parameters, queryCmd);
return(SqlServerDB.ExecuteScalar(queryCmd));
}
}
protected List <T> GetListByQuery <T>(string query) where T : new()
{
using (DbCommand queryCmd = SqlServerDB.GetSqlStringCommand(query))
{
DataSet ds = SqlServerDB.ExecuteDataSet(queryCmd);
var rows = ds.Tables[0].DataTableToObjectList <T>();
return(rows);
}
}
protected List <T> GetListByStoredProc <T>(string storedProcName) where T : new()
{
using (DbCommand sprocCmd = SqlServerDB.GetStoredProcCommand(storedProcName))
{
DataSet ds = SqlServerDB.ExecuteDataSet(sprocCmd);
var rows = ds.Tables[0].DataTableToObjectList <T>();
return(rows);
}
}
static void Main(string[] args)
{
var builder = new ConfigurationBuilder()
.SetBasePath(Directory.GetCurrentDirectory())
.AddJsonFile("appsettings.json", optional: true, reloadOnChange: true);
try
{
Configuration = builder.Build();
}
catch (Exception exception)
{
Console.WriteLine("Error obtaining configuration data. Please check your appsettings.json file.");
Console.Write(exception);
}
var database = Configuration["Database"].ToLowerInvariant();
Console.WriteLine("Configured. Starting application…");
Console.WriteLine("Ready to create database. Press any key to begin.");
Console.ReadLine();
switch (database)
{
case "sqlite":
SqliteDB.CreateDB(Configuration);
break;
case "sqlserver":
SqlServerDB.CreateDB(Configuration);
break;
default:
Console.WriteLine("Invalid database type specified.");
break;
}
}
