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