public ProductSqlRepository(MySqlContext context)
{
this.Context = context;
}
public BaseRepository(MySqlContext mySqlContext)
{
_mySqlContext = mySqlContext;
}
public GenericRepository(MySqlContext context)
{
_context = context;
_dataset = _context.Set <T>();
}
public InvestingTaxController()
{
_context = new MySqlContext();
}
public ArticlesController(MySqlContext mySql)
{
_context = mySql;
}
public SeguroAutoRepository(MySqlContext _mysqlContext) : base(_mysqlContext)
{
mysqlContext = _mysqlContext;
}
public ValuesController(MySqlContext ctx)
{
_ctx = ctx;
}
IDbContext CreateMySqlContext(string connString)
{
MySqlContext dbContext = new MySqlContext(new MySqlConnectionFactory(connString));
return(dbContext);
}
/*
* Тут должна быть плеер с плейлистами
* Создание групповых чатов, с рисованием
* Отправка приглашения, копирование приглашениия
*///
public PlayerController(MySqlContext _context)
{//IHttpActionResult
//https://docs.microsoft.com/ru-ru/aspnet/web-api/overview/getting-started-with-aspnet-web-api/tutorial-your-first-web-api
context = _context;
}
public BaseRepository(MySqlContext context)
{
_baseContext = context;
dbSet = _baseContext.Set <T>();
baseQuery = _baseContext.Set <T>();
}
protected Repositorio(MySqlContext db)
{
Db = db;
DbSet = Db.Set <TEntity>();
}
public PersonServiceImplementation(MySqlContext context)
{
_context = context;
}
public Main()
{
InitializeComponent();
var db = new MySqlContext();
}
// private volatile int count;
public PersonServiceImplem(MySqlContext context)
{
_context = context;
}
public MySqlFactory(ConnectionConfigure connectionConfigure)
{
connection = connectionConfigure;
Factory = this;
context = new MySqlContext(this);
}
public PartnerContactRepository(MySqlContext context)
{
this._context = context;
}
public PersonRepositoryImpl(MySqlContext context)
: base(context)
{
}
public UsersController(MySqlContext context)
{
_context = context;
}
public BaseRepository(MySqlContext context)
{
this.context = context;
}
public BookRepository(MySqlContext context)
: base(context)
{
}
public AdminRoleStore(MySqlContext mySqlContext) : base(mySqlContext)
{
}
public AccountStore(MySqlContext context, LoggerFactory loggerfactory)
{
_context = context;
}
public static void Test()
{
//using (TransactionScope scope = new TransactionScope())
//{
// Database.SetInitializer<MySqlContext>(null);
// using (var context = new MySqlContext())
// {
// context.Database.Log = Console.WriteLine;
// try
// {
// //var users = context.Users.Local;
// Console.WriteLine(string.Format("用户的数量:{0}", context.Users.Count()));
// foreach (User u in context.Users)
// {
// Console.WriteLine(string.Format("ID:{0},NAME:{1}", u.ID, u.Name));
// }
// scope.Complete();
// }
// catch (Exception e)
// {
// Console.WriteLine(e.Message);
// }
// }
//}
using (TransactionScope scope = new TransactionScope())
{
Database.SetInitializer <MySqlContext>(null);
using (var context = new MySqlContext())
{
try
{
context.Database.Log = Console.WriteLine;
//var sGuid1 = Guid.NewGuid().ToString();
//var sGuid2 = Guid.NewGuid().ToString();
//var tGuid1 = Guid.NewGuid().ToString();
//var tGuid2 = Guid.NewGuid().ToString();
//Teacher t1 = new Teacher()
//{
// ID = tGuid1,
// Name = "张巨鹿"
//};
//context.Entry(t1).State = EntityState.Added;
//int c= context.SaveChanges();
//Console.WriteLine(string.Format("保存Teach影响的行数:{0}", c));
var baseXml = "<DATA><ITEM ID=\"1\" NAME=\"陈平安\" ISMALE=\"1\" STUDENTNUMBER=\"100\" ></ITEM></DATA>";
var c = 0;
SqlParameter p1 = new SqlParameter()
{
ParameterName = "BASIC_XML",
Value = baseXml,
SqlDbType = SqlDbType.Xml
};
var query = context.Database.SqlQuery <Result>("exec USP_STUDENT @BASIC_XML", p1);
List <Result> resultLst = query.ToList();
foreach (var r in resultLst)
{
Console.WriteLine("ROWCOUNT:{0},ERR_MSG:{1}", r.ROWCOUNT, r.ERR_MSG);
}
scope.Complete();
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
}
}
}
private static IDbContext CreateMySqlContext(string connString)
{
var dbContext = new MySqlContext(new MySqlConnectionFactory(connString));
return(dbContext);
}
public PersonRepositoryImpl(MySqlContext context)
{
_context = context;
}
public GenericRepository(MySqlContext mySqlContext)
{
_mySqlContext = mySqlContext;
dataset = _mySqlContext.Set <T>();
}
public PersonRepositoryImplementattion(MySqlContext context)
{
_context = context;
}
private UnitOfWork(MySqlContext context)
{
_context = context;
OperationDateTimeTemplate = new OperationDateTimeTemplateRepository(_context);
ProgramVersion = new ProgramVersionRepository(_context);
OperationDateTime = new OperationDateTimeRepository(_context);
//BPVHipAdditionalStructure = new BPVHipAdditionalStructureRepository(_context);
SavedComplanesObs = new SavedComplanesObsRepository(_context);
SavedRecomendationObs = new SavedRecomendationObsRepository(_context);
SavedDiagnosisObs = new SavedDiagnosisObsRepository(_context);
SavedExamination = new SavedExaminationRepository(_context);
SavedExaminationLeg = new SavedExaminationLegRepository(_context);
Veshestvo = new VeshestvoRepository(_context);
Svetovod = new SvetovodRepository(_context);
AdditionalInfoDocument = new AdditionalInfoDocumentRepository(_context);
EpicrizOperation = new EpicrizOperationRepository(_context);
StatementOperation = new StatementOperationRepository(_context);
StatementObs = new StatementObsRepository(_context);
HirurgOverview = new HirurgOverviewRepository(_context);
SugarDiabetComment = new SugarDiabetCommentRepository(_context);
Sclezing = new SclezingRepository(_context);
Anticogulants = new AnticogulantsRepository(_context);
PreparateHateComment = new PreparateHateCommentRepository(_context);
BloodExchangeComment = new BloodExchangeCommentRepository(_context);
OperationTypeOperations = new OperationTypeOperationsRepository(_context);
//OperationForAmbulatornCard = new OperationForAmbulatornCardRepository(_context);
//OperationForAmbulatornCardPatients = new OperationForAmbulatornCardPatientsRepository(_context);
AlergicAnevrizmPatients = new AlergicAnevrizmPatientsRepository(_context);
BloodExchangePatients = new BloodExchangePatientsRepository(_context);
HirurgInterupPatients = new HirurgInteruptPatientsRepository(_context);
PreparateHatePatients = new PreparateHatePatientsRepository(_context);
AlergicAnevrizm = new AlergicAnevrizmRepository(_context);
BloodExchange = new BloodExchangeRepository(_context);
HirurgInterup = new HirurgInteruptRepository(_context);
PreparateHate = new PreparateHateRepository(_context);
ChangesInDBType = new ChangesInDBTypeRepository(_context);
ComplanesObs = new ComplanesObsRepository(_context);
RecomendationObs = new RecomendationObsRepository(_context);
ChangeHistory = new ChangeHistoryRepository(_context);
GVFull = new GVEntryFullRepository(_context);
PPVFull = new PPVEntryFullRepository(_context);
TEMPVFull = new TEMPVEntryFullRepository(_context);
MPVFull = new MPVEntryFullRepository(_context);
Perforate_shinFull = new Perforate_shinEntryFullRepository(_context);
SPSHipFull = new SPSHipEntryFullRepository(_context);
BPV_TibiaFull = new BPV_TibiaEntryFullRepository(_context);
Perforate_hipFull = new Perforate_hipEntryFullRepository(_context);
ZDSVFull = new ZDSVEntryFullRepository(_context);
SFSFull = new SFSHipEntryFullRepository(_context);
PDSVFull = new PDSVHipEntryFullRepository(_context);
BPVHipsFull = new BPVHipEntryFullRepository(_context);
ExaminationLeg = new ExaminationLegRepository(_context);
doc_template = new doc_templatesRepository(_context);
GV = new GVRepository(_context);
GVCombos = new GVComboRepository(_context);
GVEntries = new GVEntryRepository(_context);
PPV = new PPVRepository(_context);
PPVCombos = new PPVComboRepository(_context);
PPVEntries = new PPVEntryRepository(_context);
Letters = new LettersRepository(_context);
TEMPVWay = new TEMPVWayRepository(_context);
MPVWay = new MPVWayRepository(_context);
TEMPV = new TEMPVRepository(_context);
TEMPVCombos = new TEMPVComboRepository(_context);
TEMPVEntries = new TEMPVEntryRepository(_context);
MPV = new MPVRepository(_context);
MPVCombos = new MPVComboRepository(_context);
MPVEntries = new MPVEntryRepository(_context);
Perforate_shin = new Perforate_shinRepository(_context);
Perforate_shinCombos = new Perforate_shinComboRepository(_context);
Perforate_shinEntries = new Perforate_shinEntryRepository(_context);
SPS = new SPSHipRepository(_context);
SPSCombos = new SPSComboRepository(_context);
SPSEntries = new SPSHipEntryRepository(_context);
BPV_Tibia = new BPV_TibiaRepository(_context);
BPV_TibiaCombos = new BPV_TibiaComboRepository(_context);
BPV_TibiaEntries = new BPV_TibiaEntryRepository(_context);
Perforate_hip = new Perforate_hipRepository(_context);
Perforate_hipCombos = new Perforate_hipComboRepository(_context);
Perforate_hipEntries = new Perforate_hipEntryRepository(_context);
ZDSV = new ZDSVRepository(_context);
ZDSVCombos = new ZDSVComboRepository(_context);
ZDSVEntries = new ZDSVEntryRepository(_context);
PDSVHips = new PDSVHipRepository(_context);
PDSVCombos = new PDSVComboRepository(_context);
PDSVHipEntries = new PDSVHipEntryRepository(_context);
PDSVHipWay = new PDSVHipWayRepository(_context);
SFSHips = new SFSHipRepository(_context);
SFSCombos = new SFSComboRepository(_context);
SFSHipEntries = new SFSHipEntryRepository(_context);
СategoryType = new СategoryTypeRepository(_context);
BPVHipWay = new BPVHipWayRepository(_context);
Cities = new CitiesRepository(_context);
Districts = new DistrictsRepository(_context);
Regions = new RegionsRepository(_context);
Streets = new StreetsRepository(_context);
BrigadeMedPersonal = new BrigadeMedPersonalRepository(_context);
ScientificTitles = new ScientificTitlesRepository(_context);
ScientificTitleType = new ScientificTitleTypeRepository(_context);
SpecializationType = new SpecializationTypeRepository(_context);
DoctorsSpecializations = new DoctorsSpecializationsRepository(_context);
MedPersonal = new MedPersonalRepository(_context);
Accaunt = new AccauntRepository(_context);
PatologyType = new PatologyTypeRepository(_context);
Patology = new PatologyRepository(_context);
// _context.Configuration.AutoDetectChangesEnabled = false;
// _context.Set<Operation>().AsNoTracking();
ReasonsOfCancleOperation = new ReasonsOfCancelOperationRepository(_context);
OperationResult = new OperationResultRepository(_context);
CancelOperation = new CancelOperationRepository(_context);
DiagnosisObs = new DiagnosisObsRepository(_context);
Examination = new ExaminationRepository(_context);
Brigade = new BrigadeRepository(_context);
Diagnosis = new DiagnosisRepository(_context);
OperationType = new OperationTypeRepository(_context);
Operation = new OperationRepository(_context);
Anestethic = new AnestethicRepository(_context);
Doctor = new DoctorRepository(_context);
Analize = new AnalizeRepository(_context);
AnalizeType = new AnalizeTypeRepository(_context);
BPVHips = new BPVHipRepository(_context);
BPVCombos = new BPVComboRepository(_context);
BPVHipEntries = new BPVHipEntryRepository(_context);
Metrics = new MetricsRepository(_context);
Patients = new PatientsRepository(_context);
ComplainsTypes = new ComplainsTypeRepository(_context);
RecomendationsTypes = new RecomendationsTypeRepository(_context);
DiagnosisTypes = new DiagnosisTypeRepository(_context);
}
//public MySqlContext context = new MySqlContext(new MySqlConnectionFactory(connString));
private MySqlContext CreateContext()
{
MySqlContext context = new MySqlContext(new MySqlConnectionFactory(connString));
return(context);
}
public CreateTestControllerTests()
{
if (false)
{
PutData putData = new PutData();
var listQuestions = new List <Question>();//.AsQueryable();
listQuestions.AddRange(putData.questions1);
listQuestions.AddRange(putData.questions2);
var dbThema = new List <Thema>(putData.themes).AsQueryable();
var dbTestThemes = new List <TestThema>(putData.TestThemas).AsQueryable();
var dbQuestions = listQuestions.AsQueryable();
var dbQuestionAnswer = new List <QuestionAnswer>(putData.questionAnswers).AsQueryable();
var dbTestStudent = new List <TestStudent>(putData.testStudents).AsQueryable();
var mockSetThema = new Mock <DbSet <Thema> >();
mockSetThema.As <IQueryable <Thema> >().Setup(a => a.Provider).Returns(dbThema.Provider);
mockSetThema.As <IQueryable <Thema> >().Setup(a => a.Expression).Returns(dbThema.Expression);
mockSetThema.As <IQueryable <Thema> >().Setup(a => a.ElementType).Returns(dbThema.ElementType);
mockSetThema.As <IQueryable <Thema> >().Setup(a => a.GetEnumerator()).Returns(dbThema.GetEnumerator());
var mockSetTestThema = new Mock <DbSet <TestThema> >();
mockSetTestThema.As <IQueryable <TestThema> >().Setup(a => a.Provider).Returns(dbTestThemes.Provider);
mockSetTestThema.As <IQueryable <TestThema> >().Setup(a => a.Expression).Returns(dbTestThemes.Expression);
mockSetTestThema.As <IQueryable <TestThema> >().Setup(a => a.ElementType).Returns(dbTestThemes.ElementType);
mockSetTestThema.As <IQueryable <TestThema> >().Setup(a => a.GetEnumerator()).Returns(dbTestThemes.GetEnumerator());
var mockSetQuestion = new Mock <DbSet <Question> >();
mockSetQuestion.As <IQueryable <Question> >().Setup(a => a.Provider).Returns(dbQuestions.Provider);
mockSetQuestion.As <IQueryable <Question> >().Setup(a => a.Expression).Returns(dbQuestions.Expression);
mockSetQuestion.As <IQueryable <Question> >().Setup(a => a.ElementType).Returns(dbQuestions.ElementType);
mockSetQuestion.As <IQueryable <Question> >().Setup(a => a.GetEnumerator()).Returns(dbQuestions.GetEnumerator());
var mockSetQuestionAnswer = new Mock <DbSet <QuestionAnswer> >();
mockSetQuestionAnswer.As <IQueryable <QuestionAnswer> >().Setup(a => a.Provider).Returns(dbQuestionAnswer.Provider);
mockSetQuestionAnswer.As <IQueryable <QuestionAnswer> >().Setup(a => a.Expression).Returns(dbQuestionAnswer.Expression);
mockSetQuestionAnswer.As <IQueryable <QuestionAnswer> >().Setup(a => a.ElementType).Returns(dbQuestionAnswer.ElementType);
mockSetQuestionAnswer.As <IQueryable <QuestionAnswer> >().Setup(a => a.GetEnumerator()).Returns(dbQuestionAnswer.GetEnumerator());
var mockSetTestStudent = new Mock <DbSet <TestStudent> >();
mockSetTestStudent.As <IQueryable <TestStudent> >().Setup(a => a.Provider).Returns(dbTestStudent.Provider);
mockSetTestStudent.As <IQueryable <TestStudent> >().Setup(a => a.Expression).Returns(dbTestStudent.Expression);
mockSetTestStudent.As <IQueryable <TestStudent> >().Setup(a => a.ElementType).Returns(dbTestStudent.ElementType);
mockSetTestStudent.As <IQueryable <TestStudent> >().Setup(a => a.GetEnumerator()).Returns(dbTestStudent.GetEnumerator());
var mqContext = new Mock <MySqlContext>();
mqContext.Setup(a => a.Questions).Returns(mockSetQuestion.Object);
mqContext.Setup(a => a.Themes).Returns(mockSetThema.Object);
mqContext.Setup(a => a.TestThemes).Returns(mockSetTestThema.Object);
mqContext.Setup(a => a.QuestionAnswers).Returns(mockSetQuestionAnswer.Object);
mqContext.Setup(a => a.TestStudents).Returns(mockSetTestStudent.Object);
mySql = mqContext.Object;
}
else
{
var optionsBuilder = new DbContextOptionsBuilder <MySqlContext>();
var options = optionsBuilder
.UseNpgsql(xUnitTest.Helpers.Constants.DATABASE)
.Options;
mySql = new MySqlContext(options);
mySql.Database.EnsureDeleted();
mySql.Database.EnsureCreated();
controller = new CreateTestController(mySql);
}
}
