public BackOfficeCompany(DataRow rowFromALTable)
{
this.Code = rowFromALTable.Field <int>("AxCompanyCode");
this.Company = rowFromALTable.Field <string>("AxCompanyName").ToUpper();
this.ConfigurationName = rowFromALTable.Field <string>("ConfigurationName");
this.PermissionGroup = rowFromALTable.Field <int>("PermissionGroup");
this.IsLive = rowFromALTable.Field <bool>("LiveInAx");
this.CustomerInMore = rowFromALTable.Field <string>("CustomerInMore");
object date = rowFromALTable["LiveDate"];
this.ServerType = (EServerType)rowFromALTable.Field <int>("ServerType");
switch (this.ServerType)
{
case EServerType.STANDARD:
this.BackOfficeType = EBackOfficeType.AX;
break;
case EServerType.INDIAN:
this.BackOfficeType = EBackOfficeType.AX;
break;
case EServerType.TURKEY:
this.BackOfficeType = EBackOfficeType.AX;
break;
case EServerType.DPC:
this.BackOfficeType = EBackOfficeType.DPC;
break;
default:
throw new Exception("What the hell?");
}
this.LiveDate = (date == System.DBNull.Value ?
new DateTime(1970, 1, 1) :
rowFromALTable.Field <DateTime>("LiveDate"));
}
public CreditCard RetrievePaidByUsSingleCreditCardByRecId(long recId, string dataAreaID, EBackOfficeType backOffice)
{
List <SqlParameter> SqlParameters = new List <SqlParameter>();
SqlParameters.Add(new SqlParameter("dataAreaID", dataAreaID));
string AxDBStatement = ";WITH cte AS( ";
AxDBStatement += " SELECT *,ROW_NUMBER() OVER (PARTITION BY CREDITCARDNO ORDER BY RECID asc) AS rn ";
AxDBStatement += " FROM ";
AxDBStatement += " (select EXPIRYDATE, CREDITCARDNO, CVV, RECID, COMPANYID, AMS_BANKNUMBER ,EMPLID, DATAAREAID, AMS_EmpGovernmentId, status ";
AxDBStatement += " from [ELI_AMSALEMCREDITCARD] ";
AxDBStatement += " where DATAAREAID = @AxCompany ";
AxDBStatement += " and RECID = @RECID) ";
AxDBStatement += " d) ";
AxDBStatement += " select * FROM cte where rn=1 ";
List <SqlParameter> AxDBSqlParameters = new List <SqlParameter>();
AxDBSqlParameters.Add(new SqlParameter("RECID", recId));
var AxDBresults = DataBaseAccess.PerformQueryToCompany(false, AxDBStatement, AxDBSqlParameters, dataAreaID);
CreditCard toReturn = null;
if (AxDBresults != null && AxDBresults.Rows.Count > 0)
{
toReturn = this.ParseSinglePaidByUsCard(AxDBresults.Rows[0]);
}
return(toReturn);
}
public List <CreditCard> RetrievePaidByUsCreditCardsByManagerClockId(int AgentClockId, bool filterd, string dataAreaID, EBackOfficeType backOffice, bool withVAN = false)
{
string listManagerBanks = "25,26"; //an example - mockup
string AxDBStatement = ";WITH cte AS( ";
AxDBStatement += " SELECT *,ROW_NUMBER() OVER (PARTITION BY CREDITCARDNO ORDER BY RECID asc) AS rn ";
AxDBStatement += " FROM ";
AxDBStatement += " (select EXPIRYDATE, CREDITCARDNO, CVV, RECID, COMPANYID, AMS_BANKNUMBER ,EMPLID, DATAAREAID, AMS_EmpGovernmentId,status ";
AxDBStatement += " from [ELI_AMSALEMCREDITCARD] ";
AxDBStatement += " where DATAAREAID = @AxCompany and status=1 ";
if (!string.IsNullOrEmpty(listManagerBanks))
{
AxDBStatement += " and AMS_BANKNUMBER in ('25','26') ";
}
AxDBStatement += " ) d) ";
AxDBStatement += " SELECT * from cte ";
AxDBStatement += " where rn=1 ";
List <SqlParameter> AxDBSqlParameters = new List <SqlParameter>();
AxDBSqlParameters.Add(new SqlParameter("listManagerBanks", listManagerBanks));
var AxDBresults = DataBaseAccess.PerformQueryToCompany((dataAreaID == "%"), AxDBStatement, AxDBSqlParameters, dataAreaID);
var toReturn = new List <CreditCard>();
if (AxDBresults != null)
{
foreach (DataRow row in AxDBresults.Rows)
{
var toAdd = ParseSinglePaidByUsCard(row);
toReturn.Add(toAdd);
}
;
}
return(toReturn);
}
