public GeneralSettingsForm()
{
InitializeComponent();
RBEnablevatNo.Checked = true;
gms = new GeneralSettingsManager();
gs=gms.GetGeneralSettings();
txtbxvatAmount.Text = gs.Vat.ToString();
txtbxCurrency.Text = gs.Currency;
RBenabledVat.Checked = gs.IsVatEnabled;
tempDataSet = new DataSet();
tempDataSet.ReadXml("Config/VatRegisterNo.xml");
txtBoxVatRegistrationID.Text = tempDataSet.Tables[0].Rows[0]["des"].ToString();
}
public CResult GetGeneralSettings()
{
CResult tempResult = new CResult();
string sSql = SqlQueries.GetQuery(Query.GetGeneralSetting);
try
{
this.OpenConnection();
IDataReader oReader = this.ExecuteReader(sSql);
GeneralSettings gSettings = new GeneralSettings();
while (oReader.Read())
{
gSettings.Vat = Convert.ToDouble(oReader[1]);
gSettings.IsVatEnabled = Convert.ToBoolean(oReader[2]);
gSettings.Currency = oReader[3].ToString(); ;
}
tempResult.Data = gSettings;
}
catch (Exception ex)
{
Logger.Write("Exception : " + ex + " in GetGeneralSettings()", LogLevel.Error, "Database");
if (ex.GetType().Equals(typeof(SqlException)))
{
SqlException oSQLEx = ex as SqlException;
if (oSQLEx.Number != 7619)
throw new Exception("Exception occured at GetGeneralSettings()", ex);
}
else
{
throw new Exception("Exception occure at GetGeneralSettings()", ex);
}
}
finally
{
this.CloseConnection();
}
return tempResult;
}