Ejemplo n.º 1
0
    protected void frmAddAdj_ItemInserting(object sender, FormViewInsertEventArgs e)
    {
        lbl_error1.Text = "";
        IPBA_DAL dal = new IPBA_DAL();

        string plancode = (frmAddAdj.Row.FindControl("ddlAHMO") as DropDownList).SelectedValue;
        string ssn      = (frmAddAdj.Row.FindControl("txtASSN") as TextBox).Text;
        string yrmo     = (frmAddAdj.Row.FindControl("txtAYRMO") as TextBox).Text;

        if (!dal.ManAdjDupExists(plancode, ssn, yrmo))
        {
            if (e.Values["progcd"].Equals("PA") || e.Values["progcd"].Equals("PR") || e.Values["progcd"].Equals("CP"))
            {
                if (!(plancode.Equals("P5")))
                {
                    e.Values["plancd"] = plancode.Substring(3, 2);
                }
                else
                {
                    e.Values["plancd"] = plancode;
                }
            }
            else
            {
                e.Values["plancd"] = plancode.Substring(0, 2);
            }
        }
        else
        {
            e.Cancel = true;
            ResetAddControls();
            frmAddAdj.Visible = false;
            lbl_error1.Text   = "Record not inserted <br />" + "Record with Plan Code - " + plancode + " AND SSN - " + ssn + " for YRMO - " + yrmo + " already exists!";
        }
    }
Ejemplo n.º 2
0
    protected void frmEditAdj_ItemUpdating(object sender, FormViewUpdateEventArgs e)
    {
        lbl_error1.Text = "";
        IPBA_DAL dal = new IPBA_DAL();

        string plancode = (frmEditAdj.Row.FindControl("ddlEHMO") as DropDownList).SelectedValue;
        string ssn      = (frmEditAdj.Row.FindControl("txtSSN") as TextBox).Text;
        string yrmo     = (frmEditAdj.Row.FindControl("txtEYRMO") as TextBox).Text;
        int    id       = (int)grdvAdj.SelectedValue;

        if (!dal.ManAdjDupExists(plancode, ssn, yrmo, id))
        {
            if (e.NewValues["progcd"].Equals("PA") || e.NewValues["progcd"].Equals("PR") || e.NewValues["progcd"].Equals("CP"))
            {
                if (!(plancode.Equals("P5")))
                {
                    e.NewValues["plancd"] = plancode.Substring(3, 2);
                }
                else
                {
                    e.NewValues["plancd"] = plancode;
                }
            }
            else
            {
                e.NewValues["plancd"] = plancode.Substring(0, 2);
            }

            updateAudit(e, id.ToString());
        }
        else
        {
            e.Cancel = true;
            ResetAddControls();
            frmEditAdj.Visible = false;
            lbl_error1.Text    = "Record not updated <br />" + "Record with Plan Code - " + plancode + " AND SSN - " + ssn + " for YRMO - " + yrmo + " already exists!";
        }
    }