public Fatura FaturaDetails(int ID) { StoreManagmentEntities context = new StoreManagmentEntities(); return(context.Faturas.Where(x => x.Fatura_ID == ID).FirstOrDefault()); }
//Lista e faturavee per nje date public IList <Fatura> FaturaPerNjeDateTeCaktuar(DateTime dataeFatures) { StoreManagmentEntities context = new StoreManagmentEntities(); return(context.Faturas.Where(x => x.OrderDate == dataeFatures).ToList()); }
//Lista e te gjitha faturave public IList <Fatura> ListaFaturave() { StoreManagmentEntities context = new StoreManagmentEntities(); return(context.Faturas.ToList()); }
static void Main(string[] args) { DetailsList details = new DetailsList(); var listaefaturave = details.ListaFaturave(); // Shtimi dhe ruajtja ne Database Console.WriteLine("-----------------------------------------"); Console.WriteLine("A doni te shtoni nje fature te re? Po/Jo"); string answer = Console.ReadLine(); if (answer == "Po") { var context = new StoreManagmentEntities(); var invoice = new Fatura() { ProductID = 102, CustomerID = 1, OrderDate = DateTime.Now }; context.Faturas.Add(invoice); context.SaveChanges(); Console.WriteLine("Fatura u ruajt me sukses"); } else { Console.WriteLine("Ju vendoset te mos shtoni fature te re."); } Console.WriteLine("-----------------------------------------"); //Listimi i faturave if (listaefaturave.Any()) { foreach (var item in listaefaturave) { Console.WriteLine($"IdFature: {item.Fatura_ID}"); //Console.WriteLine($"Emer produkt: {item.Produkt.Product_Name}"); } } else { Console.WriteLine("Nuk u gjet asnje fature"); } // Detajet e fatures Console.WriteLine("Jep nr e fatures"); int id = Convert.ToInt32(Console.ReadLine()); var fatura = details.FaturaDetails(id); try { Console.WriteLine($"Detajet e fatures:"); Console.WriteLine($"ID e fatures: {fatura.Fatura_ID}"); Console.WriteLine($"ID e konsumatorit: {fatura.CustomerID}"); Console.WriteLine($"ID e produkutit: {fatura.ProductID}"); Console.WriteLine($"Produktit: {fatura.Produkt.Product_Name}"); Console.WriteLine($"Shuma: {fatura.Produkt.Cost}"); Console.ReadKey(); } catch (Exception ex) { Console.WriteLine(" Fatura nuk ekziston"); } }