public List <taxcodeworking> getTaxCodeDetails()
{
taxcodeworking tcw;
List <taxcodeworking> TaxCodeWorkings = new List <taxcodeworking>();
try
{
SqlConnection conn = new SqlConnection(Login.connString);
string query = "select taxcode,operator,operatorValue,TaxItemName,SUBSTRING(TaxItemName,0,CHARINDEX('-',TaxItemName)) TaxItem" +
" from TaxCodeWorking " +
" where operator='Percentage' order by Taxcode";
////" where Taxcode='" + TaxCode + "' and operator='Percentage' order by Taxcode";
SqlCommand cmd = new SqlCommand(query, conn);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
tcw = new taxcodeworking();
tcw.TaxCode = reader.GetString(0);
tcw.Operator = reader.GetString(1);
tcw.OperatorValue = reader.GetDouble(2);
tcw.TaxItemName = reader.GetString(4);
TaxCodeWorkings.Add(tcw);
}
conn.Close();
}
catch (Exception)
{
MessageBox.Show("Error Getting tax code details");
}
return(TaxCodeWorkings);
}
public List <taxcodeworking> getTaxCodeWorkings(string TaxCode)
{
taxcodeworking tcw;
List <taxcodeworking> TaxCodeWorkings = new List <taxcodeworking>();
try
{
SqlConnection conn = new SqlConnection(Login.connString);
string query = "select TaxCode, [LineNo],Description,Operator,OperandLine1,OperandLine2,OperatorValue," +
"Amount, TaxItemName,status " +
"from TaxcodeWorking where Taxcode='" + TaxCode + "' order by Taxcode";
SqlCommand cmd = new SqlCommand(query, conn);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
tcw = new taxcodeworking();
tcw.TaxCode = reader.GetString(0);
tcw.LineNo = reader.GetInt32(1);
tcw.Description = reader.GetString(2);
tcw.Operator = reader.GetString(3);
tcw.OperandLine1 = reader.GetInt32(4);
tcw.OperandLine2 = reader.GetInt32(5);
tcw.OperatorValue = reader.GetDouble(6);
tcw.Amount = reader.GetDouble(7);
tcw.TaxItemName = reader.GetString(8);
tcw.status = reader.GetInt32(9);
TaxCodeWorkings.Add(tcw);
}
conn.Close();
}
catch (Exception)
{
MessageBox.Show("Error querying Tax Code Workings");
}
return(TaxCodeWorkings);
}