Пример #1
0
 private void frmPenanggungjawabRakUpdate_FormClosed(object sender, FormClosedEventArgs e)
 {
     if (this.DialogResult == DialogResult.OK)
     {
         if (this.Caller is frmPenanggungjawabRakBrowse)
         {
             frmPenanggungjawabRakBrowse frmCaller = (frmPenanggungjawabRakBrowse)this.Caller;
             frmCaller.RefreshDataPJ();
             frmCaller.FindDetail("RowID", _rowID.ToString());
         }
     }
 }
Пример #2
0
        private void cmdSave_Click(object sender, EventArgs e)
        {
            //try
            //{
            switch (formMode)
            {
            case enumFormMode.New:

                try
                {
                    _rowID = Guid.NewGuid();
                    using (Database db = new Database())
                    {
                        DataTable dt = new DataTable();
                        db.Commands.Add(db.CreateCommand("usp_PenanggungjawabRak_INSERT"));
                        db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, _rowID));
                        db.Commands[0].Parameters.Add(new Parameter("@KodeRak", SqlDbType.VarChar, _kode));
                        db.Commands[0].Parameters.Add(new Parameter("@Nama", SqlDbType.VarChar, cboNama.SelectedValue));
                        db.Commands[0].Parameters.Add(new Parameter("@TglTransaksi", SqlDbType.DateTime, txtTgl.Text));
                        db.Commands[0].Parameters.Add(new Parameter("@lastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID));
                        db.Commands[0].ExecuteNonQuery();
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
                break;

            case enumFormMode.Update:
                try
                {
                    using (Database db = new Database())
                    {
                        DataTable dt = new DataTable();
                        db.Commands.Add(db.CreateCommand("usp_PenanggungjawabRak_UPDATE"));
                        db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, _rowID));
                        db.Commands[0].Parameters.Add(new Parameter("@KodeRak", SqlDbType.VarChar, _kode));
                        db.Commands[0].Parameters.Add(new Parameter("@Nama", SqlDbType.VarChar, cboNama.SelectedValue));
                        db.Commands[0].Parameters.Add(new Parameter("@TglTransaksi", SqlDbType.DateTime, txtTgl.Text));
                        db.Commands[0].Parameters.Add(new Parameter("@lastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID));
                        db.Commands[0].ExecuteNonQuery();
                    }
                }
                catch (Exception ex)
                {
                    Error.LogError(ex);
                }
                break;
            }
            MessageBox.Show("Data telah tersimpan");
            this.DialogResult = DialogResult.OK;
            frmPenanggungjawabRakBrowse frmCaller = (frmPenanggungjawabRakBrowse)this.Caller;

            frmCaller.RefreshDataPJ();
            this.Close();
            frmCaller.Show();

            //}
            //catch (Exception ex)
            //{
            //    MessageBox.Show(ex.Message);
            //    //Error.LogError(ex);
            //}
        }