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 int Insert(SqlTransaction trans)
{
if (!CanInsert(UserName, ObjectID))
{
throw new AccessException(UserName, "Insert");
}
AccessObject accessObject = new AccessObject(trans.Connection.ConnectionString);
accessObject.Id = Guid.NewGuid();
accessObject.Name = Name;
accessObject.ObjectTypeId = ObjectTypeID;
accessObject.ObjectStateId = StateIDAll;
ObjectID = accessObject.Insert(trans);
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].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.Insert, prms);
}
else
{
SPHelper.ExecuteNonQuery(trans, SpNames.Insert, prms);
}
ID = (int)prms[0].Value;
return(ID);
}
public int Insert(SqlTransaction trans)
{
AccessObject accessObject = new AccessObject(trans.Connection.ConnectionString);
accessObject.Id = Guid.NewGuid();
accessObject.Name = Name;
accessObject.ObjectTypeId = ObjectTypeID;
accessObject.ObjectStateId = StateIDAll;
ObjectID = accessObject.Insert(trans);
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].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.Insert, prms);
}
else
{
SPHelper.ExecuteNonQuery(trans, SpNames.Insert, prms);
}
ID = (int)prms[0].Value;
return(ID);
}
public int Insert(SqlTransaction trans)
{
/*if (!CanInsert(UserName, DepartmentID))
* {
* throw new AccessException(UserName, "Insert");
* }
*/
AccessObject accessObject = new AccessObject(trans.Connection.ConnectionString);
accessObject.Id = Guid.NewGuid();
accessObject.Name = Number;
accessObject.ObjectTypeId = ObjectTypeID;
accessObject.ObjectStateId = StateIDAll;
ObjectID = accessObject.Insert(trans);
SqlParameter[] prms = new SqlParameter[15];
prms[0] = new SqlParameter("@DocumentID", SqlDbType.Int);
prms[0].Direction = ParameterDirection.Output;
prms[1] = new SqlParameter("@DocumentCodeID", SqlDbType.Int);
prms[1].Value = CodeID;
prms[2] = new SqlParameter("@CreationDate", SqlDbType.DateTime);
prms[2].Value = CreationDate;
prms[3] = new SqlParameter("@OriginatorID", SqlDbType.UniqueIdentifier);
prms[3].Value = OriginatorID;
prms[4] = new SqlParameter("@RequestDate", SqlDbType.DateTime);
prms[4].Value = RequestDate;
prms[5] = new SqlParameter("@RequestorID", SqlDbType.UniqueIdentifier);
prms[5].Value = RequestorID;
prms[6] = new SqlParameter("@OwnerID", SqlDbType.UniqueIdentifier);
prms[6].Value = OwnerID;
prms[7] = new SqlParameter("@ObjectID", SqlDbType.UniqueIdentifier);
prms[7].Value = ObjectID;
prms[8] = new SqlParameter("@Number", SqlDbType.NVarChar, 50);
prms[8].Value = Number;
prms[9] = new SqlParameter("@Notes", SqlDbType.NVarChar, -1);
prms[9].Value = Notes;
prms[10] = new SqlParameter("@DocStatusID", SqlDbType.Int);
prms[10].Value = DocStatusID;
prms[11] = new SqlParameter("@DepartmentID", SqlDbType.Int);
prms[11].Value = DepartmentID;
prms[12] = new SqlParameter("@TemplateId", SqlDbType.Int);
prms[12].Value = TemplateId;
prms[13] = new SqlParameter("@ParentDocumentID", SqlDbType.Int);
prms[13].IsNullable = true;
if (ParentDocumentID > 0)
{
prms[13].Value = ParentDocumentID;
}
else
{
prms[13].Value = DBNull.Value;
}
prms[14] = new SqlParameter("@DocStateID", SqlDbType.Int);
prms[14].Value = DocStateID;
if (trans == null)
{
SPHelper.ExecuteNonQuery(SpNames.Insert, prms);
}
else
{
SPHelper.ExecuteNonQuery(trans, SpNames.Insert, prms);
}
ID = (int)prms[0].Value;
return(ID);
}