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!"; } }
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!"; } }