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); } }