public void InsertConnectionOriented(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;
wrapper.InsertConnectionOriented<Employee>(emp);
Console.WriteLine("Id " + emp.Id);
Console.WriteLine("Name " + emp.Name);
Console.WriteLine("City " + emp.City);
transaction.Commit();
}
catch(Exception ex)
{
transaction.Rollback();
}
}
}
}
public void InsertListConnectionOriented(string connectionString)
{
DWrapper wrapper = new DWrapper(connectionString);
using (wrapper.GetOpenConnection())
{
using (var transaction = wrapper.BeginTransaction())
{
try
{
List<Employee> empList = new List<Employee>();
Employee emp = new Employee();
emp.Name = "ListTest1";
emp.City = "Roorkee";
emp.Salary = 10000;
empList.Add(emp);
Employee empNew = new Employee();
empNew.Name = "ListTest2";
empNew.City = "Roorkee";
empNew.Salary = 10000;
empList.Add(empNew);
wrapper.InsertListConnectionOriented<Employee>(empList);
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
}
}
}
}
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" });
}
}
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);
}
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 SelectAll(string connectionString)
{
DWrapper wrapper = new DWrapper(connectionString);
List<Employee> empList = wrapper.SelectAll<Employee>()?.ToList();
foreach (var emp in empList)
{
Console.WriteLine("Id " + emp.Id);
Console.WriteLine("Name " + emp.Name);
Console.WriteLine("City " + emp.City);
}
}
public void Select(string connectionString)
{
DWrapper wrapper = new DWrapper(connectionString);
Employee emptemp = new Employee();
emptemp.Id = 1;
List<Employee> empList = wrapper.Select<Employee>(new { Name="Test" })?.ToList();
foreach (var emp in empList)
{
Console.WriteLine("Id " + emp.Id);
Console.WriteLine("Name " + emp.Name);
Console.WriteLine("City " + emp.City);
}
}
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);
}
public void UpdateSelectedColumns(string connectionString)
{
DWrapper wrapper = new DWrapper(connectionString);
Employee emp = new Employee();
emp.Name = "Test Selected";
emp.City = "Roorkee";
emp.Salary = 10000;
// Id is mandatory param
wrapper.UpdateSelectedColumns<Employee>(new { Id = 1, Name = "Update Selected" });
Console.WriteLine("Id " + emp.Id);
Console.WriteLine("Name " + emp.Name);
Console.WriteLine("City " + emp.City);
}
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);
}
}
public void InsertList(string connectionString)
{
DWrapper wrapper = new DWrapper(connectionString);
List<Employee> empList = new List<Employee>();
Employee emp = new Employee();
emp.Name = "ListTest1";
emp.City = "Roorkee";
emp.Salary = 10000;
empList.Add(emp);
Employee empNew = new Employee();
empNew.Name = "ListTest2";
empNew.City = "Roorkee";
empNew.Salary = 10000;
empList.Add(empNew);
wrapper.InsertList<Employee>(empList);
}
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();
}
}
}
}
