public List <ApiMultisiteDeleteReturnModel> MultisiteDelete(string selectedSites, int tracerID, int userID, out bool isDeadlock)
{
List <ApiMultisiteDeleteReturnModel> _result;
isDeadlock = false;
try {
using (var db = new Data.DBMEdition01Context())
{
db.Database.CommandTimeout = 360;
_result = db.ApiMultisiteDelete(selectedSites, tracerID, userID);
}
return(_result);
}
catch (SqlException ex) {
if (ex.Number == 1205)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("EXEC dbo.apiMultisiteDelete Sites='{0}', @TracerID={1}, @UserID={2}", selectedSites, tracerID, userID);
string sqlParam = sb.ToString();
string methodName = "JCRAPI/Business/TracerService/MultisiteDelete";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, userID, tracerID, sqlParam, string.Empty);
isDeadlock = true;
}
return(null);
}
catch (Exception ex) {
StringBuilder sb = new StringBuilder();
sb.AppendFormat("EXEC dbo.apiMultisiteDelete Sites='{0}', @TracerID={1}, @UserID={2}", selectedSites, tracerID, userID);
string sqlParam = sb.ToString();
string methodName = "JCRAPI/Business/TracerService/MultisiteDelete";
exceptionLog.ExceptionLogInsert(ex.Message.ToString(), "", methodName, userID, tracerID, sqlParam, string.Empty);
return(null);
}
}
