protected void cboType_SelectedIndexChanged(object sender, EventArgs e)
{
clsChartofAccounts chart = new clsChartofAccounts();
txtDescription.Text = "";
cboType.Text = cboType.SelectedValue.Substring(0, 2);
if (cboType.Text == "EXP")
{
txtCode.Text = chart.FindRecKount(cboType.Text).ToString();
}
if (cboType.Text == "INC")
{
txtCode.Text = chart.FindRecKount(cboType.Text).ToString();
}
}
protected void cmdDelete_Click(object sender, EventArgs e)
{
clsChartofAccounts DB = new clsChartofAccounts();
try
{
//Validate values
if (txtCode == null)
{
lblResults.Text = "Customer id cannot be empty";
}
if (txtCode.GetType() != typeof(int))
{
lblResults.Text = "Code must be a whole number";
}
if (cboType == null)
{
lblResults.Text = "Account type cannot be empty";
}
if (cboType.GetType() != typeof(string))
{
lblResults.Text = "Account type must be valid";
}
if (txtDescription == null)
{
lblResults.Text = "Particulars cannot be empty";
}
if (cboType.GetType() != typeof(string))
{
lblResults.Text = "Particulars must be valid";
}
//string reccount = "";
//reccount = DB.FindRecKount(cboType.Text);
//if (reccount > 0)
//{
// lblResults.Text = "Record already exists!!!";
// return;
//}
DB.Delete_rec(int.Parse(txtCode.Text), cboType.Text, txtDescription.Text);
//public string Add_rec(String txtCustomerid, String txtCustomerName, String txtAddress,String txtTelephoneNo) Define the ADO.NET objects.
//string connectionString =
//connectionString = WebConfigurationManager.ConnectionStrings["FleetConnectionString"].ConnectionString;
//string selectSQL = "SELECT * FROM tb_Customer ORDER BY convert(int,customerno)";
//SqlConnection con = new SqlConnection(connectionString);
//SqlCommand cmd = new SqlCommand(selectSQL, con);
//SqlDataAdapter adapter = new SqlDataAdapter(cmd);
// Fill the DataSet.
DataSet ds = new DataSet();
ds = DB.FindTable();
//adapter.Fill(ds, "tb_Customer");
// Perform the binding.
GridView1.DataSource = ds;
GridView1.DataBind();
lblResults.Text = "Operation successful";
txtCode.Text = "0";
cboType.Text = "";
txtDescription.Text = "";
return;
}
catch (Exception err)
{
EventLog log = new EventLog();
log.Source = "Milorry Frontend";
log.WriteEntry(err.Message, EventLogEntryType.Error);
return;
}
finally
{
//con.Close();
}
}