public static Kunde Create(string id , string deviceLanguage ,ref BusinessLayer.User user)
{
// das Objekt wird mit einem vorhandenen Kunden initializiert
DataAccessLayer.DAL_Kunde dal_Kunde = new DataAccessLayer.DAL_Kunde ();
var kunde = dal_Kunde.GetKunde (id, deviceLanguage, ref user);
return kunde;
}
public static async System.Threading.Tasks.Task<List<Kunde>> GetKundenAsync( string Name , string deviceLanguage ,BusinessLayer.User User)
{
DataAccessLayer.DAL_Kunde dal_Kunde = new DataAccessLayer.DAL_Kunde ();
var kunden =await dal_Kunde.GetKundenAsync (Name, deviceLanguage, User);
return kunden;
}
public static List<Kunde> GetKunden ( string name ,string deviceLanguage ,ref BusinessLayer.User user)
{
// Alle Kunden, die in dem Namen den Begriff <name> enthalten
DataAccessLayer.DAL_Kunde dal_Kunde = new DataAccessLayer.DAL_Kunde ();
var kunden = dal_Kunde.GetKunden (name ,deviceLanguage, ref user);
return kunden;
}
public static List<Kunde> GetKunden( string Name , string deviceLanguage , BusinessLayer.User User, bool offline)
{
if (offline == false)
return GetKunden (Name, deviceLanguage, ref User);
// Alle Kunden, die in dem Namen den Begriff <name> enthalten
DataAccessLayer.DAL_Kunde dal_Kunde = new DataAccessLayer.DAL_Kunde();
var kunden = dal_Kunde.GetKunden (Name, deviceLanguage, ref User, true);
return kunden;
}
public static async System.Threading.Tasks.Task<List<Kunde>> GetKundenAsync( string Name , string deviceLanguage ,BusinessLayer.User User, bool offline)
{
DataAccessLayer.DAL_Kunde dal_Kunde = new DataAccessLayer.DAL_Kunde ();
if (offline == false)
{
var kunden =await dal_Kunde.GetKundenAsync (Name, deviceLanguage, User);
return kunden;
}
else
{
var kunden =await dal_Kunde.GetKundenAsync (Name, deviceLanguage, User, true);
return kunden;
}
}
override async public void FillAddressenAsync(string deviceLanguage, BusinessLayer.User user)
{
// First we get the Rechnungsanschrift
// if there is noone, the Rechnungsaddresse is the Kundenaddress
DataAccessLayer.DAL_Kunde dal_kunde = new DataAccessLayer.DAL_Kunde();
this.RechnungsAnschriften = await dal_kunde.GetRechnungsAnschriftenAsync(this, deviceLanguage, user);
if (RechnungsAnschriften == null)
return ;
if (UtilityClasses.IsNullOrEmpty(this.RechnungsAnschriften))
{
Anschrift temp = new Anschrift();
temp.Name = this.Name;
temp.ID = this.ID;
temp.Land = this.Land;
temp.LandNummer = this.LandNummer;
temp.PLZ = this.PLZ;
temp.Ort = this.Ort;
this.RechnungsAnschriften.Add(temp);
}
// Then we get the Lieferanschrift
// if there is no one, the Lieferaddresse is the Kundenaddresse
this.LieferAnschriften = await dal_kunde.GetLieferAnschriftenAsync(this, deviceLanguage, user);
if (UtilityClasses.IsNullOrEmpty(this.LieferAnschriften))
{
Anschrift temp = new Anschrift();
temp.Name = this.Name;
temp.ID = this.ID;
temp.Land = this.Land;
temp.LandNummer = this.LandNummer;
temp.PLZ = this.PLZ;
temp.Ort = this.Ort;
this.LieferAnschriften.Add(temp);
}
}
public override DataAccessLayer.SOAResult Delete (ref BusinessLayer.User user)
{
DataAccessLayer.DAL_Kunde dal_kunde = new DataAccessLayer.DAL_Kunde ();
// There must be an ID to delete the Kunde
if (ID == null)
return DataAccessLayer.SOAResult.FALSE;
if (dal_kunde.DeleteKunde(this, ref user) == DataAccessLayer.SOAResult.TRUE)
{
// clear the values of the Kunde
ID = "";
Name = "";
Nummer = "";
Strasse = "";
PLZ = "";
Ort = "";
Land = "";
Telefon = "";
Email = "";
Geburtsdatum = "";
return DataAccessLayer.SOAResult.TRUE;
}
else
{
return DataAccessLayer.SOAResult.FALSE;
}
}
public override DataAccessLayer.SOAResult DownloadLocal( string deviceLanguage ,ref User user)
{
// First we have to save the Kunde data
DataAccessLayer.SOAResult result;
DataAccessLayer.DAL_Kunde dal_Kunde = new DataAccessLayer.DAL_Kunde();
result = dal_Kunde.InsertKunde(this, ref user,true);
// Then the related data
// 1. Ansprechpartner
if (result == DataAccessLayer.SOAResult.TRUE)
{
ProgressStatusWish += 3;
List<Ansprechpartner> ansprechpartnern = Ansprechpartner.GetAnsprechpartnern(this.ID, deviceLanguage, ref user);
ProgressStatus += 3;
ProgressStatusWish += 1;
DataAccessLayer.DAL_Ansprechpartner dal_ansprechpartner = new DataAccessLayer.DAL_Ansprechpartner();
result = dal_ansprechpartner.InsertAnsprechpartnern(ansprechpartnern,user,true);
ProgressStatus += 1;
}
if (result == DataAccessLayer.SOAResult.TRUE)
{
ProgressStatusWish += 3;
List<BusinessLayer.PersonUmsatz> PersonUmsatzList = GetPersonTimeUmsatz("36", ref user);
ProgressStatus += 3;
ProgressStatusWish += 4;
result = dal_Kunde.InsertPersonUmsatz(PersonUmsatzList, this, user, true);
ProgressStatus += 4;
}
DataAccessLayer.DAL_Task dal_task = new DataAccessLayer.DAL_Task();
if (result == DataAccessLayer.SOAResult.TRUE)
{
ProgressStatusWish += 11;
List<Task> tasks = dal_task.GetTasks(ID, ref user);
ProgressStatus += 11;
ProgressStatusWish += 51;
result = dal_task.InsertTasks(tasks, user, true);
ProgressStatus += 51;
}
if (result == DataAccessLayer.SOAResult.TRUE)
{
ProgressStatusWish += 4;
List<TaskArt> taskArts = DataAccessLayer.DAL_Task.GetTaskArts(ref user);
ProgressStatusWish += 1;
result = dal_task.InsertTaskArts(taskArts, user, true);
ProgressStatus += 1;
}
// III. TaskTyp
if (result == DataAccessLayer.SOAResult.TRUE)
{
ProgressStatusWish += 4;
List<TaskTyp> taskTyps = DataAccessLayer.DAL_Task.GetTaskTyps(ref user);
ProgressStatus += 4;
ProgressStatusWish += 1;
result = dal_task.InsertTaskTyps(taskTyps, user, true);
ProgressStatus += 1;
}
// IV. Mitarbeiter
if (result == DataAccessLayer.SOAResult.TRUE)
{
ProgressStatusWish += 6;
List<Mitarbeiter> mitarbeitern = DataAccessLayer.DAL_Task.GetTaskMitarbeitern(ref user);
ProgressStatus += 6;
ProgressStatusWish += 3;
result = dal_task.InsertMitarbeitern(mitarbeitern, user, true);
ProgressStatus += 3;
}
// V. Abteilung
if (result == DataAccessLayer.SOAResult.TRUE)
{
ProgressStatusWish += 6;
List<Abteilung> abteilungen = DataAccessLayer.DAL_Task.GetTaskAbteilungen(ref user);
ProgressStatus += 6;
ProgressStatusWish += 1;
result = dal_task.InsertAbteilungen(abteilungen, user, true);
ProgressStatus += 1;
}
return result;
}
async public override Task<DataAccessLayer.SOAResult> SaveAsync ( BusinessLayer.User user, bool Offline)
{
if (Offline == false)
return await SaveAsync ( user);
// First check if this is an Insert or Update Statement
DataAccessLayer.DAL_Kunde dal_Kunde = new DataAccessLayer.DAL_Kunde ();
if (ID == null)
{
// This is an Insert statement
return await dal_Kunde.InsertKundeAsync (this, user,true);
}
else
{
// This is an Update statement
return await dal_Kunde.InsertKundeAsync(this, user,true);
}
}
public override DataAccessLayer.SOAResult Save ( BusinessLayer.User user)
{
// First check if this is an Insert or Update Statement
DataAccessLayer.DAL_Kunde dal_Kunde = new DataAccessLayer.DAL_Kunde ();
if (ID == null)
{
// This is an Insert statement
return dal_Kunde.InsertKunde (this, ref user);
}
else
{
// This is an Update statement
return dal_Kunde.UpdateKunde (this,ref user);
}
}
async public override System.Threading.Tasks.Task<System.Collections.Generic.List<BusinessLayer.PersonUmsatz>> GetPersonTimeUmsatzAsync(string interval , BusinessLayer.User user)
{
DataAccessLayer.DAL_Kunde dal_Kunde = new DataAccessLayer.DAL_Kunde ();
if (ID == null)
return null;
System.Collections.Generic.List<BusinessLayer.PersonUmsatz> personUmsatzList;
personUmsatzList = await dal_Kunde.GetKundeTimeUmsatzAsync (ID, interval, user);
return personUmsatzList;
}
public override System.Collections.Generic.List<BusinessLayer.PersonUmsatz> GetPersonTimeUmsatz(string interval , BusinessLayer.User user)
{
DataAccessLayer.DAL_Kunde dal_Kunde = new DataAccessLayer.DAL_Kunde ();
if (ID == null)
return null;
System.Collections.Generic.List<BusinessLayer.PersonUmsatz> personUmsatzList;
personUmsatzList = dal_Kunde.GetKundeTimeUmsatz (ID, interval, ref user);
return personUmsatzList;
}
public override async System.Threading.Tasks.Task<string> GetUmsatzAsync ( BusinessLayer.User user)
{
DataAccessLayer.DAL_Kunde dal_kunde = new DataAccessLayer.DAL_Kunde();
if(ID == null)
return "";
Umsatz = await dal_kunde.GetUmsatzAsync (ID, user);
if (Umsatz == "")
Umsatz = "€0";
else
Umsatz = "€" + Umsatz;
return Umsatz;
}
public override async System.Threading.Tasks.Task<DataAccessLayer.SOAResult> DownloadLocalAsync(User user, string deviceLanguage)
{
Console.WriteLine("__________________________________ START ___________________________________________________");
DataAccessLayer.SOAResult result = DataAccessLayer.SOAResult.FALSE;
try
{
// In this progress we increase the progress status, too
// Main step: Kunden Data
DataAccessLayer.PerformanceWatch stopWatch = new DataAccessLayer.PerformanceWatch();
stopWatch.Start();
ResetProgressStatus();
ProgressStatusWish = 1;
DataAccessLayer.DAL_Kunde dal_Kunde = new DataAccessLayer.DAL_Kunde();
using (await DataAccessLayer.SQLiteUtilities.Mutex.LockAsync ().ConfigureAwait (false)) {
result = await dal_Kunde.InsertKundeAsync(this, user,true);
}
// result = await dal_Kunde.InsertKundeAsync(this, user,true);
ProgressStatus = 1;
stopWatch.Stop();
stopWatch.PrintConsole ("InsertKundeAsync");
// Then the related data
// 1. Ansprechpartner
if (result == DataAccessLayer.SOAResult.TRUE)
{
stopWatch.Start();
ProgressStatusWish += 2;
List<Ansprechpartner> ansprechpartnern = await Ansprechpartner.GetAnsprechpartnernAsync(this.ID, deviceLanguage, user);
ProgressStatus += 2;
stopWatch.Stop();
stopWatch.PrintConsole ("GetAnsprechpartnernAsync");
stopWatch.Start();
ProgressStatusWish += 1;
DataAccessLayer.DAL_Ansprechpartner dal_ansprechpartner = new DataAccessLayer.DAL_Ansprechpartner();
using (await DataAccessLayer.SQLiteUtilities.Mutex.LockAsync ().ConfigureAwait (false)) {
result = await System.Threading.Tasks.Task.Run(() =>dal_ansprechpartner.InsertAnsprechpartnernAsync(ansprechpartnern,user,true));
}
ProgressStatus += 1;
stopWatch.Stop();
stopWatch.PrintConsole ("InsertAnsprechpartnernAsync");
ansprechpartnern = null;
}
// 2. PersonUmsatz for Charts
if (result == DataAccessLayer.SOAResult.TRUE)
{
stopWatch.Start();
ProgressStatusWish += 3;
List<BusinessLayer.PersonUmsatz> PersonUmsatzList = await GetPersonTimeUmsatzAsync ("36", user);
ProgressStatus += 3;
stopWatch.Stop();
stopWatch.PrintConsole ("GetPersonTimeUmsatzAsync");
stopWatch.Start();
ProgressStatusWish += 2;
using (await DataAccessLayer.SQLiteUtilities.Mutex.LockAsync ().ConfigureAwait (false)) {
result = await System.Threading.Tasks.Task.Run(() =>dal_Kunde.InsertPersonUmsatzAsync(PersonUmsatzList ,this, user, true));
}
ProgressStatus += 2;
stopWatch.Stop();
stopWatch.PrintConsole ("InsertPersonUmsatzAsync");
PersonUmsatzList = null;
stopWatch.PrintConsole ("Finished InsertPersonUmsatzAsync");
}
// 3. Tasks and related data
// I. Tasks
DataAccessLayer.DAL_Task dal_task = new DataAccessLayer.DAL_Task();
if (result == DataAccessLayer.SOAResult.TRUE)
{
stopWatch.Start();
ProgressStatusWish += 11;
Console.WriteLine("Start dal_task.GetTasksAsync");
List<Task> tasks = await dal_task.GetTasksAsync(this.ID, user);
ProgressStatus += 11;
stopWatch.Stop();
stopWatch.PrintConsole ("GetTasksAsync");
stopWatch.Start();
stopWatch.PrintConsole ("GetTasksAsync2");
ProgressStatusWish += 32;
stopWatch.PrintConsole ("GetTasksAsync3");
using (await DataAccessLayer.SQLiteUtilities.Mutex.LockAsync ().ConfigureAwait (false)) {
result = await System.Threading.Tasks.Task.Run(() =>dal_task.InsertTasksAsync(tasks, user, true));
}
stopWatch.PrintConsole ("GetTasksAsync4");
//result = await dal_task.InsertTasksAsync(tasks, user, true);
ProgressStatus += 32;
stopWatch.Stop();
stopWatch.PrintConsole ("InsertTasksAsync");
tasks = null;
}
// II. TaskArt
if (result == DataAccessLayer.SOAResult.TRUE)
{
stopWatch.Start();
ProgressStatusWish += 2;
List<TaskArt> taskArts = await DataAccessLayer.DAL_Task.GetTaskArtsAsync(user);
ProgressStatus += 2;
stopWatch.Stop();
stopWatch.PrintConsole ("GetTaskArtsAsync");
stopWatch.Start();
ProgressStatusWish += 1;
using (await DataAccessLayer.SQLiteUtilities.Mutex.LockAsync ().ConfigureAwait (false)) {
result = await System.Threading.Tasks.Task.Run(() =>dal_task.InsertTaskArtsAsync(taskArts, user, true));
}
ProgressStatus += 1;
stopWatch.Stop();
stopWatch.PrintConsole ("InsertTaskArtsAsync");
taskArts = null;
}
// III. TaskTyp
if (result == DataAccessLayer.SOAResult.TRUE)
{
stopWatch.Start();
ProgressStatusWish += 3;
List<TaskTyp> taskTyps = await DataAccessLayer.DAL_Task.GetTaskTypsAsync(user);
ProgressStatus += 3;
stopWatch.Stop();
stopWatch.PrintConsole ("GetTaskTypsAsync");
stopWatch.Start();
ProgressStatusWish += 1;
using (await DataAccessLayer.SQLiteUtilities.Mutex.LockAsync ().ConfigureAwait (false)) {
result = await System.Threading.Tasks.Task.Run(() =>dal_task.InsertTaskTypsAsync(taskTyps, user, true));
}
ProgressStatus += 1;
stopWatch.Stop();
stopWatch.PrintConsole ("InsertTaskTypsAsync");
}
// IV. Mitarbeiter
if (result == DataAccessLayer.SOAResult.TRUE)
{
stopWatch.Start();
ProgressStatusWish += 2;
List<Mitarbeiter> mitarbeitern = await DataAccessLayer.DAL_Task.GetTaskMitarbeiternAsync(user);
ProgressStatus += 2;
stopWatch.Stop();
stopWatch.PrintConsole ("GetTaskMitarbeiternAsync");
stopWatch.Start();
ProgressStatusWish += 1;
using (await DataAccessLayer.SQLiteUtilities.Mutex.LockAsync ().ConfigureAwait (false)) {
result = await System.Threading.Tasks.Task.Run(() =>dal_task.InsertMitarbeiternAsync(mitarbeitern, user, true));
}
ProgressStatus += 1;
stopWatch.Stop();
stopWatch.PrintConsole ("InsertMitarbeiternAsync");
}
// V. Abteilung
if (result == DataAccessLayer.SOAResult.TRUE)
{
stopWatch.Start();
ProgressStatusWish += 2;
List<Abteilung> abteilungen = await DataAccessLayer.DAL_Task.GetTaskAbteilungenAsync(user);
ProgressStatus += 2;
stopWatch.Stop();
stopWatch.PrintConsole ("GetTaskAbteilungenAsync");
stopWatch.Start();
ProgressStatusWish += 1;
using (await DataAccessLayer.SQLiteUtilities.Mutex.LockAsync ().ConfigureAwait (false)) {
result = await System.Threading.Tasks.Task.Run(() => dal_task.InsertAbteilungenAsync(abteilungen, user, true));
}
ProgressStatus += 1;
stopWatch.Stop();
stopWatch.PrintConsole ("InsertAbteilungenAsync");
}
// VI. Angebote
DataAccessLayer.DAL_Angebot dal_angebot = new DataAccessLayer.DAL_Angebot();
DataAccessLayer.DAL_Position dal_position = new DataAccessLayer.DAL_Position();
if(result == DataAccessLayer.SOAResult.TRUE)
{
stopWatch.Start();
ProgressStatusWish += 7;
List<Angebot> angebote = await dal_angebot.GetAngeboteAsync(ID, deviceLanguage, user);
ProgressStatus += 7;
stopWatch.Stop();
stopWatch.PrintConsole ("GetAngeboteAsync");
stopWatch.Start();
foreach (var angebot in angebote)
{
List<Position> positionen = await dal_position.GetPositionenAsync(angebot.ID, angebot.Waehrung, deviceLanguage, user);
result = await System.Threading.Tasks.Task.Run(() => dal_position.InsertPositionenAsync(positionen, user, true));
}
stopWatch.Stop();
stopWatch.PrintConsole ("AngebotGetPositionenAsyncInsertPositionenAsync");
ProgressStatusWish += 11;
stopWatch.Start();
using (await DataAccessLayer.SQLiteUtilities.Mutex.LockAsync ().ConfigureAwait (false)) {
result = await System.Threading.Tasks.Task.Run(() => dal_angebot.InsertAngeboteAsync(angebote, user, true));
}
ProgressStatus += 11;
stopWatch.Stop();
stopWatch.PrintConsole ("InsertAngeboteAsync");
}
// VI. Auftraege
DataAccessLayer.DAL_Auftrag dal_auftrag = new DataAccessLayer.DAL_Auftrag();
if(result == DataAccessLayer.SOAResult.TRUE)
{
stopWatch.Start();
ProgressStatusWish += 7;
List<Auftrag> auftraege = await dal_auftrag.GetAuftraegeAsync(ID, deviceLanguage, user);
ProgressStatus += 7;
stopWatch.Stop();
stopWatch.PrintConsole ("GetAuftraegeAsync");
stopWatch.Start();
foreach (var auftrag in auftraege)
{
List<Position> positionen = await dal_position.GetPositionenAsync(auftrag.ID, auftrag.Waehrung, deviceLanguage, user);
result = await System.Threading.Tasks.Task.Run(() => dal_position.InsertPositionenAsync(positionen, user, true));
}
stopWatch.Stop();
stopWatch.PrintConsole ("AuftragGetPositionenAsyncInsertPositionenAsync");
ProgressStatusWish += 6;
stopWatch.Start();
using (await DataAccessLayer.SQLiteUtilities.Mutex.LockAsync ().ConfigureAwait (false)) {
result = await System.Threading.Tasks.Task.Run(() => dal_auftrag.InsertAuftraegeAsync(auftraege, user, true));
}
ProgressStatus += 6;
stopWatch.Stop();
stopWatch.PrintConsole ("InsertAuftraegeAsync");
Console.WriteLine("__________________________________ END ___________________________________________________");
}
}
catch (Exception ex)
{
DataAccessLayer.ExceptionWriter.WriteLogFile(ex);
}
return result;
}
public override async System.Threading.Tasks.Task<DataAccessLayer.SOAResult> DownloadLocalAsync(User user, string deviceLanguage)
{
Console.WriteLine("__________________________________ START ___________________________________________________");
DataAccessLayer.SOAResult result = DataAccessLayer.SOAResult.FALSE;
try
{
// In this progress we increase the progress status, too
// Main step: Kunden Data
ResetProgressStatus();
ProgressStatusWish = 1;
DataAccessLayer.DAL_Kunde dal_Kunde = new DataAccessLayer.DAL_Kunde();
// first check permission
if (!user.HasPermission(DAC_Object.Kunde,BusinessLayer.DAC_Permission.DOWN_UPLOAD))
return DataAccessLayer.SOAResult.TRUE;
using (await DataAccessLayer.SQLiteUtilities.Mutex.LockAsync ().ConfigureAwait (false)) {
result = await dal_Kunde.InsertKundeAsync(this, user,true);
}
ProgressStatus = 1;
// Then the related data
// 1. Ansprechpartner
// We don't check permission for Ansprechpartner, cause Tasks and other modules will use it
if (result == DataAccessLayer.SOAResult.TRUE )
{
ProgressStatusWish += 2;
List<Ansprechpartner> ansprechpartnern = await Ansprechpartner.GetAnsprechpartnernAsync(this.ID, deviceLanguage, user);
ProgressStatus += 2;
ProgressStatusWish += 1;
DataAccessLayer.DAL_Ansprechpartner dal_ansprechpartner = new DataAccessLayer.DAL_Ansprechpartner();
using (await DataAccessLayer.SQLiteUtilities.Mutex.LockAsync ().ConfigureAwait (false)) {
result = await System.Threading.Tasks.Task.Run(() =>dal_ansprechpartner.InsertAnsprechpartnernAsync(ansprechpartnern,user,true));
}
ProgressStatus += 1;
ansprechpartnern = null;
}
// 2. PersonUmsatz for Charts
if (result == DataAccessLayer.SOAResult.TRUE && user.HasPermission(DAC_Object.Kunde_Chart,DAC_Permission.DOWN_UPLOAD))
{
ProgressStatusWish += 3;
List<BusinessLayer.PersonUmsatz> PersonUmsatzList = await GetPersonTimeUmsatzAsync ("36", user);
ProgressStatus += 3;
ProgressStatusWish += 2;
using (await DataAccessLayer.SQLiteUtilities.Mutex.LockAsync ().ConfigureAwait (false)) {
result = await System.Threading.Tasks.Task.Run(() =>dal_Kunde.InsertPersonUmsatzAsync(PersonUmsatzList ,this, user, true));
}
ProgressStatus += 2;
PersonUmsatzList = null;
}
// 3. Tasks and related data
// I. Tasks
DataAccessLayer.DAL_Task dal_task = new DataAccessLayer.DAL_Task();
if (result == DataAccessLayer.SOAResult.TRUE && user.HasPermission(DAC_Object.Kunde_Task,DAC_Permission.DOWN_UPLOAD))
{
ProgressStatusWish += 11;
List<Task> tasks = await dal_task.GetTasksAsync(this.ID, user);
ProgressStatus += 11;
ProgressStatusWish += 32;
using (await DataAccessLayer.SQLiteUtilities.Mutex.LockAsync ().ConfigureAwait (false)) {
result = await System.Threading.Tasks.Task.Run(() =>dal_task.InsertTasksAsync(tasks, user, true));
}
//result = await dal_task.InsertTasksAsync(tasks, user, true);
ProgressStatus += 32;
tasks = null;
}
// II. TaskArt
// These are help data, so permission checking is not needed
if (result == DataAccessLayer.SOAResult.TRUE )
{
ProgressStatusWish += 2;
List<TaskArt> taskArts = await DataAccessLayer.DAL_Task.GetTaskArtsAsync(user);
ProgressStatus += 2;
ProgressStatusWish += 1;
using (await DataAccessLayer.SQLiteUtilities.Mutex.LockAsync ().ConfigureAwait (false)) {
result = await System.Threading.Tasks.Task.Run(() =>dal_task.InsertTaskArtsAsync(taskArts, user, true));
}
ProgressStatus += 1;
taskArts = null;
}
// III. TaskTyp
// These are help data, so permission checking is not needed
if (result == DataAccessLayer.SOAResult.TRUE )
{
ProgressStatusWish += 3;
List<TaskTyp> taskTyps = await DataAccessLayer.DAL_Task.GetTaskTypsAsync(user);
ProgressStatus += 3;
ProgressStatusWish += 1;
using (await DataAccessLayer.SQLiteUtilities.Mutex.LockAsync ().ConfigureAwait (false)) {
result = await System.Threading.Tasks.Task.Run(() =>dal_task.InsertTaskTypsAsync(taskTyps, user, true));
}
ProgressStatus += 1;
}
// IV. Mitarbeiter
// These are help data, so permission checking is not needed
if (result == DataAccessLayer.SOAResult.TRUE )
{
ProgressStatusWish += 2;
List<Mitarbeiter> mitarbeitern = await DataAccessLayer.DAL_Task.GetTaskMitarbeiternAsync(user);
ProgressStatus += 2;
ProgressStatusWish += 1;
using (await DataAccessLayer.SQLiteUtilities.Mutex.LockAsync ().ConfigureAwait (false)) {
result = await System.Threading.Tasks.Task.Run(() =>dal_task.InsertMitarbeiternAsync(mitarbeitern, user, true));
}
ProgressStatus += 1;
}
// V. Abteilung
// These are help data, so permission checking is not needed
if (result == DataAccessLayer.SOAResult.TRUE )
{
ProgressStatusWish += 2;
List<Abteilung> abteilungen = await DataAccessLayer.DAL_Task.GetTaskAbteilungenAsync(user);
ProgressStatus += 2;
ProgressStatusWish += 1;
using (await DataAccessLayer.SQLiteUtilities.Mutex.LockAsync ().ConfigureAwait (false)) {
result = await System.Threading.Tasks.Task.Run(() => dal_task.InsertAbteilungenAsync(abteilungen, user, true));
}
ProgressStatus += 1;
}
// VI. Angebote
DataAccessLayer.DAL_Angebot dal_angebot = new DataAccessLayer.DAL_Angebot();
DataAccessLayer.DAL_Position dal_position = new DataAccessLayer.DAL_Position();
if(result == DataAccessLayer.SOAResult.TRUE && user.HasPermission(DAC_Object.Kunde_Angebot,DAC_Permission.DOWN_UPLOAD))
{
ProgressStatusWish += 7;
List<Angebot> angebote = await dal_angebot.GetAngeboteAsync(ID, deviceLanguage, user);
ProgressStatus += 7;
foreach (var angebot in angebote)
{
List<Position> positionen = await dal_position.GetPositionenAsync(angebot.ID, angebot.Waehrung, deviceLanguage, user);
result = await System.Threading.Tasks.Task.Run(() => dal_position.InsertPositionenAsync(positionen, user, true));
}
ProgressStatusWish += 11;
using (await DataAccessLayer.SQLiteUtilities.Mutex.LockAsync ().ConfigureAwait (false)) {
result = await System.Threading.Tasks.Task.Run(() => dal_angebot.InsertAngeboteAsync(angebote, user, true));
}
ProgressStatus += 11;
}
// VI. Auftraege
DataAccessLayer.DAL_Auftrag dal_auftrag = new DataAccessLayer.DAL_Auftrag();
if(result == DataAccessLayer.SOAResult.TRUE && user.HasPermission(DAC_Object.Kunde_Auftrag,DAC_Permission.DOWN_UPLOAD))
{
ProgressStatusWish += 7;
List<Auftrag> auftraege = await dal_auftrag.GetAuftraegeAsync(ID, deviceLanguage, user);
ProgressStatus += 7;
foreach (var auftrag in auftraege)
{
List<Position> positionen = await dal_position.GetPositionenAsync(auftrag.ID, auftrag.Waehrung, deviceLanguage, user);
result = await System.Threading.Tasks.Task.Run(() => dal_position.InsertPositionenAsync(positionen, user, true));
}
ProgressStatusWish += 6;
using (await DataAccessLayer.SQLiteUtilities.Mutex.LockAsync ().ConfigureAwait (false)) {
result = await System.Threading.Tasks.Task.Run(() => dal_auftrag.InsertAuftraegeAsync(auftraege, user, true));
}
ProgressStatus += 6;
Console.WriteLine("__________________________________ END ___________________________________________________");
}
}
catch (Exception ex)
{
DataAccessLayer.ExceptionWriter.WriteLogFile(ex);
}
return result;
}
public override string GetUmsatz ( BusinessLayer.User user)
{
DataAccessLayer.DAL_Kunde dal_kunde = new DataAccessLayer.DAL_Kunde();
if(ID == null)
return "";
Umsatz = dal_kunde.GetUmsatz (ID, ref user);
if (Umsatz == "")
Umsatz = "€0";
else
Umsatz = "€" + Umsatz;
return Umsatz;
}
public override DataAccessLayer.SOAResult Save (ref BusinessLayer.User user, bool Offline)
{
if (Offline == false)
return Save (ref user);
// First check if this is an Insert or Update Statement
DataAccessLayer.DAL_Kunde dal_Kunde = new DataAccessLayer.DAL_Kunde ();
if (ID == null)
{
// This is an Insert statement
return dal_Kunde.InsertKunde (this, ref user,true);
}
else
{
// This is an Update statement
return dal_Kunde.InsertKunde(this,ref user,true);
}
}
