private void InsertEvent_Load(object sender, EventArgs e)
{
DataTable dtLoc = new DataTable();
DataTable dtCat = new DataTable();
DataTable dtUse = new DataTable();
Category cat = new Category();
User use = new User();
BusinessLayer.Location loc = new Location();
dtLoc = loc.getLocaitonPickList();
dtCat = cat.getCategoryPickList();
dtUse = use.getPersonList();
cboCat.DataSource = dtCat;
cboLoc.DataSource = dtLoc;
cboUser.DataSource = dtUse;
cboCat.DisplayMember = "Descr";
cboCat.ValueMember = "CategoryID";
cboLoc.DisplayMember = "Descr";
cboLoc.ValueMember = "LocationID";
cboUser.DisplayMember = "Display";
cboUser.ValueMember = "UserID";
}
public void ModifyUser(String at, int userId, string forename, string surname, string password)
{
AuthenticationToken oAt = new AuthSvc().AuthUser(at, userId);
BusinessLayer.User u = BusinessLayer.User.Populate(userId);
u.Forename = forename;
u.Password = password;
u.Surname = surname;
u.Save();
}
public static User CreateUser(string forename, string surname, string username, string password)
{
User u = new User();
u.Forename = forename;
u.Surname = surname;
u.Username = username;
u.Password = password;
u.context = new marcdissertation_dbEntities();
u = u.context.Users.Add(u);
if (u.context.Users.Count(x => x.Username.Equals(username)) > 0) {
throw new Exception("Username must be unique.");
}
errors = u.context.GetValidationErrors();
try {
u.context.SaveChanges();
} catch (Exception e) {
throw App.ExceptionFormatter(errors);
}
return u;
}
static public async Task<List<Task>> UploadTasksAsync(List<Task> tasks, User user)
{
// let the magic start, but now asynchronously, boom boom
DataAccessLayer.DAL_Task dal_task = new DataAccessLayer.DAL_Task();
return await dal_task.InsertTasksAsync(tasks, user);
}
static public List<Task> UploadTasks(List<Task> tasks, User user)
{
// let the magic start
DataAccessLayer.DAL_Task dal_task = new DataAccessLayer.DAL_Task();
return dal_task.InsertTasks(tasks, user);
}
static public async Task<List<Task>> UploadOfflineTasksAsync(User user)
{
// Better Performance because all the offline and online stuff is done in one place, but async
DataAccessLayer.DAL_Task dal_task = new DataAccessLayer.DAL_Task();
return await dal_task.UploadOfflineTasksAsync(user);
}
static public List<Task> UploadOfflineTasks(User user)
{
// Better Performance because all the offline and online stuff is done in one place
DataAccessLayer.DAL_Task dal_task = new DataAccessLayer.DAL_Task();
return dal_task.UploadOfflineTasks(user);
}
public override async Task<Position> GetPreisBeforeCommitAsync(Position position, string kundeId, Artikel artikel, string datum, string menge, string deviceLanguage, User user)
{
if (String.IsNullOrEmpty(kundeId))
kundeId = "0";
if (String.IsNullOrEmpty(menge))
menge = "0";
// it does not make a difference to use the function of angebot
DataAccessLayer.DAL_Angebot dal_Angebot = new DataAccessLayer.DAL_Angebot();
return await dal_Angebot.GetAngebotPreisBeforeCommitAsync(this,position,kundeId, artikel, datum, menge, deviceLanguage, user);
}
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: Lieranten Data
ResetProgressStatus();
ProgressStatusWish = 1;
DataAccessLayer.DAL_Lieferant dal_Lieferant = new DataAccessLayer.DAL_Lieferant();
// first check permission
if (!user.HasPermission(DAC_Object.Lieferant,BusinessLayer.DAC_Permission.DOWN_UPLOAD))
return DataAccessLayer.SOAResult.TRUE;
using (await DataAccessLayer.SQLiteUtilities.Mutex.LockAsync ().ConfigureAwait (false)) {
result = await dal_Lieferant.InsertLieferantAsync(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;
}
// 2. PersonUmsatz for Charts
if (result == DataAccessLayer.SOAResult.TRUE && user.HasPermission(DAC_Object.Lieferant_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_Lieferant.InsertPersonUmsatzAsync(PersonUmsatzList, this, user, true));
}
ProgressStatus += 2;
}
// 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.Lieferant_Task,DAC_Permission.DOWN_UPLOAD))
{
ProgressStatusWish += 11;
List<Task> tasks = await dal_task.GetTasksAsync(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;
}
// 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;
}
// 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. Anfragen
DataAccessLayer.DAL_Anfrage dal_anfrage = new DataAccessLayer.DAL_Anfrage();
DataAccessLayer.DAL_Position dal_position = new DataAccessLayer.DAL_Position();
if (result == DataAccessLayer.SOAResult.TRUE && user.HasPermission(DAC_Object.Lieferant_Anfrage,DAC_Permission.DOWN_UPLOAD))
{
ProgressStatusWish += 7;
List<Anfrage> anfragen = await dal_anfrage.GetAnfragenAsync(ID, deviceLanguage, user);
ProgressStatus += 7;
foreach (var anfrage in anfragen)
{
List<Position> positionen = await dal_position.GetPositionenAsync(anfrage.ID, anfrage.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_anfrage.InsertAnfragenAsync(anfragen, user, true));
}
ProgressStatus += 11;
}
// VI. Bestellungen
DataAccessLayer.DAL_Bestellung dal_bestellung = new DataAccessLayer.DAL_Bestellung();
if (result == DataAccessLayer.SOAResult.TRUE && user.HasPermission(DAC_Object.Lieferant_Bestellung,DAC_Permission.DOWN_UPLOAD))
{
ProgressStatusWish += 7;
List<Bestellung> bestellungen = await dal_bestellung.GetBestellungenAsync(ID, deviceLanguage, user);
ProgressStatus += 7;
foreach (var bestellung in bestellungen)
{
List<Position> positionen = await dal_position.GetPositionenAsync(bestellung.ID, bestellung.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_bestellung.InsertBestellungenAsync(bestellungen, user, true));
}
ProgressStatus += 6;
}
}
catch (Exception ex)
{
DataAccessLayer.ExceptionWriter.WriteLogFile(ex);
}
return result;
}
public static async Task<User> CreateAsync( string name, string password, string mandant, DataAccessLayer.NetworkState state, bool offline)
{
DataAccessLayer.DAL_Session dal_Session = new DataAccessLayer.DAL_Session ();
var session = BusinessLayer.Session.Create ();
// First the Name and Password have to be authiticated
session = await dal_Session.GetSessionAsync (name, password, mandant, offline);
//DataAccessLayer.SOAResult result = await dal_Session.GetSessionAsync (session, name, password, mandant, state);
if (session.Success == DataAccessLayer.SOAResult.Disconnected)
{
// Then there is a connection failure
return null;
}
var user = new User ();
if (session.Success == DataAccessLayer.SOAResult.FALSE)
{
// Username and Password were wrong, return an empty object
return user;
}
DataAccessLayer.DAL_User dal_User = new DataAccessLayer.DAL_User ();
user.IdSession = session.ID;
user.ID = session.UserID;
user.Name = name;
user.Password = password;
user.Mandant = mandant;
if (offline == true)
user.NetworkStatus = DataAccessLayer.NetworkState.Disconnected;
else
user.NetworkStatus = state;
if (state != DataAccessLayer.NetworkState.Disconnected && offline == false)
await dal_User.SetUserPermissionsAsync ( user);
return user;
}
public static User Create( string name, string password, string mandant, DataAccessLayer.NetworkState state)
{
DataAccessLayer.DAL_Session dal_Session = new DataAccessLayer.DAL_Session ();
var session = BusinessLayer.Session.Create ();
// First the Name and Password have to be authiticated
if (dal_Session.GetSession (ref session,name,password,mandant,state) == DataAccessLayer.SOAResult.Disconnected)
{
// Then there is a connection failure
return null;
}
var user = new User ();
if (session.Success == DataAccessLayer.SOAResult.FALSE)
{
// Username and Password were wrong, return an empty object
return user;
}
DataAccessLayer.DAL_User dal_User = new DataAccessLayer.DAL_User ();
user.IdSession = session.ID;
user.ID = session.UserID;
user._Abteilung = session.Abteilung;
user.Name = name;
user.Password = password;
user.Mandant = mandant;
user.NetworkStatus = state;
if (state != DataAccessLayer.NetworkState.Disconnected)
dal_User.SetUserPermissions (ref user);
return user;
}
public static async Task<User> CreateAsync( string name, string password, string mandant, DataAccessLayer.NetworkState state, bool offline)
{
DataAccessLayer.DAL_Session dal_Session = new DataAccessLayer.DAL_Session ();
var session = BusinessLayer.Session.Create ();
// First the Name and Password have to be authiticated
session = await dal_Session.GetSessionAsync (name, password, mandant, offline);
//DataAccessLayer.SOAResult result = await dal_Session.GetSessionAsync (session, name, password, mandant, state);
if (session.Success == DataAccessLayer.SOAResult.Disconnected)
{
// Then there is a connection failure
return null;
}
var user = new User ();
if (session.Success == DataAccessLayer.SOAResult.FALSE)
{
// Username and Password were wrong, return an empty object
return user;
}
DataAccessLayer.DAL_User dal_User = new DataAccessLayer.DAL_User ();
user.IdSession = session.ID;
user.ID = session.UserID;
if (state != DataAccessLayer.NetworkState.Disconnected && offline == false)
{
user = await dal_User.SetUserPermissionsAsync(user);
// set if the user is able to create tasks in the offline modus
DataAccessLayer.DAL_User.SetOfflineInsertTask(
user.HasPermission(DAC_Object.Kunde_Task, BusinessLayer.DAC_Permission.CREATE),
user.HasPermission(DAC_Object.Lieferant_Task, BusinessLayer.DAC_Permission.CREATE),
user.HasPermission(DAC_Object.Interessent_Task, BusinessLayer.DAC_Permission.CREATE));
}
user.ID = session.UserID;
user.Name = name;
user.Password = password;
user.Mandant = mandant;
user.Abteilung = session.Abteilung;
user.Adr_Vertr = session.Adr_Vertr;
user.Adr_KeyAccount = session.Adr_KeyAccount;
if (offline == true)
user.NetworkStatus = DataAccessLayer.NetworkState.Disconnected;
else
user.NetworkStatus = state;
return user;
}
public override async Task<Position> GetPreisBeforeCommitAsync(Position position, string kundeId, Artikel artikel, string datum, string menge, string deviceLanguage, User user)
{
if (String.IsNullOrEmpty(kundeId))
kundeId = "0";
if (String.IsNullOrEmpty(menge))
menge = "0";
DataAccessLayer.DAL_Bestellung dal_Bestellung = new DataAccessLayer.DAL_Bestellung();
return await dal_Bestellung.GetBestellungPreisBeforeCommitAsync(this,position,kundeId, artikel, datum, menge, deviceLanguage, user);
}
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 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;
}