public CustomAuthorization(params string[] roles) { connString = ConfigurationManager.ConnectionStrings["SQLConString"].ToString(); dbFamily = new DBFamily(); dbFamilyResult = dbFamily.GetQueryBuilder(DbFamilyConstants.MSSQL); this.allowedRoles = roles; }
internal int Save_UserPassword(string UserEmail, string userCode, string UsrPwd, string strToken) { IDBManager dbManager = CommonConnection.Connectionstring(); int results = 0; DataSet ds = new DataSet(); try { dbManager.Open(); dbManager.CreateParameters(4); dbManager.AddParameters(0, "UserEmail", UserEmail, ParameterDirection.Input); dbManager.AddParameters(1, "userCode", userCode, ParameterDirection.Input); dbManager.AddParameters(2, "UsrPwd", UsrPwd, ParameterDirection.Input); dbManager.AddParameters(3, "strToken", strToken, ParameterDirection.Input); string spCall = Helper.Ins.GetSPCall(dbManager.Parameters, "Save_userPassword"); if (ConfigurationSettings.AppSettings["DataB"] == "SQL") { ds = dbManager.ExecuteDataSet(CommandType.StoredProcedure, "Save_userPassword"); results = Convert.ToInt16(ds.Tables[0].Rows[0][0]); } return(results); } catch (Exception ex) { throw ex; } finally { dbManager.Dispose(); } }
public void Delete(object obj) { _user = (User)System.Web.HttpContext.Current.Session[Constant.session.User]; _dbmgr = new DBManager(_user.plantDBStr); _dbmgr.ConnectionString = _user.plantDBStr; DeleteDisposition(obj, _dbmgr); }
public object Fetch(object obj) { int id; string type; //type of object passed string objtype = obj.GetType().ToString(); //get object type if (objtype == "System.String") { string[] strTemp = ((string)obj).Split(new char[] { '|' }); //if the object type is a string then extract the id and type id = Convert.ToInt32(strTemp[0]); type = strTemp[1]; } else { id = ((Disposition)obj).disp_id; type = "all"; //object is a cable and get all information } _disp = new Disposition(); //create new instance of object _user = (User)System.Web.HttpContext.Current.Session[Constant.session.User]; _dbmgr = new DBManager(_user.plantDBStr); _dbmgr.ConnectionString = _user.plantDBStr; switch (type) { case "facompcabdisp": FetchFACompCabList(id, _dbmgr); return _disp.facompcablist; case "all": FetchDisposition(id, _dbmgr); FetchFACompCabList(id, _dbmgr); return _disp; } return _disp; }
internal int SendResetPswdlink(string UserCode, string UserEmail, string EmlTmpl, string token, DateTimeOffset tokenDt) { IDBManager dbManager = CommonConnection.Connectionstring(); int MsgId = 0; DataSet ds = new DataSet(); try { const string dtFormat = "yyyy-MM-dd HH:mm:ss.fffffff zzz"; string dtString2 = tokenDt.ToString(dtFormat, CultureInfo.InvariantCulture); dbManager.Open(); dbManager.CreateParameters(5); dbManager.AddParameters(0, "UserCode", UserCode, ParameterDirection.Input); dbManager.AddParameters(1, "UserEmail", UserEmail, ParameterDirection.Input); dbManager.AddParameters(2, "EmlTmpl", EmlTmpl, ParameterDirection.Input); dbManager.AddParameters(3, "token", token, ParameterDirection.Input); dbManager.AddParameters(4, "tokenDt", dtString2, ParameterDirection.Input); string spCall = Helper.Ins.GetSPCall(dbManager.Parameters, "SendResetPswdlink"); ds = dbManager.ExecuteDataSet(CommandType.StoredProcedure, "SendResetPswdlink"); MsgId = Convert.ToInt16(ds.Tables[0].Rows[0][0]); return(MsgId); } catch (Exception ex) { throw ex; } finally { dbManager.Dispose(); } }
private int[] AssignParameters(OracleCommand com, IDBManager dbmanager, int outputLength) { try{ int[] outputIndexes = new int[outputLength]; if (dbmanager.Parameters != null) { int index = 0; int length = 0; foreach (IDataParameter parameter in dbmanager.Parameters) { com.Parameters.AddWithValue(parameter.ParameterName, parameter.Value); com.Parameters[parameter.ParameterName].Direction = parameter.Direction; if (parameter.Direction == ParameterDirection.Output || parameter.Direction == ParameterDirection.InputOutput) { outputIndexes[length] = index; length++; } index++; } } return(outputIndexes); } catch (Exception ex) { throw ex; } }
public VisitManagerController(//ILogger<VisitManagerController> logger, IMapper mapper, ICMSDataHelper cmsDataHelper, IOptions <AppOptionsConfiguration> cmsOptions, IDBManager dBManager, IOptions <DatabaseOptions> connectionString) { _logger = NullLogger <VisitManagerController> .Instance;//logger; _businessLogic = new BusinessLogic(mapper, cmsDataHelper, cmsOptions.Value, dBManager, connectionString.Value); }
private ForumManager() { //forums = new List<Forum>(); forumIdCounter = 1000; MM = MessageManager.Instance(); DBforumMan = new DBforumManager(); /* * DBforumMan.add(new Forum("Sports3", 1)); * DBforumMan.add(new Forum("News3", 2)); * DBforumMan.add(new Forum("Science3", 3)); * * var obj = DBforumMan.getObj(4); * obj.CreateSubForum("Politic"); * obj.CreateSubForum("Economy"); * obj.CreateSubForum("Weather"); * * var obj2 = DBforumMan.getObj(1); * obj2.CreateSubForum("Soccer"); * obj2.CreateSubForum("Basketball"); * obj2.CreateSubForum("Weather"); * * DBforumMan.update(); */ }
public void Remove(ref HttpContext cctx, ref IDBManager dbmgr, ref Contact contact) { try { m_Rwlock.EnterWriteLock(); if (m_cachekey != "" && cctx != null && cctx.Cache[m_cachekey] != null) { var currentData = ((Contact[])cctx.Cache[m_cachekey]).ToList(); Contact[] contactarray = (Contact[])cctx.Cache[m_cachekey]; for (int i = 0; i < currentData.Count; ++i) { if (contactarray[i].Id == contact.Id) { currentData.Remove(contactarray[i]); break; } } cctx.Cache[m_cachekey] = currentData.ToArray(); } dbmgr.Remove(ref contact); SetCacheLastWriteTime(ref cctx, ref dbmgr); } finally { m_Rwlock.ExitWriteLock(); } }
public BaseManager() { //FillTodaysCalculationDetails(); DBManager = AutofacContainer.Container.Resolve <IDBManager>(); mapperConfiguration = new MapperConfiguration(config => config.CreateMap <CalculationDayDB, CalculationDay>()); }
public void Add(ref HttpContext cctx, ref IDBManager dbmgr, ref Contact contact) { try { m_Rwlock.EnterWriteLock(); int newId = 0; if (m_cachekey != "" && cctx != null && cctx.Cache[m_cachekey] != null) { var currentData = ((Contact[])cctx.Cache[m_cachekey]).ToList(); newId = 1; if (currentData.Count > 0) { Contact[] contactarray = (Contact[])cctx.Cache[m_cachekey]; newId = contactarray[currentData.Count - 1].Id + 1; } contact.Id = newId; currentData.Add(contact); cctx.Cache[m_cachekey] = currentData.ToArray(); } dbmgr.Add(ref contact); SetCacheLastWriteTime(ref cctx, ref dbmgr); } finally { m_Rwlock.ExitWriteLock(); } //catch (Exception ex) //{ // dbmgr.GetException(ref ex); //} }
public static IDBManager CreateDBManager(DbManagerConfig config) { IDBManager result = null; Type dbtype = Type.GetType(config.Type); if (dbtype == null) { throw new CacheDBException("{0} dbmanager type notfound!", config.Type); } Type formaterType = Type.GetType(config.Formater); if (formaterType == null) { throw new CacheDBException("{0} formater notfound!", config.Formater); } result = (IDBManager)Activator.CreateInstance(dbtype); result.Formater = (IFormater)Activator.CreateInstance(formaterType); foreach (PropertyConfig p in config.Properties) { PropertyInfo pi = dbtype.GetProperty(p.Name, BindingFlags.Public | BindingFlags.Instance); if (pi != null && pi.CanWrite) { try { pi.SetValue(result, Convert.ChangeType(p.Value, pi.PropertyType), null); } catch { } } } return(result); }
// fetches object and object items // user has option of passing object itself OR a string with id and type delimited by '|' public object Fetch(object obj) { int id = ((CableBlock)obj).comp_id; // create new object and database connection _cabBlock = new CableBlock(); _user = (User)System.Web.HttpContext.Current.Session[Constant.session.User]; _dbmgr = new DBManager(_user.plantDBStr); _dbmgr.ConnectionString = _user.plantDBStr; try { _dbmgr.Open(); FetchComponent(id, _dbmgr); FetchCableBlock(id, _dbmgr); FetchVertexList(id, _dbmgr); return _cabBlock; } catch (Exception ex) { throw ex; } finally { _dbmgr.Dispose(); } }
internal DataSet Fetch_UserInfo(string Mode, string usercode) { IDBManager dbManager = CommonConnection.Connectionstring(); DataSet ds = new DataSet(); try { dbManager.Open(); dbManager.CreateParameters(2); dbManager.AddParameters(0, "Mode", Mode, ParameterDirection.Input); dbManager.AddParameters(1, "UserCode", usercode, ParameterDirection.Input); string spCall = Helper.Ins.GetSPCall(dbManager.Parameters, "Fetch_Users"); if (ConfigurationSettings.AppSettings["DataB"] == "SQL") { ds = dbManager.ExecuteDataSet(CommandType.StoredProcedure, "Fetch_Users"); } return(ds); } catch (Exception ex) { throw ex; } finally { dbManager.Dispose(); } }
internal DataSet Open_LoginInfo(string UserCode, string Password, string param) { IDBManager dbManager = CommonConnection.Connectionstring(); DataSet ds = new DataSet(); try { dbManager.Open(); dbManager.CreateParameters(3); dbManager.AddParameters(0, "LoginUserCode", UserCode, ParameterDirection.Input); dbManager.AddParameters(1, "UserPassword", Password, ParameterDirection.Input); dbManager.AddParameters(2, "Param", param, ParameterDirection.Input); string spCall = Helper.Ins.GetSPCall(dbManager.Parameters, "Fetch_LoginInfo"); if (ConfigurationSettings.AppSettings["DataB"] == "SQL") { ds = dbManager.ExecuteDataSet(CommandType.StoredProcedure, "Fetch_LoginInfo"); } return(ds); } catch (Exception ex) { throw ex; } finally { dbManager.Dispose(); } }
public void SetCache() { var ctx = HttpContext.Current; string connstring = "Data Source=contactsvc18db.database.windows.net;Initial Catalog=ContactSvc18_db;Integrated Security=False;User ID=vikashviksit;Password=Gyanvi17;Connect Timeout=30;Encrypt=True;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"; //string connstringlocal = "Data Source = (localdb)\v11.0; Initial Catalog = AzureStorageEmulatorDb40; Integrated Security = True; Connect Timeout = 30; Encrypt = False; TrustServerCertificate = False; ApplicationIntent = ReadWrite; MultiSubnetFailover = False"; if (ctx != null) { if (ctx.Cache[DataMgrKey] == null) { ctx.Cache[DataMgrKey] = new ContactDataManager(CacheKey, LastWriteKey); } if (ctx.Cache[DbMgrKey] == null) { ctx.Cache[DbMgrKey] = new ContactDBManager(connstring); //TBD set connection string; } m_cdatamgr = (IDataManager)ctx.Cache[DataMgrKey]; m_cdbmgr = (IDBManager)ctx.Cache[DbMgrKey]; } else { m_cdatamgr = new ContactDataManager(CacheKey, LastWriteKey); m_cdbmgr = new ContactDBManager(connstring);; } }
internal string Validate(string param, string Mode) { IDBManager dbManager = CommonConnection.Connectionstring(); string results = ""; DataSet ds = new DataSet(); try { dbManager.Open(); dbManager.CreateParameters(2); dbManager.AddParameters(0, "params", param, ParameterDirection.Input); dbManager.AddParameters(1, "MODE", Mode, ParameterDirection.Input); string spCall = Helper.Ins.GetSPCall(dbManager.Parameters, "Validations"); if (ConfigurationSettings.AppSettings["DataB"] == "SQL") { ds = dbManager.ExecuteDataSet(CommandType.StoredProcedure, "Validations"); results = Convert.ToString(ds.Tables[0].Rows[0][0]); } return(results); } catch (Exception ex) { throw ex; } finally { dbManager.Dispose(); } }
public object Fetch(object obj) { int id; id = ((FireRoom)obj).rm_id; // initialize _fireroom = new FireRoom(); _user = (User)System.Web.HttpContext.Current.Session[Constant.session.User]; _dbmgr = new DBManager(_user.plantDBStr); _dbmgr.ConnectionString = _user.plantDBStr; try { _dbmgr.Open(); // fetch object information FetchFireRoom(id, _dbmgr); FetchComponentList(id, _dbmgr); FetchCableList(id, _dbmgr); FetchRouteList(id, _dbmgr); } catch (Exception ex) { throw ex; } finally { _dbmgr.Dispose(); } return _fireroom; }
public void Delete(object obj) { _user = (User)System.Web.HttpContext.Current.Session[Constant.session.User]; _dbmgr = new DBManager(_user.plantDBStr); _dbmgr.ConnectionString = _user.plantDBStr; string type = obj.GetType().ToString(); switch (type) { case "FRIAS.Common.Entity.FireArea": DeleteFireArea(obj, _dbmgr); break; case "FRIAS.Common.Entity.FACompDisp": DeleteCompDisp(obj, _dbmgr); break; case "FRIAS.Common.Entity.FACabDisp": DeleteCabDisp(obj, _dbmgr); break; case "FRIAS.Common.Entity.FAVFDR": DeleteVFDR(obj, _dbmgr); break; case "FRIAS.Common.Entity.FADOC": DeleteDocument(obj, _dbmgr); break; } }
public CommonDal() { if (dbManager == null) { dbManager = new DBManager(); } }
internal void LogError(string errorNameSpace, string eventName, string errorStack, string errorByUser) { IDBManager dbManager = CommonConnection.Connectionstring(); try { dbManager.Open(); dbManager.CreateParameters(4); if (ConfigurationSettings.AppSettings["DataB"] == "SQL") { dbManager.AddParameters(0, "@ErrorNameSpace", errorNameSpace, ParameterDirection.Input); dbManager.AddParameters(1, "@ErrorEvent", eventName, ParameterDirection.Input); dbManager.AddParameters(2, "@ErrorStack", errorStack, ParameterDirection.Input); dbManager.AddParameters(3, "@ErrorByUser", errorByUser, ParameterDirection.Input); dbManager.ExecuteNonQuery(CommandType.StoredProcedure, "SAVE_ERROR_LOG"); } } catch (Exception ex) { throw ex; } finally { dbManager.Dispose(); } }
public void Delete(object obj) { // get connection _user = (User)System.Web.HttpContext.Current.Session[Constant.session.User]; _dbmgr = new DBManager(_user.plantDBStr); _dbmgr.ConnectionString = _user.plantDBStr; string type = obj.GetType().ToString(); // delete from database switch (type) { case "FRIAS.Common.Entity.FireZone": DeleteFireZone(obj, _dbmgr); break; case "FRIAS.Common.Entity.FZProtection": DeleteProtection(obj, _dbmgr); break; case "FRIAS.Common.Entity.FZIgnition": DeleteIgnition(obj, _dbmgr); break; case "FRIAS.Common.Entity.FZIgnitionImpact": DeleteIgnitionImpact(obj, _dbmgr); break; } }
public ReadWriteUnitOfWork(IDBManager dbManager, IRepositoryProvider repoProvider) : base(dbManager, repoProvider) { if (_transaction == null) { _transaction = new TransactionScope(); } }
public object[] ExecuteOracleNonQuery(IDBManager dbmanager, CommandType commandType, string commandText) { try{ string strconn = dbmanager.ConnectionString; Con = new OracleConnection(strconn); Cmd = new OracleCommand(); Con.Open(); Cmd.Connection = Con; Cmd.CommandText = commandText; Cmd.CommandType = commandType; int length = 0; foreach (IDataParameter parameter in dbmanager.Parameters) { if (parameter.Direction == ParameterDirection.Output || parameter.Direction == ParameterDirection.InputOutput || parameter.Direction == ParameterDirection.Input) { length++; } } int[] outputIndexes = AssignParameters(Cmd, dbmanager, length); Cmd.ExecuteNonQuery(); object[] returnObj = new object[length]; for (int i = 0; i < outputIndexes.Length; i++) { returnObj[i] = Cmd.Parameters[Convert.ToInt32(outputIndexes[i])].Value; } Cmd.Parameters.Clear(); Con.Close(); return(returnObj); } catch (Exception ex) { throw ex; } }
public ProformaDal() { if (dbManager == null) { dbManager = new DBManager(); } }
// deletes given object or object item public void Delete(object obj) { // create database connection _user = (User)System.Web.HttpContext.Current.Session[Constant.session.User]; _dbmgr = new DBManager(_user.plantDBStr); _dbmgr.ConnectionString = _user.plantDBStr; // determine type of object string type = obj.GetType().ToString(); switch (type) { case "FRIAS.Common.Entity.Component": DeleteComponent(obj, _dbmgr); break; case "FRIAS.Common.Entity.CompDwg": DeleteDrawing(obj, _dbmgr); break; case "FRIAS.Common.Entity.Subcomp": DeleteSubcomp(obj, _dbmgr); break; case "FRIAS.Common.Entity.CompPwr": DeletePower(obj, _dbmgr); break; case "FRIAS.Common.Entity.CompIntlk": DeleteInterlock(obj, _dbmgr); break; case "FRIAS.Common.Entity.CompCab": DeleteCable(obj, _dbmgr); break; } }
public ComponentManager() { loadAssembly(); _user = (User)System.Web.HttpContext.Current.Session[Constant.session.User]; _dbmgr = new DBManager(_user.plantDBStr); _dbmgr.ConnectionString = _user.plantDBStr; }
//TODO include DB Manager that reads Names from DataBase public UserIdetifier(ISecondaryInputProvider inputProvider, IDBManager dbManager) { _inputProvider = inputProvider; _dbManager = dbManager; Console.WriteLine("Enter you User Name"); Console.WriteLine("0: Create New User"); //DBManager return List<string> userNames; UserNames = userNames for (int i = 1; i <= UserNames.Count; i++) { Console.WriteLine($"{i}: {UserNames[i - 1]}"); } int intChoiceResult = ReturnUsersChoice(); if (intChoiceResult == 0) { _userName = ReturnNewUserName(); while (UserNames.Contains(_userName)) { _userName = ReturnNewUserName(); } Log.Information($"Created new user, name is {_userName}, in {nameof(UserIdetifier)}"); //DB Creates new entity with This name in DB } else { _userName = UserNames[intChoiceResult - 1]; } }
internal int Save_NewApps(int appid, string AppName, string AppURL, string Status, string mode) { IDBManager dbManager = CommonConnection.Connectionstring(); int results = 0; DataSet ds = new DataSet(); try { dbManager.Open(); dbManager.CreateParameters(5); dbManager.AddParameters(0, "AppId", appid, ParameterDirection.Input); dbManager.AddParameters(1, "AppName", AppName, ParameterDirection.Input); dbManager.AddParameters(2, "AppURL", AppURL, ParameterDirection.Input); dbManager.AddParameters(3, "Status", Status, ParameterDirection.Input); dbManager.AddParameters(4, "mode", mode, ParameterDirection.Input); string spCall = Helper.Ins.GetSPCall(dbManager.Parameters, "Save_Apps"); if (ConfigurationSettings.AppSettings["DataB"] == "SQL") { ds = dbManager.ExecuteDataSet(CommandType.StoredProcedure, "Save_Apps"); results = Convert.ToInt16(ds.Tables[0].Rows[0][0]); } return(results); } catch (Exception ex) { throw ex; } finally { dbManager.Dispose(); } }
internal DataSet Fetch_LoginDtl(string UserCode, string Password, ref string sReturnMsg) { IDBManager dbManager = CommonConnection.Connectionstring(); DataSet ds = new DataSet(); try { dbManager.Open(); dbManager.CreateParameters(3); dbManager.AddParameters(0, "LoginUserCode", UserCode, ParameterDirection.Input); dbManager.AddParameters(1, "UserPassword", Password, ParameterDirection.Input); dbManager.AddParameters(2, "@RetMsg", string.Empty, ParameterDirection.Output, 100); string spCall = Helper.Ins.GetSPCall(dbManager.Parameters, "Fetch_LoginDtl"); if (ConfigurationSettings.AppSettings["DataB"] == "SQL") { ds = dbManager.ExecuteDataSet(CommandType.StoredProcedure, "Fetch_LoginDtl"); } if (dbManager.Parameters[2] != null) { sReturnMsg = dbManager.Parameters[2].Value.ToString(); } return(ds); } catch (Exception ex) { throw ex; } finally { dbManager.Dispose(); } }
private void Authenticate(Object source, EventArgs e) { HttpContext context = (source as HttpApplication).Context; IDBManager auth = DependencyResolver.Current.GetService <IDBManager>(); auth.Start(context, DependencyResolver.Current.GetService <IStoreDB>()); }
public void DeltaControllerBadParameter(IDBManager database) { Assert.Throws <ArgumentNullException>(() => { IDeltaController deltaController2 = new DeltaController(database); } ); }
public void Delete(object obj) { // create database connection _dbmgr = new DBManager(DBHelper.getProvider(Config.getValue("DBStr", ""))); _dbmgr.ConnectionString = Config.getValue("DBStr", ""); DeleteUser(obj, _dbmgr); }
public void FileContentControllerBadParameter(IDBManager database) { Assert.Throws <ArgumentNullException>(() => { IFileContentController fileContentController2 = new FileContentController(database); } ); }
public object Fetch(object obj) { int id; string type; // type of object passed string objtype = obj.GetType().ToString(); // get object type if (objtype == "System.String") { string[] strTemp = ((string)obj).Split(new char[] { '|' }); // if the object type is a string then extract the id and type id = Convert.ToInt32(strTemp[0]); type = strTemp[1]; } else { id = ((Route)obj).node_id; type = "all"; // object is a cable and get all information } _route = new Route(); // create new instance of object _user = (User)System.Web.HttpContext.Current.Session[Constant.session.User]; _dbmgr = new DBManager(_user.plantDBStr); _dbmgr.ConnectionString = _user.plantDBStr; try { _dbmgr.Open(); switch (type) { case "routeloca": FetchRoutelocaList(id, _dbmgr); return _route.routelocalist; case "routelocadwg": FetchRoutelocaList(id, _dbmgr); FetchDrawingList(_route.routelocalist, _dbmgr); return _route.drawinglist; case "bdendpoint": FetchBDEndpointList(id, _dbmgr); return _route.bdendpointlist; case "cable": FetchCableList(id, _dbmgr); return _route.cablelist; default: FetchRoute(id, _dbmgr); FetchRoutelocaList(id, _dbmgr); FetchBDEndpointList(id, _dbmgr); FetchDrawingList(_route.routelocalist, _dbmgr); FetchCableList(id, _dbmgr); return _route; } } catch (Exception ex) { throw ex; } finally { _dbmgr.Dispose(); } }
public object Fetch(object obj) { int id; string type; // type of object passed string objtype = obj.GetType().ToString(); // get object type if (objtype == "System.String") { string[] strTemp = ((string)obj).Split(new char[] { '|' }); // if object type is a string then extract the id and type id = Convert.ToInt32(strTemp[0]); type = strTemp[1]; } else { id = ((Power)obj).power_id; type = "all"; // object is drawing and get all information } _power = new Power(); _user = (User)System.Web.HttpContext.Current.Session[Constant.session.User]; _dbmgr = new DBManager(_user.plantDBStr); _dbmgr.ConnectionString = _user.plantDBStr; try { _dbmgr.Open(); switch (type) { case "component": FetchComponentList(id, _dbmgr); return _power.componentlist; case "psload": FetchPSLoadList(id, _dbmgr); return _power.psloadlist; case "psbkrcab": FetchPSBkrCabList(id, _dbmgr); return _power.psbkrcablist; case "cabroutelist": FetchCabRoutelist(id, _dbmgr); return _power.cabroutelist; default: FetchPower(id, _dbmgr); FetchComponentList(id, _dbmgr); FetchPSLoadList(id, _dbmgr); return _power; } } catch (Exception ex) { throw ex; } finally { _dbmgr.Dispose(); } }
public override void OnActionExecuting(ActionExecutingContext filterContext) { IDBManager manager = DependencyResolver.Current.GetService <IDBManager>(); if (manager.IsAuthentication && !manager.User.IsActive) { filterContext.Result = new RedirectResult(string.Format("/Account/Confirm?login={0}&e_mail={1}", manager.User.Login, manager.User.E_Mail)); } }
// deletes given object or object item public void Delete(object obj) { // create database connection _user = (User)System.Web.HttpContext.Current.Session[Constant.session.User]; _dbmgr = new DBManager(_user.plantDBStr); _dbmgr.ConnectionString = _user.plantDBStr; DeleteRA(obj, _dbmgr); }
public PersAccounantAddOperationProcessor(ICategoryManager categoryManagerParam, ISourceManager sourceManagerParam, ICurrencyManager currencyManagerParam, IDBManager dbManagerParam) : base(dbManagerParam) { _categoryManager = categoryManagerParam; _sourceManager = sourceManagerParam; _currencyManager = currencyManagerParam; }
private static DataTable GetFilterInfoTable(int i_FilterID, IDBManager i_DBManager) { DataTable m_TmpTable = new DataTable("Filter"); string m_FilterCMD = string.Format("{0} {1}) order by [FieldName]", CMD_ACCESS_Filter, i_FilterID); i_DBManager.FillDataTable(m_TmpTable, m_FilterCMD); return(m_TmpTable); }
public void Delete(object obj) { // get connection _user = (User)System.Web.HttpContext.Current.Session[Constant.session.User]; _dbmgr = new DBManager(_user.plantDBStr); _dbmgr.ConnectionString = _user.plantDBStr; // delete from database DeleteFireRoom(obj, _dbmgr); }
public BusinessLogic(IMapper mapper, ICMSDataHelper cmsDataHelper, AppOptionsConfiguration cmsOptions, IDBManager dBManager, DatabaseOptions connectionString) { _cmsDataHelper = cmsDataHelper; _cmsOptions = cmsOptions; _mapper = mapper; _cmsDataHelper.ConnectToCMS(_mapper.Map <AppOptions>(_cmsOptions)); _dBManager = dBManager; _dBManager.SetDBConfiguration(connectionString.DefaultConnection); }
public IDBManager GetDBManager(DataType type) { IDBManager dbManager = mongoDBMng.GetDBManager(type); if (dbManager == null) { dbManager = xmlDBMng.GetDBManager(type); } return(dbManager); }
// fetches object and object items // user has option of passing object itself OR a string with id and type delimited by '|' public object Fetch(object obj) { int id; string type; string objtype = obj.GetType().ToString(); if (objtype == "System.String") { string[] strTemp = ((string)obj).Split(new char[] { '|' }); id = Convert.ToInt32(strTemp[0]); type = strTemp[1]; } else { id = ((Component)obj).comp_id; type = "all"; } // create new object and database connection _comp = new Component(); _user = (User)System.Web.HttpContext.Current.Session[Constant.session.User]; _dbmgr = new DBManager(_user.plantDBStr); _dbmgr.ConnectionString = _user.plantDBStr; try { _dbmgr.Open(); // determine type switch (type) { case "ra": FetchRAList(id, _dbmgr); return _comp.ralist; default: FetchComponent(id, _dbmgr); FetchFACompDispList(id, _dbmgr); FetchRAList(id, _dbmgr); return _comp; } } catch (Exception ex) { throw ex; } finally { _dbmgr.Dispose(); } }
public void Delete(object obj) { _user = (User)System.Web.HttpContext.Current.Session[Constant.session.User]; _dbmgr = new DBManager(_user.plantDBStr); _dbmgr.ConnectionString = _user.plantDBStr; string type = obj.GetType().ToString(); switch (type) { case "FRIAS.Common.Entity.Drawing": DeleteDrawing(obj, _dbmgr); break; } }
// function determines if a given column exists in database // returns -1 if column does not exist otherwise returns ordinal of existing column public static bool ColumnExists(string colName, IDBManager dbmgr) { bool exists = true; try { // get ordinal of given column from database int col = dbmgr.DataReader.GetOrdinal(colName); } catch { // if ordinal does not exist exception occurs exists = false; } return exists; }
public object Fetch(object obj) { int id; string type; //type of object passed string objtype = obj.GetType().ToString(); //get object type if (objtype == "System.String") { string[] strTemp = ((string)obj).Split(new char[] { '|' }); //if the object type is a string then extract the id and type id = Convert.ToInt32(strTemp[0]); type = strTemp[1]; } else { id = ((Document)obj).doc_id; type = "all"; //object is document and get all information } _document = new Document(); _user = (User)System.Web.HttpContext.Current.Session[Constant.session.User]; _dbmgr = new DBManager(_user.plantDBStr); _dbmgr.ConnectionString = _user.plantDBStr; try { _dbmgr.Open(); switch (type) { case "firearea": FetchFAList(id, _dbmgr); return _document.falist; default: FetchDocument(id, _dbmgr); FetchFAList(id, _dbmgr); return _document; } } catch (Exception ex) { throw ex; } finally { _dbmgr.Dispose(); } }
public object Fetch(object obj) { int id; string type; // type of object passed string objtype = obj.GetType().ToString(); // get object type if (objtype == "System.String") { string[] strTemp = ((string)obj).Split(new char[] { '|' }); // if the object type is a string then extract the id and type id = Convert.ToInt32(strTemp[0]); type = strTemp[1]; } else { id = ((Cable)obj).cable_id; type = "all"; // object is a cable and get all information } _cable = new Cable(); _user = (User)System.Web.HttpContext.Current.Session[Constant.session.User]; _dbmgr = new DBManager(_user.plantDBStr); _dbmgr.ConnectionString = _user.plantDBStr; switch (type) { case "component": FetchComponentList(id, _dbmgr); return _cable.componentlist; case "drawing": FetchDrawingList(id, _dbmgr); return _cable.drawinglist; case "routechg": FetchRoutechgList(id, _dbmgr); return _cable.routechglist; case "all": FetchCable(id, _dbmgr); FetchComponentList(id, _dbmgr); FetchDrawingList(id, _dbmgr); FetchRoutechgList(id, _dbmgr); FetchRouteList(id, _dbmgr); FetchCRDPowerList(id, _dbmgr); return _cable; } return _cable; }
// fetches user information public object Fetch(object obj) { string type; string objtype = obj.GetType().ToString(); if (objtype == "System.String") type = "userlist"; else type = "user"; _user = new User(); _dbmgr = new DBManager(DBHelper.getProvider(Config.getValue("DBStr", ""))); _dbmgr.ConnectionString = Config.getValue("DBStr", ""); try { _dbmgr.Open(); switch (type) { case "userlist": FetchAccessList(_dbmgr); return _accesslist; default: FetchUser(obj, _dbmgr); //if (_user.initial != null) // FetchPlantInfo(_user, _dbmgr); return _user; } } catch (Exception ex) { throw ex; } finally { _dbmgr.Dispose(); } }
static void Main(string[] args) { int threads = 0; DbManagerConfig config = new DbManagerConfig(); config.Type = "CacheDB.Net.implement.LevelDBManager,CacheDB.Net"; // config.Formater = "CacheDB.Net.implement.JsnoFormater, CacheDB.Net"; //config.Formater = "CacheDB.Net.implement.ProtobufFormater, CacheDB.Net"; //config.Formater = "CacheDB.Net.MsgpacketFormater.Formater,CacheDB.Net.MsgpacketFormater"; config.Formater = "CacheDB.Net.BinaryFormater.Formater,CacheDB.Net.BinaryFormater"; config.Properties.Add(new PropertyConfig { Name = "Path", Value = "test" }); db = Factory.CreateDBManager(config); db.Open(); START: Console.Clear(); Console.WriteLine("1.set test"); Console.WriteLine("2.get test"); string value = Console.ReadLine(); int menuid; int.TryParse(value, out menuid); if (menuid != 1 && menuid != 2) { goto START; } INPUT_THREADS: Console.Write("test thread(1-50):"); value = Console.ReadLine(); int.TryParse(value, out threads); if (threads < 1 || threads > 50) goto INPUT_THREADS; if (menuid == 1) { for (int i = 0; i < threads; i++) { System.Threading.ThreadPool.QueueUserWorkItem(WriteTest); } } else { Console.WriteLine("get key loading ..."); IEnumerator<KeyValuePair<byte[], byte[]>> items = db.DataBase.GetEnumerator(); while (items.MoveNext()) { keys.Add(Encoding.UTF8.GetString(items.Current.Key)); } Console.WriteLine("get testing ..."); for (int i = 0; i < threads; i++) { System.Threading.ThreadPool.QueueUserWorkItem(ReadTest); } } while (true) { Console.ForegroundColor = ConsoleColor.Green; if (menuid == 1) { Console.Write("set testing ..."); } else { Console.Write("get testing ..."); } System.Threading.Thread.Sleep(1000); Console.WriteLine(" [{0}/{1}]", mCount - mLastCount, mCount); mLastCount = mCount; } }
private void UpdateVFDR(object obj, IDBManager dbmgr) { FAVFDR item = (FAVFDR)obj; try { dbmgr.Open(); dbmgr.CreateParameters(6); dbmgr.AddParameters(0, "@fa_id", item.fa_id); dbmgr.AddParameters(1, "@vfdr_id", item.vfdr_id); dbmgr.AddParameters(2, "@vfdr", item.vfdr); dbmgr.AddParameters(3, "@vfdr_disp", item.vfdr_disp); dbmgr.AddParameters(4, "@status", item.status); dbmgr.AddParameters(5, "@fre_ref", item.fre_ref); dbmgr.ExecuteNonQuery(CommandType.StoredProcedure, "dbo.FAVFDR_u"); } catch (Exception ex) { throw ex; } finally { dbmgr.Dispose(); } }
private void UpdateStatus(IDBManager dbmgr, FireArea item, int statustype_id, string user_id, DateTime status_date) { if ((user_id == "N/A") || (user_id == "")) { // delete status dbmgr.CreateParameters(2); dbmgr.AddParameters(0, "@fa_id", item.fa_id); dbmgr.AddParameters(1, "@statustype_id", statustype_id); dbmgr.ExecuteNonQuery(CommandType.StoredProcedure, "dbo.FASTATUS_d"); } else { // update status dbmgr.CreateParameters(4); dbmgr.AddParameters(0, "@fa_id", item.fa_id); dbmgr.AddParameters(1, "@statustype_id", statustype_id); dbmgr.AddParameters(2, "@user_id", user_id); if (status_date == Convert.ToDateTime(null)) // set date to null dbmgr.AddParameters(3, "@status_date", null); else // update date dbmgr.AddParameters(3, "@status_date", status_date); dbmgr.ExecuteNonQuery(CommandType.StoredProcedure, "dbo.FASTATUS_u"); } }
private void UpdatePG(object obj, IDBManager dbmgr) { FAPG item = (FAPG)obj; try { dbmgr.Open(); dbmgr.CreateParameters(4); dbmgr.AddParameters(0, "@fa_id", item.fa_id); dbmgr.AddParameters(1, "@pg", item.pg); dbmgr.AddParameters(2, "@method", item.method); dbmgr.AddParameters(3, "@comment", item.comment); dbmgr.ExecuteNonQuery(CommandType.StoredProcedure, "dbo.FAPG_u"); } catch (Exception ex) { throw ex; } finally { dbmgr.Dispose(); } }
private void UpdateFireArea(object obj, IDBManager dbmgr) { FireArea item = (FireArea)obj; System.Data.Common.DbParameter param; try { dbmgr.Open(); dbmgr.BeginTransaction(); // check to see if new object if (item.fa_id == 0) { dbmgr.CreateParameters(3); dbmgr.AddParameters(0, "@id", 0, true); dbmgr.AddParameters(1, "@fa", item.fa); dbmgr.AddParameters(2, "@fa_desc", item.fa_desc); dbmgr.ExecuteNonQuery(CommandType.StoredProcedure, "dbo.FALIST_i"); // get item id param = (System.Data.Common.DbParameter)dbmgr.Parameters.GetValue(0); item.fa_id = (int)param.Value; } // otherwise update existing object else { dbmgr.CreateParameters(14); dbmgr.AddParameters(0, "@fa_id", item.fa_id); dbmgr.AddParameters(1, "@fa", item.fa); dbmgr.AddParameters(2, "@fa_desc", item.fa_desc); dbmgr.AddParameters(3, "@bldg", item.bldg); dbmgr.AddParameters(4, "@elev", item.elev); dbmgr.AddParameters(5, "@ssd_path", item.ssd_path); dbmgr.AddParameters(6, "@req", item.req); dbmgr.AddParameters(7, "@supp", item.supp); dbmgr.AddParameters(8, "@det", item.det); dbmgr.AddParameters(9, "@comment", item.comment); dbmgr.AddParameters(10, "@dwg_id", item.dwg_id); dbmgr.AddParameters(11, "@dwg_rev", item.dwg_rev); dbmgr.AddParameters(12, "@risk_summary", item.risk_summary); dbmgr.AddParameters(13, "@reg_basis", item.reg_basis); dbmgr.ExecuteNonQuery(CommandType.StoredProcedure, "dbo.FALIST_u"); // execute the stored procedure //update status UpdateStatus(dbmgr, item, 1, item.prep_by, item.prep_date); UpdateStatus(dbmgr, item, 5, item.chkd_by, item.chkd_date); } dbmgr.CommitTransaction(); } catch (Exception ex) { dbmgr.RollbackTransaction(); throw ex; } finally { dbmgr.Dispose(); } }
private void UpdateDocument(object obj, IDBManager dbmgr) { FADoc item = (FADoc)obj; try { dbmgr.Open(); dbmgr.CreateParameters(3); dbmgr.AddParameters(0, "@fa_id", item.fa_id); dbmgr.AddParameters(1, "@doc_id", item.doc_id); dbmgr.AddParameters(2, "@comment", item.comment); dbmgr.ExecuteNonQuery(CommandType.StoredProcedure, "dbo.FADOC_u"); } catch (Exception ex) { throw ex; } finally { dbmgr.Dispose(); } }
private void UpdateCompDisp(object obj, IDBManager dbmgr) { FACompDisp item = (FACompDisp)obj; // cast object to proper item type try { dbmgr.Open(); dbmgr.CreateParameters(5); // create required paramaters dbmgr.AddParameters(0, "@fa_id", item.fa_id); dbmgr.AddParameters(1, "@comp_id", item.comp_id); dbmgr.AddParameters(2, "@old_disp_id", item.old_disp_id); dbmgr.AddParameters(3, "@disp_id", item.disp_id); dbmgr.AddParameters(4, "@status", item.status); dbmgr.ExecuteNonQuery(CommandType.StoredProcedure, "dbo.FACOMPDISP_u"); // execute stored procedure } catch (Exception ex) { throw ex; } finally { dbmgr.Dispose(); } }
private void FetchVFDRList(int id, IDBManager dbmgr) { string qryString = "SELECT f.FA, v.* FROM FAVFDR v INNER JOIN FALIST f ON f.FA_ID = v.FA_ID WHERE v.FA_ID = @fa_id ORDER BY v.VFDR_ID"; FAVFDR item = new FAVFDR(); ArrayList list = new ArrayList(); PropertyInfo[] p = item.GetType().GetProperties(); dbmgr.CreateParameters(1); dbmgr.AddParameters(0, "@fa_id", id); dbmgr.ExecuteReader(CommandType.Text, qryString); while (dbmgr.DataReader.Read()) { item = new FAVFDR(); item = (FAVFDR)FetchObject(item, p, dbmgr); list.Add(item); } dbmgr.CloseReader(); _firearea.vfdrlist = list; }
private void FetchProtectionList(int id, IDBManager dbmgr) { string qryString = "SELECT * FROM viewFZPROTECTION WHERE FA_ID = @fa_id ORDER BY FZ, SYS_CATEGORY, SYS_NAME"; FZProtection item = new FZProtection(); ArrayList list = new ArrayList(); PropertyInfo[] p = item.GetType().GetProperties(); dbmgr.CreateParameters(1); dbmgr.AddParameters(0, "@fa_id", id); dbmgr.ExecuteReader(CommandType.Text, qryString); while (dbmgr.DataReader.Read()) { item = new FZProtection(); item = (FZProtection)FetchObject(item, p, dbmgr); list.Add(item); } dbmgr.CloseReader(); _firearea.protectionlist = list; }
public DBDao(DBEstrategiaPersistenceManager estrategia) { this.dbManager = estrategia.DBManager; this.estrategia = estrategia; }
public object Fetch(object obj) { int fa_id; int comp_id = 0; string type; // type of object passed string objtype = obj.GetType().ToString(); // get object type if (objtype == "System.String") { string[] strTemp = ((string)obj).Split(new char[] { '|' }); // if the object type is a string then extract the id and type fa_id = Convert.ToInt32(strTemp[0]); type = strTemp[1]; comp_id = Convert.ToInt32(strTemp[2]); } else { fa_id = ((FireArea)obj).fa_id; type = "all"; // object is a cable and get all information } _firearea = new FireArea(); _user = (User)System.Web.HttpContext.Current.Session[Constant.session.User]; _dbmgr = new DBManager(_user.plantDBStr); _dbmgr.ConnectionString = _user.plantDBStr; try { _dbmgr.Open(); switch (type) { //case "facompdisp": // FetchCompDispList(fa_id, _dbmgr); // return _firearea.compdisplist; case "facabdisp": FetchCabDispList(fa_id, comp_id, _dbmgr); break; //return _firearea.cabdisplist; case "facompinfo": FetchCabDispList(fa_id, comp_id, _dbmgr); break; //return _firearea; case "faB3Table": FetchFireArea(fa_id, _dbmgr); FetchVFDRList(fa_id, _dbmgr); FetchPGList(fa_id, _dbmgr); FetchGENdocList(fa_id, _dbmgr); FetchEEdocList(fa_id, _dbmgr); FetchLICdocList(fa_id, _dbmgr); FetchIgnitionList(fa_id, _dbmgr); FetchProtectionList(fa_id, _dbmgr); break; //return _firearea; case "all": FetchFireArea(fa_id, _dbmgr); FetchCompDispList(fa_id, _dbmgr); FetchCascPowerList("SSD", fa_id, _dbmgr); FetchCascIntlkList("SSD", fa_id, _dbmgr); break; //return _firearea; } } catch (Exception ex) { throw ex; } finally { _dbmgr.Dispose(); } return _firearea; }