/// <summary> /// Save the user input /// </summary> protected void ibtnSave_Click(object sender, ImageClickEventArgs e) { try { DateTime dExpDate; string strState = string.Empty; dExpDate = Convert.ToDateTime(dtpExpDate.SelectedDate); strState = (ddlState.SelectedValue == "")? "": ""; string columnValue = ""; if (ViewState["Mode"].ToString() == "ADD") { //fCustMasterID, CustNo, ResaleCertNo, State, ExpirationDt, ChangeID, ChangeDt columnValue = "'" + CustomerID + "','" + lblCustNumber.Text.Trim() + "','" + txtCert.Text.Trim() + "','" + ddlState.SelectedValue + "','" + dExpDate + "','" + Session["UserName"].ToString() + "','" + DateTime.Now.ToShortDateString() + "'"; customerMaintenance.InsertTaxExempt(columnValue); lblMessage.Text = customerMaintenance.AddMessage; } else { dExpDate = Convert.ToDateTime(dtpExpDate.SelectedDate); //fCustMasterID, CustNo, ResaleCertNo, State, ExpirationDt, ChangeID, ChangeDt string whereClause = "pTaxExemptID=" + hidTaxID.Value; columnValue = "ResaleCertNo='" + txtCert.Text.Trim() + "',State='" + ddlState.SelectedValue + "',ExpirationDt='" + dExpDate + "',ChangeID='" + Session["UserName"].ToString() + "',ChangeDt='" + DateTime.Now.ToShortDateString() + "'"; customerMaintenance.UpdateTaxExempt(columnValue, whereClause); lblMessage.Text = customerMaintenance.UpdateMessage; } ViewState["Mode"] = "ADD"; ClearEntryControl(); BindDataGrid(); upTaxEntry.Update(); upTaxGrid.Update(); upProgress.Update(); } catch (Exception ex) { throw; } }