public virtual bool SetPhotoByUuidByExternalId(Photo obj)
{
return act.SetPhotoByUuidByExternalId(DEFAULT_SET_TYPE, obj);
}
//------------------------------------------------------------------------------
public virtual bool SetPhotoByUuidByExternalId(string set_type, Photo obj)
{
return act.SetPhotoByUuidByExternalId(set_type, obj);
}
public virtual bool SetPhotoByUuidByExternalId(SetType set_type, Photo obj)
{
return act.SetPhotoByUuidByExternalId(ConvertSetTypeToString(set_type), obj);
}
public virtual bool SetPhotoByUrl(SetType set_type, Photo obj)
{
return act.SetPhotoByUrl(ConvertSetTypeToString(set_type), obj);
}
public virtual bool SetPhotoByUrl(Photo obj)
{
return act.SetPhotoByUrl(DEFAULT_SET_TYPE, obj);
}
//------------------------------------------------------------------------------
public virtual bool SetPhotoByUuidByExternalId(string set_type, Photo obj)
{
List<SqlParameter> parameters
= new List<SqlParameter>();
parameters.Add(new SqlParameter("@set_type", set_type));
parameters.Add(new SqlParameter("@status", obj.status));
parameters.Add(new SqlParameter("@third_party_oembed", obj.third_party_oembed));
parameters.Add(new SqlParameter("@code", obj.code));
parameters.Add(new SqlParameter("@display_name", obj.display_name));
parameters.Add(new SqlParameter("@name", obj.name));
parameters.Add(new SqlParameter("@date_modified", obj.date_modified));
parameters.Add(new SqlParameter("@url", obj.url));
parameters.Add(new SqlParameter("@third_party_data", obj.third_party_data));
parameters.Add(new SqlParameter("@uuid", obj.uuid));
parameters.Add(new SqlParameter("@data", obj.data));
parameters.Add(new SqlParameter("@third_party_url", obj.third_party_url));
parameters.Add(new SqlParameter("@third_party_id", obj.third_party_id));
parameters.Add(new SqlParameter("@content_type", obj.content_type));
parameters.Add(new SqlParameter("@external_id", obj.external_id));
parameters.Add(new SqlParameter("@active", obj.active));
parameters.Add(new SqlParameter("@date_created", obj.date_created));
parameters.Add(new SqlParameter("@type", obj.type));
parameters.Add(new SqlParameter("@description", obj.description));
try {
return (bool)data.ExecuteScalar(
BasePlatformData.connectionString
, CommandType.StoredProcedure
, "usp_photo_set_by_uuid_by_external_id"
, parameters
);
}
catch (Exception e){
log.Error(e);
return false;
}
}
//------------------------------------------------------------------------------
public virtual bool SetPhotoByUrl(string set_type, Photo obj)
{
return act.SetPhotoByUrl(set_type, obj);
}
//------------------------------------------------------------------------------
public virtual void SetPhotoByUuidByExternalId()
{
ResponsePhotoBool wrapper = new ResponsePhotoBool();
wrapper.message = "Success";
wrapper.code = 0;
wrapper.action = "photo/set/by-uuid/by-external-id";
Photo obj = new Photo();
string _status = util.GetParamValue(_context, "status");
if(!String.IsNullOrEmpty(_status))
obj.status = (string)_status;
string _third_party_oembed = util.GetParamValue(_context, "third_party_oembed");
if(!String.IsNullOrEmpty(_third_party_oembed))
obj.third_party_oembed = (string)_third_party_oembed;
string _code = util.GetParamValue(_context, "code");
if(!String.IsNullOrEmpty(_code))
obj.code = (string)_code;
string _display_name = util.GetParamValue(_context, "display_name");
if(!String.IsNullOrEmpty(_display_name))
obj.display_name = (string)_display_name;
string _name = util.GetParamValue(_context, "name");
if(!String.IsNullOrEmpty(_name))
obj.name = (string)_name;
string _date_modified = util.GetParamValue(_context, "date_modified");
if(!String.IsNullOrEmpty(_date_modified))
obj.date_modified = Convert.ToDateTime(_date_modified);
else
obj.date_modified = DateTime.Now;
string _url = util.GetParamValue(_context, "url");
if(!String.IsNullOrEmpty(_url))
obj.url = (string)_url;
string _third_party_data = util.GetParamValue(_context, "third_party_data");
if(!String.IsNullOrEmpty(_third_party_data))
obj.third_party_data = (string)_third_party_data;
string _uuid = util.GetParamValue(_context, "uuid");
if(!String.IsNullOrEmpty(_uuid))
obj.uuid = (string)_uuid;
string _data = util.GetParamValue(_context, "data");
if(!String.IsNullOrEmpty(_data))
obj.data = (string)_data;
string _third_party_url = util.GetParamValue(_context, "third_party_url");
if(!String.IsNullOrEmpty(_third_party_url))
obj.third_party_url = (string)_third_party_url;
string _third_party_id = util.GetParamValue(_context, "third_party_id");
if(!String.IsNullOrEmpty(_third_party_id))
obj.third_party_id = (string)_third_party_id;
string _content_type = util.GetParamValue(_context, "content_type");
if(!String.IsNullOrEmpty(_content_type))
obj.content_type = (string)_content_type;
string _external_id = util.GetParamValue(_context, "external_id");
if(!String.IsNullOrEmpty(_external_id))
obj.external_id = (string)_external_id;
string _active = util.GetParamValue(_context, "active");
if(!String.IsNullOrEmpty(_active))
obj.active = Convert.ToBoolean(_active);
string _date_created = util.GetParamValue(_context, "date_created");
if(!String.IsNullOrEmpty(_date_created))
obj.date_created = Convert.ToDateTime(_date_created);
else
obj.date_created = DateTime.Now;
string _type = util.GetParamValue(_context, "type");
if(!String.IsNullOrEmpty(_type))
obj.type = (string)_type;
string _description = util.GetParamValue(_context, "description");
if(!String.IsNullOrEmpty(_description))
obj.description = (string)_description;
// get data
wrapper.data = api.SetPhotoByUuidByExternalId(obj);
util.SerializeTypeJSONToResponse(_context, wrapper);
}
//------------------------------------------------------------------------------
public virtual bool SetPhotoByUuid(string set_type, Photo obj)
{
List<NpgsqlParameter> parameters
= new List<NpgsqlParameter>();
parameters.Add(new NpgsqlParameter("in_set_type", set_type));
parameters.Add(new NpgsqlParameter("in_status", obj.status));
parameters.Add(new NpgsqlParameter("in_third_party_oembed", obj.third_party_oembed));
parameters.Add(new NpgsqlParameter("in_code", obj.code));
parameters.Add(new NpgsqlParameter("in_display_name", obj.display_name));
parameters.Add(new NpgsqlParameter("in_name", obj.name));
parameters.Add(new NpgsqlParameter("in_date_modified", obj.date_modified));
parameters.Add(new NpgsqlParameter("in_url", obj.url));
parameters.Add(new NpgsqlParameter("in_third_party_data", obj.third_party_data));
parameters.Add(new NpgsqlParameter("in_uuid", obj.uuid));
parameters.Add(new NpgsqlParameter("in_data", obj.data));
parameters.Add(new NpgsqlParameter("in_third_party_url", obj.third_party_url));
parameters.Add(new NpgsqlParameter("in_third_party_id", obj.third_party_id));
parameters.Add(new NpgsqlParameter("in_content_type", obj.content_type));
parameters.Add(new NpgsqlParameter("in_external_id", obj.external_id));
parameters.Add(new NpgsqlParameter("in_active", obj.active));
parameters.Add(new NpgsqlParameter("in_date_created", obj.date_created));
parameters.Add(new NpgsqlParameter("in_type", obj.type));
parameters.Add(new NpgsqlParameter("in_description", obj.description));
try {
return Convert.ToBoolean(data.ExecuteScalar(
BasePlatformData.connectionString
, CommandType.StoredProcedure
, "usp_photo_set_uuid"
, parameters
));
}
catch (Exception e){
log.Error(e);
return false;
}
}
public virtual bool SetPhotoByUuid(string set_type, Photo obj)
{
return data.SetPhotoByUuid(set_type, obj);
}
public virtual bool SetPhotoByUrlByExternalId(string set_type, Photo obj)
{
return data.SetPhotoByUrlByExternalId(set_type, obj);
}
public virtual Photo FillPhoto(DataRow dr)
{
Photo obj = new Photo();
if (dr["status"] != null)
obj.status = dataType.FillDataString(dr, "status");
if (dr["third_party_oembed"] != null)
obj.third_party_oembed = dataType.FillDataString(dr, "third_party_oembed");
if (dr["code"] != null)
obj.code = dataType.FillDataString(dr, "code");
if (dr["display_name"] != null)
obj.display_name = dataType.FillDataString(dr, "display_name");
if (dr["name"] != null)
obj.name = dataType.FillDataString(dr, "name");
if (dr["date_modified"] != null)
obj.date_modified = dataType.FillDataDateTime(dr, "date_modified");
if (dr["url"] != null)
obj.url = dataType.FillDataString(dr, "url");
if (dr["third_party_data"] != null)
obj.third_party_data = dataType.FillDataString(dr, "third_party_data");
if (dr["uuid"] != null)
obj.uuid = dataType.FillDataString(dr, "uuid");
if (dr["data"] != null)
obj.data = dataType.FillDataString(dr, "data");
if (dr["third_party_url"] != null)
obj.third_party_url = dataType.FillDataString(dr, "third_party_url");
if (dr["third_party_id"] != null)
obj.third_party_id = dataType.FillDataString(dr, "third_party_id");
if (dr["content_type"] != null)
obj.content_type = dataType.FillDataString(dr, "content_type");
if (dr["external_id"] != null)
obj.external_id = dataType.FillDataString(dr, "external_id");
if (dr["active"] != null)
obj.active = dataType.FillDataBool(dr, "active");
if (dr["date_created"] != null)
obj.date_created = dataType.FillDataDateTime(dr, "date_created");
if (dr["type"] != null)
obj.type = dataType.FillDataString(dr, "type");
if (dr["description"] != null)
obj.description = dataType.FillDataString(dr, "description");
return obj;
}