public Boolean insertTaxCode(taxcode tc)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "insert into TaxCode (TaxCode,Description,Status,CreateTime,CreateUser)" +
"values (" +
"'" + tc.TaxCode + "'," +
"'" + tc.Description + "'," +
tc.status + "," +
"GETDATE()" + "," +
"'" + Login.userLoggedIn + "'" + ")";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("insert", "TaxCode", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
}
return(status);
}
public List <taxcode> getTaxCode()
{
taxcode tc;
List <taxcode> TaxCodes = new List <taxcode>();
try
{
SqlConnection conn = new SqlConnection(Login.connString);
string query = "select TaxCode, Description,status " +
"from Taxcode order by Taxcode";
SqlCommand cmd = new SqlCommand(query, conn);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
tc = new taxcode();
tc.TaxCode = reader.GetString(0);
tc.Description = reader.GetString(1);
tc.status = reader.GetInt32(2);
TaxCodes.Add(tc);
}
conn.Close();
}
catch (Exception)
{
MessageBox.Show("Error querying Tax Code");
}
return(TaxCodes);
}
public Boolean updateTaxCode(taxcode tc)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update TaxCode set Description='" + tc.Description +
"', Status=" + tc.status +
" where TaxCode='" + tc.TaxCode + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "TaxCode", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
}
return(status);
}
public Boolean validateTaxCode(taxcode tc)
{
Boolean status = true;
try
{
if (tc.TaxCode.Trim().Length == 0 || tc.TaxCode == null)
{
return(false);
}
if (tc.Description.Trim().Length == 0 || tc.Description == null)
{
return(false);
}
}
catch (Exception)
{
}
return(status);
}