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);
}
}
}
