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);
};
}
