JsonResult IUser.Save(Models.Dto.MUser obj, ref ValidationError validationError)
{
throw new NotImplementedException();
}
JsonResult IBase <MUser> .Save(Models.Dto.MUser obj)
{
JsonResult hasil = new JsonResult {
JSONResult = false, JSONMessage = "Data tidak ditemukan", JSONRows = 0, JSONValue = null
};
List <MUser> list = new List <MUser>();
using (NpgsqlConnection conn = GetConnection())
{
using (NpgsqlCommand com = new NpgsqlCommand())
{
using (NpgsqlDataAdapter oDA = new NpgsqlDataAdapter())
{
try
{
conn.Open();
com.Connection = conn;
com.CommandTimeout = conn.ConnectionTimeout;
com.Transaction = com.Connection.BeginTransaction();
com.CommandText = "insert into muser (id,userid,pwd,nama,idkontak,idrole)" +
"values (@id,@userid,@pwd,@nama,@idkontak,@idrole)";
com.Parameters.Clear();
com.Parameters.Add("@id", NpgsqlTypes.NpgsqlDbType.Bigint).Value = obj.id;
com.Parameters.Add("@userid", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.userid.ToUpper().Trim();
com.Parameters.Add("@pwd", NpgsqlTypes.NpgsqlDbType.Varchar).Value = RepUtils.CreateMD5(obj.pwd.ToUpper().Trim());
com.Parameters.Add("@nama", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.nama.Trim();
com.Parameters.Add("@idkontak", NpgsqlTypes.NpgsqlDbType.Integer).Value = obj.idkontak;
com.Parameters.Add("@idrole", NpgsqlTypes.NpgsqlDbType.Integer).Value = obj.idrole;
com.ExecuteNonQuery();
//cek data sudah ada atau belum
com.CommandText = "select id from mkontak where right(upper(hp), LENGTH(upper(hp))-2) = @hp LIMIT 1";
com.Parameters.Clear();
com.Parameters.AddWithValue("@hp", obj.userid.ToUpper());
long jml = RepUtils.NullToLong(com.ExecuteScalar());
if (jml == 0)
{
com.CommandText = "select max(id) from mkontak";
jml = RepUtils.NullToLong(com.ExecuteScalar()) + 1;
com.CommandText = "insert into mkontak (id,kode,nama,alamat1,alamat2,alamat3,hp,telpon,iswhatsapp,norekening,bank,atasnamarekening)" +
"values (@id,@kode,@nama,@alamat1,@alamat2,@alamat3,@hp,@telpon,@iswhatsapp,@norekening,@bank,@atasnamarekening)";
com.Parameters.Clear();
com.Parameters.Add("@id", NpgsqlTypes.NpgsqlDbType.Bigint).Value = jml;
com.Parameters.Add("@kode", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.userid.ToUpper().Trim();
com.Parameters.Add("@nama", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.nama.Trim();
com.Parameters.Add("@alamat1", NpgsqlTypes.NpgsqlDbType.Varchar).Value = "";
com.Parameters.Add("@alamat2", NpgsqlTypes.NpgsqlDbType.Varchar).Value = "";
com.Parameters.Add("@alamat3", NpgsqlTypes.NpgsqlDbType.Varchar).Value = "";
com.Parameters.Add("@hp", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.userid.ToUpper();
com.Parameters.Add("@telpon", NpgsqlTypes.NpgsqlDbType.Varchar).Value = "";
com.Parameters.Add("@bank", NpgsqlTypes.NpgsqlDbType.Varchar).Value = "";
com.Parameters.Add("@iswhatsapp", NpgsqlTypes.NpgsqlDbType.Bit).Value = false;
com.Parameters.Add("@norekening", NpgsqlTypes.NpgsqlDbType.Varchar).Value = "";
com.Parameters.Add("@atasnamarekening", NpgsqlTypes.NpgsqlDbType.Varchar).Value = "";
com.ExecuteNonQuery();
}
obj.idkontak = jml;
com.CommandText = "update muser set idkontak=@idkontak where id=@id";
com.Parameters.Clear();
com.Parameters.AddWithValue("@idkontak", obj.idkontak);
com.Parameters.AddWithValue("@id", obj.id);
com.ExecuteNonQuery();
com.Transaction.Commit();
hasil = new JsonResult
{
JSONMessage = "Data tersimpan",
JSONResult = true,
JSONRows = 1,
JSONValue = obj
};
}
catch (Exception ex)
{
hasil = new JsonResult
{
JSONMessage = ex.Message,
JSONResult = false,
JSONRows = 0,
JSONValue = ex
};
}
}
}
}
return(hasil);
}
JsonResult IBase <MUser> .Delete(Models.Dto.MUser obj)
{
throw new NotImplementedException();
}
