private bool Insert(int userID, string createdAt, string updatedAt)
{
bool isSuccess = false;
int rowsAffacted = 0;
StringBuilder sqliteQueryInsert = new StringBuilder();
sqliteQueryInsert.Append("INSERT INTO orders");
sqliteQueryInsert.Append("(");
sqliteQueryInsert.Append("user_id, ");
sqliteQueryInsert.Append("created_at, ");
sqliteQueryInsert.Append("updated_at ");
sqliteQueryInsert.Append(") ");
sqliteQueryInsert.Append("VALUES ");
sqliteQueryInsert.Append("(");
sqliteQueryInsert.Append("@user_id, ");
sqliteQueryInsert.Append("@created_at, ");
sqliteQueryInsert.Append("@updated_at ");
sqliteQueryInsert.Append(")");
SQLiteDataAdapter sqliteDataAdapterInsert = new SQLiteDataAdapter();
sqliteDataAdapterInsert.InsertCommand = new SQLiteCommand();
sqliteDataAdapterInsert.InsertCommand.Parameters.AddWithValue("@user_id", userID);
sqliteDataAdapterInsert.InsertCommand.Parameters.AddWithValue("@created_at", createdAt);
sqliteDataAdapterInsert.InsertCommand.Parameters.AddWithValue("@updated_at", updatedAt);
dataAccessObject = new DataAccessLayer();
rowsAffacted = dataAccessObject.Insert(sqliteQueryInsert.ToString(), sqliteDataAdapterInsert);
if (rowsAffacted > 0)
{
isSuccess = true;
}
return(isSuccess);
}
private bool Insert()
{
bool isSuccess = false;
int rowsAffacted = 0;
var email = TextBoxEmail.Text.Trim();
var password = TextBoxPassword.Text.Trim();
var passwordConfirmation = TextBoxConfirmPassword.Text.Trim();
var encryptedPassword = Secure.Encrypt(password);
var signInCount = 1;
var dateTimeNow = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss.FFFFF");
var currentSignInAt = dateTimeNow;
var lastSignInAt = dateTimeNow;
var signInIPAddress = "";
var currentSignInIP = signInIPAddress;
var lastSignInIP = signInIPAddress;
var createdAt = dateTimeNow;
var updatedAt = dateTimeNow;
CreditCard credCard = CreateCreditCard();
var creditCardID = credCard.id;
var creditCardDescription = credCard.number;
StringBuilder sqliteQueryInsert = new StringBuilder();
sqliteQueryInsert.Append("INSERT INTO users");
sqliteQueryInsert.Append("(");
sqliteQueryInsert.Append("email, ");
sqliteQueryInsert.Append("encrypted_password, ");
sqliteQueryInsert.Append("sign_in_count, ");
sqliteQueryInsert.Append("current_sign_in_at,");
sqliteQueryInsert.Append("last_sign_in_at, ");
sqliteQueryInsert.Append("current_sign_in_ip, ");
sqliteQueryInsert.Append("last_sign_in_ip, ");
sqliteQueryInsert.Append("created_at, ");
sqliteQueryInsert.Append("updated_at, ");
sqliteQueryInsert.Append("credit_card_id, ");
sqliteQueryInsert.Append("credit_card_description ");
sqliteQueryInsert.Append(") ");
sqliteQueryInsert.Append("VALUES ");
sqliteQueryInsert.Append("(");
sqliteQueryInsert.Append("@email, ");
sqliteQueryInsert.Append("@encrypted_password, ");
sqliteQueryInsert.Append("@sign_in_count, ");
sqliteQueryInsert.Append("@current_sign_in_at,");
sqliteQueryInsert.Append("@last_sign_in_at, ");
sqliteQueryInsert.Append("@current_sign_in_ip, ");
sqliteQueryInsert.Append("@last_sign_in_ip, ");
sqliteQueryInsert.Append("@created_at, ");
sqliteQueryInsert.Append("@updated_at, ");
sqliteQueryInsert.Append("@credit_card_id, ");
sqliteQueryInsert.Append("@credit_card_description ");
sqliteQueryInsert.Append(")");
SQLiteDataAdapter sqliteDataAdapterInsert = new SQLiteDataAdapter();
sqliteDataAdapterInsert.InsertCommand = new SQLiteCommand();
sqliteDataAdapterInsert.InsertCommand.Parameters.AddWithValue("@email", email);
sqliteDataAdapterInsert.InsertCommand.Parameters.AddWithValue("@encrypted_password", encryptedPassword);
sqliteDataAdapterInsert.InsertCommand.Parameters.AddWithValue("@sign_in_count", signInCount);
sqliteDataAdapterInsert.InsertCommand.Parameters.AddWithValue("@current_sign_in_at", currentSignInAt);
sqliteDataAdapterInsert.InsertCommand.Parameters.AddWithValue("@last_sign_in_at", lastSignInAt);
sqliteDataAdapterInsert.InsertCommand.Parameters.AddWithValue("@current_sign_in_ip", currentSignInIP);
sqliteDataAdapterInsert.InsertCommand.Parameters.AddWithValue("@last_sign_in_ip", lastSignInIP);
sqliteDataAdapterInsert.InsertCommand.Parameters.AddWithValue("@created_at", createdAt);
sqliteDataAdapterInsert.InsertCommand.Parameters.AddWithValue("@updated_at", updatedAt);
sqliteDataAdapterInsert.InsertCommand.Parameters.AddWithValue("@credit_card_id", creditCardID);
sqliteDataAdapterInsert.InsertCommand.Parameters.AddWithValue("@credit_card_description", creditCardDescription);
dataAccessObject = new DataAccessLayer();
rowsAffacted = dataAccessObject.Insert(sqliteQueryInsert.ToString(), sqliteDataAdapterInsert);
if (rowsAffacted > 0)
{
isSuccess = true;
}
return isSuccess;
}
private bool Insert()
{
bool isSuccess = false;
int rowsAffacted = 0;
var email = TextBoxEmail.Text.Trim();
var password = TextBoxPassword.Text.Trim();
var passwordConfirmation = TextBoxConfirmPassword.Text.Trim();
var encryptedPassword = Secure.Encrypt(password);
var signInCount = 1;
var dateTimeNow = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss.FFFFF");
var currentSignInAt = dateTimeNow;
var lastSignInAt = dateTimeNow;
var signInIPAddress = ConfigManager.Instance.GetProperty("IPAddress");
var currentSignInIP = signInIPAddress;
var lastSignInIP = signInIPAddress;
var createdAt = dateTimeNow;
var updatedAt = dateTimeNow;
CreditCard credCard = CreateCreditCard();
var creditCardID = credCard.id;
var creditCardDescription = credCard.number;
StringBuilder sqliteQueryInsert = new StringBuilder();
sqliteQueryInsert.Append("INSERT INTO users");
sqliteQueryInsert.Append("(");
sqliteQueryInsert.Append("email, ");
sqliteQueryInsert.Append("encrypted_password, ");
sqliteQueryInsert.Append("sign_in_count, ");
sqliteQueryInsert.Append("current_sign_in_at,");
sqliteQueryInsert.Append("last_sign_in_at, ");
sqliteQueryInsert.Append("current_sign_in_ip, ");
sqliteQueryInsert.Append("last_sign_in_ip, ");
sqliteQueryInsert.Append("created_at, ");
sqliteQueryInsert.Append("updated_at, ");
sqliteQueryInsert.Append("credit_card_id, ");
sqliteQueryInsert.Append("credit_card_description ");
sqliteQueryInsert.Append(") ");
sqliteQueryInsert.Append("VALUES ");
sqliteQueryInsert.Append("(");
sqliteQueryInsert.Append("@email, ");
sqliteQueryInsert.Append("@encrypted_password, ");
sqliteQueryInsert.Append("@sign_in_count, ");
sqliteQueryInsert.Append("@current_sign_in_at,");
sqliteQueryInsert.Append("@last_sign_in_at, ");
sqliteQueryInsert.Append("@current_sign_in_ip, ");
sqliteQueryInsert.Append("@last_sign_in_ip, ");
sqliteQueryInsert.Append("@created_at, ");
sqliteQueryInsert.Append("@updated_at, ");
sqliteQueryInsert.Append("@credit_card_id, ");
sqliteQueryInsert.Append("@credit_card_description ");
sqliteQueryInsert.Append(")");
SQLiteDataAdapter sqliteDataAdapterInsert = new SQLiteDataAdapter();
sqliteDataAdapterInsert.InsertCommand = new SQLiteCommand();
sqliteDataAdapterInsert.InsertCommand.Parameters.AddWithValue("@email", email);
sqliteDataAdapterInsert.InsertCommand.Parameters.AddWithValue("@encrypted_password", encryptedPassword);
sqliteDataAdapterInsert.InsertCommand.Parameters.AddWithValue("@sign_in_count", signInCount);
sqliteDataAdapterInsert.InsertCommand.Parameters.AddWithValue("@current_sign_in_at", currentSignInAt);
sqliteDataAdapterInsert.InsertCommand.Parameters.AddWithValue("@last_sign_in_at", lastSignInAt);
sqliteDataAdapterInsert.InsertCommand.Parameters.AddWithValue("@current_sign_in_ip", currentSignInIP);
sqliteDataAdapterInsert.InsertCommand.Parameters.AddWithValue("@last_sign_in_ip", lastSignInIP);
sqliteDataAdapterInsert.InsertCommand.Parameters.AddWithValue("@created_at", createdAt);
sqliteDataAdapterInsert.InsertCommand.Parameters.AddWithValue("@updated_at", updatedAt);
sqliteDataAdapterInsert.InsertCommand.Parameters.AddWithValue("@credit_card_id", creditCardID);
sqliteDataAdapterInsert.InsertCommand.Parameters.AddWithValue("@credit_card_description", creditCardDescription);
dataAccessObject = new DataAccessLayer();
rowsAffacted = dataAccessObject.Insert(sqliteQueryInsert.ToString(), sqliteDataAdapterInsert);
if (rowsAffacted > 0)
{
isSuccess = true;
}
return(isSuccess);
}
private bool Insert(int userID, string createdAt, string updatedAt)
{
bool isSuccess = false;
int rowsAffacted = 0;
StringBuilder sqliteQueryInsert = new StringBuilder();
sqliteQueryInsert.Append("INSERT INTO orders");
sqliteQueryInsert.Append("(");
sqliteQueryInsert.Append("user_id, ");
sqliteQueryInsert.Append("created_at, ");
sqliteQueryInsert.Append("updated_at ");
sqliteQueryInsert.Append(") ");
sqliteQueryInsert.Append("VALUES ");
sqliteQueryInsert.Append("(");
sqliteQueryInsert.Append("@user_id, ");
sqliteQueryInsert.Append("@created_at, ");
sqliteQueryInsert.Append("@updated_at ");
sqliteQueryInsert.Append(")");
SQLiteDataAdapter sqliteDataAdapterInsert = new SQLiteDataAdapter();
sqliteDataAdapterInsert.InsertCommand = new SQLiteCommand();
sqliteDataAdapterInsert.InsertCommand.Parameters.AddWithValue("@user_id", userID);
sqliteDataAdapterInsert.InsertCommand.Parameters.AddWithValue("@created_at", createdAt);
sqliteDataAdapterInsert.InsertCommand.Parameters.AddWithValue("@updated_at", updatedAt);
dataAccessObject = new DataAccessLayer();
rowsAffacted = dataAccessObject.Insert(sqliteQueryInsert.ToString(), sqliteDataAdapterInsert);
if (rowsAffacted > 0)
{
isSuccess = true;
}
return isSuccess;
}