public static void WriteOff(PaymentNote target) { using (var cmd = new System.Data.SQLite.SQLiteCommand(DataBase.Instance.sqlConnection)) { cmd.Parameters.Add(cmd.CreateParameter()); cmd.CommandText = "update DebitNotes set WroteOff = DateTime('now','localtime') where Id = " + target.Id; cmd.ExecuteNonQuery(); } }
private void btnConfirm_Click(object sender, EventArgs e) { if (txtCompanyName.Text == string.Empty) { txtCompanyName.Focus(); return; } //Submit all changes if (currentState == AddressBookState.Add) { using (var cmd = new System.Data.SQLite.SQLiteCommand(DataBase.Instance.sqlConnection)) { cmd.CommandText = "insert into AddressBook(CompanyName,President,Contact,Tel,Fax,Cellphone,Address1,Address2,SerialNumber,State,PhoneFormatId) values(@CompanyName,@President,@Contact,@Tel,@Fax,@Cellphone,@Address1,@Address2,@SerialNumber,@State,@PhoneFormatId); Select last_insert_rowid()"; System.Data.SQLite.SQLiteParameter[] parameters = new System.Data.SQLite.SQLiteParameter[11]; parameters[0] = new System.Data.SQLite.SQLiteParameter("CompanyName", txtCompanyName.Text); parameters[1] = new System.Data.SQLite.SQLiteParameter("President", txtPresident.Text); parameters[2] = new System.Data.SQLite.SQLiteParameter("Contact", txtContact.Text); parameters[3] = new System.Data.SQLite.SQLiteParameter("Tel", mtxtTel.Text); parameters[4] = new System.Data.SQLite.SQLiteParameter("Fax", mtxtFax.Text); parameters[5] = new System.Data.SQLite.SQLiteParameter("Cellphone", mtxtCellphone.Text); parameters[6] = new System.Data.SQLite.SQLiteParameter("Address1", txtAddress1.Text); parameters[7] = new System.Data.SQLite.SQLiteParameter("Address2", txtAddress2.Text); parameters[8] = new System.Data.SQLite.SQLiteParameter("SerialNumber", mtxtSerialNumber.Text); parameters[9] = new System.Data.SQLite.SQLiteParameter("State", cbbState.SelectedText); parameters[10] = new System.Data.SQLite.SQLiteParameter("PhoneFormatId", cbbPhoneFormat.SelectedIndex); cmd.Parameters.AddRange(parameters); long insertedId = (long)cmd.ExecuteScalar(); CurrentCompany.Id = (int)insertedId; } } else if (currentState == AddressBookState.Modify) { using (var cmd = new System.Data.SQLite.SQLiteCommand(DataBase.Instance.sqlConnection)) { cmd.Parameters.Add(cmd.CreateParameter()); cmd.CommandText = "update AddressBook set CompanyName = @CompanyName,President = @President,Contact = @Contact,Tel = @Tel,Fax = @Fax,Cellphone = @Cellphone,Address1 = @Address1,Address2 = @Address2, SerialNumber = @SerialNumber, State = @State, PhoneFormatId = @PhoneFormatId where Id = @Id"; System.Data.SQLite.SQLiteParameter[] parameters = new System.Data.SQLite.SQLiteParameter[12]; parameters[0] = new System.Data.SQLite.SQLiteParameter("CompanyName", txtCompanyName.Text); parameters[1] = new System.Data.SQLite.SQLiteParameter("President", txtPresident.Text); parameters[2] = new System.Data.SQLite.SQLiteParameter("Contact", txtContact.Text); parameters[3] = new System.Data.SQLite.SQLiteParameter("Tel", mtxtTel.Text); parameters[4] = new System.Data.SQLite.SQLiteParameter("Fax", mtxtFax.Text); parameters[5] = new System.Data.SQLite.SQLiteParameter("Cellphone", mtxtCellphone.Text); parameters[6] = new System.Data.SQLite.SQLiteParameter("Address1", txtAddress1.Text); parameters[7] = new System.Data.SQLite.SQLiteParameter("Address2", txtAddress2.Text); parameters[8] = new System.Data.SQLite.SQLiteParameter("Id", CurrentCompany.Id); parameters[9] = new System.Data.SQLite.SQLiteParameter("SerialNumber", mtxtSerialNumber.Text); parameters[10] = new System.Data.SQLite.SQLiteParameter("State", cbbState.Text); parameters[11] = new System.Data.SQLite.SQLiteParameter("PhoneFormatId", cbbPhoneFormat.SelectedIndex); cmd.Parameters.AddRange(parameters); cmd.ExecuteNonQuery(); } } currentState = AddressBookState.View; companies.ResetItem(customControl1.SelectedIndex); UpdateControls(); }
public static void Delete(PaymentNote target) { using (var cmd = new System.Data.SQLite.SQLiteCommand(DataBase.Instance.sqlConnection)) { cmd.Parameters.Add(cmd.CreateParameter()); cmd.CommandText = "delete from DebitNotes where Id = " + target.Id; cmd.ExecuteNonQuery(); } }