public static void AddField(Field field) { using (FakturisanjeEntities dbEntity = new FakturisanjeEntities()) { dbEntity.Fields.Add(field); dbEntity.SaveChanges(); } }
public static void DeleteInvoice(string id) { using (FakturisanjeEntities dbEntity = new FakturisanjeEntities()) { Invoice i = (from inv in dbEntity.Invoices where inv.DocumentId == id select inv).SingleOrDefault(); dbEntity.Invoices.Remove(i); dbEntity.SaveChanges(); } }
public static void EditInvoice(Invoice i) { using (FakturisanjeEntities dbEntity = new FakturisanjeEntities()) { Invoice invoice = (from inv in dbEntity.Invoices where inv.DocumentId == i.DocumentId select inv).Single(); invoice.InvoiceId = i.InvoiceId; invoice.InvoiceDate = i.InvoiceDate; invoice.Total = i.Total; dbEntity.SaveChanges(); } }
public static void EditField(Field field) { using (FakturisanjeEntities dbEntity = new FakturisanjeEntities()) { Field newField = (from f in dbEntity.Fields where f.FieldId == field.FieldId select f).SingleOrDefault(); newField.FieldName = field.FieldName; newField.Price = field.Price; newField.Amount = field.Amount; dbEntity.SaveChanges(); } }
public static string CreateInvoice(Invoice invoice) { using (FakturisanjeEntities dbEntity = new FakturisanjeEntities()) { try { dbEntity.Invoices.Add(invoice); dbEntity.SaveChanges(); return("ok"); } catch (DbUpdateException) { return("pkViolation"); } catch (Exception) { return("general"); } } }
public static string DeleteField(int id) { using (FakturisanjeEntities dbEntity = new FakturisanjeEntities()) { Field field = (from f in dbEntity.Fields where f.FieldId == id select f).SingleOrDefault(); string documentId = field.DocumentId; try { dbEntity.Fields.Remove(field); dbEntity.SaveChanges(); return(documentId); } catch (Exception) { return("error"); } } }