MKTS.DWrapperFramework 1.1.0

using DWrapperFramework; using Newtonsoft.Json; using Newtonsoft.Json.Linq; using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks;

namespace TestDWrapperFramework { public class Program { static void Main(string[] args) { string connectionString = "Data Source=.\SqlExpress;Initial Catalog=TestMKWrapper;Integrated Security=True;Pooling=False"; Program p = new Program(); //Test1 //p.Insert(connectionString);

        //Test5
        //p.SelectSingle(connectionString);

       
        //Test8
        //p.Update(connectionString);

        //Test11
        //p.DeleteConnectionOriented(connectionString);

        //Test12
        //p.DWrapperMapSP(connectionString);

        //Test13
        p.GetItems(connectionString);

        //Test14
        //p.Execute(connectionString);
    }

    #region Insert Test
    public void Insert(string connectionString)
    {
        DWrapper wrapper = new DWrapper(connectionString);

        Employee emp = new Employee();
        emp.Name = "Test";
        emp.City = "Roorkee";
        emp.Salary = 10000;
        wrapper.Insert<Employee>(emp);

        Console.WriteLine("Id " + emp.Id);
        Console.WriteLine("Name " + emp.Name);
        Console.WriteLine("City " + emp.City);
    }
    #endregion

    #region Select Test
    public void SelectSingle(string connectionString)
    {
        DWrapper wrapper = new DWrapper(connectionString);
        Employee emp = wrapper.SelectSingle<Employee>(new { Id=1});
        Console.WriteLine("Id " + emp.Id);
        Console.WriteLine("Name " + emp.Name);
        Console.WriteLine("City " + emp.City);
    }
    #endregion

    #region Update Test
    public void Update(string connectionString)
    {
        DWrapper wrapper = new DWrapper(connectionString);

        Employee emp = new Employee();
        emp.Name = "UpdateTest";
        emp.City = "Roorkee";
        emp.Salary = 10000;
        emp.Id = 1;
        wrapper.Update<Employee>(emp);

        Console.WriteLine("Id " + emp.Id);
        Console.WriteLine("Name " + emp.Name);
        Console.WriteLine("City " + emp.City);
    }
    #endregion

    #region Delete Test
    
    public void DeleteConnectionOriented(string connectionString)
    {
        DWrapper wrapper = new DWrapper(connectionString);
        using (wrapper.GetOpenConnection())
        {
            using (var transaction = wrapper.BeginTransaction())
            {
                try
                {
                    Employee emp = new Employee();
                    emp.Name = "Test";
                    emp.City = "Roorkee";
                    emp.Salary = 10000;
                    emp.Id = 2;
                    wrapper.DeleteConnectionOriented<Employee>(emp);
                    transaction.Commit();
                }
                catch (Exception ex)
                {
                    transaction.Rollback();
                }
            }
        }
    }
    #endregion

    #region Stored Procedure Test
    public void DWrapperMapSP(string connectionString)
    {
        DWrapper wrapper = new DWrapper(connectionString);
        var dynamicData=wrapper.DWrapperMapSP<dynamic>("sp_ReadEmployeeById", new { Id = 3 });
        //string objectString = JsonConvert.SerializeObject(dynamicData);
        if(dynamicData.Count>0)
        {
            foreach(var emp in dynamicData)
            {
                Console.WriteLine("Name " + emp.Name);
                Console.WriteLine("Salary " + emp.Salary);
            }
        }
        else
        {
            Console.WriteLine("Name " + dynamicData.Name);
            Console.WriteLine("Salary " + dynamicData.Salary);
        }
    }

    #endregion

    #region Direct Query Test
    public void GetItems(string connectionString)
    {
        DWrapper wrapper = new DWrapper(connectionString);
        using (wrapper.GetOpenConnection())
        {
            var empList = wrapper.GetItems<dynamic>(System.Data.CommandType.Text, "Select * from Employee where id=@Id", new { Id = 4 });

        }
    }

    public void Execute(string connectionString)
    {
        DWrapper wrapper = new DWrapper(connectionString);
        using (wrapper.GetOpenConnection())
        {
            var empList = wrapper.Execute<dynamic>(System.Data.CommandType.Text, "Update Employee set name=@Name where id=@Id", new { Id = 8, Name = "Mukammil" });
        }
    }
    #endregion 
}

public class Employee
{
    public int Id { get; set; }

    public string Name { get; set; }

    public string City { get; set; }

    public decimal Salary { get; set; }
}

}