private void btnUpdate_Click(object sender, EventArgs e)
        {
            try
            {
                if (!GlobalFunctions.checkRights("tsmGeneralJournal", "Update"))
                {
                    return;
                }

                foreach (DataRow _drStatus in loJournalEntry.getJournalEntryStatus(dgvList.CurrentRow.Cells[0].Value.ToString()).Rows)
                {
                    if (_drStatus[0].ToString() == "Y")
                    {
                        MessageBoxUI _mbStatus = new MessageBoxUI("You cannot update a POSTED Journal Entry!", GlobalVariables.Icons.Warning, GlobalVariables.Buttons.OK);
                        _mbStatus.ShowDialog();
                        return;
                    }
                }
                if (dgvList.Rows.Count > 0)
                {
                    JournalVoucherUI loJournalVoucher = new JournalVoucherUI(dgvList.CurrentRow.Cells[0].Value.ToString());
                    loJournalVoucher.ParentList = this;
                    loJournalVoucher.ShowDialog();
                }
            }
            catch (Exception ex)
            {
                ErrorMessageUI em = new ErrorMessageUI(ex.Message, this.Name, "btnUpdate_Click");
                em.ShowDialog();
                return;
            }
        }
示例#2
0
        public void Restore()
        {
            try
            {
                //Read file from C:\
                string path;
                path = txtSqlFileAddress.Text;//.../Main/MySqlBackUp/POSBackup2012-1-6-18-44-57-353.sql
                StreamReader file  = new StreamReader(path);
                string       input = file.ReadToEnd();
                file.Close();

                ProcessStartInfo psi = new ProcessStartInfo();
                psi.FileName = GlobalVariables.RestoreMySqlAddress;
                psi.RedirectStandardInput  = true;
                psi.RedirectStandardOutput = false;
                psi.Arguments = string.Format(@"-u{0} -p{1} -h{2} {3}",
                                              txtBackupUserId.Text, txtBackupPassword.Text, txtBackupServer.Text, txtBackupDatabase.Text);
                psi.UseShellExecute = false;

                Process process = Process.Start(psi);
                process.StandardInput.WriteLine(input);
                process.StandardInput.Close();
                process.WaitForExit();
                process.Close();
                MessageBoxUI mb = new MessageBoxUI("Database has been successfully restored!", GlobalVariables.Icons.Ok, GlobalVariables.Buttons.OK);
                mb.ShowDialog();
            }
            catch (IOException ex)
            {
                MessageBoxUI mb = new MessageBoxUI(ex, GlobalVariables.Icons.Error, GlobalVariables.Buttons.Close);
                mb.ShowDialog();
            }
        }
示例#3
0
        private void pbPicture_Click(object sender, EventArgs e)
        {
            OpenFileDialog openFD = new OpenFileDialog();

            openFD.InitialDirectory = ".../Main/ScreenSaverImages/";
            openFD.Title            = "Insert an Image";
            openFD.Filter           = "JPEG Images|*.jpg|GIF Images|*.gif|PNG Images|*.png";
            if (openFD.ShowDialog() == DialogResult.Cancel)
            {
                MessageBoxUI mb = new MessageBoxUI("Operation Cancelled", GlobalVariables.Icons.Information, GlobalVariables.Buttons.OK);
                mb.ShowDialog();
            }
            else
            {
                string lChosenFile = openFD.FileName;
                string _FileName   = openFD.SafeFileName;
                byte[] m_Bitmap    = null;

                FileStream   fs     = new FileStream(lChosenFile, FileMode.Open);
                BinaryReader br     = new BinaryReader(fs);
                int          length = (int)br.BaseStream.Length;
                m_Bitmap = new byte[length];
                m_Bitmap = br.ReadBytes(length);
                br.Close();
                fs.Close();

                lPicture = GlobalFunctions.ToHex(m_Bitmap);

                pbPicture.BackgroundImage       = GlobalFunctions.ConvertByteArrayToImage(m_Bitmap);
                pbPicture.BackgroundImageLayout = ImageLayout.Stretch;
            }
        }
