private void Save_AgAnahtariTur(object sender, RoutedEventArgs e)
{
NotificationManager notificationManager = new NotificationManager();
var validationContext = new ValidationContext(agAnahtariTur, null, null);
var results = new List <System.ComponentModel.DataAnnotations.ValidationResult>();
if (Validator.TryValidateObject(agAnahtariTur, validationContext, results, true))
{
var response = service.SaveAgAnahtariTur(agAnahtariTur);
if (!response.HasError)
{
NotifySuccessPopup nfp = new NotifySuccessPopup();
nfp.msg.Text = response.Message;
nfp.Owner = Owner;
nfp.Show();
Close();
Owner.IsEnabled = true;
Owner.Effect = null;
}
else
{
if (response.HasWarning)
{
NotifyInfoPopup nfp = new NotifyInfoPopup();
nfp.msg.Text = response.Message;
nfp.Owner = Owner;
nfp.Show();
}
else
{
NotifyWarningPopup nfp = new NotifyWarningPopup();
nfp.msg.Text = "İşlem başarısız oldu.";
nfp.Owner = Owner;
nfp.Show();
}
}
}
else
{
foreach (var result in results)
{
foreach (var memberName in result.MemberNames)
{
if (memberName == "Ad")
{
Ad.BorderBrush = new SolidColorBrush(Colors.Red);
}
}
}
}
}
private void ConfirmButton_Click(object sender, RoutedEventArgs e)
{
var response = new ResponseModel();
if (selectedTipId == (int)TipEnum.AgAnahtari)
{
response = agAnahtariService.DeleteAgAnahtari((AgAnahtari)selectedItem);
(Owner as MainWindow).ListAgAnahtari();
}
if (selectedTipId == (int)TipEnum.UcBirim)
{
response = ucBirimService.DeleteUcBirim((UcBirim)selectedItem);
(Owner as MainWindow).ListUcBirim();
}
if (selectedTipId == (int)TipEnum.GucUretici)
{
response = gucUreticiService.DeleteGucUretici((GucUretici)selectedItem);
(Owner as MainWindow).ListGucUretici();
}
if (!response.HasError)
{
NotifySuccessPopup nfp = new NotifySuccessPopup();
nfp.msg.Text = response.Message;
nfp.Owner = Owner;
nfp.Show();
ClosePopup();
}
else
{
NotifyWarningPopup nfp = new NotifyWarningPopup();
nfp.msg.Text = response.Message;
nfp.Owner = Owner;
nfp.Show();
}
}
private void Import_ProjectLibrary(object sender, RoutedEventArgs e)
{
List <DbImportExportObjectModel> models = JsonConvert.DeserializeObject <List <DbImportExportObjectModel> >(File.ReadAllText(fileName));
var gucArayuzuList = new List <GucArayuzu>();
var gucUreticiList = new List <GucUretici>();
var ucBirimList = new List <UcBirim>();
var agAnahtariAgArayuzuList = new List <AgAnahtariAgArayuzu>();
var agAnahtariGucArayuzuList = new List <AgAnahtariGucArayuzu>();
var gucUreticiGucArayuzuList = new List <GucUreticiGucArayuzu>();
var ucBirimAgArayuzuList = new List <UcBirimAgArayuzu>();
var ucBirimGucArayuzuList = new List <UcBirimGucArayuzu>();
var agAnahtariTurList = new List <AgAnahtariTur>();
var gucUreticiTurList = new List <GucUreticiTur>();
var ucBirimTurList = new List <UcBirimTur>();
var agAnahtariList = new List <AgAnahtari>();
var agArayuzuList = new List <AgArayuzu>();
foreach (var model in models)
{
if (model.tableName == "GucArayuzu")
{
foreach (var row in model.rows)
{
gucArayuzuList.Add(row.ToObject <GucArayuzu>());
}
}
else if (model.tableName == "GucUretici")
{
foreach (var row in model.rows)
{
gucUreticiList.Add(row.ToObject <GucUretici>());
}
}
else if (model.tableName == "UcBirim")
{
foreach (var row in model.rows)
{
ucBirimList.Add(row.ToObject <UcBirim>());
}
}
else if (model.tableName == "AgAnahtariAgArayuzu")
{
foreach (var row in model.rows)
{
agAnahtariAgArayuzuList.Add(row.ToObject <AgAnahtariAgArayuzu>());
}
}
else if (model.tableName == "AgAnahtariGucArayuzu")
{
foreach (var row in model.rows)
{
agAnahtariGucArayuzuList.Add(row.ToObject <AgAnahtariGucArayuzu>());
}
}
else if (model.tableName == "GucUreticiGucArayuzu")
{
foreach (var row in model.rows)
{
gucUreticiGucArayuzuList.Add(row.ToObject <GucUreticiGucArayuzu>());
}
}
else if (model.tableName == "UcBirimAgArayuzu")
{
foreach (var row in model.rows)
{
ucBirimAgArayuzuList.Add(row.ToObject <UcBirimAgArayuzu>());
}
}
else if (model.tableName == "UcBirimGucArayuzu")
{
foreach (var row in model.rows)
{
ucBirimGucArayuzuList.Add(row.ToObject <UcBirimGucArayuzu>());
}
}
else if (model.tableName == "AgAnahtariTur")
{
foreach (var row in model.rows)
{
agAnahtariTurList.Add(row.ToObject <AgAnahtariTur>());
}
}
else if (model.tableName == "GucUreticiTur")
{
foreach (var row in model.rows)
{
gucUreticiTurList.Add(row.ToObject <GucUreticiTur>());
}
}
else if (model.tableName == "UcBirimTur")
{
foreach (var row in model.rows)
{
ucBirimTurList.Add(row.ToObject <UcBirimTur>());
}
}
else if (model.tableName == "AgAnahtari")
{
foreach (var row in model.rows)
{
agAnahtariList.Add(row.ToObject <AgAnahtari>());
}
}
else if (model.tableName == "AgArayuzu")
{
foreach (var row in model.rows)
{
agArayuzuList.Add(row.ToObject <AgArayuzu>());
}
}
}
foreach (var ucBirimTur in ucBirimTurList)
{
var tempUcBirimList = new List <UcBirim>();
var tempUcBirimAgArayuzuList = new List <UcBirimAgArayuzu>();
var tempAgArayuzuList = new List <AgArayuzu>();
var tempUcBirimGucArayuzuList = new List <UcBirimGucArayuzu>();
var tempGucArayuzuList = new List <GucArayuzu>();
tempUcBirimList = ucBirimList.Where(ub => ub.UcBirimTurId == ucBirimTur.Id).ToList();
foreach (var ucBirim in tempUcBirimList)
{
tempUcBirimAgArayuzuList.AddRange(ucBirimAgArayuzuList.Where(ubaa => ubaa.UcBirimId == ucBirim.Id).ToList());
tempUcBirimGucArayuzuList.AddRange(ucBirimGucArayuzuList.Where(ubga => ubga.UcBirimId == ucBirim.Id).ToList());
}
foreach (var ucBirimAgArayuzu in tempUcBirimAgArayuzuList)
{
tempAgArayuzuList.AddRange(agArayuzuList.Where(aa => aa.Id == ucBirimAgArayuzu.AgArayuzuId).ToList());
}
foreach (var ucBirimGucArayuzu in tempUcBirimGucArayuzuList)
{
tempGucArayuzuList.AddRange(gucArayuzuList.Where(ga => ga.Id == ucBirimGucArayuzu.GucArayuzuId).ToList());
}
ucBirimService.ImportUcBirimLibrary(ucBirimTur, tempUcBirimList, tempUcBirimAgArayuzuList, tempAgArayuzuList, tempUcBirimGucArayuzuList, tempGucArayuzuList);
}
foreach (var agAnahtariTur in agAnahtariTurList)
{
var tempAgAnahtariList = new List <AgAnahtari>();
var tempAgAnahtariAgArayuzuList = new List <AgAnahtariAgArayuzu>();
var tempAgArayuzuList = new List <AgArayuzu>();
var tempAgAnahtariGucArayuzuList = new List <AgAnahtariGucArayuzu>();
var tempGucArayuzuList = new List <GucArayuzu>();
tempAgAnahtariList = agAnahtariList.Where(ub => ub.AgAnahtariTurId == agAnahtariTur.Id).ToList();
foreach (var agAnahtari in tempAgAnahtariList)
{
tempAgAnahtariAgArayuzuList.AddRange(agAnahtariAgArayuzuList.Where(ubaa => ubaa.AgAnahtariId == agAnahtari.Id).ToList());
tempAgAnahtariGucArayuzuList.AddRange(agAnahtariGucArayuzuList.Where(ubga => ubga.AgAnahtariId == agAnahtari.Id).ToList());
}
foreach (var agAnahtariAgArayuzu in tempAgAnahtariAgArayuzuList)
{
tempAgArayuzuList.AddRange(agArayuzuList.Where(aa => aa.Id == agAnahtariAgArayuzu.AgArayuzuId).ToList());
}
foreach (var agAnahtariGucArayuzu in tempAgAnahtariGucArayuzuList)
{
tempGucArayuzuList.AddRange(gucArayuzuList.Where(ga => ga.Id == agAnahtariGucArayuzu.GucArayuzuId).ToList());
}
agAnahtariService.ImportAgAnahtariLibrary(agAnahtariTur, tempAgAnahtariList, tempAgAnahtariAgArayuzuList, tempAgArayuzuList, tempAgAnahtariGucArayuzuList, tempGucArayuzuList);
}
foreach (var gucUreticiTur in gucUreticiTurList)
{
var tempGucUreticiList = new List <GucUretici>();
var tempGucUreticiGucArayuzuList = new List <GucUreticiGucArayuzu>();
var tempGucArayuzuList = new List <GucArayuzu>();
tempGucUreticiList = gucUreticiList.Where(ub => ub.GucUreticiTurId == gucUreticiTur.Id).ToList();
foreach (var gucUretici in tempGucUreticiList)
{
tempGucUreticiGucArayuzuList.AddRange(gucUreticiGucArayuzuList.Where(ubga => ubga.GucUreticiId == gucUretici.Id).ToList());
}
foreach (var gucUreticiGucArayuzu in tempGucUreticiGucArayuzuList)
{
tempGucArayuzuList.AddRange(gucArayuzuList.Where(ga => ga.Id == gucUreticiGucArayuzu.GucArayuzuId).ToList());
}
gucUreticiService.ImportGucUreticiLibrary(gucUreticiTur, tempGucUreticiList, tempGucUreticiGucArayuzuList, tempGucArayuzuList);
}
var mainWindow = Owner as MainWindow;
mainWindow.ListUcBirim();
mainWindow.ListAgAnahtari();
mainWindow.ListGucUretici();
NotifySuccessPopup nfp = new NotifySuccessPopup();
nfp.msg.Text = "İşlem başarı ile gerçekleştirildi.";
nfp.Owner = Owner;
nfp.Show();
ClosePopup();
}
private void Save_TopluEdit(object sender, RoutedEventArgs e)
{
if (!string.IsNullOrEmpty(Uretici.Text) || !string.IsNullOrEmpty(UreticiParcaNo.Text) || !string.IsNullOrEmpty(Sembol.Text))
{
if (cihazTur == (int)TipEnum.UcBirim)
{
var response = serviceUcBirim.SaveTopluEdit(selectedIds, Uretici.Text, UreticiParcaNo.Text, sembolDosyaAdi, sembol);
if (!response.HasError)
{
NotifySuccessPopup nfp = new NotifySuccessPopup();
nfp.msg.Text = response.Message;
nfp.Owner = Owner;
nfp.Show();
(Owner as MainWindow).ListUcBirim();
ClosePopup();
}
else
{
NotifyWarningPopup nfp = new NotifyWarningPopup();
nfp.msg.Text = response.Message;
nfp.Owner = Owner;
nfp.Show();
}
}
else if (cihazTur == (int)TipEnum.AgAnahtari)
{
var response = serviceAgAnahtari.SaveTopluEdit(selectedIds, Uretici.Text, UreticiParcaNo.Text, sembolDosyaAdi, sembol);
if (!response.HasError)
{
NotifySuccessPopup nfp = new NotifySuccessPopup();
nfp.msg.Text = response.Message;
nfp.Owner = Owner;
nfp.Show();
(Owner as MainWindow).ListAgAnahtari();
ClosePopup();
}
else
{
NotifyWarningPopup nfp = new NotifyWarningPopup();
nfp.msg.Text = response.Message;
nfp.Owner = Owner;
nfp.Show();
}
}
else if (cihazTur == (int)TipEnum.GucUretici)
{
var response = serviceGucUreticisi.SaveTopluEdit(selectedIds, Uretici.Text, UreticiParcaNo.Text, sembolDosyaAdi, sembol);
if (!response.HasError)
{
NotifySuccessPopup nfp = new NotifySuccessPopup();
nfp.msg.Text = response.Message;
nfp.Owner = Owner;
nfp.Show();
(Owner as MainWindow).ListGucUretici();
ClosePopup();
}
else
{
NotifyWarningPopup nfp = new NotifyWarningPopup();
nfp.msg.Text = response.Message;
nfp.Owner = Owner;
nfp.Show();
}
}
}
else
{
NotifyInfoPopup nfp = new NotifyInfoPopup();
nfp.msg.Text = "Lütfen alanlardan en az biri için değer giriniz.";
nfp.Owner = Owner;
nfp.Show();
}
}
private void Save_ProjectLibrary(object sender, RoutedEventArgs e)
{
try
{
using (var connection = new SqlConnection(ConfigurationManager.ConnectionStrings["AYPContext"].ConnectionString))
{
connection.Open();
var tableNames = new List <string>();
//using (var command = new SqlCommand(@"SELECT table_name FROM information_schema.tables where table_schema = @database", connection))
using (var command = new SqlCommand(@"SELECT name FROM master.sys.tables where is_ms_shipped=0", connection))
{
command.Parameters.AddWithValue("@database", "master");
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
tableNames.Add(reader.GetString(0));
}
}
}
// open a JSON file for output; use the streaming JsonTextWriter interface to avoid high memory usage
using (var streamWriter = new StreamWriter(fileName))
using (var jsonWriter = new JsonTextWriter(streamWriter)
{
Formatting = Newtonsoft.Json.Formatting.Indented, Indentation = 2, IndentChar = ' '
})
{
// one array to hold all tables
jsonWriter.WriteStartArray();
foreach (var tableName in tableNames)
{
// an object for each table
jsonWriter.WriteStartObject();
jsonWriter.WritePropertyName("tableName");
jsonWriter.WriteValue(tableName);
jsonWriter.WritePropertyName("rows");
// an array for all the rows in the table
jsonWriter.WriteStartArray();
// select all the data from each table
using (var command = new SqlCommand($@"SELECT * FROM {tableName}", connection))
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
// write each row as a JSON object
jsonWriter.WriteStartObject();
for (int i = 0; i < reader.FieldCount; i++)
{
jsonWriter.WritePropertyName(reader.GetName(i));
jsonWriter.WriteValue(reader.GetValue(i));
}
jsonWriter.WriteEndObject();
}
}
jsonWriter.WriteEndArray();
jsonWriter.WriteEndObject();
}
jsonWriter.WriteEndArray();
NotifySuccessPopup nfp = new NotifySuccessPopup();
nfp.msg.Text = "Kütüphane başarıyla kaydedildi.";
nfp.Owner = Owner;
nfp.Show();
Close();
Owner.IsEnabled = true;
Owner.Effect = null;
}
}
}
catch
{
NotifyWarningPopup nfp = new NotifyWarningPopup();
nfp.msg.Text = "Veritabanı bağlantısı oluşturulamadı. Kütüphane aktarılamadı.";
nfp.Owner = Owner;
nfp.Show();
}
}
