public void SaveToElasticsearchPerson()
{
using (var elasticsearchContext = new ElasticsearchContext("http://localhost:9200/", _elasticsearchMappingResolver))
{
//ElasticsearchContext.TraceProvider = new ConsoleTraceProvider();
using (var modelPerson = new ModelPerson())
{
int pointer = 0;
const int interval = 1500;
int length = modelPerson.Person.Count();
while (pointer < length)
{
_stopwatch.Start();
var collection = modelPerson.Person.OrderBy(t => t.BusinessEntityID).Skip(pointer).Take(interval).ToList();
_stopwatch.Stop();
Console.WriteLine("Time taken for select {0} persons: {1}", interval, _stopwatch.Elapsed);
_stopwatch.Reset();
foreach (var item in collection)
{
elasticsearchContext.AddUpdateDocument(item, item.BusinessEntityID);
}
_stopwatch.Start();
elasticsearchContext.SaveChanges();
_stopwatch.Stop();
Console.WriteLine("Time taken to insert {0} person documents: {1}", interval, _stopwatch.Elapsed);
_stopwatch.Reset();
pointer = pointer + interval;
Console.WriteLine("Transferred: {0} items", length);
}
}
}
}
public ActionResult DeleteConfirmed(int id)
{
ModelPerson modelPerson = db.ModelPersons.Find(id);
db.ModelPersons.Remove(modelPerson);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "ModelID,IdentityCard,FirstName,LastName,Address,PhoneNumber,Email,Nick,BirthDate,ProfileType")] ModelPerson modelPerson)
{
if (ModelState.IsValid)
{
db.Entry(modelPerson).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(modelPerson));
}
public ControlerSender(Telegram.Bot.TelegramBotClient bot)
{
modelPerson = new ModelPerson();
modelGuild = new ModelGuild();
modelTavern = new ModelTavern();
view = new AView();
viewTown = new ViewTown();
viewGuild = new ViewGuild();
this.bot = bot;
}
static void Main(string[] args)
{
var config = new ConfigurationBuilder()
.SetBasePath(Directory.GetCurrentDirectory())
.AddJsonFile(
"appsettings.json",
optional: true,
reloadOnChange: true
)
.Build();
model = new ModelPerson(config);
Menu();
}
// GET: ModelPersons/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ModelPerson modelPerson = db.ModelPersons.Find(id);
if (modelPerson == null)
{
return(HttpNotFound());
}
return(View(modelPerson));
}
public ActionResult Personal()
{
ModelPerson oPerson = new ModelPerson();
var oUser = this.model.UserProfiles.Where(x => x.UserName == User.Identity.Name).FirstOrDefault();
if (oUser != null)
{
oPerson.PersonName = oUser.FirstName + " " + oUser.LastName;
oPerson.MobileNumber = oUser.PhoneNumber;
var personal = this.model.PersonalDetails.Where(x => x.UserId == oUser.UserId).FirstOrDefault();
if (personal != null)
{
oPerson.AddressOne = personal.AddressLineOne;
oPerson.AddressTwo = personal.AddressLineTwo;
oPerson.AlternateEmail = personal.AlternateEmail;
oPerson.City = personal.City;
oPerson.Country = personal.Country;
oPerson.DateOfBirth = personal.DateOfBirth;
oPerson.ExtentionCode = personal.ExtentionCode;
if (personal.Gender == "Male")
{
oPerson.Gender = true;
}
else
{
oPerson.Gender = false;
}
oPerson.Marital = personal.MaritalStatus;
oPerson.MobileNumber = personal.MobileNumber;
if (personal.Name != null)
{
oPerson.PersonName = personal.Name;
}
if (personal.PhoneNumber != null)
{
oPerson.PhoneNumber = personal.PhoneNumber;
}
oPerson.PostalCode = personal.PostalCode;
oPerson.State = personal.State;
}
}
return(View(oPerson));
}
public ActionResult EfModelFirst()
{
int count;
SampleEfModelFirstEntities context = null;
using (MiniProfiler.Current.Step("EF Model First Stuff"))
{
try
{
using (MiniProfiler.Current.Step("Create Context"))
context = new SampleEfModelFirstEntities();
// this is not correct, as the count from this assignment is never actually used
using (MiniProfiler.Current.Step("First count"))
count = context.ModelPersons.Count();
using (MiniProfiler.Current.Step("Insertion"))
{
var p = new ModelPerson {
Name = "sam", Id = new Random().Next(10000)
};
context.ModelPersons.Add(p);
context.SaveChanges();
}
// this count is actually used.
using (MiniProfiler.Current.Step("Second count"))
count = context.ModelPersons.Count();
}
finally
{
if (context != null)
{
context.Dispose();
}
}
}
return(Content("EF Model First complete - count: " + count));
}
public void SaveToElasticsearchAddress()
{
IElasticsearchMappingResolver ElasticsearchMappingResolver = new ElasticsearchMappingResolver();
using (var ElasticsearchContext = new ElasticsearchContext("http://localhost:9200/", ElasticsearchMappingResolver))
{
//ElasticsearchContext.TraceProvider = new ConsoleTraceProvider();
using (var modelPerson = new ModelPerson())
{
int pointer = 0;
const int interval = 100;
int length = modelPerson.Address.Count();
while (pointer < length)
{
stopwatch.Start();
var collection = modelPerson.Address.OrderBy(t => t.AddressID).Skip(pointer).Take(interval).ToList <Address>();
stopwatch.Stop();
Console.WriteLine("Time taken for select {0} AddressID: {1}", interval, stopwatch.Elapsed);
stopwatch.Reset();
foreach (var item in collection)
{
ElasticsearchContext.AddUpdateDocument(item, item.AddressID);
string t = "yes";
}
stopwatch.Start();
ElasticsearchContext.SaveChanges();
stopwatch.Stop();
Console.WriteLine("Time taken to insert {0} AddressID documents: {1}", interval, stopwatch.Elapsed);
stopwatch.Reset();
pointer = pointer + interval;
Console.WriteLine("Transferred: {0} items", pointer);
}
}
}
}
public void SaveAll(object param)
{
ModelPerson.Fo();
}
public ActionResult Personal(ModelPerson oModel)
{
if (ModelState.IsValid)
{
var oUser = this.model.UserProfiles.Where(x => x.UserName == User.Identity.Name).FirstOrDefault();
if (oUser != null)
{
if (this.model.PersonalDetails.Where(x => x.UserId == oUser.UserId).Any())
{
var oPerson = this.model.PersonalDetails.Where(x => x.UserId == oUser.UserId).FirstOrDefault();
oPerson.AddressLineOne = oModel.AddressOne;
oPerson.AddressLineTwo = oModel.AddressTwo;
oPerson.AlternateEmail = oModel.AlternateEmail;
oPerson.City = oModel.City;
oPerson.Country = oModel.Country;
oPerson.DateOfBirth = oModel.DateOfBirth;
oPerson.ExtentionCode = oModel.ExtentionCode;
if (oModel.Gender)
{
oPerson.Gender = "Male";
}
else
{
oPerson.Gender = "Female";
}
oPerson.MaritalStatus = oModel.Marital;
oPerson.MobileNumber = oModel.MobileNumber;
oPerson.PhoneNumber = oModel.PhoneNumber;
oPerson.PostalCode = oModel.PostalCode;
oPerson.State = oModel.State;
oPerson.Name = oModel.PersonName;
}
else
{
PersonalDetail oPerson = new PersonalDetail();
oPerson.AddressLineOne = oModel.AddressOne;
oPerson.AddressLineTwo = oModel.AddressTwo;
oPerson.AlternateEmail = oModel.AlternateEmail;
oPerson.City = oModel.City;
oPerson.Country = oModel.Country;
oPerson.DateOfBirth = oModel.DateOfBirth;
oPerson.ExtentionCode = oModel.ExtentionCode;
if (oModel.Gender)
{
oPerson.Gender = "Male";
}
else
{
oPerson.Gender = "Female";
}
oPerson.MaritalStatus = oModel.Marital;
oPerson.MobileNumber = oModel.MobileNumber;
oPerson.PhoneNumber = oModel.PhoneNumber;
oPerson.PostalCode = oModel.PostalCode;
oPerson.State = oModel.State;
oPerson.Name = oModel.PersonName;
oPerson.UserId = oUser.UserId;
this.model.PersonalDetails.Add(oPerson);
}
}
this.model.SaveChanges();
}
return(View(oModel));
}
