private void Init(SqlTransaction trans, short cityObjectTypeID) { if (!CanView(UserName)) { throw new AccessException(UserName, "Init"); } SqlParameter[] prms = new SqlParameter[3]; prms[0] = new SqlParameter("@CityObjectTypeID", SqlDbType.SmallInt); prms[0].Value = cityObjectTypeID; prms[1] = new SqlParameter("@CityObjectTypeName", SqlDbType.NVarChar, 25); prms[1].Direction = ParameterDirection.Output; prms[2] = new SqlParameter("@CityObjectTypeShortName", SqlDbType.NVarChar, 25); prms[2].Direction = ParameterDirection.Output; if (trans == null) { SPHelper.ExecuteNonQuery(SpNames.Get, prms); } else { SPHelper.ExecuteNonQuery(trans, SpNames.Get, prms); } ID = cityObjectTypeID; Name = (string)prms[1].Value; ShortName = (string)prms[2].Value; }
public int Insert(SqlTransaction trans) { if (!CanInsert(UserName)) { throw new AccessException(UserName, "Insert"); } SqlParameter[] prms = new SqlParameter[13]; prms[0] = new SqlParameter("@CitizenID", SqlDbType.Int); prms[0].Direction = ParameterDirection.Output; prms[1] = new SqlParameter("@FirstName", SqlDbType.NVarChar, 50); prms[1].Value = FirstName; prms[2] = new SqlParameter("@MiddleName", SqlDbType.NVarChar, 50); prms[2].Value = MiddleName; prms[3] = new SqlParameter("@LastName", SqlDbType.NVarChar, 50); prms[3].Value = LastName; prms[4] = new SqlParameter("@Address", SqlDbType.NVarChar, 100); prms[4].Value = Address; prms[5] = new SqlParameter("@PhoneNumber", SqlDbType.NVarChar, 50); prms[5].Value = PhoneNumber; prms[6] = new SqlParameter("@CityObjectID", SqlDbType.Int); prms[6].Value = CityObjectID; prms[7] = new SqlParameter("@HouseNumber", SqlDbType.NVarChar, 50); prms[7].Value = HouseNumber; prms[8] = new SqlParameter("@Corps", SqlDbType.NVarChar, 50); prms[8].Value = Corps; prms[9] = new SqlParameter("@ApartmentNumber", SqlDbType.NVarChar, 50); prms[9].Value = ApartmentNumber; prms[10] = new SqlParameter("@Work", SqlDbType.NVarChar, 100); prms[10].Value = Work; prms[11] = new SqlParameter("@Sex", SqlDbType.Int); prms[11].Value = Sex; prms[12] = new SqlParameter("@SocialStatusID", SqlDbType.Int); prms[12].Value = SocialStatusID; if (trans == null) { SPHelper.ExecuteNonQuery(SpNames.Insert, prms); } else { SPHelper.ExecuteNonQuery(trans, SpNames.Insert, prms); } ID = (int)prms[0].Value; return(ID); }
public int Insert(SqlTransaction trans) { if (!CanInsert(UserName)) { throw new AccessException(UserName, "Insert"); } SqlParameter[] prms = new SqlParameter[2]; prms[0] = new SqlParameter("@QuestionTypeID", SqlDbType.Int); prms[0].Direction = ParameterDirection.Output; prms[1] = new SqlParameter("@Name", SqlDbType.NVarChar, 100); prms[1].Value = Name; if (trans == null) { SPHelper.ExecuteNonQuery(SpNames.Insert, prms); } else { SPHelper.ExecuteNonQuery(trans, SpNames.Insert, prms); } ID = (int)prms[0].Value; return(ID); }
public static Guid GetObjectID(SqlTransaction trans, int departmentId) { SqlParameter[] prms = new SqlParameter[5]; prms[0] = new SqlParameter("@DepartmentID", SqlDbType.Int); prms[0].Value = departmentId; prms[1] = new SqlParameter("@Name", SqlDbType.NVarChar, 100); prms[1].Direction = ParameterDirection.Output; prms[2] = new SqlParameter("@ShortName", SqlDbType.NVarChar, 50); prms[2].Direction = ParameterDirection.Output; prms[3] = new SqlParameter("@ObjectID", SqlDbType.UniqueIdentifier); prms[3].Direction = ParameterDirection.Output; prms[4] = new SqlParameter("@ParrentDepartmentID", SqlDbType.Int); prms[4].Direction = ParameterDirection.Output; if (trans == null) { SPHelper.ExecuteNonQuery(SpNames.Get, prms); } else { SPHelper.ExecuteNonQuery(trans, SpNames.Get, prms); } return((Guid)prms[3].Value); }
public void Update(SqlTransaction trans) { if (!CanUpdate(UserName)) { throw new AccessException(UserName, "Update"); } SqlParameter[] prms = new SqlParameter[3]; prms[0] = new SqlParameter("@SocialCategoryListID", SqlDbType.Int); prms[0].Value = ID; prms[1] = new SqlParameter("@CitizenID", SqlDbType.Int); prms[1].Value = CitizenID; prms[2] = new SqlParameter("@SocialCategoryID", SqlDbType.Int); prms[2].Value = SocialCategoryID; if (trans == null) { SPHelper.ExecuteNonQuery(SpNames.Update, prms); } else { SPHelper.ExecuteNonQuery(trans, SpNames.Update, prms); } }
public static int GetDepartmentID(SqlTransaction trans, int postId) { SqlParameter[] prms = new SqlParameter[5]; prms[0] = new SqlParameter("@PostID", SqlDbType.Int); prms[0].Value = postId; prms[1] = new SqlParameter("@Name", SqlDbType.NVarChar, 256); prms[1].Direction = ParameterDirection.Output; prms[2] = new SqlParameter("@DepartmentID", SqlDbType.Int); prms[2].Direction = ParameterDirection.Output; prms[3] = new SqlParameter("@IsVacant", SqlDbType.Bit); prms[3].Direction = ParameterDirection.Output; prms[4] = new SqlParameter("@PostTypeID", SqlDbType.Int); prms[4].Direction = ParameterDirection.Output; if (trans == null) { SPHelper.ExecuteNonQuery(StoredProcedures.GetPost, prms); } else { SPHelper.ExecuteNonQuery(trans, StoredProcedures.GetPost, prms); } return((int)prms[2].Value); }
private void Init(SqlTransaction trans, Guid objectID) { SqlParameter[] prms = new SqlParameter[5]; prms[0] = new SqlParameter("@DepartmentID", SqlDbType.Int); prms[0].Direction = ParameterDirection.Output; prms[1] = new SqlParameter("@Name", SqlDbType.NVarChar, 100); prms[1].Direction = ParameterDirection.Output; prms[2] = new SqlParameter("@ShortName", SqlDbType.NVarChar, 50); prms[2].Direction = ParameterDirection.Output; prms[3] = new SqlParameter("@ObjectID", SqlDbType.UniqueIdentifier); prms[3].Value = objectID; prms[4] = new SqlParameter("@ParrentDepartmentID", SqlDbType.Int); prms[4].Direction = ParameterDirection.Output; if (trans == null) { SPHelper.ExecuteNonQuery(SpNames.GetByObjectID, prms); } else { SPHelper.ExecuteNonQuery(trans, SpNames.GetByObjectID, prms); } ID = (int)prms[0].Value; Name = (string)prms[1].Value; ShortName = (string)prms[2].Value; ObjectID = objectID; ParrentDepartmentID = (int)prms[4].Value; }
public override void Init(SqlTransaction trans, int organizationId) { base.Init(trans, organizationId); SqlParameter[] prms = new SqlParameter[5]; prms[0] = new SqlParameter("@OrganizationID", SqlDbType.Int); prms[0].Value = organizationId; prms[1] = new SqlParameter("@Name", SqlDbType.NVarChar, 256); prms[1].Direction = ParameterDirection.Output; prms[2] = new SqlParameter("@OrganizationTypeID", SqlDbType.Int); prms[2].Direction = ParameterDirection.Output; prms[3] = new SqlParameter("@DepartmentID", SqlDbType.Int); prms[3].Direction = ParameterDirection.Output; prms[4] = new SqlParameter("@WorkerID", SqlDbType.Int); prms[4].Direction = ParameterDirection.Output; if (trans == null) { SPHelper.ExecuteNonQuery(SpNames.Get, prms); } else { SPHelper.ExecuteNonQuery(trans, SpNames.Get, prms); } ID = organizationId; Name = (string)prms[1].Value; OrganizationTypeID = (int)prms[2].Value; DepartmentID = (int)prms[3].Value; WorkerID = (int)prms[4].Value; }
public void Update(SqlTransaction trans) { if (!CanUpdate(UserName)) { throw new AccessException(UserName, "Update"); } SqlParameter[] prms = new SqlParameter[4]; prms[0] = new SqlParameter("@DocumentID", SqlDbType.Int); prms[0].Value = ID; prms[1] = new SqlParameter("@CreationDate", SqlDbType.DateTime); prms[1].Value = CreationDate; prms[2] = new SqlParameter("@ExternalNumber", SqlDbType.NVarChar, 50); prms[2].Value = Number; prms[3] = new SqlParameter("@OrganizationID", SqlDbType.Int); prms[3].Value = OrganizationID; if (trans == null) { SPHelper.ExecuteNonQuery(SpNames.Update, prms); } else { SPHelper.ExecuteNonQuery(trans, SpNames.Update, prms); } }
public override int Insert(SqlTransaction trans) { base.Insert(trans); SqlParameter[] prms = new SqlParameter[5]; prms[0] = new SqlParameter("@OrganizationID", SqlDbType.Int); prms[0].Direction = ParameterDirection.Output; prms[1] = new SqlParameter("@Name", SqlDbType.NVarChar, 256); prms[1].Value = Name; prms[2] = new SqlParameter("@OrganizationTypeID", SqlDbType.Int); prms[2].Value = OrganizationTypeID; prms[3] = new SqlParameter("@DepartmentID", SqlDbType.Int); prms[3].Value = DepartmentID; prms[4] = new SqlParameter("@WorkerID", SqlDbType.Int); prms[4].Value = WorkerID; if (trans == null) { SPHelper.ExecuteNonQuery(SpNames.Insert, prms); } else { SPHelper.ExecuteNonQuery(trans, SpNames.Insert, prms); } ID = (int)prms[0].Value; return(ID); }
public static Organization GetByName(SqlTransaction trans, string name, string userName) { Organization org = null; SqlParameter[] sps = new SqlParameter[3]; sps[0] = new SqlParameter("@OrganizationID", SqlDbType.Int); sps[0].Direction = ParameterDirection.Output; sps[1] = new SqlParameter("@Name", SqlDbType.NVarChar, 256); sps[1].Value = name; sps[2] = new SqlParameter("@OrganizationTypeID", SqlDbType.Int); sps[2].Direction = ParameterDirection.Output; SPHelper.ExecuteNonQuery(trans, SpNames.GetByName, sps); if (sps[0].Value != DBNull.Value) { org = new Organization(userName); org.ID = (int)sps[0].Value; org.Name = (string)sps[1].Value; org.OrganizationTypeID = (int)sps[2].Value; } return(org); }
private void Init(SqlTransaction trans, int branchListId) { if (!CanView(UserName)) { throw new AccessException(UserName, "Init"); } SqlParameter[] prms = new SqlParameter[3]; prms[0] = new SqlParameter("@BranchListID", SqlDbType.Int); prms[0].Value = branchListId; prms[1] = new SqlParameter("@DocStatementID", SqlDbType.Int); prms[1].Direction = ParameterDirection.Output; prms[2] = new SqlParameter("@BranchTypeID", SqlDbType.Int); prms[2].Direction = ParameterDirection.Output; if (trans == null) { SPHelper.ExecuteNonQuery(SpNames.Get, prms); } else { SPHelper.ExecuteNonQuery(trans, SpNames.Get, prms); } ID = branchListId; DocStatementID = (int)prms[1].Value; BranchTypeID = (int)prms[2].Value; }
public void Update(SqlTransaction trans) { if (!CanUpdate(UserName)) { throw new AccessException(UserName, "Update"); } SqlParameter[] prms = new SqlParameter[3]; prms[0] = new SqlParameter("@BranchListID", SqlDbType.Int); prms[0].Value = ID; prms[1] = new SqlParameter("@DocStatementID", SqlDbType.Int); prms[1].Value = DocStatementID; prms[2] = new SqlParameter("@BranchTypeID", SqlDbType.Int); prms[2].Value = BranchTypeID; if (trans == null) { SPHelper.ExecuteNonQuery(SpNames.Update, prms); } else { SPHelper.ExecuteNonQuery(trans, SpNames.Update, prms); } }
public static ControlCard GetLastCard(SqlTransaction trans, int documentID, int departmentId, string userName) { SqlParameter[] prms = new SqlParameter[3]; prms[0] = new SqlParameter("@DocumentID", SqlDbType.Int); prms[0].Value = documentID; prms[1] = new SqlParameter("@DepartmentID", SqlDbType.Int); prms[1].Value = departmentId; prms[2] = new SqlParameter("@ControlCardID", SqlDbType.Int); prms[2].Direction = ParameterDirection.Output; SPHelper.ExecuteNonQuery(trans, SpNames.GetLast, prms); int controlCardID = 0; if (prms[2].Value != DBNull.Value) { controlCardID = (int)prms[2].Value; } if (controlCardID <= 0) { return(null); } return(new ControlCard(trans, controlCardID, userName)); }
public static int GetPostID(SqlTransaction trans, int workerId) { SqlParameter[] prms = new SqlParameter[6]; prms[0] = new SqlParameter("@WorkerID", SqlDbType.Int); prms[0].Value = workerId; prms[1] = new SqlParameter("@FirstName", SqlDbType.NVarChar, 50); prms[1].Direction = ParameterDirection.Output; prms[2] = new SqlParameter("@MiddleName", SqlDbType.NVarChar, 50); prms[2].Direction = ParameterDirection.Output; prms[3] = new SqlParameter("@LastName", SqlDbType.NVarChar, 50); prms[3].Direction = ParameterDirection.Output; prms[4] = new SqlParameter("@PostID", SqlDbType.Int); prms[4].Direction = ParameterDirection.Output; prms[5] = new SqlParameter("@IsDismissed", SqlDbType.Bit); prms[5].Direction = ParameterDirection.Output; if (trans == null) { SPHelper.ExecuteNonQuery(SpNames.Get, prms); } else { SPHelper.ExecuteNonQuery(trans, SpNames.Get, prms); } return((int)prms[4].Value); }
public static bool IsExist(SqlTransaction trans, int id) { bool result = false; if (id > 0) { var arParams = new SqlParameter[2]; arParams[0] = new SqlParameter("@DocumentID", SqlDbType.Int); arParams[0].Value = id; arParams[1] = new SqlParameter("@Result", SqlDbType.Bit); arParams[1].Direction = ParameterDirection.Output; if (trans == null) { SPHelper.ExecuteNonQuery(SpNames.IsExist, arParams); } else { SPHelper.ExecuteNonQuery(trans, SpNames.IsExist, arParams); } if (arParams[1].Value != DBNull.Value) { result = (bool)arParams[1].Value; } } return(result); }
public void Update(SqlTransaction trans) { if (!CanUpdate(UserName)) { throw new AccessException(UserName, "Update"); } SqlParameter[] prms = new SqlParameter[5]; prms[0] = new SqlParameter("@PostID", SqlDbType.Int); prms[0].Value = ID; prms[1] = new SqlParameter("@Name", SqlDbType.NVarChar, -1); prms[1].Value = Name; prms[2] = new SqlParameter("@DepartmentID", SqlDbType.Int); prms[2].Value = DepartmentID; prms[3] = new SqlParameter("@IsVacant", SqlDbType.Bit); prms[3].Value = IsVacant; prms[4] = new SqlParameter("@PostTypeID", SqlDbType.Int); prms[4].Value = PostTypeID; if (trans == null) { SPHelper.ExecuteNonQuery(StoredProcedures.UpdatePost, prms); } else { SPHelper.ExecuteNonQuery(trans, StoredProcedures.UpdatePost, prms); } }
private void Init(SqlTransaction trans, int documentId) { if (!CanView(UserName)) { throw new AccessException(UserName, "Init"); } SqlParameter[] prms = new SqlParameter[4]; prms[0] = new SqlParameter("@DocumentID", SqlDbType.Int); prms[0].Value = documentId; prms[1] = new SqlParameter("@CreationDate", SqlDbType.DateTime); prms[1].Direction = ParameterDirection.Output; prms[2] = new SqlParameter("@ExternalNumber", SqlDbType.NVarChar, 50); prms[2].Direction = ParameterDirection.Output; prms[3] = new SqlParameter("@OrganizationID", SqlDbType.Int); prms[3].Direction = ParameterDirection.Output; if (trans == null) { SPHelper.ExecuteNonQuery(SpNames.Get, prms); } else { SPHelper.ExecuteNonQuery(trans, SpNames.Get, prms); } ID = documentId; CreationDate = (DateTime)prms[1].Value; Number = (string)prms[2].Value; OrganizationID = (int)prms[3].Value; }
public void Update(SqlTransaction trans) { if (!CanUpdate(UserName)) { throw new AccessException(UserName, "Update"); } SqlParameter[] prms = new SqlParameter[3]; prms[0] = new SqlParameter("@DocumentCodeID", SqlDbType.Int); prms[0].Value = ID; prms[1] = new SqlParameter("@Name", SqlDbType.NVarChar, 256); prms[1].Value = Name; prms[2] = new SqlParameter("@Code", SqlDbType.NVarChar, 50); prms[2].Value = Code; if (trans == null) { SPHelper.ExecuteNonQuery(SpNames.Update, prms); } else { SPHelper.ExecuteNonQuery(trans, SpNames.Update, prms); } }
public new static ControlCardBlank GetLastCard(SqlTransaction trans, int documentID, int departmentId, string userName) { SqlParameter[] arParams = new SqlParameter[3]; arParams[0] = new SqlParameter("@DocumentID", SqlDbType.Int); arParams[0].Value = documentID; arParams[1] = new SqlParameter("@DepartmentID", SqlDbType.Int); arParams[1].Value = departmentId; arParams[2] = new SqlParameter("@ControlCardID", SqlDbType.Int); arParams[2].Direction = ParameterDirection.Output; SPHelper.ExecuteNonQuery(trans, "usp_ControlCard_GetLast", arParams); int controlCardID = 0; if (arParams[2].Value != DBNull.Value) { controlCardID = (int)arParams[2].Value; } if (controlCardID <= 0) { return(null); } return(new ControlCardBlank(trans, controlCardID, userName)); }
public void Update(SqlTransaction trans) { SqlParameter[] prms = new SqlParameter[5]; prms[0] = new SqlParameter("@DepartmentID", SqlDbType.Int); prms[0].Value = ID; prms[1] = new SqlParameter("@Name", SqlDbType.NVarChar, 100); prms[1].Value = Name; prms[2] = new SqlParameter("@ShortName", SqlDbType.NVarChar, 50); prms[2].Value = ShortName; prms[3] = new SqlParameter("@ObjectID", SqlDbType.UniqueIdentifier); prms[3].Value = ObjectID; prms[4] = new SqlParameter("@ParrentDepartmentID", SqlDbType.Int); prms[4].Value = ParrentDepartmentID; if (trans == null) { SPHelper.ExecuteNonQuery(SpNames.Update, prms); } else { SPHelper.ExecuteNonQuery(trans, SpNames.Update, prms); } }
private void Init(SqlTransaction trans, Guid objectId) { if (!CanView(UserName, objectId)) { throw new AccessException(UserName, "Init"); } SqlParameter[] prms = new SqlParameter[4]; prms[0] = new SqlParameter("@MenuTemplateID", SqlDbType.Int); prms[0].Direction = ParameterDirection.Output; prms[1] = new SqlParameter("@Name", SqlDbType.NVarChar, 50); prms[1].Direction = ParameterDirection.Output; prms[2] = new SqlParameter("@SystemName", SqlDbType.NVarChar, 50); prms[2].Direction = ParameterDirection.Output; prms[3] = new SqlParameter("@ObjectID", SqlDbType.UniqueIdentifier); prms[3].Value = objectId; if (trans == null) { SPHelper.ExecuteNonQuery(SpNames.GetByObjectID, prms); } else { SPHelper.ExecuteNonQuery(trans, SpNames.GetByObjectID, prms); } ID = (int)prms[0].Value; Name = (string)prms[1].Value; SystemName = (string)prms[2].Value; ObjectID = objectId; }
public int Insert(SqlTransaction trans) { if (!CanInsert(UserName)) { throw new AccessException(UserName, "Insert"); } SqlParameter[] prms = new SqlParameter[3]; prms[0] = new SqlParameter("@SocialCategoryListID", SqlDbType.Int); prms[0].Direction = ParameterDirection.Output; prms[1] = new SqlParameter("@CitizenID", SqlDbType.Int); prms[1].Value = CitizenID; prms[2] = new SqlParameter("@SocialCategoryID", SqlDbType.Int); prms[2].Value = SocialCategoryID; if (trans == null) { SPHelper.ExecuteNonQuery(SpNames.Insert, prms); } else { SPHelper.ExecuteNonQuery(trans, SpNames.Insert, prms); } ID = (int)prms[0].Value; return(ID); }
public void Update(SqlTransaction trans) { if (!CanUpdate(UserName, ObjectID)) { throw new AccessException(UserName, "Update"); } SqlParameter[] prms = new SqlParameter[4]; prms[0] = new SqlParameter("@MenuTemplateID", SqlDbType.Int); prms[0].Value = ID; prms[1] = new SqlParameter("@Name", SqlDbType.NVarChar, 50); prms[1].Value = Name; prms[2] = new SqlParameter("@SystemName", SqlDbType.NVarChar, 50); prms[2].Value = SystemName; prms[3] = new SqlParameter("@ObjectID", SqlDbType.UniqueIdentifier); prms[3].Value = ObjectID; if (trans == null) { SPHelper.ExecuteNonQuery(SpNames.Update, prms); } else { SPHelper.ExecuteNonQuery(trans, SpNames.Update, prms); } }
private void Init(SqlTransaction trans, int socialCategoryListID) { if (!CanView(UserName)) { throw new AccessException(UserName, "Init"); } SqlParameter[] prms = new SqlParameter[3]; prms[0] = new SqlParameter("@SocialCategoryListID", SqlDbType.Int); prms[0].Value = socialCategoryListID; prms[1] = new SqlParameter("@CitizenID", SqlDbType.Int); prms[1].Direction = ParameterDirection.Output; prms[2] = new SqlParameter("@SocialCategoryID", SqlDbType.Int); prms[2].Direction = ParameterDirection.Output; if (trans == null) { SPHelper.ExecuteNonQuery(SpNames.Get, prms); } else { SPHelper.ExecuteNonQuery(trans, SpNames.Get, prms); } ID = socialCategoryListID; CitizenID = (int)prms[1].Value; SocialCategoryID = (int)prms[2].Value; }
public int Insert(SqlTransaction trans) { if (!CanInsert(this.UserName)) { throw new AccessException(this.UserName, "Insert"); } AccessObject aObject = new AccessObject(ConstantCode.CONNECTION_STRING); aObject.Id = Guid.NewGuid(); aObject.Name = this._name; aObject.ObjectTypeId = ObjectTypeID; aObject.ObjectStateId = StateIDAll; this._objectID = aObject.Insert(trans); string spName = "usp_CityObjects_Insert"; CityObjectsParamsHelper helper = new CityObjectsParamsHelper(this); helper.InitParamsForSP(spName); SqlParameter[] parameters = helper.ParamList.Params; SPHelper.ExecuteNonQuery(trans, spName, parameters); helper.SetPropValues(); return(this._id); }
public void Update(SqlTransaction trans) { if (!CanUpdate(UserName)) { throw new AccessException(UserName, "Update"); } SqlParameter[] prms = new SqlParameter[6]; prms[0] = new SqlParameter("@CityObjectID", SqlDbType.Int); prms[0].Value = ID; prms[1] = new SqlParameter("@CityObjectTypeID", SqlDbType.SmallInt); prms[1].Value = TypeID; prms[2] = new SqlParameter("@CityObjectName", SqlDbType.NVarChar, 100); prms[2].Value = Name; prms[3] = new SqlParameter("@CityObjectOldName", SqlDbType.NVarChar, 100); prms[3].Value = OldName; prms[4] = new SqlParameter("@CityObjectSearchName", SqlDbType.NVarChar, 100); prms[4].Value = SearchName; prms[5] = new SqlParameter("@IsReal", SqlDbType.Bit); prms[5].Value = IsReal; if (trans == null) { SPHelper.ExecuteNonQuery(SpNames.Update, prms); } else { SPHelper.ExecuteNonQuery(trans, SpNames.Update, prms); } }
public override void Update(SqlTransaction trans) { base.Update(trans); SqlParameter[] prms = new SqlParameter[6]; prms[0] = new SqlParameter("@WorkerID", SqlDbType.Int); prms[0].Value = ID; prms[1] = new SqlParameter("@FirstName", SqlDbType.NVarChar, 50); prms[1].Value = FirstName; prms[2] = new SqlParameter("@MiddleName", SqlDbType.NVarChar, 50); prms[2].Value = MiddleName; prms[3] = new SqlParameter("@LastName", SqlDbType.NVarChar, 50); prms[3].Value = LastName; prms[4] = new SqlParameter("@PostID", SqlDbType.Int); prms[4].Value = PostID; prms[5] = new SqlParameter("@IsDismissed", SqlDbType.Bit); prms[5].Value = IsDismissed; if (trans == null) { SPHelper.ExecuteNonQuery(SpNames.Update, prms); } else { SPHelper.ExecuteNonQuery(trans, SpNames.Update, prms); } }
private void Init(SqlTransaction trans, int questionTypeId) { if (!CanView(UserName)) { throw new AccessException(UserName, "Init"); } SqlParameter[] prms = new SqlParameter[2]; prms[0] = new SqlParameter("@QuestionTypeID", SqlDbType.Int); prms[0].Value = questionTypeId; prms[1] = new SqlParameter("@Name", SqlDbType.NVarChar, 100); prms[1].Direction = ParameterDirection.Output; if (trans == null) { SPHelper.ExecuteNonQuery(SpNames.Get, prms); } else { SPHelper.ExecuteNonQuery(trans, SpNames.Get, prms); } ID = questionTypeId; Name = (string)prms[1].Value; }
public static bool IsExist(SqlTransaction trans, int documentId, int departmentId) { bool result = false; if (documentId > 0) { var arParams = new SqlParameter[3]; arParams[0] = new SqlParameter("@DocumentID", SqlDbType.Int); arParams[0].Value = documentId; arParams[1] = new SqlParameter("@DepartmentID", SqlDbType.Int); arParams[1].Value = departmentId; arParams[2] = new SqlParameter("@Result", SqlDbType.Bit); arParams[2].Direction = ParameterDirection.Output; SPHelper.ExecuteNonQuery(trans, SpNames.IsExist, arParams); if (arParams[2].Value != DBNull.Value) { result = (bool)arParams[2].Value; } } return(result); }