public MA_INSTRUMENT GetByID(SessionInfo sessioninfo, Guid guID)
{
try
{
MA_INSTRUMENT instrument = null;
using (EFUnitOfWork unitOfWork = new EFUnitOfWork())
{
instrument = unitOfWork.MA_INSTRUMENTRepository.GetByID(guID);
}
//if (instruments.Count == 1)
//{
// return instruments[0];
//}
//else
//{
// throw this.CreateException(new Exception() , "Found multiple instruments with label " + strLabel);
//}
return instrument;
}
catch (DataServicesException ex)
{
throw this.CreateException(ex, null);
}
}
public List<MA_INSTRUMENT> GetBondsByFilter(SessionInfo sessioninfo, string label, string sorting)
{
try
{
IEnumerable<MA_INSTRUMENT> sortedRecords;
using (EFUnitOfWork unitOfWork = new EFUnitOfWork())
{
var query = unitOfWork.MA_INSTRUMENTRepository.GetAll().Where(p => p.MA_PRODUCT.LABEL.Equals(ProductCode.BOND.ToString())).AsQueryable();
//Filters
if (!string.IsNullOrEmpty(label))
{
query = query.Where(p => p.LABEL.IndexOf(label, StringComparison.OrdinalIgnoreCase) >= 0);
}
//Sorting
string[] sortsp = sorting.Split(' ');
IQueryable<MA_INSTRUMENT> orderedRecords = query.OrderBy(sortsp[0], sortsp[1]);
sortedRecords = orderedRecords.ToList();
}
//Return result to jTable
return sortedRecords.ToList();
}
catch (DataServicesException ex)
{
throw this.CreateException(ex, null);
}
}
public List<MA_PROFILE_FUNCTIONAL> GetProfileFunctionByFilter(SessionInfo sessioninfo,string strprofile,string strfunction,string sorting)
{
try
{
IEnumerable<MA_PROFILE_FUNCTIONAL> sortedRecords;
using (EFUnitOfWork unitOfWork = new EFUnitOfWork())
{
var query = unitOfWork.MA_PROFILE_FUNCTIONALRepository.GetAll().AsQueryable();
Guid guTemp;
//Filters
if (Guid.TryParse(strfunction, out guTemp)) //Function
{
query = query.Where(p => p.FUNCTIONAL_ID == Guid.Parse(strfunction));
}
if (Guid.TryParse(strprofile, out guTemp)) //profile
{
query = query.Where(p => p.USER_PROFILE_ID == Guid.Parse(strprofile));
}
//Sorting
string[] sortsp = sorting.Split(' ');
IQueryable<MA_PROFILE_FUNCTIONAL> orderedRecords = query.OrderBy(sortsp[0], sortsp[1]);
sortedRecords = orderedRecords.ToList();
}
return sortedRecords.ToList();
}
catch (DataServicesException ex)
{
throw this.CreateException(ex, null);
}
}
public DA_TRN CancelDeal(SessionInfo sessioninfo, DA_TRN trn)
{
LookupBusiness _lookupBusiness = new LookupBusiness();
using (EFUnitOfWork unitOfWork = new EFUnitOfWork())
{
var foundTrn = unitOfWork.DA_TRNRepository.GetById(trn.ID,true);
if (foundTrn == null)
throw this.CreateException(new Exception(), "Data not found!");
else if (!Guid.Equals(foundTrn.LOG.INSERTBYUSERID, sessioninfo.CurrentUserId))
{
throw this.CreateException(new Exception(), "You have no right to cancel this transaction");
}
else if (!(foundTrn.ENGINE_DATE.Date == sessioninfo.Process.CurrentDate && foundTrn.SOURCE == "INT"))
{
throw this.CreateException(new Exception(), "You cannot cancel the past deals");
}
else
{
//foundTrn.STATUS_ID = new Guid("1ccd7506-b98c-4afa-838e-24378d9b3c2e");
foundTrn.REMARK = trn.REMARK;
foundTrn.STATUS_ID = _lookupBusiness.GetStatusAll().FirstOrDefault(p => p.LABEL == StatusCode.CANCELLED.ToString()).ID;
foundTrn.LOG.MODIFYBYUSERID = sessioninfo.CurrentUserId;
foundTrn.LOG.MODIFYDATE = DateTime.Now;
trn = foundTrn;
unitOfWork.Commit();
}
}
return trn;
}
public void TraceAuditLoginUser(SessionInfo sessioninfo)
{
using (EFUnitOfWork unitOfWork = new EFUnitOfWork())
{
List<DA_LOGIN_AUDIT> foundaudits = unitOfWork.DA_LOGIN_AUDITRepository.GetByUserID(sessioninfo.CurrentUserId);
if (foundaudits.Count > 0)
{
foreach (DA_LOGIN_AUDIT foundaudit in foundaudits.Where(p => !p.LOGOUT_DATE.HasValue))
{
foundaudit.LOGOUT_DATE = DateTime.Now;
foundaudit.RESULT = String.Format("Logout the system on {0}, because someone use this user to login the system from another machine or computer place.", DateTime.Now.ToString());
}
}
DA_LOGIN_AUDIT audit = new DA_LOGIN_AUDIT();
audit.ID = sessioninfo.ID;
audit.LOG.INSERTBYUSERID = sessioninfo.CurrentUserId;
audit.LOG.INSERTDATE = DateTime.Now;
audit.LOGON_DATE = DateTime.Now;
audit.RESULT = "Logon System";
audit.TERMINAL = sessioninfo.IPAddress;
audit.USER_ID = sessioninfo.CurrentUserId;
unitOfWork.DA_LOGIN_AUDITRepository.Add(audit);
unitOfWork.Commit();
}
}
public List<MA_LIMIT_PRODUCT> GetLimitProductByFilter(SessionInfo sessioninfo,string strproduct,string strlimit, string sorting)
{
try
{
IEnumerable<MA_LIMIT_PRODUCT> sortedRecords;
using (EFUnitOfWork unitOfWork = new EFUnitOfWork())
{
var query = unitOfWork.MA_LIMIT_PRODUCTRepository.GetAll().AsQueryable();
Guid guTemp;
//Filters
if (Guid.TryParse(strproduct, out guTemp)) //Function
{
query = query.Where(p => p.PRODUCT_ID == Guid.Parse(strproduct));
}
if (Guid.TryParse(strlimit, out guTemp)) //profile
{
query = query.Where(p => p.LIMIT_ID == Guid.Parse(strlimit));
}
//Sorting
string[] sortsp = sorting.Split(' ');
IQueryable<MA_LIMIT_PRODUCT> orderedRecords = query.OrderBy(sortsp[0], sortsp[1]);
sortedRecords = orderedRecords.ToList();
}
//Return result to jTable
return sortedRecords.ToList();
}
catch (DataServicesException ex)
{
throw this.CreateException(ex, null);
}
}
public MA_COUNTRY_LIMIT CreateTempLimit(SessionInfo sessioninfo, MA_COUNTRY_LIMIT record)
{
using (EFUnitOfWork unitOfWork = new EFUnitOfWork())
{
if (record.EFFECTIVE_DATE < sessioninfo.Process.CurrentDate)
throw this.CreateException(new Exception(), "Effective date cannot be set to past date.");
if (record.EXPIRY_DATE < sessioninfo.Process.CurrentDate)
throw this.CreateException(new Exception(), "Expiry date cannot be set to past date.");
if (record.EXPIRY_DATE <= record.EFFECTIVE_DATE)
throw this.CreateException(new Exception(), "Expiry date must be after effective date.");
var duplicate = unitOfWork.MA_COUNTRY_LIMITRepository.All().FirstOrDefault(p => p.ISTEMP == true && p.ISACTIVE == true
&& p.COUNTRY_ID == record.COUNTRY_ID && p.EXPIRY_DATE >= record.EFFECTIVE_DATE);
if (duplicate != null)
throw this.CreateException(new Exception(), "Duplicate temp limit info");
LogBusiness logBusiness = new LogBusiness();
var newRecord = new { AMOUNT = record.AMOUNT, EFFECTIVE_DATE = record.EFFECTIVE_DATE, EXPIRY_DATE = record.EXPIRY_DATE };
unitOfWork.DA_LOGGINGRepository.Add(logBusiness.CreateLogging(sessioninfo, record.COUNTRY_ID, LimitLogEvent.TEMP_COUNTRY_LIMIT_AUDIT.ToString(), LookupFactorTables.MA_COUNTRY_LIMIT, "Temp Country Limit", newRecord));
unitOfWork.MA_COUNTRY_LIMITRepository.Add(record);
unitOfWork.Commit();
}
return record;
}
public MA_COUNTRY Create(SessionInfo sessioninfo, MA_COUNTRY country)
{
using (EFUnitOfWork unitOfWork = new EFUnitOfWork())
{
var checkDuplicate1 = unitOfWork.MA_COUNTRYRepository.All().FirstOrDefault(p => p.LABEL == country.LABEL);
if (checkDuplicate1 != null)
throw this.CreateException(new Exception(), "Short name is duplicated");
//Prepare Country-Limit data
MA_COUNTRY_LIMIT ctLimit = new MA_COUNTRY_LIMIT();
ctLimit.ID = Guid.NewGuid();
ctLimit.COUNTRY_ID = country.ID;
ctLimit.AMOUNT = 0;
ctLimit.EFFECTIVE_DATE = sessioninfo.Process.CurrentDate;
ctLimit.EXPIRY_DATE = sessioninfo.Process.CurrentDate;
ctLimit.ISACTIVE = true;
ctLimit.ISTEMP = false;
ctLimit.FLAG_CONTROL = true;
ctLimit.LOG.INSERTDATE = DateTime.Now;
ctLimit.LOG.INSERTBYUSERID = sessioninfo.CurrentUserId;
unitOfWork.MA_COUNTRYRepository.Add(country);
unitOfWork.MA_COUNTRY_LIMITRepository.Add(ctLimit);
unitOfWork.Commit();
}
return country;
}
public MA_USER_PROFILE UpdateUserProfile(SessionInfo sessioninfo, MA_USER_PROFILE userprofile)
{
using (EFUnitOfWork unitOfWork = new EFUnitOfWork())
{
var checkDuplicate = unitOfWork.MA_USER_PROFILERepository.GetAll().FirstOrDefault(p => p.LABEL.ToLower().Equals(userprofile.LABEL.ToLower()) && p.ID != userprofile.ID);
if (checkDuplicate != null)
throw this.CreateException(new Exception(), "Profile is duplicated");
var founduserprofile = unitOfWork.MA_USER_PROFILERepository.All().FirstOrDefault(p => p.ID == userprofile.ID);
if (founduserprofile == null)
throw this.CreateException(new Exception(), "Data not found!");
else
{
founduserprofile.ID = userprofile.ID;
founduserprofile.LABEL = userprofile.LABEL;
founduserprofile.ISACTIVE = userprofile.ISACTIVE;
unitOfWork.Commit();
}
}
return userprofile;
}
public MA_LIMIT_PRODUCT UpdateLimitProduct(SessionInfo sessioninfo, MA_LIMIT_PRODUCT limitproduct)
{
using (EFUnitOfWork unitOfWork = new EFUnitOfWork())
{
var checkDuplicate = unitOfWork.MA_LIMIT_PRODUCTRepository.GetAll().FirstOrDefault(p => p.LIMIT_ID == limitproduct.LIMIT_ID & p.PRODUCT_ID == limitproduct.PRODUCT_ID && p.ID != limitproduct.ID);
if (checkDuplicate != null)
throw this.CreateException(new Exception(), Messages.DUPLICATE_DATA);
var foundlimitproduct = unitOfWork.MA_LIMIT_PRODUCTRepository.All().FirstOrDefault(p => p.ID == limitproduct.ID);
if (foundlimitproduct == null)
throw this.CreateException(new Exception(), Messages.DATA_NOT_FOUND);
else
{
foundlimitproduct.ID = limitproduct.ID;
foundlimitproduct.LIMIT_ID = limitproduct.LIMIT_ID;
foundlimitproduct.MA_LIMIT = limitproduct.MA_LIMIT;
foundlimitproduct.MA_PRODUCT = limitproduct.MA_PRODUCT;
foundlimitproduct.PRODUCT_ID = limitproduct.PRODUCT_ID;
unitOfWork.Commit();
}
}
return limitproduct;
}
public List<MA_USER_PROFILE> GetProfileByFilter(SessionInfo sessioninfo, string name, string sorting)
{
try
{
//IEnumerable<MA_USER> query;
IEnumerable<MA_USER_PROFILE> sortedRecords;
using (EFUnitOfWork unitOfWork = new EFUnitOfWork())
{
var query = unitOfWork.MA_USER_PROFILERepository.GetAll().AsQueryable();
//Filters
if (!string.IsNullOrEmpty(name))
{
query = query.Where(p => p.LABEL.IndexOf(name, StringComparison.OrdinalIgnoreCase) >= 0);
}
//Sorting
string[] sortsp = sorting.Split(' ');
IQueryable<MA_USER_PROFILE> orderedRecords = query.OrderBy(sortsp[0], sortsp[1]);
sortedRecords = orderedRecords.ToList();
}
//Return result to jTable
return sortedRecords.ToList();
}
catch (DataServicesException ex)
{
throw this.CreateException(ex, null);
}
}
public DA_LOGIN_AUDIT GetUserLogged(SessionInfo sessioninfo)
{
using (EFUnitOfWork unitOfWork = new EFUnitOfWork())
{
//return unitOfWork.DA_LOGIN_AUDITRepository.GetBySessionInfo(sessioninfo);
return unitOfWork.DA_LOGIN_AUDITRepository.GetByID(sessioninfo.ID);
}
}
public List<MA_USER_PROFILE> GetProfileOptions()
{
List<MA_USER_PROFILE> profileList;
using (EFUnitOfWork unitOfWork = new EFUnitOfWork())
{
profileList = unitOfWork.MA_USER_PROFILERepository.GetAll();
}
return profileList;
}
public List<MA_USER> GetAll()
{
List<MA_USER> userList;
using (EFUnitOfWork unitOfWork = new EFUnitOfWork())
{
userList = unitOfWork.MA_USERRepository.GetAll().OrderBy(p => p.NAME).ToList();
}
return userList;
}
public void DeleteUser(SessionInfo sessioninfo, Guid ID)
{
using (EFUnitOfWork unitOfWork = new EFUnitOfWork())
{
var foundUser = unitOfWork.MA_USERRepository.All().FirstOrDefault(p => p.ID == ID);
unitOfWork.MA_USERRepository.Delete(foundUser);
unitOfWork.Commit();
}
}
public void ImportCashflows(SessionInfo sessioninfo, List<DA_TRN_CASHFLOW> cashflows)
{
using (EFUnitOfWork unitOfWork = new EFUnitOfWork())
{
foreach (DA_TRN_CASHFLOW cashflow in cashflows)
{
unitOfWork.DA_TRN_CASHFLOWRepository.Add(cashflow);
}
unitOfWork.Commit();
}
}
public void DeleteProfileFunction(SessionInfo sessioninfo, Guid guID)
{
using (EFUnitOfWork unitOfWork = new EFUnitOfWork())
{
var foundprofilefunction = unitOfWork.MA_PROFILE_FUNCTIONALRepository.All().FirstOrDefault(p => p.ID == guID);
if (foundprofilefunction == null)
throw this.CreateException(new Exception(), Messages.DATA_NOT_FOUND);
else
{
unitOfWork.MA_PROFILE_FUNCTIONALRepository.Delete(foundprofilefunction);
unitOfWork.Commit();
}
}
}
public MA_PCCF CreatePCCF(SessionInfo sessioninfo, MA_PCCF pccf)
{
using (EFUnitOfWork unitOfWork = new EFUnitOfWork())
{
var checkDuplicate = unitOfWork.MA_PCCFRepository.GetAll().FirstOrDefault(p => p.LABEL.ToLower().Equals(pccf.LABEL.ToLower()));
if (checkDuplicate != null)
throw this.CreateException(new Exception(), Messages.DUPLICATE_DATA);
unitOfWork.MA_PCCFRepository.Add(pccf);
unitOfWork.Commit();
}
return pccf;
}
public MA_FUNCTIONAL CreateFunction(SessionInfo sessioninfo, MA_FUNCTIONAL function)
{
using (EFUnitOfWork unitOfWork = new EFUnitOfWork())
{
var checkDuplicate = unitOfWork.MA_FUNCTIONALRepository.GetAll().FirstOrDefault(p => p.USERCODE.ToLower().Equals(function.USERCODE.ToLower()));
if (checkDuplicate != null)
throw this.CreateException(new Exception(), Messages.DUPLICATE_DATA);
unitOfWork.MA_FUNCTIONALRepository.Add(function);
unitOfWork.Commit();
}
return function;
}
public void TraceAuditLogoutUser(SessionInfo sessioninfo)
{
using (EFUnitOfWork unitOfWork = new EFUnitOfWork())
{
//DA_LOGIN_AUDIT foundaudit = unitOfWork.DA_LOGIN_AUDITRepository.GetBySessionInfo(sessioninfo);
DA_LOGIN_AUDIT foundaudit = unitOfWork.DA_LOGIN_AUDITRepository.GetByID(sessioninfo.ID);
if (foundaudit != null)
{
foundaudit.LOGOUT_DATE = DateTime.Now;
foundaudit.RESULT = String.Format("Logout the system on {0}", DateTime.Now.ToString());
}
unitOfWork.Commit();
}
}
public MA_USER_PROFILE CreateUserProfile(SessionInfo sessioninfo, MA_USER_PROFILE userprofile)
{
using (EFUnitOfWork unitOfWork = new EFUnitOfWork())
{
var checkDuplicate = unitOfWork.MA_USER_PROFILERepository.GetAll().FirstOrDefault(p => p.LABEL.ToLower().Equals(userprofile.LABEL.ToLower()));
if (checkDuplicate != null)
throw this.CreateException(new Exception(), "Profile is duplicated");
unitOfWork.MA_USER_PROFILERepository.Add(userprofile);
unitOfWork.Commit();
}
return userprofile;
}
public MA_PROFILE_FUNCTIONAL CreateProfileFunction(SessionInfo sessioninfo, MA_PROFILE_FUNCTIONAL profilefunction)
{
using (EFUnitOfWork unitOfWork = new EFUnitOfWork())
{
if (ValidateProfileFunction(profilefunction))
{
unitOfWork.MA_PROFILE_FUNCTIONALRepository.Add(profilefunction);
unitOfWork.Commit();
}
else
throw this.CreateException(new Exception(), Messages.DUPLICATE_DATA);
}
return profilefunction;
}
public MA_LIMIT_PRODUCT CreateLimitProduct(SessionInfo sessioninfo, MA_LIMIT_PRODUCT limitproduct)
{
using (EFUnitOfWork unitOfWork = new EFUnitOfWork())
{
if (ValidateProfileFunction(limitproduct))
{
unitOfWork.MA_LIMIT_PRODUCTRepository.Add(limitproduct);
unitOfWork.Commit();
}
else
throw this.CreateException(new Exception(), Messages.DUPLICATE_DATA);
}
return limitproduct;
}
public MA_USER CreateUser(SessionInfo sessioninfo, MA_USER user)
{
using (EFUnitOfWork unitOfWork = new EFUnitOfWork())
{
var checkDuplicate = unitOfWork.MA_USERRepository.GetByUserCode(user.USERCODE);
if (checkDuplicate != null)
throw this.CreateException(new Exception(), Messages.DUPLICATE_DATA);
LogBusiness logBusiness = new LogBusiness();
unitOfWork.DA_LOGGINGRepository.Add(logBusiness.CreateLogging(sessioninfo, user.ID, LogEvent.USER_AUDIT.ToString(), LookupFactorTables.MA_USER, "User", new { }));
unitOfWork.MA_USERRepository.Add(user);
unitOfWork.Commit();
}
return user;
}
public void UpdateDealReconcile(SessionInfo sessioninfo, List<DealTranModel> trns)
{
DealBusiness _dealBusiness = new DealBusiness();
LoggingHelper.Debug("Begin UpdateDealReconcile....");
using (EFUnitOfWork unitOfWork = new EFUnitOfWork())
{
foreach (DealTranModel tran in trns)
{
switch (tran.UpdateStates)
{
case UpdateStates.Adding:
unitOfWork.DA_TRNRepository.Add(tran.Transaction);
LoggingHelper.Debug(String.Format("Insert DA_TRN {0} [{1}] is completed", tran.Transaction.INT_DEAL_NO, tran.Transaction.ID.ToString()));
break;
case UpdateStates.Editing:
var update = unitOfWork.DA_TRNRepository.All().FirstOrDefault(p => p.ID == tran.Transaction.ID);
if (update == null)
throw this.CreateException(new Exception(), "Data not found!");
else
{
update.EXT_DEAL_NO = tran.Transaction.EXT_DEAL_NO;
update.EXT_PORTFOLIO = tran.Transaction.EXT_PORTFOLIO;
update.MATURITY_DATE = tran.Transaction.MATURITY_DATE;
update.STATUS_ID = tran.Transaction.STATUS_ID;
update.LOG.MODIFYBYUSERID = tran.Transaction.LOG.MODIFYBYUSERID;
update.LOG.MODIFYDATE = tran.Transaction.LOG.MODIFYDATE;
update.INSERT_BY_EXT = tran.Transaction.INSERT_BY_EXT;
}
LoggingHelper.Debug(String.Format("Update DA_TRN {0} [{1}] is completed", update.INT_DEAL_NO, update.ID.ToString()));
break;
case UpdateStates.Deleting:
var delete = unitOfWork.DA_TRNRepository.All().FirstOrDefault(p => p.ID == tran.Transaction.ID);
if (delete == null)
throw this.CreateException(new Exception(), "Data not found!");
else
unitOfWork.DA_TRNRepository.Delete(delete);
LoggingHelper.Debug(String.Format("Delete DA_TRN {0} [{1}] is completed", delete.INT_DEAL_NO, delete.ID.ToString()));
break;
}
}
unitOfWork.Commit();
LoggingHelper.Debug("Commit UpdateDealReconcile....");
}
}
public List<MA_FUNCTIONAL> GetFunctionByFilter(SessionInfo sessioninfo, string name, string sorting)
{
try
{
//IEnumerable<MA_USER> query;
IEnumerable<MA_FUNCTIONAL> sortedRecords;
using (EFUnitOfWork unitOfWork = new EFUnitOfWork())
{
var query = unitOfWork.MA_FUNCTIONALRepository.GetAll().AsQueryable();
//Filters
if (!string.IsNullOrEmpty(name))
{
query = query.Where(p => p.USERCODE.IndexOf(name, StringComparison.OrdinalIgnoreCase) >= 0);
}
//IQueryable<MA_FUNCTIONAL> orderedRecords = null;
////Sorting
//if (string.IsNullOrEmpty(sorting) || sorting.Equals("LABEL ASC"))
//{
// orderedRecords = query.OrderBy(p => p.LABEL).AsQueryable();
//}
//else if (sorting.Equals("LABEL DESC"))
//{
// orderedRecords = query.OrderByDescending(p => p.LABEL).AsQueryable();
//}
//else
//{
// orderedRecords = query.OrderBy(p => p.LABEL).AsQueryable(); //Default!
//}
//sortedRecords = orderedRecords.ToList();
//Sorting
string[] sortsp = sorting.Split(' ');
IQueryable<MA_FUNCTIONAL> orderedRecords = query.OrderBy(sortsp[0], sortsp[1]);
sortedRecords = orderedRecords.ToList();
//if (sortsp[1].ToLower() == "desc") sortedRecords = sortedRecords.Reverse();
}
//Return result to jTable
return sortedRecords.ToList();
}
catch (DataServicesException ex)
{
throw this.CreateException(ex, null);
}
}
public MA_PROCESS_DATE Get()
{
try
{
MA_PROCESS_DATE prcDate = null;
using (EFUnitOfWork unitOfWork = new EFUnitOfWork())
{
prcDate = unitOfWork.MA_PROCESS_DATERepository.All().First();
}
return prcDate;
}
catch (DataServicesException ex)
{
throw this.CreateException(ex, null);
}
}
public List<PermisionModel> GetPermissionByProfileID(Guid guProfileID)
{
List<PermisionModel> permissions = null;
using (EFUnitOfWork unitOfWork = new EFUnitOfWork())
{
var query = unitOfWork.MA_PROFILE_FUNCTIONALRepository.GetByUserProfileId(guProfileID)
.Select(p => new PermisionModel
{
FunctionalCode = p.MA_FUNCTIONAL.USERCODE,
FunctionalLabel = p.MA_FUNCTIONAL.LABEL,
IsReadable = p.ISREADABLE,
IsWritable = p.ISWRITABLE,
IsApprovable = p.ISAPPROVABLE
});
permissions = query.ToList();
}
return permissions;
}
public MA_INSTRUMENT Create(SessionInfo sessioninfo, MA_INSTRUMENT instrument, ProductCode product)
{
using (EFUnitOfWork unitOfWork = new EFUnitOfWork())
{
var checkDuplicate = unitOfWork.MA_INSTRUMENTRepository.GetAllByProductCode(product.ToString()).FirstOrDefault(p => p.LABEL == instrument.LABEL);
if (checkDuplicate != null)
throw this.CreateException(new Exception(), "Label is duplicated");
if (product == ProductCode.BOND)
{
LogBusiness logBusiness = new LogBusiness();
unitOfWork.DA_LOGGINGRepository.Add(logBusiness.CreateLogging(sessioninfo, instrument.ID, LogEvent.INSTRUMENT_AUDIT.ToString(), LookupFactorTables.MA_INSTRUMENT, "BOND", new { }));
}
unitOfWork.MA_INSTRUMENTRepository.Add(instrument);
unitOfWork.Commit();
}
return instrument;
}
public MA_PROCESS_DATE Update(SessionInfo sessioninfo, MA_PROCESS_DATE processdate)
{
using (EFUnitOfWork unitOfWork = new EFUnitOfWork())
{
var found = unitOfWork.MA_PROCESS_DATERepository.All().First();
if (found == null)
throw this.CreateException(new Exception(), "Data not found!");
else
{
found.NEXT_PROC_DATE = processdate.NEXT_PROC_DATE;
found.PREV_PROC_DATE = processdate.PREV_PROC_DATE;
found.PROC_DATE = processdate.PROC_DATE;
found.FLAG_RECONCILE = processdate.FLAG_RECONCILE;
found.LOG.MODIFYBYUSERID = processdate.LOG.MODIFYBYUSERID;
found.LOG.MODIFYDATE = processdate.LOG.MODIFYDATE;
found.FLAG_RECONCILE = processdate.FLAG_RECONCILE;
unitOfWork.Commit();
}
}
return processdate;
}