Esempio n. 1
0
        //fungsi: Handle Ketika data pada database telah ditambahkan
        protected void dsPunishmentEdit_Inserted(object sender, System.Web.UI.WebControls.SqlDataSourceStatusEventArgs e)
        {
            //Seleksi apakah terjadi error atau tidak
            //jika tidak ada record yang ter insert maka terjadi error
            if (e.AffectedRows == 0)
            {
                ExceptionDetails.Text = lblCannotUpdate.Text;     //& " (" & e.Exception.Message & ")"
                e.ExceptionHandled    = true;
                if (!isEntrySambung())
                {
                    setInitialComponent();
                }
            }
            else
            {
                //Catat ke Log
                rtwin.azlib.AddUserAct(Session["UserID"].ToString(), "2431", e.Command.Parameters["@NIP"].Value.ToString() + "," + e.Command.Parameters["@TGL_AWAL"].Value.ToString(), Application["strCn"].ToString());
                ExceptionDetails.Text = "Data telah di simpan";

                GvPunishment.DataBind();
                setInitialComponent();
            }

            if (!isEntrySambung())
            {
                showGridView(true);
            }
        }
Esempio n. 2
0
 //fungsi: Refresh GridView
 protected void btnRefresh_Click(object sender, EventArgs e)
 {
     if (Page.IsValid)
     {
         //update ke grid
         GvPunishment.DataBind();
     }
 }
Esempio n. 3
0
        protected void GvPunishment_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            if (e.CommandName == "Show")
            {
                if (Page.IsValid)
                {
                    GridViewRow row = (GridViewRow)((LinkButton)e.CommandSource).NamingContainer;
                    GvPunishment.SelectedIndex = row.RowIndex;
                    GvPunishment.DataBind();
                    string sTahun;
                    if (ddlTahun.Text == DateTime.Now.Year.ToString())
                    {
                        sTahun = azlib.FirstDate(DateTime.Now, "en").ToString();
                    }
                    else
                    {
                        sTahun = "'1/1/" + Convert.ToString(Convert.ToInt32(ddlTahun.Text) + 1) + "'";
                    }
                    dsMangkir.SelectCommand = "select TGL_MASUK from q_AbsenHarianDetil where MANGKIR = 1 AND PIN = '" + ((LinkButton)row.Cells[0].FindControl("lnkCol0Item")).Text + "' AND TGL_MASUK >= '1/1/" + ddlTahun.Text + "' AND TGL_MASUK < '" + sTahun + "'";
                    dsMangkir.DataBind();
                    lblTitleRincianMangkir.Text    = "Rincian ketidakhadiran PIN " + ((LinkButton)row.Cells[0].FindControl("lnkCol0Item")).Text;
                    lblTitleRincianMangkir.Visible = true;
                    gvMangkir.Visible = true;

                    dsAkumulasiMangkir.SelectCommand = "SELECT [JML_JAM_LAMBAT_CPTPLG],[KONVERSI_MANGKIR] FROM [q_LambatCepatPulang]where PIN = '" + ((LinkButton)row.Cells[0].FindControl("lnkCol0Item")).Text + "' AND TAHUN = " + ddlTahun.Text + "";
                    dsAkumulasiMangkir.DataBind();
                    if (gvAkumulasiMangkir.Rows.Count > 0)
                    {
                        lblTitleAkumulasiMangkir.Text    = "Akumulasi Keterlambatan dan Cepat Pulang PIN " + ((LinkButton)row.Cells[0].FindControl("lnkCol0Item")).Text;
                        lblTitleAkumulasiMangkir.Visible = true;
                        gvAkumulasiMangkir.Visible       = true;
                    }
                }
            }
            else if (e.CommandName == "TambahPelanggaran")
            {
                FvPunishment.DefaultMode = FormViewMode.Insert;
                FvPunishment.ChangeMode(FormViewMode.Insert);
                showGridView(false);

                ImageButton b     = (ImageButton)e.CommandSource;
                GridViewRow myRow = (GridViewRow)b.NamingContainer;

                ((TextBox)FvPunishment.FindControl("txtItem0FormView")).Text    = GvPunishment.DataKeys[myRow.RowIndex].Value.ToString();
                ((TextBox)FvPunishment.FindControl("txtItem0FormView")).Enabled = false;
                TextBox txtNIP  = (TextBox)FvPunishment.FindControl("txtItem0FormView");
                Label   lblNama = (Label)FvPunishment.FindControl("lblItem1FormView");
                setNama(txtNIP, lblNama);
                ((LinkButton)FvPunishment.FindControl("lnkItem0FormView")).Visible = false;
                ((TextBox)FvPunishment.FindControl("txtItem2FormView")).Text       = (azlib.FirstDate(DateTime.Now, "id")).ToShortDateString();
                int iLamaPotongan;
                iLamaPotongan = Convert.ToInt32(((Label)(myRow.Cells[8].FindControl("lblCol11Item"))).Text.ToString());
                ((TextBox)FvPunishment.FindControl("txtItem3FormView")).Text = (azlib.FirstDate(DateTime.Now, "id")).AddMonths(iLamaPotongan).AddDays(-1).ToShortDateString();
                ((DropDownList)FvPunishment.FindControl("ddlItem4FormView")).SelectedValue = ((Label)(myRow.Cells[3].FindControl("lblCol3Item"))).Text.ToString();
            }
        }
Esempio n. 4
0
 //fungsi: Handle Ketika data pada database telah didelete
 protected void dsPunishment_Deleted(object sender, System.Web.UI.WebControls.SqlDataSourceStatusEventArgs e)
 {
     //Seleksi apakah terjadi error atau tidak
     //jika tidak ada record yang ter delete maka terjadi error
     if (e.AffectedRows == 0)
     {
         ExceptionDetails.Text = lblCannotUpdate.Text;
         e.ExceptionHandled    = true;
     }
     else
     {
         //Catat ke Log
         rtwin.azlib.AddUserAct(Session["UserID"].ToString(), "2433", e.Command.Parameters["@NIP"].Value.ToString() + "," + e.Command.Parameters["@TGL_AWAL"].Value.ToString(), Application["strCn"].ToString());
     }
     GvPunishment.DataBind();
 }
Esempio n. 5
0
        protected void txtHalaman_TextChanged(object sender, EventArgs e)
        {
            GridViewRow rowPager   = GvPunishment.BottomPagerRow;
            TextBox     txtHalaman = (TextBox)(rowPager.Cells[0].FindControl("txtHalaman"));

            try
            {
                if (int.Parse(txtHalaman.Text) <= GvPunishment.PageCount + 1 && int.Parse(txtHalaman.Text) > 0)
                {
                    GvPunishment.PageIndex = (int.Parse(txtHalaman.Text)) - 1;
                    GvPunishment.DataBind();
                }
            }
            catch (Exception)
            {
                txtHalaman.Text = (GvPunishment.PageIndex + 1).ToString();
            }
        }