public void StoreCallBackResponse(CallBackResponse callBack)
{
try
{
using (DigitalInvoiceEntities context = new DigitalInvoiceEntities())
{
context.CallBackReceived.Add(new CallBackReceived()
{
IdCallBack = Guid.NewGuid().ToString(),
clave = callBack.clave,
fecha = callBack.fecha,
indEstado = callBack.indEstado,
respuestaXml = callBack.respuestaXml,
callBackUrl = callBack.callbackUrl,
fechaCallBack = DateTime.Now
});
context.SaveChanges();
}
}
catch (Exception ex)
{
ex.Message.ToString();
}
}
public void UpdateRequestRecord(RequestRecord requestRecord)
{
RequestRecord record;
try
{
using (DigitalInvoiceEntities context = new DigitalInvoiceEntities())
{
record = (from rr in context.RequestRecord
where rr.clave.Equals(requestRecord.clave) && rr.callBackReceived == false
select rr).FirstOrDefault();
if (record != null)
{
record.docDatetime = requestRecord.docDatetime;
record.indState = requestRecord.indState;
record.responseXML = requestRecord.responseXML;
record.callBacakDatetime = requestRecord.callBacakDatetime;
record.callBackReceived = true;
context.SaveChanges();
}
}
}
catch (Exception ex)
{
}
}
public bool DeleteAccount(string id)
{
bool response = false;
Account account = null;
try
{
using (DigitalInvoiceEntities context = new DigitalInvoiceEntities())
{
account = (from a in context.Account
where a.accountId.Equals(id)
select a).FirstOrDefault();
if (account != null)
{
account.enabled = false;
context.SaveChanges();
}
else
{
throw new Exception("Account profile can't be deleted");
}
}
}
catch (Exception ex)
{
throw ex;
}
return(response);
}
public Account GetAccountById(string id)
{
Account account = null;
try
{
using (DigitalInvoiceEntities context = new DigitalInvoiceEntities())
{
account = (from a in context.Account
where a.accountId.Equals(id) && a.enabled == true
select a).FirstOrDefault();
}
}
catch (Exception ex)
{
throw ex;
}
return(account);
}
public Account UpsertAccount(Account account)
{
Account selectedAccount = null;
try
{
using (DigitalInvoiceEntities context = new DigitalInvoiceEntities())
{
selectedAccount = (from a in context.Account
where a.accountId.Equals(account.accountId)
select a).FirstOrDefault();
if (selectedAccount == null)
{
account.accountId = Guid.NewGuid().ToString();
account.enabled = true;
context.Account.Add(account);
selectedAccount = account;
}
else
{
selectedAccount.certificate = account.certificate;
selectedAccount.certificatePIN = account.certificatePIN;
selectedAccount.certificateExt = account.certificateExt;
selectedAccount.userATV = account.userATV;
selectedAccount.passwordATV = account.passwordATV;
selectedAccount.certificateName = account.certificateName;
selectedAccount.logoImage = account.logoImage;
}
context.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
return(selectedAccount);
}
public static void RegisterCallBackFailToDataBase(string request)
{
try
{
using (DigitalInvoiceEntities context = new DigitalInvoiceEntities())
{
LogRequest logRequest = new LogRequest()
{
Id = Guid.NewGuid().ToString(),
Request = request,
LogDate = DateTime.Now
};
context.LogRequest.Add(logRequest);
context.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public List <GeneralObject> GetDocumentTypes()
{
List <GeneralObject> DocumentTypeList = new List <GeneralObject>();
try
{
using (DigitalInvoiceEntities context = new DigitalInvoiceEntities())
{
DocumentTypeList = (from d in context.DocumentTypeAuthExon
select new GeneralObject()
{
code = d.CodeId,
name = d.DocumentType
}).ToList();
}
}
catch (Exception ex)
{
ex.Message.ToString();
}
return(DocumentTypeList);
}
public List <GeneralObject> GetTaxes()
{
List <GeneralObject> taxList = new List <GeneralObject>();
try
{
using (DigitalInvoiceEntities context = new DigitalInvoiceEntities())
{
taxList = (from t in context.Taxes
select new GeneralObject()
{
code = t.CodeId,
name = t.TaxName
}).ToList();
}
}
catch (Exception ex)
{
ex.Message.ToString();
}
return(taxList);
}
public void RegisterRequestRecord(string clave, string accountId, string state)
{
try
{
RequestRecord newRecord = new RequestRecord()
{
clave = clave,
accountId = accountId,
requestState = state,
sentDatetime = DateTime.Now
};
using (DigitalInvoiceEntities context = new DigitalInvoiceEntities())
{
context.RequestRecord.Add(newRecord);
context.SaveChanges();
}
}
catch (Exception ex)
{
ex.Message.ToString();
}
}
public List <GeneralResponseObject> GetMeasureUnit()
{
List <GeneralResponseObject> MeasureUnitList = new List <GeneralResponseObject>();
try
{
using (DigitalInvoiceEntities context = new DigitalInvoiceEntities())
{
MeasureUnitList = (from mu in context.MeasureUnit
select new GeneralResponseObject()
{
id = mu.IdMeasureUnit,
code = mu.Symbol,
description = mu.Description
}).ToList();
}
}
catch (Exception ex)
{
ex.Message.ToString();
}
return(MeasureUnitList);
}
public List <GeneralObject> GetLocation(LocationDistribution locationType, int Provincia = 1, int Canton = 1, int Distrito = 1)
{
List <GeneralObject> location = new List <GeneralObject>();
try
{
switch (locationType)
{
case LocationDistribution.Provincia:
{
using (DigitalInvoiceEntities context = new DigitalInvoiceEntities())
{
location = (from l in context.Location
select new GeneralObject()
{
code = l.IdProvincia,
name = l.Provincia
}).Distinct().ToList();
}
}
break;
case LocationDistribution.Canton:
{
using (DigitalInvoiceEntities context = new DigitalInvoiceEntities())
{
location = (from l in context.Location
where l.IdProvincia == Provincia
select new GeneralObject()
{
code = l.IdCanton,
name = l.Canton
}).Distinct().ToList();
}
}
break;
case LocationDistribution.Distrito:
{
using (DigitalInvoiceEntities context = new DigitalInvoiceEntities())
{
location = (from l in context.Location
where l.IdProvincia == Provincia && l.IdCanton == Canton
select new GeneralObject()
{
code = l.IdDistrito,
name = l.Distrito
}).Distinct().ToList();
}
}
break;
case LocationDistribution.Barrio:
{
using (DigitalInvoiceEntities context = new DigitalInvoiceEntities())
{
location = (from l in context.Location
where l.IdProvincia == Provincia && l.IdCanton == Canton && l.IdDistrito == Distrito
select new GeneralObject()
{
code = l.IdBarrio,
name = l.Barrio
}).Distinct().ToList();
}
}
break;
}
}
catch (Exception ex)
{
ex.Message.ToString();
}
return(location);
}
