示例#1
0
    /// <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;
        }
    }