public void invoiceUpdate()
{
connection.Open();
MySqlCommand command = new MySqlCommand();
command.Connection = connection;
command.CommandText = "Select Max(CustomerID) From tblHistory";//used the select max we can get the highest incoce num and add one as this info will e saves in the next invoice numbert
int invoice = 0;
if (command.Equals(DBNull.Value))//this check if the customer id is null then make inthe invoice equal to 1
{
invoice = 1;
}
else
{
invoice = (int)command.ExecuteScalar() + 1;//if not add one to the last invocie number as it is a new invoice
}
txtinvoice.Text = Convert.ToString(invoice);
connection.Close();
}
public string PublierProduit(publierProduit publierProduit)
{
string msg = "";
string result = ""; string result1 = ""; string result2 = "";
string query = $@"INSERT INTO [test].[dbo].[Produits]
(
[CodeProduit]
,[description]
,[photo]
,[designation]
,[prixUnitaire]
,[Monnaie])
VALUES
(
'{publierProduit.CodeProduit}'
,'{publierProduit.description}'
,'{publierProduit.Photo}'
,'{publierProduit.designation}'
,Convert(money,'{publierProduit.prixUnitaire.ToString()}'),'{publierProduit.Monnaie}')
";
string query1 = $@"INSERT INTO [test].[dbo].[Commande]
(
[CodeCommande]
,[CodeUtilisateur]
,[Sens]
,[DateCommande])
VALUES
(
'{publierProduit.CodeCommande}'
,'{publierProduit.CodeUtilisateur}'
,'{publierProduit.sens}'
,'{publierProduit.DateCommande}'
)
";
string query2 = $@"INSERT INTO [test].[dbo].[DetailCommande]
(
[CodeProduit]
,[CodeCommande]
,[QteCommandee]
,[MontantUnitaire]
,[Sens]
,[Monnaie])
VALUES
(
'{publierProduit.CodeProduit}'
,'{publierProduit.CodeCommande}'
,'{publierProduit.QteCommandee}'
,Convert(money,'{publierProduit.MontantUnitaire.ToString()}')
,'{publierProduit.sens}','{publierProduit.Monnaie}')
";
MySqlConnection sqlConnection = DbConnection.Access.getConnexion();
using (MySqlTransaction sqlTransaction = sqlConnection.BeginTransaction())
{
try
{
result = new MySqlCommand(query, sqlConnection, sqlTransaction)
.ExecuteNonQuery() > 0 ? "1" : "0";
result1 = new MySqlCommand(query1, sqlConnection, sqlTransaction)
.ExecuteNonQuery() > 0 ? "1" : "0";
result2 = new MySqlCommand(query2, sqlConnection, sqlTransaction)
.ExecuteNonQuery() > 0 ? "1" : "0";
if (result.Equals("1") && result1.Equals("1") && result2.Equals("1"))
{
sqlTransaction.Commit();
msg = "1";
}
else
{
sqlTransaction.Rollback();
msg = "0";
}
}
catch (Exception ex)
{
DbConnection.Access.sqlTransaction.Rollback();
msg = ex.Message;
}
finally
{
DbConnection.Access.setCloseConnexion();
}
}
return(msg);
}
protected override void OnCreate(Bundle savedInstanceState)
{
base.OnCreate(savedInstanceState);
connection.ConnectionString = "datasource=192.168.125.30;port=3306;Database=catalogue;Uid=rootX;Pwd=";
// Everything must be below SetContentView
SetContentView(Resource.Layout.InvoiceDisplay);
// Intent that passes all the variables from the previous Activity on to this activity and displaying them
Intent intent = Intent;
string CustomerInput = Intent.GetStringExtra("CustomerInput");
FindViewById <TextView>(Resource.Id.txtNameResult).Text = CustomerInput;
string PhoneNumber = intent.GetStringExtra("PhoneNumber");
FindViewById <TextView>(Resource.Id.txtPhoneResult).Text = PhoneNumber;
string VehicleNumber = intent.GetStringExtra("VehicleNum");
FindViewById <TextView>(Resource.Id.txtVehicleYearResult).Text = VehicleNumber;
string VehicleMake = intent.GetStringExtra("VehicleMake");
FindViewById <TextView>(Resource.Id.txtVehicleMakeResult).Text = VehicleMake;
string VehicleModel = intent.GetStringExtra("VehicleModel");
FindViewById <TextView>(Resource.Id.txtVehicleModelResult).Text = VehicleModel;
string VinNum = intent.GetStringExtra("VinNum");
FindViewById <TextView>(Resource.Id.txtVINResult).Text = VinNum;
string LicensePlate = intent.GetStringExtra("LicensePlate");
FindViewById <TextView>(Resource.Id.txtLicensePlateResult).Text = LicensePlate;
string Date = intent.GetStringExtra("Date");
FindViewById <TextView>(Resource.Id.txtDateofCompletionResult).Text = Date;
string Km = intent.GetStringExtra("KM");
FindViewById <TextView>(Resource.Id.txtKMResult).Text = Km;
// Spinner initialization and calling for the serviceslist method that adds each element into the spinner and the submit button being initialized
Spinner spinner = FindViewById <Spinner>(Resource.Id.Services);
connection.Open();
MySqlCommand command = new MySqlCommand();
command.Connection = connection;
command.CommandText = "Select Max(CustomerID) From tblHistory";//used the select max we can get the highest incoce num and add one as this info will e saves in the next invoice numbert
int invoice = 0;
if (command.Equals(DBNull.Value))//this check if the customer id is null then make inthe invoice equal to 1
{
invoice = 1;
}
else
{
invoice = (int)command.ExecuteScalar() + 1; //if not add one to the last invocie number as it is a new invoice
}
FindViewById <TextView>(Resource.Id.txtInvoiceNumberResult).Text = Convert.ToString(invoice); //this will display it in the textbox
connection.Close();
servicesList(spinner); //get the service names from database to snipper
var adapter = new ArrayAdapter <string>(this, Android.Resource.Layout.SimpleSpinnerItem, servicess);
adapter.SetDropDownViewResource(Android.Resource.Layout.SimpleSpinnerDropDownItem);
spinner.Adapter = adapter;
spinner.ItemSelected += Spinner_ItemSelected;//once something has been selected
}