private void btnCancelPhone_Click(object sender, RoutedEventArgs e)
{
CurrentBusinessPartnerPhoneForm = new BusinessPartnerPhoneViewModel();
CurrentBusinessPartnerPhoneForm.Identifier = Guid.NewGuid();
CurrentBusinessPartnerPhoneForm.ItemStatus = ItemStatus.Added;
CurrentBusinessPartnerPhoneForm.IsSynced = false;
}
private BusinessPartnerPhoneViewModel Read(SqliteDataReader query)
{
int counter = 0;
BusinessPartnerPhoneViewModel dbEntry = new BusinessPartnerPhoneViewModel();
dbEntry.Id = SQLiteHelper.GetInt(query, ref counter);
dbEntry.Identifier = SQLiteHelper.GetGuid(query, ref counter);
dbEntry.BusinessPartner = SQLiteHelper.GetBusinessPartner(query, ref counter);
dbEntry.Phone = SQLiteHelper.GetString(query, ref counter);
dbEntry.Mobile = SQLiteHelper.GetString(query, ref counter);
dbEntry.Fax = SQLiteHelper.GetString(query, ref counter);
dbEntry.Email = SQLiteHelper.GetString(query, ref counter);
dbEntry.ContactPersonFirstName = SQLiteHelper.GetString(query, ref counter);
dbEntry.ContactPersonLastName = SQLiteHelper.GetString(query, ref counter);
dbEntry.Birthday = SQLiteHelper.GetDateTime(query, ref counter);
dbEntry.Description = SQLiteHelper.GetString(query, ref counter);
dbEntry.Path = SQLiteHelper.GetString(query, ref counter);
dbEntry.ItemStatus = SQLiteHelper.GetInt(query, ref counter);
dbEntry.IsSynced = SQLiteHelper.GetBoolean(query, ref counter);
dbEntry.UpdatedAt = SQLiteHelper.GetDateTime(query, ref counter);
dbEntry.CreatedBy = SQLiteHelper.GetCreatedBy(query, ref counter);
dbEntry.Company = SQLiteHelper.GetCompany(query, ref counter);
return(dbEntry);
}
private void BtnDelete_Click(object sender, RoutedEventArgs e)
{
Thread th = new Thread(() =>
{
SubmitButtonEnabled = false;
var response = new BusinessPartnerPhoneSQLiteRepository().SetStatusDeleted(CurrentBusinessPartnerPhoneDG.Identifier);
if (response.Success)
{
MainWindow.SuccessMessage = ((string)Application.Current.FindResource("Stavka_je_uspešno_obrisanaUzvičnik"));
BusinessPartnerCreatedUpdated();
DisplayBusinessPartnerPhoneData();
CurrentBusinessPartnerPhoneForm = new BusinessPartnerPhoneViewModel();
CurrentBusinessPartnerPhoneForm.Identifier = Guid.NewGuid();
CurrentBusinessPartnerPhoneForm.ItemStatus = ItemStatus.Added;
CurrentBusinessPartnerPhoneForm.IsSynced = false;
CurrentBusinessPartnerPhoneDG = null;
}
else
{
MainWindow.ErrorMessage = response.Message;
}
SubmitButtonEnabled = true;
});
th.Start();
}
private SqliteCommand AddCreateParameters(SqliteCommand insertCommand, BusinessPartnerPhoneViewModel businessPartnerPhone)
{
insertCommand.Parameters.AddWithValue("@ServerId", businessPartnerPhone.Id);
insertCommand.Parameters.AddWithValue("@Identifier", businessPartnerPhone.Identifier);
insertCommand.Parameters.AddWithValue("@BusinessPartnerId", ((object)businessPartnerPhone.BusinessPartner.Id) ?? DBNull.Value);
insertCommand.Parameters.AddWithValue("@BusinessPartnerIdentifier", ((object)businessPartnerPhone.BusinessPartner.Identifier) ?? DBNull.Value);
insertCommand.Parameters.AddWithValue("@BusinessPartnerCode", ((object)businessPartnerPhone.BusinessPartner.Code) ?? DBNull.Value);
insertCommand.Parameters.AddWithValue("@BusinessPartnerName", ((object)businessPartnerPhone.BusinessPartner.Name) ?? DBNull.Value);
insertCommand.Parameters.AddWithValue("@BusinessPartnerInternalCode", ((object)businessPartnerPhone.BusinessPartner.InternalCode) ?? DBNull.Value);
insertCommand.Parameters.AddWithValue("@BusinessPartnerNameGer", ((object)businessPartnerPhone.BusinessPartner.NameGer) ?? DBNull.Value);
insertCommand.Parameters.AddWithValue("@Phone", ((object)businessPartnerPhone.Phone) ?? DBNull.Value);
insertCommand.Parameters.AddWithValue("@Mobile", ((object)businessPartnerPhone.Mobile) ?? DBNull.Value);
insertCommand.Parameters.AddWithValue("@Fax", ((object)businessPartnerPhone.Fax) ?? DBNull.Value);
insertCommand.Parameters.AddWithValue("@Email", ((object)businessPartnerPhone.Email) ?? DBNull.Value);
insertCommand.Parameters.AddWithValue("@ContactPersonFirstName", ((object)businessPartnerPhone.ContactPersonFirstName) ?? DBNull.Value);
insertCommand.Parameters.AddWithValue("@ContactPersonLastName", ((object)businessPartnerPhone.ContactPersonLastName) ?? DBNull.Value);
insertCommand.Parameters.AddWithValue("@Birthday", ((object)businessPartnerPhone.Birthday) ?? DBNull.Value);
insertCommand.Parameters.AddWithValue("@Description", ((object)businessPartnerPhone.Description) ?? DBNull.Value);
insertCommand.Parameters.AddWithValue("@Path", ((object)businessPartnerPhone.Path) ?? DBNull.Value);
insertCommand.Parameters.AddWithValue("@ItemStatus", ((object)businessPartnerPhone.ItemStatus) ?? DBNull.Value);
insertCommand.Parameters.AddWithValue("@IsSynced", businessPartnerPhone.IsSynced);
insertCommand.Parameters.AddWithValue("@UpdatedAt", ((object)businessPartnerPhone.UpdatedAt) ?? DBNull.Value);
insertCommand.Parameters.AddWithValue("@CreatedById", MainWindow.CurrentUser.Id);
insertCommand.Parameters.AddWithValue("@CreatedByName", MainWindow.CurrentUser.FirstName + " " + MainWindow.CurrentUser.LastName);
insertCommand.Parameters.AddWithValue("@CompanyId", MainWindow.CurrentCompany.Id);
insertCommand.Parameters.AddWithValue("@CompanyName", MainWindow.CurrentCompany.CompanyName);
return(insertCommand);
}
public BusinessPartnerPhoneResponse Create(BusinessPartnerPhoneViewModel businessPartnerPhone)
{
BusinessPartnerPhoneResponse response = new BusinessPartnerPhoneResponse();
using (SqliteConnection db = new SqliteConnection("Filename=SirmiumERPGFC.db"))
{
db.Open();
SqliteCommand insertCommand = db.CreateCommand();
insertCommand.CommandText = SqlCommandInsertPart;
try
{
insertCommand = AddCreateParameters(insertCommand, businessPartnerPhone);
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 static BusinessPartnerPhone ConvertToBusinessPartnerPhone(this BusinessPartnerPhoneViewModel businessPartnerPhoneViewModel)
{
BusinessPartnerPhone businessPartnerPhone = new BusinessPartnerPhone()
{
Id = businessPartnerPhoneViewModel.Id,
Identifier = businessPartnerPhoneViewModel.Identifier,
BusinessPartnerId = businessPartnerPhoneViewModel.BusinessPartner?.Id ?? null,
Phone = businessPartnerPhoneViewModel.Phone,
Mobile = businessPartnerPhoneViewModel.Mobile,
Fax = businessPartnerPhoneViewModel.Fax,
Email = businessPartnerPhoneViewModel.Email,
ContactPersonFirstName = businessPartnerPhoneViewModel.ContactPersonFirstName,
ContactPersonLastName = businessPartnerPhoneViewModel.ContactPersonLastName,
Birthday = businessPartnerPhoneViewModel.Birthday,
Description = businessPartnerPhoneViewModel.Description,
Path = businessPartnerPhoneViewModel.Path,
ItemStatus = businessPartnerPhoneViewModel.ItemStatus,
Active = businessPartnerPhoneViewModel.IsActive,
CreatedById = businessPartnerPhoneViewModel.CreatedBy?.Id ?? null,
CompanyId = businessPartnerPhoneViewModel.Company?.Id ?? null,
UpdatedAt = businessPartnerPhoneViewModel.UpdatedAt,
CreatedAt = businessPartnerPhoneViewModel.CreatedAt,
};
return(businessPartnerPhone);
}
public static BusinessPartnerPhoneViewModel ConvertToBusinessPartnerPhoneViewModelLite(this BusinessPartnerPhone businessPartnerPhone)
{
BusinessPartnerPhoneViewModel businessPartnerPhoneViewModel = new BusinessPartnerPhoneViewModel()
{
Id = businessPartnerPhone.Id,
Identifier = businessPartnerPhone.Identifier,
Phone = businessPartnerPhone.Phone,
Mobile = businessPartnerPhone.Mobile,
Fax = businessPartnerPhone.Fax,
Email = businessPartnerPhone.Email,
ContactPersonFirstName = businessPartnerPhone.ContactPersonFirstName,
ContactPersonLastName = businessPartnerPhone.ContactPersonLastName,
Birthday = businessPartnerPhone.Birthday,
Description = businessPartnerPhone.Description,
Path = businessPartnerPhone.Path,
ItemStatus = businessPartnerPhone.ItemStatus,
IsActive = businessPartnerPhone.Active,
UpdatedAt = businessPartnerPhone.UpdatedAt,
CreatedAt = businessPartnerPhone.CreatedAt,
};
return(businessPartnerPhoneViewModel);
}
private void btnEditPhone_Click(object sender, RoutedEventArgs e)
{
CurrentBusinessPartnerPhoneForm = new BusinessPartnerPhoneViewModel();
CurrentBusinessPartnerPhoneForm.Identifier = CurrentBusinessPartnerPhoneDG.Identifier;
CurrentBusinessPartnerPhoneForm.ItemStatus = ItemStatus.Edited;
CurrentBusinessPartnerPhoneForm.IsSynced = CurrentBusinessPartnerPhoneDG.IsSynced;
CurrentBusinessPartnerPhoneForm.ContactPersonFirstName = CurrentBusinessPartnerPhoneDG.ContactPersonFirstName;
CurrentBusinessPartnerPhoneForm.ContactPersonLastName = CurrentBusinessPartnerPhoneDG.ContactPersonLastName;
CurrentBusinessPartnerPhoneForm.Description = CurrentBusinessPartnerPhoneDG.Description;
CurrentBusinessPartnerPhoneForm.Mobile = CurrentBusinessPartnerPhoneDG.Mobile;
CurrentBusinessPartnerPhoneForm.Phone = CurrentBusinessPartnerPhoneDG.Phone;
CurrentBusinessPartnerPhoneForm.Fax = CurrentBusinessPartnerPhoneDG.Fax;
CurrentBusinessPartnerPhoneForm.Email = CurrentBusinessPartnerPhoneDG.Email;
CurrentBusinessPartnerPhoneForm.Birthday = CurrentBusinessPartnerPhoneDG.Birthday;
CurrentBusinessPartnerPhoneForm.Path = CurrentBusinessPartnerPhoneDG.Path;
CurrentBusinessPartnerPhoneForm.UpdatedAt = CurrentBusinessPartnerPhoneDG.UpdatedAt;
}
public BusinessPartnerPhoneListResponse GetBusinessPartnerPhonesByBusinessPartner(int companyId, Guid businessPartnerIdentifier)
{
BusinessPartnerPhoneListResponse response = new BusinessPartnerPhoneListResponse();
List <BusinessPartnerPhoneViewModel> businessPartnerPhones = new List <BusinessPartnerPhoneViewModel>();
using (SqliteConnection db = new SqliteConnection("Filename=SirmiumERPGFC.db"))
{
db.Open();
try
{
SqliteCommand selectCommand = new SqliteCommand(
SqlCommandSelectPart +
"FROM BusinessPartnerPhones " +
"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())
{
BusinessPartnerPhoneViewModel dbEntry = Read(query);
businessPartnerPhones.Add(dbEntry);
}
}
catch (SqliteException error)
{
MainWindow.ErrorMessage = error.Message;
response.Success = false;
response.Message = error.Message;
response.BusinessPartnerPhones = new List <BusinessPartnerPhoneViewModel>();
return(response);
}
db.Close();
}
response.Success = true;
response.BusinessPartnerPhones = businessPartnerPhones;
return(response);
}
public BusinessPartner_Phone_AddEdit(BusinessPartnerViewModel businessPartner)
{
businessPartnerService = DependencyResolver.Kernel.Get <IBusinessPartnerService>();
businessPartnerPhoneService = DependencyResolver.Kernel.Get <IBusinessPartnerPhoneService>();
InitializeComponent();
this.DataContext = this;
CurrentBusinessPartner = businessPartner;
CurrentBusinessPartnerPhoneForm = new BusinessPartnerPhoneViewModel();
CurrentBusinessPartnerPhoneForm.Identifier = Guid.NewGuid();
CurrentBusinessPartnerPhoneForm.ItemStatus = ItemStatus.Added;
CurrentBusinessPartnerPhoneForm.IsSynced = false;
Thread displayThread = new Thread(() => DisplayBusinessPartnerPhoneData());
displayThread.IsBackground = true;
displayThread.Start();
txtPhoneContactPersonFirstName.Focus();
}
public BusinessPartnerPhoneResponse GetBusinessPartnerPhone(Guid identifier)
{
BusinessPartnerPhoneResponse response = new BusinessPartnerPhoneResponse();
BusinessPartnerPhoneViewModel businessPartnerPhone = new BusinessPartnerPhoneViewModel();
using (SqliteConnection db = new SqliteConnection("Filename=SirmiumERPGFC.db"))
{
db.Open();
try
{
SqliteCommand selectCommand = new SqliteCommand(
SqlCommandSelectPart +
"FROM BusinessPartnerPhones " +
"WHERE Identifier = @Identifier;", db);
selectCommand.Parameters.AddWithValue("@Identifier", identifier);
SqliteDataReader query = selectCommand.ExecuteReader();
if (query.Read())
{
BusinessPartnerPhoneViewModel dbEntry = Read(query);
businessPartnerPhone = dbEntry;
}
}
catch (SqliteException error)
{
MainWindow.ErrorMessage = error.Message;
response.Success = false;
response.Message = error.Message;
response.BusinessPartnerPhone = new BusinessPartnerPhoneViewModel();
return(response);
}
db.Close();
}
response.Success = true;
response.BusinessPartnerPhone = businessPartnerPhone;
return(response);
}
private void btnAddPhone_Click(object sender, RoutedEventArgs e)
{
#region Validation
if (CurrentBusinessPartnerPhoneForm.ContactPersonFirstName == null)
{
MainWindow.ErrorMessage = ((string)Application.Current.FindResource("Obavezno_poljeDvotačka_Ime"));
return;
}
#endregion
Thread th = new Thread(() =>
{
SubmitButtonEnabled = false;
CurrentBusinessPartnerPhoneForm.BusinessPartner = CurrentBusinessPartner;
CurrentBusinessPartnerPhoneForm.Company = new CompanyViewModel()
{
Id = MainWindow.CurrentCompanyId
};
CurrentBusinessPartnerPhoneForm.CreatedBy = new UserViewModel()
{
Id = MainWindow.CurrentUserId
};
new BusinessPartnerPhoneSQLiteRepository().Delete(CurrentBusinessPartnerPhoneForm.Identifier);
var response = new BusinessPartnerPhoneSQLiteRepository().Create(CurrentBusinessPartnerPhoneForm);
if (!response.Success)
{
MainWindow.ErrorMessage = response.Message;
CurrentBusinessPartnerPhoneForm = new BusinessPartnerPhoneViewModel();
CurrentBusinessPartnerPhoneForm.Identifier = Guid.NewGuid();
CurrentBusinessPartnerPhoneForm.ItemStatus = ItemStatus.Added;
CurrentBusinessPartnerPhoneForm.IsSynced = false;
return;
}
CurrentBusinessPartnerPhoneForm = new BusinessPartnerPhoneViewModel();
CurrentBusinessPartnerPhoneForm.Identifier = Guid.NewGuid();
CurrentBusinessPartnerPhoneForm.ItemStatus = ItemStatus.Added;
CurrentBusinessPartnerPhoneForm.IsSynced = false;
BusinessPartnerCreatedUpdated();
DisplayBusinessPartnerPhoneData();
Application.Current.Dispatcher.BeginInvoke(
System.Windows.Threading.DispatcherPriority.Normal,
new Action(() =>
{
txtPhoneContactPersonFirstName.Focus();
})
);
SubmitButtonEnabled = true;
});
th.IsBackground = true;
th.Start();
}
