private void BtDelete_Click(object sender, EventArgs e)
{
try
{
SaleRecordModel inputData = new SaleRecordModel();
inputData.Id = id.ToString();
inputData.StaffName = "";
inputData.Time = "";
inputData.Date = "";
inputData.TotalPrice = 0;
SaleReportController controller = new SaleReportController();
bool delete = controller.DeleteValue(inputData);
if (delete == true)
{
SaleReport report = new SaleReport();
report.Show();
this.Owner.Hide();
MessageBox.Show("Delete successfully");
Close();
}
else
{
MessageBox.Show("Unsuccessfully delete");
}
}catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void Btsave_Click(object sender, EventArgs e)
{
SaleRecordModel inputData = new SaleRecordModel();
inputData.Id = id.ToString();
inputData.StaffName = txtStaffName.Text;
inputData.Time = txtTime.Text;
inputData.Date = txtDate.Text;
inputData.TotalPrice = Convert.ToInt32(txtTotalPrice.Text);
SaleReportController controller = new SaleReportController();
bool update = controller.UpdateData(inputData);
if (update == true)
{
SaleReport report = new SaleReport();
report.Show();
this.Owner.Hide();
MessageBox.Show("Update successfully");
//saleReport.Show();
Close();
}
else
{
MessageBox.Show("Unsuccessfully update");
}
}
private void Display(SaleRecordModel data)
{
txtStaffName.Text = data.StaffName;
txtTime.Text = data.Time;
txtDate.Text = data.Date;
txtTotalPrice.Text = data.TotalPrice.ToString();
}
//edit
public bool UpdateData(SaleRecordModel newData)
{
SaleRecordDBModel datas = new SaleRecordDBModel();
datas.GetConnectionString(connection.server(),
connection.database(), connection.username(), connection.password());
return(datas.GetUpdateValue(newData));
}
public bool DeleteValue(SaleRecordModel deletData)
{
SaleRecordDBModel datas = new SaleRecordDBModel();
datas.GetConnectionString(connection.server(),
connection.database(), connection.username(), connection.password()); //1
return(datas.GetDeleteData(deletData));
}
public Edit(int data)
{
InitializeComponent();
SaleReportController controller = new SaleReportController();
//get the sale record by ID
SaleRecordModel saleEdit = controller.GetValueByID(data.ToString());
id = data;
Display(saleEdit);
}
