public void SeedDataTuned(bool plinq = false)
{
var dbW = new DbWorker();
var tList = new List <Task>();
if (plinq)
{
for (var i = 0; i < 3; i++)
{
tList.Add(Task.Factory.StartNew(() =>
{
dbW.SeedGitUsers(standardAmount);
}));
}
Task.WaitAll(tList.ToArray());
}
else
{
var amounts = new List <int>()
{
standardAmount, standardAmount, standardAmount
};
Parallel.ForEach(amounts, new ParallelOptions()
{
MaxDegreeOfParallelism = 3
}, (x) =>
{
dbW.SeedGitUsers(x);
}
);
}
}
public void ConnectYes()
{
/// TODO: improve speed of Ping/Open Connection 327ms on my machine
var couldConnect = DbWorker.PingConnection("aw");
Assert.AreEqual(true, couldConnect);
}
public string GetUsers()
{
using (var db = new DbWorker())
{
return(db.getUsersCoordinteByRange(0));
}
}
public JsonResult Resumes(int count = 50000)
{
MemoryCache.Default.Add(new CacheItem("asd", "asd"), new CacheItemPolicy());
var dbWorker = new DbWorker();
return(Json(dbWorker.GetResumes(50000), JsonRequestBehavior.AllowGet));
}
public string Edit(HttpPostedFileBase image)
{
int PhotoId = 0;
using (var db = new DbWorker())
{
if (Request.Files.Count > 0)
{
PhotoId = db.StoreFile(Request.Files[0]);
}
}
if (Session["PhotoId"] == null)
{
Session["PhotoId"] = new List <int>(PhotoId);
}
else
{
var PhotoIdList = Session["PhotoId"] as List <int>;
if (PhotoIdList != null)
{
PhotoIdList.Add(PhotoId);
Session["PhotoId"] = PhotoIdList;
}
}
return(String.Format("File/ShowImg?strPhotoId={0}", PhotoId));
}
static void Main(string[] args)
{
Console.WriteLine("Connecting and Displaying AdventureWorks Data");
string queryString = "Select * from Person.Person";
var dbt = new DbTask("aw", queryString, MethodBase.GetCurrentMethod());
DbWorker.GetDataTable(ref dbt, delegate(DataTable p1, Exception e1)
{
// get DataTable
}
);
string queryString2 = "Select firstname,count(firstname) as howmany from Person.Person group by firstname order by howmany desc";
var dbt2 = new DbTask("aw", queryString2, MethodBase.GetCurrentMethod());
DbWorker.GetDataTable(ref dbt2, delegate(DataTable p1, Exception e1)
{
// get Datatable
}
);
Console.WriteLine("Finished Displaying Data Now!");
Console.ReadKey();
}
private void button3_Click(object sender, EventArgs e)
{
WindowsFormsApplication1.Worker w = new WindowsFormsApplication1.Worker();
DbWorker db = new DbWorker();
DataSet ds = new DataSet();
try
{
w.Id = int.Parse(textBox1.Text);
if (db.WorkerExist(w.Id) == true)
{
ds = db.getWorkerInfo(w);
textBox1.Text = ds.Tables[0].Rows[0]["WorkerId"].ToString();
textBox3.Text = ds.Tables[0].Rows[0]["FirstName"].ToString();
textBox2.Text = ds.Tables[0].Rows[0]["LastName"].ToString();
textBox4.Text = ds.Tables[0].Rows[0]["Address"].ToString();
textBox5.Text = ds.Tables[0].Rows[0]["Phone"].ToString();
textBox6.Text = ds.Tables[0].Rows[0]["BirthDate"].ToString();
}
else
{
textBox1.Text = "Worker not found ";
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void button1_Click(object sender, EventArgs e)
{
DbWorker db = new DbWorker();
try
{
if (comboBox1.SelectedIndex == 0)
{
WindowsFormsApplication1.Worker w = new WindowsFormsApplication1.Worker();
w.Id = int.Parse(textBox1.Text);
if (db.WorkerExist(w.Id) == true)
{
dataGridView1.DataSource = db.SearchWorkerById(w.Id).Tables[0];
}
}
else
{
dataGridView1.DataSource = db.SearchWorkerByName(textBox3.Text).Tables[0];
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error");
}
}
void updateBoxes()
{
DbClients dbc = new DbClients();
int ClientId = int.Parse(comboBox2.Text);
textBox6.Text = (string)dbc.GetClientInfo(ClientId).Tables[0].Rows[0]["FirstName"];
//textBox6.Text = dbc.GetClientInfo(2).Tables[0].Columns[0].Table.ToString();
//textBox7.Text=dbc.GetClientInfo(2).Tables[0].Columns[0].Table.ToString();
DbCars dbca = new DbCars();
if (comboBox4.Text != "")
{
int carId = int.Parse(comboBox4.Text);
textBox4.Text = (string)dbca.getCarInfo(carId).Tables[0].Rows[0]["Kind"];
}
DbWorker dbw = new DbWorker();
if (comboBox3.Text != "")
{
int wId = int.Parse(comboBox3.Text);
textBox7.Text = (string)dbw.getWorkerInfo(wId).Tables[0].Rows[0]["FirstName"];
}
}
public JsonResult GetUsers()
{
using (var db = new DbWorker())
{
return(Json(db.getUsersCoordinteByRange(0)));
}
}
private void button1_Click(object sender, EventArgs e)
{
DbWorker db = new DbWorker();
WindowsFormsApplication1.Worker w = new WindowsFormsApplication1.Worker();
try
{
w.Id = int.Parse(textBox1.Text);
if (db.WorkerExist(w.Id) == true)
{
DialogResult dialogResult = MessageBox.Show("Are You Sure To Delete Worker?", "Delete", MessageBoxButtons.YesNoCancel);
if (dialogResult == DialogResult.Yes)
{
db.DeleteWorker(w);
MessageBox.Show("Worker was deleted Successfully");
}
}
else
{
MessageBox.Show("Worker with similar ID was not found , try again", "Error");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error");
}
}
public async Task DataBaseSaveCurs_Ok_Test()
{
IConfiguration config = SU.GetConfiguration();
ExchangeRatesDdContext dbContext = new ExchangeRatesDdContext(config, SU.GetLogger <ExchangeRatesDdContext>());
DbWorker db = new DbWorker(config, SU.GetLogger <DbWorker>(), dbContext);
Valute saveValute = new Valute()
{
CharCode = "TEST_1",
Name = "TEST_1",
Nominal = 10,
Value = 10.1m
};
bool result = await db.StoreCurrencyAsync(new ValCurs()
{
Date = DateTime.Today.AddYears(-100), Name = "TEST_0", Valute = new List <Valute>()
{
saveValute
}
});
Assert.True(result);
IQueryable <ExchangeRates> restoreValute = dbContext.ExchangeRates.Where(valute => valute.Name == saveValute.Name &&
valute.Value == saveValute.Value &&
saveValute.Nominal == saveValute.Nominal);
Assert.True(restoreValute.Any());
dbContext.ExchangeRates.Remove(restoreValute.Single());
dbContext.SaveChanges();
}
public void Init()
{
IsInit = false;
List <CategoryModel> categories = null;
if (DbWorker.GetCategories().Count == 0)
{
categories = CategoryFactory.GetCategories().ToList();
foreach (var category in categories)
{
DbWorker.AddCategory(category);
}
}
else
{
categories = DbWorker.GetCategories();
}
foreach (var category in categories)
{
Categories.Add(new CategoryViewModel(category));
}
foreach (var cost in DbWorker.GetCosts().Take(TOTAL_COUNT_COSTS))
{
Costs.Add(new CostViewModel(cost));
}
Accounts.Initialization();
IsInit = true;
}
internal Task UpdateBalance(BalanceViewModel updateBalance)
{
return(Task.Factory.StartNew(() =>
{
updateBalance.Update();
DbWorker.UpdateBalance(updateBalance.Model);
}));
}
internal Task UpdateCategory(CategoryViewModel updateTag)
{
return(Task.Factory.StartNew(() =>
{
updateTag.Update();
DbWorker.UpdateCategory(updateTag.Model);
}));
}
public void TestScalar()
{
string queryString = "Select top 1 FirstName from Person.Person";
var dbt = new DbTask("aw", queryString, MethodBase.GetCurrentMethod());
string blah = DbWorker.ExecuteScalar <string>(ref dbt);
Assert.IsInstanceOfType(blah, typeof(string));
}
public List <GitHubResume> GetResumes()
{
var dbWorker = new DbWorker();
// simulate Service long waiting request
System.Threading.Thread.Sleep(8000);
return(dbWorker.GetResumes(10, true));
}
public ActionResult Index()
{
using (var db = new DbWorker())
{
var model = db.getModel("1");
return(View(model));
}
}
public JsonResult getUser(string userId)
{
using (var db = new DbWorker())
{
string model = db.getModel(userId);
return(Json(model));
}
}
public string GetUser(string data)
{
using (var db = new DbWorker())
{
string model = db.getModel(data);
return(model);
}
}
public void SeedData(bool wait = false)
{
if (wait)
{
System.Threading.Thread.Sleep(8000);
}
var dbW = new DbWorker();
dbW.SeedGitUsers(standardAmount * 3);
}
public List <GitHubResume> GetResumes_Tuned()
{
var result = new List <GitHubResume>();
var dbw = new DbWorker();
result = dbw.GetResumesWithContacts(true);
return(result);
}
public void TestDataTable()
{
string queryString = "Select top 20 * from Person.Person";
var dbt = new DbTask("aw", queryString, MethodBase.GetCurrentMethod());
DbWorker.GetDataTable(ref dbt, delegate(DataTable p1, Exception e1)
{
Assert.AreEqual(20, p1.Rows.Count);
}
);
}
public CSVImportModel(Dictionary <int, string> columns, List <string[]> dataList)
{
if (columns == null || columns.Count == 0 || dataList == null || dataList.Count == 0)
{
throw new ArgumetMissingException("Получены некорректные данные");
}
_columns = columns;
_dataList = dataList;
_db = new DbWorker();
}
private void button1_Click(object sender, EventArgs e)
{
string queryString = "Select top 20 * from Person.Person";
var dbt = new DbTask("aw", queryString, MethodBase.GetCurrentMethod());
DbWorker.GetDataTable(ref dbt, delegate(DataTable p1, Exception e1)
{
dgVw1.DataSource = p1;
dgVw1.Refresh();
}
);
}
public HttpResponseMessage GetAll(HttpRequestMessage requestMessage = null)
{
try
{
DbWorker db = new DbWorker();
return(requestMessage.CreateResponse(HttpStatusCode.OK, db.GetAll()));
}
catch
{
return(requestMessage.CreateResponse(HttpStatusCode.InternalServerError, "An error has been occured"));
}
}
internal Task DeleteCost(CostViewModel cost)
{
return(Task.Factory.StartNew(() =>
{
App.RunUIAsync(() =>
{
Costs.Remove(cost);
});
DbWorker.RemoveCost(cost.Model);
}));
}
internal Task AddCategory(CategoryViewModel newCategory)
{
return(Task.Factory.StartNew(() =>
{
App.RunUIAsync(() =>
{
Categories.Add(newCategory);
});
DbWorker.AddCategory(newCategory.Model);
}));
}
internal Task DeleteCategory(CategoryViewModel category)
{
return(Task.Factory.StartNew(() =>
{
App.RunUIAsync(() =>
{
Categories.Remove(category);
});
DbWorker.RemoveCategory(category.Model);
}));
}
private List <DbResult> LoadDbReports()
{
List <DbResult> results = null;
using (var db = new DbWorker())
{
var q = new DbQuery("Reports");
q.Sql = querySQL;
results = db.GetResults(q);
}
return(results);
}
