public bool?GetChangeCommunicationPreference(string accountno, Enums.CommPreferenceType type)
{
bool?changedValue = null;
using (GoldmineEntities context = new GoldmineEntities())
{
switch (type)
{
case Enums.CommPreferenceType.Email:
string emailValue = (from c in context.CONTACT2.Where(x => x.ACCOUNTNO == accountno) select c.UCPEMAIL).FirstOrDefault();
if (emailValue == "Yes")
{
changedValue = true;
}
else if (emailValue == "No")
{
changedValue = false;
}
break;
case Enums.CommPreferenceType.Phone:
string phoneValue = (from c in context.CONTACT2.Where(x => x.ACCOUNTNO == accountno) select c.UCPPHONE).FirstOrDefault();
if (phoneValue == "Yes")
{
changedValue = true;
}
else if (phoneValue == "No")
{
changedValue = false;
}
break;
case Enums.CommPreferenceType.Post:
string postValue = (from c in context.CONTACT2.Where(x => x.ACCOUNTNO == accountno) select c.UCPPOST).FirstOrDefault();
if (postValue == "Yes")
{
changedValue = true;
}
else if (postValue == "No")
{
changedValue = false;
}
break;
case Enums.CommPreferenceType.SMS:
string smsValue = (from c in context.CONTACT2.Where(x => x.ACCOUNTNO == accountno) select c.UCPSMS).FirstOrDefault();
if (smsValue == "Yes")
{
changedValue = true;
}
else if (smsValue == "No")
{
changedValue = false;
}
break;
}
}
return(changedValue);
}
public void DoInit()
{
using (GoldmineEntities context = new GoldmineEntities())
{
context.Tests_GCTSC_UpdateGMRepoTestData();
}
}
private void CreateNonBAUCustomer(string _nonBAUTestAccountno)
{
using (GoldmineEntities context = new GoldmineEntities())
{
context.TESTS_CreateNonBAUCustomer(_nonBAUTestAccountno);
}
}
public ResultsObject GetReferenceNumberFromAccountno(string accountno, ResultsObject ro)
{
using (GoldmineEntities context = new GoldmineEntities())
{
ro.ReferenceNumber = (from c in context.CONTACT1.Where(c => c.ACCOUNTNO == accountno) select c.KEY5).FirstOrDefault();
}
return(ro);
}
public ResultsObject GetAccountnoFromRecid(string recid, ResultsObject ro)
{
using (GoldmineEntities context = new GoldmineEntities())
{
ro.Accountno = (from c in context.CONTSUPPs.Where(c => c.recid == recid) select c.ACCOUNTNO).FirstOrDefault();
}
return(ro);
}
public string GetUemailaddr(string accountno)
{
string uemailAddr = string.Empty;
using (GoldmineEntities context = new GoldmineEntities())
{
uemailAddr = (from c in context.CONTACT2.Where(c => c.ACCOUNTNO == accountno) select c.UEMAILADDR).FirstOrDefault();
}
return(uemailAddr);
}
public string GetPhone3(string accountno)
{
string phone3 = string.Empty;
using (GoldmineEntities context = new GoldmineEntities())
{
phone3 = (from c in context.CONTACT1.Where(c => c.ACCOUNTNO == accountno) select c.PHONE3).FirstOrDefault();
}
return(phone3);
}
public string GetLastname(string accountno)
{
string lastname = string.Empty;
using (GoldmineEntities context = new GoldmineEntities())
{
lastname = (from c in context.CONTACT1.Where(c => c.ACCOUNTNO == accountno) select c.LASTNAME).FirstOrDefault();
}
return(lastname);
}
public string GetContsupref(string recid)
{
string contsupref = string.Empty;
using (GoldmineEntities context = new GoldmineEntities())
{
contsupref = (from c in context.CONTSUPPs.Where(c => c.recid == recid) select c.CONTSUPREF).FirstOrDefault();
}
return(contsupref);
}
public string GetKey5(string accountno)
{
string key5 = string.Empty;
using (GoldmineEntities context = new GoldmineEntities())
{
key5 = (from c in context.CONTACT1.Where(c => c.ACCOUNTNO == accountno) select c.KEY5).FirstOrDefault();
}
return(key5);
}
public string GetSecr(string accountno)
{
string secr = string.Empty;
using (GoldmineEntities context = new GoldmineEntities())
{
secr = (from c in context.CONTACT1.Where(c => c.ACCOUNTNO == accountno) select c.SECR).FirstOrDefault();
}
return(secr);
}
public string GetContact(string accountno)
{
string contact = string.Empty;
using (GoldmineEntities context = new GoldmineEntities())
{
contact = (from c in context.CONTACT1.Where(c => c.ACCOUNTNO == accountno) select c.CONTACT).FirstOrDefault();
}
return(contact);
}
public string GetKey3(string accountno)
{
string nino = string.Empty;
using (GoldmineEntities context = new GoldmineEntities())
{
nino = (from c in context.CONTACT1.Where(x => x.ACCOUNTNO == accountno) select c.KEY3).FirstOrDefault();
}
return(nino);
}
private string GetAccountnoFromKey5(string randomReference)
{
string accountno = string.Empty;
using (GoldmineEntities context = new GoldmineEntities())
{
accountno = (from c in context.CONTACT1.Where(c => c.KEY5 == randomReference) select c.ACCOUNTNO).FirstOrDefault();
}
return(accountno);
}
public Refund GetRefundValues(string year, string accountno)
{
Refund refund = null;
CONTACT2 contact2 = null;
using (GoldmineEntities context = new GoldmineEntities())
{
contact2 = context.CONTACT2.Where(x => x.ACCOUNTNO == accountno).FirstOrDefault();
}
if (contact2 != null)
{
if (year == "14")
{
refund = _refundHelper.CreateRefund(contact2.U14SERVT, contact2.UY14TYPE, contact2.UY14EXPREF, contact2.UY14EXPFEE, contact2.UY14FEEDAT, contact2.UY14SIGNED,
contact2.UY14ACTFEE, contact2.UY14ACTREF, contact2.UY14COM, contact2.UY14USER, 2011, accountno);
}
if (year == "15")
{
refund = _refundHelper.CreateRefund(contact2.U15SERVT, contact2.UY15TYPE, contact2.UY15EXPREF, contact2.UY15EXPFEE, contact2.UY15FEEDAT, contact2.UY15SIGNED,
contact2.UY15ACTFEE, contact2.UY15ACTREF, contact2.UY15COM, contact2.UY15USER, 2012, accountno);
}
if (year == "16")
{
refund = _refundHelper.CreateRefund(contact2.U16SERVT, contact2.U16TYPE, contact2.U16EXPREF, contact2.U16EXPFEE, contact2.U16FEEDAT, contact2.U16SIGNED,
contact2.UY16ACTFEE, contact2.UY16ACTREF, contact2.UY16COM, contact2.U16USER, 2013, accountno);
}
if (year == "17")
{
refund = _refundHelper.CreateRefund(contact2.U17SERVT, contact2.U17TYPE, contact2.U17EXPREF, contact2.U17EXPFEE, contact2.U17FEEDAT, contact2.U17SIGNED,
contact2.UY17ACTFEE, contact2.UY17ACTREF, contact2.UY17COM, contact2.U17USER, 2014, accountno);
}
if (year == "18")
{
refund = _refundHelper.CreateRefund(contact2.U18SERVT, contact2.U18TYPE, contact2.U18EXPREF, contact2.U18EXPFEE, contact2.U18FEEDAT, contact2.U18SIGNED,
contact2.UY18ACTFEE, contact2.UY18ACTREF, contact2.UY18COM, contact2.U18USER, 2015, accountno);
}
if (year == "19")
{
refund = _refundHelper.CreateRefund(contact2.U19SERVT, contact2.U19TYPE, contact2.U19EXPREF, contact2.U19EXPFEE, contact2.U19FEEDAT, contact2.U19SIGNED,
contact2.UY19ACTFEE, contact2.UY19ACTREF, contact2.UY19COM, contact2.U19USER, 2016, accountno);
}
if (year == "20")
{
refund = _refundHelper.CreateRefund(contact2.U20SERVT, contact2.U20TYPE, contact2.U20EXPREF, contact2.U20EXPFEE, contact2.U20FEEDAT, contact2.U20SIGNED,
contact2.UY20ACTFEE, contact2.UY20ACTREF, contact2.UY20COM, contact2.U20USER, 2017, accountno);
}
if (refund != null)
{
refund.TranslatedCaseowner = GetTranslatedUser(refund.User);
}
}
return(refund);
}
public void CreateContact1Change()
{
using (GoldmineEntities context = new GoldmineEntities())
{
int result = context.TESTS_CreateContact1Change(_testAccountno);
if (result <= 0)
{
throw new Exception("Can't create contact1 change");
}
}
}
public ResultsObject GetReferenceNumberFromRecid(string recid, ResultsObject ro)
{
using (GoldmineEntities context = new GoldmineEntities())
{
string accountno = (from c in context.CONTSUPPs.Where(c => c.recid == recid) select c.ACCOUNTNO).FirstOrDefault();
if (!string.IsNullOrEmpty(accountno))
{
ro.ReferenceNumber = (from c in context.CONTACT1.Where(c => c.ACCOUNTNO == accountno) select c.KEY5).FirstOrDefault();
}
}
return(ro);
}
private int GetContact2StartVersionNumber()
{
int contact2StartVersionNumber = 1;
try
{
using (GoldmineEntities context = new GoldmineEntities())
{
contact2StartVersionNumber = int.Parse((from c in context.CONTACT2ChangeTracking(1) select c.SYS_CHANGE_VERSION).ToList().OrderByDescending(c => c.Value).First().Value.ToString());
}
}
catch (Exception) { return(contact2StartVersionNumber); }
return(contact2StartVersionNumber);
}
public Address GetAddress(string accountno)
{
Address address = null;
using (GoldmineEntities context = new GoldmineEntities())
{
CONTACT1 contact1Record = (from c in context.CONTACT1.Where(x => x.ACCOUNTNO == accountno) select c).FirstOrDefault();
if (contact1Record != null)
{
address = AddressHelper.ConvertToAddress(contact1Record);
}
}
return(address);
}
public string GetDOB(string accountno)
{
string dob = string.Empty;
using (GoldmineEntities context = new GoldmineEntities())
{
DateTime?result = (from c in context.CONTACT2.Where(x => x.ACCOUNTNO == accountno) select c.UDOB).FirstOrDefault();
if (result.HasValue)
{
dob = result.Value.ToString("yyyy-MM-dd");
}
}
return(dob);
}
private string GetEmailAddrRecId(string randomReference)
{
string accountno = string.Empty;
string emailRecid = string.Empty;
using (GoldmineEntities context = new GoldmineEntities())
{
accountno = (from c in context.CONTACT1.Where(c => c.KEY5 == randomReference) select c.ACCOUNTNO).FirstOrDefault();
if (accountno != string.Empty)
{
emailRecid = (from cs in context.CONTSUPPs.Where(cs => cs.ACCOUNTNO == accountno && cs.RECTYPE == "P" && cs.ZIP == "011") select cs.recid).FirstOrDefault();
}
}
return(emailRecid);
}
public ClientData GetClientData(string referenceNumber)
{
ClientData clientData = new ClientData();
using (GoldmineEntities context = new GoldmineEntities())
{
CONTACT1 c1 = (from c in context.CONTACT1.Where(c => c.KEY5 == referenceNumber) select c).FirstOrDefault();
if (c1 != null)
{
CONTACT2 c2 = (from c in context.CONTACT2.Where(c => c.ACCOUNTNO == c1.ACCOUNTNO) select c).FirstOrDefault();
clientData = _clientDataMapping.MapClientData(clientData, c1, c2);
clientData.Key5 = referenceNumber;
}
}
return(clientData);
}
public string GetUstage1dat(string accountno)
{
DateTime?ustage1dat = null;
using (GoldmineEntities context = new GoldmineEntities())
{
ustage1dat = (from c in context.CONTACT2.Where(c => c.ACCOUNTNO == accountno) select c.USTAGE1DAT).FirstOrDefault();
}
if (ustage1dat != null)
{
return(ustage1dat.Value.ToString());
}
else
{
return(null);
}
}
public string GetUconvdate(string accountno)
{
DateTime?uconvdate = null;
using (GoldmineEntities context = new GoldmineEntities())
{
uconvdate = (from c in context.CONTACT2.Where(c => c.ACCOUNTNO == accountno) select c.UCONVDATE).FirstOrDefault();
}
if (uconvdate != null)
{
return(uconvdate.Value.ToString());
}
else
{
return(null);
}
}
public List <CONTSUPPChangeTracking_Result> GetContSuppChangeTrackingResults(int _contsuppStartVersionNumber)
{
List <CONTSUPPChangeTracking_Result> results = new List <CONTSUPPChangeTracking_Result>();
try
{
using (GoldmineEntities context = new GoldmineEntities())
{
results = (from c in context.CONTSUPPChangeTracking(_contsuppStartVersionNumber) select c).ToList();
}
if (results.Count > 0)
{
_versionNumberProcess.UpdateContsuppVersionNumber(int.Parse(results.OrderByDescending(x => x.SYS_CHANGE_VERSION).FirstOrDefault().SYS_CHANGE_VERSION.Value.ToString()));
}
}
catch (Exception ex) { _exceptionLogging.LogException(ex); }
return(results);
}
public string GetTranslatedCaseOwner(string accountno)
{
string translatedCaseOwner = string.Empty;
string goldmineValue = string.Empty;
using (GoldmineEntities context = new GoldmineEntities())
{
goldmineValue = (from c in context.CONTACT2.Where(c => c.ACCOUNTNO == accountno) select c.UBCASEOWN).FirstOrDefault();
}
if (!string.IsNullOrEmpty(goldmineValue))
{
using (RiftEntities context = new RiftEntities())
{
string riftValue = (from r in context.WorkFlowUsernameLookups.Where(r => r.GoldMineUsername == goldmineValue) select r.WorkFlowUsername).FirstOrDefault();
if (!string.IsNullOrEmpty(riftValue))
{
translatedCaseOwner = riftValue.Split('@')[0];
}
}
}
return(translatedCaseOwner);
}