public static IBPPayoutEntries_ManageResultString Manage(IBPPayoutEntries_IBPPayoutEntry IBPCV, string xml)
{
var manageResult = new IBPPayoutEntries_ManageResultString();
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 = "spDisIBPPayoutEntry_Manage";
cmd.CommandTimeout = 180;
cmd.Parameters.AddWithValue("@intIDDisIBPPayoutEntry", IBPCV.intIDDisIBPPayoutEntry);
cmd.Parameters.AddWithValue("@intDisIBPPayoutEntry_Skygo", IBPCV.intDisIBPPayoutEntry_Skygo);
cmd.Parameters.AddWithValue("@TransactionDate", IBPCV.TransactionDate);
cmd.Parameters.AddWithValue("@TotalAmount", IBPCV.TotalAmount);
cmd.Parameters.AddWithValue("@strParticular", IBPCV.strParticular);
cmd.Parameters.AddWithValue("@intIDSecUser", IBPCV.intIDSecUser);
cmd.Parameters.AddWithValue("@xmlXML", xml);
result = (string)cmd.ExecuteScalar();
}
if (result.Contains("Success"))
{
string[] separators = { "," };
string[] words = result.Split(separators, StringSplitOptions.RemoveEmptyEntries);
manageResult.Message = words[0].ToString();
manageResult.Code = words[1].ToString();
manageResult.ID = int.Parse(words[2].ToString());
}
else
{
manageResult.Message = result;
manageResult.Code = "";
manageResult.ID = 0;
}
}
}
catch (Exception ex)
{
manageResult.Message = "Error: " + ex.ToString();
manageResult.Code = "";
manageResult.ID = 0;
}
return(manageResult);
}
private void Manage()
{
IBPPayoutEntries_ManageResultString result = new IBPPayoutEntries_ManageResultString();
try
{
result = IBPPayoutEntriesBAL.Manage(Request.QueryString, Request.Form);
Response.Write(result.ToJSON());
}
catch (Exception ex)
{
result.ID = 0;
result.Message = ex.ToString();
Response.Write(result.ToJSON());
}
}
