protected void SaveData() { ltmessage.Text = ""; try { DateTime?dtWEF = null; DateTime?dtWET = null; double? SBU_Value = null; double? Value = 0.00; if (txtEffectivedate.Text != "") { dtWEF = Convert.ToDateTime(txtEffectivedate.Text); } if (txtEfffectTo.Text != "") { dtWET = Convert.ToDateTime(txtEfffectTo.Text); } else { dtWET = dtWEF; } if (txtSBU.Text != "") { SBU_Value = Convert.ToDouble(txtSBU.Text); } PI_ID = Convert.ToInt32(Request.QueryString["PI_ID"]); if (ddlMonths.Visible == true) { QtrMonth = ddlMonths.SelectedValue; } else if (ddlQuarter.Visible == true) { QtrMonth = ddlQuarter.SelectedValue; } if (dtWEF <= dtWET) { if (ViewState["Detail_ID"] != null) { Detail_ID = Convert.ToInt32(ViewState["Detail_ID"]); Value = 1.00; } DataTable dt = getValueData(); BLL_TMSA_PI.INSERT_PI_Detail(Detail_ID, Value, dt, PI_ID, ddlYear.SelectedValue, QtrMonth, dtWEF, dtWET, SBU_Value, UDFLib.ConvertToInteger(Session["UserID"].ToString()), ref IsExist); } } catch (Exception ex) { ltmessage.Text = ex.ToString(); } }