public static BoObject DaoUtilsLib_getObject(string lNameObject)
{
SqlConnection lConex = new SqlConnection();
using (lConex = Dao_SqlConnection(lConex))
{
var lObject = new BoObject();
try
{
var lCommand = new SqlCommand
{
CommandText = "spr_getObjectByName",
CommandTimeout = 30,
CommandType = CommandType.StoredProcedure,
Connection = lConex
};
lCommand.Parameters.Add(new SqlParameter("NameObject", lNameObject));
var lReader = lCommand.ExecuteReader();
if (lReader.HasRows)
{
while (lReader.Read())
{
lObject.LIdObject = Convert.ToInt32(lReader["IdObject"].ToString());
lObject.LNameObject = lReader["NameObject"].ToString();
lObject.LActive = Convert.ToBoolean(lReader["flActive"].ToString());
}
}
Dao_CloseSqlconnection(lConex);
return(lObject);
}
catch (Exception e)
{
lObject = new BoObject
{
LException = e.Message,
LMessageDao = BoErrors.MsgErrorGetSql
};
if (e.InnerException != null)
{
lObject.LInnerException = e.InnerException.ToString();
}
Dao_CloseSqlconnection(lConex);
return(lObject);
}
}
}
public List <BoInvoiceItem> bll_ChangeOrderItemToInvoiceItem(List <BoOrderItem> lListOrderItem, BoObject lObjectInvoice)
{
var lListInvoiceItem = new List <BoInvoiceItem>();
lListOrderItem?.ForEach(x =>
{
var lInvoiceItem = new BoInvoiceItem
{
LProduct = new BoProduct(),
LQuantity = x.LQty,
LValueProd = x.LValueProduct,
LValueDesc = x.LValueDesc,
LValueSupplier = x.LValueSupplier,
LValueTaxes = x.LValueTaxes,
LObject = lObjectInvoice
};
lInvoiceItem.LProduct = this.LiProduct.bll_GetProductByCode(x.LProduct.LCdProduct);
lListInvoiceItem.Add(lInvoiceItem);
});
return(lListInvoiceItem);
}
