private object[] Take(GLVoucherListDetailEntity gLVoucherListDetailEntity)
{
return(new object[]
{
"@RefDetailID", gLVoucherListDetailEntity.RefDetailId,
"@RefID", gLVoucherListDetailEntity.RefId,
"@DetailRefType", gLVoucherListDetailEntity.DetailRefType,
"@DetailID", gLVoucherListDetailEntity.DetailId,
"@SortOrder", gLVoucherListDetailEntity.SortOrder,
"@EntryType", gLVoucherListDetailEntity.EntryType,
"@DetailRefID", gLVoucherListDetailEntity.DetailRefId,
});
}
public List <GLVoucherListDetailEntity> GLVoucherListDetails(List <GLVoucherListDetail> details, string refid)
{
List <GLVoucherListDetailEntity> lstDetailEntities = new List <GLVoucherListDetailEntity>();
foreach (var result in details)
{
var newresult = new GLVoucherListDetailEntity();
newresult.RefDetailId = result.RefDetailID.ToString();
newresult.RefId = refid;
newresult.DetailRefType = result.DetailRefType ?? 0;
newresult.DetailId = result.DetailID.ToString();
newresult.SortOrder = result.SortOrder ?? 0;
newresult.EntryType = result.EntryType ?? 0;
//newresult.DetailRefId = result.DetailRefID;
lstDetailEntities.Add(newresult);
}
return(lstDetailEntities);
}
public string InsertGLVoucherListDetail(GLVoucherListDetailEntity glVoucherListDetail)
{
const string sql = @"uspInsert_GLVoucherListDetail";
return(Db.Insert(sql, true, Take(glVoucherListDetail)));
}
