/// <summary>
/// Track the Request Transaction.
/// </summary>
/// <param name="requestTransaction">The object of type TrackRequestTransaction.</param>
/// <returns>Integer object.</returns>
public int TrackRequestTransaction(TrackRequestTransaction request)
{
Logging.LogDebugMessage("Method: TrackRequestTransaction, MethodType: Post, Layer: RequestTransactionBL, Parameters: : request = " + JsonConvert.SerializeObject(request));
try
{
using (RequestTransactionDAL requestTransactionDAL = new RequestTransactionDAL())
{
//return requestTransactionDAL.TrackRequestTransaction(request);
int requestTransactionId = requestTransactionDAL.TrackRequestTransaction(request);
if (request.IsEmailSend && request.UserId != null)
{
Int64 userId = Convert.ToInt64(request.UserId);
this.SendEmail(userId, requestTransactionId, request.RequestTemplateId);
}
return(requestTransactionId);
}
}
catch (SqlException sqlEx)
{
Logging.LogErrorMessage("Method: TrackRequestTransaction, Layer: RequestTransactionBL, Stack Trace: " + sqlEx.ToString());
throw;
}
catch (Exception ex)
{
Logging.LogErrorMessage("Method: TrackRequestTransaction, Layer: RequestTransactionBL, Stack Trace: " + ex.ToString());
throw;
}
}
public int TrackRequestTransaction(TrackRequestTransaction request)
{
Logging.LogDebugMessage("Method: TrackRequestTransaction, MethodType: Post, Layer: RequestTransactionController, Parameters: request = " + JsonConvert.SerializeObject(request));
using (RequestTransactionBL requestTransactionBL = new RequestTransactionBL())
{
return(requestTransactionBL.TrackRequestTransaction(request));
}
}
/// <summary> Track the Request Transaction </summary>
/// <param name="requestTransaction">The object of type TrackRequestTransaction</param>
/// <returns> Integer object </returns>
public int TrackRequestTransaction(TrackRequestTransaction request)
{
int transactionID = 0;
Logging.LogDebugMessage("Method: TrackRequestTransaction, MethodType: Post, Layer: RequestTransactionDAL, Parameters: request = " + JsonConvert.SerializeObject(request));
var ds = new DataSet();
DataTable dataTableOne = new DataTable();
dataTableOne = EntityCollectionHelper.ConvertTo <RequestTransactionTrack>(request.requestTransactionTracks);
DataTable dataTableTwo = new DataTable();
dataTableTwo = EntityCollectionHelper.ConvertTo <RequestTransactionHistory>(request.requestTransactionHistory);
try
{
using (var command = new SqlCommand())
{
command.Connection = new SqlConnection(this.connectionString);
command.CommandText = "USP_TrackRequestTransaction";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@RequestTransactionId", Value = request.RequestTransactionId
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@UserId", Value = request.UserId
});
SqlParameter structuredParamOne = new SqlParameter("@RequestTransactionTrack", SqlDbType.Structured);
structuredParamOne.Value = dataTableOne;
command.Parameters.Add(structuredParamOne);
SqlParameter structuredParamTwo = new SqlParameter("@RequestTransactionHistory", SqlDbType.Structured);
structuredParamTwo.Value = dataTableTwo;
command.Parameters.Add(structuredParamTwo);
using (SqlDataAdapter adapter = new SqlDataAdapter(command))
{
adapter.Fill(ds);
if (ds != null && ds.Tables.Count > 0)
{
transactionID = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
}
}
}
}
catch (SqlException sqlEx)
{
Logging.LogErrorMessage("Method: TrackRequestTransaction, Layer: RequestTransactionDAL, Stack Trace: " + sqlEx.ToString());
throw;
}
catch (Exception ex)
{
Logging.LogErrorMessage("Method: TrackRequestTransaction, Layer: RequestTransactionDAL, Stack Trace: " + ex.ToString());
throw;
}
return(transactionID);
}
