public ReturnDataToKendo ReturnKendoData <T>(string userName, string source,
SqlParameter[] procedureParametersList, string storeProcedureName)
{
var newTradeView = new ReturnDataToKendo(_context);
var getTableDetail = new GetTableDetail();
var tableDetail = getTableDetail.ReturnTableDetailData(source, userName);
var columnList = "new (" + getTableDetail.ReturnColumnListCommaSeparated(tableDetail.ToList()) + ")";
if (columnList.Equals("new ()"))
{
return(newTradeView);
}
var rep = new Repository.GenericRepository <ReturnDataToKendo>();
var linqQuery =
rep.ExecuteStoredProcedure(storeProcedureName, procedureParametersList).Select(columnList);
newTradeView.Total = linqQuery.Count();
newTradeView.TradeList = linqQuery;
return(newTradeView);
}
public ReturnDataToKendo ReturnKendoData <T>(KendoGridItems item, string userName, string source,
SqlParameter[] procedureParametersList, string storeProcedureName)
{
var newTradeView = new ReturnDataToKendo(_context);
var getTableDetail = new GetTableDetail();
var tableDetail = getTableDetail.ReturnTableDetailData(source, userName);
var columnList = "new (" + getTableDetail.ReturnColumnListCommaSeparated(tableDetail.ToList()) + ")";
var rep = new Repository.GenericRepository <ReturnDataToKendo>();
var linqQuery = rep.ExecuteStoredProcedure(storeProcedureName, procedureParametersList).Select(columnList);
newTradeView.Total = linqQuery.Count();
newTradeView.TradeList = item.Sort != null
? linqQuery.Skip(item.Skip).Take(item.Take).OrderBy(ReturnOrderByString(item.Sort))
: linqQuery.Skip(item.Skip).Take(item.Take);
return(newTradeView);
}
public ReturnDataToKendo ReturnKendoDataAll <T>(string userName, string source,
SqlParameter[] procedureParametersList, string storeProcedureName)
{
if (string.IsNullOrWhiteSpace(storeProcedureName))
{
return(null);
}
var newTradeView = new ReturnDataToKendo(_context);
var getTableDetail = new GetTableDetail();
//var tableDetail = getTableDetail.ReturnTableDetailData(source, userName);
var rep = new Repository.GenericRepository <ReturnDataToKendo>();
var linqQuery = rep.ExecuteStoredProcedure(storeProcedureName,
procedureParametersList);
newTradeView.Total = linqQuery.Count();
newTradeView.TradeList = linqQuery;
return(newTradeView);
}
public string ReturnPassword(string username)
{
var returnValue = "";
var parameters = new[]
{
new SqlParameter
{
ParameterName = "@user_name",
Value = username
}
};
var TdmsDataAccess = new Repository.GenericRepository <usp_returnUserbyUserName_Result>();
var userLogin = TdmsDataAccess.ExecuteStoredProcedure("usp_returnUserbyUserName",
parameters);
foreach (var item in userLogin)
{
returnValue = item.psw;
}
return(returnValue);
}