/// <summary>
/// checking checking existance entries for save or edit function
/// </summary>
public void SaveOrEditMessage()
{
try
{
//create ledger for the tax
AccountLedgerSP spAccountLedger = new AccountLedgerSP();
string strTaxNameForLedger = string.Empty;
strTaxNameForLedger = txtTaxName.Text;
if (btnSave.Text == "Save")
{
if (!spAccountLedger.AccountLedgerCheckExistence(strTaxNameForLedger, 0))
{
if (PublicVariables.isMessageAdd)
{
if (Messages.SaveMessage())
{
SaveFunction();
TaxSelectionGridFill();
TaxSearchGridFill();
}
}
else
{
SaveFunction();
TaxSelectionGridFill();
TaxSearchGridFill();
}
}
else
{
Messages.InformationMessage("Cannot save. Ledger already exists");
}
}
else
{
if (!spAccountLedger.AccountLedgerCheckExistence(strTaxNameForLedger, decLedgerId))
{
if (PublicVariables.isMessageEdit)
{
if (Messages.UpdateMessage())
{
EditFunction();
TaxSelectionGridFill();
TaxSearchGridFill();
}
}
else
{
EditFunction();
TaxSelectionGridFill();
TaxSearchGridFill();
}
}
else
{
Messages.InformationMessage("Cannot save. Ledger already exists");
}
}
}
catch (Exception ex)
{
MessageBox.Show("TC6:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// check if data present in database
/// </summary>
/// <returns></returns>
public bool CheckAlreadyExist()
{
bool isOk = true;
try
{
AccountLedgerSP spAccountledger = new AccountLedgerSP();
int inCompleteRow = 0;
int inCurrentindex = 0;
string strMessage = "Row";
foreach (DataGridViewRow dgvRow in dgvMultipleAccountLedger.Rows)
{
if (dgvRow.Cells["dgvtxtLedgerName"].Value != null)
{
string LedgerName = dgvRow.Cells["dgvtxtLedgerName"].Value.ToString();
if (spAccountledger.AccountLedgerCheckExistence(LedgerName, 0) == true)
{
isOk = false;
if (inCompleteRow == 0)
{
strMessage = strMessage + Convert.ToString(dgvRow.Index + 1);
inCurrentindex = dgvRow.Index;
inCompleteRow++;
}
else
{
strMessage = strMessage + ", " + Convert.ToString(dgvRow.Index + 1);
}
}
}
}
if (!isOk)
{
strMessage = strMessage + " contains already exisitng ledgers. Do you want to continue?";
if (MessageBox.Show(strMessage, "OpenMiracle", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.Yes)
{
isOk = true;
for (int inK = 0; inK < dgvMultipleAccountLedger.Rows.Count; inK++)
{
if (dgvMultipleAccountLedger.Rows[inK].Cells["dgvtxtLedgerName"].Value != null)
{
string strLedgerName = dgvMultipleAccountLedger.Rows[inK].Cells["dgvtxtLedgerName"].Value.ToString().Trim();
if (spAccountledger.AccountLedgerCheckExistence(strLedgerName, 0) == true)
{
if (!dgvMultipleAccountLedger.Rows[inK].IsNewRow)
{
dgvMultipleAccountLedger.Rows.RemoveAt(inK);
inK--;
}
}
}
}
}
else
{
dgvMultipleAccountLedger.Rows[inCurrentindex].Cells["dgvtxtLedgerName"].Selected = true;
dgvMultipleAccountLedger.CurrentCell = dgvMultipleAccountLedger.Rows[inCurrentindex].Cells["dgvtxtLedgerName"];
dgvMultipleAccountLedger.Focus();
}
}
}
catch (Exception ex)
{
MessageBox.Show("MAL5:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
return isOk;
}