public R_BenificiaryMember GetBenificiaryMember(int benificiaryMemberId)
{
//Requires.NotNegative("benificiaryMemberId", benificiaryMemberId);
R_BenificiaryMember t = R_BenificiaryMember.SingleOrDefault(benificiaryMemberId);
return(t);
}
public BenificiaryMemberDTO(R_BenificiaryMember benificiaryMember)
{
BenificiaryMemberId = benificiaryMember.BenificiaryMemberId;
BenificiaryId = benificiaryMember.BenificiaryId;
Name = benificiaryMember.Name;
IsChild = benificiaryMember.IsChild;
Description = benificiaryMember.Description;
BirthDate = benificiaryMember.BirthDate;
Active = benificiaryMember.Active;
IsDeleted = benificiaryMember.IsDeleted;
CreateBy = benificiaryMember.CreateBy;
CreateOn = benificiaryMember.CreateOn;
UpdateBy = benificiaryMember.UpdateBy;
UpdateOn = benificiaryMember.UpdateOn;
}
public IEnumerable <R_BenificiaryMember> GetBenificiaryMembers()
{
IEnumerable <R_BenificiaryMember> results = null;
var sql = PetaPoco.Sql.Builder
.Select("*")
.From("R_BenificiaryMembers")
.Where("IsDeleted = 0")
;
results = R_BenificiaryMember.Query(sql);
return(results);
}
public IList <R_BenificiaryMember> GetBenificiaryMembers(string searchTerm, int pageIndex, int pageSize)
{
IList <R_BenificiaryMember> results = null;
var sql = PetaPoco.Sql.Builder
.Select("*")
.From("R_BenificiaryMembers")
.Where("IsDeleted = 0")
.Where(
"Name like '%" + searchTerm + "%'"
+ " or " + "Description like '%" + searchTerm + "%'"
)
;
results = R_BenificiaryMember.Fetch(pageIndex, pageSize, sql);
return(results);
}
public static R_BenificiaryMember ConvertDTOtoEntity(BenificiaryMemberDTO dto)
{
R_BenificiaryMember benificiaryMember = new R_BenificiaryMember();
benificiaryMember.BenificiaryMemberId = dto.BenificiaryMemberId;
benificiaryMember.BenificiaryId = dto.BenificiaryId;
benificiaryMember.Name = dto.Name;
benificiaryMember.IsChild = dto.IsChild;
benificiaryMember.Description = dto.Description;
benificiaryMember.BirthDate = dto.BirthDate;
benificiaryMember.Active = dto.Active;
benificiaryMember.IsDeleted = dto.IsDeleted;
benificiaryMember.CreateBy = dto.CreateBy;
benificiaryMember.CreateOn = dto.CreateOn;
benificiaryMember.UpdateBy = dto.UpdateBy;
benificiaryMember.UpdateOn = dto.UpdateOn;
return(benificiaryMember);
}
public void DeleteBenificiaryMember(BenificiaryMemberDTO dto)
{
try
{
log.Debug(BenificiaryMemberDTO.FormatBenificiaryMemberDTO(dto));
R_BenificiaryMember t = BenificiaryMemberDTO.ConvertDTOtoEntity(dto);
// delete
Repository.DeleteBenificiaryMember(t);
log.Debug("result: 'success'");
}
catch (System.Exception e)
{
// error
log.Error(e.ToString());
throw;
}
}
public void UpdateBenificiaryMember(BenificiaryMemberDTO dto)
{
try
{
//Requires.NotNull(t);
//Requires.PropertyNotNegative(t, "BenificiaryMemberId");
log.Debug(BenificiaryMemberDTO.FormatBenificiaryMemberDTO(dto));
R_BenificiaryMember t = BenificiaryMemberDTO.ConvertDTOtoEntity(dto);
// update
Repository.UpdateBenificiaryMember(t);
log.Debug("result: 'success'");
}
catch (System.Exception e)
{
// error
log.Error(e.ToString());
throw;
}
}
public void DeleteBenificiaryMember(R_BenificiaryMember t)
{
t.IsDeleted = true;
t.Update();
}
public int AddBenificiaryMember(R_BenificiaryMember t)
{
int id = (int)t.Insert();
return(id);
}
