public bool InsertDataBoolean(mUser data)
{
try
{
GVNMESEntities dObjContext = new GVNMESEntities();
//cara 1
dObjContext.mUsers.Add(data);
dObjContext.SaveChanges();
//cara 2
mUser dtToInsert = new mUser();
dtToInsert.txtUsername = data.txtUsername;
dtToInsert.txtPassword = data.txtPassword;
dtToInsert.txtFullname = "";
dObjContext.mUsers.Add(dtToInsert);
dObjContext.SaveChanges();
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
public mUser InsertData(mUser data)
{
data.dtCreated = DateTime.Now.AddDays(1);
data.dtUpdated = DateTime.Now;
GVNMESEntities dObjContext = new GVNMESEntities();
//cara 1
dObjContext.mUsers.Add(data);
dObjContext.SaveChanges();
//cara 2
mUser dtToInsert = new mUser();
dtToInsert.txtUsername = data.txtUsername;
dtToInsert.txtPassword = data.txtPassword;
dtToInsert.txtFullname = "";
dtToInsert.dtCreated = DateTime.Now;
dtToInsert.dtUpdated = DateTime.Now;
dObjContext.mUsers.Add(dtToInsert);
dObjContext.SaveChanges();
return(dtToInsert);
}
public List <mUser> GetListUser()
{
GVNMESEntities dObjContext = new GVNMESEntities();
//Lin Q => select * txtPassword, txtUsername from mUser
var dataLinQ = (from a in dObjContext.mUsers
select a).ToList();
//Lambda = select * from mUser
var dataLambda = dObjContext.mUsers.ToList();
return(dataLambda);
}
public mUser GetUser(int intUserId)
{
GVNMESEntities dObjContext = new GVNMESEntities();
//Lin Q => select top 1 txtPassword, txtUsername from mUser
var dataLinQ = (from a in dObjContext.mUsers
where a.intUserId == intUserId
select a).FirstOrDefault();
//Lambda = select top 1 * from mUser
var dataLambda = dObjContext.mUsers.FirstOrDefault();
return(dataLinQ);
}
public List <clsCartViewModels> GetCartDetail(int id)
{
GVNMESEntities dObjContext = new GVNMESEntities();
//select * from tcartheader a
var data = (from a in dObjContext.tCartHeaders
join b in dObjContext.tCartDetails on a.intCartHeaderId equals b.intCartHeaderId
join c in dObjContext.mUsers on a.intUserId equals c.intUserId into leftJoinUser
from usr in leftJoinUser.DefaultIfEmpty()
join d in dObjContext.mItems on b.intItemId equals d.intItemId
where a.intCartHeaderId == id
select new clsCartViewModels
{
intCartDetailId = b.intCartDetailId,
intCartHeaderId = a.intCartHeaderId,
intItemId = b.intItemId,
intQty = b.intQty,
intUserId = a.intUserId,
txtCartNumber = a.txtCartNumber,
txtFullname = usr.txtFullname,
ItemName = d.txtItemName,
txtItemDescription = d.txtItemDescription
}).AsQueryable();
var dtheader = (from a in dObjContext.tCartHeaders
select new { a.intCartHeaderId, a.txtCartNumber }).AsQueryable();
var dtdetail = (from a in dObjContext.tCartDetails
select new { a.intCartHeaderId, a.intQty }).AsQueryable();
var dataJoin = (from a in dtheader
join b in dtdetail on a.intCartHeaderId equals b.intCartHeaderId
select new clsCartViewModels
{
}).ToList();
var dt1 = data.Where(x => x.ItemName == "").ToList();
return(dt1);
}
public mUser UpdateData(mUser data)
{
GVNMESEntities dObjContext = new GVNMESEntities();
//cara 1
dObjContext.Entry(data).State = EntityState.Modified;
dObjContext.SaveChanges();
//cara 2
mUser dtToUpdate = new mUser();
dtToUpdate = dObjContext.mUsers.Where(x => x.intUserId == data.intUserId).FirstOrDefault(); //lambda
dtToUpdate = (from a in dObjContext.mUsers
where a.intUserId == data.intUserId
select a).FirstOrDefault(); //LinQ
dtToUpdate.txtUsername = data.txtUsername;
dtToUpdate.txtPassword = data.txtPassword;
dObjContext.Entry(data).State = EntityState.Modified;
dObjContext.SaveChanges();
return(dtToUpdate);
}
