//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);
}
