-
Notifications
You must be signed in to change notification settings - Fork 0
/
temp.txt
43 lines (40 loc) · 1.26 KB
/
temp.txt
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
//accessing reader data in view
@model System.Data.SqlClient.SqlDataReader
@{
System.Data.SqlClient.SqlDataReader reader = Model;
}
@while (reader.Read())
{
<p> @reader[0] <br /> @reader[1] <br /> @reader[2] </p>
}
//get user function in model in crud
//remove
public static SqlDataReader GetUsers()
{
string connectionString = @"Data Source=localhost;Initial Catalog=muz;Integrated Security=True;";
String a = "*";
string queryString = "SELECT " + a + " FROM Users";
SqlConnection connection = new SqlConnection(connectionString);
SqlCommand command = new SqlCommand(queryString, connection);
try
{
connection.Open();
SqlDataReader reader = command.ExecuteReader();
return reader;
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return null;
}
}
//code for old models
userProc uproc = new userProc();
ObjectParameter flag = new ObjectParameter("flag", typeof(int));
var value = uproc.login_user(email, password, flag);
int ret = Convert.ToInt32(flag.Value);
ret += 2;
userProc uproc = new userProc();
ObjectParameter flag = new ObjectParameter("flag", typeof(int));
var value = uproc.add_user(name, usertype, email, password, dateOfBirth, flag);
int ret = Convert.ToInt32(flag.Value);