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 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);
}