public Int32 SaveAzDocRelRequest(AzDocRelRequestEntity ent) { Int32 requestId = 0; using (var cmd = eaSql.CreateDbCommandWriter(UPDATE_AZ_DOC_REL_REQUEST, CommandType.StoredProcedure)) { cmd.AddInParam("PI_DOC_ID", DbType.Int32, ent.DocId); cmd.AddInParam("PI_TYPE_ID", DbType.Int32, ent.TypeId); cmd.AddInParam("PI_SUBTYPE_ID", DbType.Int32, ent.SubtypeId); cmd.AddInParam("PI_PROPERTY_TYPE_ID", DbType.Int32, ent.PropertyTypeId); cmd.AddInParam("PI_APPROVAL_ID", DbType.Int32, ent.ApprovalId); cmd.AddInParam("PI_COMMENTS", DbType.String, ent.Comments); cmd.AddInParam("PI_STATUS_ID", DbType.Int32, ent.StatusId); cmd.AddInParam("PI_REASON_TXT", DbType.String, ent.ReasonTxt); cmd.AddInParam("PI_DOCUMENT_ID", DbType.Int32, ent.DocumentId); cmd.AddInParam("PI_REQUEST_DTM", DbType.DateTime, ent.RequestDtm); cmd.AddInParam("PI_EXPIRATION_DTM", DbType.DateTime, ent.ExpirationDtm); cmd.AddInParam("PI_PENDING_NOTIFICATION", DbType.StringFixedLength, ent.PendingNotification.ToChar()); cmd.AddInParam("PI_UPDT_USERID", DbType.Int32, ent.UpdtUserid); cmd.AddInParam("PI_UPDT_DTM", DbType.DateTime, ent.UpdtDtm); cmd.AddInParam("PI_CHANGE_ID", DbType.Int32, ent.ChangeId); cmd.AddOutParam("PO_REQUEST_ID", DbType.Int32, 4); helper.ExecuteNonQuery(cmd); requestId = Convert.ToInt32(cmd.GetParamValue("PO_REQUEST_ID").ToString()); } return(requestId); }
public AzDocRelRequestEntity GetAzDocRelRequest(Int32 requestId) { var ent = new AzDocRelRequestEntity(); using (var cmd = eaSql.CreateDbCommandWriter(GET_AZ_DOC_REL_REQUEST, CommandType.StoredProcedure)) { cmd.AddInParam("PI_REQUEST_ID", DbType.Int32, requestId); using (var ds = new DataSet()) { helper.LoadDataSet(cmd, ds, "Results"); DataTable dt = ds.Tables["Results"]; if (dt.Rows.Count > 0) { ent.MapFromRow(dt.Rows[0]); } } } return(ent); }
public List <AzDocRelRequestEntity> GetAllAzDocRelRequest(Int32 docId) { var list = new List <AzDocRelRequestEntity>(); using (var cmd = eaSql.CreateDbCommandWriter(GET_ALL_AZ_DOC_REL_REQUEST, CommandType.StoredProcedure)) { cmd.AddInParam("PI_DOC_ID", DbType.Int32, docId); using (var ds = new DataSet()) { helper.LoadDataSet(cmd, ds, "Results"); DataTable dt = ds.Tables["Results"]; foreach (DataRow dr in dt.Rows) { var item = new AzDocRelRequestEntity(); item.MapFromRow(dr); list.Add(item); } } return(list); } }