private void CurrSubmit_Click(object sender, EventArgs e)
{
try
{
int id = int.Parse(CurrID.Text);
string sqlString = "SELECT * FROM CURRENCYTABLE WHERE ID =" + id;
using (DigiDapter dg = new DigiDapter(sqlString))
{
if (!dg.HasRows)
{
}
dg.Add("CURRENCY", CurrName.Text);
dg.Add("CURRENCYSYMBOL", CurrSymbol.Text);
dg.Add("CHANGETOEURO", StaticFunctions.FixDecimal(CurrChange1.Text));
dg.Add("CHANGEFROMEURO", StaticFunctions.FixDecimal(CurrChange2.Text));
dg.Execute("CURRENCYTABLE", "ID=" + id);
}
CurrencyRepeater.DataSource = DatabaseConnection.CreateDataset("SELECT * FROM CURRENCYTABLE").Tables[0];
CurrencyRepeater.DataBind();
CancelForm();
Start();
}
catch
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + Root.rm.GetString("Curtxt12") + "');</script>");
}
}
private void Start()
{
CurrSubmit.Text = Root.rm.GetString("Save");
NewCurrSubmit.Text = Root.rm.GetString("Save");
CurrChange1.Attributes.Add("onchange", "change(0)");
CurrChange2.Attributes.Add("onchange", "change(1)");
CancelForm();
CurrencyRepeater.DataSource = DatabaseConnection.CreateDataset("SELECT * FROM CURRENCYTABLE").Tables[0];
CurrencyRepeater.DataBind();
CurrencyRepeater.Visible = true;
currencyTable.Visible = true;
currencySymbol.Text = DatabaseConnection.SqlScalar("SELECT CURRENCY FROM CURRENCYTABLE WHERE (CHANGETOEURO=1 AND CHANGEFROMEURO=1)");
ChangeCurrency.Text = Root.rm.GetString("Curtxt7");
companyCurrencyTable.Visible = false;
}
