} //TODO: Get this from the Assembly...
public void LogMessage(string Message)
{
using (var context = new TCContext())
{
context.LogMessage(ModuleName, Message);
}
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IHostingEnvironment env, TCContext db)
{
app.UseCors("CorsPolicy");
//app.UseCors(builder =>
// builder.AllowAnyOrigin()
// .AllowAnyHeader()
// .AllowAnyMethod()
// );
app.UseResponseCompression();
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
app.UseMvc();
app.UseSwagger();
app.UseSwaggerUI(c =>
{
c.SwaggerEndpoint("/swagger/v1/swagger.json", "TravelConnect API V1");
});
db.EnsureSeedData();
}
//protected static void LogMessage(string Milestone, string Message)
//{
// using (var context = new TCContext())
// {
// context.LogMessage(Milestone, Message);
// }
//}
// To use HTTP GET, add [WebGet] attribute. (Default ResponseFormat is WebMessageFormat.Json)
// To create an operation that returns XML,
// add [WebGet(ResponseFormat=WebMessageFormat.Xml)],
// and include the following line in the operation body:
// WebOperationContext.Current.OutgoingResponse.ContentType = "text/xml";
public DataTables <Book> GetData(int pageSize, int page, string search)
{
DataTables <Book> result = new DataTables <Book>();
try
{
//string search = ((string)HttpContext.Current.Request.Params["search[value]"]).Trim();
//string draw = HttpContext.Current.Request.Params["draw"];
//string order = HttpContext.Current.Request.Params["order[0][column]"];
//string orderDir = HttpContext.Current.Request.Params["order[0][dir]"];
//int startRec = Convert.ToInt32(HttpContext.Current.Request.Params["start"]);
//int pageSize = Convert.ToInt32(HttpContext.Current.Request.Params["length"]);
// Loading.
LogMessage("Reading data...");
var context = new TCContext();
IQueryable <Book> query = context.Books.AsNoTracking();
int totalRecords = query.Count(); // Total record count.
// Verification.
if (!string.IsNullOrEmpty(search) && !string.IsNullOrWhiteSpace(search))
{ // Apply search
query = query.Where(b => b.AlphaSort.Contains(search) ||
b.Title.Contains(search) ||
b.Author.Contains(search) ||
b.MediaFormat.Contains(search) ||
b.ISBN.Contains(search) ||
b.Location.Name.Contains(search)
);
}
query = query.OrderBy(b => b.AlphaSort);
// Sorting.
//query = SortByColumnWithOrder(order, orderDir, query);
// Filter record count.
int filteredRecords = query.Count();
// Apply pagination.
//int page = (startRec + pageSize) / pageSize;
int startRec = page * pageSize;
result.Data = query.Skip(startRec).Take(pageSize).ToList();
LogMessage($"Read {result.Data.Count:#,##0} (page #{page:#,##0}) of {(filteredRecords == totalRecords ? $"{totalRecords:#,##0}" : $"{filteredRecords:#,##0} filtered ({totalRecords:#,##0} total)")} Books.");
// Loading drop down lists. (??? )
//result.Draw = Convert.ToInt32(draw);
result.RecordsTotal = totalRecords;
result.RecordsFiltered = filteredRecords;
}
catch (Exception ex)
{
LogMessage(ex.Message);
}
//WebOperationContext.Current.OutgoingResponse.ContentType = "application/json";
return(result);
}
private static void SimpleDecalDemo()
{
using (var context = new TCContext())
{
StashRepository <Decal> repo = new StashRepository <Decal>(context);
Decal decal = (Decal)repo.FindByKeyWithImages(Guid.Parse("3e206a4d-4f27-e911-9c25-001583f52824"));
//Debug.WriteLine("[Before] Decals.ID #{0}: Reference:=\"{1}\"", decal.ID, decal.Reference);
//Debug.WriteLine("[Before] Images.ID #{0}: FileName:=\"{1}\"", decal.Images[0].ID, decal.Images[0].FileName);
decal.Reference = decal.Reference == "FTD72003" ? "FTD72003 Data changed" : "FTD72003";
//Debug.WriteLine("[After] Decals.ID #{0}: Reference:=\"{1}\"", decal.ID, decal.Reference);
//decal.Images[0].FileName = decal.Images[0].FileName == null ? "Unknown" : null;
//Debug.WriteLine("[After] Images.ID #{0}: FileName:=\"{1}\"", decal.Images[0].ID, decal.Images[0].FileName);
//repo.UpdateDisconnected(decal); //Will update but will not know original values for History updates...
context.SaveChanges();
}
}
private static void SimpleBookGraphQuery()
{
using (var context = new TCContext())
{
Book book = context.Books
.Include(b => b.Location) //Eager Loading
.FirstOrDefault(b => b.Title.StartsWith("ABC"));
//If Location is declared as Virtual EF would load the collection
//on a lazy basis without explicitly loading...
Book anotherBook = context.Books
.Include(b => b.Location) //Eager Loading
.FirstOrDefault(b => b.Title.StartsWith("Death"));
//context.Entry(anotherBook).Collection(b => b.Location).Load();
}
}
public string Create(string dbCOntext = "No DB Name Provided")
{
TCContext db = new TCContext(dbCOntext);
db.Users.Add(new Models.User() {
UserName="******",
Password="******",
UserRole="Admin"
});
db.Users.Add(new Models.User()
{
UserName = "******",
Password = "******",
UserRole = "Consultant"
});
db.SaveChanges();
return dbCOntext;
}
public ActionResult Login(LoginViewModel model)
{
List<Tenant> tenants = new List<Tenant>();
tenants.Add(new Tenant() { Id = 1, Name = "K Force", DbContext = "KforceDB", Email = "*****@*****.**" });
tenants.Add(new Tenant() { Id = 2, Name = "Sudeep Company", DbContext = "SudeepDB", Email = "*****@*****.**" });
string dbCOntext = tenants.Single(x => x.Id == model.TenantId).DbContext;
TCContext db = new TCContext(dbCOntext);
User user = db.Users.SingleOrDefault(x => x.UserName == model.UserName);
if (user != null)
{
FormsAuthentication.Initialize();
FormsAuthenticationTicket ticket = new FormsAuthenticationTicket(1,
user.UserName,
DateTime.Now,
DateTime.Now.AddMinutes(30), // value of time out property
model.IsRemember, // Value of IsPersistent property
user.UserRole,
FormsAuthentication.FormsCookiePath);
string encryptedTicket = FormsAuthentication.Encrypt(ticket);
HttpCookie cookie = new HttpCookie(FormsAuthentication.FormsCookieName, encryptedTicket);
if (ticket.IsPersistent)
{
cookie.Expires = ticket.Expiration;
}
Response.Cookies.Add(cookie);
return RedirectToAction("Index", "Home");
}
ViewData["Tenants"] = (from t in tenants
select new SelectListItem()
{
Text = t.Name,
Value = t.Id.ToString()
}).ToList();
return View(model);
}
private static void InsertDecalDemo()
{
using (var context = new TCContext())
{
var decal = new Decal
{
//ID = AutoIncrement,
OID = 35,
//RowID = Null,
//DateCreated = Null,
//DateModified = Null,
Cataloged = true,
DateInventoried = new DateTime(2005, 9, 5, 16, 5, 29),
DatePurchased = new DateTime(2005, 9, 5, 16, 5, 28),
DateVerified = new DateTime(2005, 9, 6, 17, 6, 39),
Location = context.Locations.Find(2),
Notes = "",
Price = 0,
Value = 0,
WishList = false,
Designation = "UNKNOWN",
Manufacturer = "Monogram",
Name = "Rommel's Rod™ - Tom Daniel",
Nation = "N/A",
ProductCatalog = "HobbyTown USA",
Reference = "85-4260",
Scale = "1/24",
Type = "Car"
};
context.Add(decal);
context.SaveChanges();
//decal = context.Decals.Find(1);
decal = context.Decals.Where(d => d.ID == Guid.Parse("3e206a4d-4f27-e911-9c25-001583f52824")).Include(d => d.Location).FirstOrDefault();
}
}
public UserRepository(TCContext context, IMapper mapper) : base(context, mapper)
{
}
public CommitmentRepository(TCContext tCContext, IMapper mapper) : base(tCContext, mapper)
{
}
public SabreCredentialsController(TCContext context)
{
_context = context;
}
public QuestionnaireRepository(TCContext Context, IMapper Mapper) : base(Context, Mapper)
{
}
public AssignmentRepository(TCContext Context, IMapper Mapper) : base(Context, Mapper)
{
}
public StashRepository(TCContext context)
{
_context = context;
InitContextStuff();
}
public StashRepository()
{
_context = new TCContext();
InitContextStuff();
}
public SabreConnector(TCContext _context)
{
this._context = _context;
}
public BaseRepository(TCContext Context, IMapper Mapper)
{
_Context = Context;
_Mapper = Mapper;
}
public CourseRepository(TCContext tCContext, IMapper mapper) : base(tCContext, mapper)
{
}