public void depositmoney(decimal amount, int cartNumber)
{
string query = "update BankAccounts set Balance = Balance + @currnetbalance where CardNumber=@cartNumber";
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandText = query;
sqlCommand.Parameters.AddWithValue("@currnetbalance", amount);
sqlCommand.Parameters.AddWithValue("@cartNumber", cartNumber);
DataAccesLayer dal = new DataAccesLayer();
try
{
dal.connctionOpen();
dal.queryExecution(sqlCommand);
dal.connctionClosed();
}
catch (Exception e)
{
MessageBox.Show(e.ToString());
}
MessageBox.Show("WPŁACONO " + amount.ToString() + " zł na konto");
}
public string addCustomer()
{
string query = "insert into Customers values(@name, @surname,@phone,@Addres, @personaLID)";
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandText = query;
sqlCommand.Parameters.AddWithValue("@name", this.Name);
sqlCommand.Parameters.AddWithValue("@surname", this.Surname);
sqlCommand.Parameters.AddWithValue("@phone", this.PhoneNumber);
sqlCommand.Parameters.AddWithValue("@Addres", this.Address);
sqlCommand.Parameters.AddWithValue("@personaLID", this.PersonalID);
DataAccesLayer dal = new DataAccesLayer();
try
{
dal.connctionOpen();
dal.queryExecution(sqlCommand);
dal.connctionClosed();
}
catch (Exception e)
{
return(e.ToString());
}
return("Customer Inserted");
}