public static void Main(string[] args)
{
#region TestMethods
//SMTPOutgoing smptOutgoing = new SMTPOutgoing();
//smptOutgoing.SMTP("","","","");
//Console.WriteLine("Complete");
//Console.ReadLine();
//ADO.NET connection
IDataAccess _da = new DataAccess.DataAccess();
//var query = from p in dbContext.ProductSet
// where p.Categories.CategoryName == "Seafood"
// select p;
//IEnumerable<Product> products = query.ToList();
_da = new DataAccess.DataAccess();
_da.Open();
DataSet ds = _da.Read("Select * from Orders");
DataTable dt = ds.Tables[0];
//Refernce another project (MVC)
//Ask for user input
//Create Inforce referential integrity with complex object
//Read
//Update
//Delete record
//Reference JAVA
//Reference Perl
//referenca SOAP
#region Load dictionary values in enum or from web.config file.
Dictionary<int, string> type = new Dictionary<int, string>();
type.Add(1, "Home");
type.Add(2, "Product");
type.Add(3, "Parts");
type.Add(4, "Service Order");
Console.WriteLine("Select type");
string selectedValue = Console.Read().ToString();
type.ContainsKey(Convert.ToInt32(selectedValue));
//foreach (KeyValuePair<int, string> pair in selectedValue) {
// Console.WriteLine(pair.Key.ToString());
//}
selectedValue.GetType();
if (true) {
Console.WriteLine("You've selected ", "KeyValue");
} else {
Console.WriteLine("Invalid selection");
}
Console.ReadLine();
#endregion
#endregion
}
/// <summary>
/// Select command
/// </summary>
/// <param name="select">Select from database</param>
public DataSet Read(string cmd)
{
IDataAccess _da = new DataAccess();
SqlConnection connection = new SqlConnection();
DataTable dt = new DataTable();
DataSet ds = new DataSet();
string sc = System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase);
string us = "Data Source=" + sc.Remove(0, 6) + "\\NORTHWIND.MDF";
string fs = us.Replace("\\", "\\");
SqlCommand command = new SqlCommand("Select * from Orders", connection);
SqlDataAdapter adapter = new SqlDataAdapter(command);
adapter.Fill(ds);
_da = new DataAccess();
_da.Open();
connection.ConnectionString = fs;
connection.Open();
ds = _da.Read("Select * from Orders");
dt = ds.Tables[0];
return ds;
}