/// <summary>
/// Get Single Data From Database
/// <para>Use it when to retive single data through a stored procedure</para>
/// </summary>
public T ExecuteQuerySingle(string spQuery, object[] parameters)
{
using (context = new CRUD_SampleEntities())
{
return(context.Database.SqlQuery <T>(spQuery, parameters).FirstOrDefault());
}
}
/// <summary>
/// Get Data From Database
/// <para>Use it when to retive data through a stored procedure</para>
/// </summary>
public IEnumerable <T> ExecuteQuery(string spQuery, object[] parameters)
{
using (context = new CRUD_SampleEntities())
{
return(context.Database.SqlQuery <T>(spQuery, parameters).ToList());
}
}
/// <summary>
/// Get Data From Database
/// <para>Use it when to retive data through a stored procedure</para>
/// </summary>
public IEnumerable<T> ExecuteQuery(string spQuery, object[] parameters)
{
//每次都临时创建一个新的实体环境对象，用于执行数据库查询
using (context = new CRUD_SampleEntities())
{
return context.Database.SqlQuery<T>(spQuery, parameters).ToList();
}
}
/// <summary>
/// Insert/Update/Delete Data To Database
/// <para>Use it when to Insert/Update/Delete data through a stored procedure</para>
/// </summary>
public int ExecuteCommand(string spQuery, object[] parameters)
{
int result = 0;
try
{
using (context = new CRUD_SampleEntities())
{
result = context.Database.SqlQuery<int>(spQuery, parameters).FirstOrDefault();
}
}
catch { }
return result;
}
public IHttpActionResult Delete(int id)
{
if (id < 0)
{
return(BadRequest("Invalid customer id"));
}
using (var ctx = new CRUD_SampleEntities())
{
var existingCustomer = ctx.Customers.Where(c => c.Id == id).FirstOrDefault();
if (existingCustomer == null)
{
return(NotFound());
}
ctx.Entry(existingCustomer).State = System.Data.Entity.EntityState.Deleted;
ctx.SaveChanges();
}
return(Ok());
}
public IHttpActionResult Put(CustomerDTO customer)
{
if (!ModelState.IsValid)
{
return(BadRequest("Invalid data"));
}
using (var ctx = new CRUD_SampleEntities())
{
var existingCustomer = ctx.Customers.Where(c => c.Id == customer.Id).FirstOrDefault();
if (existingCustomer == null)
{
return(NotFound());
}
existingCustomer.CustName = customer.CustName;
existingCustomer.CustEmail = customer.CustEmail;
ctx.SaveChanges();
}
return(Ok());
}
public IHttpActionResult PostNewCustomer(CustomerDTO customer)
{
if (!ModelState.IsValid)
{
return(BadRequest("Invalid data"));
}
using (var ctx = new CRUD_SampleEntities())
{
ctx.Customers.Add(new Customer()
{
Id = customer.Id,
CustName = customer.CustName,
CustEmail = customer.CustEmail
});
ctx.SaveChanges();
}
return(Ok());
}
public IHttpActionResult GetCustomerById(int id)
{
CustomerDTO customer = null;
using (var ctx = new CRUD_SampleEntities())
{
customer = ctx.Customers.Where(c => c.Id == id)
.Select(c => new CustomerDTO()
{
Id = c.Id,
CustName = c.CustName,
CustEmail = c.CustEmail
}).FirstOrDefault <CustomerDTO>();
}
if (customer == null)
{
return(NotFound());
}
return(Ok(customer));
}
public IHttpActionResult GetAllCustomer()
{
IList <CustomerDTO> customers = null;
using (var ctx = new CRUD_SampleEntities())
{
customers = ctx.Customers.Select(c => new CustomerDTO()
{
Id = c.Id,
CustName = c.CustName,
CustEmail = c.CustEmail
}).ToList <CustomerDTO>();
}
if (customers.Count == 0)
{
return(NotFound());
}
return(Ok(customers));
}
public GenericRepository(CRUD_SampleEntities context)
{
this.context = context;
entities = context.Set <T>();
}
