-
Notifications
You must be signed in to change notification settings - Fork 0
/
CrudUtility.cs
121 lines (108 loc) · 4.06 KB
/
CrudUtility.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
using System;
using System.Linq;
namespace EFCore_CrudApp
{
public static class CrudUtility
{
public static void AddMember()
{
using (var dbcontext = new CrudAppDbContext())
{
Console.WriteLine("**********Enter Member details**********");
Console.WriteLine("----------------------------------------");
Console.Write("Member Name : ");
string name = Console.ReadLine();
Console.Write("Member Contact No. : ");
string phoneno = Console.ReadLine();
Console.Write("Member City : ");
string city = Console.ReadLine();
var member = new Member { Name = name, City = city, PhoneNo = phoneno };
dbcontext.Members.Add(member);
dbcontext.SaveChanges();
}
}
public static void GetMembers()
{
using (var dbcontext = new CrudAppDbContext())
{
var query = from m in dbcontext.Members orderby m.Id select m;
Console.WriteLine("List of Members....");
foreach (var m in query)
{
Console.WriteLine("id - {0}", m.Id);
Console.WriteLine("Name - {0}", m.Name);
Console.WriteLine("PhoneNo - {0}", m.PhoneNo);
Console.WriteLine("City - {0}", m.City);
}
Console.ReadKey();
}
}
public static void AddBook()
{
using (var dbcontext = new CrudAppDbContext())
{
Console.WriteLine("**********Enter Book details**********");
Console.WriteLine("--------------------------------------");
Console.Write("Book Title : ");
string title = Console.ReadLine();
Console.Write("Book Gener : ");
string gener = Console.ReadLine();
Console.WriteLine(" ");
var book = new Book { Title = title, Gener = gener };
dbcontext.Books.Add(book);
dbcontext.SaveChanges();
}
}
public static void GetBooks()
{
using (var dbcontext = new CrudAppDbContext())
{
var query = from b in dbcontext.Books orderby b.Id select b;
Console.WriteLine("**********List of Books**********");
Console.WriteLine("---------------------------------");
foreach (var b in query)
{
Console.WriteLine("Details of Book No - {0}", b.Id);
Console.WriteLine("--------------------------------- ");
Console.WriteLine("Book Title - {0}", b.Title);
Console.WriteLine("Book Gener - {0}", b.Gener);
Console.WriteLine(" ");
}
}
}
public static void DeleteBook(int bookId)
{
using (var dbcontext = new CrudAppDbContext())
{
var query = from b in dbcontext.Books orderby b.Id select b;
foreach (var b in query)
{
if (b.Id == bookId)
{
dbcontext.Remove(b);
break;
}
}
dbcontext.SaveChanges();
}
}
public static void UpdateBookDetails(int bookId, string title, string gener)
{
using (var dbcontext = new CrudAppDbContext())
{
var query = from b in dbcontext.Books orderby b.Id select b;
foreach (var b in query)
{
if (b.Id == bookId)
{
b.Title = title;
b.Gener = gener;
dbcontext.Update(b);
break;
}
}
dbcontext.SaveChanges();
}
}
}
}