//------------------------------------------------------------------------------
public virtual bool SetProfileByUuid(string set_type, Profile 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("@username", obj.username));
parameters.Add(new SqlParameter("@first_name", obj.first_name));
parameters.Add(new SqlParameter("@last_name", obj.last_name));
parameters.Add(new SqlParameter("@hash", obj.hash));
parameters.Add(new SqlParameter("@uuid", obj.uuid));
parameters.Add(new SqlParameter("@date_modified", obj.date_modified));
parameters.Add(new SqlParameter("@active", obj.active));
parameters.Add(new SqlParameter("@date_created", obj.date_created));
parameters.Add(new SqlParameter("@email", obj.email));
parameters.Add(new SqlParameter("@name", obj.name));
try {
return (bool)data.ExecuteScalar(
BaseProfileData.connectionString
, CommandType.StoredProcedure
, "usp_profile_set_by_uuid"
, parameters
);
}
catch (Exception e){
log.Error(e);
return false;
}
}
//------------------------------------------------------------------------------
public virtual void SetProfileByUuid()
{
ResponseProfileBool wrapper = new ResponseProfileBool();
wrapper.message = "Success";
wrapper.code = 0;
wrapper.action = "profile/set/by-uuid";
Profile obj = new Profile();
string _status = util.GetParamValue(_context, "status");
if(!String.IsNullOrEmpty(_status))
obj.status = (string)_status;
string _username = util.GetParamValue(_context, "username");
if(!String.IsNullOrEmpty(_username))
obj.username = (string)_username;
string _first_name = util.GetParamValue(_context, "first_name");
if(!String.IsNullOrEmpty(_first_name))
obj.first_name = (string)_first_name;
string _last_name = util.GetParamValue(_context, "last_name");
if(!String.IsNullOrEmpty(_last_name))
obj.last_name = (string)_last_name;
string _hash = util.GetParamValue(_context, "hash");
if(!String.IsNullOrEmpty(_hash))
obj.hash = (string)_hash;
string _uuid = util.GetParamValue(_context, "uuid");
if(!String.IsNullOrEmpty(_uuid))
obj.uuid = (string)_uuid;
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 _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 _email = util.GetParamValue(_context, "email");
if(!String.IsNullOrEmpty(_email))
obj.email = (string)_email;
string _name = util.GetParamValue(_context, "name");
if(!String.IsNullOrEmpty(_name))
obj.name = (string)_name;
// get data
wrapper.data = api.SetProfileByUuid(obj);
util.SerializeTypeJSONToResponse(_context, wrapper);
}
//------------------------------------------------------------------------------
public virtual bool SetProfileByUuid(string set_type, Profile 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_username", obj.username));
parameters.Add(new NpgsqlParameter("in_first_name", obj.first_name));
parameters.Add(new NpgsqlParameter("in_last_name", obj.last_name));
parameters.Add(new NpgsqlParameter("in_hash", obj.hash));
parameters.Add(new NpgsqlParameter("in_uuid", obj.uuid));
parameters.Add(new NpgsqlParameter("in_date_modified", obj.date_modified));
parameters.Add(new NpgsqlParameter("in_active", obj.active));
parameters.Add(new NpgsqlParameter("in_date_created", obj.date_created));
parameters.Add(new NpgsqlParameter("in_email", obj.email));
parameters.Add(new NpgsqlParameter("in_name", obj.name));
try {
return Convert.ToBoolean(data.ExecuteScalar(
BaseProfileData.connectionString
, CommandType.StoredProcedure
, "usp_profile_set_uuid"
, parameters
));
}
catch (Exception e){
log.Error(e);
return false;
}
}
public virtual bool SetProfileByUuid(Profile obj)
{
return act.SetProfileByUuid(DEFAULT_SET_TYPE, obj);
}
public virtual bool SetProfileByUuid(SetType set_type, Profile obj)
{
return act.SetProfileByUuid(ConvertSetTypeToString(set_type), obj);
}
//------------------------------------------------------------------------------
public virtual bool SetProfileByUuid(string set_type, Profile obj)
{
return act.SetProfileByUuid(set_type, obj);
}
public virtual Profile FillProfile(DataRow dr)
{
Profile obj = new Profile();
if (dr["status"] != null)
obj.status = dataType.FillDataString(dr, "status");
if (dr["username"] != null)
obj.username = dataType.FillDataString(dr, "username");
if (dr["first_name"] != null)
obj.first_name = dataType.FillDataString(dr, "first_name");
if (dr["last_name"] != null)
obj.last_name = dataType.FillDataString(dr, "last_name");
if (dr["hash"] != null)
obj.hash = dataType.FillDataString(dr, "hash");
if (dr["uuid"] != null)
obj.uuid = dataType.FillDataString(dr, "uuid");
if (dr["date_modified"] != null)
obj.date_modified = dataType.FillDataDateTime(dr, "date_modified");
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["email"] != null)
obj.email = dataType.FillDataString(dr, "email");
if (dr["name"] != null)
obj.name = dataType.FillDataString(dr, "name");
return obj;
}
public virtual bool SetProfileByUsername(string set_type, Profile obj)
{
return data.SetProfileByUsername(set_type, obj);
}
