public List <POMaster> GetPOMaster() { List <POMaster> items = new List <POMaster>(); string connectionString = @"Data Source=DOTNET;Initial Catalog=PODb;Integrated Security=true"; using (SqlConnection c = new SqlConnection(connectionString)) { c.Open(); using (SqlCommand sqlCommand = new SqlCommand("SELECT * FROM [PODb].[dbo].[POMASTER]", c)) { SqlDataReader reader = sqlCommand.ExecuteReader(); while (reader.Read()) { POMaster item = new POMaster(); item.PONO = reader["PONO"].ToString(); item.PODATE = Convert.ToDateTime(reader["PODATE"].ToString()); item.SUPLNO = reader["SUPLNO"].ToString(); items.Add(item); } reader.Close(); } return(items); } }
public int AddPOMaster(POMaster value) { int result = -1; string connetionString = @"Data Source=DOTNET;Initial Catalog=PODb;Integrated Security=true"; using (SqlConnection c = new SqlConnection(connetionString)) { c.Open(); using (SqlCommand sqlCommand = new SqlCommand("INSERT INTO [PODb].[dbo].[POMASTER] VALUES ('" + value.PONO + "', '" + value.PODATE + "', '" + value.SUPLNO + "')", c)) { result = sqlCommand.ExecuteNonQuery(); } c.Close(); } return(result); }