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 { } }