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