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