public static void AddField(Field field) { using (FakturisanjeEntities dbEntity = new FakturisanjeEntities()) { dbEntity.Fields.Add(field); dbEntity.SaveChanges(); } }
//GET: list of all invoices - index.cshtml public static List <Invoice> GetInvoices() { using (FakturisanjeEntities dbEntity = new FakturisanjeEntities()) { List <Invoice> listOfInvoices = (from i in dbEntity.Invoices select i).ToList(); return(listOfInvoices); } }
public static List <Field> GetFields(string documentId) { using (FakturisanjeEntities dbEntity = new FakturisanjeEntities()) { List <Field> fields = (from f in dbEntity.Fields where f.DocumentId == documentId select f).ToList(); return(fields); } }
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(); } }
//check user credentials public static User CheckUser(LoginViewModel model) { using (FakturisanjeEntities dbEntity = new FakturisanjeEntities()) { User user = (from u in dbEntity.Users where u.Role == model.Username && u.Password == model.Password select u).SingleOrDefault(); return(user); } }
public static InvoiceModel FindInvoice(string id) { using (FakturisanjeEntities dbEntity = new FakturisanjeEntities()) { InvoiceModel im = (from i in dbEntity.Invoices where i.DocumentId == id select new InvoiceModel { DocumentId = i.DocumentId, InvoiceId = i.InvoiceId, InvoiceDate = i.InvoiceDate }).SingleOrDefault(); return(im); } }
public static InvoiceModel FindField(int?id) { using (FakturisanjeEntities dbEntity = new FakturisanjeEntities()) { InvoiceModel field = (from f in dbEntity.Fields where f.FieldId == id select new InvoiceModel { DocumentId = f.DocumentId, FieldId = f.FieldId, FieldName = f.FieldName, Price = f.Price, Amount = f.Amount }).SingleOrDefault(); return(field); } }
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"); } } }