public InsertTaskForm(DB db, updateType t, int idToChange)
{
InitializeComponent();
_db = db;
_t = t;
_id = idToChange;
}
public override void Reset()
{
gameObject = null;
is2D = false;
useSmoothDeltaTime = false;
positionVal = new List <Vector3>();
rotationVal = new List <Vector3>();
sizeVal = new List <Vector3>();
velocityVal = new List <Vector3>();
updateTypeSelect = updateType.FixedUpdate;
// --> add new List component
// <-- end
listLimit = 500;
timeLimitInSeconds = 10;
isRewinding = false;
rewind = false;
forceQuit = false;
forceQuitEvent = null;
rewindIsKinematic = true;
stopMotion = 0.1f;
useStopMotion = false;
}
public override void Reset()
{
isMobile = null;
tag = null;
updateTypeSelect = updateType.Update;
forceQuit = null;
pause = null;
isUpdate = false;
isFUpdate = false;
isLUpdate = false;
}
/// <summary>
/// insert a new period
/// </summary>
/// <param name="period">peridiocity (monthly,weekly, etc)</param>
/// <returns>the returned value from stored function on database. Return -1 if an error occurred</returns>
public string InsertPeriod(string period, updateType type, string id)
{
string q = "SELECT insertPeriod(@period,@type,@id)";
cmd = new MySqlCommand(q, cn);
cmd.Parameters.AddWithValue("@period", period);
cmd.Parameters.AddWithValue("@type", (int)type);
cmd.Parameters.AddWithValue("@id", id);
return(CallFunctionTemplate());
}
/// <summary>
/// add a new location
/// </summary>
/// <param name="country">Country</param>
/// <param name="region">Region</param>
/// <param name="province">Province</param>
/// <param name="type">0: insert,1:update,2:delete</param>
/// <param name="id">the id of the item to delete or update, suggest to type -1 if insert</param>
/// <returns></returns>
public string InsertLocation(string country, string region, string province, updateType type, string id)
{
string q = "SELECT insertLocation(@country,@region,@province,@type,@id)";
cmd = new MySqlCommand(q, cn);
cmd.Parameters.AddWithValue("@country", country);
cmd.Parameters.AddWithValue("@region", region);
cmd.Parameters.AddWithValue("@province", province);
cmd.Parameters.AddWithValue("@type", (int)type);
cmd.Parameters.AddWithValue("@id", id);
return(CallFunctionTemplate());
}
/// <summary>
/// updates an employee record by id
/// </summary>
/// <param name="emp"></param>
/// <param name="type"></param>
public static void Update(IEmployee emp, updateType type)
{
List <parmStructure> lstParms = new List <parmStructure>();
switch (type)
{
case updateType.webPersonal:
lstParms.Add(new parmStructure("@id", emp.Id, ParameterDirection.Input, SqlDbType.Int));
lstParms.Add(new parmStructure("@street", emp.Street, ParameterDirection.Input, SqlDbType.VarChar, 100));
lstParms.Add(new parmStructure("@city", emp.City, ParameterDirection.Input, SqlDbType.VarChar, 50));
lstParms.Add(new parmStructure("@PO", emp.PostalCode, ParameterDirection.Input, SqlDbType.VarChar, 6));
lstParms.Add(new parmStructure("@workPhone", emp.WorkPhone, ParameterDirection.Input, SqlDbType.Char, 10));
lstParms.Add(new parmStructure("@cellPhone", emp.CellPhone, ParameterDirection.Input, SqlDbType.Char, 10));
DataAccess.SendData("EmployeeUpdatePersonal", lstParms);
break;
case updateType.winPersonal:
lstParms.Add(new parmStructure("@id", emp.Id, ParameterDirection.Input, SqlDbType.Int));
lstParms.Add(new parmStructure("@fname", emp.FirstName, ParameterDirection.Input, SqlDbType.VarChar, 50));
lstParms.Add(new parmStructure("@lname", emp.LastName, ParameterDirection.Input, SqlDbType.VarChar, 50));
if (emp.MiddleName != "")
{
lstParms.Add(new parmStructure("@mname", emp.MiddleName, ParameterDirection.Input, SqlDbType.Char, 1));
}
lstParms.Add(new parmStructure("@date", emp.DOB, ParameterDirection.Input, SqlDbType.Date));
lstParms.Add(new parmStructure("@street", emp.Street, ParameterDirection.Input, SqlDbType.VarChar, 100));
lstParms.Add(new parmStructure("@city", emp.City, ParameterDirection.Input, SqlDbType.VarChar, 50));
lstParms.Add(new parmStructure("@PO", emp.PostalCode, ParameterDirection.Input, SqlDbType.VarChar, 6));
DataAccess.SendData("EmployeeUpdatePersonal2", lstParms);
break;
case updateType.status:
lstParms.Add(new parmStructure("@id", emp.Id, ParameterDirection.Input, SqlDbType.Int));
lstParms.Add(new parmStructure("@status", emp.Status, ParameterDirection.Input, SqlDbType.VarChar, 10));
lstParms.Add(new parmStructure("@date", emp.StatusApplied, ParameterDirection.Input, SqlDbType.Date));
DataAccess.SendData("[EmployeeUpdateStatus]", lstParms);
break;
case updateType.job:
lstParms.Add(new parmStructure("@id", emp.Id, ParameterDirection.Input, SqlDbType.Int));
lstParms.Add(new parmStructure("@job", emp.Job, ParameterDirection.Input, SqlDbType.Int));
lstParms.Add(new parmStructure("@dep", emp.Department, ParameterDirection.Input, SqlDbType.Int));
lstParms.Add(new parmStructure("@pay", emp.PayRate, ParameterDirection.Input, SqlDbType.Money));
lstParms.Add(new parmStructure("@startDate", emp.JobStartDate, ParameterDirection.Input, SqlDbType.Date));
DataAccess.SendData("[EmployeeUpdateJob]", lstParms);
break;
}
}
public override void Reset()
{
gameObject = null;
zoomSpeed = 20f;
updateTypeSelect = updateType.LateUpdate;
everyFrame = true;
orthoSizeMin = 1f;
orthoSizeMax = 100f;
boundingBoxPadding = 15f;
boundingBoxPadding = 2f;
useTag = false;
}
public override void Reset()
{
gameObject = null;
zoomSpeed = 20f;
updateTypeSelect = updateType.LateUpdate;
lerpOn = true;
everyFrame = true;
orthoSizeMin = 1f;
orthoSizeMax= 100f;
boundingBoxPadding=15f;
boundingBoxPadding=2f;
useTag = false;
}
//---
public override void Reset()
{
quality = 4;
fovAngle = 90;
fovMaxDistance = 15f;
debugColor = Color.yellow;
updateTypeSelect = updateType.Update;
filterTag = null;
status = 0;
layerMask = new FsmInt[0];
invertMask = false;
useTag = false;
forceFinish = false;
}
/// <summary>
/// insert a new job (a job is a set of tasks, a task is a delivery/recovery magazines to one newsstand)
/// </summary>
/// <param name="jobName">the job name</param>
/// <param name="jobDate">the job date</param>
/// <returns>the returned value from stored function on database. Return -1 if an error occurred</returns>
public string InsertJob(string jobName, string jobDate, updateType type, string id)
{
string q = "SELECT insertJob(@jobName,@jobDate,@type,@id)";
cmd = new MySqlCommand(q, cn);
cmd.Parameters.AddWithValue("@jobName", jobName);
cmd.Parameters.AddWithValue("@jobDate", jobDate);
int i = (int)type;
cmd.Parameters.AddWithValue("@type", i);
cmd.Parameters.AddWithValue("@id", id);
return(CallFunctionTemplate());
}
public override void Reset()
{
gameObject = null;
distance = 1f;
snappyness = 5f;
updateTypeSelect = updateType.LateUpdate;
interpolation = LerpInterpolationType.Linear;
sensitivity = 30;
lerpOn = true;
everyFrame = true;
orthoSizeMin = 1f;
orthoSizeMax = 100f;
cameraBufferX = 15f;
cameraBufferY = 15f;
}
public override void Reset()
{
gameObject = null;
distance = 1f;
upDistance = 1f;
snappyness = 5f;
charA = null;
charB = null;
updateTypeSelect = updateType.LateUpdate;
everyFrame = true;
direction = new Vector3(0, 1, 0);
interpolation = LerpInterpolationType.Off;
sensitivity = 30;
positionObjectbool = false;
lerpOn = true;
}
public void performUpdate()
{
if (Event.current.type == EventType.Repaint)
{
switch (UpdatePosition)
{
case updateType.Cursor:
moveToCursor();
break;
case updateType.Center:
moveToCenter();
break;
}
UpdatePosition = updateType.none;
}
}
/// <summary>
/// updates variouse information for an employee
/// </summary>
/// <param name="cus">employee info</param>
/// <param name="type">type of information being updated</param>
public static void Modify(Employee cus, updateType type)
{
EmployeeSQL.Update(cus, type);
}
private void init(Rect rect = new Rect(), updateType needsUpdate = updateType.none)
{
this.rect = rect;
this.UpdatePosition = needsUpdate;
}
public Rectangle(Rect rect = new Rect(), updateType needsUpdate = updateType.none)
{
init(rect, needsUpdate);
}
public Rectangle(updateType needsUpdate = updateType.none)
{
init(rect, needsUpdate);
}
/// <summary>
/// insert a new newsstand, and eventually add new location and/or a new owner, if not listed yet
/// </summary>
/// <param name="businessName">business name</param>
/// <param name="piva">VAT number</param>
/// <param name="city">newsstand city location</param>
/// <param name="zipCode">city zipcode</param>
/// <param name="address">newsstand address</param>
/// <param name="province">newsstand province (from locations table)</param>
/// <param name="newsstandPhone">newsstand landline</param>
/// <param name="lastnameOwner">owner lastname</param>
/// <param name="nameOwner">owner name</param>
/// <returns>the returned value from stored function on database. Return -1 if an error occurred</returns>
public string InsertNewsStand(string businessName, string piva, string city, string zipCode, string address, string province, string newsstandPhone, string lastnameOwner, string nameOwner, updateType type, string id)
{
string q = "SELECT insertNewsStand(@businessName,@piva,@city,@zipCode,@address,@province,@newsstandPhone,@lastnameOwner,@nameOwner,@type,@id)";
cmd = new MySqlCommand(q, cn);
cmd.Parameters.AddWithValue("@businessName", businessName);
cmd.Parameters.AddWithValue("@piva", piva);
cmd.Parameters.AddWithValue("@city", city);
cmd.Parameters.AddWithValue("@zipCode", zipCode);
cmd.Parameters.AddWithValue("@address", address);
cmd.Parameters.AddWithValue("@province", province);
cmd.Parameters.AddWithValue("@newsstandPhone", newsstandPhone);
cmd.Parameters.AddWithValue("@lastnameOwner", lastnameOwner);
cmd.Parameters.AddWithValue("@nameOwner", nameOwner);
cmd.Parameters.AddWithValue("@type", (int)type);
cmd.Parameters.AddWithValue("@id", id);
return(CallFunctionTemplate());
}
/// <summary>
/// <see cref="Provider{TSingle, TMultiple}.Put(TMultiple, string[], string[])">Put</see>
/// </summary>
public override IHttpActionResult Put(
List <T> objs,
[MatrixParameter] string[] zoneId = null,
[MatrixParameter] string[] contextId = null)
{
if (!AuthenticationService.VerifyAuthenticationHeader(Request.Headers, out string sessionToken))
{
return(Unauthorized());
}
// Check ACLs and return StatusCode(HttpStatusCode.Forbidden) if appropriate.
if (!AuthorisationService.IsAuthorised(Request.Headers, sessionToken, $"{TypeName}s", RightType.CREATE))
{
return(StatusCode(HttpStatusCode.Forbidden));
}
if ((zoneId != null && zoneId.Length != 1) || (contextId != null && contextId.Length != 1))
{
return(BadRequest($"Request failed for object {TypeName} as Zone and/or Context are invalid."));
}
ICollection <updateType> updateStatuses = new List <updateType>();
try
{
foreach (T obj in objs)
{
var status = new updateType
{
id = obj.RefId
};
try
{
Service.Update(obj, (zoneId?[0]), (contextId?[0]));
status.statusCode = ((int)HttpStatusCode.NoContent).ToString();
}
catch (ArgumentException e)
{
status.error = ProviderUtils.CreateError(
HttpStatusCode.BadRequest,
TypeName,
$"Object to update of type {TypeName} is invalid.\n{e.Message}");
status.statusCode = ((int)HttpStatusCode.BadRequest).ToString();
}
catch (NotFoundException e)
{
status.error = ProviderUtils.CreateError(
HttpStatusCode.NotFound,
TypeName,
$"Object {TypeName} with ID of {obj.RefId} not found.\n{e.Message}");
status.statusCode = ((int)HttpStatusCode.NotFound).ToString();
}
catch (UpdateException e)
{
status.error = ProviderUtils.CreateError(
HttpStatusCode.BadRequest,
TypeName,
$"Request failed for object {TypeName} with ID of {obj.RefId}.\n{e.Message}");
status.statusCode = ((int)HttpStatusCode.BadRequest).ToString();
}
catch (Exception e)
{
status.error = ProviderUtils.CreateError(
HttpStatusCode.InternalServerError,
TypeName,
$"Request failed for object {TypeName} with ID of {obj.RefId}.\n{e.Message}");
status.statusCode = ((int)HttpStatusCode.InternalServerError).ToString();
}
updateStatuses.Add(status);
}
}
catch (Exception)
{
// Need to ignore exceptions otherwise it would not be possible to return status records of processed objects.
}
var updateResponse = new updateResponseType {
updates = updateStatuses.ToArray()
};
return(Ok(updateResponse));
}
public override void Reset()
{
gameObject = null;
updateTypeSelect = updateType.FixedUpdate;
everyFrame = true;
}
/// <summary>
/// insert a new worker, and eventually add new location if not listed yet
/// </summary>
/// <param name="lastName">lastname</param>
/// <param name="name">name</param>
/// <param name="email">email</param>
/// <param name="dateOfBirth">date of birth</param>
/// <param name="province">province where he lives</param>
/// <param name="city">city where he lives</param>
/// <param name="zipcode">city zipcode</param>
/// <param name="address">home address</param>
/// <returns>the returned value from stored function on database. Return -1 if an error occurred</returns>
public string InsertWorker(string lastName, string name, string email, string dateOfBirth, string province, string city, string zipcode, string address, updateType type, string id)
{
string q = "SELECT insertWorker(@lastname,@name,@email,@dateOfBirth,@province,@city,@zipcode,@address,@type,@id)";
cmd = new MySqlCommand(q, cn);
cmd.Parameters.AddWithValue("@lastname", lastName);
cmd.Parameters.AddWithValue("@name", name);
cmd.Parameters.AddWithValue("@email", email);
cmd.Parameters.AddWithValue("@dateOfBirth", dateOfBirth);
cmd.Parameters.AddWithValue("@province", province);
cmd.Parameters.AddWithValue("@city", city);
cmd.Parameters.AddWithValue("@zipcode", zipcode);
cmd.Parameters.AddWithValue("@address", address);
cmd.Parameters.AddWithValue("@type", (int)type);
cmd.Parameters.AddWithValue("@id", id);
return(CallFunctionTemplate());
}
/// <summary>
/// insert a new task
/// </summary>
/// <param name="taskName">task name</param>
/// <param name="nCopies">number of magazines copies</param>
/// <param name="typeTask">the task type (must be "deliver" or "returner"</param>
/// <param name="magTitle">magazine title</param>
/// <param name="magNumber">magazine number</param>
/// <param name="nsBusinessName">newsstand's business name</param>
/// <param name="lastNameWorker">lastname of the distributor</param>
/// <param name="nameWorker">name of the distributor</param>
/// <param name="jobName">job name (this task must belong to a job)</param>
/// <param name="jobDate">job date</param>
/// <returns>the returned value from stored function on database. Return -1 if an error occurred</returns>
public string InsertTask(string taskName, string nCopies, string typeTask, string magTitle, string magNumber, string nsBusinessName, string lastNameWorker, string nameWorker, string jobName, string jobDate, updateType type, string id)
{
string q = "SELECT insertTask(@taskName,@nCopies,@typeTask,@magTitle,@magNumber,@nsBusinessName,@lastNameWorker,@nameWorker,@jobName,@jobDate,@type,@id)";
cmd = new MySqlCommand(q, cn);
cmd.Parameters.AddWithValue("@taskName", taskName);
cmd.Parameters.AddWithValue("@nCopies", nCopies);
cmd.Parameters.AddWithValue("@typeTask", typeTask);
cmd.Parameters.AddWithValue("@magTitle", magTitle);
cmd.Parameters.AddWithValue("@magNumber", magNumber);
cmd.Parameters.AddWithValue("@nsBusinessName", nsBusinessName);
cmd.Parameters.AddWithValue("@lastNameWorker", lastNameWorker);
cmd.Parameters.AddWithValue("@nameWorker", nameWorker);
cmd.Parameters.AddWithValue("@jobName", jobName);
cmd.Parameters.AddWithValue("@jobDate", jobDate);
cmd.Parameters.AddWithValue("@type", (int)type);
cmd.Parameters.AddWithValue("@id", id);
return(CallFunctionTemplate());
}
public InsertNewsstandForm(DB db, updateType t)
{
InitializeComponent();
_db = db;
_t = t;
}
/// <summary>
/// <see cref="Provider{TSingle, TMultiple}.Put(TMultiple, string[], string[])">Put</see>
/// </summary>
public override IHttpActionResult Put(List <T> objs, [MatrixParameter] string[] zoneId = null, [MatrixParameter] string[] contextId = null)
{
if (!authService.VerifyAuthenticationHeader(Request.Headers))
{
return(Unauthorized());
}
// Check ACLs and return StatusCode(HttpStatusCode.Forbidden) if appropriate.
if ((zoneId != null && zoneId.Length != 1) || (contextId != null && contextId.Length != 1))
{
return(BadRequest("Request failed for object " + typeof(T).Name + " as Zone and/or Context are invalid."));
}
IHttpActionResult result;
ICollection <updateType> updateStatuses = new List <updateType>();
try
{
foreach (T obj in objs)
{
updateType status = new updateType();
status.id = obj.RefId;
try
{
service.Update(obj, zoneId: (zoneId == null ? null : zoneId[0]), contextId: (contextId == null ? null : contextId[0]));
status.statusCode = ((int)HttpStatusCode.NoContent).ToString();
}
catch (ArgumentException e)
{
status.error = ProviderUtils.CreateError(HttpStatusCode.BadRequest, typeof(T).Name, "Object to update of type " + typeof(T).Name + " is invalid.\n " + e.Message);
status.statusCode = ((int)HttpStatusCode.BadRequest).ToString();
}
catch (NotFoundException e)
{
status.error = ProviderUtils.CreateError(HttpStatusCode.NotFound, typeof(T).Name, "Object " + typeof(T).Name + " with ID of " + obj.RefId + " not found.\n" + e.Message);
status.statusCode = ((int)HttpStatusCode.NotFound).ToString();
}
catch (UpdateException e)
{
status.error = ProviderUtils.CreateError(HttpStatusCode.BadRequest, typeof(T).Name, "Request failed for object " + typeof(T).Name + " with ID of " + obj.RefId + ".\n " + e.Message);
status.statusCode = ((int)HttpStatusCode.BadRequest).ToString();
}
catch (Exception e)
{
status.error = ProviderUtils.CreateError(HttpStatusCode.InternalServerError, typeof(T).Name, "Request failed for object " + typeof(T).Name + " with ID of " + obj.RefId + ".\n " + e.Message);
status.statusCode = ((int)HttpStatusCode.InternalServerError).ToString();
}
updateStatuses.Add(status);
}
}
catch (Exception)
{
// Need to ignore exceptions otherwise it would not be possible to return status records of processed objects.
}
updateResponseType updateResponse = new updateResponseType {
updates = updateStatuses.ToArray()
};
result = Ok(updateResponse);
return(result);
}
/// <summary>
/// add a new magazine relase, and eventually add a new magazine, if not listed
/// </summary>
/// <param name="magName">magazine name</param>
/// <param name="magNumber">magazine number</param>
/// <param name="dateRelase">relase date</param>
/// <param name="nameRelase">relase name (for example: "april number")</param>
/// <param name="priceToPublic">price to the public</param>
/// <param name="percentToNS">percentage of price to public that the the newsstand earns</param>
/// <returns>the returned value from stored function on database. Return -1 if an error occurred</returns>
public string InsertMagRelase(string magName, string magNumber, string dateRelase, string nameRelase, string priceToPublic, string percentToNS, updateType type, string id)
{
string q = "SELECT insertMagRelase(@magName,@magNumber,@dateRelase,@nameRelase,@priceToPublic,@percentToNS,@type,@id)";
cmd = new MySqlCommand(q, cn);
cmd.Parameters.AddWithValue("@magName", magName);
cmd.Parameters.AddWithValue("@magNumber", magNumber);
cmd.Parameters.AddWithValue("@dateRelase", dateRelase);
cmd.Parameters.AddWithValue("@nameRelase", nameRelase);
cmd.Parameters.AddWithValue("@priceToPublic", priceToPublic);
cmd.Parameters.AddWithValue("@percentToNS", percentToNS);
cmd.Parameters.AddWithValue("@type", (int)type);
cmd.Parameters.AddWithValue("@id", id);
return(CallFunctionTemplate());
}
/// <summary>
/// insert a new magazine, and eventually add a new owner, if not listed yet
/// </summary>
/// <param name="title">magazine title</param>
/// <param name="period">magazine periodicity</param>
/// <param name="lastnameOwner">magazine owner lastname</param>
/// <param name="nameOwner">magazine owner name</param>
/// <returns>the returned value from stored function on database. Return -1 if an error occurred</returns>
public string InsertMagazine(string title, string period, string lastnameOwner, string nameOwner, updateType type, string id)
{
string q = "SELECT insertMagazine(@title,@period,@lastnameOwner,@nameOwner,@type,@id)";
cmd = new MySqlCommand(q, cn);
cmd.Parameters.AddWithValue("@title", title);
cmd.Parameters.AddWithValue("@period", period);
cmd.Parameters.AddWithValue("@lastnameOwner", lastnameOwner);
cmd.Parameters.AddWithValue("@nameOwner", nameOwner);
cmd.Parameters.AddWithValue("@type", (int)type);
cmd.Parameters.AddWithValue("@id", id);
return(CallFunctionTemplate());
}
public void ExplicitResponseMapperTest()
{
// Error.
ResponseError srcError = new ResponseError {
Code = 123, Description = "Err desc", Id = "42", Message = "Error occurred", Scope = "request"
};
errorType destError = MapperFactory.CreateInstance <ResponseError, errorType>(srcError);
// Create.
CreateStatus srcCreateStatus = new CreateStatus {
AdvisoryId = "src456", Error = srcError, Id = "cr8", StatusCode = "200"
};
createType destCreateStatus = MapperFactory.CreateInstance <CreateStatus, createType>(srcCreateStatus);
MultipleCreateResponse srcCreateResponse = new MultipleCreateResponse {
StatusRecords = new List <CreateStatus> {
srcCreateStatus
}
};
createResponseType destCreateResponse = MapperFactory.CreateInstance <MultipleCreateResponse, createResponseType>(srcCreateResponse);
int index = 0;
// Assert that the mapping was successful.
foreach (CreateStatus record in srcCreateResponse.StatusRecords)
{
Assert.AreEqual(record.AdvisoryId, destCreateResponse.creates[index].advisoryId);
Assert.AreEqual(record.Error.Code, destCreateResponse.creates[index].error.code);
Assert.AreEqual(record.Error.Description, destCreateResponse.creates[index].error.description);
Assert.AreEqual(record.Error.Id, destCreateResponse.creates[index].error.id);
Assert.AreEqual(record.Error.Message, destCreateResponse.creates[index].error.message);
Assert.AreEqual(record.Error.Scope, destCreateResponse.creates[index].error.scope);
Assert.AreEqual(record.Id, destCreateResponse.creates[index].id);
Assert.AreEqual(record.StatusCode, destCreateResponse.creates[index].statusCode);
index++;
}
// Delete.
DeleteStatus srcDeleteStatus = new DeleteStatus {
Error = srcError, Id = "del8", StatusCode = "300"
};
deleteStatus destDeleteStatus = MapperFactory.CreateInstance <DeleteStatus, deleteStatus>(srcDeleteStatus);
MultipleDeleteResponse srcDeleteResponse = new MultipleDeleteResponse {
StatusRecords = new List <DeleteStatus> {
srcDeleteStatus
}
};
deleteResponseType destDeleteResponse = MapperFactory.CreateInstance <MultipleDeleteResponse, deleteResponseType>(srcDeleteResponse);
index = 0;
// Assert that the mapping was successful.
foreach (DeleteStatus record in srcDeleteResponse.StatusRecords)
{
Assert.AreEqual(record.Error.Code, destDeleteResponse.deletes[index].error.code);
Assert.AreEqual(record.Error.Description, destDeleteResponse.deletes[index].error.description);
Assert.AreEqual(record.Error.Id, destDeleteResponse.deletes[index].error.id);
Assert.AreEqual(record.Error.Message, destDeleteResponse.deletes[index].error.message);
Assert.AreEqual(record.Error.Scope, destDeleteResponse.deletes[index].error.scope);
Assert.AreEqual(record.Id, destDeleteResponse.deletes[index].id);
Assert.AreEqual(record.StatusCode, destDeleteResponse.deletes[index].statusCode);
index++;
}
// Update.
UpdateStatus srcUpdateStatus = new UpdateStatus {
Error = srcError, Id = "up8", StatusCode = "400"
};
updateType destUpdateStatus = MapperFactory.CreateInstance <UpdateStatus, updateType>(srcUpdateStatus);
MultipleUpdateResponse srcUpdateResponse = new MultipleUpdateResponse {
StatusRecords = new List <UpdateStatus> {
srcUpdateStatus
}
};
updateResponseType destUpdateResponse = MapperFactory.CreateInstance <MultipleUpdateResponse, updateResponseType>(srcUpdateResponse);
index = 0;
// Assert that the mapping was successful.
foreach (UpdateStatus record in srcUpdateResponse.StatusRecords)
{
Assert.AreEqual(record.Error.Code, destUpdateResponse.updates[index].error.code);
Assert.AreEqual(record.Error.Description, destUpdateResponse.updates[index].error.description);
Assert.AreEqual(record.Error.Id, destUpdateResponse.updates[index].error.id);
Assert.AreEqual(record.Error.Message, destUpdateResponse.updates[index].error.message);
Assert.AreEqual(record.Error.Scope, destUpdateResponse.updates[index].error.scope);
Assert.AreEqual(record.Id, destUpdateResponse.updates[index].id);
Assert.AreEqual(record.StatusCode, destUpdateResponse.updates[index].statusCode);
index++;
}
}
/// <summary>
/// add a new phone number to somebody, and eventually add a new "somebody"
/// </summary>
/// <param name="phoneNumber">the phone number</param>
/// <param name="lastnameOwner">lastname of the phone number owner</param>
/// <param name="nameOwner">name of the phone number owner</param>
/// <returns>the returned value from stored function on database. Return -1 if an error occurred</returns>
public string InsertPhoneNumber(string phoneNumber, string lastnameOwner, string nameOwner, updateType type, string id)
{
string q = "SELECT insertPhoneNumber(@phoneN,@lastnameOwner,@nameOwner,@type,@id)";
cmd = new MySqlCommand(q, cn);
cmd.Parameters.AddWithValue("@phoneN", phoneNumber);
cmd.Parameters.AddWithValue("@lastnameOwner", lastnameOwner);
cmd.Parameters.AddWithValue("@nameOwner", nameOwner);
cmd.Parameters.AddWithValue("@type", (int)type);
cmd.Parameters.AddWithValue("@id", id);
return(CallFunctionTemplate());
}
public InsertTaskForm(DB db, updateType t)
{
InitializeComponent();
_db = db;
_t = t;
}
public InsertMagRelaseForm(DB db, updateType t)
{
InitializeComponent();
_db = db;
_t = t;
}
