public ServiceDeliveryResponse GetServiceSDeliveryById(int serviceDeliveryId)
{
var response = new ServiceDeliveryResponse();
try
{
var serviceDeliveryRepository = new ServiceDeliveryRepository();
var serviceDelivery = serviceDeliveryRepository.Query().FirstOrDefault(x => x.idServiceDelivery == serviceDeliveryId);
if (serviceDelivery != null)
{
response.ServiceDelivery = new ServiceDeliveryDto()
{
idServiceDelivery = serviceDelivery.idServiceDelivery,
IdServiceSubscription = serviceDelivery.IdServiceSubscription,
DateDelivered = serviceDelivery.DateDelivered,
DeliveryDateTo = serviceDelivery.DeliveryDateTo
};
response.Acknowledgment = true;
response.Message = "Success";
}
else
{
response.Acknowledgment = false;
response.Message = "Invalid Delivery Id";
}
}
catch (Exception ex)
{
response.Acknowledgment = false;
response.Message = ex.Message;
}
return(response);
}
public ServiceDeliveryResponse Delete(Guid identifier)
{
ServiceDeliveryResponse response = new ServiceDeliveryResponse();
using (SqliteConnection db = new SqliteConnection("Filename=SirmiumERPGFC.db"))
{
db.Open();
SqliteCommand insertCommand = new SqliteCommand();
insertCommand.Connection = db;
//Use parameterized query to prevent SQL injection attacks
insertCommand.CommandText = "DELETE FROM ServiceDeliverys WHERE Identifier = @Identifier";
insertCommand.Parameters.AddWithValue("@Identifier", identifier);
try
{
insertCommand.ExecuteNonQuery();
}
catch (SqliteException error)
{
MainWindow.ErrorMessage = error.Message;
response.Success = false;
response.Message = error.Message;
return(response);
}
db.Close();
response.Success = true;
return(response);
}
}
public ServiceDeliveryResponse Create(ServiceDeliveryViewModel serviceDelivery)
{
ServiceDeliveryResponse response = new ServiceDeliveryResponse();
using (SqliteConnection db = new SqliteConnection("Filename=SirmiumERPGFC.db"))
{
db.Open();
SqliteCommand insertCommand = db.CreateCommand();
insertCommand.CommandText = SqlCommandInsertPart;
try
{
insertCommand = AddCreateParameters(insertCommand, serviceDelivery);
insertCommand.ExecuteNonQuery();
}
catch (SqliteException error)
{
MainWindow.ErrorMessage = error.Message;
response.Success = false;
response.Message = error.Message;
return(response);
}
db.Close();
response.Success = true;
return(response);
}
}
public ServiceDeliveryResponse Create(ServiceDeliveryViewModel serviceDelivery)
{
ServiceDeliveryResponse response = new ServiceDeliveryResponse();
try
{
response = WpfApiHandler.SendToApi <ServiceDeliveryViewModel, ServiceDeliveryResponse>(serviceDelivery, "Create");
}
catch (Exception ex)
{
response.ServiceDelivery = new ServiceDeliveryViewModel();
response.Success = false;
response.Message = ex.Message;
}
return(response);
}
public ServiceDeliveryResponse Delete(Guid identifier)
{
ServiceDeliveryResponse response = new ServiceDeliveryResponse();
try
{
ServiceDeliveryViewModel serviceDelivery = new ServiceDeliveryViewModel();
serviceDelivery.Identifier = identifier;
response = WpfApiHandler.SendToApi <ServiceDeliveryViewModel, ServiceDeliveryResponse>(serviceDelivery, "Delete");
}
catch (Exception ex)
{
response.ServiceDelivery = new ServiceDeliveryViewModel();
response.Success = false;
response.Message = ex.Message;
}
return(response);
}
public ServiceDeliveryResponse Delete(Guid identifier)
{
ServiceDeliveryResponse response = new ServiceDeliveryResponse();
try
{
ServiceDelivery deletedServiceDelivery = unitOfWork.GetServiceDeliveryRepository().Delete(identifier);
unitOfWork.Save();
response.ServiceDelivery = deletedServiceDelivery.ConvertToServiceDeliveryViewModel();
response.Success = true;
}
catch (Exception ex)
{
response.ServiceDelivery = new ServiceDeliveryViewModel();
response.Success = false;
response.Message = ex.Message;
}
return(response);
}
public ServiceDeliveryResponse Create(ServiceDeliveryViewModel re)
{
ServiceDeliveryResponse response = new ServiceDeliveryResponse();
try
{
ServiceDelivery addedServiceDelivery = unitOfWork.GetServiceDeliveryRepository().Create(re.ConvertToServiceDelivery());
unitOfWork.Save();
response.ServiceDelivery = addedServiceDelivery.ConvertToServiceDeliveryViewModel();
response.Success = true;
}
catch (Exception ex)
{
response.ServiceDelivery = new ServiceDeliveryViewModel();
response.Success = false;
response.Message = ex.Message;
}
return(response);
}
private void BtnDelete_Click(object sender, RoutedEventArgs e)
{
Thread th = new Thread(() =>
{
ServiceDeliveryDataLoading = true;
if (CurrentServiceDelivery == null)
{
MainWindow.WarningMessage = ((string)Application.Current.FindResource("Morate_odabrati_stavku_za_brisanjeUzvičnik"));
ServiceDeliveryDataLoading = false;
return;
}
ServiceDeliveryResponse response = ServiceDeliveryService.Delete(CurrentServiceDelivery.Identifier);
if (!response.Success)
{
MainWindow.ErrorMessage = ((string)Application.Current.FindResource("Greška_kod_brisanja_sa_serveraUzvičnik"));
ServiceDeliveryDataLoading = false;
return;
}
response = new ServiceDeliverySQLiteRepository().Delete(CurrentServiceDelivery.Identifier);
if (!response.Success)
{
MainWindow.ErrorMessage = ((string)Application.Current.FindResource("Greška_kod_lokalnog_brisanjaUzvičnik"));
ServiceDeliveryDataLoading = false;
return;
}
MainWindow.SuccessMessage = ((string)Application.Current.FindResource("Podaci_su_uspešno_obrisaniUzvičnik"));
DisplayServiceDeliveryData();
ServiceDeliveryDataLoading = false;
});
th.IsBackground = true;
th.Start();
}
public ServiceDeliveryResponse GetServiceDelivery(Guid identifier)
{
ServiceDeliveryResponse response = new ServiceDeliveryResponse();
ServiceDeliveryViewModel serviceDelivery = null;
using (SqliteConnection db = new SqliteConnection("Filename=SirmiumERPGFC.db"))
{
db.Open();
try
{
SqliteCommand selectCommand = new SqliteCommand(
SqlCommandSelectPart +
"FROM ServiceDeliverys " +
"WHERE Identifier = @Identifier;", db);
selectCommand.Parameters.AddWithValue("@Identifier", identifier);
SqliteDataReader query = selectCommand.ExecuteReader();
if (query.Read())
{
ServiceDeliveryViewModel dbEntry = Read(query);
serviceDelivery = dbEntry;
}
}
catch (SqliteException error)
{
MainWindow.ErrorMessage = error.Message;
response.Success = false;
response.Message = error.Message;
response.ServiceDelivery = new ServiceDeliveryViewModel();
return(response);
}
db.Close();
}
response.Success = true;
response.ServiceDelivery = serviceDelivery;
return(response);
}
public JsonResult Delete([FromBody] ServiceDeliveryViewModel serviceDelivery)
{
ServiceDeliveryResponse response = new ServiceDeliveryResponse();
try
{
response = this.serviceDeliveryService.Delete(serviceDelivery.Identifier);
}
catch (Exception ex)
{
response.Success = false;
response.Message = ex.Message;
Console.WriteLine(ex.Message);
}
JsonResult result = Json(response, new Newtonsoft.Json.JsonSerializerSettings()
{
Formatting = Newtonsoft.Json.Formatting.Indented,
ReferenceLoopHandling = Newtonsoft.Json.ReferenceLoopHandling.Serialize
});
return(result);
}
private void BtnSubmit_Click(object sender, RoutedEventArgs e)
{
#region Validation
if (String.IsNullOrEmpty(CurrentServiceDelivery.Name))
{
MainWindow.WarningMessage = ((string)Application.Current.FindResource("Obavezno_poljeDvotačka_Naziv"));
return;
}
#endregion
Thread th = new Thread(() =>
{
SubmitButtonContent = ((string)Application.Current.FindResource("Čuvanje_u_tokuTriTacke"));
SubmitButtonEnabled = false;
CurrentServiceDelivery.IsSynced = false;
CurrentServiceDelivery.Company = new CompanyViewModel()
{
Id = MainWindow.CurrentCompanyId
};
CurrentServiceDelivery.CreatedBy = new UserViewModel()
{
Id = MainWindow.CurrentUserId
};
ServiceDeliveryResponse response = ServiceDeliveryService.Create(CurrentServiceDelivery);
if (!response.Success)
{
MainWindow.ErrorMessage = ((string)Application.Current.FindResource("Greška_kod_čuvanja_na_serveruUzvičnik"));
SubmitButtonContent = ((string)Application.Current.FindResource("Proknjiži"));
SubmitButtonEnabled = true;
}
if (response.Success)
{
MainWindow.SuccessMessage = ((string)Application.Current.FindResource("Podaci_su_uspešno_sačuvaniUzvičnik"));
SubmitButtonContent = ((string)Application.Current.FindResource("Proknjiži"));
SubmitButtonEnabled = true;
ServiceDeliveryCreatedUpdated();
if (IsCreateProcess)
{
CurrentServiceDelivery = new ServiceDeliveryViewModel();
CurrentServiceDelivery.Identifier = Guid.NewGuid();
Application.Current.Dispatcher.BeginInvoke(
System.Windows.Threading.DispatcherPriority.Normal,
new Action(() =>
{
txtAmount.Focus();
})
);
}
else
{
Application.Current.Dispatcher.BeginInvoke(
System.Windows.Threading.DispatcherPriority.Normal,
new Action(() =>
{
if (IsPopup)
{
FlyoutHelper.CloseFlyoutPopup(this);
}
else
{
FlyoutHelper.CloseFlyout(this);
}
})
);
}
}
});
th.IsBackground = true;
th.Start();
}
