public int File_Update([global::System.Data.Linq.Mapping.ParameterAttribute(Name = "Id", DbType = "UniqueIdentifier")] System.Nullable <System.Guid> id, [global::System.Data.Linq.Mapping.ParameterAttribute(Name = "Name", DbType = "NVarChar(300)")] string name, [global::System.Data.Linq.Mapping.ParameterAttribute(Name = "Type", DbType = "VarChar(30)")] string type, [global::System.Data.Linq.Mapping.ParameterAttribute(Name = "Content", DbType = "VarBinary(MAX)")] System.Data.Linq.Binary content)
{
IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), id, name, type, content);
return((int)(result.ReturnValue));
}
public int datosDelUsuario([global::System.Data.Linq.Mapping.ParameterAttribute(DbType = "Decimal(18,10)")] System.Nullable <decimal> latitudUsuario, [global::System.Data.Linq.Mapping.ParameterAttribute(DbType = "Decimal(18,10)")] System.Nullable <decimal> longitudUsuario, [global::System.Data.Linq.Mapping.ParameterAttribute(DbType = "NVarChar(30)")] string ipAddres, [global::System.Data.Linq.Mapping.ParameterAttribute(DbType = "NVarChar(50)")] string loteCerveza)
{
IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), latitudUsuario, longitudUsuario, ipAddres, loteCerveza);
return((int)(result.ReturnValue));
}
public ISingleResult <CheckDuckResult> CheckDuck([global::System.Data.Linq.Mapping.ParameterAttribute(Name = "Barcode", DbType = "NChar(20)")] string barcode)
{
IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), barcode);
return((ISingleResult <CheckDuckResult>)(result.ReturnValue));
}
public int PR_ELIMINAR_AREA([global::System.Data.Linq.Mapping.ParameterAttribute(DbType = "Int")] System.Nullable <int> codigo3)
{
IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), codigo3);
return((int)(result.ReturnValue));
}
public int SaveGame([global::System.Data.Linq.Mapping.ParameterAttribute(Name = "Moves", DbType = "VarChar(MAX)")] string moves, [global::System.Data.Linq.Mapping.ParameterAttribute(Name = "GameID", DbType = "Int")] System.Nullable <int> gameID)
{
IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), moves, gameID);
return((int)(result.ReturnValue));
}
public int PR_INSERTAR_AREA([global::System.Data.Linq.Mapping.ParameterAttribute(DbType = "VarChar(100)")] string descripcion)
{
IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), descripcion);
return((int)(result.ReturnValue));
}
public int PR_ACTUALIZAR_AREA([global::System.Data.Linq.Mapping.ParameterAttribute(DbType = "Int")] System.Nullable <int> codigo2, [global::System.Data.Linq.Mapping.ParameterAttribute(DbType = "VarChar(100)")] string descripcion2)
{
IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), codigo2, descripcion2);
return((int)(result.ReturnValue));
}
public int File_Delete([global::System.Data.Linq.Mapping.ParameterAttribute(Name = "Id", DbType = "UniqueIdentifier")] System.Nullable <System.Guid> id)
{
IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), id);
return((int)(result.ReturnValue));
}
public ISingleResult <reportResult> report()
{
IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())));
return((ISingleResult <reportResult>)(result.ReturnValue));
}
public int User_Password([global::System.Data.Linq.Mapping.ParameterAttribute(Name = "Username", DbType = "NVarChar(70)")] string username, [global::System.Data.Linq.Mapping.ParameterAttribute(DbType = "NVarChar(70)")] string prevPassword, [global::System.Data.Linq.Mapping.ParameterAttribute(DbType = "NVarChar(70)")] string newPassword)
{
IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), username, prevPassword, newPassword);
return((int)(result.ReturnValue));
}
public int User_Update([global::System.Data.Linq.Mapping.ParameterAttribute(DbType = "NVarChar(70)")] string prevUsername, [global::System.Data.Linq.Mapping.ParameterAttribute(DbType = "NVarChar(70)")] string newUsername, [global::System.Data.Linq.Mapping.ParameterAttribute(Name = "Fullname", DbType = "NVarChar(300)")] string fullname, [global::System.Data.Linq.Mapping.ParameterAttribute(Name = "IsAdmin", DbType = "Bit")] System.Nullable <bool> isAdmin)
{
IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), prevUsername, newUsername, fullname, isAdmin);
return((int)(result.ReturnValue));
}
public ISingleResult <User_LoginResult> User_Login([global::System.Data.Linq.Mapping.ParameterAttribute(Name = "Username", DbType = "NVarChar(70)")] string username, [global::System.Data.Linq.Mapping.ParameterAttribute(Name = "Password", DbType = "NVarChar(300)")] string password)
{
IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), username, password);
return((ISingleResult <User_LoginResult>)(result.ReturnValue));
}
public int Post_Update([global::System.Data.Linq.Mapping.ParameterAttribute(Name = "Id", DbType = "UniqueIdentifier")] System.Nullable <System.Guid> id, [global::System.Data.Linq.Mapping.ParameterAttribute(Name = "Title", DbType = "NVarChar(1000)")] string title, [global::System.Data.Linq.Mapping.ParameterAttribute(Name = "Abstract", DbType = "NVarChar(MAX)")] string @abstract, [global::System.Data.Linq.Mapping.ParameterAttribute(Name = "Body", DbType = "NVarChar(MAX)")] string body, [global::System.Data.Linq.Mapping.ParameterAttribute(Name = "Publish", DbType = "Bit")] System.Nullable <bool> publish, [global::System.Data.Linq.Mapping.ParameterAttribute(Name = "Date", DbType = "DateTime")] System.Nullable <System.DateTime> date, [global::System.Data.Linq.Mapping.ParameterAttribute(Name = "AdminUsername", DbType = "NVarChar(70)")] string adminUsername, [global::System.Data.Linq.Mapping.ParameterAttribute(Name = "GroupId", DbType = "UniqueIdentifier")] System.Nullable <System.Guid> groupId)
{
IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), id, title, @abstract, body, publish, date, adminUsername, groupId);
return((int)(result.ReturnValue));
}
public int Group_Update([global::System.Data.Linq.Mapping.ParameterAttribute(Name = "Id", DbType = "UniqueIdentifier")] System.Nullable <System.Guid> id, [global::System.Data.Linq.Mapping.ParameterAttribute(Name = "ParentId", DbType = "UniqueIdentifier")] System.Nullable <System.Guid> parentId, [global::System.Data.Linq.Mapping.ParameterAttribute(Name = "Name", DbType = "NVarChar(50)")] string name, [global::System.Data.Linq.Mapping.ParameterAttribute(Name = "Publish", DbType = "Bit")] System.Nullable <bool> publish, [global::System.Data.Linq.Mapping.ParameterAttribute(Name = "AdminUsername", DbType = "NVarChar(70)")] string adminUsername)
{
IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), id, parentId, name, publish, adminUsername);
return((int)(result.ReturnValue));
}
public int ManageMaintenance([Parameter(Name = "InstallationNo", DbType = "Int")] System.Nullable <int> installationNo, [Parameter(Name = "EventID", DbType = "Int")] System.Nullable <int> eventID, [Parameter(Name = "UserID", DbType = "Int")] System.Nullable <int> userID)
{
IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), installationNo, eventID, userID);
return((int)(result.ReturnValue));
}
public int UpdateAppLockState([Parameter(Name = "Lock_IDs", DbType = "VarChar(MAX)")] string lock_IDs)
{
IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), lock_IDs);
return((int)(result.ReturnValue));
}
public ISingleResult <CSlotPortStatus> GetSlotPortStatusForInstallation([Parameter(Name = "@Installation_No", DbType = "Int")] System.Nullable <int> installationNo)
{
IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), installationNo);
return((ISingleResult <CSlotPortStatus>)(result.ReturnValue));
}
public IMultipleResults GetLockTypes()
{
IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())));
return((IMultipleResults)result.ReturnValue);
}
public ISingleResult <PR_LISTAR_AREAResult> PR_LISTAR_AREA()
{
IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())));
return((ISingleResult <PR_LISTAR_AREAResult>)(result.ReturnValue));
}
public ISingleResult <rsp_GetLockDetailsResult> GetLockDetails([Parameter(Name = "Lock_Application", DbType = "VarChar(50)")] string lock_Application, [Parameter(Name = "Lock_Type", DbType = "VarChar(50)")] string lock_Type)
{
IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), lock_Application, lock_Type);
return((ISingleResult <rsp_GetLockDetailsResult>)(result.ReturnValue));
}
public ISingleResult <PR_BUSCAR_AREAResult> PR_BUSCAR_AREA([global::System.Data.Linq.Mapping.ParameterAttribute(DbType = "Int")] System.Nullable <int> codigo)
{
IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), codigo);
return((ISingleResult <PR_BUSCAR_AREAResult>)(result.ReturnValue));
}
public ISingleResult <sp_searchEmpResult> sp_searchEmp([global::System.Data.Linq.Mapping.ParameterAttribute(DbType = "Int")] System.Nullable <int> empid)
{
IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), empid);
return((ISingleResult <sp_searchEmpResult>)(result.ReturnValue));
}
public ISingleResult <GetBestMoveResult> GetBestMove([global::System.Data.Linq.Mapping.ParameterAttribute(Name = "Moves", DbType = "VarChar(MAX)")] string moves)
{
IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), moves);
return((ISingleResult <GetBestMoveResult>)(result.ReturnValue));
}
public int UpdateSlotPortStatus([Parameter(Name = "@Installation_No", DbType = "Int")] System.Nullable <int> installationNo, [Parameter(Name = "@AuxSerialPort_Enabled", DbType = "Bit")] System.Nullable <bool> auxSerialPort, [Parameter(Name = "@GatSerialPort_Enabled", DbType = "Bit")] System.Nullable <bool> gatSerialPort, [Parameter(Name = "@SlotLinePort_Enabled", DbType = "Bit")] System.Nullable <bool> slotLinePort)
{
IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), installationNo, auxSerialPort, gatSerialPort, slotLinePort);
return((int)(result.ReturnValue));
}
public ISingleResult <GetNewGameResult> GetNewGame([global::System.Data.Linq.Mapping.ParameterAttribute(Name = "SelfPlay", DbType = "Bit")] System.Nullable <bool> selfPlay)
{
IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), selfPlay);
return((ISingleResult <GetNewGameResult>)(result.ReturnValue));
}
public ISingleResult <CMaintenanceSession> GetMaintainSessionForInstallation([Parameter(Name = "InstallationNo", DbType = "Int")] System.Nullable <int> installationNo)
{
IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), installationNo);
return((ISingleResult <CMaintenanceSession>)(result.ReturnValue));
}
public ISingleResult <GetAllPrizesResult> GetAllPrizes()
{
IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())));
return((ISingleResult <GetAllPrizesResult>)(result.ReturnValue));
}
public ISingleResult <GetEventsForMaintainSessionResult> GetEventsForMaintainSession([Parameter(Name = "SessionID", DbType = "Int")] System.Nullable <int> sessionID, [Parameter(Name = "InstallationNo", DbType = "Int")] System.Nullable <int> installationNo)
{
IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), sessionID, installationNo);
return((ISingleResult <GetEventsForMaintainSessionResult>)(result.ReturnValue));
}
public int UpdatePrize([global::System.Data.Linq.Mapping.ParameterAttribute(Name = "ID", DbType = "Int")] System.Nullable <int> iD)
{
IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), iD);
return((int)(result.ReturnValue));
}
public ISingleResult <ValidateUserLoginResult> ValidateUserLogin([global::System.Data.Linq.Mapping.ParameterAttribute(Name = "IN_vEmail", DbType = "NVarChar(50)")] string iN_vEmail, [global::System.Data.Linq.Mapping.ParameterAttribute(Name = "IN_vPassword", DbType = "NVarChar(10)")] string iN_vPassword)
{
IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), iN_vEmail, iN_vPassword);
return((ISingleResult <ValidateUserLoginResult>)(result.ReturnValue));
}
