public IList <FamilyMemberBank> Get(int accountHolderId, int id)
{
try
{
Logger.LogInfo("Get: Family member information process start");
IList <FamilyMemberBank> lstFamilyMember = new List <FamilyMemberBank>();
DataTable dtAppConfig = DataBase.DBService.ExecuteCommand(string.Format(SELECT_ALL_BY_ACCOUNTHOLDER_ID_AND_ID,
accountHolderId, id));
foreach (DataRow dr in dtAppConfig.Rows)
{
FamilyMemberBank familyMemberBank = convertToFamilyMemberBankObject(dr);
lstFamilyMember.Add(familyMemberBank);
}
Logger.LogInfo("Get: Family member information process completed.");
return(lstFamilyMember);
}
catch (Exception ex)
{
StackTrace st = new StackTrace();
StackFrame sf = st.GetFrame(0);
MethodBase currentMethodName = sf.GetMethod();
LogDebug(currentMethodName.Name, ex);
return(null);
}
}
public void Update(FamilyMemberBank familyMemberBank)
{
try
{
DataBase.DBService.BeginTransaction();
DataBase.DBService.ExecuteCommandString(string.Format(UPDATE_FAMILYMEMBER_BANK,
familyMemberBank.BankId, familyMemberBank.AccountNo,
familyMemberBank.AccountType,
familyMemberBank.UpdatedOn.ToString("yyyy-MM-dd hh:mm:ss"),
familyMemberBank.UpdatedBy, familyMemberBank.Id), true);
Activity.ActivitiesService.Add(ActivityType.UpdateFamilyMember, EntryStatus.Success,
Source.Server, familyMemberBank.UpdatedByUserName, familyMemberBank.Bank.Name, familyMemberBank.MachineName);
DataBase.DBService.CommitTransaction();
}
catch (Exception ex)
{
DataBase.DBService.RollbackTransaction();
StackTrace st = new StackTrace();
StackFrame sf = st.GetFrame(0);
MethodBase currentMethodName = sf.GetMethod();
LogDebug(currentMethodName.Name, ex);
throw ex;
}
}
private FamilyMemberBank convertToFamilyMemberBankObject(DataRow dr)
{
FamilyMemberBank familymemberBank = new FamilyMemberBank();
familymemberBank.Id = dr.Field <int>("ID");
familymemberBank.AccountHolderId = dr.Field <int>("AccountHolderId");
familymemberBank.BankId = dr.Field <int>("BankId");
familymemberBank.AccountNo = dr.Field <string>("AccountNo");
familymemberBank.AccountType = dr.Field <string>("AccountType");
familymemberBank.Bank = new BankService().Get(familymemberBank.BankId);
return(familymemberBank);
}
public Result Delete(FamilyMemberBank familyMemberBank)
{
var result = new Result();
try
{
FamilyMemberBankService familyMemberService = new FamilyMemberBankService();
familyMemberService.Delete(familyMemberBank);
result.IsSuccess = true;
}
catch (Exception exception)
{
result.IsSuccess = false;
result.ExceptionInfo = exception;
}
return(result);
}
public void Delete(FamilyMemberBank familyMemberBank)
{
try
{
DataBase.DBService.ExecuteCommand(string.Format(DELETE_FAMILYMEMBER_BANK, familyMemberBank.Id));
Activity.ActivitiesService.Add(ActivityType.DeleteFamilyMember, EntryStatus.Success,
Source.Server, familyMemberBank.UpdatedByUserName, familyMemberBank.Bank.Name, familyMemberBank.MachineName);
}
catch (Exception ex)
{
StackTrace st = new StackTrace();
StackFrame sf = st.GetFrame(0);
MethodBase currentMethodName = sf.GetMethod();
LogDebug(currentMethodName.Name, ex);
throw ex;
}
}
public void Add(FamilyMemberBank familyMemberBank)
{
try
{
//string clientName = DataBase.DBService.ExecuteCommandScalar(string.Format(GET_CLIENT_NAME_QUERY, familyMember.Cid));
DataBase.DBService.ExecuteCommand(string.Format(INSERT_FAMILYMEMBER_BANK,
familyMemberBank.AccountHolderId, familyMemberBank.BankId, familyMemberBank.AccountNo,
familyMemberBank.AccountType,
familyMemberBank.CreatedOn.ToString("yyyy-MM-dd hh:mm:ss"), familyMemberBank.CreatedBy,
familyMemberBank.UpdatedOn.ToString("yyyy-MM-dd hh:mm:ss"), familyMemberBank.UpdatedBy));
Activity.ActivitiesService.Add(ActivityType.CreateFamilyMember, EntryStatus.Success,
Source.Server, familyMemberBank.UpdatedByUserName, familyMemberBank.Bank.Name, familyMemberBank.MachineName);
}
catch (Exception ex)
{
StackTrace st = new StackTrace();
StackFrame sf = st.GetFrame(0);
MethodBase currentMethodName = sf.GetMethod();
LogDebug(currentMethodName.Name, ex);
throw ex;
}
}
