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_car oObject = new tbm_car();
oConn.Open();
oObject.Koneksi = oConn.Conn;
oObject.carid = Convert.ToString(gridViewData.GetFocusedRowCellValue(colCarId));
oObject.opedit = clsGlobal.strUserName;
oObject.pcedit = SystemInformation.ComputerName;
oObject.SoftDelete();
oObject = null;
gridViewData.DeleteSelectedRows();
XtraMessageBox.Show(this, "Record Successfully Deleted", clsGlobal.pstrAppName, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (NpgsqlException ex)
{
}
catch (Exception ex)
{
////clsGlobal.generateErrMessageAndSendmail(ex, false);
}
finally
{
frmMain.setLoadDialog(false, "");
}
}
}
private void doStuff()
{
try
{
using (clsConnection oConn = new clsConnection())
{
string carId = Convert.ToString(gridViewData.GetFocusedRowCellValue(colCarId));
string platnumber = Convert.ToString(gridViewData.GetFocusedRowCellValue(colPlatnumber));
string strCount = clsGlobal.getData1Field("select count(*) from tbm_car where dlt='0' and trim(lower(platnumber))=trim(lower('" + platnumber + "')) and carid <>'" + carId + "'");
if (Convert.ToInt32(strCount) == 0)
{
tbm_car oObject = new tbm_car();
oConn.Open();
oObject.Koneksi = oConn.Conn;
if (!string.IsNullOrEmpty(carId))
{
oObject.GetByPrimaryKey(carId);
}
oObject.carid = carId;
if (string.IsNullOrEmpty(carId))
{
oObject.carid = oObject.NewID();
oObject.opadd = clsGlobal.strUserName;
oObject.pcadd = SystemInformation.ComputerName;
oObject.luadd = DateTime.Now;
oObject.Insert();
}
else
{
oObject.available = status;
oObject.opedit = clsGlobal.strUserName;
oObject.pcedit = SystemInformation.ComputerName;
oObject.luedit = DateTime.Now;
oObject.Update();
}
}
else
{
}
}
}
catch (NpgsqlException ex)
{
XtraMessageBox.Show(ex.Message);
}
}
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_car oObject1 = new tbm_car();
oConn.Open();
oObject1.Koneksi = oConn.Conn;
oObject1.carid = "Example";
oObject1.platnumber = Convert.ToString(dgData.CurrentRow.Cells["platnumber"].Value.ToString());
oObject1.available = true;
oObject1.pcedit = SystemInformation.ComputerName;
oObject1.opedit = clsGlobal.strUserName;
oObject1.luedit = DateTime.Now;
oObject1.updateAv();
tbm_carrepair oObject = new tbm_carrepair();
oConn.Open();
oObject.Koneksi = oConn.Conn;
oObject.repairid = Convert.ToString(dgData.CurrentRow.Cells["repairid"].Value.ToString());
oObject.opedit = clsGlobal.strUserName;
oObject.pcedit = SystemInformation.ComputerName;
oObject.Delete();
oObject = null;
XtraMessageBox.Show(this, "Record Successfully Deleted", clsGlobal.pstrAppName, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (NpgsqlException ex)
{
}
catch (Exception ex)
{
////clsGlobal.generateErrMessageAndSendmail(ex, false);
}
finally
{
frmMain.setLoadDialog(false, "");
loadData();
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (txtBookingID.Text == "" || txtPenalty.Text == "" || txtPayment.Text == "")
{
MessageBox.Show("Please Provide All The Field", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (dgData.Rows.Count == 0)
{
MessageBox.Show("You Have No Car To be Return", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
try
{
using (clsConnection oConn = new clsConnection())
{
tbm_carreturn oObject = new tbm_carreturn();
oConn.Open();
oObject.Koneksi = oConn.Conn;
if (!string.IsNullOrEmpty(txtReturnID.Text))
{
oObject.GetByPrimaryKey(txtReturnID.Text);
}
oObject.returnid = txtReturnID.Text;
oObject.bookingid = txtBookingID.Text;
oObject.dtreturn = dateReturn.Value;
oObject.remainingpayment = Convert.ToDecimal(txtRemaining.Text);
oObject.penaltypayment = Convert.ToDecimal(txtPenalty.Text);
oObject.paymentamount = Convert.ToDecimal(txtPayment.Text);
oObject.opadd = clsGlobal.strUserName;
oObject.pcadd = SystemInformation.ComputerName;
oObject.Insert();
for (int i = 0; i < dgData.Rows.Count; i++)
{
tbm_car oObject1 = new tbm_car();
oConn.Open();
oObject1.Koneksi = oConn.Conn;
oObject1.carid = "Example";
oObject1.platnumber = dgData.Rows[i].Cells[5].Value.ToString();
oObject1.available = true;
oObject.pcedit = SystemInformation.ComputerName;
oObject.opedit = clsGlobal.strUserName;
oObject.luedit = DateTime.Now;
oObject1.updateAv();
}
clear();
MessageBox.Show("Data Submitted", "Submit", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (NpgsqlException ex)
{
}
catch (Exception ex)
{
}
finally
{
frmMain.setLoadDialog(false, "");
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
getRepairId();
if (cmbPlatnumber.Text == "")
{
MessageBox.Show("Please Provide The Car ID", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
try
{
using (clsConnection oConn = new clsConnection())
{
string strGetCarid = clsGlobal.getData1Field("select carid from tbm_car where platnumber='" + cmbPlatnumber.Text + "'");
string strCount = clsGlobal.getData1Field("select count(*) from tbm_carrepair where dlt='0' and trim(lower(carid))=trim(lower('" + strGetCarid + "')) and repairid <>'" + strRepairid + "'");
if (Convert.ToInt32(strCount) == 0)
{
tbm_carrepair oObject = new tbm_carrepair();
oConn.Open();
oObject.Koneksi = oConn.Conn;
if (!string.IsNullOrEmpty(strRepairid))
{
oObject.GetByPrimaryKey(strRepairid);
}
tbm_car oObject1 = new tbm_car();
oConn.Open();
oObject1.Koneksi = oConn.Conn;
oObject1.carid = "Example";
oObject1.platnumber = cmbPlatnumber.Text;
oObject1.available = false;
oObject1.pcedit = SystemInformation.ComputerName;
oObject1.opedit = clsGlobal.strUserName;
oObject1.luedit = DateTime.Now;
oObject1.updateAv();
oObject.repairid = strRepairid;
oObject.carid = strGetCarid;
if (oObject.carid == "")
{
XtraMessageBox.Show("Data Can't Be Null", "Warning");
}
else
{
oObject.repairid = strRepairid;
oObject.opadd = clsGlobal.strUserName;
oObject.pcadd = SystemInformation.ComputerName;
oObject.luadd = DateTime.Now;
oObject.Insert();
Clear();
loadData();
XtraMessageBox.Show(this, "Record Successfully Saved", clsGlobal.pstrAppName, MessageBoxButtons.OK, MessageBoxIcon.Information);
oObject = null;
}
}
else
{
}
}
}
catch (NpgsqlException ex)
{
}
catch (Exception ex)
{
}
}
}
private void save()
{
try
{
using (clsConnection oConn = new clsConnection())
{
#region tbm_booking
tbm_booking oObject = new tbm_booking();
oConn.Open();
oObject.Koneksi = oConn.Conn;
oObject.bookingid = txtBookingId.Text;
oObject.customerid = txtCustomerId.Text;
oObject.dateorder = Convert.ToDateTime(dtTimeOrder.EditValue.ToString());
oObject.sdatebooking = Convert.ToDateTime(dtSBooking.EditValue.ToString());
oObject.edatebooking = Convert.ToDateTime(dtEBooking.EditValue.ToString());
oObject.duration_booking = Convert.ToDecimal(seDuration.Text);
oObject.downpayment = Convert.ToDecimal(txtDP.Text);
#endregion tbm_booking
if (!string.IsNullOrEmpty(txtBookingId.Text))
{
oObject.GetByPrimaryKey(txtBookingId.Text);
}
for (int j = 0; j < 3; j++)
{
if (j == 0)
{
oObject.opadd = clsGlobal.strUserName;
oObject.pcadd = SystemInformation.ComputerName;
oObject.luadd = DateTime.Now;
oObject.Insert();
}
if (j == 1)
{
for (int i = 0; i < dataRight.Rows.Count; i++)
{
#region getCarId
string strSQL = "Select * from tbm_car where platnumber='" + dataRight.Rows[i].Cells[0].Value.ToString() + "'";
DataTable dt = oConn.GetData(strSQL);
#endregion getCarId
#region tbm_bookingDetail
tbm_bookingdetail oObject1 = new tbm_bookingdetail();
oConn.Open();
oObject1.Koneksi = oConn.Conn;
oObject1.detailid = oObject1.NewID();
oObject1.bookingid = txtBookingId.Text;
oObject1.carid = dt.Rows[0]["carid"].ToString();
oObject1.price = Convert.ToInt32(dt.Rows[0]["price"]);
oObject1.opadd = clsGlobal.strUserName;
oObject1.pcadd = SystemInformation.ComputerName;
oObject1.Insert();
#endregion tbm_bookingDetail
}
}
if (j == 2)
{
for (int i = 0; i < dataRight.Rows.Count; i++)
{
#region tbm_carid
tbm_car oObject2 = new tbm_car();
oConn.Open();
oObject2.Koneksi = oConn.Conn;
oObject2.platnumber = dataRight.Rows[i].Cells[0].Value.ToString();
oObject2.available = false;
oObject2.opedit = clsGlobal.strUserName;
oObject2.pcedit = SystemInformation.ComputerName;
oObject2.updateAv();
#endregion tbm_carid
Refresh();
XtraMessageBox.Show(this, "Record Successfully Saved", clsGlobal.pstrAppName, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
}
}
catch { }
}
private void btnSave_Click(object sender, EventArgs e)
{
if (XtraMessageBox.Show(this, "Do you want to save this data?", clsGlobal.pstrAppName, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
loadImage();
if (txtPlatnumber.Text == "" || txtPathText.Text == "" || cmbTipe.Text == "" || txtkapasitas.Value <= 1 || txtHarga.Text == "" || txtDesc.Text == "")
{
XtraMessageBox.Show("Data Can't Be Null", "Warning");
}
else
{
getTypeid();
try
{
using (clsConnection oConn = new clsConnection())
{
string strCount = clsGlobal.getData1Field("select count(*) from tbm_car where dlt='0' and trim(lower(platnumber))=trim(lower('" + txtPlatnumber.Text + "')) and carid <>'" + CarId + "'");
if (Convert.ToInt32(strCount) == 0)
{
tbm_car oObject = new tbm_car();
oConn.Open();
oObject.Koneksi = oConn.Conn;
if (!string.IsNullOrEmpty(CarId))
{
oObject.GetByPrimaryKey(CarId);
}
oObject.carid = m_carid;
oObject.platnumber = txtPlatnumber.Text;
oObject.typeid = typeid;
oObject.description = txtDesc.Text;
oObject.capacity = Convert.ToInt32(txtkapasitas.Value);
oObject.price = Convert.ToInt32(txtHarga.Text);
oObject.filepath_car = txtPathText.Text;
if (pathText == null)
{
pathText = getImage;
}
oObject.image_car = pathText;
if (string.IsNullOrEmpty(CarId))
{
oObject.carid = oObject.NewID();
oObject.available = true;
oObject.opadd = clsGlobal.strUserName;
oObject.pcadd = SystemInformation.ComputerName;
oObject.Insert();
XtraMessageBox.Show("Data Has been Inserted", clsGlobal.pstrAppName, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
oObject.opedit = clsGlobal.strUserName;
oObject.pcedit = SystemInformation.ComputerName;
oObject.Update();
XtraMessageBox.Show("Data Has been Updated", clsGlobal.pstrAppName, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
}
//catch { }
catch (NpgsqlException ex)
{
XtraMessageBox.Show(ex.Message);
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message);
}
this.Close();
clsGlobal.isClose = true;
}
}
else
{
}
}
