static void Main(string[] args)
{
DbContextOptionsBuilder <MobileDbContext> builder = new DbContextOptionsBuilder <MobileDbContext>();
builder.UseSqlServer("Data Source=.;DataBase = MobileStore;Integrated Security=True");
MobileDbContext context = new MobileDbContext(builder.Options);
Console.ReadKey();
}
public ActionResult SendReview(Review review, float rating)
{
MobileDbContext db = new MobileDbContext();
string session = Session[USER_SESSION].ToString();
review.DatePost = DateTime.Now;
//review.UserId = db.User.Single(a => a.UserName.Equals(session)).ID;
review.Rating = rating;
db.Review.Add(review);
db.SaveChanges();
return(RedirectToAction("Detail", "Product", new { id = review.ProductId }));
}
private void GetMobileServiceOnline(Subscription subscription)
{
MobileDbContext ctx = new MobileDbContext();
var subscriptionDb = ctx.Subscriptions.Where(s => s.Id == subscription.Id).First();
try
{
var service = Data.Helper.GetMobileServiceInSubscription(subscription.Id.ToString("d"));
if (service == null)
{
return;
}
service.ForEach(u =>
{
if (!MobileServiceList.Contains(u.Name))
{
Application.Current.Dispatcher.Invoke(() => MobileServiceList.Add(u.Name));
subscriptionDb.MobileServices.Add(new MobileService()
{
Name = u.Name
});
try
{
ctx.SaveChanges();
Message = String.Format("Inserted New Mobile Service Reference : {0}", u.Name);
}
catch (Exception e) {
Message = String.Format("Error during Mobile Service List Update : {0}", e.Message);
}
}
});
}
catch (Exception e) {
Message = e.Message;
}
}
internal void SubscriptionsChanged(Subscription subscription)
{
LoadingRingMessage = true;
Message = String.Format("Get Mobile Service From Subscription : {0} ", subscription.Name);
Application.Current.Dispatcher.Invoke(() => MobileServiceList.Clear());
//Update list of mobile service
MobileDbContext ctx = new MobileDbContext();
var mobileService = ctx.MobileServices.Where(u => u.subscription.Id == subscription.Id).ToList();
foreach (var item in mobileService)
{
Application.Current.Dispatcher.Invoke(() => MobileServiceList.Add(item.Name));
}
if (AutoRefresh)
{
GetMobileServiceOnline(subscription);
}
Message = String.Empty;
LoadingRingMessage = false;
}
private async void MainPage_OnAppearing(object sender, EventArgs e)
{
var dbFolder = Environment.GetFolderPath(Environment.SpecialFolder.Personal);
var fileName = "Test.db";
var dbFullPath = Path.Combine(dbFolder, fileName);
using (var dbContext = new MobileDbContext($"Filename={dbFullPath}"))
{
var migrateResult = await DbOperationsWrappers.PerformSafelyAsync(dbContext, async db =>
{
await db.Database.MigrateAsync();
return(new ErrorOr <Nothing>(new Nothing()));
});
if (migrateResult.IsError)
{
Debug.WriteLine(migrateResult.Error.Exception.Message);
return;
}
Debug.WriteLine("DbMigrated");
var createTasksResult = await DbOperationsWrappers.PerformSafelyAsync(dbContext, async db =>
{
var tasks = new List <TaskEntity>();
var startBase = new DateTime(2017, 10, 1);
for (var i = 1; i <= 100; i++)
{
tasks.Add(new TaskEntity
{
Title = $"Task {i}",
Description = Guid.NewGuid().ToString(),
Start = startBase.AddDays(i),
End = startBase.AddDays(i + 2)
});
}
db.Tasks.AddRange(tasks);
await db.SaveChangesAsync();
return(new ErrorOr <Nothing>(new Nothing()));
});
if (createTasksResult.IsError)
{
Debug.WriteLine(createTasksResult.Error.Exception.Message);
return;
}
Debug.WriteLine("Tasks created");
var loadTasksResult = await DbOperationsWrappers.PerformSafelyAsync(dbContext, async db =>
{
var tasks = await db.Tasks.AsNoTracking().ToListAsync();
return(new ErrorOr <List <TaskEntity> >(tasks));
});
if (loadTasksResult.IsError)
{
Debug.WriteLine(loadTasksResult.Error.Exception.Message);
return;
}
Debug.WriteLine("Tasks loaded");
}
}
public UserFeedController(IConfiguration _configuration, MobileDbContext _db, IHostingEnvironment _env)
{
configuration = _configuration;
db = _db;
env = _env;
}
public AccountController(MobileDbContext context, UserManager <IdentityUser> userManager, SignInManager <IdentityUser> signInManager)
{
_context = context;
_userManager = userManager;
_signInManager = signInManager;
}
public CartProductsRepository(MobileDbContext dbContext)
{
_dbContext = dbContext;
}
public Repository(MobileDbContext context)
{
_context = context;
_dbSet = _context.Set <TEntity>();
}
public CartRepository(MobileDbContext context, IUnitOfWork unitOfWork) : base(context)
{
_unitOfWork = unitOfWork;
}
public CustomerRepository(MobileDbContext context) : base(context)
{
}
public MobileBrandRepository(MobileDbContext dbContext)
{
_dbContext = dbContext;
}
public UnitOfWork(MobileDbContext context)
{
_context = context;
}
public void LoadPublishProfile(PublishDataPublishProfile profile_)
{
new DelegateCommandBW((o) =>
{
try
{
var profile = o as PublishDataPublishProfile;
LoadingRingMessage = true;
Message = "Loading Publish Profile";
if (profile.Subscription.Count() != 0)
{
var _sub = new List <Subscription>();
MobileDbContext ctx = new MobileDbContext();
foreach (var subscription in profile.Subscription)
{
_sub.Add(new Subscription()
{
Id = Guid.Parse(subscription.Id),
Name = subscription.Name,
Cert = subscription.ManagementCertificate
});
var subId = Guid.Parse(subscription.Id);
//Check If subscription already exist in the database
if (!ctx.Subscriptions.Any(u => u.Id == subId))
{
Message = String.Format("New Subscription : {0} added", subscription.Name);
var subToInsert = new Subscription()
{
Id = subId,
Name = subscription.Name,
Cert = subscription.ManagementCertificate
};
ctx.Subscriptions.Add(subToInsert);
Application.Current.Dispatcher.Invoke(() =>
{
Subscriptions.Add(subToInsert);
});
}
//Else Check if the certificate has changed, take the last certificate
else if (ctx.Subscriptions.Find(subId) != null)
{
var sub = ctx.Subscriptions.Find(subId);
if (sub.Cert != subscription.ManagementCertificate)
{
sub.Cert = subscription.ManagementCertificate;
Message = String.Format("Certificate change for Subscription :{0}",
subscription.Name);
}
}
}
ctx.SaveChanges();
Message = "Publish Profile Loaded";
}
else
{
Message = "No subscription found in the publish profile";
}
}
catch (Exception e)
{
Message = e.Message;
}
finally
{
LoadingRingMessage = false;
}
}).Execute(profile_);
}
public LoginController(IConfiguration _configuration, MobileDbContext _db)
{
configuration = _configuration;
db = _db;
}
public ReviewDao()
{
db = new MobileDbContext();
}
public OrderDetailDao()
{
db = new MobileDbContext();
}
public MobilePhoneRepository(MobileDbContext context) : base(context)
{
}
public MenuDao()
{
db = new MobileDbContext();
}
public UserProfileController(IConfiguration _configuration, MobileDbContext _db)
{
configuration = _configuration;
db = _db;
}
public ProductDetailsRepository(MobileDbContext dbContext)
{
_dbContext = dbContext;
}
public AccountController(MobileDbContext context)
{
_context = context;
}
public CategoryDao()
{
db = new MobileDbContext();
}
public FooterDao()
{
db = new MobileDbContext();
}
public UserDao()
{
db = new MobileDbContext();
}
public UsersController(MobileDbContext context)
{
_context = context;
}
public CartRepository(MobileDbContext dbContext)
{
_dbContext = dbContext;
}
public ProductCategoryDao()
{
db = new MobileDbContext();
}
public CommentRepository(MobileDbContext context) : base(context)
{
}
public ContactDao()
{
db = new MobileDbContext();
}
