protected void dgvCurrency_OnRowDeleting(object sender, GridViewDeleteEventArgs e)
{
if (dgvCurrency.Rows[e.RowIndex].Cells[9].Text != "False")
{
Utilities.editId = int.Parse(dgvCurrency.DataKeys[e.RowIndex].Value.ToString());
string _txtName = dgvCurrency.Rows[e.RowIndex].Cells[1].Text;
string _txtSymbol = HttpUtility.HtmlDecode(dgvCurrency.Rows[e.RowIndex].Cells[2].Text);
string _txtISO = dgvCurrency.Rows[e.RowIndex].Cells[3].Text;
string _txtUnit = dgvCurrency.Rows[e.RowIndex].Cells[4].Text;
string _txtSubUnit = dgvCurrency.Rows[e.RowIndex].Cells[5].Text;
string _txtUnitSingle = dgvCurrency.Rows[e.RowIndex].Cells[6].Text;
string _txtSubUnitSngle = dgvCurrency.Rows[e.RowIndex].Cells[7].Text;
bool _chkBaseCurrency = bool.Parse(dgvCurrency.Rows[e.RowIndex].Cells[8].Text);
CurrencyDataSet curr = new CurrencyDataSet();
curr.Currency.AddCurrencyRow(_txtName, _txtSymbol, _txtISO, _txtUnit, _txtSubUnit, _txtUnitSingle,
_txtSubUnitSngle,
_chkBaseCurrency, false, Utilities.editId);
dataProvider.UpdateCurrency(userToken, curr, orgId);
SetToast("success", "Currency deactivated succesfully");
}
else
{
SetToast("info", "Currency already deactivated");
}
DisplayCurrenciesInGrid();
}
protected void btnSaveUser_OnClick(object sender, EventArgs e)
{
var currencyDS = new CurrencyDataSet();
string _symbol = HttpUtility.HtmlDecode(txtSymbol.Text);
currencyDS.Currency.AddCurrencyRow(txtName.Text, _symbol, txtISO.Text, txtUnit.Text, txtSubUnit.Text
, txtUnitSingle.Text, txtSubUnitSngle.Text, chkBaseCurrency.Checked, chkActive.Checked, Utilities.editId);
if (Utilities.editId != -1)
{
int result = dataProvider.UpdateCurrency(Utilities.userToken, currencyDS, orgId);
if (result != -1)
{
SetToast("success", "Currency has been succesfully updated");
Utilities.editId = -1;
btnCloseModal_OnClick(sender, e);
}
else
{
SetToast("error", "Currency already exists");
}
}
else
{
if (!Utilities.CheckGridForText(dgvCurrency, txtName.Text))
{
int result = dataProvider.AddCurrency(Utilities.userToken, currencyDS, orgId);
if (result != -1)
{
Utilities.editId = -1;
SetToast("success", "Currency was created successfully.");
}
else
{
SetToast("error", "An error has occured, try again.");
}
}
else
{
SetToast("info", "Currency already exists");
}
DisplayCurrenciesInGrid();
}
DisplayCurrenciesInGrid();
}
protected void btnSaveUser_OnClick(object sender, EventArgs e)
{
var currencyDS = new CurrencyDataSet();
string _symbol = HttpUtility.HtmlDecode(txtSymbol.Text);
currencyDS.Currency.AddCurrencyRow(txtName.Text, _symbol, txtISO.Text, txtUnit.Text, txtSubUnit.Text
, txtUnitSingle.Text, txtSubUnitSngle.Text, chkBaseCurrency.Checked, chkActive.Checked, Utilities.editId);
if (Utilities.editId != -1)
{
int result = dataProvider.UpdateCurrency(Utilities.userToken, currencyDS, orgId);
if (result != -1)
{
SetToast("success", "Currency has been succesfully updated");
Utilities.editId = -1;
btnCloseModal_OnClick(sender, e);
}
else
{
SetToast("error", "Currency already exists");
}
}
else
{
if (!Utilities.CheckGridForText(dgvCurrency, txtName.Text))
{
int result = dataProvider.AddCurrency(Utilities.userToken, currencyDS, orgId);
if (result != -1)
{
Utilities.editId = -1;
SetToast("success", "Currency was created successfully.");
}
else
{
SetToast("error", "An error has occured, try again.");
}
}
else
{
SetToast("info", "Currency already exists");
}
DisplayCurrenciesInGrid();
}
DisplayCurrenciesInGrid();
}
protected void dgvCurrency_OnRowDeleting(object sender, GridViewDeleteEventArgs e)
{
if (dgvCurrency.Rows[e.RowIndex].Cells[9].Text != "False")
{
Utilities.editId = int.Parse(dgvCurrency.DataKeys[e.RowIndex].Value.ToString());
string _txtName = dgvCurrency.Rows[e.RowIndex].Cells[1].Text;
string _txtSymbol = HttpUtility.HtmlDecode(dgvCurrency.Rows[e.RowIndex].Cells[2].Text);
string _txtISO = dgvCurrency.Rows[e.RowIndex].Cells[3].Text;
string _txtUnit = dgvCurrency.Rows[e.RowIndex].Cells[4].Text;
string _txtSubUnit = dgvCurrency.Rows[e.RowIndex].Cells[5].Text;
string _txtUnitSingle = dgvCurrency.Rows[e.RowIndex].Cells[6].Text;
string _txtSubUnitSngle = dgvCurrency.Rows[e.RowIndex].Cells[7].Text;
bool _chkBaseCurrency = bool.Parse(dgvCurrency.Rows[e.RowIndex].Cells[8].Text);
CurrencyDataSet curr = new CurrencyDataSet();
curr.Currency.AddCurrencyRow(_txtName, _txtSymbol, _txtISO, _txtUnit, _txtSubUnit, _txtUnitSingle,
_txtSubUnitSngle,
_chkBaseCurrency, false, Utilities.editId);
dataProvider.UpdateCurrency(userToken,curr,orgId);
SetToast("success", "Currency deactivated succesfully");
}
else
{
SetToast("info", "Currency already deactivated");
}
DisplayCurrenciesInGrid();
}
public CurrencyDataSet GetActiveCurrencyByOrgId(string userToken, int orgId)
{
var retDataset = new CurrencyDataSet();
if (IsUserTokenValid(userToken))
{
try
{
if (conn.State != System.Data.ConnectionState.Open) { conn.Open(); }
SqlCommand cmd = conn.CreateCommand();
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "spGetActiveCurrencyByOrgId";
var p = new SqlParameter("orgId", orgId);
cmd.Parameters.Add(p);
SqlDataReader reader = cmd.ExecuteReader();
if (reader != null)
{
while (reader.Read())
{
var sysParam = retDataset.Currency.NewCurrencyRow();
sysParam.Id = int.Parse(reader["Id"].ToString());
sysParam.Name = reader["Name"].ToString();
sysParam.Symbol = reader["Symbol"].ToString();
sysParam.ISOCode = reader["ISOCode"].ToString();
sysParam.UnitName = reader["UnitName"].ToString();
sysParam.SubUnitName = reader["SubUnitName"].ToString();
sysParam.UnitNameSingle = reader["UnitNameSingle"].ToString();
sysParam.SubUnitNameSingle = reader["SubUnitNameSingle"].ToString();
sysParam.BaseCurrency = bool.Parse(reader["BaseCurrency"].ToString());
sysParam.Active = bool.Parse(reader["Active"].ToString());
retDataset.Currency.AddCurrencyRow(sysParam);
}
reader.Close();
}
}
catch (Exception ex)
{
throw new OperationFailedException(ex.Message, ex);
}
finally
{
if (conn.State != System.Data.ConnectionState.Closed)
{
conn.Close();
}
}
}
return retDataset;
}
public int UpdateCurrency(string userToken, CurrencyDataSet sysParameter, int orgId)
{
int newId = -1;
if (IsUserTokenValid(userToken))
{
try
{
if (conn.State != System.Data.ConnectionState.Open) { conn.Open(); }
SqlCommand cmd = conn.CreateCommand();
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "spUpdateCurrency";
var p2 = new SqlParameter[12];
for (int i = 0; i < 12; i++)
p2[i] = new SqlParameter();
p2[0] = new SqlParameter("name", sysParameter.Currency[0].Name);
p2[1] = new SqlParameter("symbol", sysParameter.Currency[0].Symbol);
p2[2] = new SqlParameter("iso_code", sysParameter.Currency[0].ISOCode);
p2[3] = new SqlParameter("unitName", sysParameter.Currency[0].UnitName);
p2[4] = new SqlParameter("subUnitName", sysParameter.Currency[0].SubUnitName);
p2[5] = new SqlParameter("unitNameSingle", sysParameter.Currency[0].UnitNameSingle);
p2[6] = new SqlParameter("subUnitNameSingle", sysParameter.Currency[0].SubUnitNameSingle);
p2[7] = new SqlParameter("baseCurrency", sysParameter.Currency[0].BaseCurrency);
p2[8] = new SqlParameter("active", sysParameter.Currency[0].Active);
p2[9] = new SqlParameter("updateUser", _userId);
p2[10] = new SqlParameter("id", sysParameter.Currency[0].Id);
p2[11] = new SqlParameter("orgId", orgId);
cmd.Parameters.AddRange(p2);
newId = int.Parse(cmd.ExecuteScalar().ToString());
if (conn.State != System.Data.ConnectionState.Closed)
{
conn.Close();
}
//SetInterestsForEvent(newId, interests);
}
catch (Exception ex)
{
throw new OperationFailedException(ex.Message, ex);
}
finally
{
if (conn.State != System.Data.ConnectionState.Closed)
{
conn.Close();
}
}
}
return newId;
}
