示例#1
0
        public JsonResult Delete(MMenu obj, MUser user)
        {
            JsonResult jsonResult = new JsonResult();

            if (user != null && user.id >= 1)
            {
                using (NpgsqlConnection con = new NpgsqlConnection(StrKon))
                {
                    using (NpgsqlCommand com = new NpgsqlCommand("", con))
                    {
                        using (NpgsqlDataAdapter oDA = new NpgsqlDataAdapter(com))
                        {
                            try
                            {
                                con.Open();
                                com.CommandTimeout = con.ConnectionTimeout;
                                com.Transaction    = com.Connection.BeginTransaction();

                                com.CommandText = "update mmenu set aktif=0 where id=@id";
                                com.Parameters.Clear();
                                com.Parameters.AddWithValue("@id", obj.id);
                                com.ExecuteNonQuery();

                                jsonResult.JSONMessage = "Data menu id=" + obj.id + " dihapus";
                                jsonResult.JSONResult  = true;
                                jsonResult.JSONRows    = 1;
                                jsonResult.JSONValue   = obj;

                                Repository.RepLogData.insertLog(com,
                                                                Newtonsoft.Json.JsonConvert.SerializeObject(user, formatting),
                                                                Newtonsoft.Json.JsonConvert.SerializeObject(jsonResult, formatting));

                                jsonResult.JSONMessage = "Data berhasil dihapus";
                                jsonResult.JSONResult  = true;
                                jsonResult.JSONRows    = 0;
                                jsonResult.JSONValue   = null;

                                com.Transaction.Commit();
                            }
                            catch (Exception e)
                            {
                                jsonResult.JSONMessage = "ERR : " + e.Message;
                                jsonResult.JSONResult  = false;
                                jsonResult.JSONRows    = 0;
                                jsonResult.JSONValue   = null;
                            }
                        }
                    }
                }
            }
            else
            {
                jsonResult.JSONMessage = "User untuk hapus data harus diisi";
                jsonResult.JSONResult  = false;
                jsonResult.JSONRows    = 0;
                jsonResult.JSONValue   = null;
            }

            return(jsonResult);
        }
示例#2
0
        public JsonResult Update(MMenu obj, MUser user)
        {
            JsonResult jsonResult = new JsonResult();
            bool       validasi   = true;

            if (user != null && user.id >= 1)
            {
                using (NpgsqlConnection con = new NpgsqlConnection(StrKon))
                {
                    using (NpgsqlCommand com = new NpgsqlCommand("", con))
                    {
                        using (NpgsqlDataAdapter oDA = new NpgsqlDataAdapter(com))
                        {
                            try
                            {
                                con.Open();
                                com.CommandTimeout = con.ConnectionTimeout;
                                com.Transaction    = com.Connection.BeginTransaction();

                                if (validasi)
                                {
                                    if (obj.name.Length <= 0)
                                    {
                                        jsonResult.JSONMessage = "Data name yang anda masukkan harus terisi.";
                                        validasi = false;
                                    }
                                }
                                if (validasi)
                                {
                                    if (obj.caption.Length <= 0)
                                    {
                                        jsonResult.JSONMessage = "Data caption yang anda masukkan harus terisi.";
                                        validasi = false;
                                    }
                                }
                                if (validasi)
                                {
                                    if (obj.idparent < -1 || obj.idparent == 0)
                                    {
                                        jsonResult.JSONMessage = "Data parent yang anda masukkan harus terisi.";
                                        validasi = false;
                                    }
                                }
                                if (validasi)
                                {
                                    com.CommandText = "select count(id) from mmenu where id<>@id and upper(name)=@name or upper(caption)=@caption";
                                    com.Parameters.Clear();
                                    com.Parameters.AddWithValue("@name", obj.name.ToUpper());
                                    com.Parameters.AddWithValue("@caption", obj.caption.ToUpper());
                                    if ((long)com.ExecuteScalar() >= 1)
                                    {
                                        jsonResult.JSONMessage = "Data name atau caption yang anda masukkan sudah terdaftar.";
                                        validasi = false;
                                    }
                                }
                                //Validasi done

                                com.CommandText = "update mmenu set idparent=@idparent, nourut=@nourut, name=@name, caption=@caption, isbig=@isbig, isbegingroup=@isbegingroup, aktif=@aktif where id=@id";
                                com.Parameters.Clear();
                                com.Parameters.AddWithValue("@id", obj.id);
                                com.Parameters.AddWithValue("@idparent", obj.idparent);
                                com.Parameters.AddWithValue("@nourut", obj.nourut);
                                com.Parameters.AddWithValue("@name", obj.name);
                                com.Parameters.AddWithValue("@caption", obj.caption);
                                com.Parameters.AddWithValue("@isbig", obj.isbig);
                                com.Parameters.AddWithValue("@isbegingroup", obj.isbegingroup);
                                com.Parameters.AddWithValue("@aktif", obj.aktif);
                                com.ExecuteNonQuery();

                                jsonResult.JSONMessage = "Data menu id=" + obj.id + " ditambahkan";
                                jsonResult.JSONResult  = true;
                                jsonResult.JSONRows    = 1;
                                jsonResult.JSONValue   = obj;

                                Repository.RepLogData.insertLog(com,
                                                                Newtonsoft.Json.JsonConvert.SerializeObject(user, formatting),
                                                                Newtonsoft.Json.JsonConvert.SerializeObject(jsonResult, formatting));

                                jsonResult.JSONMessage = "Data berhasil diupdate";
                                jsonResult.JSONResult  = true;
                                jsonResult.JSONRows    = 0;
                                jsonResult.JSONValue   = null;

                                com.Transaction.Commit();
                            }
                            catch (Exception e)
                            {
                                jsonResult.JSONMessage = "ERR : " + e.Message;
                                jsonResult.JSONResult  = false;
                                jsonResult.JSONRows    = 0;
                                jsonResult.JSONValue   = null;
                            }
                        }
                    }
                }
            }
            else
            {
                jsonResult.JSONMessage = "User untuk update data harus diisi";
                jsonResult.JSONResult  = false;
                jsonResult.JSONRows    = 0;
                jsonResult.JSONValue   = null;
            }

            return(jsonResult);
        }