public static void CreateLoginTransaction(LoginMessage loginMessage)
{
tsNumberRangeModel newNumberRange = new tsNumberRangeModel()
{
login_id = (Int32.Parse(DatabaseConnection.querytsNumberRange().login_id) + 1).ToString()
};
tsLoginDetailModel tsLoginDetailModel = new tsLoginDetailModel()
{
login_id = newNumberRange.login_id,
login_account_id = loginMessage.zAccountDetailModel.account_id,
login_username = loginMessage.zAccountDetailModel.account_username,
login_time = DateTime.Now.ToString("HHmm"),
login_date = DateTime.Now.Date.ToString("ddMMyyyy"),
login_ip = GlobalFunctions.GetIPAddress(),
login_token = "null",
login_status = loginMessage.returnStatusModel.status.ToString()
};
DatabaseConnection.inserttsLoginDetail(tsLoginDetailModel);
returnStatusModel = DatabaseConnection.updatetsNumberRange(newNumberRange);
if (GlobalFunctions.isNotError(returnStatusModel.status))
{
GlobalFunctions.ShowDebug("COMPLETED");
}
}
public static void inserttsLoginDetail(tsLoginDetailModel tsLoginDetailModel)
{
//zAccountDetailModel zAccountDetailModel = new zAccountDetailModel();
//string CommandText = "SELECT * " +
// "FROM zAccount_Detail " +
// "WHERE ";
//sqlConnection.Open();
//sqlCommand = sqlConnection.CreateCommand();
//using (SQLiteCommand cmd = new SQLiteCommand(CommandText, DatabaseConnection.sqlConnection))
//{
// using (SQLiteDataReader rdr = cmd.ExecuteReader())
// {
// if (rdr.HasRows != false)
// {
// while (rdr.Read())
// {
// zAccountDetailModel.account_id = (rdr["account_id"].ToString());
// zAccountDetailModel.account_username = (rdr["account_username"].ToString());
// zAccountDetailModel.account_password = (rdr["account_password"].ToString());
// zAccountDetailModel.account_created_date = (rdr["account_created_date"].ToString());
// zAccountDetailModel.account_created_by = (rdr["account_created_by"].ToString());
// zAccountDetailModel.account_firstname = (rdr["account_firstname"].ToString());
// zAccountDetailModel.account_lastname = (rdr["account_lastname"].ToString());
// zAccountDetailModel.account_lastlogin_time = (rdr["account_lastlogin_time"].ToString());
// zAccountDetailModel.account_lastlogin_date = (rdr["account_lastlogin_date"].ToString());
// zAccountDetailModel.account_language_default = (rdr["account_language_default"].ToString());
// zAccountDetailModel.account_role_id = (rdr["account_role_id"].ToString());
// zAccountDetailModel.account_expire_date = (rdr["account_expire_date"].ToString());
// zAccountDetailModel.account_status = (rdr["account_status"].ToString());
// }
// }
// else
// {
// GlobalFunctions.ShowDebug("Incorrect");
// }
// }
//}
//sqlConnection.Close();
}
