MyCrudPackage 1.2.0

Purpose

This package is useful to everyone who uses .net framework and try to push the model data to the sql database.

Implementation

we have 3 methods in this package

1. DBTransaction - Applicable to send model as a parameter and do the CUD operations
2. GetDataSet - Applicable to receive the dataset with multiple or single table (with and without model)
3. GetDataTable - Applicable to receive the datatable (with and without model)

Scenario 1:

You want to do a transaction to create / update / delete a record

Here is your Model

public class Employee
{

	public string FirstName{get;set;}

	public string LastName{get;set;}

	public string MiddleName{get;set;}

	public int Age{get;set;}

	public bit Gender{get;set;}
}

Server side - Button_Click event

/* you are forming this object in your creation screen (Employee.aspx.cs) */

Employee employee=new Employee();
  
employee.FirstName=txtFirstName.Text;

employee.LastName=txtLastName.Text;

employee.MiddleName=txtMiddleName.Text;

employee.Age=Convert.ToInt16(txtAge.Text);

employee.Gender=Convert.ToBoolean(rbdGender.Value);

here is your connection string

string sqlconnectionstring=ConfigurationManager.ConnectionStrings["yourconnectionstring"].ConnectionString;
string storedprocname=<storedprocedurename>;

here we call our MyCrudPackage

var result=MyCrudPackage.CRUD.DBTransactions<Employee>(employee,storedprocname,sqlconnectionstring);

Scenario 2:

To receive data to a Dataset with parameters (multiple collection of select statement from stored proc / single)

DataSet ds=new DataSet();
ds=MyCrudPackage.CRUD.GetDataSet<Employee>(employee,storedprocname,sqlconnectionstring);

Scenario 3:

To receive data to a Dataset without parameters (multiple collection of select statement from stored proc / single)

DataSet ds=new DataSet();
ds=MyCrudPackage.CRUD.GetDataSet(storedprocname,sqlconnectionstring);

Scenario 4:

To receive data to a Datatable with parameters

DataTable dt=new DataTable();
dt=MyCrudPackage.CRUD.GetDataTable<Employee>(employee,storedprocname,sqlconnectionstring);

Scenario 5:

To receive data to a Datatable without parameters

DataTable dt=new DataTable();
dt=MyCrudPackage.CRUD.GetDataTable(storedprocname,sqlconnectionstring);