public UserEN Save(UserEN registerUser) { MySqlConnection con = CommonDAL.CreateConnection(); try { MySql.Data.MySqlClient.MySqlCommand dbcommand = null; CommonDAL.OpenConnection(con, "user_add", out dbcommand); dbcommand.Parameters.AddWithValue("param_name", registerUser.Name); dbcommand.Parameters.AddWithValue("param_emailId", registerUser.EmailID); dbcommand.Parameters.AddWithValue("param_phonenumber", registerUser.Phonenumber); dbcommand.Parameters.AddWithValue("param_password", registerUser.Password); dbcommand.Parameters.AddWithValue("param_photourl", registerUser.Photourl); dbcommand.Parameters.AddWithValue("param_usertype", registerUser.Usertype); dbcommand.Parameters.AddWithValue("param_status", registerUser.Status); object id = dbcommand.ExecuteScalar(); registerUser.ID = Convert.ToInt32(id); return registerUser; } catch (Exception e1) { throw new Exception(e1.Message); } finally { con.Close(); } }
public LoginResponse Auth(LoginRequest loginRequest) { UserEN user = new UserEN(); user.EmailID = loginRequest.UserName; user.Password = loginRequest.PassWord; user = userBiz.Login(user); LoginResponse response = new LoginResponse(); if (user != null) { response.Status = true; response.UserID = user.ID; } else { response.Status = false; response.UserID = 0; } return response; }
public UserEN Find(UserEN user) { MySqlConnection con = CommonDAL.CreateConnection(); try { MySql.Data.MySqlClient.MySqlCommand dbcommand = null; CommonDAL.OpenConnection(con, "user_login", out dbcommand); dbcommand.Parameters.AddWithValue("param_emailId", user.EmailID); DataTable dt = CommonDAL.ExecuteReader(con, dbcommand); UserEN returnuser = new UserEN(); if (dt.Rows.Count == 1) { for (int i = 0; i < dt.Rows.Count; i++) { returnuser.ID = Convert.ToInt32(dt.Rows[i]["id"].ToString()); returnuser.Name = dt.Rows[i]["name"].ToString(); returnuser.EmailID = dt.Rows[i]["emailId"].ToString(); returnuser.Phonenumber = dt.Rows[i]["phonenumber"].ToString(); returnuser.Password = dt.Rows[i]["password"].ToString(); returnuser.Photourl = dt.Rows[i]["photourl"].ToString(); returnuser.Usertype = Convert.ToInt32(dt.Rows[i]["usertype"].ToString()); returnuser.Status = Convert.ToInt32(dt.Rows[i]["status"].ToString()); returnuser.CreatedOn = Convert.ToDateTime(dt.Rows[i]["createdOn"].ToString()); } } return returnuser; } catch (Exception e1) { throw new Exception(e1.Message); } finally { con.Close(); } }
public UserEN Register(UserEN registerUser) { UserEN response = userBiz.Register(registerUser); return response; }