public List <IDTPErrorLog> GetIDTPErrorLog(DateTime?logDate) { IEnumerable <IDTPErrorLog> resultSet; using (var context = new IDTPDBContext()) { var LogDate = new SqlParameter("@LogDate", logDate); resultSet = context.IDTPErrorLogs.FromSqlRaw <IDTPErrorLog>("usp_GetIDTPErrorLog", LogDate); } return(resultSet.ToList()); }
public List <IDTPAppErrorLog> GetIDTPAppErrorLog(DateTime?logDate) { IEnumerable <IDTPAppErrorLog> applogs = null; using (var context = new IDTPDBContext()) { var LogDate = new SqlParameter("@LogDate", logDate); applogs = context.IDTPAppErrorLogs.FromSqlRaw <IDTPAppErrorLog>("dbo.usp_GetIDTPAppErrorLog @LogDate", new SqlParameter("@LogDate", LogDate)); } return(applogs.ToList()); }
public DataTable GetDataWithSProc(string sprocName) { DataTable data = new DataTable(); using (var context = new IDTPDBContext()) { SqlConnection sqlConnection = new SqlConnection(context.Database.GetDbConnection().ConnectionString); SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sprocName, sqlConnection); sqlDataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure; sqlConnection.Open(); sqlDataAdapter.Fill(data); sqlConnection.Close(); sqlDataAdapter.Dispose(); } return(data); }
public virtual T GetSingle(Func <T, bool> where, params System.Linq.Expressions.Expression <Func <T, object> >[] navigationProperties) { if (_context == null) { _context = new IDTPDBContext(); } T item = null; IQueryable <T> dbQuery = _context.Set <T>(); //Apply eager loading foreach (Expression <Func <T, object> > navigationProperty in navigationProperties) { dbQuery = dbQuery.Include <T, object>(navigationProperty); } item = dbQuery .AsNoTracking() //Don't track any changes for the selected item .FirstOrDefault(where); //Apply where clause return(item); }
public virtual IQueryable <T> GetAll(params System.Linq.Expressions.Expression <Func <T, object> >[] navigationProperties) { if (_context == null) { _context = new IDTPDBContext(); } IQueryable <T> list; IQueryable <T> dbQuery = _context.Set <T>(); //Apply eager loading foreach (Expression <Func <T, object> > navigationProperty in navigationProperties) { dbQuery = dbQuery.Include <T, object>(navigationProperty); } list = dbQuery .AsNoTracking() .AsQueryable <T>(); return(list); }
public void LogIDTPError(int?UserID, int errorNumber, string errorContext, string errorMessage, string errorTimeStamp) { if (_isVerbose.ToLower(CultureInfo.CurrentCulture) == "true") { using (var context = new IDTPDBContext()) { SqlParameter param1 = new SqlParameter("@UserID", UserID); SqlParameter param2 = new SqlParameter("@ErrorNumber", errorNumber); SqlParameter param3 = new SqlParameter("@ErrorContex", errorContext); SqlParameter param4 = new SqlParameter("@errorMessage", errorMessage); SqlParameter param5 = new SqlParameter("@errorTimeStamp ", errorTimeStamp); context.Database.ExecuteSqlRaw("usp_LogIDTPError @UserID, @ErrorNumber, @ErrorContex, @errorMessage, @errorTimeStamp", param1, param2, param3, param4, param5); } } }
public DataTable GetDataUsingSprocWithParam(string sprocName, string prameterName, string parameterValue, SqlDbType sqlDbType) { DataTable data = new DataTable(); using (var context = new IDTPDBContext()) { SqlConnection sqlConnection = new SqlConnection(context.Database.GetDbConnection().ConnectionString); SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sprocName, sqlConnection); sqlDataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure; sqlDataAdapter.SelectCommand.CommandTimeout = 120; /*SqlParameter SqlParameter = new SqlParameter(prameterName, sqlDbType); * SqlParameter.Value = parameterValue; * sqlDataAdapter.SelectCommand.Parameters.Add(SqlParameter); */ sqlDataAdapter.SelectCommand.Parameters.AddWithValue(prameterName, Int32.Parse(parameterValue)); sqlConnection.Open(); sqlDataAdapter.Fill(data); sqlConnection.Close(); sqlDataAdapter.Dispose(); } return(data); }
//Logging error message from android app for the IDTP system public void LogAppErrorInfo(int UserID, string ErrorMessage, string ErrorStackTrace, int ErrorType, DateTime ErrorTimeStamp, string ErrorDeviceInfo) { if (_isVerbose.ToLower(CultureInfo.CurrentCulture) == "true") { using (var context = new IDTPDBContext()) { SqlParameter param1 = new SqlParameter("@UserID", UserID); SqlParameter param2 = new SqlParameter("@ErrorMessage", ErrorMessage); SqlParameter param3 = new SqlParameter("@ErrorStackTrace", ErrorStackTrace); SqlParameter param4 = new SqlParameter("@ErrorType", ErrorType); SqlParameter param5 = new SqlParameter("@ErrorTimeStamp", ErrorTimeStamp); SqlParameter param6 = new SqlParameter("@ErrorDeviceInfo", ErrorDeviceInfo); context.Database.ExecuteSqlRaw("dbo.usp_LogAndroidAppError @UserID, @ErrorMessage, @ErrorStackTrace,@ErrorType,@ErrorTimeStamp,@ErrorDeviceInfo", param1, param2, param3, param4, param5, param6); //context.Database.ExecuteSqlCommand("usp_Update_BI_Dashboard_Data"); } } }
public void LogUserActivity(int?UserID, string activity, System.Uri pageUrl) { if (_isVerbose.ToLower(CultureInfo.CurrentCulture) == "true") { try { using (var context = new IDTPDBContext()) { SqlParameter param1 = new SqlParameter("@UserId", UserID); SqlParameter param2 = new SqlParameter("@Activity", activity); SqlParameter param3 = new SqlParameter("@PageUrl", pageUrl); context.Database.ExecuteSqlRaw("usp_LogUserActivity @UserId, @Activity, @PageUrl", param1, param2, param3); } } catch (WebException) { throw; } } }
public GenericDataRepository() { _context = new IDTPDBContext(); }
public SuspenseTransactionRepository() { _context = new IDTPDBContext(); }