示例#4
0
 private void btnAuthenticate_Click(object sender, EventArgs e)
 {
     if (txtKey1.Text == lExpectedValue1 && txtKey2.Text == lExpectedValue2 &&
         txtKey3.Text == lExpectedValue3 && txtKey4.Text == lExpectedValue4)
     {
         /*
          * if (!sendEmailForLicenseKeyRecording(GlobalFunctions.GetProcessorId(), txtKey1.Text + "-" + txtKey2.Text + "-" + txtKey3.Text + "-" + txtKey4.Text))
          * {
          *  MessageBoxUI mb1 = new MessageBoxUI("NO INTERNET CONNECTION!\nYou must have an internet connection or contact supplier!", GlobalVariables.Icons.Warning, GlobalVariables.Buttons.OK);
          *  mb1.ShowDialog();
          *  Application.Exit();
          * }
          */
         MessageBoxUI mb = new MessageBoxUI("CONGRATULATIONS!\nLicense has been verified. Thank you for using NSites Business Applications!", GlobalVariables.Icons.Information, GlobalVariables.Buttons.OK);
         mb.ShowDialog();
         //writeLicenseCertificate();
         lLicenseNo            = lExpectedValue1 + "-" + lExpectedValue2 + "-" + lExpectedValue3 + "-" + lExpectedValue4;
         lExpiryDate           = DateTime.Parse("01/01/9999");
         lSuccessFullyVerified = true;
         this.Close();
     }
     else
     {
         MessageBoxUI mb = new MessageBoxUI("INVALID KEY!\nPlease input correct license key or contact supplier!", GlobalVariables.Icons.Warning, GlobalVariables.Buttons.OK);
         mb.ShowDialog();
         return;
     }
 }
 private void btnRemove_Click(object sender, EventArgs e)
 {
     try
     {
         if (!GlobalFunctions.checkRights("tsmUserGroup", "Remove"))
         {
             return;
         }
         if (lId != null)
         {
             DialogResult _dr = new DialogResult();
             MessageBoxUI _mb = new MessageBoxUI("Are sure you want to continue removing this record?", GlobalVariables.Icons.QuestionMark, GlobalVariables.Buttons.YesNo);
             _mb.ShowDialog();
             _dr = _mb.Operation;
             if (_dr == DialogResult.Yes)
             {
                 if (loUserGroup.removeUserGroup(lId))
                 {
                     MessageBoxUI _mb1 = new MessageBoxUI("User Group has been successfully removed!", GlobalVariables.Icons.Information, GlobalVariables.Buttons.OK);
                     _mb1.ShowDialog();
                     refresh("ViewAll", "", "");
                     loadAllMenuItems();
                 }
             }
         }
     }
     catch (Exception ex)
     {
         ErrorMessageUI em = new ErrorMessageUI(ex.Message, this.Name, "btnRemove_Click");
         em.ShowDialog();
         return;
     }
 }
        private void btnRemoveCreditExperience_Click(object sender, EventArgs e)
        {
            DialogResult _dr = new DialogResult();
            MessageBoxUI _mb = new MessageBoxUI("Are sure you want to continue removing this record?", GlobalVariables.Icons.QuestionMark, GlobalVariables.Buttons.YesNo);

            _mb.ShowDialog();
            _dr = _mb.Operation;
            if (_dr == DialogResult.Yes)
            {
                try
                {
                    if (loClientCreditExperience.remove(dgvCreditExperience.CurrentRow.Cells[0].Value.ToString()))
                    {
                        MessageBoxUI _mb1 = new MessageBoxUI("Credit Experience has been successfully removed!", GlobalVariables.Icons.Information, GlobalVariables.Buttons.OK);
                        _mb1.ShowDialog();
                        dgvCreditExperience.DataSource = loClientCreditExperience.getAllData(txtClientId.Text, "");
                    }
                }
                catch (Exception ex)
                {
                    MessageBoxUI mb = new MessageBoxUI(ex, GlobalVariables.Icons.Error, GlobalVariables.Buttons.OK);
                    mb.ShowDialog();
                    return;
                }
            }
        }
        private void btnSave_Click(object sender, EventArgs e)
        {
            try
            {
                if (!GlobalFunctions.checkRights("tsmScreenSaver", "Save"))
                {
                    return;
                }
                loSystemConfiguration.Value = lScreenSaverImage;
                loSystemConfiguration.Key   = "ScreenSaverImage";

                if (loSystemConfiguration.saveSystemConfiguration(GlobalVariables.Operation.Edit))
                {
                    GlobalVariables.ScreenSaverImage = lScreenSaverImage;
                    MessageBoxUI ms = new MessageBoxUI("Screen Saver has been change successfully!", GlobalVariables.Icons.Information, GlobalVariables.Buttons.OK);
                    ms.ShowDialog();
                    ParentList.GetType().GetMethod("changeHomeImage").Invoke(ParentList, null);
                }
            }
            catch (Exception ex)
            {
                ErrorMessageUI em = new ErrorMessageUI(ex.Message, this.Name, "btnSave_Click");
                em.ShowDialog();
                return;
            }
        }
        public bool saveSystemConfiguration(GlobalVariables.Operation pOperation)
        {
            bool _Status = false;

            try
            {
                switch (pOperation)
                {
                case GlobalVariables.Operation.Add:
                    _Status = lSystemConfigurationDAO.insertSystemConfiguration(this);
                    break;

                case GlobalVariables.Operation.Edit:
                    _Status = lSystemConfigurationDAO.updateSystemConfiguration(this);
                    break;

                default:
                    break;
                }
            }
            catch (Exception ex)
            {
                MessageBoxUI mb = new MessageBoxUI(ex, GlobalVariables.Icons.Error, GlobalVariables.Buttons.OK);
                mb.ShowDialog();
            }
            return(_Status);
        }
