public async Task <List <UserInformation> > GetAllUserInformations(UserLoginRequestDTO UserEmail)
{
List <UserInformation> UserInfo = new List <UserInformation>();
GetQueryByProperties getQuery = new GetQueryByProperties();
string query = getQuery.GetDetailQuery("AuthenticateUser", "LoginAuthenticate");
string newQuery = query.Replace("{useremail}", "");
using (SqlCommand cmd = new SqlCommand(newQuery, conn))
{
cmd.CommandType = CommandType.Text;
conn.Open();
using (SqlDataReader reader = await cmd.ExecuteReaderAsync())
{
while (reader.Read())
{
UserInfo.Add(
new UserInformation
{
UserId = Convert.ToInt32(reader["UserId"]),
UserEmail = reader["UserEmail"].ToString(),
FirstName = reader["firstName"].ToString(),
LastName = reader["lastName"].ToString(),
UserType = ((UserIdDeleted)Convert.ToInt16(reader["IsDeleted"])).ToString(),
UserStatus = reader["StatusCode"].ToString(),
PhoneNumber = reader["PhoneNumber"].ToString(),
}
);
}
conn.Close();
return(UserInfo);
}
}
}
public async Task <bool> InsertQuery(BusinessInsertUserRequestMessage UserDetails)
{
GetQueryByProperties getQuery = new GetQueryByProperties();
//string newQuery = "SELECT * FROM UserDetails WHERE UserEmail = '*****@*****.**' AND PhoneNumber = '3653658625' AND FirstName = 'asdf' AND LastName = 'asdfj'";
string query = getQuery.GetDetailQuery("UpdateStatus", "ChangeStatus");
using (SqlCommand cmd = new SqlCommand(query, conn))
{
//@phonenumber
cmd.CommandType = CommandType.Text;
conn.Open();
cmd.Parameters.AddWithValue("@useremail", UserDetails.UserEmail.ToString());
try
{
int result = await cmd.ExecuteNonQueryAsync();
if (result != 1)
{
conn.Close();
return(false);
}
conn.Close();
return(true);
}
catch (Exception e)
{
Debug.WriteLine(e);
conn.Close();
return(false);
}
}
}
public async Task <bool> DeleteUserDetailsAsync(string userId)
{
// updatedUserEmail updatedUserFirstName updatedUserLastName updatedUserTypeId userId
GetQueryByProperties getQuery = new GetQueryByProperties();
string query = getQuery.GetDetailQuery("DeleteUserDetail", "DeleteUserInformation");
using (SqlCommand cmd = new SqlCommand(query, conn))
{
//@phonenumber
cmd.CommandType = CommandType.Text;
conn.Open();
cmd.Parameters.AddWithValue("@userid", Convert.ToInt16(userId));
try
{
int result = await cmd.ExecuteNonQueryAsync();
if (result != 1)
{
conn.Close();
return(false);
}
conn.Close();
return(true);
}
catch (Exception)
{
return(false);
}
}
}
public async Task <bool> InsertUserDetails(BusinessInsertUserRequestMessage UserDetails)
{
// updatedUserEmail updatedUserFirstName updatedUserLastName updatedUserTypeId userId
GetQueryByProperties getQuery = new GetQueryByProperties();
string query = getQuery.GetDetailQuery("InsertOne", "InsertOneNew");
using (SqlCommand cmd = new SqlCommand(query, conn))
{
//@phonenumber
cmd.CommandType = CommandType.Text;
conn.Open();
cmd.Parameters.AddWithValue("@userid", Convert.ToInt16(UserDetails.UserId));
cmd.Parameters.AddWithValue("@userTypeId", (int)Enum.Parse(typeof(UserAccessType), UserDetails.UserStatus) + 1);
cmd.Parameters.AddWithValue("@firstname", UserDetails.FirstName.ToString());
cmd.Parameters.AddWithValue("@lastname", UserDetails.LastName.ToString());
cmd.Parameters.AddWithValue("@useremail", UserDetails.UserEmail.ToString());
cmd.Parameters.AddWithValue("@phonenumber", UserDetails.PhoneNumber.ToString());
try
{
var reader = await cmd.ExecuteReaderAsync();
var one = reader.Read();
if (one)
{
AddNewUserServices services = new AddNewUserServices(new ActiveUser());
if (await services.InsertQuery(UserDetails))
{
conn.Close();
return(true);
}
conn.Close();
return(false);
}
else
{
AddNewUserServices services = new AddNewUserServices(new AddNewUser());
if (await services.InsertQuery(UserDetails))
{
conn.Close();
return(true);
}
conn.Close();
return(false);
}
//conn.Close();
//return false;
}
catch (Exception e)
{
Debug.WriteLine(e);
conn.Close();
return(false);
}
}
}
public async Task <bool> InsertQuery(BusinessInsertUserRequestMessage UserDetails)
{
GetQueryByProperties getQuery = new GetQueryByProperties();
string query = getQuery.GetDetailQuery("InsertUserDetail", "AddUserDetail");
using (SqlCommand cmd = new SqlCommand(query, conn))
{
//@phonenumber
cmd.CommandType = CommandType.Text;
conn.Open();
cmd.Parameters.AddWithValue("@userid", Convert.ToInt16(UserDetails.UserId));
cmd.Parameters.AddWithValue("@userTypeId", (int)Enum.Parse(typeof(UserAccessType), UserDetails.UserStatus) + 1);
cmd.Parameters.AddWithValue("@firstname", UserDetails.FirstName.ToString());
cmd.Parameters.AddWithValue("@lastname", UserDetails.LastName.ToString());
cmd.Parameters.AddWithValue("@useremail", UserDetails.UserEmail.ToString());
cmd.Parameters.AddWithValue("@phonenumber", UserDetails.PhoneNumber.ToString());
try
{
var reader = await cmd.ExecuteReaderAsync();
var one = reader.Read();
if (one)
{
conn.Close();
return(true);
}
/*while (reader.Read())
* {
* Debug.WriteLine(reader[0]);
* }*/
/*if (result == -1)
* {
* conn.Close();
* return false;
* }*/
conn.Close();
return(false);
}
catch (Exception e)
{
Debug.WriteLine(e);
conn.Close();
return(false);
}
}
}
async Task <bool> IUserDetailsUpdate.UpdateUserDetailAsync(BusinessUpdateUserRequestMessage UserDetails)
{
// updatedUserEmail updatedUserFirstName updatedUserLastName updatedUserTypeId userId
GetQueryByProperties getQuery = new GetQueryByProperties();
string query = getQuery.GetDetailQuery("UpdateUserDetails", "UpdateUserInformation");
using (SqlCommand cmd = new SqlCommand(query, conn))
{
//@phonenumber
cmd.CommandType = CommandType.Text;
conn.Open();
cmd.Parameters.AddWithValue("@userId", Convert.ToInt16(UserDetails.UserId));
cmd.Parameters.AddWithValue("@updatedUserTypeId", (int)Enum.Parse(typeof(UserAccessType), UserDetails.userStatus) + 1);
cmd.Parameters.AddWithValue("@updatedUserFirstName", UserDetails.FirstName);
cmd.Parameters.AddWithValue("@updatedUserLastName", UserDetails.LastName);
cmd.Parameters.AddWithValue("@updatedUserEmail", UserDetails.UserEmail);
cmd.Parameters.AddWithValue("@phonenumber", UserDetails.PhoneNumber);
try
{
int result = await cmd.ExecuteNonQueryAsync();
if (result != 1)
{
conn.Close();
return(false);
}
conn.Close();
return(true);
}
catch (Exception e)
{
Debug.WriteLine(e);
conn.Close();
return(false);
}
}
}
