public YemBitkileriForm(string TcNo)
{
InitializeComponent();
_yemManager = new YemBitkileriManager();
_cksDal = new CksDal();
_cksKayit = _cksDal.Get(TcNo);
_urunManager = new UrunManager();
}
public SertifikaliTohumForm(string TcNo)
{
InitializeComponent();
_bll = new SertifikaliTohumManager();
_cksDal = new CksDal();
_cksKayit = _cksDal.Get(TcNo);
_urunManager = new UrunManager();
_firmaManager = new FirmaManager();
}
private static void Listele()
{
// GetAll
CksDal dal = new CksDal();
var liste = dal.GetAll();
foreach (var item in liste)
{
Console.WriteLine($"{item.DosyaNo} {item.Tc} {item.IsimSoyisim} {item.BabaAdi} {item.KoyMahalle} {item.CepTelefonu} {item.EvTelefonu} {item.KayitTarihi}");
}
}
private static void InsertCks2020ToDb()
{
int result;
//Insert
string cks2020 = File.ReadAllText(@"C:\Users\caglar\Google Drive\YesilyurtProjects\Archive\Yesilyurt.UI.2021\bin\Debug\Backup\Cks2020.json");
var liste = DeserializeObject <MyClass>(cks2020);
List <Cks> cksListe = new List <Cks>();
foreach (var item in liste)
{
Cks cks = new Cks();
cks.DosyaNo = item.CksDosyaNo;
cks.CepTelefonu = item.MobilePhone;
cks.EvTelefonu = item.HomePhone;
cks.Tc = item.TcKimlikNo;
cks.IsimSoyisim = item.NameSurname;
cks.KayitTarihi = item.FileDeliveryDate.ToString().Substring(0, 10);
cks.KoyMahalle = item.Village;
cks.BabaAdi = item.FatherName;
cksListe.Add(cks);
}
CksDal dal = new CksDal();
foreach (var kayit in cksListe)
{
try
{
result = dal.Add(kayit);
Console.WriteLine($"{result} Row efected {kayit.DosyaNo} {kayit.Tc} {kayit.IsimSoyisim} {kayit.KoyMahalle}");
}
catch (Exception exception)
{
Console.WriteLine(exception.Message);
Console.ReadLine();
}
}
Listele();
Console.ReadLine();
}
public CksManager()
{
_dal = new CksDal();
}
