//getting remittance param public IList <Param> GetRemittanceParam(string remittanceid, string biller) { remittance rem = db.remittances.Where(o => o.remittance_id == remittanceid).FirstOrDefault(); Dictionary <string, string> remittance_array = new Dictionary <string, string>(); if (rem == null) { return(null); } remittance_array.Add("mda_key", rem.MDA_ID); remittance_array.Add("Remittance", rem.remittance_id); remittance_array.Add("amount", rem.amount.ToString()); remittance_array.Add("ercasBillerId", biller); IList <Param> remittance_list = new List <Param>(); foreach (var item in remittance_array) { Param p = new Param(); p.key = item.Key; p.value = item.Value; remittance_list.Add(p); } return(remittance_list); }
//generating remittance public RemittanceDTO GetRemittance(RemittanceDTO RemitRequest) { var UserVerify = _db.aspnetusers.Where(o => o.Id == RemitRequest.USER_ID).SingleOrDefault(); var PosVerify = _db.pos.Where(o => o.POS_ID == RemitRequest.POS_ID).SingleOrDefault(); if (UserVerify == null || PosVerify == null) { return(null); } var RemitStatus = _db.remittances.Where(o => o.USER_ID == RemitRequest.USER_ID && o.remittance_status == 0 && o.MDAStation_ID == RemitRequest.MDAStation_ID) .SingleOrDefault(); if (RemitStatus != null) { RemitRequest.Message = 1; return(RemitRequest); } var collection = _db.pos_collections.Where(o => o.USER_ID == RemitRequest.USER_ID && o.CollectionStatus == 0 && o.MDAStation_ID == RemitRequest.MDAStation_ID) .FirstOrDefault(); if (collection == null) { RemitRequest.Message = 2; return(RemitRequest); } var collectionAmount = _db.pos_collections.Where(o => o.USER_ID == RemitRequest.USER_ID && o.CollectionStatus == 0 && o.MDAStation_ID == RemitRequest.MDAStation_ID) .Select(o => o.Amount).Sum(); remittance RemiteMap = Mapper.Map <RemittanceDTO, remittance>(RemitRequest); RemiteMap.amount = collectionAmount; RemiteMap.remittance_id = "RE" + RandomNumber(); RemiteMap.create_at = GetCurrentDateTime(); var RemiteResponse = _db.remittances.Add(RemiteMap); _db.SaveChanges(); RemittanceDTO RemiteResponseDTO = Mapper.Map <remittance, RemittanceDTO>(RemiteResponse); return(RemiteResponseDTO); }