/// <summary>
/// F1220_s the account names.
/// </summary>
/// <returns>the datatable contains the Account Names</returns>
public static F1220AccountRegisterData.ListAccountNamesDataTable F1220_AccountNames()
{
F1220AccountRegisterData accountRegisterData = new F1220AccountRegisterData();
Hashtable ht = new Hashtable();
Utility.LoadDataSet(accountRegisterData.ListAccountNames, "f1213_pclst_AccountName", ht);
return(accountRegisterData.ListAccountNames);
}
/// <summary>
/// F1220_s the get reconciled details.
/// </summary>
/// <param name="registerId">The register id.</param>
/// <returns>datatable holds the Reconciled Details</returns>
public static F1220AccountRegisterData.ReconciledDetailsDataTable F1220_GetReconciledDetails(int registerId)
{
F1220AccountRegisterData accountRegisterData = new F1220AccountRegisterData();
Hashtable ht = new Hashtable();
ht.Add("@RegisterID", registerId);
Utility.LoadDataSet(accountRegisterData.ReconciledDetails, "f1220_pcget_ReconciledDetails", ht);
return(accountRegisterData.ReconciledDetails);
}
/// <summary>
/// F1220_s the list account register.
/// </summary>
/// <param name="registerId">The register id.</param>
/// <param name="beginningDate">The beginning date.</param>
/// <returns>datatable contains the Account Register Details</returns>
public static F1220AccountRegisterData.ListAccountRegisterDataTable F1220_ListAccountRegister(int registerId, DateTime beginningDate)
{
F1220AccountRegisterData accountRegisterData = new F1220AccountRegisterData();
Hashtable ht = new Hashtable();
ht.Add("@RegisterID", registerId);
ht.Add("@BeginningDate", beginningDate);
Utility.LoadDataSet(accountRegisterData.ListAccountRegister, "f1220_pclst_AccountRegister", ht);
return(accountRegisterData.ListAccountRegister);
}
/// <summary>
/// Populates the account register details.
/// </summary>
/// <param name="regId">The reg id.</param>
/// <param name="beginDate">The begin date.</param>
private void PopulateAccountRegisterDetails(int regId, DateTime beginDate)
{
int accountRegisterRowCount = 0;
if (this.RegisterId != -1)
{
this.accountRegisterDataSet.ListAccountRegister.Rows.Clear();
this.accountRegisterDataSet = this.form1220Controll.WorkItem.F1220_GetAccountRegisterDetails(regId, beginDate);
this.LastReconciledTextBox.Text = this.accountRegisterDataSet.ReconciledDetails.Rows[0][this.accountRegisterDataSet.ReconciledDetails.LastReconciledDateColumn.ToString()].ToString();
this.beginningBalance = Convert.ToDecimal(this.accountRegisterDataSet.ReconciledDetails.Rows[0][this.accountRegisterDataSet.ReconciledDetails.BeginningBalanceColumn.ToString()]);
this.BeginningBalanceTextBox.Text = this.accountRegisterDataSet.ReconciledDetails.Rows[0][this.accountRegisterDataSet.ReconciledDetails.BeginningBalanceColumn.ToString()].ToString();
this.BeginningDateTextBox.Text = this.accountRegisterDataSet.ReconciledDetails.Rows[0][this.accountRegisterDataSet.ReconciledDetails.BeginningDateColumn.ToString()].ToString();
this.DisplayEndigBalance();
accountRegisterRowCount = this.accountRegisterDataSet.ListAccountRegister.Rows.Count;
////this.TransactionsGridView.DataSource = this.accountRegisterDataSet.ListAccountRegister;
}
else
{
this.ClearFields();
this.accountRegisterDataSet = new F1220AccountRegisterData();
////this.TransactionsGridView.DataSource = this.accountRegisterDataSet.ListAccountRegister;
}
if (accountRegisterRowCount > 0)
{
this.emptyRecord = false;
this.TransactionsGridView.DataSource = this.accountRegisterDataSet.ListAccountRegister;
this.TransactionsGridView.Enabled = true;
this.TransactionsGridView.Rows[0].Selected = true;
this.AccountRegisterAuditLink.Text = SharedFunctions.GetResourceString("1213DepositHistoryAuditLink") + " " + this.TransactionsGridView.Rows[0].Cells[this.accountRegisterDataSet.ListAccountRegister.CLIDColumn.ToString()].Value.ToString();
this.AccountRegisterAuditLink.Enabled = true;
}
else
{
this.emptyRecord = true;
this.TransactionsGridView.DataSource = this.accountRegisterDataSet.ListAccountRegister;
this.TransactionsGridView.CurrentCell = null;
this.TransactionsGridView.Rows[0].Selected = false;
this.TransactionsGridView.Enabled = false;
this.AccountRegisterAuditLink.Text = SharedFunctions.GetResourceString("1213DepositHistoryAuditLink");
this.AccountRegisterAuditLink.Enabled = false;
}
if (accountRegisterRowCount > this.TransactionsGridView.NumRowsVisible)
{
this.TransactionsGridVScrollBar.Visible = false;
}
else
{
this.TransactionsGridVScrollBar.Visible = true;
}
}
/// <summary>
/// F1220_s the get account register details.
/// </summary>
/// <param name="registerId">The register id.</param>
/// <param name="beginningDate">The beginning date.</param>
/// <returns>accountRegister DataSet</returns>
public static F1220AccountRegisterData F1220_GetAccountRegisterDetails(int registerId, DateTime beginningDate)
{
F1220AccountRegisterData accountRegisterData = new F1220AccountRegisterData();
Hashtable ht = new Hashtable();
ht.Add("@RegisterID", registerId);
if (!string.Equals(beginningDate.ToShortDateString(), "1/1/0001"))
{
ht.Add("@BeginningDate", beginningDate);
}
string[] tableName = new string[] { accountRegisterData.ReconciledDetails.TableName, accountRegisterData.ListAccountRegister.TableName };
Utility.LoadDataSet(accountRegisterData, "f1220_pcget_ReconciledDetails", ht, tableName);
return(accountRegisterData);
}
