public int OpdateringAfSlettet_rsmembership_transaction(int p_trans_id, dbData3060DataContext p_dbData3060)
{
int out_trans_id = p_trans_id;
puls3060_dkEntities dbPuls3060_dk = new puls3060_dkEntities();
var qry1 = from s1 in dbPuls3060_dk.ecpwt_rsmembership_transactions where s1.id == p_trans_id select s1;
int c1 = qry1.Count();
if (c1 == 0)
{
var qry2 = from s2 in p_dbData3060.tblrsmembership_transactions where s2.trans_id == p_trans_id select s2;
try
{
tblrsmembership_transaction t2 = qry2.First();
int?subscriber_id = t2.subscriber_id;
var qry3 = from s3 in dbPuls3060_dk.ecpwt_rsmembership_membership_subscribers where s3.id == subscriber_id select s3;
int c3 = qry3.Count();
if (c3 == 1)
{
ecpwt_rsmembership_transactions t1 = new ecpwt_rsmembership_transactions
{
user_id = t2.user_id,
user_email = t2.user_email,
user_data = t2.user_data,
type = t2.type,
@params = t2.@params,
date = t2.date,
ip = t2.ip,
price = t2.price,
coupon = t2.coupon,
currency = t2.currency,
hash = t2.hash,
custom = t2.custom,
gateway = t2.gateway,
status = t2.status,
response_log = t2.response_log
};
dbPuls3060_dk.ecpwt_rsmembership_transactions.Add(t1);
dbPuls3060_dk.SaveChanges();
ecpwt_rsmembership_transactions rec_trans = (from t in dbPuls3060_dk.ecpwt_rsmembership_transactions where t.custom == t2.custom select t).First();
out_trans_id = rec_trans.id;
}
else
{
out_trans_id = 0;
}
}
catch
{
out_trans_id = 0;
}
}
return(out_trans_id);
}
public MemBogfoeringsKlader konter_paypal_betalinger_fra_rsmembership(puls3060_dkEntities p_dbPuls3060_dk, DateTime Regnskabsaar_Startdato, DateTime Regnskabsaar_Slutdato)
{
clsPayPal objPayPal = new clsPayPal();
MemBogfoeringsKlader klader = new MemBogfoeringsKlader();
int BS1_SidsteNr = 0;
var qry_rsmembership = from s in p_dbPuls3060_dk.ecpwt_rsmembership_membership_subscribers
where s.membership_id == 6
join tl in p_dbPuls3060_dk.ecpwt_rsmembership_transactions on s.last_transaction_id equals tl.id
where tl.gateway == "PayPal"
join p in p_dbPuls3060_dk.tblpaypalpayments on tl.hash equals p.paypal_transactions_id into p1
from p in p1.DefaultIfEmpty()
where p.bogfoert == null || p.bogfoert == false
join u in p_dbPuls3060_dk.ecpwt_users on s.user_id equals u.id
select new
{
paypal_transaction_id = tl.hash,
Navn = u.name,
s.membership_id,
s.membership_start,
s.membership_end,
};
var arr_rsmembership = qry_rsmembership.ToArray();
if (arr_rsmembership.Count() > 0)
{
foreach (var rsmembership in arr_rsmembership)
{
if (rsmembership.paypal_transaction_id.Length == 0)
{
continue;
}
PaymentTransactionSearchResultType paypal_trans = objPayPal.getPayPalTransaction(rsmembership.paypal_transaction_id);
if (paypal_trans != null)
{
decimal Belob = decimal.Parse(paypal_trans.GrossAmount.Value.Replace(".", ","));
decimal[] arrBeløb = clsPbs602.fordeling(Belob, rsmembership.membership_start, rsmembership.membership_end, Regnskabsaar_Startdato, Regnskabsaar_Slutdato);
string stdate = string.Format(" {0}-{1}", rsmembership.membership_start.ToString("d.M.yyyy"), rsmembership.membership_end.ToString("d.M.yyyy"));
int wBilag = ++BS1_SidsteNr;
recBogfoeringsKlader recklade = new recBogfoeringsKlader
{
Dato = paypal_trans.Timestamp,
Bilag = wBilag,
Tekst = ("Paypal: " + rsmembership.paypal_transaction_id).PadRight(40, ' ').Substring(0, 40),
Afstemningskonto = "PayPal",
Belob = Belob,
Kontonr = null,
Faknr = null,
Sagnr = null
};
klader.Add(recklade);
if (arrBeløb[0] > 0)
{
recklade = new recBogfoeringsKlader
{
Dato = paypal_trans.Timestamp,
Bilag = wBilag,
Tekst = (rsmembership.Navn + stdate).PadRight(40, ' ').Substring(0, 40),
Afstemningskonto = "",
Belob = arrBeløb[0],
Kontonr = 1800,
Faknr = null,
Sagnr = null
};
klader.Add(recklade);
}
if (arrBeløb[1] > 0)
{
recklade = new recBogfoeringsKlader
{
Dato = paypal_trans.Timestamp,
Bilag = wBilag,
Tekst = (rsmembership.Navn + stdate).PadRight(40, ' ').Substring(0, 40),
Afstemningskonto = "",
Belob = arrBeløb[1],
Kontonr = 64200,
Faknr = null,
Sagnr = null
};
klader.Add(recklade);
}
recklade = new recBogfoeringsKlader
{
Dato = paypal_trans.Timestamp,
Bilag = wBilag,
Tekst = ("PayPal Gebyr").PadRight(40, ' ').Substring(0, 40),
Afstemningskonto = "PayPal",
Belob = decimal.Parse(paypal_trans.FeeAmount.Value.Replace(".", ",")),
Kontonr = 9950,
Faknr = null,
Sagnr = null
};
klader.Add(recklade);
tblpaypalpayment rec_paypalpayments = (from p in p_dbPuls3060_dk.tblpaypalpayments where p.paypal_transactions_id == rsmembership.paypal_transaction_id select p).FirstOrDefault();
if (rec_paypalpayments == null)
{
rec_paypalpayments = new tblpaypalpayment
{
paypal_transactions_id = rsmembership.paypal_transaction_id,
bogfoert = true
};
p_dbPuls3060_dk.tblpaypalpayments.Add(rec_paypalpayments);
}
else
{
rec_paypalpayments.bogfoert = true;
}
p_dbPuls3060_dk.SaveChanges();
}
}
}
return(klader);
}
public int betalinger_til_rsmembership(dbData3060DataContext p_dbData3060, puls3060_dkEntities p_dbPuls3060_dk)
{
int saveBetid = 0;
var rsmbrshp = from bl in p_dbData3060.tblbetlins
where (bl.pbstranskode == "0236" || bl.pbstranskode == "0297")
join b in p_dbData3060.tblbets on bl.betid equals b.id
where b.rsmembership == null || b.rsmembership == false
join p in p_dbData3060.tblfrapbs on b.frapbsid equals p.id
orderby p.id, b.id, bl.id
select new
{
Frapbsid = p.id,
p.leverancespecifikation,
Betid = b.id,
Betlinid = bl.id,
bl.betalingsdato,
bl.indbetalingsdato,
bl.indbetalingsbelob,
bl.faknr,
bl.debitorkonto
};
int AntalBetalinger = rsmbrshp.Count();
Program.Log(string.Format("betalinger_til_rsmembership - AntalBetalinger {0}", AntalBetalinger));
if (rsmbrshp.Count() > 0)
{
clsPbsHelper objPbsHelperd = new clsPbsHelper();
foreach (var b in rsmbrshp)
{
if (saveBetid != b.Betid) // ny gruppe
{
saveBetid = b.Betid;
var rec_bet = (from ub in p_dbData3060.tblbets where ub.id == b.Betid select ub).First();
rec_bet.rsmembership = true;
}
// Do somthing here
var qry = from f in p_dbData3060.tblfaks
where f.faknr == b.faknr
join m in p_dbData3060.tblrsmembership_transactions on f.id equals m.id
select new tblmembershippayment
{
rsmembership_transactions_id = m.trans_id,
};
if (qry.Count() == 1)
{
tblmembershippayment rec_membershippayment = qry.First();
//*********************************************************
int new_rsmembership_transactions_id = objPbsHelperd.OpdateringAfSlettet_rsmembership_transaction(rec_membershippayment.rsmembership_transactions_id, p_dbData3060);
Program.Log(string.Format("betalinger_til_rsmembership - transactions_id {0} --> {1}", rec_membershippayment.rsmembership_transactions_id, p_dbData3060, new_rsmembership_transactions_id));
rec_membershippayment.rsmembership_transactions_id = new_rsmembership_transactions_id;
//*********************************************************
p_dbPuls3060_dk.tblmembershippayments.Add(rec_membershippayment);
p_dbPuls3060_dk.SaveChanges();
Program.Log(string.Format("betalinger_til_rsmembership - faknr {0} betalt", b.faknr));
}
}
p_dbData3060.SubmitChanges();
}
return(AntalBetalinger);
}