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;
}
