/// <summary> /// Save the user input /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void ibtnSave_Click(object sender, ImageClickEventArgs e) { try { string columnValue = ""; if (ddlCode.SelectedIndex > 0) { if (ViewState["Mode"].ToString() == "ADD") { //fSOHeaderID,LineNumber,ExpenseCd,Amount,Cost,ExpenseInd,TaxStatus,EntryID,EntryDt columnValue = "'" + poNumber + "','" + lblLineNo.Text.Trim() + "','" + ddlCode.SelectedValue.Trim() + "','" + txtAmount.Text + "','" + lblIndicator.Text + "','" + ((chkTaxable.Checked) ? "Y" : "N") + "','" + Session["UserName"].ToString() + "','" + DateTime.Now.ToShortDateString() + "','" + lblDescription.Text + "'"; expenseEntry.InsertPOExpense(columnValue); utility.DisplayMessage(MessageType.Success, "Data has been successfully added", lblMessage); } else { // string whereClause = "pSOExpenseID=" + hidExpenseID.Value; columnValue = "ExpenseCd='" + ddlCode.SelectedValue.Trim() + "',Amount=" + txtAmount.Text + ",ExpenseInd='" + lblIndicator.Text + "',TaxStatus='" + ((chkTaxable.Checked) ? "Y" : "N") + "',ChangeID='" + Session["UserName"].ToString() + "',ChangeDt='" + DateTime.Now.ToShortDateString() + "',ExpenseDesc='" + lblDescription.Text + "'"; expenseEntry.UpdatePOExpense(columnValue, hidExpenseID.Value); //lblMessage.Text = utility.UpdateMessage; utility.DisplayMessage(MessageType.Success, updateMessage, lblMessage); } ViewState["Mode"] = "ADD"; ClearEntryControl(); BindDataGrid(); upExpenseEntry.Update(); upExpenseGrid.Update(); } else { lblMessage.Text = invalidMessage; lblMessage.ForeColor = System.Drawing.Color.Red; } upProgress.Update(); } catch (Exception ex) { throw; } }