public static List <Fatura> GetAllFaturas()
{
using (IzsuDBContext db = new IzsuDBContext())
{
return(db.Fatura.ToList());
}
}
public static List <Fatura> GetOdenmemisFaturalar(int id)
{
using (IzsuDBContext db = new IzsuDBContext())
{
return(db.Fatura.Where(f => f.AboneID == id && f.Tahsilat == false).ToList());
}
}
public static Fatura GetFatura(int id)
{
using (IzsuDBContext db = new IzsuDBContext())
{
return(db.Fatura.OrderByDescending(f => f.FaturaID).FirstOrDefault(f => f.AboneID == id));
}
}
public static List <AboneTuru> GetAllAboneTurus()
{
using (IzsuDBContext db = new IzsuDBContext())
{
return(db.AboneTuru.ToList());
}
}
public static List <Fatura> GetListeFatura(int id)
{
using (IzsuDBContext db = new IzsuDBContext())
{
return(db.Fatura.Where(f => f.AboneID == id).ToList());
}
}
private void txtAdoneNo_Leave(object sender, EventArgs e)
{
using (IzsuDBContext context = new IzsuDBContext())
{
int _aboneNo = int.Parse(txtAdoneNo.Text);
var result = context.Abone.FirstOrDefault(a => a.AboneNo == _aboneNo);
if (result != null)
{
txtAdoneNo.Enabled = false;
txtAdSoyad.Enabled = false;
cBoxAboneTuru.Enabled = false;
GroupBoxFaturaBilgileri.Enabled = true;
txtAdSoyad.Text = result.AboneAdSoyad;
cBoxAboneTuru.SelectedIndex = result.AboneTuruID - 1;
txtFaturaAboneNo.Text = result.AboneNo.ToString();
txtFaturaAdSoyad.Text = result.AboneAdSoyad;
}
else
{
MessageBox.Show("Kullanıcı Bulunamadı!");
btnKaydet.Enabled = true;
txtAdSoyad.Enabled = true;
cBoxAboneTuru.Enabled = true;
}
}
}
public static Abone FindAboneTuruID(int id)
{
using (IzsuDBContext db = new IzsuDBContext())
{
return(db.Abone.FirstOrDefault(a => a.AboneID == id));
}
}
private void Form1_Load(object sender, EventArgs e)
{
Tarih.Format = DateTimePickerFormat.Custom;
Tarih.CustomFormat = "MM-yyyy";
Tarih.ShowUpDown = true;
btnKaydet.Enabled = false;
GroupBoxFaturaBilgileri.Enabled = false;
using (IzsuDBContext context = new IzsuDBContext())
{
var result = context.AboneTuru.ToList();
foreach (var item in result)
{
cBoxAboneTuru.Items.Add(item);
}
//int yeniAboneNo = context.Abone.OrderByDescending(a => a.AboneNo).FirstOrDefault().AboneNo++;
Abone _abone = context.Abone.OrderByDescending(a => a.AboneNo).FirstOrDefault();
int yeniAbeneNo = _abone.AboneNo;
yeniAbeneNo++;
txtAdoneNo.Text = yeniAbeneNo.ToString();
}
}
public static void AddFatura(Fatura fatura)
{
using (IzsuDBContext db = new IzsuDBContext())
{
db.Fatura.Add(fatura);
db.SaveChanges();
}
}
public static void AddAbone(Abone abone)
{
using (IzsuDBContext db = new IzsuDBContext())
{
db.Abone.Add(abone);
db.SaveChanges();
}
}
public static void DeleteAbone(int no)
{
using (IzsuDBContext db = new IzsuDBContext())
{
var result = db.Abone.Where(a => a.AboneID == no).FirstOrDefault();
db.Abone.Remove(result);
db.SaveChanges();
}
}
public static void UpdateOdenenFatura(int faturaID)
{
using (IzsuDBContext db = new IzsuDBContext())
{
var result = db.Fatura.Find(faturaID);
result.Tahsilat = true;
db.SaveChanges();
}
}
public static void UpdateAbone(Abone abone)
{
using (IzsuDBContext db = new IzsuDBContext())
{
var result = db.Abone.FirstOrDefault(a => a.AboneID == abone.AboneID);
result.AboneAdSoyad = abone.AboneAdSoyad;
result.AboneTuruID = abone.AboneTuruID;
db.SaveChanges();
}
}
public static List <ViewAbones> GetAllAbones()
{
using (IzsuDBContext db = new IzsuDBContext())
{
return(db.Abone.Select(a => new ViewAbones
{
AboneID = a.AboneID,
AboneAdSoyad = a.AboneAdSoyad,
AboneTuruAd = a.AboneTuru.AboneTuruAd,
}).ToList());
}
}
public static ViewAbones GetViewAbone(int no)
{
using (IzsuDBContext db = new IzsuDBContext())
{
return(db.Abone.
Where(a => a.AboneID == no).
Select(a => new ViewAbones
{
AboneAdSoyad = a.AboneAdSoyad,
AboneTuruAd = a.AboneTuru.AboneTuruAd,
}).FirstOrDefault());
}
}
private void btnKaydet_Click(object sender, EventArgs e)
{
Abone a = new Abone();
a.AboneNo = int.Parse(txtAdoneNo.Text);
a.AboneAdSoyad = txtAdSoyad.Text;
AboneTuru at = (AboneTuru)cBoxAboneTuru.SelectedItem;
a.AboneTuruID = at.AboneTuruID;
at.AboneTuruAd = "hususi";
using (IzsuDBContext context = new IzsuDBContext())
{
context.Abone.Add(a);
context.SaveChanges();
}
}
