public FamilyMemberResponse Create(FamilyMemberViewModel FamilyMember)
{
FamilyMemberResponse response = new FamilyMemberResponse();
using (SqliteConnection db = new SqliteConnection("Filename=SirmiumERPGFC.db"))
{
db.Open();
SqliteCommand insertCommand = db.CreateCommand();
insertCommand.CommandText = SqlCommandInsertPart;
try
{
insertCommand = AddCreateParameters(insertCommand, FamilyMember);
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);
}
}
private static void OnCurrentFamilyMemberPropertyChanged(DependencyObject source, DependencyPropertyChangedEventArgs e)
{
FamilyMemberPopup popup = source as FamilyMemberPopup;
FamilyMemberViewModel FamilyMember = (FamilyMemberViewModel)e.NewValue;
popup.txtFamilyMember.Text = FamilyMember != null ? FamilyMember.Code + " (" + FamilyMember.Name + ")" : "";
}
private void btnAdd_Click(object sender, RoutedEventArgs e)
{
FamilyMemberViewModel FamilyMember = new FamilyMemberViewModel();
FamilyMember.Identifier = Guid.NewGuid();
FamilyMember_List_AddEdit addEditForm = new FamilyMember_List_AddEdit(FamilyMember, true);
addEditForm.FamilyMemberCreatedUpdated += new FamilyMemberHandler(SyncData);
FlyoutHelper.OpenFlyout(this, ((string)Application.Current.FindResource("Podaci_o_clanovima_porodice")), 95, addEditForm);
}
public FamilyMember_List_AddEdit(FamilyMemberViewModel familyMemberViewModel, bool isCreateProcess, bool isPopup = false)
{
// Get required services
familyMemberService = DependencyResolver.Kernel.Get <IFamilyMemberService>();
InitializeComponent();
this.DataContext = this;
CurrentFamilyMember = familyMemberViewModel;
IsCreateProcess = isCreateProcess;
IsPopup = isPopup;
}
private SqliteCommand AddCreateParameters(SqliteCommand insertCommand, FamilyMemberViewModel FamilyMember)
{
insertCommand.Parameters.AddWithValue("@ServerId", FamilyMember.Id);
insertCommand.Parameters.AddWithValue("@Identifier", FamilyMember.Identifier);
insertCommand.Parameters.AddWithValue("@Code", ((object)FamilyMember.Code) ?? DBNull.Value);
insertCommand.Parameters.AddWithValue("@Name", ((object)FamilyMember.Name) ?? DBNull.Value);
insertCommand.Parameters.AddWithValue("@IsSynced", FamilyMember.IsSynced);
insertCommand.Parameters.AddWithValue("@UpdatedAt", ((object)FamilyMember.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);
}
private FamilyMemberViewModel Read(SqliteDataReader query)
{
int counter = 0;
FamilyMemberViewModel dbEntry = new FamilyMemberViewModel();
dbEntry.Id = SQLiteHelper.GetInt(query, ref counter);
dbEntry.Identifier = SQLiteHelper.GetGuid(query, ref counter);
dbEntry.Code = SQLiteHelper.GetString(query, ref counter);
dbEntry.Name = SQLiteHelper.GetString(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);
}
public FamilyMemberListResponse GetFamilyMembersForPopup(int companyId, string filterString)
{
FamilyMemberListResponse response = new FamilyMemberListResponse();
List <FamilyMemberViewModel> familyMembers = new List <FamilyMemberViewModel>();
using (SqliteConnection db = new SqliteConnection("Filename=SirmiumERPGFC.db"))
{
db.Open();
try
{
SqliteCommand selectCommand = new SqliteCommand(
SqlCommandSelectPart +
"FROM FamilyMembers " +
"WHERE ((@Code IS NULL OR @Code = '' OR Code LIKE @Code) " +
"OR (@Name IS NULL OR @Name = '' OR Name LIKE @Name)) " +
"AND CompanyId = @CompanyId " +
"ORDER BY IsSynced, Id DESC " +
"LIMIT @ItemsPerPage;", db);
selectCommand.Parameters.AddWithValue("@Code", ((object)filterString) != null ? "%" + filterString + "%" : "");
selectCommand.Parameters.AddWithValue("@Name", ((object)filterString) != null ? "%" + filterString + "%" : "");
selectCommand.Parameters.AddWithValue("@CompanyId", ((object)filterString) != null ? companyId : 0);
selectCommand.Parameters.AddWithValue("@ItemsPerPage", 100);
SqliteDataReader query = selectCommand.ExecuteReader();
while (query.Read())
{
FamilyMemberViewModel dbEntry = Read(query);
familyMembers.Add(dbEntry);
}
}
catch (SqliteException error)
{
MainWindow.ErrorMessage = error.Message;
response.Success = false;
response.Message = error.Message;
response.FamilyMembers = new List <FamilyMemberViewModel>();
return(response);
}
db.Close();
}
response.Success = true;
response.FamilyMembers = familyMembers;
return(response);
}
public FamilyMemberResponse Create(FamilyMemberViewModel FamilyMember)
{
FamilyMemberResponse response = new FamilyMemberResponse();
try
{
response = WpfApiHandler.SendToApi <FamilyMemberViewModel, FamilyMemberResponse>(FamilyMember, "Create");
}
catch (Exception ex)
{
response.FamilyMember = new FamilyMemberViewModel();
response.Success = false;
response.Message = ex.Message;
}
return(response);
}
public static FamilyMemberViewModel ConvertToFamilyMemberViewModelLite(this FamilyMember familyMember)
{
FamilyMemberViewModel familyMemberViewModel = new FamilyMemberViewModel()
{
Id = familyMember.Id,
Identifier = familyMember.Identifier,
Code = familyMember.Code,
Name = familyMember.Name,
IsActive = familyMember.Active,
CreatedAt = familyMember.CreatedAt,
UpdatedAt = familyMember.UpdatedAt
};
return(familyMemberViewModel);
}
public FamilyMemberResponse Delete(Guid identifier)
{
FamilyMemberResponse response = new FamilyMemberResponse();
try
{
FamilyMemberViewModel re = new FamilyMemberViewModel();
re.Identifier = identifier;
response = WpfApiHandler.SendToApi <FamilyMemberViewModel, FamilyMemberResponse>(re, "Delete");
}
catch (Exception ex)
{
response.FamilyMember = new FamilyMemberViewModel();
response.Success = false;
response.Message = ex.Message;
}
return(response);
}
public static FamilyMember ConvertToFamilyMember(this FamilyMemberViewModel familyMemberViewModel)
{
FamilyMember familyMember = new FamilyMember()
{
Id = familyMemberViewModel.Id,
Identifier = familyMemberViewModel.Identifier,
Code = familyMemberViewModel.Code,
Name = familyMemberViewModel.Name,
CreatedById = familyMemberViewModel.CreatedBy?.Id ?? null,
CompanyId = familyMemberViewModel.Company?.Id ?? null,
CreatedAt = familyMemberViewModel.CreatedAt,
UpdatedAt = familyMemberViewModel.UpdatedAt
};
return(familyMember);
}
public JsonResult Delete([FromBody] FamilyMemberViewModel remedy)
{
FamilyMemberResponse response = new FamilyMemberResponse();
try
{
response = this.familyMemberService.Delete(remedy.Identifier);
}
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 FamilyMemberResponse Create(FamilyMemberViewModel familyMember)
{
FamilyMemberResponse response = new FamilyMemberResponse();
try
{
FamilyMember addedFamilyMember = unitOfWork.GetFamilyMemberRepository().Create(familyMember.ConvertToFamilyMember());
unitOfWork.Save();
response.FamilyMember = addedFamilyMember.ConvertToFamilyMemberViewModel();
response.Success = true;
}
catch (Exception ex)
{
response.FamilyMember = new FamilyMemberViewModel();
response.Success = false;
response.Message = ex.Message;
}
return(response);
}
public static FamilyMemberViewModel ConvertToFamilyMemberViewModel(this FamilyMember familyMember)
{
FamilyMemberViewModel FamilyMemberViewModel = new FamilyMemberViewModel()
{
Id = familyMember.Id,
Identifier = familyMember.Identifier,
Code = familyMember.Code,
Name = familyMember.Name,
IsActive = familyMember.Active,
CreatedBy = familyMember.CreatedBy?.ConvertToUserViewModelLite(),
Company = familyMember.Company?.ConvertToCompanyViewModelLite(),
UpdatedAt = familyMember.UpdatedAt,
CreatedAt = familyMember.CreatedAt
};
return(FamilyMemberViewModel);
}
public FamilyMemberResponse GetFamilyMember(Guid identifier)
{
FamilyMemberResponse response = new FamilyMemberResponse();
FamilyMemberViewModel FamilyMember = new FamilyMemberViewModel();
using (SqliteConnection db = new SqliteConnection("Filename=SirmiumERPGFC.db"))
{
db.Open();
try
{
SqliteCommand selectCommand = new SqliteCommand(
SqlCommandSelectPart +
"FROM FamilyMembers " +
"WHERE Identifier = @Identifier;", db);
selectCommand.Parameters.AddWithValue("@Identifier", identifier);
SqliteDataReader query = selectCommand.ExecuteReader();
if (query.Read())
{
FamilyMemberViewModel dbEntry = Read(query);
FamilyMember = dbEntry;
}
}
catch (SqliteException error)
{
MainWindow.ErrorMessage = error.Message;
response.Success = false;
response.Message = error.Message;
response.FamilyMember = new FamilyMemberViewModel();
return(response);
}
db.Close();
}
response.Success = true;
response.FamilyMember = FamilyMember;
return(response);
}
public async Task <IActionResult> RequestUpdateFamilyMember(int id, [FromBody] FamilyMemberViewModel familyMember)
{
if (ModelState.IsValid)
{
if (familyMember == null)
{
return(BadRequest($"{nameof(familyMember)} cannot be null"));
}
if (id != familyMember.Id)
{
return(BadRequest("Conflicting family member id in parameter and model data"));
}
}
FamilyMemberUpdate familyMemberUpdate = Mapper.Map <FamilyMemberViewModel, FamilyMemberUpdate>(familyMember);
familyMemberUpdate.Status = UpdateStatus.Pending;
familyMemberUpdate.Id = 0;
familyMemberUpdate.RefId = id;
var newId = await this._unitOfWork.FamilyMemberUpdates.AddFamilyMemberUpdateAsync(familyMemberUpdate);
var userId = Utilities.GetUserId(this.User);
ApplicationUser appUser = await this._accountManager.GetUserByIdAsync(userId);
var recipients = new EmailAddress[] {
new EmailAddress {
Name = EmailSender.Configuration.AdminName,
Email = EmailSender.Configuration.AdminEmail
}
};
var webRootPath = $"{this.Request.Scheme}://{this.Request.Host}/api/FamilyMember/updates/";
//TODO: Get Parnet, Controy, and Horsoscope
var requestParam = new Dictionary <string, string>
{
{ "{requester.Name}", appUser.FirstName + " " + appUser.LastName },
{ "{requester.Email}", appUser.Email },
{ "{requester.PhoneNumber}", appUser.PhoneNumber },
{ "{familyMemberUpdate.FamilyId}", familyMemberUpdate.FamilyId },
{ "{familyMemberUpdate.BirthYear}", familyMemberUpdate.BirthYear != null?familyMemberUpdate.BirthYear.Value.ToString() : "N/A" },
{ "{familyMemberUpdate.City}", familyMemberUpdate.City != null ? familyMemberUpdate.City : "" },
{ "{familyMemberUpdate.Country}", familyMemberUpdate.CountryId != null?familyMemberUpdate.CountryId.ToString() : "N/A" },
{ "{familyMemberUpdate.DeathYear}", familyMemberUpdate.DeathYear != null?familyMemberUpdate.DeathYear.ToString() : "N/A" },
{ "{familyMemberUpdate.DisplayEmail}", familyMemberUpdate.DisplayEmail != null ? familyMemberUpdate.DisplayEmail : "N/A" },
{ "{familyMemberUpdate.DisplayPhone}", familyMemberUpdate.DisplayPhone != null ? familyMemberUpdate.DisplayPhone : "N/A" },
{ "{familyMemberUpdate.DisplayPhoneType}", familyMemberUpdate.DisplayPhoneType != null?familyMemberUpdate.DisplayPhoneType.ToString() : "N/A" },
{ "{familyMemberUpdate.Facebook}", familyMemberUpdate.Facebook != null ? familyMemberUpdate.Facebook : "N/A" },
{ "{familyMemberUpdate.FamilyName_En}", familyMemberUpdate.FamilyName_En != null ? familyMemberUpdate.FamilyName_En : "N/A" },
{ "{familyMemberUpdate.FirstName_Ar}", familyMemberUpdate.FirstName_Ar != null ? familyMemberUpdate.FirstName_Ar : "N/A" },
{ "{familyMemberUpdate.FirstName_En}", familyMemberUpdate.FirstName_En != null ? familyMemberUpdate.FirstName_En : "N/A" },
{ "{familyMemberUpdate.Gender}", familyMemberUpdate.Gender.ToString() },
{ "{familyMemberUpdate.Generation}", familyMemberUpdate.Generation.ToString() },
{ "{familyMemberUpdate.Horoscope}", familyMemberUpdate.HoroscopeId != null?familyMemberUpdate.HoroscopeId.ToString() : "N/A" },
{ "{familyMemberUpdate.LinkedIn}", familyMemberUpdate.LinkedIn != null ? familyMemberUpdate.LinkedIn : "N/A" },
{ "{familyMemberUpdate.MaritalStatus}", familyMemberUpdate.MaritalStatus != null?familyMemberUpdate.MaritalStatus.ToString() : "N/A" },
{ "{familyMemberUpdate.MotherFirstName_Ar}", familyMemberUpdate.MotherFirstName_Ar != null ? familyMemberUpdate.MotherFirstName_Ar : "N/A" },
{ "{familyMemberUpdate.MotherFirstName_En}", familyMemberUpdate.MotherFirstName_En != null ? familyMemberUpdate.MotherFirstName_En : "N/A" },
{ "{familyMemberUpdate.MotherLastName_Ar}", familyMemberUpdate.MotherLastName_Ar != null ? familyMemberUpdate.MotherLastName_Ar : "N/A" },
{ "{familyMemberUpdate.MotherLastName_En}", familyMemberUpdate.MotherLastName_En != null ? familyMemberUpdate.MotherLastName_En : "N/A" },
{ "{familyMemberUpdate.Parent}", familyMemberUpdate.ParentId != null?familyMemberUpdate.ParentId.ToString() : "N/A" },
{ "{familyMemberUpdate.Province}", familyMemberUpdate.Province != null ? familyMemberUpdate.Province : "N/A" },
{ "{familyMemberUpdate.Sequence}", familyMemberUpdate.Sequence.ToString() },
{ "{familyMemberUpdate.SpouseFirstName_Ar}", familyMemberUpdate.SpouseFirstName_Ar != null ? familyMemberUpdate.SpouseFirstName_Ar : "N/A" },
{ "{familyMemberUpdate.SpouseFirstName_En}", familyMemberUpdate.SpouseFirstName_En != null ? familyMemberUpdate.SpouseFirstName_En : "N/A" },
{ "{familyMemberUpdate.SpouseLastName_Ar}", familyMemberUpdate.SpouseLastName_Ar != null ? familyMemberUpdate.SpouseLastName_Ar : "N/A" },
{ "{familyMemberUpdate.SpouseLastName_En}", familyMemberUpdate.SpouseLastName_En != null ? familyMemberUpdate.SpouseLastName_En : "N/A" },
{ "{familyMemberUpdate.PrvSpouseFirstName_Ar}", familyMemberUpdate.PrvSpouseFirstName_Ar != null ? familyMemberUpdate.PrvSpouseFirstName_Ar : "N/A" },
{ "{familyMemberUpdate.PrvSpouseFirstName_En}", familyMemberUpdate.PrvSpouseFirstName_En != null ? familyMemberUpdate.PrvSpouseFirstName_En : "N/A" },
{ "{familyMemberUpdate.PrvSpouseLastName_Ar}", familyMemberUpdate.PrvSpouseLastName_Ar != null ? familyMemberUpdate.PrvSpouseLastName_Ar : "N/A" },
{ "{familyMemberUpdate.PrvSpouseLastName_En}", familyMemberUpdate.PrvSpouseLastName_En != null ? familyMemberUpdate.PrvSpouseLastName_En : "N/A" },
{ "{familyMemberUpdate.PrvPrvSpouseFirstName_Ar}", familyMemberUpdate.PrvPrvSpouseFirstName_Ar != null ? familyMemberUpdate.PrvPrvSpouseFirstName_Ar : "N/A" },
{ "{familyMemberUpdate.PrvPrvSpouseFirstName_En}", familyMemberUpdate.PrvPrvSpouseFirstName_En != null ? familyMemberUpdate.PrvPrvSpouseFirstName_En : "N/A" },
{ "{familyMemberUpdate.PrvPrvSpouseLastName_Ar}", familyMemberUpdate.PrvPrvSpouseLastName_Ar != null ? familyMemberUpdate.PrvPrvSpouseLastName_Ar : "N/A" },
{ "{familyMemberUpdate.PrvPrvSpouseLastName_En}", familyMemberUpdate.PrvPrvSpouseLastName_En != null ? familyMemberUpdate.PrvPrvSpouseLastName_En : "N/A" },
{ "{familyMemberUpdate.FemChildrenList_Ar}", familyMemberUpdate.FemChildrenList_Ar != null ? familyMemberUpdate.FemChildrenList_Ar : "N/A" },
{ "{familyMemberUpdate.FemChildrenList_En}", familyMemberUpdate.FemChildrenList_En != null ? familyMemberUpdate.FemChildrenList_En : "N/A" },
{ "{familyMemberUpdate.PassedAway}", familyMemberUpdate.PassedAway ? "Yes" : "No" },
{ "{familyMemberUpdate.SpousePassedAway}", familyMemberUpdate.SpousePassedAway ? "Yes" : "No" },
{ "{familyMemberUpdate.Website}", familyMemberUpdate.Website != null ? familyMemberUpdate.Website : "N/A" },
{ "{Url.Approve}", $"{webRootPath}approve/{newId}" },
{ "{Url.Reject}", $"{webRootPath}reject/{newId}" },
};
var response = await EmailSender.SendEmailAsync(
recipients,
subject : "Adam.info Request Family Member Update",
content : EmailTemplates.GetFamilyMemberUpdatedEmail(requestParam, "en"),
isHtml : true,
addBccs : false);
if (!response.Item1)
{
this.logger.LogWarning(new EventId(1, "Email Error"), null, $"Failed to send Email Error: {response.Item2}");
}
return(NoContent());
}
private void ScreenFamilyMember()
{
FamilyMemberViewModel.ScreenFamilyMember(FamilyMemberTemplate);
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
#region Validation
if (String.IsNullOrEmpty(CurrentFamilyMember.Name))
{
MainWindow.WarningMessage = ((string)Application.Current.FindResource("Obavezno_poljeDvotačka_Naziv"));
return;
}
#endregion
Thread th = new Thread(() =>
{
SaveButtonContent = ((string)Application.Current.FindResource("Čuvanje_u_tokuTriTacke"));
SaveButtonEnabled = false;
CurrentFamilyMember.IsSynced = false;
CurrentFamilyMember.Company = new CompanyViewModel()
{
Id = MainWindow.CurrentCompanyId
};
CurrentFamilyMember.CreatedBy = new UserViewModel()
{
Id = MainWindow.CurrentUserId
};
FamilyMemberResponse response = familyMemberService.Create(CurrentFamilyMember);
if (!response.Success)
{
MainWindow.ErrorMessage = ((string)Application.Current.FindResource("Podaci_su_sačuvani_u_lokaluUzvičnikTačka_Greška_kod_čuvanja_na_serveruUzvičnik"));
SaveButtonContent = ((string)Application.Current.FindResource("Sačuvaj"));
SaveButtonEnabled = true;
}
if (response.Success)
{
MainWindow.SuccessMessage = ((string)Application.Current.FindResource("Podaci_su_uspešno_sačuvaniUzvičnik"));
SaveButtonContent = ((string)Application.Current.FindResource("Sačuvaj"));
SaveButtonEnabled = true;
FamilyMemberCreatedUpdated();
if (IsCreateProcess)
{
CurrentFamilyMember = new FamilyMemberViewModel();
CurrentFamilyMember.Identifier = Guid.NewGuid();
Application.Current.Dispatcher.BeginInvoke(
System.Windows.Threading.DispatcherPriority.Normal,
new Action(() =>
{
txtName.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();
}
public IHttpActionResult Get(int familyId)
{
using (bkContext context = new bkContext())
{
Family f = context.Families.Where(x => x.FamilyID == familyId).FirstOrDefault();
if (f == null)
{
return(BadRequest("Family record cannot be loaded."));
}
List <bk_GetFamilyMembers_Result> members = context.bk_GetFamilyMembers(familyId).ToList();
FamilyViewModel fvm = new FamilyViewModel();
fvm.FamilyNative = f.FamilyNative;
fvm.Address1 = f.Address1;
fvm.Address2 = f.Address2;
fvm.CategoryID = f.CategoryID;
fvm.City = f.City;
fvm.District = f.District;
fvm.Country = f.Country;
fvm.FamilyID = f.FamilyID;
fvm.NukhID = f.NukhID;
fvm.PostalCode = f.PostalCode;
fvm.State = f.State;
fvm.HeadOfFamilyID = f.HeadOfFamilyID;
fvm.CanEdit = CanEditFamily(f.FamilyID);
Member hofMember = f.Member;
if (hofMember != null)
{
fvm.HeadOfFirstName = hofMember.FirstName;
fvm.HeadOfLastName = hofMember.LastName;
}
foreach (var item in members)
{
var tmp = new FamilyMemberViewModel();
tmp.DOB = item.DOB;
tmp.MaritalStatusId = item.MaritalStatusID;
tmp.MemberID = item.MemberID;
tmp.Name = $"{item.FirstName} {item.LastName}";
tmp.CanEdit = CanEditMember(f.FamilyMemberAssociations.ToList(), item.MemberID);
tmp.MatrimonialExists = item.MatrimonialExists.Value;
tmp.Gender = item.Gender;
tmp.Alive = item.Alive;
tmp.DOD = item.DOD;
tmp.PaternalFamilyId = item.PaternalFamilyId;
if (tmp.PaternalFamilyId.HasValue)
{
tmp.PaternalFamilyName = string.Format("{0}, {1}", item.PaternalFamilyName, item.PaternalFamilyAddress);
}
tmp.MaternalFamilyId = item.MaternalFamilyId;
if (tmp.MaternalFamilyId.HasValue)
{
tmp.MaternalFamilyName = string.Format("{0}, {1}", item.MaternalFamilyName, item.MaternalFamilyAddress);
}
if (!string.IsNullOrEmpty(item.rFirstName))
{
tmp.RelatedToName = $"{item.rFirstName} {item.rLastName}";
}
tmp.RelationTypeId = item.RelationTypeId;
tmp.DefaultFamilyId = item.DefaultFamilyId;
fvm.Members.Add(tmp);
}
fvm.Members = fvm.Members.OrderByDescending(x => x.Age).ToList();
List <bk_PendingApprovals_Result> approvals = context.bk_PendingApprovals(LoggedInMemberId).ToList();
foreach (var item in approvals)
{
var tmp = new PendingApprovalViewModel();
tmp.AddedByFirstName = item.AddedByFirstName;
tmp.AddedById = item.AddedById;
tmp.AddedByLastName = item.AddedByLastName;
tmp.AddedOn = item.AddedOn;
tmp.AddedToFirstName = item.AddedToFirstName;
tmp.AddedToId = item.AddedToId;
tmp.AddedToLastName = item.AddedToLastName;
tmp.FamilyId = item.FamilyId;
fvm.PendingApprovals.Add(tmp);
}
return(Ok(fvm));
}
}
public FamilyMemberListResponse GetFamilyMembersByPage(int companyId, FamilyMemberViewModel familyMemberSearchObject, int currentPage = 1, int itemsPerPage = 50)
{
FamilyMemberListResponse response = new FamilyMemberListResponse();
List <FamilyMemberViewModel> Remedies = new List <FamilyMemberViewModel>();
using (SqliteConnection db = new SqliteConnection("Filename=SirmiumERPGFC.db"))
{
db.Open();
try
{
SqliteCommand selectCommand = new SqliteCommand(
SqlCommandSelectPart +
"FROM FamilyMembers " +
"WHERE (@Code IS NULL OR @Code = '' OR Code LIKE @Code) " +
"AND (@Name IS NULL OR @Name = '' OR Name LIKE @Name) " +
"AND CompanyId = @CompanyId " +
"ORDER BY IsSynced, Id DESC " +
"LIMIT @ItemsPerPage OFFSET @Offset;", db);
selectCommand.Parameters.AddWithValue("@Code", ((object)familyMemberSearchObject.Search_Code) != null ? "%" + familyMemberSearchObject.Search_Code + "%" : "");
selectCommand.Parameters.AddWithValue("@Name", ((object)familyMemberSearchObject.Search_Name) != null ? "%" + familyMemberSearchObject.Search_Name + "%" : "");
selectCommand.Parameters.AddWithValue("@CompanyId", companyId);
selectCommand.Parameters.AddWithValue("@ItemsPerPage", itemsPerPage);
selectCommand.Parameters.AddWithValue("@Offset", (currentPage - 1) * itemsPerPage);
SqliteDataReader query = selectCommand.ExecuteReader();
while (query.Read())
{
FamilyMemberViewModel dbEntry = Read(query);
Remedies.Add(dbEntry);
}
selectCommand = new SqliteCommand(
"SELECT Count(*) " +
"FROM FamilyMembers " +
"WHERE ((@Code IS NULL OR @Code = '' OR Name LIKE @Code) " +
"AND (@Name IS NULL OR @Name = '' OR Name LIKE @Name)) " +
"AND CompanyId = @CompanyId;", db);
selectCommand.Parameters.AddWithValue("@Code", ((object)familyMemberSearchObject.Search_Code) != null ? "%" + familyMemberSearchObject.Search_Code + "%" : "");
selectCommand.Parameters.AddWithValue("@Name", ((object)familyMemberSearchObject.Search_Name) != null ? "%" + familyMemberSearchObject.Search_Name + "%" : "");
selectCommand.Parameters.AddWithValue("@CompanyId", companyId);
query = selectCommand.ExecuteReader();
if (query.Read())
{
response.TotalItems = query.GetInt32(0);
}
}
catch (SqliteException error)
{
MainWindow.ErrorMessage = error.Message;
response.Success = false;
response.Message = error.Message;
response.FamilyMembers = new List <FamilyMemberViewModel>();
return(response);
}
db.Close();
}
response.Success = true;
response.FamilyMembers = Remedies;
return(response);
}
private void RemoveRelationship()
{
FamilyMemberViewModel.RemoveFamilyMember(FamilyMemberTemplate);
}
