private void BtSql_Click(object sender, RoutedEventArgs e)
{
try
{
context = TbSql.Text;
var accessDb = new DBContextFactory();
List <string> listedData = accessDb.getData(context);
int count = listedData.Count;
string record1 = listedData[0].ToString();
string record2 = listedData[1].ToString();
Panel.AppendText("\r\n" + record1.ToString() + "\r\n" + record2);
}
catch (Exception err)
{
if (err != null)
{
Panel.Text = err.ToString();
}
}
}
public void SaveAuthModelInDB(string connectionString, string clientName, string publicToken, string secretToken, string storeAddress /*AuthParameters authParams*/)
{
//string nonQuery = @"insert into web_api_credentials (client_id,client_secret,access_token,refresh_token,redirect_url,server_url) values
// ('{0}','{1}','{2}','{3}','{4}','{5}')";
//SqlCommand command = new SqlCommand(String.Format(nonQuery, authParams.ClientId, authParams.ClientSecret,
// authParams.authModel.AccessToken, authParams.authModel.RefreshToken, authParams.RedirectUrl, authParams.ServerUrl));
DBContextFactory.SetConnection(connectionString);
string nonQuery = @"insert into web_api_credentials (clientName,publicToken,secretToken,storeaddress) values
('{0}','{1}','{2}','{3}')";
SqlCommand command = new SqlCommand(String.Format(nonQuery, clientName, publicToken, secretToken, storeAddress));
DBContextFactory.DBContext.BeginTransaction();
int result = DBContextFactory.DBContext.NonQuery(command);
if (result < 0)
{
DBContextFactory.DBContext.RollbackTransaction();
}
else
{
DBContextFactory.DBContext.CommitTransaction();
}
}
public static BaseViewModel GetOverviewViewModel(MainViewModel parent)
{
var dbContext = DBContextFactory.GetAdoDatabaseContext();
return(new OverviewViewModel(ref parent,
new GenreLogic(dbContext),
new ScheduleLogic(dbContext)));
}
public SubscriptionsModule(DBContextFactory factory, EmbedService embedService, Config config, CNNService cnnService, RedditService redditService, MathService mathService) : base(mathService)
{
DBFactory = factory;
EmbedService = embedService;
Config = config;
CNNService = cnnService;
RedditService = redditService;
}
public CNNService(IServiceProvider provider) : base(provider)
{
TextChannnels = new List <SocketTextChannel>();
Config = provider.GetService <Config>();
HttpService = provider.GetService <HttpService>();
Factory = provider.GetService <DBContextFactory>();
CheckTimer = null;
PostedArticles = new List <string>();
}
public StatsModule(EmbedService embedService, Config config, TrackingService trackingService, MathService mathService, ImageService imageService, DBContextFactory dbFactory) : base(mathService)
{
EmbedService = embedService;
Config = config;
TrackingService = trackingService;
MathService = mathService;
ImageService = imageService;
DBFactory = dbFactory;
}
public DataModule(HttpService httpService, EmbedService embedService, TrackingService trackingService, ImageService imageService, DBContextFactory dbFactory, Config config, MathService mathService) : base(mathService)
{
HttpService = httpService;
EmbedService = embedService;
TrackingService = trackingService;
ImageService = imageService;
DBFactory = dbFactory;
Config = config;
}
public static BaseViewModel GetPaymentViewModel(MainViewModel parent,
Schedule selectedSchedule,
IList <SelectionViewModel <TakenSeatViewModel> > selectedSeats)
{
return(new PaymentViewModel(ref parent,
selectedSchedule,
selectedSeats,
new PaymentLogic(),
new ReservationLogic(DBContextFactory.GetAdoDatabaseContext())));
}
public static BaseViewModel GetDetailViewModel(MainViewModel parent, Movie selectedMovie)
{
var dbContext = DBContextFactory.GetAdoDatabaseContext();
return(new DetailViewModel(ref parent,
selectedMovie,
new ScheduleLogic(dbContext),
new ReservationLogic(dbContext),
new SeatLogic(dbContext)));
}
public static DataSettings DatabaseIsInstalled()
{
var settings = DatabaseManager.LoadSettings();
if (settings != null && !String.IsNullOrEmpty(settings.DataConnectionString))
{
DBContextFactory.SetConnection(settings.DataConnectionString);
}
return(settings);
}
public static async Task PopulateDummyCars(int NumberOfCars)
{
// Ask the DBContextFactory to create the desired DbContext object for use for database access
DSuiteContext db = DBContextFactory.GetDbContext <DSuiteContext>();
for (int i = 0; i < NumberOfCars; ++i)
{
Car NewCar = GenerateCar();
await EFCrud.Create(db, NewCar);
}
}
//public string GetGuid()
//{
// return _context.Guid.ToString();
//}
/// <summary>
/// 会报错
/// </summary>
/// <returns></returns>
public string GetGuidAsync()
{
Task <string> task = new Task <string>(() =>
{
DBContext context = DBContextFactory.GetDBContext();
return(context.Guid.ToString());
});
task.Start();
return(task.Result);
}
public virtual bool Add(T instance)
{
try
{
DBContextFactory.GetDbContextInstance().Set <T>().Add(instance);
return(true);
}
catch (Exception e)
{
return(false);
}
}
public async Task CRUDUsingHelperClass()
{
Car newCar = GenerateCar();
// Demonstrate basic CRUD
DSuiteContext db = DBContextFactory.GetDbContext <DSuiteContext>();
await EFCrud.Create(db, newCar);
Car found = await EFCrud.GetByKey(db, newCar);
EFCrud.Delete(db, found);
}
private void LoadEvents()
{
if (this.Events != null)
{
this.Events.Clear();
}
DBContextFactory factory = new DBContextFactory();
var eventRepository = new EventRepository(factory);
IEnumerable <event_detail> ed = eventRepository.GetAll();
this.Events = new ObservableCollection <event_detail>(ed.ToList <event_detail>());
}
public GeometryEditViewModel(DBContextFactory contextFactory)
{
if (IsInDesignMode)
{
// Code runs in Blend --> create design time data.
}
else
{
ContextFactory = contextFactory;
}
SaveChangesCommand = new RelayCommand(SaveChanges);
RestoreShapeCommand = new RelayCommand(RestoreShape);
}
public void FindMultipleUsingLINQ()
{
DSuiteContext dSuiteContext = DBContextFactory.GetDbContext <DSuiteContext>();
// Demonstrate the deferred execution POWER of IQueryable!
// Find a small list of cars that we don't need to page through.
IQueryable <Car> linqFordBunnies = (from c in dSuiteContext.Cars where c.Make == "Ford" && c.Model == "Bunny" && c.Year < 2006 select c);
// But I DO want to sort them too. Still no DB call here!
linqFordBunnies = linqFordBunnies.OrderBy(bunny => bunny.Mileage);
// NOW, go ahead and execute the query against the database
linqFordBunnies.DumpData("\r\n\r\n==============FindMultipleUsingLINQ==============================");
}
public ReferenceViewModel(DBContextFactory contextFactory)
{
if (IsInDesignMode)
{
// Code runs in Blend --> create design time data.
}
else
{
ContextDb = contextFactory.Create();
LoadDataAsync();
}
//Инициализация комманд
SaveChangesCommand = new RelayCommand(SaveChanges);
UndoChangesCommand = new RelayCommand(UndoChanges);
}
public override bool Delete(int key)
{
try
{
DBContextFactory.GetDbContextInstance()
.TicketMasterUsers.Remove(
DBContextFactory.GetDbContextInstance().TicketMasterUsers.SingleOrDefault(k => k.UserId == key));
_unitOfWork.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
public override bool Delete(int key)
{
try
{
DBContextFactory.GetDbContextInstance()
.EntertainmentAddresses.Remove(
DBContextFactory.GetDbContextInstance().EntertainmentAddresses.SingleOrDefault(k => k.AddressId == key));
_unitOfWork.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
public MapViewModel(DBContextFactory contextFactory)
{
if (IsInDesignMode)
{
// Code runs in Blend --> create design time data.
}
else
{
ContextDbFactory = contextFactory;
LoadDataAsync();
}
//Инициализация комманд
FindParcelCommand = new RelayCommand <string>(FindParcelAsync, (o) => FindParcelCommandCanExecute);
FindParcelCommandCanExecute = true;
ClearFindedParcelCommand = new RelayCommand(ClearFindedParcel);
}
public override bool Update(TicketMasterUser instance)
{
try
{
var user =
DBContextFactory.GetDbContextInstance()
.TicketMasterUsers.SingleOrDefault(k => k.UserId == instance.UserId);
user.UserName = instance.UserName;
user.Email = instance.Email;
_unitOfWork.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
public override bool Update(Booking instance)
{
try
{
var booking =
DBContextFactory.GetDbContextInstance()
.Bookings.SingleOrDefault(k => k.BookingId == instance.BookingId);
booking.BookingDate = instance.BookingDate;
booking.EventId = instance.EventId;
booking.NumberOfTickets = instance.NumberOfTickets;
_unitOfWork.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
public override bool Update(Ticket instance)
{
try
{
var ticket =
DBContextFactory.GetDbContextInstance()
.Tickets.SingleOrDefault(k => k.TicketId == instance.TicketId);
ticket.EventId = instance.EventId;
ticket.Price = instance.Price;
ticket.TicketGUID = instance.TicketGUID;
_unitOfWork.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
public virtual BookingTicketInfo[] GetTicketsForUserVerified()
{
var DBContext = DBContextFactory.GetDbContextInstance();
var userRepository = new TicketMasterUserRepository(new UnitOfWork.UnitOfWork());
var tickets = from t in DBContext.Tickets
from b in DBContext.Bookings
from u in DBContext.TicketMasterUsers
where t.TicketId == b.TicketId && b.IsVerifiedPayment == true && u.UserId == b.UserId
select new BookingTicketInfo
{
BookingId = b.BookingId,
EventName = b.Ticket.Event.EventName,
IsVerifiedPayment = true,
NumberOfTickets = (int)b.NumberOfTickets,
Username = u.UserName
};
return(tickets.ToArray());
}
public virtual EntertainmentAddress GetEntertainmentAddressByUsername(string username)
{
try
{
var user =
DBContextFactory.GetDbContextInstance()
.TicketMasterUsers.SingleOrDefault(p => p.UserName == username);
if (user != null)
{
var EntertainmentAddress = DBContextFactory.GetDbContextInstance().EntertainmentAddresses.SingleOrDefault(p => p.UserId == user.UserId);
return(EntertainmentAddress);
}
}
catch (Exception e)
{
}
return(null);
}
public virtual BookingStats[] GetStatsByMonth(DateTime fro, DateTime to)
{
var DBContext = DBContextFactory.GetDbContextInstance();
var results = from b in DBContext.Bookings
from t in DBContext.Tickets
where b.EventId == t.EventId && b.BookingDate >= fro && b.BookingDate <= to
orderby b.Ticket.Event.EventName
group t by b.BookingDate.Value.Month
into gr
select
new BookingStats
{
NumberOfTickets = (int)gr.Count(),
TotalAmount = (decimal)gr.Select(p => p.Price * gr.Count()).FirstOrDefault(),
BookingDate = gr.Key
};
return(results.ToArray());
}
public override bool Update(EntertainmentAddress instance)
{
try
{
var EntertainmentAddress =
DBContextFactory.GetDbContextInstance()
.EntertainmentAddresses.SingleOrDefault(k => k.UserId == instance.UserId);
EntertainmentAddress.AddressLine1 = instance.AddressLine1;
EntertainmentAddress.AddressLine2 = instance.AddressLine2;
EntertainmentAddress.Town = instance.Town;
EntertainmentAddress.Country = instance.Country;
EntertainmentAddress.PostCode = instance.PostCode;
_unitOfWork.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
public static bool CheckTableExistence(string connectionString, string tableName)
{
bool exists;
try
{
exists = true;
DBContextFactory.SetConnection(connectionString);
DBContextFactory.DBContext.OpenConnection();
DBContextFactory.DBContext.NonQuery("select 1 from " + tableName + " where 1 = 0");
DBContextFactory.DBContext.CloseConnection();
}
catch (Exception e)
{
exists = false;
DBContextFactory.DBContext.CloseConnection();
}
return(exists);
}
public virtual GroupedBooking[] GetBookingsByEvent(DateTime fro, DateTime to)
{
var DBContext = DBContextFactory.GetDbContextInstance();
var results = from b in DBContext.Bookings
from t in DBContext.Tickets where b.EventId == t.EventId && b.BookingDate >= fro && b.BookingDate <= to
orderby b.Ticket.Event.EventName
group t by b
into gr
select
new GroupedBooking
{
BookingId = (int)gr.Key.BookingId,
EventName = gr.Key.Ticket.Event.EventName,
NumberOfTickets = (int)gr.Key.NumberOfTickets,
TotalAmount = (decimal)gr.Where(q => q.TicketId == gr.Key.TicketId).Select(p => p.Price * gr.Key.NumberOfTickets).FirstOrDefault(),
BookingDate = (DateTime)gr.Key.BookingDate
};
return(results.ToArray());
}
