//----SORGULAR----
public static int encokMarka(SatilanSurragate marka)
{
SatilanSurragate g = new SatilanSurragate();
int b = 0;
//using (DB_OtoGaleriEntities db = new DB_OtoGaleriEntities())
//{
// var a = from m in db.TB_Satilan
// group m by m.Marka into grp
// orderby grp.Marka.Count()descending
// select new
// {
// marka.Marka = a.Marka,
// };
//}
return(b);
}
//SATIŞ TABLOSUNDA SATIŞ İŞLEMİ-Satış Tablosuna ekleme
public static int sat(SatilanSurragate arabasat)
{
int satID;
using (DB_OtoGaleriEntities db = new DB_OtoGaleriEntities())
{
TB_Satilan st = new TB_Satilan();
st.ArabaID = arabasat.ArabaID;
st.Marka = arabasat.Marka;
st.Model = arabasat.Model;
st.MusteriID = arabasat.MusteriID;
st.Plaka = arabasat.Plaka;
st.SatisFiyat = arabasat.SatisFiyat;
st.SatisTarihi = arabasat.SatisTarihi;
st.AlisFiyat = arabasat.AlisFiyat;
db.TB_Satilan.Add(st);
db.SaveChanges();
satID = st.SatisID;
}
return(satID);
}
