protected List <T> ExecuteStoreQuery <T>(string strQuery, List <SqlParameter> listDbParameters = null, string strFunctionName = "")
{
this.PrintDetailsInTrace(strQuery, listDbParameters, strFunctionName);
using (cricketEntities objCommonEntity = new cricketEntities())
{
var lstResult = objCommonEntity.Database.SqlQuery <T>(strQuery, (listDbParameters != null) ? listDbParameters.ToArray() : null).ToList();
return(lstResult);
}
}
protected void ExecuteFunction(string strQuery, List <ObjectParameter> listDbParameters = null, string strFunctionName = "", string strDB = "")
{
this.PrintObjectParaDetailsInTrace(strQuery, listDbParameters, strFunctionName);
using (cricketEntities objCommonEntity = new cricketEntities())
{
objCommonEntity.Database.ExecuteSqlCommand(strQuery, (listDbParameters != null) ? listDbParameters.ToArray() : null);
}
}
protected int ExecuteStoreCommand(string strQuery, List <SqlParameter> listDbParameters = null, string strFunctionName = "", char charReqLastId = 'N')
{
this.PrintDetailsInTrace(strQuery, listDbParameters, strFunctionName);
using (cricketEntities objCommonEntity = new cricketEntities())
{
int intLastInsertedId = 0;
if (charReqLastId == 'Y')
{
strQuery += "; DECLARE @intLastld int; SET @intLastld = SCOPE_IDENTITY(); SELECT @intlastld; ";
if (listDbParameters == null)
{
listDbParameters = new List <SqlParameter>();
}
intLastInsertedId = objCommonEntity.Database.SqlQuery <int>(strQuery, (listDbParameters != null) ? listDbParameters.ToArray() : null).FirstOrDefault();
HttpContext.Current.Trace.Warn("\n " + strFunctionName + " => Lastlnsertedld " + intLastInsertedId.ToString());
}
else
{
objCommonEntity.Database.ExecuteSqlCommand(strQuery, (listDbParameters != null) ? listDbParameters.ToArray() : null); //SqlQuery<int>(strQuery, (listDbParameters != null) ? listDbParameters.ToArray() : null);
}
return(intLastInsertedId);
}
}
