private List <UserBagHistoryEN> RegisterInitialUserBagState(List <PersonBagOperatorEN> pUserBags, int pProductID)
{
List <UserBagHistoryEN> userbagStates = new List <UserBagHistoryEN>();
try
{
foreach (var bag in pUserBags)
{
UserBagHistoryEN userbagState = new UserBagHistoryEN();
userbagState.BagID = bag.BagID;
userbagState.ProductID = pProductID;
userbagState.InitialBagValue = bag.UserBalanceAmount;
userbagState.InsertedAt = DateTime.Now;
userbagState.UpdatedAt = DateTime.Now;
int statusID = topupDAL.InsertUserBagHistory(userbagState);
if (statusID > 0)
{
userbagState.ID = statusID;
userbagStates.Add(userbagState);
}
}
}
catch (Exception ex)
{
userbagStates = null;
Console.WriteLine(ex.Message);
EventViewerLogger.LogError("RegisterInitialUserBagState: " + ex.Message);
}
return(userbagStates);
}
public int UpdateUserBagHistory(UserBagHistoryEN pBagHistory)
{
int updated = default(int);
try
{
connection.Cnn.Open();
updated = connection.Cnn.Update(pBagHistory);
}
catch (Exception ex)
{
updated = 0;
Console.WriteLine(ex.InnerException);
EventViewerLogger.LogError("UpdateUserBagHistory: " + ex.Message);
}
finally
{
connection.Cnn.Close();
}
return(updated);
}
public int InsertUserBagHistory(UserBagHistoryEN pBagHistory)
{
int userBagHistoryID = default(int);
try
{
connection.Cnn.Open();
userBagHistoryID = connection.Cnn.Insert(pBagHistory) ?? default(int);
}
catch (Exception ex)
{
userBagHistoryID = 0;
Console.WriteLine(ex.InnerException);
EventViewerLogger.LogError("InsertUserBagHistory: " + ex.Message);
}
finally
{
connection.Cnn.Close();
}
return(userBagHistoryID);
}
