private void SetAutoCompleteForSearchField()
{
AutoCompleteStringCollection source = new AutoCompleteStringCollection();
foreach (JkColumn column in Columns)
{
if (column.Visible &&
(column.DataType == SqlDbType.VarChar || column.DataType == SqlDbType.NVarChar))
{
foreach (String data in VMasterDataTable
.AsEnumerable()
.Select <System.Data.DataRow, String>(x => x.Field <String>(column.Name))
.ToArray())
{
if (!source.Contains(data) && !String.IsNullOrWhiteSpace(data))
{
source.Add(data);
}
}
}
}
txtFind.AutoCompleteCustomSource = source;
txtFind.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
txtFind.AutoCompleteSource = AutoCompleteSource.CustomSource;
}
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();
}
}
//This will update the value on MasterColumns and DataTables before performing Save or Edit
private void SetColumnsValue()
{
DataRow row = null;
if (FormState == FormStates.fsNew)
{
row = VMasterDataTable.NewRow();
}
else
{
row = VMasterDataTable.Rows.Find(IAppHandler.ConvertMaskValue(Parameters[0].Value));
row.BeginEdit();
}
foreach (JkMasterColumn col in MasterColumns)
{
if (String.IsNullOrWhiteSpace(col.ControlName))
{
if (!String.IsNullOrWhiteSpace(col.DefaultValue))
{
if ((col.Name == "CreatedById" || col.Name == "DateCreated") && FormState == FormStates.fsEdit)
{
col.Value = col.Value;
}
else
{
col.Value = IAppHandler.ConvertMaskValue(col.DefaultValue);
}
}
}
else
{
col.Value = IAppHandler.GetControlsValue(Controls.Find(col.ControlName, true).First());
}
row[col.Name] = col.Value ?? DBNull.Value;
}
if (FormState == FormStates.fsNew)
{
VMasterDataTable.Rows.Add(row);
}
else
{
row.EndEdit();
}
}
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);
};
}
