public async Task <JsonResult> GetConnectionSingleByMID(string ID)
{
try {
var data = ConnectionServices.GetByMemberSingleID(ID);
var vmModel = new List <ConnectionViewModel>();
foreach (var model in data)
{
var temp = new ConnectionViewModel()
{
ID = model.ID.ToString(),
GroupName = model.ConnectionName
};
foreach (var member in model.Members)
{
//assign userinformationmodel
var vm = new UserInformationViewModel()
{
User = member.UserID.ToString()
};
temp.PushMembers(member, vm);
}
vmModel.Add(temp);
}
return(Json(new { success = true, data = vmModel }, JsonRequestBehavior.AllowGet));
} catch (Exception e) {
Console.Write(e);
return(Json(new { success = false, message = MessageUtility.ServerError() }, JsonRequestBehavior.AllowGet));
}
}
public ApiResponse ValidateLearningOpportunityConnection(string ctid)
{
bool isValid = true;
List <string> messages = new List <string>();
var response = new ApiResponse();
//some validation?
string apiKey = "";
//can the api validation and request validation be done at the same time to minimize
//if ( !AuthorizationServices.IsAuthTokenValid( true, ref apiKey, ref statusMessage ) )
//{
// response.Messages.Add( "Error: A valid Apikey was not provided in an Authorization Header. " + statusMessage );
// return response;
//}
if (string.IsNullOrWhiteSpace(ctid) || ctid.Length != 39)
{
response.Messages.Add("A valid LearningOpportunity CTID must be provided.");
return(response);
}
//
string status = "";
if (ConnectionServices.DoesLearningOpportunityHaveCredentialConnection(ctid, ref status))
{
response.Successful = true;
}
else
{
LoggingHelper.DoTrace(6, string.Format("CredentialFinderWebAPI.ValidationController.ValidateLearningOpportunityConnection FAILED for LearningOpportunityCTID:{0}", ctid));
response.Messages.Add("The LearningOpportunity is not connected to any credentials.");
}
return(response);
}
public async Task <JsonResult> Insert()
{
try {
var id = Guid.NewGuid();
var rfrom = Request.Form["RF"];
var rtID = Request.Form["RTID"];
var connID = Request.Form["CID"];
var connection = ConnectionServices.GetByID(connID);
//first check if it is already existing
var temp = RequestService.GetByConnectionIDRTID(connID, rtID);
if (temp == null)
{
if (RequestService.Insert(id, rfrom, Guid.Parse(rtID), Guid.Parse(connID), false))
{
SignalRClients.NotifyInvitationSent(connection.ConnectionName, connection.ID.ToString(), rtID);
return(Json(new { success = true }));
}
}
else if (temp.isArchived)
{
//if it already exist and is archived then unarchive it
RequestService.UpdateStatus(false, temp.ID.ToString());
SignalRClients.NotifyInvitationSent(connection.ConnectionName, connection.ID.ToString(), rtID);
return(Json(new { success = true }));
}
return(Json(new { success = false, message = MessageUtility.ServerError() }));
} catch { return(Json(new { success = false, message = MessageUtility.ServerError() })); }
}
public frmConnection()
{
InitializeComponent();
cboAuthType.Items.Add("Windows Authentication");
cboAuthType.Items.Add("SQL Server Authentication");
_connectionProvider = new ConnectionServices();
cboAuthType.SelectedIndex = (int)AuthType.Windows;
}
public string SendMessage(string message)
{
using (var svr = new ConnectionServices())
{
svr.Connect(HsmIp, HsmPort);
string hsmResponse = svr.SendCommand(message);
return(hsmResponse);
}
}
public async Task <JsonResult> CreateConnection()
{
try {
var uid = Request.Form["UID"];
var conName = Request.Form["CNAME"];
var API = Guid.Parse(Request.Form["API"]);
var cid = Guid.NewGuid();
ConnectionServices.Insert(cid, true, conName, DateTime.Now, API);
var mid = Guid.NewGuid();
ConnectionMemberService.InsertMember(mid, Guid.Parse(uid), cid.ToString(), DateTime.Now, false, true);
return(Json(new { success = true }));
} catch { return(Json(new { success = false, message = MessageUtility.ServerError() })); }
}
protected byte[] SendBytes(byte[] message)
{
try
{
using (var svr = new ConnectionServices(HsmIp, HsmPort))
{
byte[] hsmResponse = svr.SendBytes(message);
return(hsmResponse);
}
}
catch (TimeoutException e)
{
logger.Error(e.ToString());
throw;
}
}
protected string SendMessage(string message)
{
try
{
using (var svr = new ConnectionServices(HsmIp, HsmPort))
{
string hsmResponse = svr.SendCommand(message);
return(hsmResponse);
}
}
catch (TimeoutException e)
{
logger.Error(e.ToString());
throw;
}
}
static void Main()
{
string server = "cwagner01"; //API Server
string dsn = "FactoryLogix2019"; //Database Name
string userName2 = "AegisAdmin";
string password = "";
ConnectionServices cs = new ConnectionServices();
sessionID = cs.Connect(server, userName2, password, dsn, System.Threading.Thread.CurrentThread.CurrentUICulture.TwoLetterISOLanguageName);
//Enter part number
Console.Write("Enter Part Number: ");
var partnumber = Console.ReadLine();
//retrieve part number
var pn = _partServices.FindParts(sessionID, PartKind.Internal, RevisionKind.CurrentRevision, AssemblyKind.BasicPartsOnly, partnumber, "*", "*", 2, 1);
//check to see if Part Number exists
if (pn.Results.Count == 0)
{
Console.WriteLine("***The Part Number does not exist***");
}
else
//Cast results as an InternalPart
if (pn.Results[0] is InternalPart)
{
Console.WriteLine($"Description: " + ((InternalPart)pn.Results[0]).Description);
Console.WriteLine($"Revision: " + ((InternalPart)pn.Results[0]).Revision);
Console.WriteLine($"Allow Simultaneous Loading: " + ((InternalPart)pn.Results[0]).SimultaneousLoading);
Console.WriteLine($"RoHS: " + ((InternalPart)pn.Results[0]).IsRoHS);
Console.WriteLine($"Part Label: " + ((InternalPart)pn.Results[0]).PartLabel);
Console.WriteLine($"Package Type: " + ((InternalPart)pn.Results[0]).PackageName);
Console.WriteLine($"Part Type: " + ((InternalPart)pn.Results[0]).PartType);
Console.WriteLine($"Technology: " + ((InternalPart)pn.Results[0]).MountingTechnology);
Console.WriteLine($"Unit of Issue: " + ((InternalPart)pn.Results[0]).UnitOfIssue);
Console.WriteLine($"Polarized: " + ((InternalPart)pn.Results[0]).IsPolarized);
Console.WriteLine($"Socket: " + ((InternalPart)pn.Results[0]).IsSocket);
Console.WriteLine($"Default Stock Location: " + ((InternalPart)pn.Results[0]).DefaultStockLocation);
Console.WriteLine("");
}
Console.WriteLine("Press any key to exit");
Console.ReadKey();
}
private void btnGetTables_Click(object sender, EventArgs e)
{
SchemaData schemaData = new SchemaData();
try
{
RefreshTreeView(schemaData);
btnNext.Enabled = true;
ConnectionServices.CleanErrorMsg();
}
catch (Exception ex)
{
MessageBox.Show(string.Format("讀取資料表時發生錯誤. SysInfo={0}", ex.Message), this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
btnNext.Enabled = false;
ConnectionServices.Error(ex);
ConnectionServices.ShowConnectWindow();
RefreshTreeView(schemaData);
}
}
public async Task <JsonResult> LeaveConnection()
{
try {
var mid = Request.Form["MID"];
var uid = Request.Form["UID"];
var cid = Request.Form["CID"];
var conn = ConnectionServices.GetByID(cid);
ConnectionMemberService.UpdateMemberStatus(mid, true);
//if there no active users in this connection then remove this data from the database
if (conn.Members.Where(x => x.isArchived == false).Count() <= 0)
{
//remove data from database
ConnectionMemberService.RemoveMembersByConnectionID(cid);
ConnectionServices.RemoveConnection(cid);
}
return(Json(new { success = true }));
} catch { return(Json(new { success = false, message = MessageUtility.ServerError() })); }
}
private static void Main()
{
//
var serverAddress = ConfigurationManager.AppSettings["FlxApplicationServerName"];
var username = ConfigurationManager.AppSettings["FlxServiceAccountName"];
var password = ConfigurationManager.AppSettings["FlxServiceAccountPassword"];
var testPartNumber = ConfigurationManager.AppSettings["TestPartNumber"];
var testSerialNumber = ConfigurationManager.AppSettings["TestSerialNumber"];
var conn = new ConnectionServices();
var dbConnName = "FactoryLogix2019";
_sessionId = conn.Connect(serverAddress, username, password, dbConnName);
var assemblyParameter = new ParameterValue
{
DataSourceId = "WIP 1",
ParameterId = "Assembly"
};
assemblyParameter.Values.Add(testPartNumber);
var serialNumberParameter = new ParameterValue
{
DataSourceId = "WIP 1",
ParameterId = "Serial Number"
};
serialNumberParameter.Values.Add(testSerialNumber);
//System.ServiceModel.QuotaExceededException is thrown using GetDataTemplate
var template = _reportingService.GetDataTemplate(_sessionId, "whippy");
var result = _reportingService.RunDataTemplate(_sessionId, template.Id, new [] { assemblyParameter, serialNumberParameter });
Console.ReadKey();
}
static void Main(string[] args)
{
AtmRequestHelper atmRequestHelper = new AtmRequestHelper();
string ip = "127.0.0.1";
int port = 8000;
Log.Debug(string.Format("Connect to {0}, Port {1}", ip, port));
string isContinue = "y";
while (isContinue == "y")
{
Console.WriteLine(@"How many ATM ?:");
string input = Console.ReadLine(); // Read string from console
int count;
if (int.TryParse(input, out count)) // Try to parse the string as an integer
{
string m1 = "<STX>00000000td2W0 <FS>S9111111 <FS>11<FS>";
string m3 = "<FS>4089670000392726=17112011000017980000<FS>00008900<FS>00000200<FS>76728398F76ED27D<FS><FS><FS>VA6.00.12WV02.70.10 V06.01.12 0 0T 00 100 00000302K0288000000002K028800000000000000000000000000000000000000<FS><FS><FS><ETX>";
for (int i = 1; i <= count; i++)
{
string m2 = i.ToString("D4");
byte[] rawMessageBytes = atmRequestHelper.BuildMessageBytesForAtmRequest(m1 + m2 + m3); // Bulid byte
ConnectionServices svc = new ConnectionServices();
svc.Connect(i, ip, port);
svc.Send(rawMessageBytes);
}
}
else
{
Console.WriteLine("Not an integer!");
}
Console.WriteLine("Input y to continue");
isContinue = Console.ReadLine();
Console.Clear();
}
}
public async Task <JsonResult> GetConnectionMemberUpdatedLocation(string connection)
{
try {
ConnectionViewModel param = json_serializer.Deserialize <ConnectionViewModel>(connection);
var connectionData = ConnectionServices.GetByID(param.ID);
var temp = new ConnectionViewModel()
{
ID = param.ID,
GroupName = param.GroupName
};
foreach (var member in connectionData.Members)
{
if (member.isArchived == false)
{
var vm = new UserInformationViewModel()
{
User = member.UserID.ToString(),
};
temp.PushMembers(member, vm);
}
}
return(Json(new { success = true, data = temp }, JsonRequestBehavior.AllowGet));
} catch { return(Json(new { success = false, message = MessageUtility.ServerError() }, JsonRequestBehavior.AllowGet)); }
}
public async Task <JsonResult> AcceptRequest()
{
try {
var rid = Request.Form["RID"];
//connID
var cid = Request.Form["CID"];
//recquestTo UID
var rtID = Request.Form["RTID"];
//checks if it is already existing
var data = ConnectionServices.GetByUIDConnectionID(rtID, cid);
if (data == null)
{
//create if not existing yet
var id = Guid.NewGuid();
ConnectionMemberService.InsertMember(id, Guid.Parse(rtID), cid, DateTime.Now, false, false);
RequestService.UpdateStatus(true, rid);
//signalR notify accepted request is a standalone now if you want to invoke it please access it via api
return(Json(new { success = true }));
}
else if (data.isArchived)
{
//if data already exist then unarchive it
ConnectionMemberService.UpdateMemberStatus(data.ID.ToString(), false);
RequestService.UpdateStatus(true, rid);
//signalR notify accepted request is a standalone now if you want to invoke it please access it via api
return(Json(new { success = true }));
}
else if (!data.isArchived)
{
RequestService.UpdateStatus(true, rid);
return(Json(new { success = false, message = MessageUtility.AlreadyMember() }));
}
return(Json(new { success = false, message = MessageUtility.ServerError() }));
} catch { return(Json(new { success = false, message = MessageUtility.ServerError() })); }
}
public frmConnection(ConnectionServices connectionProvider)
: this()
{
_connectionProvider = connectionProvider;
}
public static List <Connexion> GetConnexions()
{
return(ConnectionServices.GetConnexions());
}
