public void UpdateMember(MemberView mv)
{
using (GoGoDBEntities db = new GoGoDBEntities())
{
Member mm = db.Members.Find(mv.id_member);
mm.nama = mv.nama;
mm.telepon = mv.telepon;
mm.saldo = mv.saldo;
//db.Members.Add(mm);
db.SaveChanges();
}
}
public void AddMember(MemberView mv)
{
using (GoGoDBEntities db = new GoGoDBEntities())
{
Member mm = new Member();
mm.nama = mv.nama;
mm.telepon = mv.telepon;
mm.saldo = mv.saldo;
db.Members.Add(mm);
db.SaveChanges();
}
}
public List <MemberView> GetMemberData()
{
using (GoGoDBEntities db = new GoGoDBEntities())
{
var member = db.Members.Select(o => new MemberView
{
id_member = o.id_member,
nama = o.nama,
telepon = o.telepon,
saldo = o.saldo
}).ToList();
return(member);
}
}
public void DeleteMember(int memberID)
{
using (GoGoDBEntities db = new GoGoDBEntities())
{
using (var dbContextTransaction = db.Database.BeginTransaction())
{
try
{
var mm = db.Members.Where(o => o.id_member == memberID);
if (mm.Any())
{
db.Members.Remove(mm.FirstOrDefault());
db.SaveChanges();
}
dbContextTransaction.Commit();
}
catch
{
dbContextTransaction.Rollback();
}
}
}
}
