本文整理汇总了C#中DatabaseContext类的典型用法代码示例。如果您正苦于以下问题：C# DatabaseContext类的具体用法？C# DatabaseContext怎么用？C# DatabaseContext使用的例子？那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
DatabaseContext类属于命名空间，在下文中一共展示了DatabaseContext类的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的C#代码示例。
示例1: Update
public void Update(ContentItem contentItem)
{
using (DatabaseContext context = new DatabaseContext())
{
context.Update<MSSQL.Entities.ContentItem, ContentItem>(contentItem, new string[] { "Id" });
}
}
开发者ID:orelinde，项目名称:CZCI，代码行数:7，代码来源:ContentItemDao.cs
示例2: Page_Load
protected void Page_Load(object sender, EventArgs e)
{
if (Session["New"] != null)
{
int hitchBotId = (int)Session[SessionInfo.HitchBotId];
var skip = Request.QueryString["skip"];
int skipOver = 0;
if (int.TryParse(skip, out skipOver))
{
currentSkip = skipOver;
}
using (var db = new DatabaseContext())
{
var imageList = db.Images.Where(l => !l.TimeDenied.HasValue && l.TimeApproved.HasValue && l.HitchBotId == hitchBotId).OrderByDescending(l => l.TimeTaken).Skip(skipOver).Take(50).ToList();
var master = Master as imageGrid;
master.SetImageSkip(currentSkip);
master.SetImages(imageList);
}
}
else
{
Response.Redirect("Unauthorized.aspx");
}
}
开发者ID:ElrHolis，项目名称:hitchBOT，代码行数:28，代码来源:ViewSavedImages.aspx.cs
示例3: UserControl_Loaded
private void UserControl_Loaded(object sender, RoutedEventArgs e)
{
using (var context = new DatabaseContext())
{
if (AccountNumber != null)
{
var account = context.CustomerAccounts.FirstOrDefault(c => c.AccountNumber == AccountNumber);
if (account != null)
{
var customer = context.Customers.FirstOrDefault(c => c.CustomerID == account.CustomerID);
var territory = context.Territories.FirstOrDefault(c => c.TerritoryID == account.TerritoryID);
var product = context.Products.FirstOrDefault(c => c.ProductID == account.ProductID);
var agent = context.Agents.FirstOrDefault(c => c.AgentId == account.AgentId);
if (customer != null && territory != null && product != null)
{
txtAccountNumber.Text = account.AccountNumber;
txtDiscount.Text = account.Discount;
txtGross.Text = account.Gross;
txtNetValue.Text = account.NetValue;
txtServiceCharge.Text = account.ServiceCharge;
txtCompanyName.Text = customer.CompanyName;
txtModeOfPayment.Text = account.ModeOfPayment;
txtProduct.Text = product.ProductName;
txtTerritory.Text = territory.TerritoryName;
txtAgent.Text = agent.AgentName;
}
}
}
}
}
开发者ID:tonryu，项目名称:NSPIRESystem，代码行数:32，代码来源:CustomerAccountDetails.xaml.cs
示例4: QueryValidateUser
private Task<string> QueryValidateUser(string str1, string str2)
{
return Task.Factory.StartNew(() =>
{
try
{
using (var context = new DatabaseContext())
{
var user = context.UserAccounts.FirstOrDefault(c => c.UserAccountId == str1
&& c.Password == str2);
if (user != null)
{
empno = str1;
mainUser = user;
return null;
}
else
{
mainUser = null;
return "Invalid username or password";
}
}
}
catch (Exception ex)
{
return "Error : " + ex.Message;
}
});
}
开发者ID:tonryu，项目名称:NSPIRESystem，代码行数:30，代码来源:Login.xaml.cs
示例5: GetFiltered
static IQueryable<Journal> GetFiltered(Filter filter, DatabaseContext context)
{
IQueryable<Journal> result = context.Journal;
if (filter.JournalTypes.Any())
result = result.Where(x => filter.JournalTypes.Contains(x.JournalType));
if (filter.ConsumerUIDs.Any())
result = result.Where(x => filter.ConsumerUIDs.Contains(x.ObjectUID));
if (filter.DeviceUIDs.Any())
result = result.Where(x => filter.DeviceUIDs.Contains(x.ObjectUID));
if (filter.UserUIDs.Any())
result = result.Where(x => filter.UserUIDs.Contains(x.UserUID));
if (filter.TariffUIDs.Any())
result = result.Where(x => filter.TariffUIDs.Contains(x.ObjectUID));
result = result.Where(x => x.DateTime > filter.StartDate && x.DateTime < filter.EndDate);
if (filter.IsSortAsc)
result = result.OrderBy(x => x.DateTime);
else
result = result.OrderByDescending(x => x.DateTime);
return result;
}
开发者ID:xbadcode，项目名称:Rubezh，代码行数:27，代码来源:DbCache.Journal.cs
示例6: LoadEmployees
private void LoadEmployees(string text)
{
using (var context = new DatabaseContext())
{
var employee = context.Employees.ToList();
listEmployees.Items.Clear();
employeesList.Clear();
if (employee != null)
{
foreach (var item in employee)
{
employeesList.Add(new EmployeeView
{
EmployeeName = item.FirstName + " " + item.MiddleName + " " + item.LastName
});
}
}
foreach (var item in employeesList.Where(c => c.EmployeeName.ToLower().Contains(text.ToLower())).ToList())
{
listEmployees.Items.Add(item.EmployeeName);
}
}
}
开发者ID:tonryu，项目名称:NSPIRESystem，代码行数:25，代码来源:EmployeeSelection.xaml.cs
示例7: DbService
public DbService()
{
Context = new DatabaseContext(DbServiceHelper.CreateConnection());
Context.Database.CommandTimeout = 180;
GKScheduleTranslator = new GKScheduleTranslator(this);
GKDayScheduleTranslator = new GKDayScheduleTranslator(this);
PassJournalTranslator = new PassJournalTranslator(this);
JournalTranslator = new JournalTranslator(this);
AccessTemplateTranslator = new AccessTemplateTranslator(this);
AdditionalColumnTypeTranslator = new AdditionalColumnTypeTranslator(this);
CardTranslator = new CardTranslator(this);
CurrentConsumptionTranslator = new CurrentConsumptionTranslator(this);
DayIntervalTranslator = new DayIntervalTranslator(this);
DepartmentTranslator = new DepartmentTranslator(this);
EmployeeTranslator = new EmployeeTranslator(this);
HolidayTranslator = new HolidayTranslator(this);
NightSettingTranslator = new NightSettingTranslator(this);
OrganisationTranslator = new OrganisationTranslator(this);
PassCardTemplateTranslator = new PassCardTemplateTranslator(this);
PositionTranslator = new PositionTranslator(this);
ScheduleTranslator = new ScheduleTranslator(this);
ScheduleSchemeTranslator = new ScheduleSchemeTranslator(this);
GKCardTranslator = new GKCardTranslator(this);
GKMetadataTranslator = new GKMetadataTranslator(this);
TimeTrackTranslator = new TimeTrackTranslator(this);
TimeTrackDocumentTypeTranslator = new TimeTrackDocumentTypeTranslator(this);
TimeTrackDocumentTranslator = new TimeTrackDocumentTranslator(this);
TestDataGenerator = new TestDataGenerator(this);
ImitatorUserTraslator = new ImitatorUserTraslator(this);
ImitatorScheduleTranslator = new ImitatorScheduleTranslator(this);
ImitatorJournalTranslator = new ImitatorJournalTranslator(this);
}
开发者ID:xbadcode，项目名称:Rubezh，代码行数:32，代码来源:DbService.cs
示例8: LoadProducts
private void LoadProducts(string text)
{
using (var context = new DatabaseContext())
{
var products = context.Products.ToList();
listProducts.Items.Clear();
productsList.Clear();
if (products != null)
{
foreach (var product in products)
{
productsList.Add(new ProductView
{
ProductName = product.ProductName
});
}
}
foreach (var item in productsList.Where(c => c.ProductName.ToLower().Contains(text.ToLower()) && c.ProductName != " ").OrderBy(c => c.ProductID).ToList())
{
listProducts.Items.Add(item.ProductName);
}
}
}
开发者ID:tonryu，项目名称:NSPIRESystem，代码行数:25，代码来源:ProductSelection.xaml.cs
示例9: WizardDialog
public WizardDialog()
{
InitializeComponent();
//New Up DB Object
_db = new DatabaseContext();
}
开发者ID:sahbijabnouni，项目名称:Umbraco-VS-New-Project，代码行数:7，代码来源:WizardDialog.xaml.cs
示例10: CreatePoll
public async Task<IHttpActionResult> CreatePoll(string name)
{
using (var dbContext = new DatabaseContext())
{
if (string.IsNullOrWhiteSpace(name))
return BadRequest().WithReason("A name is required");
var exists = await GetPolls(dbContext, DateTime.Now)
.AnyAsync(p => p.Name == name);
if (exists)
return StatusCode(HttpStatusCode.Conflict)
.WithReason("A poll with the same name already exists");
var currentUser = await dbContext.Users.SingleAsync(u => u.UserName == User.Identity.Name);
var poll = new LunchPoll
{
Name = name,
Date = DateTime.Now,
Voters = new List<User>(),
Votes = new List<LunchVote>()
};
dbContext.LunchPolls.Add(poll);
await AddToPoll(dbContext, poll, currentUser);
await dbContext.SaveChangesAsync();
LunchHub.OnPollChanged(new LunchPollViewModel(poll));
return Ok();
}
}
开发者ID:Quantumplation，项目名称:Various.Services，代码行数:29，代码来源:LunchApi.cs
示例11: GetOptions
public IEnumerable<LunchOption> GetOptions(string q = "")
{
using (var dbContext = new DatabaseContext())
{
return dbContext.LunchOptions.Where(o => o.Name.Contains(q)).ToList();
}
}
开发者ID:Quantumplation，项目名称:Various.Services，代码行数:7，代码来源:LunchApi.cs
示例12: CreateActiveUser
public static UserEntity CreateActiveUser(string email, Role role)
{
using (var context = new DatabaseContext())
{
var passwordManager = new PasswordManager(new Configuration());
var salt = passwordManager.GenerateSalt();
var hashedPassword = passwordManager.HashPassword(Password, salt);
var enctyptedSecurePhrase = passwordManager.EncryptSecurePhrase(Phrase);
var user = new UserEntity
{
Id = Guid.NewGuid(),
Email = email,
FirstName = email,
LastName = email,
Role = role,
UserState = UserState.Activated,
PasswordSalt = salt,
HashedPassword = hashedPassword,
EncryptedSecurePhrase = enctyptedSecurePhrase,
FirstSecurePhraseQuestionCharacterIndex = 0,
SecondSecurePhraseQuestionCharacterIndex = 1,
};
context.Users.Add(user);
context.SaveChanges();
return user;
}
}
开发者ID:Cognite-Soft，项目名称:ARB_2016_V2，代码行数:27，代码来源:Database.cs
示例13: UserControl_Loaded
private void UserControl_Loaded(object sender, RoutedEventArgs e)
{
using (var context = new DatabaseContext())
{
var markstrat = new MarketingStrategy();
if (MarketingStrategiesId > 0)
{
var markstarte = context.MarketingStrategies.FirstOrDefault(c => c.MarketingStrategyId == MarketingStrategiesId);
if (markstarte != null)
{
lblMarketingStrategyId.Visibility = Visibility.Visible;
txtMarketingStrategyId.Visibility = Visibility.Visible;
Grid.SetRow(lblMarketingStrategyName, 1);
Grid.SetRow(txtMarketingStrategyName, 1); Grid.SetColumn(txtMarketingStrategyName, 1);
txtMarketingStrategyId.Text = Convert.ToString(markstarte.MarketingStrategyId);
txtMarketingStrategyName.Text = markstarte.Description;
}
}
else
{
lblMarketingStrategyId.Visibility = Visibility.Hidden;
txtMarketingStrategyId.Visibility = Visibility.Hidden;
Grid.SetRow(lblMarketingStrategyName, 0);
Grid.SetRow(txtMarketingStrategyName, 0); Grid.SetColumn(txtMarketingStrategyName, 1);
txtMarketingStrategyName.Text = "";
}
}
}
开发者ID:tonryu，项目名称:NSPIRESystem，代码行数:33，代码来源:MarketingStrategiesForm.xaml.cs
示例14: Window_Loaded
private void Window_Loaded(object sender, RoutedEventArgs e)
{
using (var context = new DatabaseContext())
{
var lead = context.Leads.FirstOrDefault(c => c.LeadID == LeadId);
var territory = context.Territories.FirstOrDefault(c => c.TerritoryID == lead.TerritoryID);
txtCompanyAddress.Text = lead.CompanyAddress;
txtCompanyName.Text = lead.CompanyName;
txtLeadId.Text = Convert.ToString(lead.LeadID);
txtStatus.Text = lead.Status;
txtTerritory.Text = territory.TerritoryName;
}
#region animation onLoading
double screenWidth = Application.Current.MainWindow.Width;
if (screenLeftEdge > 0 || screenLeftEdge < -8)
{
screenWidth += screenLeftEdge;
}
DoubleAnimation animation = new DoubleAnimation(0, this.Width, (Duration)TimeSpan.FromSeconds(0.3));
DoubleAnimation animation2 = new DoubleAnimation(screenWidth, screenWidth - this.Width, (Duration)TimeSpan.FromSeconds(0.3));
this.BeginAnimation(Window.WidthProperty, animation);
this.BeginAnimation(Window.LeftProperty, animation2);
#endregion
}
开发者ID:tonryu，项目名称:NSPIRESystem，代码行数:26，代码来源:LeadDetailsWindow.xaml.cs
示例15: Update
public void Update(Timeline timeline)
{
using (DatabaseContext context = new DatabaseContext())
{
context.Update<MSSQL.Entities.ContentItem, Timeline>(timeline, new string[] { "Id", "Timestamp" });
}
}
开发者ID:orelinde，项目名称:CZCI，代码行数:7，代码来源:TimelineDao.cs
示例16: NewQuote
public async Task<ActionResult> NewQuote(QuoteViewModel vm)
{
using (var dbContext = new DatabaseContext())
{
var quote = new Quote
{
Text = vm.Text,
Submitter = dbContext.Users.Single(u => u.UserName == User.Identity.Name),
CreatedAt = DateTime.Now,
Tags = new List<Tag>()
};
var user = dbContext.Users.SingleOrDefault(x => x.UserName == vm.Author);
if (user != null)
{
quote.Author = user;
}
else
{
quote.AlternateAuthor = String.IsNullOrWhiteSpace(vm.Author) ? "Anonymous" : vm.Author;
}
dbContext.Quotes.Add(quote);
vm = new QuoteViewModel(quote);
await dbContext.SaveChangesAsync();
QuotesHub.NewQuote(quote);
}
return PartialView("_Quote", vm);
}
开发者ID:Quantumplation，项目名称:Various.Services，代码行数:27，代码来源:QuotesController.cs
示例17: btnOK_Click
private void btnOK_Click(object sender, RoutedEventArgs e)
{
using (var context = new DatabaseContext())
{
if (listProducts.SelectedItems != null)
{
foreach (var product in listProducts.SelectedItems)
{
var convertedProduct = Convert.ToString(product);
var prod = context.Products.FirstOrDefault(c => c.ProductName == convertedProduct);
passList = prod.ProductName;
}
Variables.yesClicked = true;
var frame = DevExpress.Xpf.Core.Native.LayoutHelper.FindParentObject<NavigationFrame>(this);
frame.BackNavigationMode = BackNavigationMode.PreviousScreen;
frame.GoBack();
LeadForm.isSelectFinish = true;
}
else
{
var window = new NoticeWindow();
NoticeWindow.message = "Please select a row.";
window.Height = 0;
window.Top = Application.Current.MainWindow.Top + 8;
window.Left = (screenWidth / 2) - (window.Width / 2);
if (screenLeftEdge > 0 || screenLeftEdge < -8) { window.Left += screenLeftEdge; }
window.ShowDialog();
}
}
}
开发者ID:tonryu，项目名称:NSPIRESystem，代码行数:32，代码来源:ProductSelection.xaml.cs
示例18: UserControl_Loaded
private void UserControl_Loaded(object sender, RoutedEventArgs e)
{
using (var context = new DatabaseContext())
{
if (SalesStageId > 0)
{
var stage = context.SalesStages.FirstOrDefault(c => c.SalesStageID == SalesStageId);
if (stage != null)
{
lblsaleId.Visibility = Visibility.Visible;
txtSalesId.Visibility = Visibility.Visible;
Grid.SetRow(lblSaleName, 1);
Grid.SetRow(txtSalesStageName, 1); Grid.SetColumn(txtSalesStageName, 1);
Grid.SetRow(lblRAnk, 2);
Grid.SetRow(txtRankNo, 2); Grid.SetColumn(txtRankNo, 1);
txtSalesId.Text = Convert.ToString(stage.SalesStageID);
txtRankNo.Text = Convert.ToString(stage.RankNo);
txtSalesStageName.Text = stage.SalesStageName;
}
}
else
{
lblsaleId.Visibility = Visibility.Hidden;
txtSalesId.Visibility = Visibility.Hidden;
Grid.SetRow(lblSaleName, 0);
Grid.SetRow(txtSalesStageName, 0); Grid.SetColumn(txtSalesStageName, 1);
Grid.SetRow(lblRAnk, 1);
Grid.SetRow(txtRankNo, 1); Grid.SetColumn(txtRankNo, 1);
txtSalesStageName.Text = "";
txtRankNo.Text = "";
}
}
}
开发者ID:tonryu，项目名称:NSPIRESystem，代码行数:35，代码来源:SalesStageForm.xaml.cs
示例19: CreateArrangementWithUsers
public void CreateArrangementWithUsers()
{
using (DatabaseContext ctx = new DatabaseContext())
{
ArrangementRepository repository = new ArrangementRepository(ctx);
var arrangement = repository.Add();
arrangement.Name = "Koops Furness";
arrangement.BpNumber = "123456789";
var user1 = new User() {UserName = "user1", Email = "[email protected]", FullName = "User One"};
var user2 = new User() {UserName = "user2", Email = "[email protected]", FullName = "User Two"};
arrangement.Users.Add(user1);
arrangement.Users.Add(user2);
Assert.IsTrue(arrangement.Id == 0);
Assert.IsTrue(user1.Id == 0);
Assert.IsTrue(user2.Id == 0);
ctx.SaveChanges();
Assert.IsTrue(arrangement.Id > 0);
Assert.IsTrue(user1.Id > 0);
Assert.IsTrue(user2.Id > 0);
Assert.AreEqual(arrangement, user1.Arrangements.Single());
Assert.AreEqual(arrangement, user2.Arrangements.Single());
}
}
开发者ID:phoogestijn，项目名称:EntityFrameworkSandbox，代码行数:29，代码来源:ArrangementTests.cs
示例20: Add
public ContentItem Add(ContentItem contentItem)
{
using (DatabaseContext context = new DatabaseContext())
{
return context.AddContentItem<MSSQL.Entities.ContentItem, ContentItem>(contentItem);
}
}
开发者ID:orelinde，项目名称:CZCI，代码行数:7，代码来源:ContentItemDao.cs
注：本文中的DatabaseContext类示例整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。 |
客服电话
APP下载
官方微信
请发表评论