public RegistrationViewModel()
{
using (var db = DbHelpers.GetConnection())
{
this.EditableItem = new RegistrationTable();
this.TodoItems = db.Query <RegistrationTable>("SELECT * FROM RegistrationTable ORDER BY AddDate DESC").ToList();
}
}
//--- Methods ---
public async override Task InitializeAsync(LambdaConfig config)
{
var tableName = config.ReadDynamoDBTableName("RegistrationTable");
_registrations = new RegistrationTable(new AmazonDynamoDBClient(), tableName);
_rollbarClient = new RollbarClient(
config.ReadText("RollbarReadAccessToken", defaultValue: null),
config.ReadText("RollbarWriteAccessToken", defaultValue: null),
message => LogInfo(message)
);
_rollbarProjectPrefix = config.ReadText("RollbarProjectPrefix");
}
//--- Methods ---
public override async Task InitializeAsync(LambdaConfig config)
{
_logic = new Logic(this);
_snsClient = new AmazonSimpleNotificationServiceClient();
_errorTopic = config.ReadText("ErrorReportTopic");
_usageTopic = config.ReadText("UsageReportTopic");
var tableName = config.ReadDynamoDBTableName("RegistrationTable");
var dynamoClient = new AmazonDynamoDBClient();
_registrations = new RegistrationTable(dynamoClient, tableName);
_cachedRegistrations = new Dictionary <string, OwnerMetaData>();
_rollbarClient = new RollbarClient(null, null, message => LogInfo(message));
}
public ActionResult RegistrationPage([Bind] RegistrationTable rt)
{
SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["databasestring"].ConnectionString);
try
{
if (ModelState.IsValid)
{
connection.Open();
SqlCommand command = new SqlCommand("Select * from Registration where EmpID = @empid", connection);
command.Parameters.AddWithValue("@empid", rt.EmpID);
SqlDataReader rd = command.ExecuteReader();
// Check if EmpId exists else insert data in table
if (rd.HasRows)
{
ModelState.AddModelError("EmpID", "EmpID already in use. Please use another one.");
return(View());
}
else
{
string insertquery = "Insert into Registration values(@FirstName, @LastName, @EmpID, @Username, @Password, @Email)";
using (SqlCommand cmd = new SqlCommand(insertquery, connection))
{
cmd.Parameters.AddWithValue("@FirstName", rt.FirstName);
cmd.Parameters.AddWithValue("@LastName", rt.LastName);
cmd.Parameters.AddWithValue("@EmpID", rt.EmpID);
cmd.Parameters.AddWithValue("@Username", rt.Username);
cmd.Parameters.AddWithValue("@Password", rt.Password);
cmd.Parameters.AddWithValue("@Email", rt.Email);
cmd.ExecuteNonQuery();
}
return(RedirectToAction("RegistrationSuccess"));
}
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception: " + ex.Message);
if (connection.State == ConnectionState.Open)
{
connection.Close();
}
}
return(View());
}
public HttpResponseMessage UserLogin(LoginModel model)
{
// Check Model State is valid or not
if (!ModelState.IsValid)
{
return(null);
}
using (var context = new WebApiEntities())
{
bool isValidUser = context.RegistrationTables.Any(user => user.Username.Equals(model.Username, StringComparison.OrdinalIgnoreCase) && user.Password == model.Password);
// Check whether the user is valid or not
if (isValidUser)
{
// Run Query for user selection where username are matched
var query = from user in context.RegistrationTables where user.Username == model.Username select user;
//Get first Default query Value
RegistrationTable userDetails = query.FirstOrDefault();
//create object of Generate Token Class
GenerateToken generateToken = new GenerateToken();
// Return generatedToken through CreateToken Method
string generatedToken = generateToken.CreateToken(userDetails.Username, userDetails.Password, userDetails.UserID);
// Update token value in Database
if (context.RegistrationTables.Any(user => user.UserID == userDetails.UserID))
{
RegistrationTable registration = new RegistrationTable();
registration.Token = generatedToken;
registration.UserID = userDetails.UserID;
registration.Username = userDetails.Username;
registration.Password = userDetails.Password;
// Add or Update Database context
context.RegistrationTables.AddOrUpdate(registration);
context.SaveChanges();
}
// Return generated token to client
return(Request.CreateResponse(HttpStatusCode.OK, generatedToken));
}
//If Usernama and Password are invalid then return invalid username
ModelState.AddModelError("", "Invalid username and password or Token Expired -- Please Login Again");
// return request status for create error response
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
}
//--- Methods ---
public async override Task InitializeAsync(LambdaConfig config)
{
var tableName = config.ReadDynamoDBTableName("RegistrationTable");
_registrations = new RegistrationTable(new AmazonDynamoDBClient(), tableName);
_rollbarClient = new RollbarClient(
config.ReadText("RollbarReadAccessToken", defaultValue: null),
config.ReadText("RollbarWriteAccessToken", defaultValue: null),
message => LogInfo(message)
);
_rollbarProjectPattern = config.ReadText("RollbarProjectPattern");
_coreSecretsKey = config.ReadText("CoreSecretsKey");
// set default project pattern if none is specified
if (_rollbarProjectPattern == "")
{
var rollbarProjectPrefix = config.ReadText("RollbarProjectPrefix");
_rollbarProjectPattern = $"{rollbarProjectPrefix}{{ModuleFullName}}";
}
}
