public List <ExpBankVoucher> GetTransactionInfoForSearch()
{
using (_context)
{
var Data = (from t in _context.EXP_BankVoucher.AsEnumerable()
join b in _context.Sys_Bank on t.BankID equals b.BankID into Banks
from b in Banks.DefaultIfEmpty()
join br in _context.Sys_Branch on t.BranchID equals br.BranchID into Branches
from br in Branches.DefaultIfEmpty()
join ci in _context.EXP_CI on(t.CIID == null?null:t.CIID) equals ci.CIID into CIs
from ci in CIs.DefaultIfEmpty()
orderby t.BVID descending
select new ExpBankVoucher
{
BVID = t.BVID,
RefBVNo = t.RefBVNo,
BVDate = (Convert.ToDateTime(t.BVDate)).ToString("dd'/'MM'/'yyyy"),
BVType = (t.BVType == "DR"? "Debit": "Credit"),
BankID = t.BankID,
BankName = b == null?null:b.BankName,
BranchID = t.BranchID,
BranchName = br == null ? null : br.BranchName,
ACNo = t.ACNo,
ACName = t.ACName,
Remarks = t.Remarks,
RecordStatus = DalCommon.ReturnRecordStatus(t.RecordStatus)
}).ToList();
return(Data);
}
}
public List <EXPBankVoucherDtl> GetVouchertemList(long BVID)
{
using (var context = new BLC_DEVEntities())
{
var Data = (from vd in context.EXP_BankVoucherDtl
where vd.BVID == BVID
join c in context.Sys_Currency on(vd.Currency == null ? null : vd.Currency) equals c.CurrencyID into Currencies
from c in Currencies.DefaultIfEmpty()
join ec in context.Sys_Currency on(vd.ExchangeCurrency == null ? null : vd.ExchangeCurrency) equals ec.CurrencyID into ExchangeCurrencies
from ec in ExchangeCurrencies.DefaultIfEmpty()
join th in context.Sys_TransHead on(vd.TransHead == null ? null : vd.TransHead) equals th.HeadID into TransHeads
from th in TransHeads.DefaultIfEmpty()
join ci in context.EXP_CI on(vd.CIID == null ? null : vd.CIID) equals ci.CIID into CIs
from ci in CIs.DefaultIfEmpty()
select new EXPBankVoucherDtl
{
BVDTLID = vd.BVDTLID,
TransSL = vd.TransSL,
Narration = vd.Narration,
HeadID = vd.TransHead,
HeadName = (th == null ? null : th.HeadName),
BVDRAmt = vd.BVDRAmt,
BVCRAmt = vd.BVCRAmt,
CurrencyName = (c == null ? null : c.CurrencyName),
ExchangeCurrencyName = (ec == null ? null : ec.CurrencyName),
ExchangeRate = vd.ExchangeRate,
ExchangeAmount = vd.ExchangeAmount,
CIID = vd.CIID,
CIRefNo = ci == null ? "" : ci.CIRefNo
}).ToList();
return(Data);
}
}
static void CheckBeforePatch(ComprobanteIngreso oldData, ComprobanteIngreso request,
DALProxy proxy,
int idUsuario,
string operacion)
{
oldData.ValidateAndThrowHttpError(operacion);
CIs ces= new CIs(){Nuevo=request, Viejo=oldData};
CIsValidator ev = new CIsValidator();
ev.ValidateAndThrowHttpError(ces,operacion);
oldData.CheckSucursal(proxy,idUsuario);
oldData.CheckPeriodo(proxy);
request.PopulateWith(oldData);
}
private static void CheckOldAndNew(ComprobanteIngreso oldData, ComprobanteIngreso request,
DALProxy proxy,
int idUsuario)
{
oldData.ValidateAndThrowHttpError(Operaciones.Update);
var cis= new CIs(){Nuevo=request, Viejo=oldData};
CIsValidator ev = new CIsValidator();
ev.ValidateAndThrowHttpError(cis,Operaciones.Update);
oldData.CheckSucursal(proxy, idUsuario);
var data = new ComprobanteIngreso();
data.PopulateWith(oldData);
if( request.Fecha!=default(DateTime) && request.Fecha!=data.Fecha)
{
data.Fecha=request.Fecha;
data.Periodo= data.Fecha.ObtenerPeriodo();
}
data.CheckPeriodo(proxy);
//if(request.IdTercero!=default(int) && request.IdTercero!=data.IdTercero)
//{
// data.IdTercero=request.IdTercero;
// data.CheckTercero(proxy);
//}
if(!request.Descripcion.IsNullOrEmpty() && request.Descripcion!=data.Descripcion)
data.Descripcion=request.Descripcion;
bool checkcg=false;
if(request.IdCuentaReceptora!=default(int) && request.IdCuentaReceptora!=data.IdCuentaReceptora)
{
data.IdCuentaReceptora= request.IdCuentaReceptora;
checkcg=true;
}
if((request.IdTerceroReceptora.HasValue && request.IdTerceroReceptora.Value!=default(int)) &&
( !data.IdTerceroReceptora.HasValue ||
(data.IdTerceroReceptora.HasValue && request.IdTerceroReceptora.Value!=data.IdTerceroReceptora.Value)))
{
data.IdTerceroReceptora= request.IdTerceroReceptora;
checkcg=true;
}
if(checkcg){
var pi = data.CheckUsuarioReceptora(proxy, idUsuario);
data.CodigoItem= pi.Codigo;
data.NombreItem = pi.Nombre;
}
request.PopulateWith(data);
}
