public int ChangePasswordOnFirstLogin(string userName, string currentPassword, string newPassword)
{
using (SqlConnection con = Connection.SqlConnectionObject)
{
SqlDataReader reader = ExecuteScoopenDB.ExecuteReader(con, ScoopenDB.spChangePasswordOnFirstLogin,
new SqlParameter()
{
ParameterName = "@Username", Value = userName
},
new SqlParameter()
{
ParameterName = "@CurrentPassword", Value = currentPassword
},
new SqlParameter()
{
ParameterName = "@NewPassword", Value = newPassword
});
if (reader.HasRows)
{
while (reader.Read())
{
return((int)reader[0]);
}
}
}
return(-1);
}
public User1 Authenticate(string username, string password)
{
User1 user = new User1();
using (SqlConnection con = Connection.SqlConnectionObject)
{
SqlDataReader reader = ExecuteScoopenDB.ExecuteReader(con, ScoopenDB.spAuthenticateUser,
new SqlParameter()
{
ParameterName = "@UserName", Value = username
},
new SqlParameter()
{
ParameterName = "@Password", Value = password
});
if (reader.HasRows)
{
while (reader.Read())
{
user.AccountLocked = (int)reader["AccountLocked"];
user.IsAuthenticated = (int)reader["Authenticated"];
user.RetryAttempts = (int)reader["RetryAttempts"];
}
}
}
return(user);
}
public int ActivateRegisteredUser(string mobile, string password, string email, string otp)
{
using (SqlConnection con = Connection.SqlConnectionObject)
{
SqlDataReader reader = ExecuteScoopenDB.ExecuteReader(con, ScoopenDB.spActivateRegisteredUser,
new SqlParameter()
{
ParameterName = "@Mobile", Value = mobile
},
new SqlParameter()
{
ParameterName = "@Password", Value = password
},
new SqlParameter()
{
ParameterName = "@Email", Value = email
},
new SqlParameter()
{
ParameterName = "@Otp", Value = otp
});
if (reader.HasRows)
{
while (reader.Read())
{
return((int)reader[0]);
}
}
}
return(-1);
}
public int RegisterAdmin(string FirstName, string LastName, string Email, string Password, string PhoneNumber, string Address, int ZipCode)
{
using (SqlConnection con = Connection.SqlConnectionObject)
{
SqlDataReader reader = ExecuteScoopenDB.ExecuteReader(con, ScoopenDB.spRegisterUser,
new SqlParameter()
{
ParameterName = "@FirstName", Value = FirstName
},
new SqlParameter()
{
ParameterName = "@LastName", Value = LastName
},
new SqlParameter()
{
ParameterName = "@Email", Value = Email
},
new SqlParameter()
{
ParameterName = "@Password", Value = Password
},
new SqlParameter()
{
ParameterName = "@PhoneNumber", Value = PhoneNumber
},
new SqlParameter()
{
ParameterName = "@Address", Value = Address
});
new SqlParameter()
{
ParameterName = "@ZipCode", Value = zipCode
};
if (reader.HasRows)
{
while (reader.Read())
{
return((int)reader[0]);
}
}
}
return(-1);
}
public void SaveOtpInDatabase(string mobile, string email, string otp)
{
using (SqlConnection con = Connection.SqlConnectionObject)
{
SqlDataReader reader = ExecuteScoopenDB.ExecuteReader(con, ScoopenDB.spSaveOtpInDatabase,
new SqlParameter()
{
ParameterName = "@Mobile", Value = mobile
},
new SqlParameter()
{
ParameterName = "@Email", Value = email
},
new SqlParameter()
{
ParameterName = "@Otp", Value = otp
});
}
}
public string GetOtpFromDatabase(string mobile, string email)
{
using (SqlConnection con = Connection.SqlConnectionObject)
{
SqlParameter otp = new SqlParameter()
{
ParameterName = "@Otp", DbType = DbType.String, Size = 6, Direction = ParameterDirection.Output
};
SqlDataReader reader = ExecuteScoopenDB.ExecuteReader(con, ScoopenDB.spGetOtpFromDatabase,
new SqlParameter()
{
ParameterName = "@Mobile", Value = mobile
},
new SqlParameter()
{
ParameterName = "@Email", Value = email
}, otp);
return(otp.Value.ToString());
}
return(string.Empty);
}
public int RegisterUser(string firstName, string lastName, string mobile, string email, string otp)
{
using (SqlConnection con = Connection.SqlConnectionObject)
{
SqlDataReader reader = ExecuteScoopenDB.ExecuteReader(con, ScoopenDB.spRegisterUser,
new SqlParameter()
{
ParameterName = "@FirstName", Value = firstName
},
new SqlParameter()
{
ParameterName = "@LastName", Value = lastName
},
new SqlParameter()
{
ParameterName = "@Mobile", Value = mobile
},
new SqlParameter()
{
ParameterName = "@Email", Value = email
},
new SqlParameter()
{
ParameterName = "@Otp", Value = otp
});
if (reader.HasRows)
{
while (reader.Read())
{
return((int)reader[0]);
}
}
}
return(-1);
}