private void btnDelete_Click(object sender, EventArgs e)
{
DialogResult Dir = MessageBox.Show("តើអ្នកចង់លុបទិន្នន័យនេះឫទេ?", "ទិន្នន័យនឹងត្រូវបានលុប", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (Dir == DialogResult.Yes)
{
Statement1 = @"DELETE FROM Expense WHERE ExpID in(";
for (int i = 0; i < DataExpense.SelectedRows.Count; i++)
{
Statement1 += "'" + DataExpense.SelectedRows[i].Cells[0].Value.ToString() + "',";
}
Statement1 = Statement1.TrimEnd(',') + ");";
MessageBox.Show(Statement1);
if (Dom_SqlClass.SQLMultiTable(new string[] { Statement1 }) == true)
{
while (DataExpense.SelectedRows.Count > 0)
{
int i = DataExpense.SelectedRows[0].Index;
DataExpense.Rows.RemoveAt(i);
if (n != 0)
{
n--;
}
}
}
}
//ID = dom_Design.GenerateID(ID.Substring(6), "Cus_00");
//txtID.Text = ID;
Clear();
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (DataExpense.SelectedRows.Count < 1)
{
if (cmType.SelectedIndex != -1 && txtName.Text != "" && txtAmount.Text != "")
{
String EID = txtID.Text;
DateTime DN = DateNote.Value;
String Type = cmType.SelectedItem.ToString();
String Name = txtName.Text;
DateTime DP = datePay.Value;
float Amount = float.Parse(txtAmount.Text);
Statement1 = @"INSERT INTO Expense Values( '" + EID + "'," + "'" + DN.ToShortDateString() + "');";
Statement2 = @"INSERT INTO ExpenseDetail Values('" + EID + "', " + "'" + cmType.ValueMember + "', " + "'" + Name + "'," + "" + ((float)Amount) + "," + "'" + DP.ToShortDateString() + "');";
MessageBox.Show(Statement1 + "\n" + Statement2);
if (Dom_SqlClass.SQLMultiTable(new string[] { Statement1, Statement2 }) == true)
{
DataExpense.Rows.Add(new object[] { EID, DN, Type, Name, DP, Amount });
n++;
}
DataExpense.ClearSelection();
ID = dom_Design.SetID(6, ID, "EXP_00");
Clear();
}
else
{
MessageBox.Show("Please Input Importan Information!");
}
}
else
{
DialogResult dialog = MessageBox.Show("You are selecting one or more rows!\nDo you want to clear selection?", "Warning", MessageBoxButtons.YesNo);
if (dialog == DialogResult.Yes)
{
DataExpense.ClearSelection();
}
}
}
private void btnEdit_Click(object sender, EventArgs e)
{
if (DataExpense.SelectedRows.Count == 1)
{
Statement1 = @"UPDATE Expense Set ExpID='" + txtID.Text + "', DateCreated='" + DateNote.Value.ToShortDateString() + "' WHERE ExpID='" + txtID.Text + "';";
Statement2 = @"UPDATE ExpenseDetail Set ExpID='" + txtID.Text + "', ExpTypeID='" + cmType.ValueMember + "', ExpDes='" + txtName.Text + "', ExpDate='" + datePay.Value.ToShortDateString() + "', Amount=" + txtAmount.Text + " WHERE ExpID='" + txtID.Text + "';";
// MessageBox.Show(Statement1 + "\n" + Statement2);
if (Dom_SqlClass.SQLMultiTable(new string[] { Statement1, Statement2 }) == true)
{
int i = DataExpense.SelectedRows[0].Index;
DataExpense.Rows[i].Cells[0].Value = txtID.Text;
DataExpense.Rows[i].Cells[1].Value = DateNote.Value;
DataExpense.Rows[i].Cells[2].Value = cmType.SelectedItem.ToString();
DataExpense.Rows[i].Cells[3].Value = txtName.Text;
DataExpense.Rows[i].Cells[4].Value = datePay.Value;
DataExpense.Rows[i].Cells[5].Value = txtAmount.Text;
}
}
else
{
MessageBox.Show("Please Select any Rows in List");
}
Clear();
}