public Captains Update(Captains captain)
{
Captains _captain = null;
using (var sqlConnection = new SqlConnection(DbDbConstant.DatabaseConnection))
{
sqlConnection.Open();
_captain = sqlConnection.Get <Captains>(captain.CAPTAIN_ID);
_captain.RECORD_STATUS = 1;
_captain.UPDATE_DATE = DateTime.Now;
_captain.UPDATE_USER = captain.UPDATE_USER;
_captain.CAPTAIN_INFO = captain.CAPTAIN_INFO;
_captain.BOAT_ID = captain.BOAT_ID;
_captain.CAPTAIN_MIDDLE_NAME = captain.CAPTAIN_MIDDLE_NAME;
_captain.CAPTAIN_NAME = captain.CAPTAIN_NAME;
_captain.CAPTAIN_SURNAME = captain.CAPTAIN_SURNAME;
_captain.EMAIL = captain.EMAIL;
_captain.PHONE_NUMBER = captain.PHONE_NUMBER;
sqlConnection.Update <Captains>(_captain);
var result = sqlConnection.Get <Captains>(captain.BOAT_ID);
}
return(_captain);
}
public long Insert(Captains captain)
{
using (var sqlConnection = new SqlConnection(DbDbConstant.DatabaseConnection))
{
sqlConnection.Open();
var _captain = new Captains()
{
GUID = Guid.NewGuid().ToString(),
RECORD_STATUS = 1,
INSERT_DATE = DateTime.Now,
INSERT_USER = captain.INSERT_USER,
UPDATE_DATE = DateTime.Now,
UPDATE_USER = captain.UPDATE_USER,
BOAT_ID = captain.BOAT_ID,
CAPTAIN_INFO = captain.CAPTAIN_INFO,
CAPTAIN_MIDDLE_NAME = captain.CAPTAIN_MIDDLE_NAME,
CAPTAIN_NAME = captain.CAPTAIN_NAME,
CAPTAIN_SURNAME = captain.CAPTAIN_SURNAME,
EMAIL = captain.EMAIL,
PHONE_NUMBER = captain.PHONE_NUMBER,
IDENTIFICATION_ID = captain.IDENTIFICATION_ID
};
var captainGuid = sqlConnection.Insert <Captains>(_captain);
sqlConnection.Close();
return(captainGuid);
}
}
//private async void RunCompetition()
//{
//var captainsToRun = Captains.Where(c => c.IsSelected).ToList();
//var numCaptains = captainsToRun.Count;
//// Compute the number of total rounds for keeping track of progress
//int numberofrounds = numCaptains * numCaptains - numCaptains;
//int counter = 0;
//foreach (var captain in captainsToRun)
//{
// var captainOpponents = captainsToRun.Where(c => c.AssemblyQualifiedName != captain.AssemblyQualifiedName);
// foreach (var captain2 in captainOpponents)
// {
// if (StopCompetition) return;
// if (/*await*/ BattleCaptains(captain, captain2, captainsToRun.Count))
// {
// counter++;
// }
// MatchProgress = 100 * counter / numberofrounds;
// }
//}
// RunCompetitionAsync();
//}
private async Task <bool> RunCompetitionAsync()
{
var watch = Stopwatch.StartNew();
var captainsToRun = Captains.Where(c => c.IsSelected).ToList();
var numCaptains = captainsToRun.Count;
// Compute the number of total rounds for keeping track of progress
int numberofrounds = numCaptains * numCaptains - numCaptains;
int counter = 0;
foreach (var captain in captainsToRun)
{
var captainOpponents = captainsToRun.Where(c => c.AssemblyQualifiedName != captain.AssemblyQualifiedName);
foreach (var captain2 in captainOpponents)
{
if (StopCompetition)
{
return(true);
}
//if (/*await*/ BattleCaptains(captain, captain2, captainsToRun.Count))
if (await BattleCaptains(captain, captain2, captainsToRun.Count))
{
counter++;
}
MatchProgress = 100 * counter / numberofrounds;
}
}
watch.Stop();
Console.WriteLine($"took {watch.ElapsedMilliseconds}");
return(true);
}
//From before perf testing
private async void RunCompetition()
{
var captainsToRun = Captains.Where(c => c.IsSelected).ToList();
var numCaptains = captainsToRun.Count;
// Compute the number of total rounds for keeping track of progress
int numberofrounds = numCaptains * numCaptains - numCaptains;
int counter = 0;
foreach (var captain in captainsToRun)
{
var captainOpponents = captainsToRun.Where(c => c.AssemblyQualifiedName != captain.AssemblyQualifiedName);
foreach (var captain2 in captainOpponents)
{
if (StopCompetition)
{
return;
}
if (await BattleCaptains(captain, captain2, captainsToRun.Count))
{
counter++;
}
MatchProgress = 100 * counter / numberofrounds;
}
}
}
public static ResponseCaptain GetCaptainInfo(long captainID)
{
try
{
Captains captain = captainsService.SelectByBoatId(captainID);
ResponseCaptain response = new ResponseCaptain
{
BOAT_ID = captain.BOAT_ID,
CAPTAIN_INFO = captain.CAPTAIN_INFO,
CAPTAIN_NAME = captain.CAPTAIN_NAME,
CAPTAIN_MIDDLE_NAME = captain.CAPTAIN_MIDDLE_NAME,
CAPTAIN_SURNAME = captain.CAPTAIN_SURNAME,
EMAIL = captain.EMAIL,
IDENTIFICATION_ID = captain.IDENTIFICATION_ID,
PHONE_NUMBER = captain.PHONE_NUMBER,
CAPTAIN_ID = captain.CAPTAIN_ID,
header = new ResponseHeader
{
IsSuccess = true,
ResponseCode = CommonDefinitions.SUCCESS,
ResponseMessage = CommonDefinitions.SUCCESS_MESSAGE
}
};
return(response);
}
catch (Exception)
{
throw;
}
}
public Captains SelectByBoatId(long captainId)
{
Captains _captain = null;
using (var sqlConnection = new SqlConnection(DbDbConstant.DatabaseConnection))
{
sqlConnection.Open();
IEnumerable <Captains> captain = sqlConnection.Query <Captains>("select * from CAPTAINS where CAPTAIN_ID = @id", new { id = captainId });
_captain = captain.FirstOrDefault();
}
return(_captain);
}
public Captains Delete(Captains captain)
{
Captains _captain = null;
using (var sqlConnection = new SqlConnection(DbDbConstant.DatabaseConnection))
{
sqlConnection.Open();
_captain = sqlConnection.Get <Captains>(captain.CAPTAIN_ID);
_captain.RECORD_STATUS = 0;
_captain.UPDATE_DATE = DateTime.Now;
_captain.UPDATE_USER = captain.UPDATE_USER;
sqlConnection.Update <Captains>(_captain);
var result = sqlConnection.Get <Captains>(captain.CAPTAIN_ID);
}
return(_captain);
}
public override void DoOperation()
{
try
{
//Validate Reques Header / Constants
this.baseResponseMessage = ValidateInput();
if (!this.baseResponseMessage.header.IsSuccess)
{
throw new Exception(this.baseResponseMessage.header.ResponseMessage);
}
//Operation
switch (this.request.Header.OperationTypes)
{
case (int)OperationType.OperationTypes.ADD:
#region ADD
long checkGuid = 0;
this.captain = new Captains
{
INSERT_USER = this.request.INSERT_USER,
UPDATE_USER = this.request.UPDATE_USER,
CAPTAIN_NAME = this.request.CAPTAIN_NAME,
CAPTAIN_MIDDLE_NAME = this.request.CAPTAIN_MIDDLE_NAME,
CAPTAIN_SURNAME = this.request.CAPTAIN_SURNAME,
BOAT_ID = this.request.BOAT_ID,
IDENTIFICATION_ID = this.request.IDENTIFICATION_ID,
EMAIL = this.request.EMAIL,
PHONE_NUMBER = this.request.PHONE_NUMBER,
CAPTAIN_INFO = this.request.CAPTAIN_INFO
};
//Add Data to Database
checkGuid = captainsService.Insert(this.captain);
//Connect captain to related Boat
Boats boat = new Boats();
boat = boatsService.SelectByBoatId(this.captain.BOAT_ID);
boat.CAPTAIN_ID = checkGuid;
boatsService.Update(boat);
this.response = new ResponseCaptain
{
CAPTAIN_ID = checkGuid,
CAPTAIN_NAME = this.request.CAPTAIN_NAME,
CAPTAIN_MIDDLE_NAME = this.request.CAPTAIN_MIDDLE_NAME,
CAPTAIN_SURNAME = this.request.CAPTAIN_SURNAME,
BOAT_ID = this.request.BOAT_ID,
IDENTIFICATION_ID = this.request.IDENTIFICATION_ID,
EMAIL = this.request.EMAIL,
PHONE_NUMBER = this.request.PHONE_NUMBER,
CAPTAIN_INFO = this.request.CAPTAIN_INFO,
header = new ResponseHeader
{
IsSuccess = checkGuid == 0 ? false : true,
ResponseCode = checkGuid == 0 ? CommonDefinitions.INTERNAL_SYSTEM_UNKNOWN_ERROR : CommonDefinitions.SUCCESS,
ResponseMessage = checkGuid == 0 ? CommonDefinitions.ERROR_MESSAGE : CommonDefinitions.SUCCESS_MESSAGE
}
};
#endregion
break;
case (int)OperationType.OperationTypes.UPDATE:
#region UPDATE
this.captain = new Captains
{
UPDATE_USER = this.request.UPDATE_USER,
CAPTAIN_NAME = this.request.CAPTAIN_NAME,
CAPTAIN_MIDDLE_NAME = this.request.CAPTAIN_MIDDLE_NAME,
CAPTAIN_SURNAME = this.request.CAPTAIN_SURNAME,
BOAT_ID = this.request.BOAT_ID,
IDENTIFICATION_ID = this.request.IDENTIFICATION_ID,
EMAIL = this.request.EMAIL,
PHONE_NUMBER = this.request.PHONE_NUMBER,
CAPTAIN_INFO = this.request.CAPTAIN_INFO
};
//Modify Data to Database
captainsService.Update(this.captain);
this.response = new ResponseCaptain
{
CAPTAIN_NAME = this.request.CAPTAIN_NAME,
CAPTAIN_MIDDLE_NAME = this.request.CAPTAIN_MIDDLE_NAME,
CAPTAIN_SURNAME = this.request.CAPTAIN_SURNAME,
BOAT_ID = this.request.BOAT_ID,
IDENTIFICATION_ID = this.request.IDENTIFICATION_ID,
EMAIL = this.request.EMAIL,
PHONE_NUMBER = this.request.PHONE_NUMBER,
CAPTAIN_INFO = this.request.CAPTAIN_INFO,
header = new ResponseHeader
{
IsSuccess = true,
ResponseCode = CommonDefinitions.SUCCESS,
ResponseMessage = CommonDefinitions.SUCCESS_MESSAGE
}
};
#endregion
break;
case (int)OperationType.OperationTypes.GET:
#region GET
//Get Data
this.captain = captainsService.SelectByBoatId(this.request.BOAT_ID);
this.response = new ResponseCaptain
{
CAPTAIN_NAME = this.captain.CAPTAIN_NAME,
CAPTAIN_MIDDLE_NAME = this.captain.CAPTAIN_MIDDLE_NAME,
CAPTAIN_SURNAME = this.captain.CAPTAIN_SURNAME,
BOAT_ID = this.captain.BOAT_ID,
IDENTIFICATION_ID = this.captain.IDENTIFICATION_ID,
EMAIL = this.captain.EMAIL,
PHONE_NUMBER = this.captain.PHONE_NUMBER,
CAPTAIN_INFO = this.captain.CAPTAIN_INFO,
header = new ResponseHeader
{
IsSuccess = true,
ResponseCode = CommonDefinitions.SUCCESS,
ResponseMessage = CommonDefinitions.SUCCESS_MESSAGE
}
};
#endregion
break;
case (int)OperationType.OperationTypes.DELETE:
#region DELETE
this.captain = captainsService.SelectByBoatId(this.request.BOAT_ID);
captainsService.Delete(this.captain);
this.response = new ResponseCaptain
{
CAPTAIN_NAME = "",
CAPTAIN_MIDDLE_NAME = "",
CAPTAIN_SURNAME = "",
BOAT_ID = this.captain.BOAT_ID,
IDENTIFICATION_ID = 0,
EMAIL = "",
PHONE_NUMBER = "",
CAPTAIN_INFO = "",
header = new ResponseHeader
{
IsSuccess = true,
ResponseCode = CommonDefinitions.SUCCESS,
ResponseMessage = CommonDefinitions.SUCCESS_MESSAGE
}
};
//DisConnect captain to related Boat
Boats boats = new Boats();
boats = boatsService.SelectByBoatId(this.captain.BOAT_ID);
boats.CAPTAIN_ID = 0;
boatsService.Update(boats);
#endregion
break;
default:
break;
}
}
catch (Exception ex)
{
string operationError = "HATA:[" + "CaptainId:" + this.request.CAPTAIN_ID + ",ResponseCode:" + this.baseResponseMessage.header.ResponseCode + ", ResponseMessage:" + ex.Message + "]";
log.InfoFormat(operationError, ex);
throw new Exception(ex.Message, ex.InnerException);
}
}
public CaptainsData(Captains captains)
{
PlayerData = captains.Player.GetSerializationData();
}
public CaptainViewInfo(Captains capt)
{
Id = (int)capt;
Name = string.Format("Captain {0}", capt.Humanize(LetterCasing.Title));
Image = string.Format("{0}.png", capt.ToString());
}
