public async Task SetupAsync() { _evnt = new EventViewModel { Title = "Title event", Description = "Test event", Start = "11:00", End = "14:27", Date = "2016-02-01" }; var userViewModel = new LoginViewModel { Email = "*****@*****.**", Password = "******", RememberMe = false }; var context = new DataContext(); var manager = new UserManager(new UserStore(context)); var user = await manager.FindAsync(userViewModel.Email, userViewModel.Password); if (user == null) { await manager.CreateAsync(new User { Email = userViewModel.Email, UserName = userViewModel.Email }, userViewModel.Password); } _calendarController = new CalendarController(context); var mockCp = new Mock<IClaimsPrincipal>(); if (user != null) mockCp.SetupGet(cp => cp.UserId).Returns(user.Id); _calendarController.CurrentUser = mockCp.Object; var mockAuthenticationManager = new Mock<IAuthenticationManager>(); mockAuthenticationManager.Setup(am => am.SignOut()); mockAuthenticationManager.Setup(am => am.SignIn()); _calendarController.AuthenticationManager = mockAuthenticationManager.Object; }
//cambBuscar //*creavuelo public Vuelo buscarporId(int idVuelo) { Vuelo vuelo = new Vuelo(); MyConnection myConnection = new MyConnection(); DataContext datacontext = new DataContext(myConnection.SQLConnection); var Table = datacontext.GetTable<Vuelo>(); try { var buscarPorIdVuelo = from vueloId in Table where vueloId.IdVuelo == idVuelo select vueloId; foreach (Vuelo v in buscarPorIdVuelo) { vuelo = v; } } catch (Exception ex) { Console.WriteLine(ex.Message); } return vuelo; }
public int LinkInsert(DataContext Context) { var Links = Context.GetTable<CRdsAttributeLink>(); Links.InsertOnSubmit(this); return -1; }
/// <summary> /// Metoda zapisująca informacje o użytkowniku /// </summary> /// <param name="email"></param> /// <param name="result"></param> /// <returns></returns> public bool SaveUser(string email, Users result) { try { using (var context = new DataContext()) { var user = context.Table<Users>().NewQuery().FirstOrDefault(x => x.Email == email); if (user != null) { user.Name = result.Name; user.Surname = result.Surname; if (!string.IsNullOrEmpty(result.Password)) { user.Password = result.Password; } context.Table<Users>().Update(user); context.SaveChanges(); return true; } } } catch (Exception ex) { // ojojojoj } return false; }
public void Test2() { var dc = new DataContext(); dc.AddTable("data", new[] { new Item { Col1="A", Col2 = 2 } }); var flow = new Flow { Orientation = FlowOrientation.Vertical }; var table = flow.AddTable<Item>("data"); table.Columns.Single(a => a.DataField == "Col2").ConditionalFormatting = (value) => { if (!(value is int)) return null; var v = (int)value; if (v > 0) return new Styling.CellStyle { FontStyle = new Styling.FontStyle { FontColor = Styling.Color.FromHtml("#00FF00") } }; return null; }; var rep = Report.CreateReport(flow, dc); var cells = ReportUtil.GetCellMatrix(rep); Assert.IsNull(cells[0][0].CustomStyle); Assert.IsNotNull(cells[0][1].CustomStyle); var html = HtmlReportWriter.RenderReport(rep, new DefaultHtmlReportTheme()); Assert.IsTrue(html.Contains("style=\"color:")); Assert.IsTrue(html.Contains("#00FF00")); }
public void DataObjectQuery_Should_Select_All_Items_From_Database_With_Parameter_Binding_And_Context_Transaction() { commandMock.Setup(c => c.CommandText).Returns("SELECT [Id], [Name], [FirstFlight] FROM Airplane WHERE Name = @Name"); using (var context = new DataContext()) { // Execute a command to open transaction. context.Execute("DELETE FROM Airplane"); // Simulate connection open state later the first execute. connectionMock.Setup(c => c.State).Returns(ConnectionState.Open); select.With(context).All("WHERE Name = @Name", new { Name = "Omega" }); context.Commit(); } connectionMock.Verify(c => c.CreateCommand(), Times.Exactly(2)); connectionMock.Verify(c => c.Open(), Times.Once()); connectionMock.Verify(c => c.BeginTransaction(), Times.Once()); connectionMock.Verify(c => c.Close(), Times.Once()); commandMock.Verify(c => c.ExecuteReader(), Times.Once()); commandMock.VerifySet(c => c.CommandText = "SELECT [Id], [Name], [FirstFlight] FROM Airplane WHERE Name = @Name"); commandMock.VerifySet(c => c.Connection = connectionMock.Object); commandMock.VerifySet(c => c.Transaction = transactionMock.Object); commandMock.Verify(c => c.CreateParameter(), Times.Once()); parameterMock.VerifySet(p => p.ParameterName = "@Name"); parameterMock.VerifySet(p => p.Value = "Omega"); parameterCollectionMock.Verify(p => p.Add(parameterMock.Object), Times.Once()); transactionMock.Verify(t => t.Commit(), Times.Once()); }
public void InitDatabase() { using (Db = new DataContext()) { Db.InitilizeDatabase(); } }
/// <summary> /// Metoda pobierająca id użytkownika na podstawie jego maila /// </summary> /// <param name="email"></param> /// <returns></returns> public int GetUserId(string email) { using (var context = new DataContext()) { return context.Table<Users>().NewQuery().Where(x => x.Email == email).Select(x => x.ID).FirstOrDefault(); } }
private void DropDatabase() { using (var data = new DataContext("Master", Transaction.No)) { data.Execute("DROP DATABASE ThunderTest"); } }
public override bool DeleteRole(string roleName, bool throwOnPopulatedRole) { if (string.IsNullOrEmpty(roleName)) { return false; } using (DataContext Context = new DataContext()) { Role Role = null; Role = Context.Roles.FirstOrDefault(Rl => Rl.RoleName == roleName); if (Role == null) { return false; } if (throwOnPopulatedRole) { if (Role.Users.Any()) { return false; } } else { Role.Users.Clear(); } Context.Roles.Remove(Role); Context.SaveChanges(); return true; } }
private void CreateDatabase() { using (var data = new DataContext("Master", Transaction.No)) { data.Execute("CREATE DATABASE ThunderTest"); } }
private void CreateTables() { var createManufacturerTable = new StringBuilder("CREATE TABLE Le_Manufacturer (") .Append("[TheId] NUMERIC(8) NOT NULL IDENTITY PRIMARY KEY,") .Append("[Name] VARCHAR(32) NOT NULL,") .Append("[BuildYear] NUMERIC(4) NOT NULL)") .ToString(); var createCarTable = new StringBuilder("CREATE TABLE Car (") .Append("[Id] NUMERIC(8) NOT NULL IDENTITY PRIMARY KEY,") .Append("[Name] VARCHAR(32) NOT NULL,") .Append("[ModelYear] NUMERIC(4) NOT NULL,") .Append("[Date] DATETIME NOT NULL,") .Append("[Chassis] VARCHAR(32) NOT NULL,") .Append("[Mileage] FLOAT,") .Append("[ManufacturerId] NUMERIC(8) REFERENCES Le_Manufacturer(TheId))") .ToString(); using (var data = new DataContext()) { data.Execute(createManufacturerTable); data.Execute(createCarTable); data.Commit(); } }
public ManageEventCategoriesViewModel() { using (DataContext context = new DataContext()) { EventCategories = context.EventCategories.ToList(); } }
public static void CloseConnection() { _context.Connection.Close(); _context.Dispose(); _table = null; _context = null; }
public JsonResult AddCategory(string name) { var result = new JsonResult(); if (!String.IsNullOrEmpty(name)) { using (var context = new DataContext()) { var newCategory = new BlogCategory { CategoryName = name, CreateDate = DateTime.Now, IsActive = true }; context.BlogCategories.Add(newCategory); context.SaveChanges(); result.Data = new {id = newCategory.CategoryId}; return result; } } return result; }
public BlogsByUserViewModel(string username) { // Get back to the original name before url conversion BlogUsername = username.Replace(ContentGlobals.BLOGDELIMMETER, " "); using (var context = new DataContext()) { // Get User based on authorid TheBlogUser = context.BlogUsers.FirstOrDefault(x => x.Username == BlogUsername); MaxBlogCount = BlogListModel.GetBlogSettings().MaxBlogsOnHomepageBeforeLoad; BlogTitle = BlogListModel.GetBlogSettings().BlogTitle; BlogsByUser = context.Blogs.Where(x => x.Author == BlogUsername && x.IsActive) .OrderByDescending(blog => blog.Date) .Take(MaxBlogCount) .ToList(); // Try permalink first TheBlog = BlogsByUser.FirstOrDefault(x => x.Author == BlogUsername); if (BlogsByUser.Count > 0) { LastBlogId = BlogsByUser.LastOrDefault().BlogId; } } }
/// <summary> /// Constructor initializes DataContext /// plus adds additional configuration /// </summary> public RepositoryBase() { dc = new DataContext(); dc.Configuration.LazyLoadingEnabled = false; dc.Configuration.ProxyCreationEnabled = false; }
static void Main(string[] args) { DataContext dc = new DataContext(@"Data Source=.\SQLEXPRESS;Initial Catalog=AdventureWorks;Integrated Security=True"); dc.Log = Console.Out; //Table<Pessoa> pessoas = dc.GetTable<Pessoa>(); var pessoas = from p in dc.GetTable<Pessoa>() select p; //ObjectDumper.Write(pessoas); //Console.WriteLine(); var nomes = from p in pessoas select p.Nome; nomes = from p in nomes where p.Equals("ABEL") select p; ObjectDumper.Write(nomes); Console.ReadKey(); }
public AuthorizationRepository() { _dataContext = new DataContext(); var userStore = new UserStore<PropertyManagerUser>(_dataContext); _userManager = new UserManager<PropertyManagerUser>(userStore); }
public async Task<ActionResult> Login(LoginViewModel model, string returnUrl) { if (!ModelState.IsValid) { using (var db = new DataContext()) { ViewBag.LoginsList = db.Users.ToArray(); } return View(model); } // This doesn't count login failures towards account lockout // To enable password failures to trigger account lockout, change to shouldLockout: true var result = await SignInManager.PasswordSignInAsync(model.UserName, model.Password, model.RememberMe, shouldLockout: false); switch (result) { case SignInStatus.Success: return RedirectToLocal(returnUrl); case SignInStatus.LockedOut: return View("Lockout"); case SignInStatus.RequiresVerification: return RedirectToAction("SendCode", new { ReturnUrl = returnUrl, RememberMe = model.RememberMe }); case SignInStatus.Failure: default: ModelState.AddModelError("", "Invalid login attempt."); return View(model); } }
public EventCategorySingleViewModel(string category, HttpServerUtilityBase server) { _server = server; category = formatCategoryString(category); //ImageList = getImageList(); using (var context = new DataContext()) { var tomorrow = DateTime.Now.Date; TheCategory = context.EventCategories.FirstOrDefault(x => x.CategoryName == category); EventRoll = context.Events.Where(x => x.MainCategory == category && x.IsActive == true && DateTime.Compare(x.EndDate.Value, tomorrow) >= 0).ToList(); // Set a random picture on the eventRoll if none is currently set //foreach (var event in EventRoll) //{ // if (String.IsNullOrEmpty(event.ImageUrl)) // { // event.ImageUrl = getRandomImage(); // } //} } }
public void TestContext(string context) { var ctx = new DataContext(context); ctx.GetTable<Person>().ToList(); ctx.KeepConnectionAlive = true; ctx.GetTable<Person>().ToList(); ctx.GetTable<Person>().ToList(); ctx.KeepConnectionAlive = false; using (var tran = new DataContextTransaction(ctx)) { ctx.GetTable<Person>().ToList(); tran.BeginTransaction(); ctx.GetTable<Person>().ToList(); ctx.GetTable<Person>().ToList(); tran.CommitTransaction(); } }
public CMetaobjectExtented(Guid ID, DataContext Context) : base(ID, Context) { this._likesNumberAttribute.Attributes = this._attributes; this.LikesNumber = 0; }
/// <summary> /// Creates a new site tree model for the given namespace. /// </summary> /// <param name="id">Namespace id</param> public SiteTreeEditModel(Guid namespaceId) { // Get the namespaces using (var db = new DataContext()) { var ns = db.Namespaces.OrderBy(n => n.Name).ToList() ; if (namespaceId != Guid.Empty) Namespaces = new SelectList(ns, "Id", "Name", namespaceId) ; Namespaces = new SelectList(ns, "Id", "Name") ; } // Get the available region types RegionTypes = new List<dynamic>() ; ExtensionManager.Extensions.Where(e => e.ExtensionType == ExtensionType.Region).OrderBy(e => e.Name).Each((i, r) => RegionTypes.Add(new { Name = r.Name, Type = r.Type.ToString() })) ; RegionTypes.Insert(0, new { Name = "", Type = "" }) ; // Initialize the new site Id = Guid.NewGuid() ; NamespaceId = namespaceId ; Template = new PageTemplate() { Id = Id, Name = Id.ToString(), IsSiteTemplate = true } ; Regions = Template.RegionTemplates ; }
public int AmountInsert(DataContext Context) { var Amounts = Context.GetTable<CMenuServiceOrderAmount>(); Amounts.InsertOnSubmit(this); return CErrors.ERR_SUC; }
public CMetaobjectExtented(decimal Key, DataContext Context) : base(Key, Context) { this._likesNumberAttribute.Attributes = this._attributes; this.LikesNumber = 0; }
//private static TextWriter dbLinqLogWriter = new StreamWriter(@"C:\Temp\sipsorcery\dblinq.log", true, Encoding.ASCII); public static DataContext CreateDBLinqDataContext(StorageTypes storageType, string connectionString) { DataContext dataContext = null; //DbProviderFactory factory = DbProviderFactories.GetFactory(providerName); //new MySql.Data.MySqlClient.MySqlClientFactory(); //DbProviderFactory factory = Npgsql.NpgsqlFactory.Instance; switch (storageType) { case StorageTypes.DBLinqMySQL: IDbConnection mySqlConn = new MySqlConnection(connectionString); dataContext = new DataContext(mySqlConn, m_mappingSource, new DbLinq.MySql.MySqlVendor()); break; case StorageTypes.DBLinqPostgresql: IDbConnection npgsqlConn = new NpgsqlConnection(connectionString); dataContext = new DataContext(npgsqlConn, m_mappingSource, new DbLinq.PostgreSql.PgsqlVendor()); break; default: throw new NotSupportedException("Database type " + storageType + " is not supported by CreateDBLinqDataContext."); } //dataContext.QueryCacheEnabled = true; //dataContext.Log = Console.Out; //dataContext.Log = dbLinqLogWriter; dataContext.ObjectTrackingEnabled = false; return dataContext; }
private void AddOrUpdate(List<ExcelDeltaker> deltakere, DataContext context) { var alleLag = context.Lag.ToList(); foreach (var excelDeltaker in deltakere) { var deltaker = context.Deltakere.SingleOrDefault(x => x.Kode == excelDeltaker.Kode); var lag = alleLag.SingleOrDefault(x => x.LagId == excelDeltaker.LagId); if (deltaker == null) { context.Deltakere.Add(new Deltaker { DeltakerId = Guid.NewGuid().ToString(), Navn = excelDeltaker.Navn, Kode = excelDeltaker.Kode, Lag = lag }); } else { deltaker.Navn = excelDeltaker.Navn; deltaker.Lag = lag; } } }
public void Cleanup() { DataBoss = null; Context.Dispose(); Context = null; Connection.Dispose(); Connection = null; }
public RequestHandler(DataContext context, IMapper mapper) { this.context = context; this.mapper = mapper; }
public Handler(DataContext context, UserManager <AppUser> userManager, IJwtGenerator jwtGenerator) { _context = context; _userManager = userManager; _jwtGenerator = jwtGenerator; }
public DataContext Init() { return(dbContext ?? (dbContext = new DataContext())); }
public Handler(DataContext context, IMapper mapper, IUserAccessor userAccessor) { _context = context; _mapper = mapper; _userAccessor = userAccessor; }
public HardDiskSizeService(DataContext dataContext) { _context = dataContext; }
protected Repository(IDatabaseFactory databaseFactory) { DatabaseFactory = databaseFactory; dbset = DataContext.Set <T>(); }
public ValuesController(DataContext context) { _context = context; }
public ProductTypeDesignServiceController(DataContext context) { _context = context; }
public gastosController(DataContext context) { _context = context; }
public Handler(DataContext context, IMapper mapper) { _mapper = mapper; _context = context; }
public AttendancesController(DataContext context) { _context = context; }
public Handler(DataContext context) { _context = context; }
public FuncaoRepository(DataContext context) : base(context) { this.context = context; }
public Property(ILogger <Property> logger, DataContext context) { _logger = logger; _context = context; }
public AccountController(DataContext context, ITokenService tokenService) { _context = context; _tokenService = tokenService; }
public PetTypesController(DataContext context) { _context = context; }
public PropertiesController(DataContext dataContext, IConverterHelper converterHelper) { _dataContext = dataContext; _converterHelper = converterHelper; }
public StudentController(DataContext ctx) { _ctx = ctx; }
public GetDiscountQueryHandler(DataContext context, IMapper mapper) { _context = context; _mapper = mapper; }
public CustomerRepository(DataContext context) : base(context) { }
public UserAccessRepository(DataContext dataContext) { _dataContext = dataContext; }
public Handler(DataContext context, UserManager <AppUser> userManager, IUserAccessor userAccessor) { _userAccessor = userAccessor; _userManager = userManager; _context = context; }
public ActionResult Edit(Company c, HttpPostedFileBase file) { bool status=false ; User userdata = (User)Session["UserData"]; Session["UserData"] = userdata; Session["UserID"] = userdata.UserId; ViewBag.ListRecords = GetAllCompany(); ViewBag.States = new SelectList(stController.GetAllState(), "StateID", "StateName"); ViewBag.Countries = new SelectList(cnController.GetAllCountry(), "CountryID", "CountryName"); using (DataContext dc = new DataContext()) { var v = dc.Companies.Where(a => a.CompanyId==c.CompanyId).FirstOrDefault(); if (v != null) { v.CompanyDescription = c.CompanyDescription; v.CompanyLat = c.CompanyLat; v.CompanyLong = c.CompanyLong; v.CompanyAddress = c.CompanyAddress; v.CompanyCity = c.CompanyCity; v.CompanyZipCode = c.CompanyZipCode; v.CompanyTelephoneNo = c.CompanyTelephoneNo; v.DateUpdated=DateTime.Now; if (ModelState.IsValid) { dc.SaveChanges(); status = true; } else { status = false; var modelErrors = new List<string>(); foreach (var modelState in ModelState.Values) { foreach (var modelError in modelState.Errors) { modelErrors.Add(modelError.ErrorMessage); } } } } else status = false; } ViewBag.States = new SelectList(stController.GetAllState(), "StateID", "StateName"); ViewBag.Countries = new SelectList(cnController.GetAllCountry(), "CountryID", "CountryName"); if (status) return RedirectToAction("Index"); else return View(c); }
public Handler(DataContext context) { this._context = context; }
public CharacterServices(IMapper mapper, DataContext context) { _context = context; _mapper = mapper; }
public ActionResult Create(Company c) { string message = ""; bool status = false; int userid = 0; userid = Convert.ToInt32(Session["UserID"]); User u = (User)Session["UserData"]; Session["UserData"] = u; Session["UserID"] = u.UserId; User userdata = (User)Session["UserData"]; if (c.CompanyDescription != null) c.CompanyDescription = ""; if (c.CompanyLat == null) c.CompanyLat = 0; if (c.CompanyLong == null) c.CompanyLong = 0; if (c.CompanyAddress == null) c.CompanyAddress = ""; if (c.CompanyCity == null) c.CompanyCity = ""; if (c.CompanyZipCode == null) c.CompanyZipCode = ""; if (c.CompanyTelephoneNo == null) c.CompanyTelephoneNo = ""; c.IsActive=true; c.DateUpdated = DateTime.Now; using (DataContext dc = new DataContext()) { var v = dc.Companies.Where(a => a.CompanyName.Equals(c.CompanyName)).FirstOrDefault(); if (v == null) { if (ModelState.IsValid) { dc.Companies.Add(c); dc.SaveChanges(); status = true; } else { // var modelErrors = new List<string>(); foreach (var modelState in ModelState.Values) { foreach (var modelError in modelState.Errors) { modelErrors.Add(modelError.ErrorMessage); } } } } } ViewBag.ListRecords = GetAllCompany(); ViewBag.States = new SelectList(stController.GetAllState(), "StateID", "StateName"); ViewBag.Countries = new SelectList(cnController.GetAllCountry(), "CountryID", "CountryName"); if (status) return RedirectToAction("Index"); else return View(c); }
public TransactionService(DataContext context) { _context = context; }
public IsHostRequirementHandler(IHttpContextAccessor httpContextAccessor, DataContext context) { _context = context; _httpContextAccessor = httpContextAccessor; }
public LiquidacionesController(DataContext context) { _context = context; _liquidacionService = new LiquidacionService(_context); }
public AuthRepository(DataContext context) { this.context = context; }
public async Task SetupAsync() { _userViewModel = new LoginViewModel { Email = "*****@*****.**", Password = "******", RememberMe = false }; var context = new DataContext(); _manager = new UserManager(new UserStore(context)); _controller = new AccountController(_manager); var user = await _manager.FindAsync(_userViewModel.Email, _userViewModel.Password); if (user == null) { await _manager.CreateAsync(new User { Email = _userViewModel.Email, UserName = _userViewModel.Email }, _userViewModel.Password); } var mockCp = new Mock<IClaimsPrincipal>(); if (user != null) mockCp.SetupGet(cp => cp.UserId).Returns(user.Id); _controller.CurrentUser = mockCp.Object; var mockAuthenticationManager = new Mock<IAuthenticationManager>(); mockAuthenticationManager.Setup(am => am.SignOut()); mockAuthenticationManager.Setup(am => am.SignIn()); _controller.AuthenticationManager = mockAuthenticationManager.Object; }