public MLJRecord QueryRecordByID(int RecordID) { using (MLJRecordAccessClient _MLJAccessClient = new MLJRecordAccessClient(EndpointName.MLJRecordAccess)) { return new MLJRecordCollection(_MLJAccessClient.QueryByRecordID(RecordID))[0]; } }
public StatusColorCollection QueryStatusColor() { using (MLJRecordAccessClient _MLJAccessClient = new MLJRecordAccessClient(EndpointName.MLJRecordAccess)) { return new StatusColorCollection(_MLJAccessClient.QueryStatusColor()); } }
public MLJJournalCollection Query(int PeriodID, string EntityName) { using (MLJRecordAccessClient _MLJAccessClient = new MLJRecordAccessClient(EndpointName.MLJRecordAccess)) { return new MLJJournalCollection(_MLJAccessClient.QueryByPeriodIDEntityName(PeriodID, EntityName)); } }
public decimal GetMLJSum(int periodId, int entityid) { using (MLJRecordAccessClient _MLJAccessClient = new MLJRecordAccessClient(EndpointName.MLJRecordAccess)) { return _MLJAccessClient.GetMLJSum(periodId, entityid); } }
public void CheckAndAdd(int PeriodID, int userID) { using (MLJRecordAccessClient _MLJAccessClient = new MLJRecordAccessClient(EndpointName.MLJRecordAccess)) { _MLJAccessClient.CheckAndAdd(PeriodID, userID); } }
public void Approve(int MLJRecordID, int userID) { using (MLJRecordAccessClient _MLJAccessClient = new MLJRecordAccessClient(EndpointName.MLJRecordAccess)) { //First get all JournalCollection in this period MLJRecord _MLJ = new MLJRecordCollection(_MLJAccessClient.QueryByRecordID(MLJRecordID))[0]; //New Record Record _re = new Record(); _re.Period = _MLJ.Period; _re.RecordStatus = RecordStatus.Normal; _re.Type = RecordType.WinAndLoss; foreach (MLJJournal _MLJjur in _MLJ.MLJJournalCollection) { Journal _jur = new Journal(); decimal _baseamount = _MLJjur.Mon + _MLJjur.Tue + _MLJjur.Wed + _MLJjur.Thu + _MLJjur.Fri + _MLJjur.Sat + _MLJjur.Sun; _jur.BaseAmount = _baseamount; _jur.BaseCurrency = _MLJjur.BaseCurrency; _jur.ExchangeRate = _MLJjur.ExchangeRate; _jur.SGDAmount = _baseamount * _MLJjur.ExchangeRate; _jur.EntityID = _MLJjur.EntityID; _jur.EntryUser.UserID = userID; _re.JournalCollection.Add(_jur); } //Second insert Record using (RecordAccessClient _RecordClient = new RecordAccessClient(EndpointName.RecordAccess)) { _RecordClient.Insert(_re, _re.JournalCollection.ToArray()); } //Third Change MLJ_Record Status _MLJAccessClient.ChangeStatus(MLJRecordID, RecordStatus.Confirm, userID); } }
public void UpdateJournal(MLJJournal journal) { using (MLJRecordAccessClient _MLJAccessClient = new MLJRecordAccessClient(EndpointName.MLJRecordAccess)) { _MLJAccessClient.UpdateJournal(journal); } }
public void UpdateColor(StatusColorCollection collection) { using (MLJRecordAccessClient _MLJAccessClient = new MLJRecordAccessClient(EndpointName.MLJRecordAccess)) { _MLJAccessClient.UpdateColor(collection.ToArray()); } }
public void UpdateUserMLJ(int userid, EntityCollection collection) { using (MLJRecordAccessClient _MLJAccessClient = new MLJRecordAccessClient(EndpointName.MLJRecordAccess)) { _MLJAccessClient.UpdateUserMLJ(userid,collection.ToArray()); } }