示例#9
0
        private void btnSave_Click(object sender, EventArgs e)
        {
            try
            {
                if (!GlobalFunctions.checkRights("tsmSystemConfiguration", "Save"))
                {
                    return;
                }

                lOperation = GlobalVariables.Operation.Edit;
                loadDataToHash();
                foreach (DictionaryEntry Hash in lSystemConfigHash)
                {
                    try
                    {
                        loSystemConfiguration.Key   = Hash.Key.ToString();
                        loSystemConfiguration.Value = Hash.Value.ToString();
                    }
                    catch (Exception ex)
                    {
                        throw ex;
                    }
                    loSystemConfiguration.saveSystemConfiguration(lOperation);
                }
                writeSystemSettings();
                MessageBoxUI _mb = new MessageBoxUI("System Configuration has been saved successfully!", GlobalVariables.Icons.Save, GlobalVariables.Buttons.OK);
                _mb.ShowDialog();
            }
            catch (Exception ex)
            {
                ErrorMessageUI em = new ErrorMessageUI(ex.Message, this.Name, "btnSave_Click");
                em.ShowDialog();
                return;
            }
        }
 private void tsmPreviewDetail_Click(object sender, EventArgs e)
 {
     try
     {
         if (!GlobalFunctions.checkRights("tsmPriceQuotation", "Preview Detail"))
         {
             return;
         }
         foreach (DataRow _drStatus in loPriceQuotation.getPriceQuotationStatus(dgvList.CurrentRow.Cells[0].Value.ToString()).Rows)
         {
             if (_drStatus[0].ToString() == "N")
             {
                 MessageBoxUI _mbStatus = new MessageBoxUI("Only APPROVED Price Quotation can be previewed!", GlobalVariables.Icons.Warning, GlobalVariables.Buttons.OK);
                 _mbStatus.ShowDialog();
                 return;
             }
             else if (_drStatus[2].ToString() == "Y")
             {
                 MessageBoxUI _mbStatus = new MessageBoxUI("You cannot preview a cancelled Price Quotation!", GlobalVariables.Icons.Warning, GlobalVariables.Buttons.OK);
                 _mbStatus.ShowDialog();
                 return;
             }
             else
             {
                 previewPriceQuotationDetail(dgvList.CurrentRow.Cells[0].Value.ToString());
             }
         }
     }
     catch (Exception ex)
     {
         ErrorMessageUI em = new ErrorMessageUI(ex.Message, this.Name, "tsmPreviewDetail_Click");
         em.ShowDialog();
         return;
     }
 }
示例#11
0
        private void btnUpdate_Click(object sender, EventArgs e)
        {
            try
            {
                if (!GlobalFunctions.checkRights("tsmStockReceiving", "Update"))
                {
                    return;
                }

                foreach (DataRow _drStatus in loInventory.getInventoryStatus(dgvList.CurrentRow.Cells[0].Value.ToString()).Rows)
                {
                    if (_drStatus[0].ToString() == "Y")
                    {
                        MessageBoxUI _mbStatus = new MessageBoxUI("You cannot update a FINALIZED Stock Inventory!", GlobalVariables.Icons.Warning, GlobalVariables.Buttons.OK);
                        _mbStatus.ShowDialog();
                        return;
                    }
                }
                if (dgvList.Rows.Count > 0)
                {
                    StockReceivingDetailUI loStockReceivingDetail = new StockReceivingDetailUI(dgvList.CurrentRow.Cells[0].Value.ToString());
                    loStockReceivingDetail.ParentList = this;
                    loStockReceivingDetail.ShowDialog();
                }
            }
            catch (Exception ex)
            {
                ErrorMessageUI em = new ErrorMessageUI(ex.Message, this.Name, "btnUpdate_Click");
                em.ShowDialog();
                return;
            }
        }
        public string save(GlobalVariables.Operation pOperation, ref MySqlTransaction pTrans)
        {
            string _UserGroupId = "";

            try
            {
                switch (pOperation)
                {
                case GlobalVariables.Operation.Add:
                    _UserGroupId = lUserGroupDAO.insertUserGroup(this, ref pTrans);
                    break;

                case GlobalVariables.Operation.Edit:
                    _UserGroupId = lUserGroupDAO.updateUserGroup(this, ref pTrans);
                    break;

                default:
                    break;
                }
            }
            catch (Exception ex)
            {
                MessageBoxUI mb = new MessageBoxUI(ex, GlobalVariables.Icons.Error, GlobalVariables.Buttons.OK);
                mb.ShowDialog();
            }
            return(_UserGroupId);
        }
示例#13
0
        public bool save(GlobalVariables.Operation pOperation, ref MySqlTransaction pTrans)
        {
            bool _Status = false;

            try
            {
                switch (pOperation)
                {
                case GlobalVariables.Operation.Add:
                    _Status = lUserDAO.insertUser(this, ref pTrans);
                    break;

                case GlobalVariables.Operation.Edit:
                    _Status = lUserDAO.updateUser(this, ref pTrans);
                    break;

                default:
                    break;
                }
            }
            catch (Exception ex)
            {
                MessageBoxUI mb = new MessageBoxUI(ex, GlobalVariables.Icons.Error, GlobalVariables.Buttons.OK);
                mb.ShowDialog();
            }
            return(_Status);
        }
示例#14
0
 private void btnPreview_Click(object sender, EventArgs e)
 {
     if (!GlobalFunctions.checkRights("tsmAuditTrail", "Preview"))
     {
         return;
     }
     try
     {
         loAuditTrailRpt.SetDataSource(ldtAuditTrail);
         loAuditTrailRpt.Database.Tables[1].SetDataSource(GlobalVariables.DTCompanyLogo);
         loAuditTrailRpt.SetParameterValue("CompanyName", GlobalVariables.CompanyName);
         loAuditTrailRpt.SetParameterValue("CompanyAddress", GlobalVariables.CompanyAddress);
         loAuditTrailRpt.SetParameterValue("CompanyContactNumber", GlobalVariables.ContactNumber);
         loAuditTrailRpt.SetParameterValue("Username", GlobalVariables.Userfullname);
         loAuditTrailRpt.SetParameterValue("Title", "Audit Trail");
         loAuditTrailRpt.SetParameterValue("SubTitle", "Audit Trail");
         loReportViewer.crystalReportViewer.ReportSource = loAuditTrailRpt;
         loReportViewer.ShowDialog();
     }
     catch (Exception ex)
     {
         MessageBoxUI mb = new MessageBoxUI(ex, GlobalVariables.Icons.Error, GlobalVariables.Buttons.Close);
         mb.ShowDialog();
         return;
     }
 }
