public static object cUpdateLinq(MODEL.Query obj)
{
bool reUpdate = false;
// qLinq.Connection.Open();
// qLinq.Transaction = qLinq.Connection.BeginTransaction();
try
{
var Lquery = (from a in qLinq.TEST_SYSTEMs
where a.ID == obj.ID
select a).FirstOrDefault();
if (Lquery != null)
{
Lquery.EMAIL = obj.EMAIL;
Lquery.NAME = obj.NAME;
qLinq.SubmitChanges();
reUpdate = true;
}
}
catch (Exception)
{
// if (qLinq.Transaction != null)
// qLinq.Transaction.Rollback();
reUpdate = false;
}
finally {
// qLinq.Transaction.Dispose();
// qLinq.Connection.Close();
}
return(reUpdate);
}
public static object cDeleteEntity(MODEL.Query obj)
{
Entity.silkspanEntities db = new Entity.silkspanEntities();
var obReturn = db.TEST_SYSTEM.Where(
e => (e.ID == obj.ID)
).First();
db.TEST_SYSTEM.DeleteObject(obReturn);
db.SaveChanges();
return(true);
}
public static object cInsertEntity(MODEL.Query obj)
{
Entity.silkspanEntities db = new Entity.silkspanEntities();
Entity.TEST_SYSTEM ob = new Entity.TEST_SYSTEM();
ob.NAME = obj.NAME;
ob.SYSTEM_NAME = "entity";
ob.EMAIL = obj.EMAIL;
db.TEST_SYSTEM.AddObject(ob);
db.SaveChanges();
return(true);
}
public static object cSelectEntity(MODEL.Query obj)
{
Entity.silkspanEntities db = new Entity.silkspanEntities();
var obReturn = db.TEST_SYSTEM.Where(
e => e.SYSTEM_NAME == "entity"
).ToList();
return(obReturn);
/*return db.ExecuteStoreQuery<MODEL.QueryModel>(" select * from TEST_SYSTEM ").ToList(); */
}
public static object cUpdateEntity(MODEL.Query obj)
{
Entity.silkspanEntities db = new Entity.silkspanEntities();
var obReturn = db.TEST_SYSTEM.First(
e => (e.SYSTEM_NAME == "entity") &&
(e.ID == obj.ID)
);
obReturn.NAME = obj.NAME;
obReturn.EMAIL = obj.EMAIL;
db.SaveChanges();
return(true);
}
public static object cSelectLinq(MODEL.Query obj)
{
/* var Lquery = from a in qLinq.TEST_SYSTEMs
* where a.SYSTEM_NAME.ToLower() == "linq"
* select new MODEL.Query
* {
* ID =a.ID,
* NAME = a.NAME,
* EMAIL = a.EMAIL
* };
* return Lquery.ToList<MODEL.Query>();
**/
string query = " SELECT ID,NAME,EMAIL from TEST_SYSTEM where SYSTEM_NAME='linq' ";
var respon = qLinq.ExecuteQuery <MODEL.Query>(query);
return(respon.ToList());
}
public static object cInsertLinq(MODEL.Query obj)
{
bool reUpdate = false;
// qLinq.Connection.Open();
// qLinq.Transaction = qLinq.Connection.BeginTransaction();
try
{
// query จาก object linq
/* Linq.TEST_SYSTEM objLinq = new Linq.TEST_SYSTEM();
* objLinq.NAME = obj.NAME;
* objLinq.EMAIL = obj.EMAIL;
* objLinq.SYSTEM_NAME = "linq";
*
* qLinq.TEST_SYSTEMs.InsertOnSubmit(objLinq);
* qLinq.SubmitChanges();*/
string query = " INSERT INTO TEST_SYSTEM(NAME,EMAIL,SYSTEM_NAME) values('" + obj.NAME + "','" + obj.EMAIL + "','linq') ";
var respon = qLinq.ExecuteQuery <MODEL.Query>(query);
// qLinq.Transaction.Commit();
}
catch (Exception)
{
// if (qLinq.Transaction != null)
// qLinq.Transaction.Rollback();
reUpdate = false;
}
finally
{
// qLinq.Transaction.Dispose();
// qLinq.Connection.Close();
}
return(reUpdate);
}
public static object cDeleteEntity(string data)
{
MODEL.Query obj = cHelper.Deserialize <MODEL.Query>(data);
return(DAL.QueryEntityDAL.cDeleteEntity(obj));
}
public static object cDeleteLinq(string data)
{
MODEL.Query obj = cHelper.Deserialize <MODEL.Query>(data);
return(DAL.QueryLinqDAL.cDeleteLinq(obj));
}
