public IActionResult SaveFIMemberMasterData([FromBody] FiMemberContactDetails _FiMemberContactDetails)
{
FIMeberRefIdAndID _FIMeberRefIdAndID = new FIMeberRefIdAndID();
try
{
long MemberID = 0;
string Dob = string.Empty;
string MemberReferenceId = _FIMemberDAL.SaveFIMemberMasterData(_FiMemberContactDetails, Con, out MemberID, out Dob);
if (!string.IsNullOrEmpty(MemberReferenceId))
{
_FIMeberRefIdAndID.pMemberReferenceId = MemberReferenceId;
_FIMeberRefIdAndID.pMemberId = MemberID;
_FIMeberRefIdAndID.pDob = Dob;
return(Ok(_FIMeberRefIdAndID));
}
else
{
return(StatusCode(StatusCodes.Status304NotModified));
}
}
catch (Exception)
{
return(StatusCode(StatusCodes.Status500InternalServerError));
}
}
public async Task <List <FiMemberContactDetails> > GetMemberDetails(string chitbranchname, string connectionstring)
{
var _FiMemberContactDetails = new List <FiMemberContactDetails>();
await Task.Run(() =>
{
try
{
NpgsqlDataReader dr;
// string qry = "select te.memberid,te.membercode, te.contactid, te.contacttype, te.contactreferenceid, te.membername, coalesce(te.membertype,'') as membertype,coalesce(te.membertypeid, 0) as membertypeid, coalesce(memberstatus, '') as memberstatus, businessentitycontactno,te.contactreferenceid,te.statusid from tblmstmembers te join tblmstcontact tc on tc.contactid = te.contactid join tbltransfdcreation tf on tf.memberid=te.memberid where te.statusid=" + Convert.ToInt32(Status.Active) + " and tf.statusid=" + Convert.ToInt32(Status.Active) + " and chitbranchname='" + chitbranchname + "' order by membername";
//string qry = "select *,(depositamount-paidamount)balance from (select te.memberid,te.membercode, te.contactid, te.contacttype, te.contactreferenceid, te.membername, coalesce(te.membertype,'') as membertype,coalesce(te.membertypeid, 0) as membertypeid, coalesce(memberstatus, '') as memberstatus, businessentitycontactno,te.contactreferenceid,te.statusid,tf.depositamount,(select sum(received_amount)-sum(case when tr.clearstatus='Y' then 0 when tr.clearstatus is null then 0 else totalreceivedamount end )paidamount from fd_receipt fr left join tbltransreceiptreference tr on fr.receipt_no=tr.receiptid where fr.fd_account_id=tf.fdaccountid) from tblmstmembers te join tblmstcontact tc on tc.contactid = te.contactid join tbltransfdcreation tf on tf.memberid = te.memberid where te.statusid = " + Convert.ToInt32(Status.Active) + " and tf.statusid = " + Convert.ToInt32(Status.Active) + " and chitbranchname = '" + chitbranchname + "' order by membername) as d where(depositamount - paidamount) <= 0;";
string qry = "select distinct memberid,membercode,contactid,contacttype,contactreferenceid,membername,membertype,membertypeid,mobileno from vwfdtransaction_details where chitbranchname='" + chitbranchname + "' and balanceamount<=0 and fdaccountid not in(select trans_type_id from maturity_bonds) order by membername";
using (dr = NPGSqlHelper.ExecuteReader(connectionstring, CommandType.Text, qry))
{
while (dr.Read())
{
var _FIMemberContactDTO = new FiMemberContactDetails
{
pMembertypeId = Convert.ToInt64(dr["memberid"]),
pContacttype = Convert.ToString(dr["contacttype"]),
pContactName = Convert.ToString(dr["membername"]),
pMemberType = Convert.ToString(dr["membertype"]),
pContactReferenceId = Convert.ToString(dr["contactreferenceid"]),
pContactId = Convert.ToInt64(dr["contactid"]),
ptypeofoperation = "OLD",
pMemberReferenceId = Convert.ToString(dr["membercode"]),
pContactNo = Convert.ToString(dr["mobileno"])
};
_FiMemberContactDetails.Add(_FIMemberContactDTO);
}
}
}
catch (Exception ex)
{
throw;
}
});
return(_FiMemberContactDetails);
}
