public JsonResult GetContractsFileModel()
{
var filtrCriteria = new AccountFilterCriteria <Contracts> ();
filtrCriteria.AddCriterion(new Criterion()
{
Attribute = "DEV.CODE", Filter = "6600"
});
filtrCriteria.AddCriterion(new Criterion()
{
Attribute = "PROJ.CODE", Filter = "6606"
});
filtrCriteria.AddCriterion(new Criterion()
{
Attribute = "LEND.CODE", Filter = "100"
});
filtrCriteria.AddCriterion(new Criterion()
{
Attribute = "AC", Filter = "N"
});
var credentials = new CssCredentials();
var model = new ContractsFilterCallModel()
{
Credentials = credentials, FilterCriteria = filtrCriteria
};
return(new JsonResult(model));
}
// ReSharper disable once UnusedMember.Global
public ChangeItRequest(string changeType, AccountList getList, CssCredentials credentials, CssAccountFile file, Note note)
{
TypeOfChange = changeType;
GetListName = getList;
Credentials = credentials;
File = file;
Note = note;
}
public CssCallModel(CssAccountFile file)
{
File = file;
Credentials = new CssCredentials();
CssDataFile = new AccountList()
{
AccountListName = "empty"
};
}
private static CssCommandResult MakeMultiNote(AccountList list, Note note, CssCredentials cssCredentials)
{
var result = new CssCommandResult();
var lHostName = _cssHostname ?? cssCredentials.Hostname;
var lAccount = _cssAccount ?? cssCredentials.Account;
var lUser = _cssUserName ?? cssCredentials.User;
var lPassword = _cssUserPassword ?? cssCredentials.UserPassword;
const string lServiceType = CssServiceType;
UniSession us = null;
try
{
Console.WriteLine($"{lHostName}, {lUser}, {lAccount}, {lServiceType}");
us = UniObjects.OpenSession(lHostName, lUser, lPassword, lAccount, lServiceType);
UniCommand cmd = us.CreateUniCommand();
cmd.Command = $"GET-LIST {list.AccountListName}";
cmd.Execute();
cmd.Command = "MULTI.NOTES";
cmd.Execute();
cmd.Reply($"{note.Message}");
cmd.Reply("AGHERRERA");
cmd.Reply("G");
int lineNumber = 0;
foreach (var line in cmd.Response.Split("\r\n"))
{
result.Results.Add(new CommandResponse($"Response Line: {++lineNumber}", line));
}
return(result);
}
catch (Exception ex)
{
result.Results.Add(new CommandResponse("Exception", ex.ToString()));
}
finally
{
if (us != null && us.IsActive)
{
UniObjects.CloseSession(us);
}
}
result.Results.Add(new CommandResponse("Error", "There was an error procesing your request."));
return(result);
}
private static CssCommandResult Filter(string indexFile, string developerCode, string filterCriteria,
AccountList saveListName, CssCredentials cssCredentials)
{
var result = new CssCommandResult();
var lHostName = _cssHostname ?? cssCredentials.Hostname;
var lAccount = _cssAccount ?? cssCredentials.Account;
var lUser = _cssUserName ?? cssCredentials.User;
var lPassword = _cssUserPassword ?? cssCredentials.UserPassword;
const string lServiceType = CssServiceType;
UniSession us = null;
try
{
Console.WriteLine($"{lHostName}, {lUser}, {lAccount}, {lServiceType}");
//get the session object
us = UniObjects.OpenSession(lHostName, lUser, lPassword, lAccount, lServiceType);
UniCommand cmd = us.CreateUniCommand();
cmd.Command = $"SELECT {indexFile} WITH DEV.CODE = \"{developerCode}\"";
cmd.Execute();
result.Results.Add(new CommandResponse(cmd.Command, cmd.Response));
cmd.Command = $"QSELECT {indexFile}";
cmd.Execute();
result.Results.Add(new CommandResponse(cmd.Command, cmd.Response));
cmd.Command = filterCriteria;
cmd.Execute();
result.Results.Add(new CommandResponse(cmd.Command, cmd.Response));
cmd.Command = $"SAVE-LIST {saveListName}";
cmd.Execute();
result.Results.Add(new CommandResponse(cmd.Command, cmd.Response));
return result;
}
catch (Exception ex)
{
result.Results.Add(new CommandResponse("Exception", ex.ToString()));
}
finally
{
if (us != null && us.IsActive)
{
UniObjects.CloseSession(us);
}
}
result.Results.Add(new CommandResponse("Error", "There was an error procesing your request."));
return result;
}
public ActionResult <MaintFilterCallModel> GetMaintFileModel()
{
var filtrCriteria = new AccountFilterCriteria <Maint>();
filtrCriteria.AddCriterion(new Criterion()
{
Attribute = "DEV.CODE", Filter = "1075"
});
var credentials = new CssCredentials();
var model = new MaintFilterCallModel()
{
Credentials = credentials, FilterCriteria = filtrCriteria
};
return(model);
}
public static CssCommandResult MakeCustomGetList(IEnumerable<string> list,
AccountList saveList,
CssCredentials cssCredentials)
{
return CustomGetList(list, saveList, cssCredentials);
}
public static CssCommandResult FilterContracts(AccountFilterCriteria<Contracts> contractsFilter, AccountList saveList,
CssCredentials cssCredentials)
{
return Filter("ACTIVE.IDX", contractsFilter.DeveloperCode, contractsFilter.ToString(), saveList, cssCredentials);
}
public static CssCommandResult FilterMaint(AccountFilterCriteria<Maint> mainFilter, AccountList saveList,
CssCredentials cssCredentials)
{
return Filter("MACTIVE.IDX", mainFilter.DeveloperCode, mainFilter.ToString(), saveList, cssCredentials);
}
private static CssCommandResult CustomGetList(IEnumerable<string> accountList, AccountList saveListName, CssCredentials cssCredentials)
{
var result = new CssCommandResult();
var lHostName = _cssHostname ?? cssCredentials.Hostname;
var lAccount = _cssAccount ?? cssCredentials.Account;
var lUser = _cssUserName ?? cssCredentials.User;
var lPassword = _cssUserPassword ?? cssCredentials.UserPassword;
const string lServiceType = CssServiceType;
UniSession us = null;
try
{
Console.WriteLine($"{lHostName}, {lUser}, {lAccount}, {lServiceType}");
//get the session object
us = UniObjects.OpenSession(lHostName, lUser, lPassword, lAccount, lServiceType);
UniCommand cmd = us.CreateUniCommand();
cmd.Command = $"EDIT-LIST {saveListName.AccountListName}";
cmd.Execute();
result.Results.Add(new CommandResponse(cmd.Command, cmd.Response));
cmd.Reply("I"); //Get list ready for insert
foreach (var acct in accountList)
{
if (!acct.Contains("=")) continue;
var account = acct.Split("=")[1].Replace("]","");
cmd.Reply($"{account}");
}
cmd.Reply(""); // Send empty marker to close list
cmd.Reply("FI"); // Save list
result.Results.Add(new CommandResponse(cmd.CommandStatus.ToString(), cmd.Response));
return result;
}
catch (Exception ex)
{
result.Results.Add(new CommandResponse("Exception", ex.ToString()));
}
finally
{
if (us != null && us.IsActive)
{
UniObjects.CloseSession(us);
}
}
result.Results.Add(new CommandResponse("Error", "There was an error procesing your request."));
return result;
}
public CustomGetList()
{
Credentials = new CssCredentials();
Accounts = new List <string>();
}
public static CssCommandResult ChangeAccountCode(CssAccountFile file, AccountList list, AccountCode newCode, Note changeNote, CssCredentials cssCredentials)
{
return(ChangeIt2(file, list, "", "", "", newCode.Code, changeNote, cssCredentials));
}
public MaintFilterCallModel()
{
Credentials = new CssCredentials();
FilterCriteria = new AccountFilterCriteria <Maint>();
}
public MultiNoteModel()
{
GetList = new AccountList();
Credentials = new CssCredentials();
Note = new Note("This is the note");
}
public static CssCommandResult MakeNote(AccountList list, Note note, CssCredentials cssCredentials)
{
return(MakeMultiNote(list, note, cssCredentials));
}
public ContractsFilterCallModel()
{
Credentials = new CssCredentials();
FilterCriteria = new AccountFilterCriteria <Contracts>();
}
private static CssCommandResult ChangeIt2(CssAccountFile file, AccountList list, string developerCode, string projectCode, string lenderCode, string accountCode, Note changeNote, CssCredentials cssCredentials)
{
var result = new CssCommandResult();
var lHostName = _cssHostname ?? cssCredentials.Hostname;
var lAccount = _cssAccount ?? cssCredentials.Account;
var lUser = _cssUserName ?? cssCredentials.User;
var lPassword = _cssUserPassword ?? cssCredentials.UserPassword;
const string lServiceType = CssServiceType;
string fileInitial = file.FileName.ToCharArray() [0].ToString();
UniSession us = null;
try {
Console.WriteLine($"{lHostName}, {lUser}, {lAccount}, {lServiceType}");
//get the session object
us = UniObjects.OpenSession(lHostName, lUser, lPassword, lAccount, lServiceType);
UniCommand cmd = us.CreateUniCommand();
cmd.Command = "CHANGE.IT2";
cmd.Execute();
//result.Results.Add(new CommandResponse(cmd.Command, cmd.Response));
//ENTER THE LIST NAME YOU ARE USING
cmd.Reply($"{list.AccountListName}");
//result.Results.Add(new CommandResponse("", cmd.Response));
//'C'ONTRACT OR 'M'AINTENANCE IDS? ?
cmd.Reply($"{fileInitial}");
//result.Results.Add(new CommandResponse($"{fileInitial}", cmd.Response));
//CHANGE MAINTENANCE TOO? (IF APPLICABLE) ?
cmd.Reply("N");
//result.Results.Add(new CommandResponse("N", cmd.Response));
//ENTER NEW DEVELOPER CODE, IF ANY ?
if (!string.IsNullOrEmpty(developerCode))
{
cmd.Reply($"{developerCode}");
//result.Results.Add(new CommandResponse($"{developerCode}", cmd.Response));
//WARNING: Dev Code changes may cause conflict with legal agreements.\r\n
//Is our legal department aware of new dev/len relationships? (Y/N)
cmd.Reply("Y");
//result.Results.Add(new CommandResponse("Legal Department", cmd.Response));
}
else
{
cmd.Reply($"{developerCode}");
//result.Results.Add(new CommandResponse($"{projectCode}", cmd.Response));
}
//Project?
cmd.Reply($"{projectCode}");
//result.Results.Add(new CommandResponse($"{projectCode}", cmd.Response));
//Lender
cmd.Reply($"{lenderCode}");
//result.Results.Add(new CommandResponse($"{lenderCode}", cmd.Response));
//AccountCode
cmd.Reply($"{accountCode}");
//result.Results.Add(new CommandResponse($"{accountCode}", cmd.Response));
//Note
cmd.Reply($"{changeNote.Message}");
//result.Results.Add(new CommandResponse($"{changeNote.Message}", cmd.Response));
//Note Type
cmd.Reply("G");
//result.Results.Add(new CommandResponse($"NoteType", cmd.Response));
if (cmd.Response.Contains("OKAY TO PROCEED? (Y/N)"))
{
//OKAY TO PROCEED? (Y/N)
cmd.Reply("Y");
}
else
{
throw new Exception($"Could not get confirmation message. Raw result: {cmd.Response}");
}
int lineNumber = 0;
foreach (var line in cmd.Response.Split("\r\n"))
{
result.Results.Add(new CommandResponse($"Response Line: {++lineNumber}", line));
}
return(result);
} catch (Exception ex) {
result.Results.Add(new CommandResponse("Exception", ex.ToString()));
} finally {
if (us != null && us.IsActive)
{
UniObjects.CloseSession(us);
}
}
result.Results.Add(new CommandResponse("Error", "There was an error procesing your request."));
return(result);
}
public static CssCommandResult ChangeDplCode(CssAccountFile file, AccountList list, DplCode newCode, Note changeNote, CssCredentials cssCredentials)
{
return(ChangeIt2(file, list, newCode.GetDeveloperCode(), newCode.GetProjectCode(), newCode.GetLenderCode(), "", changeNote, cssCredentials));
}
public static CssFileResult GetData(AccountList list, CssAccountFile file, CssCredentials cssCredentials)
{
var lHostName = cssCredentials.Hostname;
var lAccount = cssCredentials.Account;
var lUser = cssCredentials.User;
var lPassword = cssCredentials.UserPassword;
var lServiceType = cssCredentials.ServiceType;
var response = new CssFileResult();
var fileResults = new CssFile {
FileName = list.AccountListName
};
UniSession us = null;
try
{
//get the session object
us = UniObjects.OpenSession(lHostName, lUser, lPassword, lAccount, lServiceType);
// create select list
UniSelectList selectList = us.CreateUniSelectList(2);
selectList.GetList(list.AccountListName);
// read records using array of records ids
var ids = selectList.ReadListAsStringArray();
//open file
UniFile cssFile = us.CreateUniFile(file.FileName);
var lSet = cssFile.ReadRecords(ids);
//var dict = us.CreateUniDictionary(file.FileName);
//var field1 = dict.ReadField(1);
//use foreach statement to construct data to be displayed
foreach (UniRecord item in lSet)
{
var record = new CssRecord(item.RecordID, "");
var numFields = item.Record.Dcount();
for (int i = 0; i < numFields; i++)
{
var field = item.Record.Extract(i);
var valuesCount = field.Dcount();
if (valuesCount > 1)
{
throw new Exception("This field has sub-values" + field);
}
record.Fields.Add(new CssField(i.ToString(), field.ToString()));
}
fileResults.Records.Add(record);
}
response.FileContents = fileResults;
return(response);
}
catch (Exception ex)
{
response.CssResponses.Results.Add(new CommandResponse("Exception", ex.ToString()));
}
finally
{
if (us != null && us.IsActive)
{
UniObjects.CloseSession(us);
}
}
response.CssResponses.Results.Add(new CommandResponse("Error", "There was an error procesing your request."));
return(response);
}
public CssCallModel(CssCredentials credentials, AccountList accountList, CssAccountFile file)
{
Credentials = credentials;
CssDataFile = accountList;
File = file;
}