private void button2_Click(object sender, EventArgs e)
{
DocsEntities docsEntities = new DocsEntities();
List <Category> categories = docsEntities.Categories.Include(c => c.Files).Include(f => f.Sequences).ToList();
categoryBindingSource.DataSource = categories;
}
private void button5_Click(object sender, EventArgs e)
{
DocsEntities docsEntities = new DocsEntities();
//avarage
// double result = docsEntities.FileVersions.AverageAsync(f => f.FileSize).Result;
//int result = docsEntities.FileVersions.Count(f => f.Extension == ".docx");
int result = docsEntities.FileVersions.Sum(f => f.FileSize);
label1.Text = result.ToString();
}
private void button4_Click(object sender, EventArgs e)
{
List <int> idInts = new List <int>()
{
3, 4, 87, 4, 12, 54
};
DocsEntities docsEntities = new DocsEntities();
List <User> users = docsEntities.Users.Where(f => idInts.Contains(f.Id)).ToList();
categoryBindingSource.DataSource = users;
}
private void button6_Click(object sender, EventArgs e)
{
Category category = new Category
{
Code = "DD2",
DelFlag = false,
Name = "Deneme Kategori"
};
DocsEntities docsEntities = new DocsEntities();
//Category add = docsEntities.Categories.Add(category);
docsEntities.Entry(category).State = EntityState.Added;
docsEntities.SaveChanges();
}
private void button3_Click(object sender, EventArgs e)
{
DocsEntities docsEntities = new DocsEntities();
//List<IGrouping<string, User>> list = docsEntities.Users.GroupBy(u => u.IpAddress).ToList();
//foreach (IGrouping<string, User> grouping in list)
//{
// string groupingKey = grouping.Key;
// foreach (User user in grouping)
// {
// }
//}
bool all = docsEntities.Users.Any(u => u.ReadOnlyUser == true);
}
private void button8_Click(object sender, EventArgs e)
{
DocsEntities docsEntities = new DocsEntities();
Category category = new Category
{
Id = 1004,
Code = "BG2",
DelFlag = false,
Name = "Blgi Yönetim Sistemi"
};
//Category category = docsEntities.Categories.FirstOrDefault(c => c.Id == 1003);
docsEntities.Entry(category).State = EntityState.Deleted;
docsEntities.SaveChanges();
}
private void button1_Click(object sender, EventArgs e)
{
// int id = Int32.Parse(textBox1.Text);
// where metodu
DocsEntities docsEntities = new DocsEntities();
User user = docsEntities.Users.SingleOrDefault(u => u.Id == 12);
// List<User> users = docsEntities.Users.Where(u => u.UserName.StartsWith(textBox1.Text) && u.Login == true).ToList();
//List<User> users = docsEntities.Users.Where(u => u.Login == true).OrderByDescending(u1 => u1.FullName).ThenByDescending(u2 => u2.IpAddress).ToList();
//var users = docsEntities.Users.Where(u => u.Login == true).Select(u => new
//{
// u.FullName,
// u.UserName
//}).ToList();
// categoryBindingSource.DataSource = users;
}
private void button7_Click(object sender, EventArgs e)
{
DocsEntities docsEntities = new DocsEntities();
//Category category = docsEntities.Categories.FirstOrDefault(c => c.Id == 1003);
//category.Name = "Bilgi Güvenliği";
//category.Code = "BG";
Category category = new Category
{
Id = 1003,
Code = "BG2",
DelFlag = false,
Name = "Blgi Yönetim Sistemi"
};
docsEntities.Entry(category).State = EntityState.Modified;
docsEntities.SaveChanges();
}