public IEnumerable <Vat> GetVats() { List <Vat> vats = new List <Vat>(); using (SqlConnection con = new SqlConnection(DbCon.connection)) { SqlCommand cmd = new SqlCommand("Select * from tblVat", con); if (con.State == ConnectionState.Closed) { con.Open(); } SqlDataReader reader = cmd.ExecuteReader(); if (!reader.HasRows) { return(null); } while (reader.Read()) { Vat vat = new Vat(); vat.VatCd = reader["VatCd"].ToString(); vat.VatPercentage = Convert.ToDecimal(reader["VatPercentage"]); vats.Add(vat); } } return(vats); }
public Vat GetVat(string Vatcode) { Vat vat = new Vat(); using (SqlConnection con = new SqlConnection(DbCon.connection)) { string query = "Select * from tblVat where VatCd = @VatCd"; SqlCommand cmd = new SqlCommand(query, con); cmd.Parameters.AddWithValue("@VatCd", Vatcode); try { if (con.State == ConnectionState.Closed) { con.Open(); } SqlDataReader rdr = cmd.ExecuteReader(); if (!rdr.HasRows) { return(null); } while (rdr.Read()) { vat.VatCd = rdr["VatCd"].ToString(); vat.VatPercentage = Convert.ToDecimal(rdr["VatPercentage"]); } return(vat); } catch (Exception exe) { MessageBox.Show(exe.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return(null); } } }
public bool AddVat(Vat vat) { using (SqlConnection con = new SqlConnection(DbCon.connection)) { try { string query = "Insert into tblVat(VatCd,VatPercentage,CreatedBy) values(@VatCd,@VatPercentage,@CreatedBy)"; SqlCommand sql = new SqlCommand(query, con); sql.Parameters.AddWithValue("@VatCd", vat.VatCd); sql.Parameters.AddWithValue("@VatPercentage", vat.VatPercentage); sql.Parameters.AddWithValue("@CreatedBy", vat.CreatedBy); try { if (con.State == ConnectionState.Closed) { con.Open(); } SqlTransaction transaction = con.BeginTransaction(); sql.Transaction = transaction; try { sql.ExecuteNonQuery(); transaction.Commit(); return(true); } catch (Exception) { transaction.Rollback(); return(false); } } catch (Exception exe) { MessageBox.Show(exe.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } } catch (Exception) { throw; } } }
public bool EditVat(Vat vat) { using (SqlConnection con = new SqlConnection(DbCon.connection)) { SqlCommand cmd = new SqlCommand("EditVat", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@VatCd", vat.VatCd); cmd.Parameters.AddWithValue("@VatPercentage", vat.VatPercentage); if (con.State == ConnectionState.Closed) { con.Open(); } try { cmd.ExecuteNonQuery(); return(true); } catch (Exception exe) { MessageBox.Show(exe.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Information); return(false); } } }