public static void RefreshData(BankaSubeTumListe values)
{
GetMappingData();
foreach (var value in values.BankaSubeleri)
{
foreach (var data in mappingData)
{
if (value.Banka.BKd == data.BankCode && value.Banka.BAd != data.BankName)
{
value.Banka.BAd = data.BankName;
}
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (filePath != String.Empty)
{
try
{
list = SerializeConfig <BankaSubeTumListe> .DeSerialize(filePath);
DbOperations.AddDatabase(list);
if (DbOperations.result)
{
MessageBox.Show("Veritabanına başarıyla kaydedildi.");
}
}
catch (Exception)
{
MessageBox.Show("Dosyadan veriler alınamadı.");
}
}
else
{
MessageBox.Show("Lütfen bir dosya seçiniz...");
}
}
public static void AddDatabase(BankaSubeTumListe values)
{
RefreshData(values);
foreach (var value in values.BankaSubeleri)
{
temp = @"
Insert into XML_PARSER_BANKS (bKd,bAd,bIlAd,adr,sonIslemTuru, sonIslemZamani)
Values('@bKd','@bAd','@bIlAd','@adr','@sonIslemTuru','@sonIslemZamani')
";
temp = temp.Replace("@bKd", value.Banka.BKd.Trim());
temp = temp.Replace("@bAd", value.Banka.BAd.Trim());
temp = temp.Replace("@bIlAd", value.Banka.BIlAd.Trim());
temp = temp.Replace("@adr", value.Banka.Adr.Trim());
temp = temp.Replace("@sonIslemTuru", value.Banka.SonIslemTuru.Trim());
temp = temp.Replace("@sonIslemZamani", value.Banka.SonIslemZamani.Trim());
sqlStatement += temp;
branchs = value.Sube;
foreach (var branch in branchs)
{
temp = @"
Insert into XML_PARSER_BRANCHS (sKd,bKd,sAd,sIlAd,sIlcAd,sIlcKd,sIlKd,tlf,adr,fks,epst,sonIslemTuru,sonIslemZamani)
Values('@sKd','@bKd','@sAd','@sIlAd','@sIlcAd','@sIlcKd','@sIlKd','@tlf','@adr','@fks','@epst','@sonIslemTuru','@sonIslemZamani')
";
temp = temp.Replace("@sKd", branch.SKd.Trim());
temp = temp.Replace("@bKd", branch.BKd.Trim());
temp = temp.Replace("@sAd", branch.SAd.Trim());
temp = temp.Replace("@sIlAd", branch.SIlAd);
temp = temp.Replace("@sIlcAd", branch.SIlcAd);
temp = temp.Replace("@sIlcKd", branch.SIlcKd);
temp = temp.Replace("@sIlKd", branch.SIlKd.Trim());
temp = temp.Replace("@tlf", branch.Tlf);
temp = temp.Replace("@adr", branch.Adr);
temp = temp.Replace("@fks", branch.Fks);
temp = temp.Replace("@epst", branch.Epst);
temp = temp.Replace("@sonIslemTuru", branch.SonIslemTuru.Trim());
temp = temp.Replace("@sonIslemZamani", branch.SonIslemZamani.Trim());
sqlStatement += temp;
}
try
{
using (SqlConnection connection = new SqlConnection("data source=yourDb;persist security info=True;initial catalog=yourcatalog;User id=yourid;Password=yourpass")
{
SqlCommand command = new SqlCommand(sqlStatement, connection);
connection.Open();
command.ExecuteNonQuery();
connection.Close();
}
sqlStatement = String.Empty;
result = true;
}
catch
{
MessageBox.Show("Dosyada sorunlu veri var.");
result = false;
sqlStatement = String.Empty;
break;
}
}
}