private void btnDelete_Click(object sender, EventArgs e)
{
if (XtraMessageBox.Show(this, "Are you sure to delete selected record?", clsGlobal.pstrAppName, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
try
{
using (clsConnection oConn = new clsConnection())
{
frmMain.setLoadDialog(true, "Deleting data...");
tbm_customer oObject = new tbm_customer();
oConn.Open();
oObject.Koneksi = oConn.Conn;
oObject.customerid = Convert.ToString(gridViewData.GetFocusedRowCellValue(colCustomerid));
oObject.opedit = clsGlobal.strUserName;
oObject.pcedit = SystemInformation.ComputerName;
oObject.SoftDelete();
oObject = null;
gridViewData.DeleteSelectedRows();
}
}
catch (NpgsqlException ex)
{
}
catch (Exception ex)
{
////clsGlobal.generateErrMessageAndSendmail(ex, false);
}
finally
{
frmMain.setLoadDialog(false, "");
}
}
}
private void gridViewData_ValidateRow(object sender, DevExpress.XtraGrid.Views.Base.ValidateRowEventArgs e)
{
try
{
using (clsConnection oConn = new clsConnection())
{
string customerid = Convert.ToString(gridViewData.GetFocusedRowCellValue(colCustomerid));
string strCount = clsGlobal.getData1Field("select count(*) from tbm_customer where dlt='0' and trim(lower(name))=trim(lower('" + Convert.ToString(gridViewData.GetFocusedRowCellValue(colName)) + "')) and customerid <>'" + customerid + "'");
if (Convert.ToInt32(strCount) == 0)
{
tbm_customer oObject = new tbm_customer();
oConn.Open();
oObject.Koneksi = oConn.Conn;
if (!string.IsNullOrEmpty(customerid))
{
oObject.GetByPrimaryKey(customerid);
}
oObject.customerid = Convert.ToString(gridViewData.GetFocusedRowCellValue(colCustomerid));
oObject.name = Convert.ToString(gridViewData.GetFocusedRowCellValue(colName));
oObject.identity_type = Convert.ToString(gridViewData.GetFocusedRowCellValue(colIdentityType));
oObject.identity_number = Convert.ToString(gridViewData.GetFocusedRowCellValue(colIdentityNumber));
oObject.gender = Convert.ToString(gridViewData.GetFocusedRowCellValue(colGender));
oObject.phoneNumber = Convert.ToDecimal(gridViewData.GetFocusedRowCellValue(colPhoneNumber));
oObject.dob = Convert.ToDateTime(gridViewData.GetFocusedRowCellValue(colDob));
oObject.address = Convert.ToString(gridViewData.GetFocusedRowCellValue(colAddress));
if (oObject.name == "")
{
XtraMessageBox.Show("Data Can't Be Null", "Warning");
}
else
{
if (string.IsNullOrEmpty(customerid))
{
oObject.customerid = oObject.NewID();
oObject.opadd = clsGlobal.strUserName;
oObject.pcadd = SystemInformation.ComputerName;
oObject.luadd = DateTime.Now;
oObject.Insert();
gridViewData.SetFocusedRowCellValue(colCustomerid, oObject.customerid);
}
else
{
oObject.opedit = clsGlobal.strUserName;
oObject.pcedit = SystemInformation.ComputerName;
oObject.luedit = DateTime.Now;
oObject.Update();
}
oObject = null;
e.Valid = true;
}
}
else
{
e.ErrorText = "This code " + Convert.ToString(gridViewData.GetFocusedRowCellValue(colName)) + " already exists in database and cannot be filled the same value.!\n";
gridViewData.FocusedColumn = colName;
e.Valid = false;
return;
}
}
}
catch (NpgsqlException ex)
{
////clsGlobal.generateErrMessageAndSendmail(ex, false);
}
catch (Exception ex)
{
////clsGlobal.generateErrMessageAndSendmail(ex, false);
}
}
