public Boolean InsertarReporte(ErrorReport errorReport)
{
try
{
TEC_QA_CRMEntities db = new TEC_QA_CRMEntities();
//var insert = db.ErrorReports.Add(errorReport);
var insert = db.sp_Insert_Error_Report(errorReport.UserID, errorReport.SaleID, errorReport.ProductName, errorReport.ErrorDate, errorReport.ContactMail, errorReport.ErrorDescription);
//db.SaveChanges();
if (insert != null)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
return(false);
}
}
public List <Contact_View> Contactos(int usuarioID)
{
TEC_QA_CRMEntities db = new TEC_QA_CRMEntities();
return(db.Contact_View.Where(x => x.ClientID == usuarioID).ToList());
}
public List <getRelationatedProducts_Result> getRelationatedProducts(int pUserID)
{
TEC_QA_CRMEntities db = new TEC_QA_CRMEntities();
return(db.getRelationatedProducts(pUserID).ToList <getRelationatedProducts_Result>());
}
public List <getTrainings_Result> getMisEntrenamientos(int pUserID)
{
TEC_QA_CRMEntities db = new TEC_QA_CRMEntities();
return(db.getTrainings(pUserID).ToList <getTrainings_Result>());
}
public List <ErrorReport> ReportesdeUsuario(int usuarioID)
{
TEC_QA_CRMEntities db = new TEC_QA_CRMEntities();
return(db.ErrorReports.Where(x => x.UserID == usuarioID).ToList());
}
public List <Sale> VentasdeUsuario(int usuarioID)
{
TEC_QA_CRMEntities db = new TEC_QA_CRMEntities();
return(db.Sales.Where(x => x.ClientID == usuarioID).ToList());
}