private bool Update(int orderID, string pymntID, string state, string amount, string description, string updatedAt) { bool isSuccess = false; int rowsAffacted = 0; StringBuilder sqliteQueryUpdate = new StringBuilder(); sqliteQueryUpdate.Append("UPDATE orders "); sqliteQueryUpdate.Append("SET "); sqliteQueryUpdate.Append("payment_id = @payment_id, "); sqliteQueryUpdate.Append("state = @state, "); sqliteQueryUpdate.Append("amount = @amount, "); sqliteQueryUpdate.Append("description = @description, "); sqliteQueryUpdate.Append("updated_at = @updated_at "); sqliteQueryUpdate.Append("WHERE "); sqliteQueryUpdate.Append("id = @id"); SQLiteDataAdapter sqliteDataAdapterUpdate = new SQLiteDataAdapter(); sqliteDataAdapterUpdate.UpdateCommand = new SQLiteCommand(); sqliteDataAdapterUpdate.UpdateCommand.Parameters.AddWithValue("@payment_id", pymntID); sqliteDataAdapterUpdate.UpdateCommand.Parameters.AddWithValue("@state", state); sqliteDataAdapterUpdate.UpdateCommand.Parameters.AddWithValue("@amount", amount); sqliteDataAdapterUpdate.UpdateCommand.Parameters.AddWithValue("@description", description); sqliteDataAdapterUpdate.UpdateCommand.Parameters.AddWithValue("@updated_at", updatedAt); sqliteDataAdapterUpdate.UpdateCommand.Parameters.AddWithValue("@id", orderID); dataAccessObject = new DataAccessLayer(); rowsAffacted = dataAccessObject.Update(sqliteQueryUpdate.ToString(), sqliteDataAdapterUpdate); if (rowsAffacted > 0) { isSuccess = true; } return isSuccess; }
private bool Update(int orderID, string pymntID, string state, string amount, string description, string updatedAt) { bool isSuccess = false; int rowsAffacted = 0; StringBuilder sqliteQueryUpdate = new StringBuilder(); sqliteQueryUpdate.Append("UPDATE orders "); sqliteQueryUpdate.Append("SET "); sqliteQueryUpdate.Append("payment_id = @payment_id, "); sqliteQueryUpdate.Append("state = @state, "); sqliteQueryUpdate.Append("amount = @amount, "); sqliteQueryUpdate.Append("description = @description, "); sqliteQueryUpdate.Append("updated_at = @updated_at "); sqliteQueryUpdate.Append("WHERE "); sqliteQueryUpdate.Append("id = @id"); SQLiteDataAdapter sqliteDataAdapterUpdate = new SQLiteDataAdapter(); sqliteDataAdapterUpdate.UpdateCommand = new SQLiteCommand(); sqliteDataAdapterUpdate.UpdateCommand.Parameters.AddWithValue("@payment_id", pymntID); sqliteDataAdapterUpdate.UpdateCommand.Parameters.AddWithValue("@state", state); sqliteDataAdapterUpdate.UpdateCommand.Parameters.AddWithValue("@amount", amount); sqliteDataAdapterUpdate.UpdateCommand.Parameters.AddWithValue("@description", description); sqliteDataAdapterUpdate.UpdateCommand.Parameters.AddWithValue("@updated_at", updatedAt); sqliteDataAdapterUpdate.UpdateCommand.Parameters.AddWithValue("@id", orderID); dataAccessObject = new DataAccessLayer(); rowsAffacted = dataAccessObject.Update(sqliteQueryUpdate.ToString(), sqliteDataAdapterUpdate); if (rowsAffacted > 0) { isSuccess = true; } return(isSuccess); }
private bool Update(string email) { bool isSuccess = false; int rowsAffacted = 0; int signInCount = 0; DataTable datTable = GetUser(email); if (datTable != null && datTable.Rows.Count > 0) { var distinctRows = from DataRow dRow in datTable.Rows where dRow.Field<string>("email") == email select new { column1 = dRow["sign_in_count"] }; if (distinctRows != null) { foreach (var row in distinctRows) { signInCount = Convert.ToInt32(row.column1.ToString()); signInCount++; break; } } StringBuilder sqliteQueryUpdate = new StringBuilder(); sqliteQueryUpdate.Append("UPDATE Users "); sqliteQueryUpdate.Append("SET "); sqliteQueryUpdate.Append("sign_in_count = @sign_in_count "); sqliteQueryUpdate.Append("WHERE "); sqliteQueryUpdate.Append("email = @email"); SQLiteDataAdapter sqliteDataAdapterUpdate = new SQLiteDataAdapter(); sqliteDataAdapterUpdate.UpdateCommand = new SQLiteCommand(); sqliteDataAdapterUpdate.UpdateCommand.Parameters.AddWithValue("@email", email); sqliteDataAdapterUpdate.UpdateCommand.Parameters.AddWithValue("@sign_in_count", signInCount); dataAccessObject = new DataAccessLayer(); rowsAffacted = dataAccessObject.Update(sqliteQueryUpdate.ToString(), sqliteDataAdapterUpdate); } if (rowsAffacted > 0) { isSuccess = true; } return isSuccess; }
private bool Update(ProfileModel model, string email) { bool isSuccess = false; int rowsAffacted = 0; var newPassword = model.NewPassword.Trim(); var confirmNewPassword = model.ConfirmPassword.Trim(); var encryptedNewPassword = Secure.Encrypt(newPassword); var signInCount = 0; var dateTimeNow = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss.FFFFF"); var currentSignInAt = dateTimeNow; var lastSignInAt = string.Empty; var signInIPAddress = string.Empty; var currentSignInIP = string.Empty; var lastSignInIP = string.Empty; var createdAt = string.Empty; var updatedAt = dateTimeNow; DataTable datTable = GetUser(email); if (datTable != null && datTable.Rows.Count > 0) { var distinctRows = from DataRow dRow in datTable.Rows where dRow.Field<string>("email") == email select new { column1 = dRow["sign_in_count"], column2 = dRow["last_sign_in_at"], column3 = dRow["last_sign_in_ip"], column4 = dRow["created_at"] }; if (distinctRows != null) { foreach (var row in distinctRows) { signInCount = Convert.ToInt32(row.column1.ToString()); signInCount++; DateTime lastSignInAtDateTime = Convert.ToDateTime(row.column2); lastSignInAt = lastSignInAtDateTime.ToString("yyyy-MM-dd hh:mm:ss.FFFFF"); lastSignInIP = Convert.ToString(row.column3); DateTime createdAtDateTime = Convert.ToDateTime(row.column4); createdAt = createdAtDateTime.ToString("yyyy-MM-dd hh:mm:ss.FFFFF"); break; } } CreditCard credCard = CreateCreditCard(model); var creditCardID = credCard.id; var creditCardDescription = credCard.number; StringBuilder sqliteQueryUpdate = new StringBuilder(); sqliteQueryUpdate.Append("UPDATE Users "); sqliteQueryUpdate.Append("SET "); sqliteQueryUpdate.Append("encrypted_password = @encrypted_password, "); sqliteQueryUpdate.Append("sign_in_count = @sign_in_count, "); sqliteQueryUpdate.Append("current_sign_in_at = @current_sign_in_at, "); sqliteQueryUpdate.Append("last_sign_in_at = @last_sign_in_at, "); sqliteQueryUpdate.Append("current_sign_in_ip = @current_sign_in_ip, "); sqliteQueryUpdate.Append("last_sign_in_ip = @last_sign_in_ip, "); sqliteQueryUpdate.Append("created_at = @created_at, "); sqliteQueryUpdate.Append("credit_card_id = @credit_card_id, "); sqliteQueryUpdate.Append("credit_card_description = @credit_card_description "); sqliteQueryUpdate.Append("WHERE "); sqliteQueryUpdate.Append("email = @email"); SQLiteDataAdapter sqliteDataAdapterUpdate = new SQLiteDataAdapter(); sqliteDataAdapterUpdate.UpdateCommand = new SQLiteCommand(); sqliteDataAdapterUpdate.UpdateCommand.Parameters.AddWithValue("@email", email); sqliteDataAdapterUpdate.UpdateCommand.Parameters.AddWithValue("@encrypted_password", encryptedNewPassword); sqliteDataAdapterUpdate.UpdateCommand.Parameters.AddWithValue("@sign_in_count", signInCount); sqliteDataAdapterUpdate.UpdateCommand.Parameters.AddWithValue("@current_sign_in_at", currentSignInAt); sqliteDataAdapterUpdate.UpdateCommand.Parameters.AddWithValue("@last_sign_in_at", lastSignInAt); sqliteDataAdapterUpdate.UpdateCommand.Parameters.AddWithValue("@current_sign_in_ip", currentSignInIP); sqliteDataAdapterUpdate.UpdateCommand.Parameters.AddWithValue("@last_sign_in_ip", lastSignInIP); sqliteDataAdapterUpdate.UpdateCommand.Parameters.AddWithValue("@created_at", createdAt); sqliteDataAdapterUpdate.UpdateCommand.Parameters.AddWithValue("@updated_at", updatedAt); sqliteDataAdapterUpdate.UpdateCommand.Parameters.AddWithValue("@credit_card_id", creditCardID); sqliteDataAdapterUpdate.UpdateCommand.Parameters.AddWithValue("@credit_card_description", creditCardDescription); dataAccessObject = new DataAccessLayer(); rowsAffacted = dataAccessObject.Update(sqliteQueryUpdate.ToString(), sqliteDataAdapterUpdate); } if (rowsAffacted > 0) { isSuccess = true; } return isSuccess; }