internal static void InicializarPorFecha(DateTime dtIni, DateTime dtFin)
{
String dtInic = dtIni.ToString("yyyyMMdd");
String dtFinc = dtFin.ToString("yyyyMMdd");
DataTable iterateValues = SQLDataManager.getTypeData("NULL", dtInic, dtFinc, "NULL");
List <EntityInitRawMaterial> addAllLinesToList = new List <EntityInitRawMaterial>();
iterateValuesRows = iterateValues.Rows.Count;
try
{
foreach (DataRow r in iterateValues.Rows)
{
EntityInitRawMaterial eirm = new EntityInitRawMaterial();
eirm.Orig_Ubic_Alm = r["ORIG_UBIC_ALM"].ToString();
eirm.NumMaterial = r["NumMaterial"].ToString();
eirm.Orig_Cant = r["ORIG_CANT"].ToString();
eirm.Material = r["Material"].ToString();
eirm.Conf_Usuario = r["CONF_USUARIO"].ToString();
eirm.Descripcion = r["DESCRIPCION"].ToString();
eirm.Num_Pallet = r["NUM_PALLET"].ToString();
addAllLinesToList.Add(eirm);
}
}
catch (Exception e) { LogThis.LogThisValue(e); }
foreach (EntityInitRawMaterial q in addAllLinesToList)
{
wsInitRawMaterial(q);
}
}
// Program start
static void Main(string[] args)
{
DataManager _dataManager = new SQLDataManager();
FileManager _fileManager = new HierarchicalFileManager();
UserManager _userManager = new UserManager(_dataManager, _fileManager);
ServerInterface _interface = new TCPInterface();
_interface.Run();
ActionProvider _provider = new ConsoleReaderActionProvider();
ServerAction action;
while ((action = _provider.Dequeue()).ExitServer == false)
{
if (!action.IsEmpty)
{
action.PerformAction(_userManager, _fileManager, _dataManager);
}
}
_interface.Stop();
}
protected override void OnCreate(Bundle savedInstanceState)
{
base.OnCreate(savedInstanceState);
//vmManager = new VMManager();
sqliteManager = new SQLDataManager();
}
public void ExecutStoredProcedure(string procedureName, out string result)
{
SQLDataManager sql = new SQLDataManager(false);
// {
sql.ExecuteStoredProcedure(procedureName, out var dataReader);
string returnedResult = "";
if (dataReader.HasRows)
{
int i = 0;
while (dataReader.Read())
{
returnedResult = "";
returnedResult += dataReader[i].ToString();
//result += "\t";
i++;
//return;
}
}
result = returnedResult;
// }
}
internal static void wsInitUpdateInterface(EntityInitRawMaterial q)
{
String connectionString = "ConnectToInterfaceDESA";
string queryString = @"UPDATE [Traza_material].[dbo].[XXE_WMS_COGISCAN_PEDIDO_LPNS]SET [STATUS] = 'DONE' WHERE LPN = '" + q.Num_Pallet + "'";
SQLMapper.Conectivity.ConnectItAndBringResults(queryString, connectionString);
{ SQLDataManager.IAServerInsertionLog(q, WSRequest.InitRawMaterial(q)); }
}
internal static void InicializarPorFecha(DateTime dtIni, DateTime dtFin, Boolean dataOrigin, Boolean dataCygnus)
{
String dtInic = dtIni.ToString("yyyyMMdd");
String dtFinc = dtFin.ToString("yyyyMMdd");
DataTable iterateValuesInterface = null;
List <EntityInitRawMaterial> addAllLinesToList = new List <EntityInitRawMaterial>();
List <EntityInitRawMaterial> addAllLinesToListInterface = new List <EntityInitRawMaterial>();
if (dataOrigin)
{
iterateValuesInterface = SQLDataManager.GetLPNFromInterface();
}
if (dataCygnus)
{
//iterateValuesCygnus = SQLDataManager.getTypeData("NULL", dtInic, dtFinc, "NULL");
}
int iterateValuesInterfaceRows = iterateValuesInterface.Rows.Count;
//int iterateValuesCygnussRows = iterateValuesCygnus.Rows.Count;
try
{
foreach (DataRow r in iterateValuesInterface.Rows)
{
EntityInitRawMaterial eirm = new EntityInitRawMaterial();
eirm.Orig_Ubic_Alm = r["PROD_LINE"].ToString();
eirm.NumMaterial = r["ITEM_CODE"].ToString();
eirm.Orig_Cant = r["LPN_QUANTITY"].ToString();
eirm.Material = r["ITEM_CODE"].ToString();
eirm.Conf_Usuario = r["LAST_UPDATED_BY"].ToString();
eirm.Descripcion = r["OP_NUMBER"].ToString();
eirm.Num_Pallet = r["LPN"].ToString();
addAllLinesToListInterface.Add(eirm);
}
}
catch (Exception e)
{
System.Console.WriteLine("ERROR: " + e.Message);
}
//foreach (EntityInitRawMaterial q in addAllLinesToList)
//{ wsInitRawMaterial(q); }
foreach (EntityInitRawMaterial q in addAllLinesToListInterface)
{
wsInitUpdateInterface(q);
}
specialRun : string specialRun = "";
}
private string CreateTable(string formdata, string formname)
{
SQLDataManager sql = new SQLDataManager(false);
//string query_create = "CREATE TABLE template_" + formname.Replace(" ", "").ToLower() + " (Id INT IDENTITY(1,1), accountid int, locationid int, patientid varchar(100)";
string query_create = "CREATE TABLE template_" + formname.Replace(" ", "").ToLower() + " (Id INT, encodedby int foreign key references ApplicationUser(AppUserId), encounterid int foreign key references checkin(encounterid),accountid int, locationid int, patientid varchar(100)";
// s789990-
//List<Component> request = new List<Component>();
try
{
FormDirect myform = new FormDirect();
myform = JsonConvert.DeserializeObject <FormDirect>(formdata);
for (int k = 0; k < myform.components.Count; k++)
{
//Detail mydetail = mycomponent.components[i].;
query_create += "," + myform.components[k].key.ToString().Replace(" ", "").ToLower() + " varchar(100)";
}
//Form myform = new Form();
//myform = JsonConvert.DeserializeObject<Form>(formdata);
//for (int i = 0; i < myform.components.Count; i++)
//{
// Columns mycolumn = myform.components[i];
// for (int j = 0; j < mycolumn.columns.Count; j++)
// {
// Component mycomponent = mycolumn.columns[j];
// for (int k = 0; k < mycomponent.components.Count; k++)
// {
// //Detail mydetail = mycomponent.components[i].;
// query_create += "," + mycomponent.components[k].key.ToString().Replace(" ", "").ToLower() + " varchar(100)";
// }
// }
// //query_create += ","+myform.components[i].key.ToString().Replace(" ", "").ToLower() + " varchar(100)";
//}
}
catch (Exception)
{
FormDirect myform = new FormDirect();
myform = JsonConvert.DeserializeObject <FormDirect>(formdata);
for (int k = 0; k < myform.components.Count; k++)
{
//Detail mydetail = mycomponent.components[i].;
query_create += "," + myform.components[k].key.ToString().Replace(" ", "").ToLower() + " varchar(100)";
}
}
//query_create += $" , Dateadded datetime DEFAULT GETDATE(), CONSTRAINT [{formname.Replace(" ", "").ToLower()+"_"+Guid.NewGuid().ToString()}] PRIMARY KEY CLUSTERED ([id] asc) )";
query_create += $" , Dateadded varchar(100) default '', oldid int default 0,CONSTRAINT [{formname.Replace(" ", "").ToLower() + "_" + Guid.NewGuid().ToString()}] PRIMARY KEY CLUSTERED ([id] asc) )";
sql.ExecuteNonQuery(query_create, CommandType.Text);
return("Success");
}
public IActionResult SaveData(FormData request)
{
SQLDataManager sql = new SQLDataManager(false);
if (request != null && request.formname != null && request.formdata != null)
{
string query = "insert into template_" + request.formname.Replace(" ", "").ToLower() + " " + request.formdata;
sql.ExecuteNonQuery(query, CommandType.Text);
return(Ok("Success"));
}
else
{
return(BadRequest("Invalid/Bad Request"));
}
}
internal static String InitRawMaterial(Entity.EntityInitRawMaterial q)
{
String resultReturn = "";
try
{
DataTable queryTable = new DataTable();
String queryString = "select * from materiales where num_pallet='" + q.Num_Pallet + "'";
String connectionStringFromAppConfig = "ConnectToMySQL";
queryTable = Conectivity.ConnectItAndExecuteMYSQL(queryString, connectionStringFromAppConfig);
if (queryTable.Rows.Count == 0)
{
RPCServicesClient RPC = new RPCServices_CogiscanManager.RPCServicesClient();
String partNumber = SQLDataManager.selectValuesFromMateriales(q.NumMaterial);
executeCommandRequest paramInitRawMat = new executeCommandRequest("initializeRawMaterial", @"
<Parameters>
<Parameter name=""itemId"">" + q.Num_Pallet + @"</Parameter>
<Parameter name=""partNumber"">" + partNumber + @"</Parameter>
<Parameter name=""msLevel"">1</Parameter>k
<Parameter name=""containerType"">REEL</Parameter>
<Parameter name=""supplierId"">Default</Parameter>
<Parameter name=""quantity"">" + q.Orig_Cant + @"</Parameter>
<Parameter name=""tagId""></Parameter>
<Parameter name=""tagModel""></Parameter>
</Parameters>");
executeCommandResponse res = RPC.executeCommand(paramInitRawMat);
LogThis.LogThisValue("Material Inicializado: " + q.Num_Pallet);
takeTheThreadFlag(Form1.logRTBInitRaw, true, q.Num_Pallet);
resultReturn = CleanInput(res.result);
}
else
{
return(null);
}
}
catch (Exception e)
{ LogThis.LogThisValue(e); return(e.Message); }
return(resultReturn);
}
internal static String InitRawMaterial(Entity.EntityInitRawMaterial q)
{
String resultReturn = "";
try
{
DataTable queryTable = new DataTable();
String queryString = "select num_pallet from materiales where num_pallet='" + q.Num_Pallet + "'";
String connectionStringFromAppConfig = "ConnectToMySQL";
queryTable = Conectivity.ConnectItAndExecuteMYSQL(queryString, connectionStringFromAppConfig);
if (queryTable.Rows.Count == 0)
{
String partNumber = SQLDataManager.selectValuesFromMateriales(q.NumMaterial);
//Boolean opNotInit = CheckIfOpMustInit(q.NumMaterial, q.Num_Pallet);
//if (opNotInit)
//{ goto skipped; }
RPCServicesClient RPC = new RPCServicesClient();
executeCommandRequest paramInitRawMat = new executeCommandRequest("initializeRawMaterial", @"
<Parameters>
<Parameter name=""itemId"">" + q.Num_Pallet + @"</Parameter>
<Parameter name=""partNumber"">" + partNumber + @"</Parameter>
<Parameter name=""containerType"">REEL</Parameter>
<Parameter name=""supplierId"">DEFAULT</Parameter>
<Parameter name=""quantity"">" + q.Orig_Cant + @"</Parameter>
<Parameter name=""tagId""></Parameter>
<Parameter name=""tagModel""></Parameter>
</Parameters>");
executeCommandResponse res = RPC.executeCommand(paramInitRawMat);
//LogThis.LogThisValue("Material Inicializado: " + q.Num_Pallet);
takeTheThreadFlag(Form1.logRTBInitRaw, true, q.Num_Pallet);
resultReturn = CleanInput(res.result);
if (res.result.Contains("<Success />"))
{
executeCommandRequest paramLoadRawMat = new executeCommandRequest("load", @"
<Parameters>
<Parameter name=""contentId"">" + q.Num_Pallet + @"</Parameter>
<Parameter name=""containerId"">DEFAULTSTORAGE</Parameter>
<Parameter name=""location""></Parameter>
<Parameter name=""unloadPrevious"">false</Parameter>
<Parameter name=""deletePrevious"">false</Parameter>
</Parameters>");
string responseFromLoad = executeWSRequest(paramLoadRawMat);
resultReturn = "||" + responseFromLoad + "OnLoad - ";
}
skipped : string skipped = "";
}
else
{
return(null);
}
}
catch (Exception e)
{ System.Console.WriteLine(e.Message); }
return(resultReturn);
}
internal static void wsInitRawMaterial(EntityInitRawMaterial q)
{
SQLDataManager.IAServerInsertionLog(q, WSRequest.InitRawMaterial(q));
}
public UserConnection(string id, string pipename, Connection connection) : base(id)
{
npcs = new NamedPipeClientStream(pipename);
this.connection = connection;
sqldm = new SQLDataManager(this.connection.ActiveConnection);
}
