private void approveIncentive()
{
try
{
LtoIncentive_ApproveIncentive list = LtoIncentiveBal.approveIncentive(Request.QueryString);
Response.Write(list.ToJSON());
}
catch (Exception ex)
{
Response.Write("Error: " + ex.Message);
}
}
public static LtoIncentive_ApproveIncentive approveIncentive(int intIDLtoIncentive, string DateApproved, int intIDSecUser)
{
var manageResult = new LtoIncentive_ApproveIncentive();
try
{
var dbUtil = new DatabaseManager();
using (var conn = new SqlConnection(dbUtil.getSQLConnectionString("MainDB")))
{
string result = string.Empty;
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "spLtoIncentive_approveLtoIncentive";
cmd.CommandTimeout = 180;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@intIDLtoIncentive", intIDLtoIncentive);
cmd.Parameters.AddWithValue("@DateApproved", DateApproved);
cmd.Parameters.AddWithValue("@intIDSecUser", intIDSecUser);
result = (string)cmd.ExecuteScalar();
}
if (result.Contains("Success121"))
{
string[] separators = { "," };
string[] words = result.Split(separators, StringSplitOptions.RemoveEmptyEntries);
manageResult.Message = "Success";
manageResult.DateApproved = words[1].ToString();
manageResult.ID = intIDLtoIncentive;
}
else
{
manageResult.Message = result;
manageResult.ID = 0;
manageResult.DateApproved = "";
}
}
}
catch (Exception ex)
{
manageResult.Message = "Error: " + ex.ToString();
manageResult.ID = 0;
manageResult.DateApproved = "";
}
return(manageResult);
}
