public List <User_Master> GetAll_User()
{
using (SqlConnection con = new SqlConnection(ConnectionString.GetCon()))
{
List <User_Master> lstUser = new List <User_Master>();
SqlCommand cmd = new SqlCommand("SP_GetAllUser", con);
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
User_Master temp = new User_Master();
temp.User_ID = Convert.ToInt32(dr["User_ID"]);
temp.Role_ID = Convert.ToInt32(dr["Role_ID"]);
temp.User_Name = dr["User_Name"].ToString();
temp.User_Email = dr["User_Email"].ToString();
temp.User_Password = dr["User_Password"].ToString();
lstUser.Add(temp);
}
}
return(lstUser);
}
}
public User_Master Login(string Email, string Password, int Role_ID)
{
User_Master Data = new User_Master();
using (SqlConnection con = new SqlConnection(ConnectionString.GetCon()))
{
SqlCommand cmd = new SqlCommand("SP_Login", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("User_Email", Email);
cmd.Parameters.AddWithValue("User_Password", Password);
cmd.Parameters.AddWithValue("Role_ID", Role_ID);
con.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
Data.User_ID = Convert.ToInt32(dr["User_ID"]);
Data.Role_ID = Convert.ToInt32(dr["Role_ID"]);
Data.User_Name = dr["User_Name"].ToString();
Data.User_Email = dr["User_Email"].ToString();
}
}
}
return(Data);
}
public int Create_User(User_Master User)
{
using (SqlConnection con = new SqlConnection(ConnectionString.GetCon()))
{
SqlCommand cmd = new SqlCommand("SP_CreateUser", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("Role_ID", User.Role_ID);
cmd.Parameters.AddWithValue("User_Name", User.User_Name);
cmd.Parameters.AddWithValue("User_Email", User.User_Email);
cmd.Parameters.AddWithValue("User_Password", User.User_Password);
con.Open();
int Data = cmd.ExecuteNonQuery();
return(Data);
}
}
public User_Master Details_User(int User_ID)
{
using (SqlConnection con = new SqlConnection(ConnectionString.GetCon()))
{
User_Master temp = new User_Master();
SqlCommand cmd = new SqlCommand("SP_DetailsUser", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("User_ID", User_ID);
con.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
temp.User_ID = Convert.ToInt32(dr["User_ID"]);
temp.Role_ID = Convert.ToInt32(dr["Role_ID"]);
temp.User_Name = dr["User_Name"].ToString();
temp.User_Email = dr["User_Email"].ToString();
temp.User_Password = dr["User_Password"].ToString();
}
}
return(temp);
}
}
