private void cmdDELETE_Click(object sender, EventArgs e)
{
DateTimeFormatInfo dfi = DateTimeFormatInfo.CurrentInfo;
DateTime date = GlobalVar.GetServerDate;
Calendar cal = dfi.Calendar;
int mingguKe = cal.GetWeekOfYear(date, dfi.CalendarWeekRule, dfi.FirstDayOfWeek);
if (dataGridView1.SelectedCells.Count > 0)
{
string namacustomer = dataGridView1.SelectedCells[0].OwningRow.Cells["Nama"].Value.ToString();
Guid rowID = (Guid)dataGridView1.SelectedCells[0].OwningRow.Cells["RowID"].Value;
if (MessageBox.Show(Messages.Question.AskDelete, "Anda yakin akan menghapus data ini ?", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
try
{
DataTable dtSales = FillComboBox.DBGetTargetSales(Guid.Empty, rowID);
if (dtSales.Rows.Count > 0)
{
MessageBox.Show("Terdapat keterkaitan data !");
return;
}
else
{ // pake cekDelete punya Pak Novi
if (Class.PenerimaanUang.checkDelete(rowID, "Sales") == true) // this.ceckDelete(rowID) == true -> ke Sales
{
Tools.pin(PinId.Periode.Hari, mingguKe, date, PinId.Bagian.Piutang, Convert.ToInt32(PinId.ModulId.HapusMaster), "Hapus Master.\nSudah lewat tanggal, tidak diperkenankan menghapus data ini !");
if (GlobalVar.pinResult == false)
{
return;
}
}
using (Database db = new Database())
{
DataTable dt = new DataTable();
db.Commands.Add(db.CreateCommand("usp_Sales_DELETE"));
db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, rowID));
dt = db.Commands[0].ExecuteDataTable();
}
dataGridView1.Rows.Remove(dataGridView1.SelectedCells[0].OwningRow);
MessageBox.Show("Data berhasil dihapus");
}
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
}
else
{
MessageBox.Show(Messages.Error.RowNotSelected);
}
}