//Add to MemariSystem Table public bool AddMemariSystem(memariSystem ms) { try { db.memariSystems.InsertOnSubmit(ms); db.SubmitChanges(); return true; } catch (Exception error) { return false; } }
//Edit MemariSystem Table public int EditMemariSystem(memariSystem ms) { try { var v = from i in db.memariSystems where i.memariCode == ms.memariCode select i; memariSystem newmemari = v.FirstOrDefault(); if(newmemari != null) { newmemari = ms; db.SubmitChanges(); return 1; } return 0;//not found } catch (Exception error) { return -1; } }
partial void UpdatememariSystem(memariSystem instance);
partial void DeletememariSystem(memariSystem instance);
partial void InsertmemariSystem(memariSystem instance);