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