// Called by UserObject when it changes internal void UserObjectChanged(UserObject user) { try { int index = List.IndexOf(user); OnListChanged(new ListChangedEventArgs(ListChangedType.ItemChanged, index)); } catch (System.Exception exception1) { Exception innerException = exception1; throw new Exception(MethodBase.GetCurrentMethod().Name, innerException); } }
// Methods. object IBindingList.AddNew() { try { UserObject user = new UserObject(); List.Add(user); return user; } catch (System.Exception exception1) { Exception innerException = exception1; throw new Exception(MethodBase.GetCurrentMethod().Name, innerException); } }
public void Remove(UserObject value) { try { List.Remove(value); } catch (System.Exception exception1) { Exception innerException = exception1; throw new Exception(MethodBase.GetCurrentMethod().Name, innerException); } }
public PopupObjectCollection GetAllActiveByEmployee(UserObject user) { PopupObjectCollection popups = new PopupObjectCollection(); QueryBuilder builder; try { builder = new QueryBuilder(); builder.Append(this.BaseQuery(false, 0)); builder.AppendWhereString(PopupUserObject.USER_ID, user.UsrID.ToString(), QueryBuilder.ComparisonOperators.Equal, QueryBuilder.ParameterLocation.FIRST); builder.Append("AND " + PopupUserObject.USER_ID + " is not null "); builder.Append("AND " + PopupUserObject.POPUP_ID + " is not null "); builder.AppendWhereBoolean(PopupObject.ACTIVE, true, QueryBuilder.ParameterLocation.LAST); popups = PopupConvertor.DataTableToCollection(this.ExecuteDataSet(builder.Query, false).Tables[0]); } catch (System.Exception exception1) { throw new Exception(MethodBase.GetCurrentMethod().Name, exception1); } return popups; }
public int Add(UserObject value) { try { return List.Add(value); } catch (System.Exception exception1) { Exception innerException = exception1; throw new Exception(MethodBase.GetCurrentMethod().Name, innerException); } }
public UserObject GetUserByLogin(string login) { UserObject user = new UserObject(); QueryBuilder builder; try { builder = new QueryBuilder(); builder.Append(this.BaseQuery(false, 0)); builder.AppendWhereString(UserObject.LOGIN, DBFunctions.FixStringValue(login), QueryBuilder.ComparisonOperators.Equal, QueryBuilder.ParameterLocation.FIRST_LAST); user = UserConvertor.UserRowToObject(DBFunctions.FillDataRow(builder.Query , true, "Generic", 30)); } catch (Exception exception1) { Exception innerException = exception1; throw new Exception(MethodBase.GetCurrentMethod().Name, innerException); } return user; }
public void SetUnknownSecurityParameters(UserObject user) { SqlCommand cmd = null; try { //user.Security = new UserSecurityObject(); if (user.Security.Application.AuthSettings == null | user.Security.Application.AuthSettings == "") user.Security.Application.AuthSettings = "000"; if (user.Security.Application.AuthUser == null | user.Security.Application.AuthUser == "") user.Security.Application.AuthUser = "******"; if (user.Security.Main.AuthTask == null | user.Security.Main.AuthTask == "") user.Security.Main.AuthTask = "000"; if (user.Security.Main.AuthCustomer == null | user.Security.Main.AuthCustomer == "") user.Security.Main.AuthCustomer = "000"; if (user.Security.Main.AuthEmployee == null | user.Security.Main.AuthEmployee == "") user.Security.Main.AuthEmployee = "000"; if (user.Security.Costing.AuthCosting == null | user.Security.Costing.AuthCosting == "") user.Security.Costing.AuthCosting = "000"; if (user.Security.Costing.AuthFuel == null | user.Security.Costing.AuthFuel == "") user.Security.Costing.AuthFuel = "000"; if (user.Security.Costing.AuthFuelDelivery == null | user.Security.Costing.AuthFuelDelivery == "") user.Security.Costing.AuthFuelDelivery = "000"; if (user.Security.Costing.AuthFuelCorrection == null | user.Security.Costing.AuthFuelCorrection == "") user.Security.Costing.AuthFuelCorrection = "000"; if (user.Security.Vehicle.AuthVehicle == null | user.Security.Vehicle.AuthVehicle == "") user.Security.Vehicle.AuthVehicle = "000"; //user.Security.Material if (user.Security.Material == null) user.Security.Material = new UserSecurityMaterial(); if (user.Security.Material.AuthMaterial == null | user.Security.Material.AuthMaterial == "") user.Security.Material.AuthMaterial = "000"; if (user.Security.Material.AuthMaterialMaintenance == null | user.Security.Material.AuthMaterialMaintenance == "") user.Security.Material.AuthMaterialMaintenance = "000"; if (user.Security.Material.AuthMaterialMemo == null | user.Security.Material.AuthMaterialMemo == "") user.Security.Material.AuthMaterialMemo = "000"; if (user.Security.Material.AuthMaterialCategory == null | user.Security.Material.AuthMaterialCategory == "") user.Security.Material.AuthMaterialCategory = "000"; if(user.Security.Planning == null) user.Security.Planning = new UserSecurityPlanning(); if (user.Security.Planning.AuthPlanning == null | user.Security.Planning.AuthPlanning == "") user.Security.Planning.AuthPlanning = "000"; this.Save(user); } catch (Exception exception1) { Exception innerException = exception1; throw new Exception(MethodBase.GetCurrentMethod().Name, innerException); } finally { if (cmd != null) { cmd.Dispose(); } cmd = null; } }
public void Save(UserObject user) { SqlCommand cmd = null; try { ExecuteNonQuery(out cmd, false, "Users_SAVE", CreateParameter("@usrID", SqlDbType.UniqueIdentifier, user.UsrID, ParameterDirection.InputOutput), CreateParameter("@empID", SqlDbType.UniqueIdentifier, user.Employee == null ? Guid.Empty : user.Employee.EmpID), CreateParameter("@Surname", SqlDbType.VarChar, user.Surname), CreateParameter("@Name", SqlDbType.VarChar, user.Name), CreateParameter("@Login", SqlDbType.VarChar, user.Login), CreateParameter("@Password", SqlDbType.VarChar, user.Password), CreateParameter("@Active", SqlDbType.Bit, user.Active), CreateParameter("@Security",SqlDbType.VarBinary, PROF_IT.Common.Convert.Byte.ObjectToByteArray(user.Security)), CreateParameter("@HasPopups",SqlDbType.Bit,user.HasPopups) ); user.UsrID = (Guid)cmd.Parameters["@usrID"].Value; } catch (Exception exception1) { Exception innerException = exception1; throw new Exception(MethodBase.GetCurrentMethod().Name, innerException); } finally { if (cmd != null) { cmd.Dispose(); } cmd = null; } }
public bool Remove(UserObject user) { SqlCommand cmd = null; try { ExecuteNonQuery(out cmd, false, "Users_DELETE", CreateParameter("@usrID", SqlDbType.UniqueIdentifier, user.UsrID, ParameterDirection.Input) ); return true; } catch (Exception exception1) { Exception innerException = exception1; throw new Exception(MethodBase.GetCurrentMethod().Name, innerException); } finally { if (cmd != null) { cmd.Dispose(); } cmd = null; } }
public Boolean HasDependencies(UserObject user) { bool flag; try { flag = false; } catch (Exception exception1) { Exception innerException = exception1; throw new Exception(MethodBase.GetCurrentMethod().Name, innerException); } return flag; }