コード例 #1
0
        protected void save()
        {
            #region Variables
            SubcidiaryAccount.sub_code        = txtcode.Text;
            SubcidiaryAccount.sub_title       = txtTitle.Text;
            SubcidiaryAccount.sub_category_id = cboLedgerCategory.SelectedValue.ToString();
            SubcidiaryAccount.sub_opening_bal = txtOpeningBal.Text != string.Empty.Trim() ? decimal.Parse(txtOpeningBal.Text.Trim()) : 0;
            SubcidiaryAccount.nominal_acc_id  = cboNorminalAcc.SelectedValue.ToString();
            SubcidiaryAccount.debit_credit    = cboDebitCredit.Text;
            SubcidiaryAccount.active          = chkActive.Checked ? true : false;
            SubcidiaryAccount.tel_contact     = txtPhone.Text;
            SubcidiaryAccount.email_adress    = txtEmail.Text;
            SubcidiaryAccount.adress          = txtAddress.Text;
            SubcidiaryAccount.branch_id       = cboBranch.SelectedValue.ToString();
            SubcidiaryAccount.usr_id_create   = SystemConst._user_id;
            SubcidiaryAccount.usr_id_update   = SystemConst._user_id;
            SubcidiaryAccount.usr_date_create = DateTime.Now;
            SubcidiaryAccount.usr_date_update = DateTime.Now;
            #endregion

            if (lblID.Text == Globals.EmptyID)
            {
                SubcidiaryAccount.sub_id = Guid.NewGuid().ToString();
                lblID.Text = SubcidiaryAccount.sub_id;
                SubcidiaryAccount.save("save_record");
                MessageBox.Show("Succefully saved new subsidiary account details", "save", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            else
            {
                SubcidiaryAccount.sub_id = lblID.Text;
                SubcidiaryAccount.save("update_record");
                MessageBox.Show("Succefully updated subsidiary account details", "save", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
        }
コード例 #2
0
        protected void LoadRecordDetails(string id)
        {
            dt = SubcidiaryAccount.LoadRecord("select_record_details", id);
            if (dt.Rows.Count > 0)
            {
                DataRow dtRow = dt.Rows[0];

                txtcode.Text  = dtRow["sub_code"].ToString();
                txtTitle.Text = dtRow["sub_title"].ToString();
                cboLedgerCategory.SelectedValue = dtRow["sub_category_id"].ToString();
                txtOpeningBal.Text           = decimal.Parse(dtRow["sub_opening_bal"].ToString()).ToString();
                cboNorminalAcc.SelectedValue = dtRow["nominal_acc_id"].ToString();
                cboDebitCredit.Text          = dtRow["sub_category_id"].ToString();
                chkActive.Checked            = Convert.ToBoolean(dtRow["active"]);
                txtPhone.Text           = dtRow["tel_contact"].ToString();
                txtEmail.Text           = dtRow["email_adress"].ToString();
                txtAddress.Text         = dtRow["adress"].ToString();
                cboBranch.SelectedValue = dtRow["branch_id"].ToString();
                lblID.Text           = id;
                pnlDataEntry.Enabled = false;
            }
        }
コード例 #3
0
        protected void SearchGridviewListing()
        {
            dt = SubcidiaryAccount.LoadList("select_record_listing", txtCodeSearch.Text.Trim(), cboSubLedgerSearch.SelectedValue.ToString(), cboControlAccSearch.SelectedValue.ToString(), txtAccountTitle.Text.Trim());
            if (dt != null)
            {
                gdvList.DataSource = dt;

                gdvList.Columns["sub_id"].Visible = false;
                gdvList.Columns["adress"].Visible = false;

                gdvList.Columns["sub_title"].HeaderText                = "Account Title";
                gdvList.Columns["sub_code"].HeaderText                 = "Account Code";
                gdvList.Columns["sub_opening_bal"].HeaderText          = "Opening Bal";
                gdvList.Columns["debit_credit"].HeaderText             = "Dr/Cr";
                gdvList.Columns["sub_ledger_category_name"].HeaderText = "Sub Ledger";
                gdvList.Columns["acc_name"].HeaderText                 = "Control Acc Title";
                gdvList.Columns["active"].HeaderText       = "Active";
                gdvList.Columns["tel_contact"].HeaderText  = "Phone Number";
                gdvList.Columns["email_adress"].HeaderText = "Email Address";
                gdvList.Columns["branch"].HeaderText       = "Branch";

                gdvList.RowsDefaultCellStyle.BackColor            = Color.LightGray;
                gdvList.AlternatingRowsDefaultCellStyle.BackColor = Color.Beige;
                gdvList.ColumnHeadersDefaultCellStyle.ForeColor   = Color.White;
                gdvList.ColumnHeadersDefaultCellStyle.BackColor   = Color.Black;
                gdvList.RowHeadersDefaultCellStyle.BackColor      = Color.Black;
                gdvList.DefaultCellStyle.SelectionBackColor       = Color.Cyan;
                gdvList.DefaultCellStyle.SelectionForeColor       = Color.Black;
                foreach (DataGridViewColumn c in this.gdvList.Columns)
                {
                    c.DefaultCellStyle.Font = new System.Drawing.Font("Arial", 12f, GraphicsUnit.Pixel);
                }
                this.gdvList.ColumnHeadersDefaultCellStyle.BackColor = Color.CadetBlue;
                this.gdvList.EnableHeadersVisualStyles = false;
            }
        }