private void loadCmb()
{
try
{
using (clsConnection oConn = new clsConnection())
{
NpgsqlCommand ocmd = new NpgsqlCommand();
string strSqlCategory = @"select carcategoryname as categoryname from tbm_carcategory where dlt='0'";
string strSqlBrand = @"select brandname from tbm_carbrand where dlt='0'";
DataTable dtCategory = oConn.GetData(strSqlCategory);
DataTable dtBrand = oConn.GetData(strSqlBrand);
foreach (DataRow row in dtCategory.Rows)
{
ricmbCategory.Items.Add(row["categoryname"]);
}
foreach (DataRow row in dtBrand.Rows)
{
ricmbBrand.Items.Add(row["brandname"]);
}
}
}
catch
{
}
}
private void loadCmb()
{
try
{
using (clsConnection oConn = new clsConnection())
{
string strSql = @"select a.carid, a.platnumber,a.typeid,a.filepath_car,a.passengercapacity,a.price,a.description,
a.statusavailable as available,
b.typeid,b.carcategoryid as categoryid, b.carbrandid,b.typename,
c.carcategoryid as categoryid,c.carcategoryname as categoryname,
d.carbrandid as brandids,d.brandname
from tbm_car a
left join tbm_cartype b on b.typeid = a.typeid and b.dlt='0'
left join tbm_carcategory c on c.carcategoryid = b.carcategoryid and c.dlt='0'
left join tbm_carbrand d on d.carbrandid = b.carbrandid and d.dlt='0'
where b.dlt ='0' a.typeid='" + Convert.ToString(gridViewData.GetFocusedRowCellValue(colTypeid)) + "' order by a.typeid;";
DataTable dtData = oConn.GetData(strSql);
string strTypename = @"select typename from tbm_cartype where dlt='0' ";
DataTable dtType = oConn.GetData(strTypename);
foreach (DataRow row in dtType.Rows)
{
ricmbCarType.Items.Add(row["typename"]);
}
}
}
catch
{
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
try
{
using (clsConnection oConn = new clsConnection())
{
NpgsqlCommand ocmd = new NpgsqlCommand();
frmMain.setLoadDialog(true, "Loading data...");
string strSql1 = @"select a.name,a.identity_number,b.down_payment from tbm_customer a inner join tbm_booking b on b.customerid=a.customerid and b.dlt='0' where b.bookingid='" + txtBookingID.Text + "'";
DataTable dtData = oConn.GetData(strSql1);
string strSql2 = @"select a.detailid,a.carid,a.price,b.bookingid,b.edatebooking,c.platnumber,d.typename from tbm_bookingdetail a
INNER join tbm_booking b on b.bookingid = a.bookingid and b.dlt='0'
INNER join tbm_car c on c.carid = a.carid and c.dlt='0'
INNER join tbm_cartype d on d.typeid = c.typeid and d.dlt='0'
where b.bookingid ='" + txtBookingID.Text + "' AND NOT EXISTS(Select bookingid from tbm_carreturn where tbm_carreturn.bookingid = b.bookingid) ORDER BY c.carid ";
DataTable dtData2 = oConn.GetData(strSql2);
if (dtData.Rows.Count == 0)
{
MessageBox.Show("Data Not Found From This BookingID", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
txtPenalty.Enabled = true;
dgData.DataSource = dtData2;
dtEdateBooking = Convert.ToDateTime(dtData2.Rows[0]["edatebooking"].ToString());
txtName.Text = dtData.Rows[0]["name"].ToString();
txtIdentity.Text = dtData.Rows[0]["identity_number"].ToString();
int sum = 0;
for (int i = 0; i < dtData.Rows.Count; i++)
{
sum += Convert.ToInt32(dgData.Rows[i].Cells["price"].Value);
}
txtTotal.Text = sum.ToString();
txtDP.Text = (Convert.ToInt32(txtTotal.Text) / 2).ToString();
txtRemaining.Text = (Convert.ToInt32(txtTotal.Text) - Convert.ToInt32(txtDP.Text)).ToString();
getPenaltyAmount();
}
if (dtData2.Rows.Count == 0)
{
MessageBox.Show("All Car Has Been Returned", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
catch (NpgsqlException ex)
{
}
catch (Exception ex)
{
}
finally
{
frmMain.setLoadDialog(false, "");
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
using (clsConnection oConn = new clsConnection())
{
NpgsqlCommand ocmd = new NpgsqlCommand();
frmMain.setLoadDialog(true, "Loading data...");
string strSql = @"select returnid,bookingid,dtreturn,remainingpayment,penaltypayment,paymentamount from tbm_carreturn where dlt='0' and returnid ='" + textBox1.Text + "'";
DataTable dtData = oConn.GetData(strSql);
dgData.DataSource = dtData;
int sum = 0;
for (int i = 0; i < dgData.Rows.Count; i++)
{
sum += Convert.ToInt32(dgData.Rows[i].Cells[5].Value);
}
label6.Text = sum.ToString();
if (dtData.Rows.Count == 0)
{
MessageBox.Show("Data Not Found", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
catch (NpgsqlException ex)
{
}
catch (Exception ex)
{
}
finally
{
frmMain.setLoadDialog(false, "");
}
}
private void loadData()
{
try
{
using (clsConnection oConn = new clsConnection())
{
NpgsqlCommand ocmd = new NpgsqlCommand();
frmMain.setLoadDialog(true, "Loading data...");
string strSql = @"select returnid,bookingid,dtreturn,remainingpayment,penaltypayment,paymentamount from tbm_carreturn where dlt='0'";
DataTable dtData = oConn.GetData(strSql);
dgData.DataSource = dtData;
int sum = 0;
for (int i = 0; i < dgData.Rows.Count; i++)
{
sum += Convert.ToInt32(dgData.Rows[i].Cells[5].Value);
}
label6.Text = sum.ToString();
}
}
catch (NpgsqlException ex)
{
}
catch (Exception ex)
{
}
finally
{
frmMain.setLoadDialog(false, "");
}
}
private void doStuff()
{
try
{
using (clsConnection oConn = new clsConnection())
{
string typename = cmbTipe.Text;
if (cmbTipe.Text != null)
{
string getTypeid = @"select a.typeid, a.carcategoryid as categoryid,a.carbrandid as brandid, a.typename,
b.carcategoryid as categoryids,b.carcategoryname as categoryname,
c.carbrandid as brandids, c.brandname
from tbm_cartype a
left join tbm_carcategory b on b.carcategoryid = a.carcategoryid and b.dlt='0'
left join tbm_carbrand c on c.carbrandid = a.carbrandid and c.dlt='0'
where a.dlt ='0' and a.typename='" + typename + "'";
DataTable dtData = oConn.GetData(getTypeid);
foreach (DataRow row in dtData.Rows)
{
txtKategori.Text = row["categoryname"].ToString();
txtBrand.Text = row["brandname"].ToString();
}
}
}
}
catch (NpgsqlException ex)
{
////clsGlobal.generateErrMessageAndSendmail(ex, false);
}
catch (Exception ex)
{
////clsGlobal.generateErrMessageAndSendmail(ex, false);
}
}
public void loadImage()
{
try
{
using (clsConnection oConn = new clsConnection())
{
NpgsqlCommand ocmd = new NpgsqlCommand();
string strSql = @"select * from tbm_car where carid ='" + CarId + "'";
DataTable dtData = oConn.GetData(strSql);
foreach (DataRow row in dtData.Rows)
{
m_imagestring = row["imagename"].ToString();
}
}
}
catch (NpgsqlException ex)
{
////clsGlobal.generateErrMessageAndSendmail(ex, false);
}
catch (Exception ex)
{
////clsGlobal.generateErrMessageAndSendmail(ex, false);
}
finally
{
frmMain.setLoadDialog(false, "");
}
}
private void getTypeid()
{
try
{
using (clsConnection oConn = new clsConnection())
{
NpgsqlCommand ocmd = new NpgsqlCommand();
string getTypeid = @"select a.typeid, a.carcategoryid as categoryid,a.carbrandid as brandid, a.typename,
b.carcategoryid as categoryids,b.carcategoryname as categoryname,
c.carbrandid as brandids, c.brandname
from tbm_cartype a
left join tbm_carcategory b on b.carcategoryid = a.carcategoryid and b.dlt='0'
left join tbm_carbrand c on c.carbrandid = a.carbrandid and c.dlt='0'
where a.dlt ='0' and a.typename='" + cmbTipe.Text + "'";
DataTable dtType = oConn.GetData(getTypeid);
foreach (DataRow row in dtType.Rows)
{
typeid = Convert.ToString(row["typeid"]);
}
//foreach (DataRow row in dtBrand.Rows)
//{
// ricmbBrand.Items.Add(row["brandname"]);
//}
}
}
catch
{
}
}
public void loadData()
{
try
{
using (clsConnection oConn = new clsConnection())
{
NpgsqlCommand ocmd = new NpgsqlCommand();
frmMain.setLoadDialog(true, "Loading data...");
string strSql = @"select carbrandid as brandid,
brandname
from tbm_carbrand
where dlt='0'";
DataTable dtData = oConn.GetData(strSql);
dgData.DataSource = dtData;
}
}
catch (NpgsqlException ex)
{
////clsGlobal.generateErrMessageAndSendmail(ex, false);
}
catch (Exception ex)
{
////clsGlobal.generateErrMessageAndSendmail(ex, false);
}
finally
{
frmMain.setLoadDialog(false, "");
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
try
{
using (clsConnection oConn = new clsConnection())
{
NpgsqlCommand ocmd = new NpgsqlCommand();
frmMain.setLoadDialog(true, "Loading data...");
string strSql = @"select * from tbm_customer where identity_number='" + txtIdentity_Number.Text + "'";
DataTable dtData = oConn.GetData(strSql);
if (dtData.Rows.Count == 0)
{
MessageBox.Show("Error : Customer Data not Found", clsGlobal.pstrAppName, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
foreach (DataRow row in dtData.Rows)
{
txtCustomerId.Text = row["customerid"].ToString();
txtCustomerName.Text = row["name"].ToString();
}
}
}
}
catch (NpgsqlException ex)
{
}
catch (Exception ex)
{
}
finally
{
frmMain.setLoadDialog(false, "");
}
}
public void loadData()
{
try
{
clsEncryption oEncryption = new clsEncryption();
using (clsConnection oConn = new clsConnection())
{
NpgsqlCommand ocmd = new NpgsqlCommand();
frmMain.setLoadDialog(true, "Loading data...");
string strSql = @"select userid, username, password,fullname,email,groupusers,active
from tbm_users
where dlt='0'
order by groupusers";
DataTable dtData = oConn.GetData(strSql);
dgData.DataSource = dtData;
}
}
catch (NpgsqlException ex)
{
////clsGlobal.generateErrMessageAndSendmail(ex, false);
}
catch (Exception ex)
{
////clsGlobal.generateErrMessageAndSendmail(ex, false);
}
finally
{
frmMain.setLoadDialog(false, "");
}
loadGroupUsers();
}
public void loadData()
{
try
{
using (clsConnection oConn = new clsConnection())
{
NpgsqlCommand ocmd = new NpgsqlCommand();
frmMain.setLoadDialog(true, "Loading data...");
string strSql = @"select * from tbm_customer where dlt=false";
DataTable dtData = oConn.GetData(strSql);
dgData.DataSource = dtData;
foreach (DataRow row in dtData.Rows)
{
}
//gridViewData.Columns[1].ColumnEdit = ricmbCarType;
}
}
catch (NpgsqlException ex)
{
}
catch (Exception ex)
{
}
finally
{
frmMain.setLoadDialog(false, "");
}
LoadCmb();
}
private void loadData()
{
try
{
using (clsConnection oConn = new clsConnection())
{
NpgsqlCommand ocmd = new NpgsqlCommand();
frmMain.setLoadDialog(true, "Loading data...");
string strSql = @"select * from tbm_booking where dlt='0'";
DataTable dtData = oConn.GetData(strSql);
dgData.DataSource = dtData;
label8.Text = dtData.Rows.Count.ToString();
}
}
catch (NpgsqlException ex)
{
}
catch (Exception ex)
{
}
finally
{
frmMain.setLoadDialog(false, "");
}
}
private void button2_Click(object sender, EventArgs e)
{
try
{
using (clsConnection oConn = new clsConnection())
{
NpgsqlCommand ocmd = new NpgsqlCommand();
frmMain.setLoadDialog(true, "Loading data...");
string strSql = @"select * from tbm_booking where dlt='0' and date_order between'" + dateStart.Value + "'And'" + dateEnd.Value + "'";
DataTable dtData = oConn.GetData(strSql);
dgData.DataSource = dtData;
label8.Text = dtData.Rows.Count.ToString();
if (dtData.Rows.Count == 0)
{
MessageBox.Show("Data Not Found", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
catch (NpgsqlException ex)
{
}
catch (Exception ex)
{
}
finally
{
frmMain.setLoadDialog(false, "");
}
}
private void dgData_Click(object sender, EventArgs e)
{
try
{
using (clsConnection oConn = new clsConnection())
{
NpgsqlCommand ocmd = new NpgsqlCommand();
frmMain.setLoadDialog(true, "Loading data...");
string strSql = @"select a.detailid,a.carid,a.price,b.bookingid,b.edatebooking,c.platnumber,d.typename from tbm_bookingdetail a
INNER join tbm_booking b on b.bookingid = a.bookingid and b.dlt='0'
INNER join tbm_car c on c.carid = a.carid and c.dlt='0'
INNER join tbm_cartype d on d.typeid = c.typeid and d.dlt='0'
where b.bookingid ='" + dgData.CurrentRow.Cells[0].Value.ToString() + "' AND NOT EXISTS(Select bookingid from tbm_carreturn where tbm_carreturn.bookingid = b.bookingid) ORDER BY c.carid";
DataTable dtData = oConn.GetData(strSql);
dgBawah.DataSource = dtData;
label9.Text = dgBawah.Rows.Count.ToString();
}
}
catch (NpgsqlException ex)
{
}
catch (Exception ex)
{
}
finally
{
frmMain.setLoadDialog(false, "");
}
}
public void loadData()
{
try
{
using (clsConnection oConn = new clsConnection())
{
NpgsqlCommand ocmd = new NpgsqlCommand();
frmMain.setLoadDialog(true, "Loading data...");
string strSql = @"select a.platnumber,b.typename,a.price from tbm_car a left join tbm_cartype b on b.typeid=a.typeid and b.dlt='0' where a.statusavailable=true and not exists(select carid from tbm_carrepair where tbm_carrepair.carid = a.carid)";
DataTable dtData = oConn.GetData(strSql);
//dataLeft.DataSource = dtData;
foreach (DataRow row in dtData.Rows)
{
dataLeft.Rows.Add(row["platnumber"].ToString(), row["typename"].ToString(), row["price"]);
}
//gridViewData.Columns[1].ColumnEdit = ricmbCarType;
}
}
catch (NpgsqlException ex)
{
}
catch (Exception ex)
{
}
finally
{
frmMain.setLoadDialog(false, "");
}
}
private void btnNew_Click(object sender, EventArgs e)
{
try
{
using (clsConnection oConn = new clsConnection())
{
NpgsqlCommand ocmd = new NpgsqlCommand();
frmMain.setLoadDialog(true, "Loading data...");
string strSql = @"select * from tbm_carreturn where dlt=false";
DataTable dtData = oConn.GetData(strSql);
//dgData.DataSource = dtData;
if (dtData.Rows.Count == 0)
{
int bookingId = 1;
txtReturnID.Text = clsGlobal.pstrservercode + "0" + bookingId++;
}
else
{
foreach (DataRow row in dtData.Rows)
{
int BookingId = Convert.ToInt32(row["returnid"].ToString().Substring(3, 2));
int IncBookingId = BookingId++;
string strBookingId = Convert.ToString(BookingId++);
string finalid = clsGlobal.pstrservercode + "0" + strBookingId;
txtReturnID.Text = finalid;
}
}
}
}
catch (NpgsqlException ex)
{
}
catch (Exception ex)
{
}
finally
{
frmMain.setLoadDialog(false, "");
}
txtReturnID.Enabled = false;
txtBookingID.Enabled = true;
btnSearch.Enabled = true;
txtName.Enabled = false;
txtIdentity.Enabled = false;
dateReturn.Enabled = true;
txtTotal.Enabled = false;
txtDP.Enabled = false;
txtRemaining.Enabled = false;
txtPenalty.Enabled = false;
txtPayment.Enabled = false;
btnCancel.Enabled = true;
btnSave.Enabled = true;
btnNew.Enabled = false;
}
private void loadData()
{
try
{
using (clsConnection oConn = new clsConnection())
{
NpgsqlCommand ocmd = new NpgsqlCommand();
string strSql = @"select a.carid, a.platnumber,a.typeid,a.filepath_car,a.imagename,a.passengercapacity,a.price,a.description,
a.statusavailable,
b.typeid,b.carcategoryid as categoryid, b.carbrandid,b.typename as typename,
c.carcategoryid as categoryid,c.carcategoryname as categoryname,
d.carbrandid as brandids,d.brandname
from tbm_car a
left join tbm_cartype b on b.typeid = a.typeid and b.dlt='0'
left join tbm_carcategory c on c.carcategoryid = b.carcategoryid and c.dlt='0'
left join tbm_carbrand d on d.carbrandid = b.carbrandid and d.dlt='0'
where b.dlt ='0' and a.carid='" + CarId + "'";
DataTable dtData = oConn.GetData(strSql);
//cmbTipe.DataSource = dtData;
//cmbTipe.SelectedValue = cmbTipe.Items.Contains("typename").ToString();
foreach (DataRow row in dtData.Rows)
{
txtPlatnumber.Text = Convert.ToString(row["platnumber"]);
cmbTipe.Text = row["typename"].ToString();
txtKategori.Text = Convert.ToString(row["categoryname"]);
txtBrand.Text = Convert.ToString(row["brandname"]);
txtDesc.Text = Convert.ToString(row["description"]);
txtkapasitas.Value = Convert.ToInt32(row["passengercapacity"]);
txtHarga.EditValue = Convert.ToString(row["price"]);
typeid = row["typeid"].ToString();
txtKategori.Text = row["categoryname"].ToString();
txtBrand.Text = row["brandname"].ToString();
if (System.IO.File.Exists(row["imagename"].ToString()))
{
pFoto.Image = Image.FromFile(row["imagename"].ToString());
txtPathText.Text = row["filepath_car"].ToString();
getImage = row["imagename"].ToString();
}
//byte[] imageByte = oObject.imageCar.ToArray();
}
}
}
catch
{
}
//fillcmb();
}
public void loadData()
{
try
{
using (clsConnection oConn = new clsConnection())
{
NpgsqlCommand ocmd = new NpgsqlCommand();
frmMain.setLoadDialog(true, "Loading data...");
//List<Char> getCategory = new List<char>();
// var getCategory= oConn.ReadData("select carcategoryname from tbm_carcategory").ToString().ToList();
//ricmbCategory.Items.Add(getCategory);
string strSql = @"select a.typeid, a.carcategoryid as categoryid,a.carbrandid as brandid, a.typename,
b.carcategoryid as categoryids,b.carcategoryname as categoryname,
c.carbrandid as brandids, c.brandname
from tbm_cartype a
left join tbm_carcategory b on b.carcategoryid = a.carcategoryid and b.dlt='0'
left join tbm_carbrand c on c.carbrandid = a.carbrandid and c.dlt='0'
where a.dlt ='0' order by a.typeid;";
DataTable dtData = oConn.GetData(strSql);
dgData.DataSource = dtData;
//string strSqlCategory = clsGlobal.getData1Field("select carcategoryid from tbm_carcategory where carcategoryname='" + Convert.ToString(gridViewData.GetFocusedRowCellValue(colCategoryname)) + "'");
//DataTable categoryData = oConn.GetData(getCategoryValue);
//DataTable brandData = oConn.GetData(getBrandValue);
loadCmb();
gridViewData.Columns[1].ColumnEdit = ricmbCategory;
gridViewData.Columns[2].ColumnEdit = ricmbBrand;
}
}
catch (NpgsqlException ex)
{
}
catch (Exception ex)
{
}
finally
{
frmMain.setLoadDialog(false, "");
}
}
private void fillcmb()
{
try
{
using (clsConnection oConn = new clsConnection())
{
string strSql = @"select * from tbm_cartype where dlt='0'";
DataTable dtData = oConn.GetData(strSql);
cmbTipe.DataSource = dtData;
cmbTipe.DisplayMember = "typename";
cmbTipe.ValueMember = "typeid";
foreach (DataRow row in dtData.Rows)
{
//cmbTipe.Items.Add(row["typename"].ToString());
}
}
}
catch
{
}
}
private void fillCombo()
{
try
{
using (clsConnection oConn = new clsConnection())
{
NpgsqlCommand ocmd = new NpgsqlCommand();
string strSql = @"select * from tbm_car where dlt='0'";
DataTable dtData = oConn.GetData(strSql);
for (int i = 0; i < dtData.Rows.Count; i++)
{
cmbPlatnumber.Items.Add(dtData.Rows[i]["platnumber"].ToString());
}
}
}
catch (NpgsqlException ex)
{
}
catch (Exception ex)
{
}
}
private void getRepairId()
{
try
{
using (clsConnection oConn = new clsConnection())
{
NpgsqlCommand ocmd = new NpgsqlCommand();
string strSql = @"select * from tbm_carrepair where dlt=false";
DataTable dtData = oConn.GetData(strSql);
//dgData.DataSource = dtData;
if (dtData.Rows.Count == 0)
{
int bookingId = 1;
strRepairid = clsGlobal.pstrservercode + "0" + bookingId++;
}
else
{
foreach (DataRow row in dtData.Rows)
{
int BookingId = Convert.ToInt32(row["repairid"].ToString().Substring(3, 2));
int IncBookingId = BookingId++;
string strBookingId = Convert.ToString(BookingId++);
string finalid = clsGlobal.pstrservercode + "0" + strBookingId;
strRepairid = finalid;
}
}
}
}
catch (NpgsqlException ex)
{
}
catch (Exception ex)
{
}
finally
{
}
}
public void loadData()
{
try
{
using (clsConnection oConn = new clsConnection())
{
NpgsqlCommand ocmd = new NpgsqlCommand();
frmMain.setLoadDialog(true, "Loading data...");
string strSql = @"select a.carid, a.platnumber,a.imagename,a.typeid,a.filepath_car,a.passengercapacity,a.price,a.description,
a.statusavailable,
b.typeid,b.carcategoryid as categoryid, b.carbrandid,b.typename,
c.carcategoryid as categoryid,c.carcategoryname as categoryname,
d.carbrandid as brandids,d.brandname
from tbm_car a
left join tbm_cartype b on b.typeid = a.typeid and b.dlt='0'
left join tbm_carcategory c on c.carcategoryid = b.carcategoryid and c.dlt='0'
left join tbm_carbrand d on d.carbrandid = b.carbrandid and d.dlt='0'
where a.dlt=false order by a.statusavailable;";
DataTable dtData = oConn.GetData(strSql);
dgData.DataSource = dtData;
foreach (DataRow row in dtData.Rows)
{
}
gridViewData.Columns[1].ColumnEdit = ricmbCarType;
}
}
catch (NpgsqlException ex)
{
}
catch (Exception ex)
{
}
finally
{
frmMain.setLoadDialog(false, "");
}
}
public void loadData()
{
try
{
using (clsConnection oConn = new clsConnection())
{
NpgsqlCommand ocmd = new NpgsqlCommand();
frmMain.setLoadDialog(true, "Loading data...");
string strSql = @"select a.repairid,a.carid,b.platnumber from tbm_carrepair a inner join tbm_car b on b.carid=a.carid and b.dlt='0'";
DataTable dtData = oConn.GetData(strSql);
dgData.DataSource = dtData;
}
}
catch (NpgsqlException ex)
{
}
catch (Exception ex)
{
}
finally
{
frmMain.setLoadDialog(false, "");
}
}
private void loadBookingId()
{
using (clsConnection oConn = new clsConnection())
{
string strSql = @"select * from tbm_booking";
DataTable dtData = oConn.GetData(strSql);
if (dtData.Rows.Count == 0)
{
int bookingId = 1;
txtBookingId.Text = clsGlobal.pstrservercode + "0" + bookingId++;
}
else
{
foreach (DataRow row in dtData.Rows)
{
int BookingId = Convert.ToInt32(row["bookingid"].ToString().Substring(3, 2));
int IncBookingId = BookingId++;
string strBookingId = Convert.ToString(BookingId++);
string finalid = clsGlobal.pstrservercode + "0" + strBookingId;
txtBookingId.Text = finalid;
}
}
}
}
public static string getDataRequired(string categoryName, string website)
{
DataTable dt = cls.GetData(@"select * from tbl_MLS_DataRequired where website_id = '" + website + @"' and
category_id = (SELECT category_id from tbl_MLS_Category where Category_Name = '" + categoryName + "')");
DataTable dtable;
if (dt.Rows.Count > 0)
{
dtable = cls.GetData(@"select Indicator = 'TRUE', a.field_id, a.field_name, b.Category_Name, c.field_id [Fields] from tbl_MLS_Fields a
inner join tbl_MLS_Category b
on a.category_id = b.category_id
inner join tbl_MLS_DataRequired c
on b.category_id = c.category_id
and website_id = '" + website + @"' and
b.category_id = (SELECT category_id from tbl_MLS_Category where Category_Name = '" + categoryName + "')");
}
else
{
dtable = cls.GetData(@"Select Indicator = 'FALSE', * from tbl_MLS_Fields a
full outer join tbl_MLS_Category b
on a.category_id = b.category_id
where b.Category_Name = '" + categoryName + "'");
}
return(JsonConvert.SerializeObject(new { Success = true, Message = "Success", data = new { record = dtable } }));
}
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 { }
}