private void ChooseStudent_Activated(object sender, EventArgs e)
{
using (StudyContext db = new StudyContext())
{
List <Student> students = db.Students.ToList();
comboBox1.DataSource = students;
comboBox1.ValueMember = "Id";
comboBox1.DisplayMember = "Surname";
}
}
private void TeachSalary_Activated(object sender, EventArgs e)
{
using (StudyContext db = new StudyContext())
{
int minSalary = db.Teachers.Min(t => t.Salary);
int maxSalary = db.Teachers.Max(t => t.Salary);
int sumSalary = db.Teachers.Sum(t => t.Salary);
double avgSalary = db.Teachers.Average(t => t.Salary);
richTextBox1.Text += "Минимальная зарплата: " + minSalary + Environment.NewLine + "Максимальная зарплата: " +
maxSalary + Environment.NewLine + "Средняя зарплата: " + avgSalary + Environment.NewLine + "Общая зарплата: " + sumSalary;
}
}
private void button1_Click(object sender, EventArgs e)
{
richTextBox1.Text = "";
if (comboBox1.Text == "")
{
richTextBox1.Text = "Не получено данных";
}
else
{
using (StudyContext db = new StudyContext())
{
var marks = db.Marks.Where(m => m.Student.Surname == comboBox1.Text);
foreach (Mark m in marks)
{
richTextBox1.Text += m.Subject.ToString() + " " + m.Smark + Environment.NewLine;
}
}
if (richTextBox1.Text == "")
{
richTextBox1.Text = "У этого студента пока нету оценок";
}
}
}
public ApiResult <T> Run()
{
var result = new ApiResult <T> {
ResultStatus = ResultStatus.Successful
};
try
{
using (var scope = new TransactionScope(TransactionScopeOption.Required))
{
var context = new StudyContext();
Do(context, result);
scope.Complete();
}
}
catch (Exception)
{
result.Messages.Clear();
result.ResultStatus = ResultStatus.Thrown;
}
return(result);
}
public StudentDecorator(StudyContext database)
{
Database = database;
}
public CustomerRepository(StudyContext studyContext) : base(studyContext)
{
}
public Repository(StudyContext context) => _context = context;
public ChatsController(StudyContext context)
{
_context = context;
}
public GroupDecorator(StudyContext database)
{
Database = database;
}
public GradeController(StudyContext context)
{
this.context = context;
}
public ReportManager(StudyContext context, IMapper mapper)
{
_context = context;
_mapper = mapper;
}
public Repository(StudyContext context)
{
_context = context;
_dbSet = _context.Set <TEntity>();
}
public StudentRepository(StudyContext dbContext) : base(dbContext)
{
}
public DatabaseController(StudyContext context)
{
this.context = context;
}
public ContatoRepository(StudyContext contexto)
{
_contexto = contexto;
}
public StudyYearController(StudyContext context)
{
this.context = context;
}
public UnitOfWork(StudyContext context)
{
_context = context;
_transaction = context.Database.BeginTransaction();
}
public AssignmentController(StudyContext context)
{
this.context = context;
}
public TeachFrm()
{
InitializeComponent();
db = new StudyContext();
}
public OrderRepository(StudyContext context)
: base(context)
{
}
public StudentRepository(StudyContext context) : base(context)
{
}
public SubjFrm()
{
InitializeComponent();
db = new StudyContext();
}
public Repository(StudyContext dbContext)
{
_dbContext = dbContext;
}
// A constructor is necessary in order to get the context ready
public StudentController(StudyContext context)
{
this.context = context;
}
public Repository(StudyContext studyContext)
{
_db = studyContext;
DbSet = _db.Set <Tentity>();
}
public Repository(StudyContext context)
{
Db = context;
DbSet = Db.Set <TEntity>();
}
public UnitOfWork(StudyContext studyContext)
{
_studyContext = studyContext;
}
//构造函数注入
public UnitOfWork(StudyContext context)
{
_context = context;
}
public Repository(StudyContext dbContext)
{
this._dbContext = dbContext;
_dbSet = _dbContext.Set <TEntity>();
}