public async Task <bool> Update(PersonalDetailEntity entity)
{
var result = 0;
var memberList = _context.Member.Where(x => x.IsActive.Value).Select(x => new {
id = x.MemberId,
desc = x.MemberDesc
}).ToList();
var CodeValue = _context.CodeValue.Where(x => x.IsActive.Value).Select(x => x).ToList();
var detail = _context.FamilyDetail.Where(x => x.IsActive.Value && x.FamilyDetailId == entity.UniqueKey).FirstOrDefault();
if (detail != null)
{
detail.MemberId = memberList.Where(x => x.desc == entity.RelationWithEmp).Select(x => x.id).FirstOrDefault();
detail.BirthDate = Convert.ToDateTime(entity.DateOfBirth);
detail.GenderId = CodeValue.Where(x => x.ValCode.ToLower() == entity.Gender.ToLower() && x.TypeCode == GlobalConstant.Gender).Select(x => x.CodeValId).FirstOrDefault();
detail.FirstName = entity.MemberName.Split(" ")[0];
detail.LastName = entity.MemberName.Split(" ")[1];
detail.MaritalStatusId = CodeValue.Where(x => x.ValCode.ToLower() == entity.MaritalStatus.ToLower() && x.TypeCode == GlobalConstant.MaritalStatus).Select(x => x.CodeValId).FirstOrDefault();
detail.NomineeName = string.IsNullOrEmpty(entity.NameOfNominee) ? null : entity.NameOfNominee;
detail.NomineeRelationId = string.IsNullOrEmpty(entity.RelationOfNomineeWithEmp) ? (int?)null : memberList.Where(x => x.desc == entity.RelationOfNomineeWithEmp).Select(x => x.id).FirstOrDefault();
detail.Reason = entity.Reason;
detail.ModifiedBy = "System";
detail.ModifiedDate = DateTime.Now;
result = _context.SaveChanges();
}
if (result > 0)
{
return(true);
}
return(false);
}
public async Task <bool> Delete(PersonalDetailEntity entity)
{
var result = 0;
var detail = _context.FamilyDetail.Where(x => x.IsActive.Value && x.FamilyDetailId == entity.UniqueKey).FirstOrDefault();
if (detail != null)
{
_context.Remove(detail);
result = _context.SaveChanges();
}
if (result > 0)
{
return(true);
}
return(false);
}
public async Task <bool> Add(PersonalDetailEntity entity)
{
var result = 0;
var memberList = _context.Member.Where(x => x.IsActive.Value).Select(x => new {
id = x.MemberId,
desc = x.MemberDesc
}).ToList();
var maxSerialno = 0;
var maxSerialnoquery = _context.FamilyDetail.Where(x => x.IsActive.Value && x.RepId == LoggedInUserId).Select(x => x.SerialNo);
if (maxSerialnoquery.Any())
{
maxSerialno = maxSerialnoquery.Max();
}
var CodeValue = _context.CodeValue.Where(x => x.IsActive.Value).Select(x => x).ToList();
var detail = new FamilyDetail()
{
RepId = LoggedInUserId,
MemberId = memberList.Where(x => x.desc == entity.RelationWithEmp).Select(x => x.id).FirstOrDefault(),
SerialNo = maxSerialno + 1,
BirthDate = Convert.ToDateTime(entity.DateOfBirth),
GenderId = CodeValue.Where(x => x.ValCode.ToLower() == entity.Gender.ToLower() && x.TypeCode == GlobalConstant.Gender).Select(x => x.CodeValId).FirstOrDefault(),
FirstName = entity.MemberName.Split(" ")[0],
LastName = entity.MemberName.Split(" ")[1],
MaritalStatusId = CodeValue.Where(x => x.ValCode.ToLower() == entity.MaritalStatus.ToLower() && x.TypeCode == GlobalConstant.MaritalStatus).Select(x => x.CodeValId).FirstOrDefault(),
NomineeName = string.IsNullOrEmpty(entity.NameOfNominee) ? null : entity.NameOfNominee,
NomineeRelationId = string.IsNullOrEmpty(entity.RelationOfNomineeWithEmp) ? (int?)null : memberList.Where(x => x.desc == entity.RelationOfNomineeWithEmp).Select(x => x.id).FirstOrDefault(),
Reason = entity.Reason,
IsActive = true,
CreatedBy = "System",
CreatedDate = DateTime.Now,
ModifiedBy = "System",
ModifiedDate = DateTime.Now,
};
_context.FamilyDetail.Add(detail);
result = _context.SaveChanges();
if (result > 0)
{
return(true);
}
return(false);
}
public async Task <ApiResponse> DeletePersonalDetail(PersonalDetailEntity entity)
{
var result = await _personalDetailService.Delete(entity);
if (result)
{
return(new ApiResponse
{
Messsage = "Successfully Deleted",
Status = Status.Success.ToString()
});
}
return(new ApiResponse
{
Messsage = "Some error ,failed to delete member",
Status = Status.Failed.ToString()
});
}
public Task <bool> Update(PersonalDetailEntity entity)
{
return(_personalDetailRepository.Update(entity));
}
public Task <bool> Add(PersonalDetailEntity entity)
{
return(_personalDetailRepository.Add(entity));
}