示例#15
0
 private void btnSearch_Click(object sender, EventArgs e)
 {
     if (!GlobalFunctions.checkRights("tsmAuditTrail", "Search"))
     {
         return;
     }
     try
     {
         string _AuditTrailDisplayFields = "SELECT DATE_FORMAT(`Date`,'%M %d, %Y') AS `TransactionDate`,DATE_FORMAT(`Date`,'%h:%i:%s %p') AS `Transaction Time`,LogDescription AS `Log Description`, Hostname AS `Computer Name` " +
                                           "FROM audittrail ";
         string __AuditTrailWhereFields = " ORDER BY `Date` ASC;";
         loSearches.lAlias = "";
         loSearches.ShowDialog();
         if (loSearches.lFromShow)
         {
             ldtAuditTrail = loCommon.getDataFromSearch(_AuditTrailDisplayFields + loSearches.lQuery + __AuditTrailWhereFields);
             GlobalFunctions.refreshGrid(ref dgvAuditTrail, ldtAuditTrail);
         }
     }
     catch (Exception ex)
     {
         MessageBoxUI mb = new MessageBoxUI(ex, GlobalVariables.Icons.Error, GlobalVariables.Buttons.Close);
         mb.ShowDialog();
         return;
     }
 }
        private void btnSave_Click(object sender, EventArgs e)
        {
            try
            {
                if (decimal.Parse(txtQtyIN.Text) == 0)
                {
                    MessageBoxUI _mbStatus = new MessageBoxUI("Qty must not be Zero(0)!", GlobalVariables.Icons.Error, GlobalVariables.Buttons.OK);
                    _mbStatus.ShowDialog();
                    return;
                }

                lRecordData[0] = lDetailId;
                try
                {
                    lRecordData[1] = cboStockDescription.SelectedValue.ToString();
                }
                catch
                {
                    MessageBoxUI _mbStatus = new MessageBoxUI("You must select a correct Stock!", GlobalVariables.Icons.Error, GlobalVariables.Buttons.OK);
                    _mbStatus.ShowDialog();
                    cboStockDescription.Focus();
                    return;
                }
                lRecordData[2] = txtStockCode.Text;
                lRecordData[3] = cboStockDescription.Text;
                lRecordData[4] = txtUnit.Text;
                try
                {
                    lRecordData[5] = cboLocation.SelectedValue.ToString();
                }
                catch
                {
                    lRecordData[5] = "";
                }
                lRecordData[6] = cboLocation.Text;
                lRecordData[7] = string.Format("{0:n}", decimal.Parse(txtQtyIN.Text));
                lRecordData[8] = GlobalFunctions.replaceChar(txtRemarks.Text);

                object[] _params = { lRecordData };
                if (lOperator == "Add")
                {
                    lRecordData[9] = "Add";
                    ParentList.GetType().GetMethod("addData").Invoke(ParentList, _params);
                    clear();
                }
                else if (lOperator == "Edit")
                {
                    lRecordData[9] = "Edit";
                    ParentList.GetType().GetMethod("updateData").Invoke(ParentList, _params);
                    this.Close();
                }
            }
            catch (Exception ex)
            {
                ErrorMessageUI em = new ErrorMessageUI(ex.Message, this.Name, "btnSave_Click");
                em.ShowDialog();
                return;
            }
        }
        private void btnSave_Click(object sender, EventArgs e)
        {
            /*if (decimal.Parse(txtQtyIN.Text) == 0 && decimal.Parse(txtQtyOUT.Text) == 0)
             * {
             *  MessageBoxUI _mbStatus = new MessageBoxUI("Qty must not be Zero(0)!", GlobalVariables.Icons.Error, GlobalVariables.Buttons.OK);
             *  _mbStatus.ShowDialog();
             *  return;
             * }*/

            if (decimal.Parse(txtQtyIN.Text) != 0 && decimal.Parse(txtQtyOUT.Text) != 0)
            {
                MessageBoxUI _mbStatus = new MessageBoxUI("Only 1 (one) Qty must not be Zero(0)!", GlobalVariables.Icons.Error, GlobalVariables.Buttons.OK);
                _mbStatus.ShowDialog();
                return;
            }

            lRecordData[0] = lDetailId;
            try
            {
                lRecordData[1] = cboStockDescription.SelectedValue.ToString();
            }
            catch
            {
                MessageBoxUI _mbStatus = new MessageBoxUI("You must select a correct Stock!", GlobalVariables.Icons.Error, GlobalVariables.Buttons.OK);
                _mbStatus.ShowDialog();
                cboStockDescription.Focus();
                return;
            }
            lRecordData[2]  = cboStockDescription.Text;
            lRecordData[3]  = txtUnit.Text;
            lRecordData[4]  = txtBrand.Text;
            lRecordData[5]  = txtSupplier.Text;
            lRecordData[6]  = lPicture;
            lRecordData[7]  = cboLocation.SelectedValue.ToString();
            lRecordData[8]  = cboLocation.Text;
            lRecordData[9]  = string.Format("{0:n}", decimal.Parse(txtQtyIN.Text));
            lRecordData[10] = string.Format("{0:n}", decimal.Parse(txtQtyOUT.Text));
            lRecordData[11] = string.Format("{0:n}", decimal.Parse(txtBalance.Text));
            lRecordData[12] = string.Format("{0:n}", decimal.Parse(txtUnitPrice.Text));
            lRecordData[13] = string.Format("{0:n}", decimal.Parse(txtTotalPrice.Text));
            lRecordData[14] = GlobalFunctions.replaceChar(txtRemarks.Text);

            object[] _params = { lRecordData };
            if (lOperator == "Add")
            {
                lRecordData[15] = "Add";
                ParentList.GetType().GetMethod("addData").Invoke(ParentList, _params);
                MessageBoxUI _mbStatus = new MessageBoxUI("Successfully added!", GlobalVariables.Icons.Save, GlobalVariables.Buttons.OK);
                _mbStatus.ShowDialog();
                clear();
            }
            else if (lOperator == "Edit")
            {
                lRecordData[15] = "Edit";
                ParentList.GetType().GetMethod("updateData").Invoke(ParentList, _params);
                Close();
            }
        }
        private void btnFinalize_Click(object sender, EventArgs e)
        {
            if (!GlobalFunctions.checkRights("tsmStockWithdrawal", "Finalize"))
            {
                return;
            }
            try
            {
                if (dgvList.Rows.Count > 0)
                {
                    foreach (DataRow _drF in loInventoryHeader.getAllData("", dgvList.CurrentRow.Cells[0].Value.ToString(), "", "Stock Withdtrawal").Rows)
                    {
                        if (_drF["Final"].ToString() == "Y")
                        {
                            MessageBoxUI mb = new MessageBoxUI("Stock Withdrawal is already FINALIZED!", GlobalVariables.Icons.Information, GlobalVariables.Buttons.OK);
                            mb.ShowDialog();
                            return;
                        }
                    }

                    DialogResult _dr = new DialogResult();
                    MessageBoxUI _mb = new MessageBoxUI("Are sure you want to continue finalizing this record?", GlobalVariables.Icons.QuestionMark, GlobalVariables.Buttons.YesNo);
                    _mb.ShowDialog();
                    _dr = _mb.Operation;
                    if (_dr == DialogResult.Yes)
                    {
                        MySqlTransaction Trans = GlobalVariables.Connection.BeginTransaction();
                        try
                        {
                            if (loInventoryHeader.finalize(dgvList.CurrentRow.Cells[0].Value.ToString(), ref Trans))
                            {
                                foreach (DataRow _dr1 in loInventoryDetail.getAllData(dgvList.CurrentRow.Cells[0].Value.ToString()).Rows)
                                {
                                    loInventoryDetail.updateQtyOnHand(_dr1[0].ToString(), ref Trans);
                                }

                                Trans.Commit();
                                MessageBoxUI _mb1 = new MessageBoxUI("Record has been successfully finalized!", GlobalVariables.Icons.Information, GlobalVariables.Buttons.OK);
                                _mb1.ShowDialog();

                                previewDetails(dgvList.CurrentRow.Cells[0].Value.ToString());

                                refresh("ViewAll", "", "", "Stock Withdrawal");
                            }
                        }
                        catch (Exception ex)
                        {
                            Trans.Rollback();
                            MessageBoxUI mb = new MessageBoxUI(ex, GlobalVariables.Icons.Error, GlobalVariables.Buttons.OK);
                            mb.ShowDialog();
                            return;
                        }
                    }
                }
            }
            catch { }
        }
        private void btnRemove_Click(object sender, EventArgs e)
        {
            try
            {
                if (!GlobalFunctions.checkRights("tsmLoanApplication", "Remove"))
                {
                    return;
                }

                DataTable _dt = loLoanApplication.getLoanApplicationStatus(dgvList.CurrentRow.Cells[0].Value.ToString());
                if (_dt.Rows.Count > 0)
                {
                    foreach (DataRow _drStatus in _dt.Rows)
                    {
                        if (_drStatus[0].ToString() != "In Process")
                        {
                            MessageBoxUI _mbStatus = new MessageBoxUI("Only IN PROCESS application can be removed!", GlobalVariables.Icons.Warning, GlobalVariables.Buttons.OK);
                            _mbStatus.ShowDialog();
                            return;
                        }
                    }
                }
                else
                {
                    MessageBoxUI _mbStatus = new MessageBoxUI("Loan Application Id does not exist!", GlobalVariables.Icons.Warning, GlobalVariables.Buttons.OK);
                    _mbStatus.ShowDialog();
                    return;
                }

                if (dgvList.Rows.Count > 0)
                {
                    DialogResult _dr = new DialogResult();
                    MessageBoxUI _mb = new MessageBoxUI("Are sure you want to continue removing this Loan Application record?", GlobalVariables.Icons.QuestionMark, GlobalVariables.Buttons.YesNo);
                    _mb.ShowDialog();
                    _dr = _mb.Operation;
                    if (_dr == DialogResult.Yes)
                    {
                        if (loLoanApplication.remove(dgvList.CurrentRow.Cells[0].Value.ToString()))
                        {
                            MessageBoxUI _mb1 = new MessageBoxUI("Loan Application record has been successfully removed!", GlobalVariables.Icons.Information, GlobalVariables.Buttons.OK);
                            _mb1.ShowDialog();
                            refresh();
                        }
                        else
                        {
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                ErrorMessageUI em = new ErrorMessageUI(ex.Message, this.Name, "btnRemove_Click");
                em.ShowDialog();
                return;
            }
        }
        private void btnApprove_Click(object sender, EventArgs e)
        {
            try
            {
                if (!GlobalFunctions.checkRights("tsmPriceQuotation", "Approved"))
                {
                    return;
                }

                foreach (DataRow _drStatus in loPriceQuotation.getPriceQuotationStatus(dgvList.CurrentRow.Cells[0].Value.ToString()).Rows)
                {
                    if (_drStatus[0].ToString() == "Y")
                    {
                        MessageBoxUI _mbStatus = new MessageBoxUI("Price Quotation is already APPROVED!", GlobalVariables.Icons.Warning, GlobalVariables.Buttons.OK);
                        _mbStatus.ShowDialog();
                        return;
                    }

                    /*
                     * if (_drStatus[4].ToString() == GlobalVariables.Username)
                     * {
                     *  MessageBoxUI _mbStatus = new MessageBoxUI("You cannot APPROVE a Price Quotation you preprared!", GlobalVariables.Icons.Warning, GlobalVariables.Buttons.OK);
                     *  _mbStatus.ShowDialog();
                     *  return;
                     * }
                     */
                }
                if (dgvList.Rows.Count > 0)
                {
                    DialogResult _dr = new DialogResult();
                    MessageBoxUI _mb = new MessageBoxUI("Are sure you want to continue approving this Price Quotation record?", GlobalVariables.Icons.QuestionMark, GlobalVariables.Buttons.YesNo);
                    _mb.ShowDialog();
                    _dr = _mb.Operation;
                    if (_dr == DialogResult.Yes)
                    {
                        if (loPriceQuotation.approve(dgvList.CurrentRow.Cells[0].Value.ToString()))
                        {
                            MessageBoxUI _mb1 = new MessageBoxUI("Price Quotation record has been successfully approved!", GlobalVariables.Icons.Information, GlobalVariables.Buttons.OK);
                            _mb1.ShowDialog();
                            previewPriceQuotationDetail(dgvList.CurrentRow.Cells[0].Value.ToString());
                            //sendEmailToCreator();
                            refresh();
                        }
                        else
                        {
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                ErrorMessageUI em = new ErrorMessageUI(ex.Message, this.Name, "btnApprove_Click");
                em.ShowDialog();
                return;
            }
        }
        private void btnFinalize_Click(object sender, EventArgs e)
        {
            try
            {
                if (!GlobalFunctions.checkRights("tsmStockTransferIn", "Finalize"))
                {
                    return;
                }

                foreach (DataRow _drStatus in loInventory.getInventoryStatus(dgvList.CurrentRow.Cells[0].Value.ToString()).Rows)
                {
                    if (_drStatus[0].ToString() == "Y")
                    {
                        MessageBoxUI _mbStatus = new MessageBoxUI("Stock Inventory is already FINALIZED!", GlobalVariables.Icons.Warning, GlobalVariables.Buttons.OK);
                        _mbStatus.ShowDialog();
                        return;
                    }

                    /*
                     * if (_drStatus[4].ToString() == GlobalVariables.Username)
                     * {
                     *  MessageBoxUI _mbStatus = new MessageBoxUI("You cannot FINALIZE a Stock Inventory you preprared!", GlobalVariables.Icons.Warning, GlobalVariables.Buttons.OK);
                     *  _mbStatus.ShowDialog();
                     *  return;
                     * }
                     */
                }
                if (dgvList.Rows.Count > 0)
                {
                    DialogResult _dr = new DialogResult();
                    MessageBoxUI _mb = new MessageBoxUI("Are sure you want to continue finalizing this Stock Inventory record?", GlobalVariables.Icons.QuestionMark, GlobalVariables.Buttons.YesNo);
                    _mb.ShowDialog();
                    _dr = _mb.Operation;
                    if (_dr == DialogResult.Yes)
                    {
                        if (loInventory.final(dgvList.CurrentRow.Cells[0].Value.ToString()))
                        {
                            MessageBoxUI _mb1 = new MessageBoxUI("Stock Inventory record has been successfully finalized!", GlobalVariables.Icons.Information, GlobalVariables.Buttons.OK);
                            _mb1.ShowDialog();
                            previewInventoryDetail(dgvList.CurrentRow.Cells[0].Value.ToString());
                            //sendEmailToCreator();
                            refresh("Stock Transfer In");
                        }
                        else
                        {
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                ErrorMessageUI em = new ErrorMessageUI(ex.Message, this.Name, "btnFinalize_Click");
                em.ShowDialog();
                return;
            }
        }
示例#22
0
        private void SoftwareLicenseUI_Load(object sender, EventArgs e)
        {
            try
            {
                lblCompanyName.Text   = lCompanyName;
                lSuccessFullyVerified = false;

                //for every software varies...
                string SoftwareNo = "1";

                string[] lValueWithNumbers2 = generateCode(ref txtCode2, ref lblKey2).Split('*');
                string[] lValueWithNumbers3 = generateCode(ref txtCode3, ref lblKey3).Split('*');
                string[] lValueWithNumbers4 = generateCode(ref txtCode4, ref lblKey4).Split('*');

                lExpectedValue2          = lValueWithNumbers2[0].ToString();
                lGetExpectedValueNumber2 = lValueWithNumbers2[1].ToString();
                lNumbers2 = lValueWithNumbers2[2].ToString();

                lExpectedValue3          = lValueWithNumbers3[0].ToString();
                lGetExpectedValueNumber3 = lValueWithNumbers3[1].ToString();
                lNumbers3 = lValueWithNumbers3[2].ToString();

                lExpectedValue4          = lValueWithNumbers4[0].ToString();
                lGetExpectedValueNumber4 = lValueWithNumbers4[1].ToString();
                lNumbers4 = lValueWithNumbers4[2].ToString();
                //for number 1
                string _Value1 = expectedValue(int.Parse(SoftwareNo), int.Parse(SoftwareNo));
                string _Value2 = expectedValue(int.Parse(SoftwareNo), int.Parse(lGetExpectedValueNumber2));
                string _Value3 = expectedValue(int.Parse(SoftwareNo), int.Parse(lGetExpectedValueNumber3));
                string _Value4 = expectedValue(int.Parse(SoftwareNo), int.Parse(lGetExpectedValueNumber4));

                lExpectedValue1          = _Value1 + _Value2 + _Value3 + _Value4;
                lGetExpectedValueNumber1 = "2";
                lNumbers1 = SoftwareNo + lGetExpectedValueNumber2 + lGetExpectedValueNumber3 + lGetExpectedValueNumber4;

                txtCode1.Text = lNumbers1;
                lblKey1.Text  = lNumbers1 + " = " + SoftwareNo + ", " + lGetExpectedValueNumber2 + ", " + lGetExpectedValueNumber3 + ", " + lGetExpectedValueNumber4;

                if (!sendSoftwareLicenseEmail(GlobalFunctions.GetProcessorId(), txtCode1.Text + "-" + txtCode2.Text + "-" + txtCode3.Text + "-" + txtCode4.Text))
                {
                    MessageBoxUI mb = new MessageBoxUI("NO INTERNET CONNECTION!\nYou must have an internet connection or contact supplier!", GlobalVariables.Icons.Warning, GlobalVariables.Buttons.OK);
                    mb.ShowDialog();
                    Application.Exit();
                }

                txtLicenseKey.Focus();
            }
            catch (Exception ex)
            {
                ErrorMessageUI em = new ErrorMessageUI(ex.Message, this.Name, "SoftwareLicenseUI_Load");
                em.ShowDialog();
                Application.Exit();
            }
        }
        private void btnSave_Click(object sender, EventArgs e)
        {
            try
            {
                if (decimal.Parse(txtCheckAmount.Text) == 0)
                {
                    MessageBoxUI _mbStatus = new MessageBoxUI("Check Amount must not be Zero(0)!", GlobalVariables.Icons.Error, GlobalVariables.Buttons.OK);
                    _mbStatus.ShowDialog();
                    return;
                }

                lRecordData[0] = lDetailId;
                try
                {
                    lRecordData[1] = cboBank.SelectedValue.ToString();
                    lRecordData[2] = cboBank.Text;
                }
                catch
                {
                    MessageBoxUI _mbStatus = new MessageBoxUI("You must select a correct Bank!", GlobalVariables.Icons.Error, GlobalVariables.Buttons.OK);
                    _mbStatus.ShowDialog();
                    cboBank.Focus();
                    return;
                }
                lRecordData[3] = txtCheckNo.Text;
                lRecordData[4] = string.Format("{0:n}", decimal.Parse(txtCheckAmount.Text));
                lRecordData[5] = string.Format("{0:MM-dd-yyyy}", dtpCheckDate.Value);
                lRecordData[6] = GlobalFunctions.replaceChar(txtRemarks.Text);

                object[] _params = { lRecordData, false };
                if (lOperator == "Add")
                {
                    lRecordData[7] = "Add";
                    ParentList.GetType().GetMethod("addDataCheck").Invoke(ParentList, _params);
                    //MessageBoxUI _mbStatus = new MessageBoxUI("Successfully added!", GlobalVariables.Icons.Save, GlobalVariables.Buttons.OK);
                    //_mbStatus.ShowDialog();
                    clear();
                }
                else if (lOperator == "Edit")
                {
                    lRecordData[7] = "Edit";
                    ParentList.GetType().GetMethod("updateDataCheck").Invoke(ParentList, _params);
                    this.Close();
                }
            }
            catch (Exception ex)
            {
                ErrorMessageUI em = new ErrorMessageUI(ex.Message, this.Name, "btnSave_Click");
                em.ShowDialog();
                return;
            }
        }
示例#24
0
 private void btnView_Click(object sender, EventArgs e)
 {
     if (dtpDate.Value.Year == dtpFinancialYear.Value.Year)
     {
         viewLedgerByDate();
     }
     else
     {
         MessageBoxUI _mbStatus = new MessageBoxUI("Year must be the same with the Financial Year!", GlobalVariables.Icons.Error, GlobalVariables.Buttons.OK);
         _mbStatus.ShowDialog();
         dtpDate.Focus();
         return;
     }
 }
        private void tsmPreviewDetails_Click(object sender, EventArgs e)
        {
            foreach (DataRow _dr in loInventoryHeader.getAllData("", dgvList.CurrentRow.Cells[0].Value.ToString(), "", "Stock Receiving").Rows)
            {
                if (_dr["Final"].ToString() == "N")
                {
                    MessageBoxUI mb = new MessageBoxUI("Stock Receiving must be FINALIZED!", GlobalVariables.Icons.Information, GlobalVariables.Buttons.OK);
                    mb.ShowDialog();
                    return;
                }
            }

            previewDetails(dgvList.CurrentRow.Cells[0].Value.ToString());
        }
        private void tsmiForcedRemove_Click(object sender, EventArgs e)
        {
            if (!GlobalFunctions.checkRights("tsmStockReceiving", "Forced Remove"))
            {
                return;
            }
            try
            {
                if (dgvList.Rows.Count > 0)
                {
                    foreach (DataRow _drF in loInventoryHeader.getAllData("", dgvList.CurrentRow.Cells[0].Value.ToString(), "", "Stock Receiving").Rows)
                    {
                        if (_drF["Final"].ToString() == "N")
                        {
                            MessageBoxUI mb = new MessageBoxUI("Stock Receiving must be finalized to be forced removed!", GlobalVariables.Icons.Information, GlobalVariables.Buttons.OK);
                            mb.ShowDialog();
                            return;
                        }
                    }

                    DialogResult _dr = new DialogResult();
                    MessageBoxUI _mb = new MessageBoxUI("Are sure you want to continue removing this record?", GlobalVariables.Icons.QuestionMark, GlobalVariables.Buttons.YesNo);
                    _mb.ShowDialog();
                    _dr = _mb.Operation;
                    if (_dr == DialogResult.Yes)
                    {
                        MySqlTransaction Trans = GlobalVariables.Connection.BeginTransaction();
                        try
                        {
                            if (loInventoryHeader.remove(dgvList.CurrentRow.Cells[0].Value.ToString(), ref Trans))
                            {
                                Trans.Commit();
                                MessageBoxUI _mb1 = new MessageBoxUI("Record has been successfully forced remove!", GlobalVariables.Icons.Information, GlobalVariables.Buttons.OK);
                                _mb1.ShowDialog();
                                refresh("ViewAll", "", "", "Stock Receiving");
                            }
                        }
                        catch (Exception ex)
                        {
                            Trans.Rollback();
                            MessageBoxUI mb = new MessageBoxUI(ex, GlobalVariables.Icons.Error, GlobalVariables.Buttons.OK);
                            mb.ShowDialog();
                            return;
                        }
                    }
                }
            }
            catch { }
        }
        public bool updateUserGroupRights(string pUserGroupId, string pItemName, DataTable pRights)
        {
            bool _Status = false;

            try
            {
                _Status = lUserGroupDAO.updateUserGroupRights(pUserGroupId, pItemName, pRights);
            }
            catch (Exception ex)
            {
                MessageBoxUI mb = new MessageBoxUI(ex, GlobalVariables.Icons.Error, GlobalVariables.Buttons.OK);
                mb.ShowDialog();
            }
            return(_Status);
        }
        public bool removeSystemConfiguration(string pKey)
        {
            bool _Status = false;

            try
            {
                _Status = lSystemConfigurationDAO.removeSystemConfiguration(pKey);
            }
            catch (Exception ex)
            {
                MessageBoxUI mb = new MessageBoxUI(ex, GlobalVariables.Icons.Error, GlobalVariables.Buttons.OK);
                mb.ShowDialog();
            }
            return(_Status);
        }
示例#29
0
        public bool remove(string pUsername, ref MySqlTransaction pTrans)
        {
            bool _Status = false;

            try
            {
                _Status = lUserDAO.removeUser(pUsername, ref pTrans);
            }
            catch (Exception ex)
            {
                MessageBoxUI mb = new MessageBoxUI(ex, GlobalVariables.Icons.Error, GlobalVariables.Buttons.OK);
                mb.ShowDialog();
            }
            return(_Status);
        }
        private void btnFinalize_Click(object sender, EventArgs e)
        {
            //loStock.finalizeStockReinventory();
            if (!GlobalFunctions.checkRights("tsmStockReinventory", "Finalize"))
            {
                return;
            }
            try
            {
                if (dgvReport.Rows.Count > 0)
                {
                    DialogResult _dr = new DialogResult();
                    MessageBoxUI _mb = new MessageBoxUI("Are sure you want to continue finalizing this record?", GlobalVariables.Icons.QuestionMark, GlobalVariables.Buttons.YesNo);
                    _mb.ShowDialog();
                    _dr = _mb.Operation;
                    if (_dr == DialogResult.Yes)
                    {
                        MySqlTransaction Trans = GlobalVariables.Connection.BeginTransaction();
                        try
                        {
                            if (loStock.finalizeStockReinventory(dgvReport.CurrentRow.Cells[1].Value.ToString(), dgvReport.CurrentRow.Cells[0].Value.ToString(), ref Trans))
                            {
                                /* Probably Needed */

                                /*foreach (DataRow _dr1 in loInventoryDetail.getAllData(dgvList.CurrentRow.Cells[0].Value.ToString()).Rows)
                                 * {
                                 *  loInventoryDetail.updateQtyOnHand(_dr1[0].ToString(), ref Trans);
                                 * }*/

                                Trans.Commit();
                                MessageBoxUI _mb1 = new MessageBoxUI("Record has been successfully finalized!", GlobalVariables.Icons.Information, GlobalVariables.Buttons.OK);
                                _mb1.ShowDialog();

                                btnRefresh_Click(null, new EventArgs());
                            }
                        }
                        catch (Exception ex)
                        {
                            Trans.Rollback();
                            MessageBoxUI mb = new MessageBoxUI(ex, GlobalVariables.Icons.Error, GlobalVariables.Buttons.OK);
                            mb.ShowDialog();
                            return;
                        }
                    }
                }
            }
            catch { }
        }