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 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); } 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(); MessageBox.Show("Data Inserted", "Insert", MessageBoxButtons.OK, MessageBoxIcon.Information); oObject = null; } } else { } } } catch (NpgsqlException ex) { ////clsGlobal.generateErrMessageAndSendmail(ex, false); } catch (Exception ex) { ////clsGlobal.generateErrMessageAndSendmail(ex, false); } } }
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 Login(string strUsername, string strPassword) { try { clsEncryption oEncryption = new clsEncryption(); using (clsConnection oconn = new clsConnection()) { NpgsqlCommand ocmd = new NpgsqlCommand(); oconn.Open(); ocmd.Connection = oconn.Conn; ocmd = new NpgsqlCommand(); ocmd.Connection = oconn.Conn; bool isActive = true; string strsql = @"select userid, username, fullname,email, groupusers from tbm_users where username=@username and password=@password and dlt='0' and active='1'"; ocmd.Parameters.Add("@username", NpgsqlTypes.NpgsqlDbType.Varchar).Value = oEncryption.Encrypt(strUsername.ToString().ToUpper()); ocmd.Parameters.Add("@password", NpgsqlTypes.NpgsqlDbType.Varchar).Value = oEncryption.Encrypt(strPassword.ToString()); ocmd.CommandText = strsql; NpgsqlDataReader dr; dr = ocmd.ExecuteReader(); if (dr.Read()) { clsRegKey oRegKey = new clsRegKey(); oRegKey.RegistryPathCurrentUser = clsGlobal.s_FullRegKey; oRegKey = null; clsGlobal.strUserName = oEncryption.Decrypt(dr["username"].ToString()); clsGlobal.strUserID = dr["userid"].ToString(); clsGlobal.strHakAkses = dr["groupusers"].ToString(); clsGlobal.strNamaPetugas = dr["fullname"].ToString(); clsGlobal.strUserPassword = txtPassword.Text; clsGlobal.strGroupUser = dr["groupusers"].ToString(); } else { XtraMessageBox.Show("Invalid username or password .!", clsGlobal.str_ApplicationName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); strPassword = ""; oconn.Close(); ocmd = null; oEncryption = null; return; } oconn.Close(); ocmd = null; } oEncryption = null; this.DialogResult = System.Windows.Forms.DialogResult.OK; } catch (Exception ex) { XtraMessageBox.Show("Unable connect to database server, please configure the database connection first", clsGlobal.str_ApplicationName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); frmServerInitialize frm = new frmServerInitialize(); frm.ShowDialog(this); } }
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); } }
public frmMain() { try { formSplash = new frmLogin(); formSplash.ShowDialog(this); if (formSplash.DialogResult == DialogResult.OK) { clsGlobal.xpatchDatabase(); loadDialog = new WaitDialogForm("Loading Components...", "Processing...Please Wait...", new Size(420, 78)); InitializeComponent(); if (clsGlobal.bolevaluationversion) { clsGlobal.pstrAppName = "EVALUATION VERSION - Mobilo Rental"; this.Text = "EVALUATION VERSION - Mobilo Rental"; } else { clsGlobal.pstrAppName = "MobiloRental"; this.Text = "Mobilo Rental"; } oReg.RegistryPathCurrentUser = clsGlobal.s_FullRegKey; using (clsConnection oconn = new clsConnection()) { oconn.Open(); lblWelcome.Text = "WELCOME : " + clsGlobal.strUserName.ToUpper(); lblPosition.Text = "POSITION : " + clsGlobal.strGroupUser.ToUpper(); oconn.Close(); } setUserPrivillage(); nbiVisibility(); } } catch { } finally { setLoadDialog(false, ""); } try { if (clsGlobal.isusebackgroundimage) { if (System.IO.File.Exists(Application.StartupPath.ToString() + "\\bg\\mainbg.jpg")) { panelHome.Visible = true; panelHome.BackgroundImage = Image.FromFile(Application.StartupPath.ToString() + "\\bg\\mainbg.jpg"); panelHome.BackgroundImageLayout = ImageLayout.Stretch; } } } catch (Exception ex) { } }
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 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); } }
private void gridViewData_ValidateRow(object sender, DevExpress.XtraGrid.Views.Base.ValidateRowEventArgs e) { try { using (clsConnection oConn = new clsConnection()) { string strID = Convert.ToString(gridViewData.GetFocusedRowCellValue(colUserId)); string strPassword = Convert.ToString(gridViewData.GetFocusedRowCellValue(colPassword)); string strUsername = Convert.ToString(gridViewData.GetFocusedRowCellValue(colUsername)); string strCount = clsGlobal.getData1Field("select count(*) from tbm_users where dlt='0' and trim(lower(username))=trim(lower('" + Convert.ToString(gridViewData.GetFocusedRowCellValue(colUsername)) + "')) and userid<>'" + strID + "'"); string strGetPassword = clsGlobal.getData1Field("select password from tbm_users where userid='" + strID + "'"); string strGetUsername = clsGlobal.getData1Field("select username from tbm_users where userid='" + strID + "'"); if (Convert.ToInt32(strCount) == 0) { tbm_users oObject = new tbm_users(); oConn.Open(); oObject.Koneksi = oConn.Conn; if (!string.IsNullOrEmpty(strID)) { oObject.GetByPrimaryKey(strID); } clsEncryption oEncryption = new clsEncryption(); if (strPassword == strGetPassword) { oObject.password = strGetPassword; } else { oObject.password = oEncryption.Encrypt(strPassword); } if (strUsername == strGetUsername) { oObject.username = strGetUsername; } else { oObject.username = oEncryption.Encrypt(strUsername); } oObject.userid = Convert.ToString(gridViewData.GetFocusedRowCellValue(colUserId)); oObject.fullname = Convert.ToString(gridViewData.GetFocusedRowCellValue(colFullname)); oObject.email = Convert.ToString(gridViewData.GetFocusedRowCellValue(colEmail)); oObject.groupusers = Convert.ToString(gridViewData.GetFocusedRowCellValue(colGroupUsers)).ToLower(); if (oObject.username == "" || oObject.password == "" || oObject.fullname == "" || oObject.email == "" || oObject.groupusers == "") { XtraMessageBox.Show("Data Can't Be Null", "Warning"); } else { if (string.IsNullOrEmpty(strID)) { oObject.userid = oObject.NewID(); oObject.active = true; oObject.opadd = clsGlobal.strUserName; oObject.pcadd = SystemInformation.ComputerName; oObject.luadd = DateTime.Now; oObject.Insert(); gridViewData.SetFocusedRowCellValue(colUserId, oObject.userid); } else { oObject.active = Convert.ToBoolean(gridViewData.GetFocusedRowCellValue(colActive)); oObject.opedit = clsGlobal.strUserName; oObject.pcedit = SystemInformation.ComputerName; oObject.Update(); } oObject = null; e.Valid = true; } } else { e.ErrorText = "This code " + Convert.ToString(gridViewData.GetFocusedRowCellValue(colUserId)) + " already exists in database and cannot be filled the same value.!\n"; gridViewData.FocusedColumn = colUsername; e.Valid = false; return; } } } catch (NpgsqlException ex) { ////clsGlobal.generateErrMessageAndSendmail(ex, false); } catch (Exception ex) { ////clsGlobal.generateErrMessageAndSendmail(ex, false); } }
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 { } }