public BusinessPartnerOrganizationUnitListResponse GetBusinessPartnerOrganizationUnitsNewerThen(int companyId, DateTime?lastUpdateTime)
{
BusinessPartnerOrganizationUnitListResponse response = new BusinessPartnerOrganizationUnitListResponse();
try
{
if (lastUpdateTime != null)
{
response.BusinessPartnerOrganizationUnits = unitOfWork.GetBusinessPartnerOrganizationUnitRepository()
.GetBusinessPartnerOrganizationUnitsNewerThen(companyId, (DateTime)lastUpdateTime)
.ConvertToBusinessPartnerOrganizationUnitViewModelList();
}
else
{
response.BusinessPartnerOrganizationUnits = unitOfWork.GetBusinessPartnerOrganizationUnitRepository()
.GetBusinessPartnerOrganizationUnits(companyId)
.ConvertToBusinessPartnerOrganizationUnitViewModelList();
}
response.Success = true;
}
catch (Exception ex)
{
response.BusinessPartnerOrganizationUnits = new List <BusinessPartnerOrganizationUnitViewModel>();
response.Success = false;
response.Message = ex.Message;
}
return(response);
}
public BusinessPartnerOrganizationUnitListResponse Sync(SyncBusinessPartnerOrganizationUnitRequest request)
{
BusinessPartnerOrganizationUnitListResponse response = new BusinessPartnerOrganizationUnitListResponse();
try
{
response.BusinessPartnerOrganizationUnits = new List <BusinessPartnerOrganizationUnitViewModel>();
if (request.LastUpdatedAt != null)
{
response.BusinessPartnerOrganizationUnits.AddRange(unitOfWork.GetBusinessPartnerOrganizationUnitRepository()
.GetBusinessPartnerOrganizationUnitsNewerThen(request.CompanyId, (DateTime)request.LastUpdatedAt)
?.ConvertToBusinessPartnerOrganizationUnitViewModelList() ?? new List <BusinessPartnerOrganizationUnitViewModel>());
}
else
{
response.BusinessPartnerOrganizationUnits.AddRange(unitOfWork.GetBusinessPartnerOrganizationUnitRepository()
.GetBusinessPartnerOrganizationUnits(request.CompanyId)
?.ConvertToBusinessPartnerOrganizationUnitViewModelList() ?? new List <BusinessPartnerOrganizationUnitViewModel>());
}
response.Success = true;
}
catch (Exception ex)
{
response.BusinessPartnerOrganizationUnits = new List <BusinessPartnerOrganizationUnitViewModel>();
response.Success = false;
response.Message = ex.Message;
}
return(response);
}
public BusinessPartnerOrganizationUnitListResponse Sync(SyncBusinessPartnerOrganizationUnitRequest request)
{
BusinessPartnerOrganizationUnitListResponse response = new BusinessPartnerOrganizationUnitListResponse();
try
{
response = WpfApiHandler.SendToApi <SyncBusinessPartnerOrganizationUnitRequest, BusinessPartnerOrganizationUnitViewModel, BusinessPartnerOrganizationUnitListResponse>(request, "Sync");
}
catch (Exception ex)
{
response.BusinessPartnerOrganizationUnits = new List <BusinessPartnerOrganizationUnitViewModel>();
response.Success = false;
response.Message = ex.Message;
}
return(response);
}
public BusinessPartnerOrganizationUnitListResponse GetBusinessPartnerOrganizationUnits(int companyId)
{
BusinessPartnerOrganizationUnitListResponse response = new BusinessPartnerOrganizationUnitListResponse();
try
{
Dictionary <string, string> parameters = new Dictionary <string, string>();
parameters.Add("CompanyID", companyId.ToString());
response = WpfApiHandler.GetFromApi <List <BusinessPartnerOrganizationUnitViewModel>, BusinessPartnerOrganizationUnitListResponse>("GetBusinessPartnerOrganizationUnits", parameters);
}
catch (Exception ex)
{
response.Success = false;
response.Message = ex.Message;
}
return(response);
}
public BusinessPartnerOrganizationUnitListResponse GetBusinessPartnerOrganizationUnitsNewerThen(int companyId, DateTime?lastUpdateTime)
{
BusinessPartnerOrganizationUnitListResponse response = new BusinessPartnerOrganizationUnitListResponse();
try
{
response = WpfApiHandler.GetFromApi <List <BusinessPartnerOrganizationUnitViewModel>, BusinessPartnerOrganizationUnitListResponse>("GetBusinessPartnerOrganizationUnitsNewerThen", new Dictionary <string, string>()
{
{ "CompanyId", companyId.ToString() },
{ "LastUpdateTime", lastUpdateTime.ToString() }
});
}
catch (Exception ex)
{
response.Success = false;
response.Message = ex.Message;
}
return(response);
}
public BusinessPartnerOrganizationUnitListResponse GetBusinessPartnerOrganizationUnits(int companyId)
{
BusinessPartnerOrganizationUnitListResponse response = new BusinessPartnerOrganizationUnitListResponse();
try
{
response.BusinessPartnerOrganizationUnits = unitOfWork.GetBusinessPartnerOrganizationUnitRepository()
.GetBusinessPartnerOrganizationUnits(companyId)
.ConvertToBusinessPartnerOrganizationUnitViewModelList();
response.Success = true;
}
catch (Exception ex)
{
response.BusinessPartnerOrganizationUnits = new List <BusinessPartnerOrganizationUnitViewModel>();
response.Success = false;
response.Message = ex.Message;
}
return(response);
}
public JsonResult GetBusinessPartnerOrganizationUnitsNewerThen(int CompanyId, DateTime?lastUpdateTime)
{
BusinessPartnerOrganizationUnitListResponse response = new BusinessPartnerOrganizationUnitListResponse();
try
{
response = businessPartnerOrganizationUnitService.GetBusinessPartnerOrganizationUnitsNewerThen(CompanyId, lastUpdateTime);
}
catch (Exception ex)
{
response.Success = false;
response.Message = ex.Message;
Console.WriteLine(ex.Message);
}
return(Json(response, new Newtonsoft.Json.JsonSerializerSettings()
{
Formatting = Newtonsoft.Json.Formatting.Indented
}));
}
public JsonResult Sync([FromBody] SyncBusinessPartnerOrganizationUnitRequest request)
{
BusinessPartnerOrganizationUnitListResponse response = new BusinessPartnerOrganizationUnitListResponse();
try
{
response = this.businessPartnerOrganizationUnitService.Sync(request);
}
catch (Exception ex)
{
response.Success = false;
response.Message = ex.Message;
}
return(Json(response, new Newtonsoft.Json.JsonSerializerSettings()
{
Formatting = Newtonsoft.Json.Formatting.Indented
}));
}
public BusinessPartnerOrganizationUnitListResponse GetBusinessPartnerOrganizationUnitsByBusinessPartner(int companyId, Guid businessPartnerIdentifier)
{
BusinessPartnerOrganizationUnitListResponse response = new BusinessPartnerOrganizationUnitListResponse();
List <BusinessPartnerOrganizationUnitViewModel> businessPartnerOrganizationUnits = new List <BusinessPartnerOrganizationUnitViewModel>();
using (SqliteConnection db = new SqliteConnection("Filename=SirmiumERPGFC.db"))
{
db.Open();
try
{
SqliteCommand selectCommand = new SqliteCommand(
SqlCommandSelectPart +
"FROM BusinessPartnerOrganizationUnits " +
"WHERE BusinessPartnerIdentifier = @BusinessPartnerIdentifier " +
"AND CompanyId = @CompanyId " +
"ORDER BY IsSynced, Id DESC;", db);
selectCommand.Parameters.AddWithValue("@BusinessPartnerIdentifier", businessPartnerIdentifier);
selectCommand.Parameters.AddWithValue("@CompanyId", companyId);
SqliteDataReader query = selectCommand.ExecuteReader();
while (query.Read())
{
businessPartnerOrganizationUnits.Add(Read(query));
}
}
catch (SqliteException error)
{
MainWindow.ErrorMessage = error.Message;
response.Success = false;
response.Message = error.Message;
response.BusinessPartnerOrganizationUnits = new List <BusinessPartnerOrganizationUnitViewModel>();
return(response);
}
db.Close();
}
response.Success = true;
response.BusinessPartnerOrganizationUnits = businessPartnerOrganizationUnits;
return(response);
}
