public virtual List <ChildObject> _SelectListInternal(DbManagerProxy manager , Int64?ID , on_action loading, on_action loaded ) { ChildObject _obj = null; try { MapResultSet[] sets = new MapResultSet[1]; List <ChildObject> objs = new List <ChildObject>(); sets[0] = new MapResultSet(typeof(ChildObject), objs); manager .SetSpCommand("spChildObject_SelectDetail" , manager.Parameter("@ID", ID) , manager.Parameter("@LangID", ModelUserContext.CurrentLanguage) ) .ExecuteResultSet(sets); foreach (var obj in objs) { _obj = obj; obj.m_CS = m_CS; if (loading != null) { loading(obj); } _SetupLoad(manager, obj); if (loaded != null) { loaded(obj); } } return(objs); } catch (DataException e) { throw DbModelException.Create(_obj, e); } }
public virtual List <SampleTypeForDiagnosisLookup> _SelectListInternal(DbManagerProxy manager , Int32?intHACode , on_action loading, on_action loaded ) { SampleTypeForDiagnosisLookup _obj = null; try { MapResultSet[] sets = new MapResultSet[1]; List <SampleTypeForDiagnosisLookup> objs = new List <SampleTypeForDiagnosisLookup>(); sets[0] = new MapResultSet(typeof(SampleTypeForDiagnosisLookup), objs); manager .SetSpCommand("spSampleTypeForDiagnosis_SelectLookup" , manager.Parameter("@intHACode", intHACode) , manager.Parameter("@LangID", ModelUserContext.CurrentLanguage) ) .ExecuteResultSet(sets); foreach (var obj in objs) { _obj = obj; obj.m_CS = m_CS; if (loading != null) { loading(obj); } _SetupLoad(manager, obj); if (loaded != null) { loaded(obj); } } return(objs); } catch (DataException e) { throw DbModelException.Create(_obj, e); } }
private CountryLookup _CreateNew(DbManagerProxy manager, IObject Parent, int?HACode, on_action creating, on_action created, bool isFake = false) { CountryLookup obj = null; try { obj = CountryLookup.CreateInstance(); obj.m_CS = m_CS; obj.m_IsNew = true; obj.Parent = Parent; if (creating != null) { creating(obj); } // creating extenters - begin // creating extenters - end _LoadLookups(manager, obj); _SetupHandlers(obj); _SetupChildHandlers(obj, null); obj._SetupMainHandler(); obj._setParent(); // created extenters - begin // created extenters - end if (created != null) { created(obj); } obj.Created(manager); _SetPermitions(obj._permissions, obj); _SetupRequired(obj); _SetupPersonalDataRestrictions(obj); return(obj); } catch (DataException e) { throw DbModelException.Create(obj, e); } }
public virtual List <AnimalAgeLookup> _SelectListInternal(DbManagerProxy manager , String idfsSpecies , on_action loading, on_action loaded ) { AnimalAgeLookup _obj = null; try { MapResultSet[] sets = new MapResultSet[1]; List <AnimalAgeLookup> objs = new List <AnimalAgeLookup>(); sets[0] = new MapResultSet(typeof(AnimalAgeLookup), objs); manager .SetSpCommand("spAnimalAgeList_SelectLookup" , manager.Parameter("@idfsSpecies", idfsSpecies) , manager.Parameter("@LangID", ModelUserContext.CurrentLanguage) ) .ExecuteResultSet(sets); foreach (var obj in objs) { _obj = obj; obj.m_CS = m_CS; if (loading != null) { loading(obj); } _SetupLoad(manager, obj); if (loaded != null) { loaded(obj); } } return(objs); } catch (DataException e) { throw DbModelException.Create(_obj, e); } }
public virtual List <Lookup2ParamTable> _SelectListInternal(DbManagerProxy manager , Int32?ParentID , on_action loading, on_action loaded ) { Lookup2ParamTable _obj = null; try { MapResultSet[] sets = new MapResultSet[1]; List <Lookup2ParamTable> objs = new List <Lookup2ParamTable>(); sets[0] = new MapResultSet(typeof(Lookup2ParamTable), objs); manager .SetSpCommand("spLookupTable2Param_SelectLookup" , manager.Parameter("@ParentID", ParentID) , manager.Parameter("@LangID", ModelUserContext.CurrentLanguage) ) .ExecuteResultSet(sets); foreach (var obj in objs) { _obj = obj; obj.m_CS = m_CS; if (loading != null) { loading(obj); } _SetupLoad(manager, obj); if (loaded != null) { loaded(obj); } } return(objs); } catch (DataException e) { throw DbModelException.Create(_obj, e); } }
public virtual List <SmphBaseReferenceTranslationLookup> _SelectListInternal(DbManagerProxy manager , Int64?idfsReferenceType , String lang , on_action loading, on_action loaded ) { SmphBaseReferenceTranslationLookup _obj = null; try { MapResultSet[] sets = new MapResultSet[1]; List <SmphBaseReferenceTranslationLookup> objs = new List <SmphBaseReferenceTranslationLookup>(); sets[0] = new MapResultSet(typeof(SmphBaseReferenceTranslationLookup), objs); manager .SetSpCommand("spSmphBaseReferenceTranslation_SelectLookup" , manager.Parameter("@idfsReferenceType", idfsReferenceType) , manager.Parameter("@lang", lang) ) .ExecuteResultSet(sets); foreach (var obj in objs) { _obj = obj; obj.m_CS = m_CS; if (loading != null) { loading(obj); } _SetupLoad(manager, obj); if (loaded != null) { loaded(obj); } } return(objs); } catch (DataException e) { throw DbModelException.Create(_obj, e); } }
public List <CustomMandatoryField> GetCustomMandatoryFields(long?idfCustomizationPackage = null) { using (DbManagerProxy manager = DbManagerFactory.Factory.Create(ModelUserContext.Instance)) { try { DataTable dt = manager.SetSpCommand("dbo.spContext_GetCustomMandatoryFields", manager.Parameter("@idfCustomizationPackage", idfCustomizationPackage) ).ExecuteDataTable(); return((from DataRow row in dt.Rows select(CustomMandatoryField) Convert.ToInt64(row["idfMandatoryField"])).ToList()); } catch (DataException e) { throw DbModelException.Create(null, e); } } }
public int SetPassword(object userID, string password) { using (DbManagerProxy manager = DbManagerFactory.Factory.Create(ModelUserContext.Instance)) { try { manager.SetSpCommand("dbo.spSetPassword", manager.Parameter("@UserID", userID), manager.Parameter("@Password", PasswordHash(password)), manager.Parameter(ParameterDirection.Output, "@Result", 0) ).ExecuteNonQuery(); return(Convert.ToInt32(manager.Parameter("@Result").Value)); } catch (DataException e) { throw DbModelException.Create(null, e); } } }
internal int CheckVersion() { using (DbManagerProxy manager = DbManagerFactory.Factory.Create(ModelUserContext.Instance)) { try { manager.SetSpCommand("dbo.spCheckVersion", manager.Parameter("@ModuleName", ModelUserContext.ApplicationName), manager.Parameter("@ModuleVersion", ModelUserContext.Version), manager.Parameter(ParameterDirection.Output, "@Result", 0) ).ExecuteNonQuery(); return(Convert.ToInt32(manager.Parameter("@Result").Value)); } catch (DataException e) { throw DbModelException.Create(null, e); } } }
public virtual List <RuleConstant> _SelectListInternal(DbManagerProxy manager , Int64?idfsRule , on_action loading, on_action loaded ) { RuleConstant _obj = null; try { MapResultSet[] sets = new MapResultSet[1]; List <RuleConstant> objs = new List <RuleConstant>(); sets[0] = new MapResultSet(typeof(RuleConstant), objs); manager .SetSpCommand("spFFGetRuleConstant" , manager.Parameter("@idfsRule", idfsRule) ) .ExecuteResultSet(sets); foreach (var obj in objs) { _obj = obj; obj.m_CS = m_CS; if (loading != null) { loading(obj); } _SetupLoad(manager, obj); if (loaded != null) { loaded(obj); } } return(objs); } catch (DataException e) { throw DbModelException.Create(_obj, e); } }
public virtual List <SmphInvisibleFieldsLookup> _SelectListInternal(DbManagerProxy manager , Int64?idfCustomizationPackage , on_action loading, on_action loaded ) { SmphInvisibleFieldsLookup _obj = null; try { MapResultSet[] sets = new MapResultSet[1]; List <SmphInvisibleFieldsLookup> objs = new List <SmphInvisibleFieldsLookup>(); sets[0] = new MapResultSet(typeof(SmphInvisibleFieldsLookup), objs); manager .SetSpCommand("spSmphInvisibleFields_SelectLookup" , manager.Parameter("@idfCustomizationPackage", idfCustomizationPackage) ) .ExecuteResultSet(sets); foreach (var obj in objs) { _obj = obj; obj.m_CS = m_CS; if (loading != null) { loading(obj); } _SetupLoad(manager, obj); if (loaded != null) { loaded(obj); } } return(objs); } catch (DataException e) { throw DbModelException.Create(_obj, e); } }
public virtual List <PostalCodeLookup> _SelectListInternal(DbManagerProxy manager , Int64?SettlementID , on_action loading, on_action loaded ) { PostalCodeLookup _obj = null; try { MapResultSet[] sets = new MapResultSet[1]; List <PostalCodeLookup> objs = new List <PostalCodeLookup>(); sets[0] = new MapResultSet(typeof(PostalCodeLookup), objs); manager .SetSpCommand("spPostalCode_SelectLookup" , manager.Parameter("@SettlementID", SettlementID) ) .ExecuteResultSet(sets); foreach (var obj in objs) { _obj = obj; obj.m_CS = m_CS; if (loading != null) { loading(obj); } _SetupLoad(manager, obj); if (loaded != null) { loaded(obj); } } return(objs); } catch (DataException e) { throw DbModelException.Create(_obj, e); } }
public virtual List <Observation> _SelectListInternal(DbManagerProxy manager , String observationList , on_action loading, on_action loaded ) { Observation _obj = null; try { MapResultSet[] sets = new MapResultSet[1]; List <Observation> objs = new List <Observation>(); sets[0] = new MapResultSet(typeof(Observation), objs); manager .SetSpCommand("spFFGetObservations" , manager.Parameter("@observationList", observationList) ) .ExecuteResultSet(sets); foreach (var obj in objs) { _obj = obj; obj.m_CS = m_CS; if (loading != null) { loading(obj); } _SetupLoad(manager, obj); if (loaded != null) { loaded(obj); } } return(objs); } catch (DataException e) { throw DbModelException.Create(_obj, e); } }
private List <EidssSiteOptions> GetSiteOptions(string spName) { Utils.CheckNotNullOrEmpty(spName, "spName"); using (DbManagerProxy manager = DbManagerFactory.Factory.Create(ModelUserContext.Instance)) { try { List <EidssSiteOptions> eidssSiteOptionses = manager.SetSpCommand(spName).ExecuteList <EidssSiteOptions>(); return(eidssSiteOptionses); } catch (Exception e) { if (e is DataException) { throw DbModelException.Create(null, e as DataException); } throw; } } }
public int ChangePassword(string organization, string userName, string currentPassword, string newPassword) { int res = CheckVersion(); if (res != 0) { return(res); } object hash = null; res = EvaluateHash(currentPassword, ref hash); if (res != 0) { return(res); } using (DbManagerProxy manager = DbManagerFactory.Factory.Create(ModelUserContext.Instance)) { try { DataTable dt = manager.SetSpCommand("dbo.spChangePassword", manager.Parameter("@Organization", organization), manager.Parameter("@UserName", userName), manager.Parameter("@CurrentPassword", hash), manager.Parameter("@NewPassword", PasswordHash(newPassword)), manager.Parameter(ParameterDirection.Output, "@Result", 0) ).ExecuteDataTable(); res = Convert.ToInt32(manager.Parameter("@Result").Value); if (res == 0) { SetEidssUser(dt); } return(res); } catch (DataException e) { throw DbModelException.Create(null, e); } } }
public virtual List<FFTemplateLookup> _SelectListInternal(DbManagerProxy manager , Int64? idfsFormTemplate , Int64? idfsFormType , on_action loading, on_action loaded ) { FFTemplateLookup _obj = null; try { MapResultSet[] sets = new MapResultSet[1]; List<FFTemplateLookup> objs = new List<FFTemplateLookup>(); sets[0] = new MapResultSet(typeof(FFTemplateLookup), objs); manager .SetSpCommand("spFFGetTemplates" , manager.Parameter("@idfsFormTemplate", idfsFormTemplate) , manager.Parameter("@idfsFormType", idfsFormType) , manager.Parameter("@LangID", ModelUserContext.CurrentLanguage) ) .ExecuteResultSet(sets); foreach(var obj in objs) { _obj = obj; obj.m_CS = m_CS; if (loading != null) loading(obj); _SetupLoad(manager, obj); if (loaded != null) loaded(obj); } return objs; } catch(DataException e) { throw DbModelException.Create(_obj, e); } }
private List <long> GetDenyPermissionOnDiagnosis(object userId) { using (DbManagerProxy manager = DbManagerFactory.Factory.Create(ModelUserContext.Instance)) { try { DataTable table = manager.SetCommand( "select idfsDiagnosis from dbo.fnGetPermissionOnDiagnosis(@ObjectOperation, @Employee) where intPermission = 1", manager.Parameter("@ObjectOperation", Convert.ToInt64(ObjectOperation.Read)), manager.Parameter("@Employee", userId) ).ExecuteDataTable(); return((from DataRow row in table.Rows select(long) row["idfsDiagnosis"]).ToList()); } catch (DataException e) { throw DbModelException.Create(null, e); } } }
public virtual List <SmphDiagnosisLookup> _SelectListInternal(DbManagerProxy manager , on_action loading, on_action loaded ) { SmphDiagnosisLookup _obj = null; try { MapResultSet[] sets = new MapResultSet[1]; List <SmphDiagnosisLookup> objs = new List <SmphDiagnosisLookup>(); sets[0] = new MapResultSet(typeof(SmphDiagnosisLookup), objs); manager .SetSpCommand("spSmphDiagnosis_SelectLookup" ) .ExecuteResultSet(sets); foreach (var obj in objs) { _obj = obj; obj.m_CS = m_CS; if (loading != null) { loading(obj); } _SetupLoad(manager, obj); if (loaded != null) { loaded(obj); } } return(objs); } catch (DataException e) { throw DbModelException.Create(_obj, e); } }
private void CreateEvent(DbManagerProxy manager, int isProcessed, EventType eventType, long?objectIdent, string info) { try { Type cacheManager = Type.GetType("bv.common.db.Core.LookupCache, bvdb_common"); if (cacheManager != null) { MethodInfo method = cacheManager.GetMethod("Refresh", BindingFlags.Static | BindingFlags.Public, null, new[] { typeof(string), typeof(bool), typeof(IDbTransaction), typeof(object) }, null); if (method != null) { method.Invoke(null, new object[] { info, false, manager.Transaction, null }); } } var lEventID = manager.SetSpCommand("dbo.spEventLog_CreateNewEvent", eventType, objectIdent, info, DBNull.Value, ClientID, DBNull.Value, isProcessed, DBNull.Value, DBNull.Value, DBNull.Value, DBNull.Value ).ExecuteScalar <long>(ScalarSourceType.OutputParameter, "EventID"); m_EventIdents.Add(lEventID); } catch (Exception e) { if (e is DataException) { throw DbModelException.Create(null, e as DataException); } throw; } }
public int LogIn(string ticketId, bool repeatAfterDeadlock = true) { using (DbManagerProxy manager = DbManagerFactory.Factory.Create(ModelUserContext.Instance)) { try { DataTable dt = manager.SetSpCommand("dbo.spLoginByTicket", manager.Parameter("@strTicket", ticketId), manager.Parameter("@intExpirationInterval", BaseSettings.TicketExpiration), manager.Parameter(ParameterDirection.Output, "@Result", 0) ).ExecuteDataTable(); int res = Convert.ToInt32(manager.Parameter("@Result").Value); if (res == 0) { PerformLogin(dt); } m_LoginTry = 0; return(res); } catch (Exception e) { Dbg.Debug("login by ticket failed, error: {0}", e); Dbg.Trace(); m_LoginTry++; if (DbModelException.IsDeadlockException(e) && m_LoginTry < DedalockRepeatCount) { Debug.WriteLine("user login deadlock found"); return(LogIn(ticketId, m_LoginTry < DedalockRepeatCount - 1)); } var dataException = e as DataException; if (dataException != null) { m_LoginTry = 0; throw DbModelException.Create(null, dataException); } m_LoginTry = 0; throw; } } }
public string CreateTicket(long userId) { var dbType = DatabaseType.Main; var connectionCredentials = new ConnectionCredentials(null, "Avr"); if (connectionCredentials.IsCorrect) { DbManagerFactory.SetSqlFactory(connectionCredentials.ConnectionString, DatabaseType.AvrTicket); using (var avrManager = DbManagerFactory.Factory[DatabaseType.AvrTicket].Create()) { if (avrManager.TestConnection()) { dbType = DatabaseType.AvrTicket; } } } using (DbManagerProxy manager = DbManagerFactory.Factory[dbType].Create(ModelUserContext.Instance)) { try { manager.SetSpCommand("dbo.spLoginCreateTicket", manager.Parameter("@idfUserID", userId), manager.Parameter(ParameterDirection.Output, "@strTicket", ""), manager.Parameter(ParameterDirection.Output, "@Result", 0) ).ExecuteNonQuery(); int res = Convert.ToInt32(manager.Parameter("@Result").Value); if (res == 0) { return(Utils.Str(manager.Parameter("@strTicket").Value)); } return(null); } catch (DataException e) { throw DbModelException.Create(null, e); } } }
public ActionResult HttpError() { Exception ex = null; ViewData["SessionExpired"] = false; try { ex = (Exception)HttpContext.Application[Request.UserHostAddress]; ViewData["Description"] = ex.Message; } catch { ViewData["Description"] = EidssMessages.Get("Error_Unknown"); } if (ex != null) { if (ex is ObjectNotFoundException) { ViewData["Description"] = EidssMessages.Get("Error_ObjectExpired"); } else if (ex is DbModelException) { DbModelException ex1 = ex as DbModelException; // ViewData["Description"] = ex.Message; //if (ex1 != null) //{ // ViewData["Description"] = ex1.Message; //} if (string.IsNullOrEmpty(ex1.MessageId)) { ViewData["Description"] = ex1.Message; } else { string err = EidssMessages.Get(ex1.MessageId); if (string.IsNullOrEmpty(err)) { err = BvMessages.Get(ex1.MessageId, ex1.Message); } ViewData["Description"] = err; } } else { if (EidssUserContext.User == null || Session == null || String.IsNullOrEmpty(EidssUserContext.User.FullName)) { ViewData["Description"] = EidssMessages.Get("SessionExpired"); ViewData["SessionExpired"] = true; } else { ViewData["Description"] = ex.Message; } } } else { ViewData["Description"] = EidssMessages.Get("Error_Custom"); } ViewData["Title"] = EidssMessages.Get("Error_Custom"); return(View("Error")); }
public List <PersonalDataGroup> GetPersonalDataGroups(long?idfUser = null, long?idfCustomizationPackage = null) { using (DbManagerProxy manager = DbManagerFactory.Factory.Create(ModelUserContext.Instance)) { var result = new List <PersonalDataGroup>(); try { Dictionary <string, bool> permissions; if (EidssUserContext.User == null) { //check if user has restrictions permissions = ParsePermissions( manager.SetSpCommand("dbo.spEvaluatePermissions", manager.Parameter("@idfEmployee", idfUser) ).ExecuteDataTable()); } else { permissions = (Dictionary <string, bool>)EidssUserContext.User.Permissions; } List <PersonalDataGroup> personalGroups = ParsePersonalDataGroups( manager.SetSpCommand("[dbo].[spContext_GetPersonalDataGroups]", manager.Parameter("@idfCustomizationPackage", idfCustomizationPackage) ).ExecuteDataTable()); if (personalGroups.Count == 0) { return(result); } var splitter = new[] { '.' }; foreach (KeyValuePair <string, bool> permission in permissions) { string[] parser = permission.Key.Split(splitter); if (parser[1].Equals(AccessToPersonalDataString, StringComparison.InvariantCultureIgnoreCase) && !permission.Value) { bool human = parser[0] == EIDSSPermissionObject.HumanCase.ToString(); bool vet = parser[0] == EIDSSPermissionObject.VetCase.ToString(); foreach (PersonalDataGroup pg in personalGroups) { if (pg.ToString().StartsWith("Human") && human) { result.Add(pg); continue; } if (pg.ToString().StartsWith("Vet") && vet) { result.Add(pg); } } } if (personalGroups.Count == result.Count) { break; } } return(result); } catch (DataException e) { throw DbModelException.Create(null, e); } } }