public void EditTransaction(TransactionDetails transactionDetails)
{
MyDatabaseFileEntities db = new MyDatabaseFileEntities();
Transaction transaction = db.Transactions.Find(transactionDetails.Id);
transaction.Date = transactionDetails.Date;
transaction.ContactId = transactionDetails.ContactId;
transaction.Amount = transactionDetails.Amount;
db.SaveChanges();
}
private void SaveTransaction(object sender, EventArgs e)
{
if (MessageBox.Show("Do you want to save the new transaction?", "PFMS | Save Transaction", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
string type = radioBtnExpense.Text;
if (this.radioBtnExpense.Checked == true)
{
type = radioBtnExpense.Text;
}
else if (this.radioBtnIncome.Checked == true)
{
type = radioBtnIncome.Text;
}
this.TransactionDetailsData = new TransactionDetails();
this.TransactionDetailsData.Date = this.dateTimePicker.Value;
this.TransactionDetailsData.Type = type;
this.TransactionDetailsData.ContactId = this.currentSelectedContactId;
this.TransactionDetailsData.Amount = double.Parse(textBoxAmount.Text);
if (File.Exists(@"transactioninputdata.xml"))
{
this.dbManager.ReadXml(@"transactioninputdata.xml");
}
DBManager.TransactionHeaderRow row = this.dbManager.TransactionHeader.NewTransactionHeaderRow();
row.Date = this.TransactionDetailsData.Date;
row.Type = this.TransactionDetailsData.Type;
row.FK_ContactNo = this.TransactionDetailsData.ContactId;
row.Amount = this.TransactionDetailsData.Amount;
this.dbManager.TransactionHeader.AddTransactionHeaderRow(row);
this.dbManager.AcceptChanges();
this.dbManager.WriteXml(@"transactioninputdata.xml");
Eventt transactionModel = new Eventt();
transactionModel.SaveTransaction(this.TransactionDetailsData);
this.dbManager.Reset();
File.Delete(@"transactioninputdata.xml");
MessageBox.Show("Successfully Saved");
// this.dateTimePicker.Value = DateTime.UtcNow();
this.radioBtnExpense.Checked = true;
this.textBoxAmount.Clear();
}
}
public void SaveTransaction(TransactionDetails transactionDetails)
{
Transaction transaction = new Transaction();
transaction.Date = transactionDetails.Date;
transaction.Type = transactionDetails.Type;
transaction.ContactId = transactionDetails.ContactId;
transaction.Amount = transactionDetails.Amount;
MyDatabaseFileEntities db = new MyDatabaseFileEntities();
db.Transactions.Add(transaction);
db.SaveChanges();
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (dataGridViewTransaction.Columns[e.ColumnIndex].Name == "Edit")
{
int selectId = (int)dataGridViewTransaction.Rows[e.RowIndex].Cells[0].Value;
DateTime selectDate = (DateTime)dataGridViewTransaction.Rows[e.RowIndex].Cells[1].Value;
String selectType = (string)dataGridViewTransaction.Rows[e.RowIndex].Cells[2].Value;
String selectName = (string)dataGridViewTransaction.Rows[e.RowIndex].Cells[3].Value;
double selectAmount = (double)dataGridViewTransaction.Rows[e.RowIndex].Cells[4].Value;
this.TransactionDetailsData = new TransactionDetails();
this.TransactionDetailsData.Id = selectId;
this.TransactionDetailsData.Date = selectDate;
this.TransactionDetailsData.Type = selectType;
this.TransactionDetailsData.Amount = selectAmount;
EditTransactionForm editTransactionForm = new EditTransactionForm(TransactionDetailsData);
editTransactionForm.Activate();
editTransactionForm.ShowDialog();
GetTransactionData();
}
if (dataGridViewTransaction.Columns[e.ColumnIndex].Name == "Delete")
{
if (MessageBox.Show("Do you want to delete the selected transaction?", "PFMS | Delete Transaction", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
int selectId = (int)dataGridViewTransaction.Rows[e.RowIndex].Cells[0].Value;
Eventt transactionModel = new Eventt();
transactionModel.DeleteTransaction(selectId);
MessageBox.Show("Successfully Deleted");
transactionDetailsBindingSource.RemoveCurrent();
}
}
}
