Exemplo n.º 1
0
    protected void btnSaveDetail_Click(object sender, EventArgs e)
    {
        EmpExclaimDetailDAL _dalEmpExclaimDetailDAL = null;
        Hashtable           _htParameters           = null;
        int iNextID = 0;

        try
        {
            _dalEmpExclaimDetailDAL = new EmpExclaimDetailDAL();
            _htParameters           = new Hashtable();

            MPF23.Shared.Mapper.UIToDB.Map(UpExpenseClaimDetail.Controls, _htParameters);
            Utility.ApplyDefaultProp(_htParameters);

            if (lbljudulCost.Text == "Ubah")
            {
                _htParameters["p_ID"]         = lblIdDetail.Text;
                _htParameters["p_ExClaim_No"] = txtExClaim_No.Text;
                _dalEmpExclaimDetailDAL.Update(_htParameters);
                iNextID = Int32.Parse(lblIdDetail.Text);
            }
            else
            {
                _htParameters["p_ExClaim_No"] = txtExClaim_No.Text;
                _dalEmpExclaimDetailDAL.Insert(_htParameters, ref iNextID);
            }
            Utility.ShowMessageBox(this, Utility.SAVE_DATA_SUCCESS_MESSAGE, null, null);
            BindGridClaim();
            panelDetail.Visible = false;
        }
        catch (Exception ex)
        {
            Utility.ShowMessageBox(this, Utility.SAVE_DATA_FAIL_MESSAGE, ex, null);
        }
    }
Exemplo n.º 2
0
    public static void BindGrvEmpExclaim(GridView gvw, string ExClaim_No)
    {
        EmpExclaimDetailDAL _dalEmpExclaimDetailDAL = null;
        Hashtable           _htParameters           = null;

        try
        {
            _dalEmpExclaimDetailDAL       = new EmpExclaimDetailDAL();
            _htParameters                 = new Hashtable();
            _htParameters["p_ExClaim_No"] = ExClaim_No;

            DataTable dt = new DataTable();
            dt             = _dalEmpExclaimDetailDAL.GetRows(_htParameters);
            gvw.DataSource = dt;
            gvw.DataBind();

            if (dt.Rows.Count > 0)
            {
                decimal total = dt.AsEnumerable().Sum(row => row.Field <decimal>("Total_Cost"));
                gvw.FooterRow.Cells[14].Text            = "Total";
                gvw.FooterRow.Cells[14].HorizontalAlign = HorizontalAlign.Right;
                gvw.FooterRow.Cells[14].Font.Bold       = true;
                gvw.FooterRow.Cells[15].HorizontalAlign = HorizontalAlign.Right;
                gvw.FooterRow.Cells[15].Font.Bold       = true;
                gvw.FooterRow.Cells[15].Text            = total.ToString("N2");
            }
        }
        catch (Exception ex)
        {
            throw ex;
        }
    }
Exemplo n.º 3
0
    //------------------------- end SPD ---------------------------------------------------------
    #endregion

    #region Cost
    protected void grvExpenseClaimDetail_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        switch (e.CommandName)
        {
        case "EditRow":
            try
            {
                GridViewRow gvr = (GridViewRow)(((ImageButton)e.CommandSource).NamingContainer);

                int RowIndex = gvr.RowIndex;
                lblIdDetail.Text = e.CommandArgument.ToString();

                txtTravel_Date.Text      = gvr.Cells[1].Text;
                txtCost_Code.Text        = gvr.Cells[2].Text;
                txtCost_Description.Text = gvr.Cells[3].Text;
                txtCost_Value.Text       = gvr.Cells[4].Text;
                txtQty.Text         = gvr.Cells[5].Text;
                txtTotal_Cost.Text  = gvr.Cells[6].Text;
                lbljudulCost.Text   = "Ubah";
                panelDetail.Visible = true;
            }
            catch (Exception ex)
            {
                Utility.ShowMessageBox(this, Utility.LOAD_DATA_FAIL_MESSAGE, ex, null);
            }
            break;

        case "DeleteRow ":
            try
            {
                EmpExclaimDetailDAL _dalEmpExclaimDetailDAL = null;
                Hashtable           _htParameters           = null;

                _dalEmpExclaimDetailDAL = new EmpExclaimDetailDAL();
                _htParameters           = new Hashtable();

                _htParameters["p_ID"] = e.CommandArgument.ToString();

                _dalEmpExclaimDetailDAL.Delete(_htParameters);
                BindGridClaim();
            }
            catch (Exception ex)
            {
                Utility.ShowMessageBox(this, Utility.LOAD_DATA_FAIL_MESSAGE, ex, null);
            }
            break;
        }
    }
Exemplo n.º 4
0
    private void BindGridClaim()
    {
        EmpExclaimDetailDAL _dalEmpExclaimDetailDAL = null;
        Hashtable           _htParameters           = null;

        try
        {
            _dalEmpExclaimDetailDAL = new EmpExclaimDetailDAL();
            _htParameters           = new Hashtable();

            if (txtExClaim_No.Text != "")
            {
                //Shared.BindGrvEmpExclaim(grvExpenseClaimDetail, txtSPD_No.Text);
                _htParameters["p_ExClaim_No"] = txtExClaim_No.Text;
            }
            else
            {
                _htParameters["p_SPD_No"] = txtSPD_No.Text;
                //Shared.BindGrvEmpExclaim(grvExpenseClaimDetail, txtExClaim_No.Text);
            }

            DataTable dt = new DataTable();
            dt = _dalEmpExclaimDetailDAL.GetRows(_htParameters);
            grvExpenseClaimDetail.DataSource = dt;
            grvExpenseClaimDetail.DataBind();

            if (dt.Rows.Count > 0)
            {
                decimal total = dt.AsEnumerable().Sum(row => row.Field <decimal>("Total_Cost"));
                grvExpenseClaimDetail.FooterRow.Cells[5].Text            = "Total";
                grvExpenseClaimDetail.FooterRow.Cells[5].HorizontalAlign = HorizontalAlign.Right;
                grvExpenseClaimDetail.FooterRow.Cells[5].Font.Bold       = true;
                grvExpenseClaimDetail.FooterRow.Cells[6].HorizontalAlign = HorizontalAlign.Right;
                grvExpenseClaimDetail.FooterRow.Cells[6].Font.Bold       = true;
                grvExpenseClaimDetail.FooterRow.Cells[6].Text            = total.ToString("N2");
            }
        }
        catch (Exception ex)
        {
            Utility.ShowMessageBox(this, Utility.LOAD_DATA_FAIL_MESSAGE, ex, null, null);
        }
    }