public void Post(EbObjectChangeStatusRequest request)
{
ILog log = LogManager.GetLogger(GetType());
log.Info("#DS Change status");
try
{
using (var con = this.TenantDbFactory.ObjectsDB.GetNewConnection())
{
con.Open();
DbCommand cmd = null;
log.Info("#DS insert 1 -- con open");
string sql = "SELECT eb_objects_change_status(@id, @status, @commit_uid, @obj_changelog)";
cmd = this.TenantDbFactory.ObjectsDB.GetNewCommand(con, sql);
cmd.Parameters.Add(this.TenantDbFactory.ObjectsDB.GetNewParameter("@id", System.Data.DbType.String, request.RefId));
cmd.Parameters.Add(this.TenantDbFactory.ObjectsDB.GetNewParameter("@status", System.Data.DbType.Int32, (int)request.Status));
cmd.Parameters.Add(this.TenantDbFactory.ObjectsDB.GetNewParameter("@commit_uid", System.Data.DbType.Int32, request.UserId));
cmd.Parameters.Add(this.TenantDbFactory.ObjectsDB.GetNewParameter("@obj_changelog", System.Data.DbType.String, request.ChangeLog));
cmd.ExecuteScalar();
}
}
catch (Exception e)
{
}
}
public string ChangeStatus(string _refid, string _changelog, string _status)
{
var ds = new EbObjectChangeStatusRequest();
ds.RefId = _refid;
ds.Status = (ObjectLifeCycleStatus)Enum.Parse(typeof(ObjectLifeCycleStatus), _status);
ds.ChangeLog = _changelog;
var res = this.ServiceClient.Post <EbObjectChangeStatusResponse>(ds);
return("success");
}