protected virtual void OnSetupData() { //load all lookups foreach (JkLookUpComboBox comboBox in IAppHandler.FindControlByType("JkLookUpComboBox", this)) { comboBox.LoadData(); } //clear all datatables VMasterDataTable.Clear(); foreach (JkDetailDataSet DataSet in IAppHandler.FindControlByType("JkDetailDataSet", this)) { DataSet.DataTable.Clear(); } if (CommandText != null && CommandText != "") { VTransactionHandler.LoadData(CommandText, ref VMasterDataTable, this.Parameters); } if (SetupData != null) { SetupData(); } }
private void ECashReceiptVoucherForm_SetupControl() { LoadInvoices(); ShowAmountToApply(); DisplaySummary(); //load journal entry if (FormState == FormStates.fsView) { if (!dstJournalEntry.ZLoadGrid) { dstJournalEntry.ZLoadGrid = true; } dstJournalEntry.Parameters[0].Value = this.MasterColumns.Find(mc => mc.Name == "JournalId").Value.ToString(); dstJournalEntry.DataTable = VTransactionHandler.LoadData(dstJournalEntry.CommandText, dstJournalEntry.Parameters); dataGridViewJournalEntry.DataSource = dstJournalEntry.DataTable; dataGridViewJournalEntry.AutoGenerateColumns = false; tabPageJournalEntry.Text = String.Format("Journal Entry ({0})", dstJournalEntry.DataTable.Rows[0]["TransactionNo"].ToString()); if (!tabControlDetails.TabPages.Contains(tabPageJournalEntry)) { tabControlDetails.TabPages.Insert(1, tabPageJournalEntry); } } else { tabPageJournalEntry.Text = "Journal Entry"; tabControlDetails.TabPages.Remove(tabPageJournalEntry); } }
private void ELogConfigurationForm_AfterSave() { SqlCommand Command = new SqlCommand(); Command.CommandType = CommandType.StoredProcedure; Command.CommandText = "uspCreateTrigger"; Command.Parameters.AddWithValue("@Id", Parameters.Find(p => p.Name == "Id").Value); VTransactionHandler.ExecuteStoredProc(Command); }
protected override void SaveDetail() { base.SaveDetail(); foreach (JkDetailDataSet DataSet in IAppHandler.FindControlByType("JkDetailDataSet", this)) { if (!String.IsNullOrWhiteSpace(DataSet.CommandText) && DataSet.LinkToMaster) { VTransactionHandler.SaveDetail(DataSet.CommandText, DataSet.DataTable, Parameters, DataSet.Parameters); } } }
private void IMasterDetailForm_SetupData() { foreach (JkDetailDataSet DataSet in IAppHandler.FindControlByType("JkDetailDataSet", this)) { if (!String.IsNullOrWhiteSpace(DataSet.CommandText) && DataSet.LinkToMaster) { DataSet.Parameters.Find(dp => dp.Name == "Id").Value = Parameters.Find(p => p.Name == "Id").Value; if (!String.IsNullOrWhiteSpace(DataSet.CommandText)) { DataSet.DataTable = VTransactionHandler.LoadData(DataSet.CommandText, DataSet.Parameters); DataSet.AddTemporaryColumns(); DataSet.GridView.DataSource = DataSet.DataTable; } //For further update on this code, I'm still not sure if this will fit on all scenarios foreach (DataColumn column in DataSet.DataTable.Columns) { if (!column.AllowDBNull && column.DataType.ToString() == "System.Int32" && !column.AutoIncrement) { if (FormState == FormStates.fsNew) { column.DefaultValue = -1; } else { column.DefaultValue = Parameters.Find(p => p.Name == "Id").Value; } } } } //load data from lookup to grid foreach (DataGridViewColumn column in DataSet.GridView.Columns) { if (column.GetType().ToString().Contains("DataGridViewComboBoxColumn")) { DataGridViewComboBoxColumn comboBox = column as DataGridViewComboBoxColumn; JkLookUpComboBox lookUp = (Controls.Find(DataSet.Columns.Find(dc => dc.Name == column.DataPropertyName).ControlName, true).First() as JkLookUpComboBox); if (lookUp.Items.Count == 0) { lookUp.LoadData(); } comboBox.DataSource = lookUp.DataSource; comboBox.DisplayMember = lookUp.DisplayText; comboBox.ValueMember = lookUp.Key; } } } }
private void EBillsPaymentForm_SetupControl() { dataGridView.AllowUserToAddRows = false; foreach (ToolStripMenuItem item in btnPreview.DropDown.Items) { if (item.Text == "Check") { item.Enabled = HasCheck(); } if (item.Text == "BIR Form 2307") { item.Enabled = Print2307(); } } ShowAmountToApply(); //load journal entry if (FormState == FormStates.fsView) { if (!dstJournalEntry.ZLoadGrid) { dstJournalEntry.ZLoadGrid = true; } dstJournalEntry.Parameters[0].Value = this.MasterColumns.Find(mc => mc.Name == "JournalId").Value.ToString(); dstJournalEntry.DataTable = VTransactionHandler.LoadData(dstJournalEntry.CommandText, dstJournalEntry.Parameters); dataGridViewJournalEntry.DataSource = dstJournalEntry.DataTable; dataGridViewJournalEntry.AutoGenerateColumns = false; tabPageJournalEntry.Text = String.Format("Journal Entry ({0})", dstJournalEntry.DataTable.Rows[0]["TransactionNo"].ToString()); if (!tabControlDetails.TabPages.Contains(tabPageJournalEntry)) { tabControlDetails.TabPages.Insert(1, tabPageJournalEntry); } } else { tabPageJournalEntry.Text = "Journal Entry"; tabControlDetails.TabPages.Remove(tabPageJournalEntry); } }
private bool HasCheck() { bool result = true; SqlCommand Command = new SqlCommand(); SqlParameter Result = new SqlParameter(); Command.CommandType = CommandType.StoredProcedure; Command.CommandText = "uspGetCheckDetails"; Command.Parameters.AddWithValue("@Id", Parameters.Find(p => p.Name == "Id").Value); Result.ParameterName = "@HasCheck"; Result.Direction = ParameterDirection.Output; Result.SqlDbType = SqlDbType.Bit; Command.Parameters.Add(Result); VTransactionHandler.ExecuteStoredProc(Command); result = bool.Parse(Command.Parameters["@HasCheck"].Value.ToString()); return(result); }
private bool Print2307() { bool result = false; SqlCommand Command = new SqlCommand(); SqlParameter Result = new SqlParameter(); Command.CommandType = CommandType.StoredProcedure; Command.CommandText = "uspPrintBIRForm2307"; Command.Parameters.AddWithValue("@Id", Parameters.Find(p => p.Name == "Id").Value); Result.ParameterName = "@Result"; Result.Direction = ParameterDirection.Output; Result.SqlDbType = SqlDbType.Bit; Command.Parameters.Add(Result); VTransactionHandler.ExecuteStoredProc(Command); result = bool.Parse(Command.Parameters["@Result"].Value.ToString()); return(result); }
private void EBillsForm_SetupControl() { txtGrossAmount.Text = double.Parse(txtGrossAmount.Text).ToString("#,##0.00;(#,##0.00)"); txtWTAX.Text = double.Parse(txtWTAX.Text).ToString("#,##0.00;(#,##0.00)"); txtVATAmount.Text = double.Parse(txtVATAmount.Text).ToString("#,##0.00;(#,##0.00)"); txtDiscountAmount.Text = double.Parse(txtDiscountAmount.Text).ToString("#,##0.00;(#,##0.00)"); txtNetAmount.Text = double.Parse(txtNetAmount.Text).ToString("#,##0.00;(#,##0.00)"); txtPaidAmount.Text = double.Parse(txtPaidAmount.Text).ToString("#,##0.00;(#,##0.00)"); txtBalance.Text = (double.Parse(txtNetAmount.Text) - double.Parse(txtPaidAmount.Text)).ToString("#,##0.00;(#,##0.00)"); //load journal entry if (FormState == FormStates.fsView) { if (!dstJournalEntry.ZLoadGrid) { dstJournalEntry.ZLoadGrid = true; } dstJournalEntry.Parameters[0].Value = this.MasterColumns.Find(mc => mc.Name == "JournalId").Value.ToString(); dstJournalEntry.DataTable = VTransactionHandler.LoadData(dstJournalEntry.CommandText, dstJournalEntry.Parameters); if (dataGridViewJournalEntry.DataSource == null) { dataGridViewJournalEntry.DataSource = dstJournalEntry.DataTable; dataGridViewJournalEntry.AutoGenerateColumns = false; } tabPageJournalEntry.Text = String.Format("Journal Entry ({0})", dstJournalEntry.DataTable.Rows[0]["TransactionNo"].ToString()); if (!tabControlDetails.TabPages.Contains(tabPageJournalEntry)) { tabControlDetails.TabPages.Insert(1, tabPageJournalEntry); } } else { tabPageJournalEntry.Text = "Journal Entry"; tabControlDetails.TabPages.Remove(tabPageJournalEntry); } }
private String GetIdentifierHeader() { DataTable table = new DataTable(); String CommandText, result; List <JkFormParameter> param = new List <JkFormParameter>(); CommandText = "SELECT IdentifierColumnName FROM tblSystemLogTableConfig WHERE Caption = @Caption"; param.Add(new JkFormParameter() { Value = this.SubCategory, Name = "Caption" }); table = VTransactionHandler.LoadData(CommandText, param); result = table.Rows[table.Rows.Count - 1][0].ToString(); if (result == "TransactionNo") { result = "Transaction No"; } table.Dispose(); return(result); }
private void AssignEventOnButtons() { btnNew.Click += (obj, e) => { if (!btnNew.Visible || !btnNew.Enabled) { return; } try { IAppHandler.StartBusy("Executing New"); FormState = FormStates.fsNew; Run(); VMasterDataTable.Clear(); foreach (JkDetailDataSet DataSet in IAppHandler.FindControlByType("JkDetailDataSet", this)) { DataSet.DataTable.Clear(); } } finally { IAppHandler.EndBusy("Executing New"); } }; btnEdit.Click += (obj, e) => { if (!btnEdit.Visible || !btnEdit.Enabled) { return; } try { IAppHandler.StartBusy("Executing Edit"); FormState = FormStates.fsEdit; Run(); } finally { IAppHandler.EndBusy("Executing Edit"); } }; btnSave.Click += (obj, e) => { Control focusedControl = IAppHandler.FindFocusedControl(this); if (!btnSave.Visible || !btnSave.Enabled) { return; } //remove focus on databound controls, so that it will perform its validation or computation this.splitContainer.Panel2.Focus(); //perform Validation first OnValidateSave(); if (ValidationFails) { if (focusedControl != null) { focusedControl.Select(); } return; } if (IMessageHandler.Confirm(ISystemMessages.SavingQuestion) == DialogResult.Yes) { try { IAppHandler.StartBusy("Executing Save"); OnBeforeSave(); //this should be called after before save, so that before save can be used on //performing operations before assigning it to MasterColumns SetColumnsValue(); try { try { //all of the events which interacts with the database //should be just put in one connection, so if in case //error occurs all the processes will be rolled back VTransactionHandler.Connect(); VTransactionHandler.BeginTran(); if (FormState == FormStates.fsEdit) { UnPost(); } if (FormState == FormStates.fsNew) { VTransactionHandler.SaveMaster(CommandText, ref VMasterDataTable, Parameters); SaveDetail(); } else if (FormState == FormStates.fsEdit) { VTransactionHandler.EditMaster(CommandText, Parameters); EditDetail(); } Post(); VTransactionHandler.CommitTran(); } catch (Exception ex) { VTransactionHandler.Rollback(); if (FormState == FormStates.fsNew) { IMessageHandler.ShowError(ISystemMessages.SaveDataError + ex.Message); } else { IMessageHandler.ShowError(ISystemMessages.EditDataError + ex.Message); } return; } } finally { VTransactionHandler.Disconnect(); } if (FormState == FormStates.fsNew) { KeyList.Add(Parameters[0].Value); KeyId = KeyList.Count() - 1; } OnAfterSave(); FormState = FormStates.fsView; Run(); } finally { IAppHandler.EndBusy("Executing Save"); } } }; btnCancel.Click += (obj, e) => { if (!btnCancel.Visible || !btnCancel.Enabled) { return; } if (IMessageHandler.Confirm(ISystemMessages.ClosingOrCancellingQuestion) == DialogResult.Yes) { this.splitContainer.Panel2.Focus(); try { IAppHandler.StartBusy("Executing Cancel"); if (FormState == FormStates.fsNew) { if (ParametersHasValues()) { FormState = FormStates.fsView; Run(); } else { CloseForm(); } } else { FormState = FormStates.fsView; Run(); } } finally { IAppHandler.EndBusy("Executing Cancel"); } } }; btnFirstRecord.Click += (obj, e) => { if (!btnFirstRecord.Visible || !btnFirstRecord.Enabled) { return; } ReQuery(obj, e); }; btnPreviousRecord.Click += (obj, e) => { if (!btnPreviousRecord.Visible || !btnPreviousRecord.Enabled) { return; } ReQuery(obj, e); }; btnNextRecord.Click += (obj, e) => { if (!btnNextRecord.Visible || !btnNextRecord.Enabled) { return; } ReQuery(obj, e); }; btnLastRecord.Click += (obj, e) => { if (!btnLastRecord.Visible || !btnLastRecord.Enabled) { return; } ReQuery(obj, e); }; }