public int registerUser(RM_UserDetailModel model)
{
con.Open();
string query = "INSERT INTO public.rm_userdetail(user_name, user_email, user_password) VALUES(@user_name,@user_email,@user_password)";
cmd = new NpgsqlCommand(query, con);
cmd.Parameters.AddWithValue("@user_name", model.user_name);
cmd.Parameters.AddWithValue("@user_email", model.user_email);
cmd.Parameters.AddWithValue("@user_password", model.user_password);
int i = 0;
try
{
i = cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
con.Close();
}
return(i);
}
public List <RM_UserDetailModel> ListAllUser()
{
con.Open();
List <RM_UserDetailModel> userList = new List <RM_UserDetailModel>();
string query = "SELECT * FROM public.rm_userdetail";
cmd = new NpgsqlCommand(query, con);
try
{
NpgsqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
var user = new RM_UserDetailModel();
user.user_id = Convert.ToInt32(dr["user_id"]);
user.user_name = dr["user_name"].ToString();
user.user_email = dr["user_email"].ToString();
user.user_password = dr["user_password"].ToString();
userList.Add(user);
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
con.Close();
}
return(userList);
}
public ActionResult RegisterUser(RM_UserDetailModel model)
{
int i = userRepo.registerUser(model);
if (i >= 1)
{
int id = userRepo.GetUserId(model.user_email);
cartRepo.registerCartUser(id);
return(RedirectToAction("SignIn"));
}
else
{
return(View());
}
}
public IHttpActionResult RegisterUser([FromBody] RM_UserDetailModel model)
{
RM_UserDetailModel detail = new RM_UserDetailModel();
detail.user_name = model.user_name;
detail.user_email = model.user_email;
detail.user_password = model.user_password;
int i = userRepo.registerUser(detail);
if (i >= 1)
{
return(Ok("Succesfully Register"));
}
else
{
return(BadRequest("Not a valid Detail/Request"));
}
}
public ActionResult SignOut(RM_UserDetailModel model)
{
FormsAuthentication.SignOut();
return(RedirectToAction("SignIn", "Home"));
}
