public Tuple <ResultModel, IEnumerable <StudentModel> > List()
{
List <StudentModel> list = new List <StudentModel>();
try
{
using (SchoolDb db = new SchoolDb())
{
var v = (from v1 in db.Students orderby v1.StudentID ascending select v1).ToList();
if (v.Any())
{
foreach (Student it in v)
{
StudentModel model = new StudentModel();
it.MapToModelObject(model);
list.Add(model);
}
result.Result = iResultType.iSuccess;
result.Message = string.Empty;
result.Data = null;
}
else
{
result.Result = iResultType.iNoRecordFound;
result.Message = Common.NO_DATA_FOUND;
result.Data = null;
}
}
}
catch (Exception e1)
{
result = e1.GetHTMLException();
}
return(new Tuple <ResultModel, IEnumerable <StudentModel> >(result, list));
}
private static void Add(SchoolDb ctx)
{
ctx.Courses.Add(new Domain.Course
{
Name = "ASP.NET Core 3.0"
});
}
public ResultModel Add(StudentModel entity)
{
try
{
Student paObj = new Student();
using (SchoolDb db = new SchoolDb())
{
entity.MapToModelObject(paObj, new List <string> {
"StudentID", "LastModifiedBy", "LastModifiedOn"
});
paObj.CreatedOn = DateTime.Now;
db.Students.Add(paObj);
db.SaveChanges();
var v = (from v1 in db.Students where v1.StudentID == paObj.StudentID select v1);
v.MapToModelObject(entity);
entity.StudentID = paObj.StudentID;
}
result.Result = iResultType.iSuccess;
result.Message = Common.DbInsertInfo;
result.Data = entity.StudentID;
}
catch (Exception e1)
{
result = e1.GetHTMLException();
}
return(result);
}
private static void Select(SchoolDb ctx)
{
var courses = ctx.Courses.ToList();
foreach (var item in courses)
{
Console.WriteLine($"Course Id={item.CourseId} Course Name:{item.Name}");
}
}
public MainWindow()
{
using (SchoolDb db = new SchoolDb())
{
// Bei db.CreateDatabase(true) wurde die Datenbank gelöscht und neu erzeugt werden.
// Das ist sinnvoll, wenn die DB zurückgesetzt werden soll.
db.CreateDatabase();
}
InitializeComponent();
}
static void Main(string[] args)
{
using (var ctx = new SchoolDb())
{
Add(ctx);
// Update(ctx);
//Delete(ctx);
Select(ctx);
ctx.SaveChanges();
}
Console.ReadLine();
}
public ResultModel Delete(StudentModel entity)
{
try
{
using (SchoolDb db = new SchoolDb())
{
if (entity.StudentID != 0)
{
var v = (from v1 in db.Students where v1.StudentID == entity.StudentID select v1);
if (v != null)
{
db.Students.RemoveRange(v);
db.SaveChanges();
result.Result = iResultType.iSuccess;
result.Message = Common.DbDeleteInfo;
result.Data = null;
}
else
{
result.Result = iResultType.iNoRecordFound;
result.Message = Common.NO_DATA_FOUND;
result.Data = null;
}
}
else
{
result.Result = iResultType.iEmptyModel;
result.Message = "Before calling this method set Student ID";
result.Data = null;
}
}
}
catch (Exception e1)
{
result = e1.GetHTMLException();
}
return(result);
}
public ResultModel Update(StudentModel entity)
{
try
{
using (SchoolDb db = new SchoolDb())
{
if (entity.StudentID != 0)
{
var v = (from v1 in db.Students where v1.StudentID == entity.StudentID select v1).FirstOrDefault();
if (v != null)
{
entity.MapToModelObject(v, new List <string> {
"StudentID", "CreatedOn"
});
v.LastModifiedOn = DateTime.Now;
db.SaveChanges();
var CityM = (from CM in db.Students where CM.StudentID == entity.StudentID select CM);
CityM.MapToModelObject(entity);
result.Result = iResultType.iSuccess;
result.Message = Common.DbUpdateInfo;
result.Data = entity;
}
else
{
result.Result = iResultType.iNoRecordFound;
result.Message = Common.NO_DATA_FOUND;
result.Data = null;
}
}
}
}
catch (Exception e1)
{
result = e1.GetHTMLException();
}
return(result);
}
public Tuple <ResultModel, StudentModel> GetByKey(int primaryKey)
{
StudentModel model = new StudentModel();
try
{
using (SchoolDb db = new SchoolDb())
{
var v = (from v1 in db.Students where v1.StudentID == primaryKey select v1).First();
v.MapToModelObject(model);
}
result.Result = iResultType.iSuccess;
result.Message = string.Empty;
result.Data = null;
}
catch (Exception e1)
{
result = e1.GetHTMLException();
}
return(new Tuple <ResultModel, StudentModel>(result, model));
}
public static Tuple <ResultModel, IEnumerable <T> > ExecuteQuery(string sql, params object[] parameters)
{
Tuple <ResultModel, IEnumerable <T> > r;
using (SchoolDb db = new SchoolDb())
{
DbRawSqlQuery <T> data;
if (parameters != null)
{
data = db.Database.SqlQuery <T>(sql, parameters);
}
else
{
data = db.Database.SqlQuery <T>(sql);
}
ResultModel result = new ResultModel();
result.Result = iResultType.iSuccess;
result.Message = "Executed successfully";
r = new Tuple <ResultModel, IEnumerable <T> >(result, data.ToList <T>());
}
return(r);
}
public Tuple <ResultModel, IEnumerable <StudentModel> > GetByForeignKey(StudentModel entity)
{
ResultModel result = new ResultModel();
List <StudentModel> list = new List <StudentModel>();
try
{
if (entity.StudentID != 0)
{
using (SchoolDb db = new SchoolDb())
{
var v = (from v1 in db.Students orderby v1.StudentID ascending select v1).ToList();
foreach (Student it in v)
{
StudentModel model = new StudentModel();
it.MapToModelObject(model);
list.Add(model);
}
}
result.Result = iResultType.iSuccess;
result.Message = string.Empty;
result.Data = null;
}
else
{
result.Result = iResultType.iError;
result.Message = "Set Student ID before calling this method.";
result.Data = null;
}
}
catch (Exception e1)
{
result = e1.GetHTMLException();
}
return(new Tuple <ResultModel, IEnumerable <StudentModel> >(result, list));
//throw new NotImplementedException();
}
public UnitOfWork(SchoolDb myDbContext)
{
_context = myDbContext;
}
public GenericRepository(SchoolDb schoolDb)
{
_schoolDb = schoolDb;
}
private static void Update(SchoolDb ctx)
{
var course = ctx.Courses.Find(1);
course.Name = "ASP.NET Core";
}
private static void Delete(SchoolDb ctx)
{
var course = ctx.Courses.Find(1);
ctx.Courses.Remove(course);
}
