public IEnumerable <ScanCode> GetScanCodes() { List <ScanCode> scans = new List <ScanCode>(); using (SqlConnection con = new SqlConnection(DbCon.connection)) { try { SqlCommand cmd = new SqlCommand("Select * From tblScnCd", con); if (con.State == ConnectionState.Closed) { con.Open(); } SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { while (rdr.Read()) { ScanCode scan = new ScanCode(); scan.ScanCd = rdr["Scancode"].ToString(); scan.ProdCd = rdr["Prodcd"].ToString(); scan.Unitcd = rdr["Unitcd"].ToString(); scans.Add(scan); } } return(scans); } catch (Exception exe) { return(null); } } }
public bool SaveScan(ScanCode ScanCode) { using (SqlConnection con = new SqlConnection(DbCon.connection)) { try { SqlCommand cmd = new SqlCommand("Insert into tblscncd (Scancode,Prodcd,Unitcd,Createdby) values (@Scancode,@Prodcd,@Unitcd,@CreatedBy)", con); cmd.Parameters.AddWithValue("@ScanCode", ScanCode.ScanCd); cmd.Parameters.AddWithValue("@Prodcd", ScanCode.ProdCd); cmd.Parameters.AddWithValue("@Unitcd", ScanCode.Unitcd); cmd.Parameters.AddWithValue("@CreatedBy", ScanCode.CreatedBy); if (con.State == ConnectionState.Closed) { con.Open(); } cmd.ExecuteNonQuery(); return(true); } catch (Exception exe) { return(false); } } }