/// <summary>
/// Function to Update values in TaxDetails Table
/// </summary>
/// <param name="taxdetailsinfo"></param>
public void TaxDetailsEdit(TaxDetailsInfo taxdetailsinfo)
{
try
{
if (sqlcon.State == ConnectionState.Closed)
{
sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("TaxDetailsEdit", sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam = new SqlParameter();
sprmparam = sccmd.Parameters.Add("@taxdetailsId", SqlDbType.Decimal);
sprmparam.Value = taxdetailsinfo.TaxdetailsId;
sprmparam = sccmd.Parameters.Add("@taxId", SqlDbType.Decimal);
sprmparam.Value = taxdetailsinfo.TaxId;
sprmparam = sccmd.Parameters.Add("@selectedtaxId", SqlDbType.Decimal);
sprmparam.Value = taxdetailsinfo.SelectedtaxId;
sprmparam = sccmd.Parameters.Add("@extraDate", SqlDbType.DateTime);
sprmparam.Value = taxdetailsinfo.ExtraDate;
sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar);
sprmparam.Value = taxdetailsinfo.Extra1;
sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar);
sprmparam.Value = taxdetailsinfo.Extra2;
sccmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
sqlcon.Close();
}
}
/// <summary>
/// Function to Update values in TaxDetails Table
/// </summary>
/// <param name="taxdetailsinfo"></param>
public void TaxDetailsEdit(TaxDetailsInfo taxdetailsinfo)
{
try
{
if (sqlcon.State == ConnectionState.Closed)
{
sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("TaxDetailsEdit", sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam = new SqlParameter();
sprmparam = sccmd.Parameters.Add("@taxdetailsId", SqlDbType.Decimal);
sprmparam.Value = taxdetailsinfo.TaxdetailsId;
sprmparam = sccmd.Parameters.Add("@taxId", SqlDbType.Decimal);
sprmparam.Value = taxdetailsinfo.TaxId;
sprmparam = sccmd.Parameters.Add("@selectedtaxId", SqlDbType.Decimal);
sprmparam.Value = taxdetailsinfo.SelectedtaxId;
sprmparam = sccmd.Parameters.Add("@extraDate", SqlDbType.DateTime);
sprmparam.Value = taxdetailsinfo.ExtraDate;
sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar);
sprmparam.Value = taxdetailsinfo.Extra1;
sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar);
sprmparam.Value = taxdetailsinfo.Extra2;
sccmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
sqlcon.Close();
}
}
/// <summary>
/// Function to get particular values from TaxDetails Table based on the parameter
/// </summary>
/// <param name="taxdetailsId"></param>
/// <returns></returns>
public TaxDetailsInfo TaxDetailsView(decimal taxdetailsId)
{
TaxDetailsInfo taxdetailsinfo = new TaxDetailsInfo();
SqlDataReader sdrreader = null;
try
{
if (sqlcon.State == ConnectionState.Closed)
{
sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("TaxDetailsView", sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam = new SqlParameter();
sprmparam = sccmd.Parameters.Add("@taxdetailsId", SqlDbType.Decimal);
sprmparam.Value = taxdetailsId;
sdrreader = sccmd.ExecuteReader();
while (sdrreader.Read())
{
taxdetailsinfo.TaxdetailsId = decimal.Parse(sdrreader[0].ToString());
taxdetailsinfo.TaxId = decimal.Parse(sdrreader[1].ToString());
taxdetailsinfo.SelectedtaxId = decimal.Parse(sdrreader[2].ToString());
taxdetailsinfo.ExtraDate = DateTime.Parse(sdrreader[3].ToString());
taxdetailsinfo.Extra1 = sdrreader[4].ToString();
taxdetailsinfo.Extra2 = sdrreader[5].ToString();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
sdrreader.Close();
sqlcon.Close();
}
return(taxdetailsinfo);
}
/// <summary>
/// Function to get particular values from TaxDetails Table based on the parameter
/// </summary>
/// <param name="taxdetailsId"></param>
/// <returns></returns>
public TaxDetailsInfo TaxDetailsView(decimal taxdetailsId)
{
TaxDetailsInfo taxdetailsinfo = new TaxDetailsInfo();
SqlDataReader sdrreader = null;
try
{
if (sqlcon.State == ConnectionState.Closed)
{
sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("TaxDetailsView", sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam = new SqlParameter();
sprmparam = sccmd.Parameters.Add("@taxdetailsId", SqlDbType.Decimal);
sprmparam.Value = taxdetailsId;
sdrreader = sccmd.ExecuteReader();
while (sdrreader.Read())
{
taxdetailsinfo.TaxdetailsId = decimal.Parse(sdrreader[0].ToString());
taxdetailsinfo.TaxId = decimal.Parse(sdrreader[1].ToString());
taxdetailsinfo.SelectedtaxId = decimal.Parse(sdrreader[2].ToString());
taxdetailsinfo.ExtraDate = DateTime.Parse(sdrreader[3].ToString());
taxdetailsinfo.Extra1 = sdrreader[4].ToString();
taxdetailsinfo.Extra2 = sdrreader[5].ToString();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
sdrreader.Close();
sqlcon.Close();
}
return taxdetailsinfo;
}
/// <summary>
/// delete function
/// </summary>
public void Delete()
{
try
{
if (PublicVariables.isMessageDelete)
{
if (Messages.DeleteMessage())
{
TaxInfo infoTax = new TaxInfo();
TaxSP spTax = new TaxSP();
TaxDetailsInfo infoTaxDetails = new TaxDetailsInfo();
TaxDetailsSP spTaxDetails = new TaxDetailsSP();
AccountLedgerSP spAccountLedger = new AccountLedgerSP();
bool isExist = spTax.TaxReferenceCheck(decTaxId);
if (!isExist)
{
if ((spTax.TaxReferenceDelete(decTaxId,decLedgerId)) == -1)
{
Messages.ReferenceExistsMessage();
}
else
{
spTaxDetails.TaxDetailsDeleteWithTaxId(decTaxId);
spAccountLedger.AccountLedgerDelete(decLedgerId);
Messages.DeletedMessage();
TaxSearchGridFill();
TaxSelectionGridFill();
Clear();
SearchClear();
}
}
else
{
Messages.ReferenceExistsMessage();
}
}
}
else
{
TaxInfo infoTax = new TaxInfo();
TaxSP spTax = new TaxSP();
TaxDetailsInfo infoTaxDetails = new TaxDetailsInfo();
TaxDetailsSP spTaxDetails = new TaxDetailsSP();
bool isExist = spTax.TaxReferenceCheck(decTaxId);
if (!isExist)
{
if ((spTax.TaxReferenceDelete(decTaxId,decLedgerId)) == -1)
{
Messages.ReferenceExistsMessage();
}
else
{
spTaxDetails.TaxDetailsDeleteWithTaxId(decTaxId);
Messages.DeletedMessage();
TaxSearchGridFill();
TaxSelectionGridFill();
Clear();
SearchClear();
}
}
else
{
Messages.ReferenceExistsMessage();
}
}
}
catch (Exception ex)
{
MessageBox.Show("TC11:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// fill the curresponding details for update
/// </summary>
public void TaxSelectionFillForUpdate()
{
try
{
int inRowCount = dgvTaxSelection.RowCount;
for (int i = 0; i < inRowCount; i++)
{
dgvTaxSelection.Rows[i].Cells["dgvcbxSelect"].Value = false;
}
decTaxId = Convert.ToDecimal(dgvTaxSearch.CurrentRow.Cells["dgvtxtTaxIdSearch"].Value.ToString());
TaxInfo infoTax = new TaxInfo();
TaxSP spTax = new TaxSP();
TaxDetailsInfo infoTaxDetails = new TaxDetailsInfo();
TaxDetailsSP spTaxDetails = new TaxDetailsSP();
infoTax = spTax.TaxView(decTaxId);
txtTaxName.Text = infoTax.TaxName;
txtRate.Text = infoTax.Rate.ToString();
cmbApplicableFor.Text = infoTax.ApplicableOn;
cmbCalculationMode.Text = infoTax.CalculatingMode;
txtNarration.Text = infoTax.Narration;
if (infoTax.IsActive.ToString() == "True")
{
cbxActive.Checked = true;
}
else
{
cbxActive.Checked = false;
}
strTaxName = infoTax.TaxName;
decTaxIdForEdit = infoTax.TaxId;
btnSave.Text = "Update";
btnDelete.Enabled = true;
DataTable dtbl = new DataTable();
dtbl = spTax.TaxIdForTaxSelectionUpdate(decTaxId);
foreach (DataRow dr in dtbl.Rows)
{
string strTaxId = dr["selectedtaxId"].ToString();
for (int i = 0; i < inRowCount; i++)
{
if (dgvTaxSelection.Rows[i].Cells["dgvtxtTaxId"].Value.ToString() == strTaxId)
{
dgvTaxSelection.Rows[i].Cells["dgvcbxSelect"].Value = true;
}
}
}
AccountLedgerSP spAccountLedger = new AccountLedgerSP();
decLedgerId = spAccountLedger.AccountLedgerIdGetByName(txtTaxName.Text);
}
catch (Exception ex)
{
MessageBox.Show("TC10:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// update function
/// </summary>
public void EditFunction()
{
try
{
TaxInfo infoTax = new TaxInfo();
TaxSP spTax = new TaxSP();
TaxDetailsInfo infoTaxDetails = new TaxDetailsInfo();
TaxDetailsSP spTaxDetails = new TaxDetailsSP();
infoTax.TaxName = txtTaxName.Text.Trim();
infoTax.Rate = Convert.ToDecimal(txtRate.Text.ToString());
infoTax.ApplicableOn = cmbApplicableFor.SelectedItem.ToString();
if (cmbCalculationMode.Enabled != true)
{
infoTax.CalculatingMode = string.Empty;
}
else
{
infoTax.CalculatingMode = cmbCalculationMode.SelectedItem.ToString();
}
infoTax.Narration = txtNarration.Text.Trim();
if (cbxActive.Checked)
{
infoTax.IsActive = true;
}
else
{
infoTax.IsActive = false;
}
infoTax.Extra1 = string.Empty;
infoTax.Extra2 = string.Empty;
if (txtTaxName.Text.ToString() != strTaxName)
{
if (spTax.TaxCheckExistence(decTaxIdForEdit, txtTaxName.Text.Trim()) == false)
{
infoTax.TaxId = decTaxId;
spTax.TaxEdit(infoTax);
//-- Delete And Add Tax details --//
spTaxDetails.TaxDetailsDeleteWithTaxId(decTaxId);
if (dgvTaxSelection.RowCount > 0)
{
bool isOk = false;
foreach (DataGridViewRow dgvRow in dgvTaxSelection.Rows)
{
isOk = Convert.ToBoolean(dgvRow.Cells["dgvcbxSelect"].Value);
if (isOk)
{
infoTaxDetails.TaxId = decTaxId;
infoTaxDetails.SelectedtaxId = Convert.ToDecimal(dgvRow.Cells["dgvtxtTaxId"].Value.ToString());//dgvRow.Cells[0].Value.ToString();
infoTaxDetails.ExtraDate = DateTime.Now;
infoTaxDetails.Extra1 = string.Empty;
infoTaxDetails.Extra2 = string.Empty;
spTaxDetails.TaxDetailsAddWithoutId(infoTaxDetails);
}
}
}
LedgerEdit();
Messages.UpdatedMessage();
Clear();
}
else
{
Messages.InformationMessage(" Tax or ledger already exist");
txtTaxName.Focus();
}
}
else
{
infoTax.TaxId = decTaxId;
spTax.TaxEdit(infoTax);
spTaxDetails.TaxDetailsDeleteWithTaxId(decTaxId);
if (dgvTaxSelection.RowCount > 0)
{
bool isOk = false;
foreach (DataGridViewRow dgvRow in dgvTaxSelection.Rows)
{
isOk = Convert.ToBoolean(dgvRow.Cells["dgvcbxSelect"].Value);
if (isOk)
{
infoTaxDetails.TaxId = decTaxId;
infoTaxDetails.SelectedtaxId = Convert.ToDecimal(dgvRow.Cells["dgvtxtTaxId"].Value.ToString());//dgvRow.Cells[0].Value.ToString();
infoTaxDetails.ExtraDate = DateTime.Now;
infoTaxDetails.Extra1 = string.Empty;
infoTaxDetails.Extra2 = string.Empty;
spTaxDetails.TaxDetailsAddWithoutId(infoTaxDetails);
}
}
}
LedgerEdit();
Messages.UpdatedMessage();
Clear();
}
}
catch (Exception ex)
{
MessageBox.Show("TC5:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// save function
/// </summary>
public void SaveFunction()
{
try
{
TaxInfo infoTax = new TaxInfo();
TaxSP spTax = new TaxSP();
TaxDetailsInfo infoTaxDetails = new TaxDetailsInfo();
TaxDetailsSP spTaxDetails = new TaxDetailsSP();
infoTax.TaxName = txtTaxName.Text.Trim();
infoTax.Rate = Convert.ToDecimal(txtRate.Text.ToString());
infoTax.ApplicableOn = cmbApplicableFor.SelectedItem.ToString();
if (cmbCalculationMode.Enabled != true)
{
infoTax.CalculatingMode = string.Empty;
}
else
{
infoTax.CalculatingMode = cmbCalculationMode.SelectedItem.ToString();
}
infoTax.Narration = txtNarration.Text.Trim();
if (cbxActive.Checked)
{
infoTax.IsActive = true;
}
else
{
infoTax.IsActive = false;
}
infoTax.Extra1 = string.Empty;
infoTax.Extra2 = string.Empty;
if (spTax.TaxCheckExistence(0, txtTaxName.Text.Trim()) == false)
{
decTaxId = spTax.TaxAddWithIdentity(infoTax);
decIdForOtherForms = decTaxId;
if (dgvTaxSelection.RowCount > 0)
{
bool isOk = false;
foreach (DataGridViewRow dgvRow in dgvTaxSelection.Rows)
{
isOk = Convert.ToBoolean(dgvRow.Cells["dgvcbxSelect"].Value);
if (isOk)
{
infoTaxDetails.TaxId = decTaxId;
infoTaxDetails.SelectedtaxId = Convert.ToDecimal(dgvRow.Cells["dgvtxtTaxId"].Value.ToString());//dgvRow.Cells[0].Value.ToString();
infoTaxDetails.ExtraDate = DateTime.Now;
infoTaxDetails.Extra1 = string.Empty;
infoTaxDetails.Extra2 = string.Empty;
spTaxDetails.TaxDetailsAddWithoutId(infoTaxDetails);
}
}
}
CreateLedger();
Messages.SavedMessage();
Clear();
SearchClear();
}
else
{
Messages.InformationMessage(" Tax or ledger already exist");
txtTaxName.Focus();
}
if (frmProductCreationObj != null)
{
this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show("TC4:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}