public ClientProductModel SPExecute(int Id)
{
SqlConnection sqlConn = new SqlConnection();
sqlConn.ConnectionString = "Data Source =.; Initial Catalog=OnPremSQLDB;Integrated Security=SSPI;";
sqlConn.Open();
SqlCommand sqlcmd = new SqlCommand();
sqlcmd.CommandText = "Sp_GetProductById";
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Connection = sqlConn;
sqlcmd.Parameters.Add("@Id", SqlDbType.Int).Value = Id;
SqlDataReader sqldr = sqlcmd.ExecuteReader();
ClientProductModel prod = new ClientProductModel();
while (sqldr.Read())
{
prod.Name = (string)sqldr["ProductName"];
prod.Id = Convert.ToString(sqldr["ProductID"]);
prod.Qty = Convert.ToString(sqldr["Quantity"]);
prod.Rate = Convert.ToString(sqldr["Rate"]);
}
return(prod);
}
public bool Insert(ClientProductModel prod)
{
SqlConnection sqlConn = new SqlConnection();
sqlConn.ConnectionString = "Data Source =.; Initial Catalog=OnPremSQLDB;Integrated Security=SSPI;";
sqlConn.Open();
SqlCommand sqlcmd = new SqlCommand();
sqlcmd.Connection = sqlConn;
sqlcmd.CommandType = CommandType.Text;
sqlcmd.CommandText = "INSERT INTO [dbo].[Products] ([ProductName] ,[Quantity] ,[Rate]) VALUES('" + prod.Name + "'," + prod.Qty.ToString() + "," + prod.Rate + ")";
sqlcmd.ExecuteNonQuery();
sqlConn.Close();
return(true);
}
static void Main(string[] args)
{
Console.WriteLine("Helo World...");
//Console.ReadLine();
//Environment.Exit(0);
#region ClassMember
UtilityHelper objHelper = new UtilityHelper();
List <int> numbers = new List <int>();
numbers.Add(1);
numbers.Add(2);
numbers.Add(-1);
objHelper.numbers = numbers;
objHelper.PrintNumbers();
//Console.WriteLine(objHelper.numbers);
//objHelper.status = "Setter";
Console.WriteLine("Status :-" + objHelper.status);
UtilityHelper objHelper1 = new UtilityHelper("Initilaizer");
//Console.ReadLine();
#endregion ClassMember
#region OOPS
Console.WriteLine("-----OOPS-----");
Console.WriteLine("--Word Press--");
BlogPage objBlogPage = new GoogleBlog("Google");
objBlogPage.isActive = "YES";
objBlogPage.blogPageAuthor = "DJ";
objBlogPage.blogPageName = "C# .Net Articles";
objBlogPage.AddArticles("Basics of C#");
objBlogPage.AddArticles("Basics of C# OOPS");
objBlogPage.DisplayArticle();
Console.WriteLine("------------");
objBlogPage.BlogInfo();
Console.ReadLine();
#endregion
#region DesignPattern
Console.WriteLine("-----OOPS-----");
Console.WriteLine("--Word Press--");
int blogType = 2;
BlogPage dynamicobjBlogPage;
if (blogType == 1)
{
dynamicobjBlogPage = new WordPressBlog("WordPress");
}
else
{
dynamicobjBlogPage = new GoogleBlog("WordPress");
}
dynamicobjBlogPage.isActive = "YES";
dynamicobjBlogPage.blogPageAuthor = "DJ";
dynamicobjBlogPage.blogPageName = "C# .Net Articles";
dynamicobjBlogPage.AddArticles("Basics of C# DesignPattern");
dynamicobjBlogPage.DisplayArticle();
Console.WriteLine("------------");
dynamicobjBlogPage.BlogInfo();
Console.ReadLine();
#endregion
#region DelegateDemo
CalOperations objCal = new CalOperations();
CalDelegate objDelegate = new CalDelegate(objCal.Add);
objDelegate += new CalDelegate(objCal.Sub);
int result = objDelegate(1, 2);
Console.WriteLine("Result Set :- " + result.ToString());
#endregion
#region DAL
DALHelper objDAL = new DALHelper();
ClientProductModel product = new ClientProductModel();
product.Name = "IPhone";
product.Qty = "25";
product.Rate = "25.00";
// objDAL.Insert(product);
product.Name = "Nokia";
product.Qty = "100";
product.Rate = "12.00";
// objDAL.Insert(product);
product = null;
product = objDAL.SelectQuery(1);
product = objDAL.SPExecute(1);
#endregion
#region LINQ
LinqTuto.LinqHelloWorld();
LinqTuto.LinqHelloWorldOnStudent();
LinqTuto.LinqHelloWorldOnStudentTeacher();
#endregion
}
