private void ModifyInvoice()
{
ClientConversation.authenticate(_frmAuth.EllipseUser, _frmAuth.EllipsePswd);
supplierInfo = new SupplierInvoiceInfo();
var currentRow = TittleRow + 1;
var proxySheet = new screen.ScreenService();
var requestSheet = new screen.ScreenSubmitRequestDTO();
proxySheet.Url = _eFunctions.GetServicesUrl(drpEnviroment.SelectedItem.Label) + "/ScreenService";
var opSheet = new screen.OperationContext
{
district = _frmAuth.EllipseDsct,
position = _frmAuth.EllipsePost,
maxInstances = 100,
maxInstancesSpecified = true,
returnWarnings = _eFunctions.DebugWarnings
};
_cells.GetCell(1, currentRow).Select();
while (_cells.GetNullIfTrimmedEmpty(_cells.GetCell(1, currentRow).Value) != null)
{
try
{
_cells.GetCell(1, currentRow).Select();
supplierInfo.Supplier = _cells.GetNullIfTrimmedEmpty(_cells.GetCell(1, currentRow).Value);
supplierInfo.Factura = _cells.GetNullIfTrimmedEmpty(_cells.GetCell(2, currentRow).Value);
supplierInfo.Fechapagosolicitada = _cells.GetNullIfTrimmedEmpty(_cells.GetCell(3, currentRow).Value);
supplierInfo.Fechapagooriginal = _cells.GetNullIfTrimmedEmpty(_cells.GetCell(4, currentRow).Value);
supplierInfo.PmtStatus = _cells.GetNullIfTrimmedEmpty(_cells.GetCell(5, currentRow).Value);
supplierInfo.Proveedor = _cells.GetNullIfTrimmedEmpty(_cells.GetCell(6, currentRow).Value);
supplierInfo.CodigoBancoOriginal = _cells.GetNullIfTrimmedEmpty(_cells.GetCell(7, currentRow).Value);
supplierInfo.St = Convert.ToDouble(_cells.GetNullIfTrimmedEmpty(_cells.GetCell(8, currentRow).Value));
supplierInfo.Vrtotalfactura = Convert.ToDouble(_cells.GetNullIfTrimmedEmpty(_cells.GetCell(9, currentRow).Value));
supplierInfo.VrBasedeDescuento = Convert.ToDouble(_cells.GetNullIfTrimmedEmpty(_cells.GetCell(10, currentRow).Value));
supplierInfo.Diferencia = Convert.ToDouble(_cells.GetNullIfTrimmedEmpty(_cells.GetCell(11, currentRow).Value));
supplierInfo.Descuentocalculado = Convert.ToDouble(_cells.GetNullIfTrimmedEmpty(_cells.GetCell(12, currentRow).Value));
supplierInfo.Vrdescuentoaplicado = Convert.ToDouble(_cells.GetNullIfTrimmedEmpty(_cells.GetCell(13, currentRow).Value));
supplierInfo.Fechadepagomodificada = _cells.GetNullIfTrimmedEmpty(_cells.GetCell(14, currentRow).Value);
supplierInfo.BancodePagoModificado = _cells.GetNullIfTrimmedEmpty(_cells.GetCell(15, currentRow).Value);
_eFunctions.RevertOperation(opSheet, proxySheet);
var replySheet = proxySheet.executeScreen(opSheet, "MSO261");
if (_eFunctions.CheckReplyError(replySheet))
{
_cells.GetCell(ResultColumn, currentRow).Style = StyleConstants.Error;
_cells.GetCell(ResultColumn, currentRow).Value = replySheet.message;
}
else
{
if (replySheet.mapName != "MSM261A") return;
var arrayFields = new ArrayScreenNameValue();
arrayFields.Add("OPTION1I", "1");
arrayFields.Add("DSTRCT_CODE1I", "ICOR");
arrayFields.Add("SUPPLIER_NO1I", supplierInfo.Supplier);
arrayFields.Add("INV_NO1I", supplierInfo.Factura);
requestSheet.screenFields = arrayFields.ToArray();
requestSheet.screenKey = "1";
replySheet = proxySheet.submit(opSheet, requestSheet);
while (_eFunctions.CheckReplyWarning(replySheet) || replySheet.functionKeys.Contains("XMIT-Confirm"))
replySheet = proxySheet.submit(opSheet, requestSheet);
if (_eFunctions.CheckReplyError(replySheet))
{
_cells.GetCell(ResultColumn, currentRow).Style = StyleConstants.Error;
_cells.GetCell(ResultColumn, currentRow).Value = replySheet.message;
}
else if (replySheet.mapName == "MSM261B")
{
arrayFields = new ArrayScreenNameValue();
arrayFields.Add("BRANCH_CODE2I", parameters.Branchcode);
arrayFields.Add("BANK_ACCT_NO2I", parameters.Bankaccount);
arrayFields.Add("SD_AMOUNT2I", supplierInfo.Descuentocalculado.ToString(CultureInfo.InvariantCulture));
arrayFields.Add("SD_DATE2I", supplierInfo.Fechapagosolicitada);
requestSheet.screenFields = arrayFields.ToArray();
requestSheet.screenKey = "1";
replySheet = proxySheet.submit(opSheet, requestSheet);
while (_eFunctions.CheckReplyWarning(replySheet) || replySheet.functionKeys.Contains("XMIT-Confirm"))
replySheet = proxySheet.submit(opSheet, requestSheet);
if (_eFunctions.CheckReplyError(replySheet) & !replySheet.message.Contains("X2:3730 - MODIFICATIONS MADE TO INVOICE"))
{
_cells.GetCell(ResultColumn, currentRow).Style = StyleConstants.Error;
_cells.GetCell(ResultColumn, currentRow).Value = replySheet.message;
}
else
{
_cells.GetCell(ResultColumn, currentRow).Style = StyleConstants.Success;
_cells.GetCell(ResultColumn, currentRow).Value = "Success";
_cells.GetCell(13, currentRow).Value = supplierInfo.Vrdescuentoaplicado = supplierInfo.Descuentocalculado;
_cells.GetCell(14, currentRow).Value = supplierInfo.Fechadepagomodificada = supplierInfo.Fechapagosolicitada;
_cells.GetCell(15, currentRow).Value = supplierInfo.BancodePagoModificado = parameters.Branchcode+ " - " + parameters.Bankaccount ;
}
}
}
}
catch (Exception ex)
{
_cells.GetCell(ResultColumn, currentRow).Style = StyleConstants.Error;
_cells.GetCell(ResultColumn, currentRow).Value = ex.Message;
}
finally
{
currentRow++;
}
}
}
private void DeleteProfile(ref string OPTION1I, ref ArrayScreenNameValue arrayFields,
Screen.OperationContext opSheet, Screen.ScreenService proxySheet, Screen.ScreenSubmitRequestDTO requestSheet,
ref Screen.ScreenDTO replySheet, int currentRow, out string PROFILE, out string PROFILE_TYPE)
{
OPTION1I = "3";
PROFILE_TYPE = "" + _cells.GetCell("B" + currentRow).Value;
PROFILE = "" + _cells.GetCell("C" + currentRow).Value;
_eFunctions.RevertOperation(opSheet, proxySheet);
replySheet = proxySheet.executeScreen(opSheet, "MSO615");
if (replySheet.mapName == "MSM615A" && _excelApp.ActiveWorkbook.ActiveSheet.Name == _sheetName01)
{
arrayFields = new ArrayScreenNameValue();
arrayFields.Add("OPTION1I", OPTION1I);
if (PROFILE_TYPE == "EGI")
{
arrayFields.Add("GROUP_ID11I", PROFILE);
}
else
{
arrayFields.Add("PLANT_NO11I", PROFILE);
}
requestSheet.screenFields = arrayFields.ToArray();
requestSheet.screenKey = "1";
replySheet = proxySheet.submit(opSheet, requestSheet);
if (_eFunctions.CheckReplyWarning(replySheet))
replySheet = proxySheet.submit(opSheet, requestSheet);
if (replySheet != null && replySheet.mapName == "MSM617A" && !_eFunctions.CheckReplyError(replySheet))
{
arrayFields = new ArrayScreenNameValue();
arrayFields.Add("EQUIP_REF1I", PROFILE);
requestSheet.screenFields = arrayFields.ToArray();
requestSheet.screenKey = "9";
replySheet = proxySheet.submit(opSheet, requestSheet);
if (_eFunctions.CheckReplyWarning(replySheet))
replySheet = proxySheet.submit(opSheet, requestSheet);
while (replySheet.mapName == "MSM180B")
{
arrayFields = new ArrayScreenNameValue();
arrayFields.Add("DELETE_CONF2I", "Y");
requestSheet.screenFields = arrayFields.ToArray();
requestSheet.screenKey = "1";
replySheet = proxySheet.submit(opSheet, requestSheet);
}
if (replySheet != null && replySheet.mapName == "MSM615A" && !_eFunctions.CheckReplyError(replySheet))
{
_cells.GetCell("A" + currentRow + ":" + "C" + currentRow).Style =
_cells.GetStyle(StyleConstants.Success);
}
else if (_eFunctions.CheckReplyError(replySheet))
{
_cells.GetCell("A" + currentRow + ":" + "B" + currentRow).Style =
_cells.GetStyle(StyleConstants.Error);
_cells.GetCell("A" + currentRow).AddComment(_cells.GetEmptyIfNull(replySheet.message));
}
else
{
_cells.GetCell("A" + currentRow + ":" + "B" + currentRow).Style =
_cells.GetStyle(StyleConstants.Error);
_cells.GetCell("A" + currentRow).AddComment("NPI");
}
}
}
}
private void MaintainStatisticsProfile(ref string option1I, List<string> statType, List<string> statEntry,
ref ArrayScreenNameValue arrayFields, Screen.OperationContext opSheet, Screen.ScreenService proxySheet,
Screen.ScreenSubmitRequestDTO requestSheet, ref Screen.ScreenDTO replySheet, int currentRow,
out string profile, out string profileType, out string prStatType1I)
{
option1I = option1I.Substring(0, 1);
profileType = "" + _cells.GetCell("B" + currentRow).Value;
profile = "" + _cells.GetCell("C" + currentRow).Value;
prStatType1I = "" + _cells.GetCell("F" + currentRow).Value;
statType = new List<string>();
statEntry = new List<string>();
const int startColumn = 7;
for (var i = 0; i < 20; i++)
{
statType.Add(_cells.GetEmptyIfNull(_cells.GetCell(i*2 + startColumn, currentRow).Value));
statEntry.Add(_cells.GetEmptyIfNull(_cells.GetCell(i*2 + startColumn + 1, currentRow).Value));
}
_eFunctions.RevertOperation(opSheet, proxySheet);
replySheet = proxySheet.executeScreen(opSheet, "MSO615");
if (replySheet.mapName != "MSM615A" || _excelApp.ActiveWorkbook.ActiveSheet.Name != _sheetName01) return;
arrayFields = new ArrayScreenNameValue();
arrayFields.Add("OPTION1I", option1I);
arrayFields.Add(profileType == "EGI" ? "GROUP_ID11I" : "PLANT_NO11I", profile);
requestSheet.screenFields = arrayFields.ToArray();
requestSheet.screenKey = "1";
replySheet = proxySheet.submit(opSheet, requestSheet);
if (_eFunctions.CheckReplyWarning(replySheet))
replySheet = proxySheet.submit(opSheet, requestSheet);
if (replySheet != null && replySheet.mapName == "MSM617A")
{
arrayFields = new ArrayScreenNameValue();
arrayFields.Add("EQUIP_REF1I", profile);
arrayFields.Add("PR_STAT_TYPE1I", prStatType1I);
double index = 0;
double firstIndex;
double secondIndex;
foreach (var item in statType)
{
firstIndex = (index%2) + 1;
secondIndex = Math.Ceiling((index + 1)/2);
arrayFields.Add("STAT_TYPE" + firstIndex + "1I" + secondIndex, item);
index++;
}
index = 0;
foreach (var item in statEntry)
{
firstIndex = (index%2) + 1;
secondIndex = Math.Ceiling((index + 1)/2);
arrayFields.Add("STAT_ENTRY" + firstIndex + "1I" + secondIndex, item);
index++;
}
requestSheet.screenFields = arrayFields.ToArray();
requestSheet.screenKey = "1";
replySheet = proxySheet.submit(opSheet, requestSheet);
while (replySheet != null && replySheet.mapName == "MSM617A" &&
(replySheet.functionKeys.Contains("XMIT-Confirm") ||
replySheet.functionKeys.Contains("XMIT-Validate") ||
_eFunctions.CheckReplyWarning(replySheet)))
{
replySheet = proxySheet.submit(opSheet, requestSheet);
}
if (replySheet != null && replySheet.mapName == "MSM615A")
{
_cells.GetCell("A" + currentRow + ":" + "C" + currentRow).Style =
_cells.GetStyle(StyleConstants.Success);
}
else if (_eFunctions.CheckReplyError(replySheet))
{
_cells.GetCell("A" + currentRow + ":" + "B" + currentRow).Style =
_cells.GetStyle(StyleConstants.Error);
_cells.GetCell("A" + currentRow).AddComment(_cells.GetEmptyIfNull(replySheet.message));
}
else
{
_cells.GetCell("A" + currentRow + ":" + "B" + currentRow).Style =
_cells.GetStyle(StyleConstants.Error);
_cells.GetCell("A" + currentRow).AddComment("NPI");
}
}
else if (_eFunctions.CheckReplyError(replySheet))
{
_cells.GetCell("A" + currentRow + ":" + "B" + currentRow).Style = _cells.GetStyle(StyleConstants.Error);
_cells.GetCell("A" + currentRow).AddComment(_cells.GetEmptyIfNull(replySheet.message));
}
else
{
_cells.GetCell("A" + currentRow + ":" + "B" + currentRow).Style = _cells.GetStyle(StyleConstants.Error);
_cells.GetCell("A" + currentRow).AddComment("NPI");
}
}
private void ManintainGeneralProfile(ref string option1I, ref ArrayScreenNameValue arrayFields,
Screen.OperationContext opSheet, Screen.ScreenService proxySheet, Screen.ScreenSubmitRequestDTO requestSheet,
ref Screen.ScreenDTO replySheet, int currentRow, out string profile, out string profileType,
out string fuelOilType2I, out string fuelCapacity2I)
{
option1I = option1I.Substring(0, 1);
profileType = "" + _cells.GetCell("B" + currentRow).Value;
profile = "" + _cells.GetCell("C" + currentRow).Value;
fuelOilType2I = "" + _cells.GetCell("D" + currentRow).Value;
fuelCapacity2I = "" + _cells.GetCell("E" + currentRow).Value;
_eFunctions.RevertOperation(opSheet, proxySheet);
replySheet = proxySheet.executeScreen(opSheet, "MSO615");
if (replySheet.mapName == "MSM615A" && _excelApp.ActiveWorkbook.ActiveSheet.Name == _sheetName01)
{
arrayFields = new ArrayScreenNameValue();
arrayFields.Add("OPTION1I", option1I);
if (profileType == "EGI")
{
arrayFields.Add("GROUP_ID11I", profile);
}
else
{
arrayFields.Add("PLANT_NO11I", profile);
}
requestSheet.screenFields = arrayFields.ToArray();
requestSheet.screenKey = "1";
replySheet = proxySheet.submit(opSheet, requestSheet);
if (_eFunctions.CheckReplyWarning(replySheet))
replySheet = proxySheet.submit(opSheet, requestSheet);
if (replySheet != null && replySheet.mapName == "MSM617B" && !_eFunctions.CheckReplyError(replySheet))
{
arrayFields = new ArrayScreenNameValue();
arrayFields.Add("PLANT_NO2I", profile);
arrayFields.Add("FUEL_OIL_TYPE2I", fuelOilType2I);
arrayFields.Add("FUEL_CAPACITY2I", fuelCapacity2I);
arrayFields.Add("VAL_PROF_FLG2I", "N");
requestSheet.screenFields = arrayFields.ToArray();
requestSheet.screenKey = "1";
replySheet = proxySheet.submit(opSheet, requestSheet);
if (replySheet != null && replySheet.mapName == "MSM617B" &&
(replySheet.functionKeys.Contains("XMIT-Confirm") || _eFunctions.CheckReplyWarning(replySheet)))
{
replySheet = proxySheet.submit(opSheet, requestSheet);
if (replySheet != null && replySheet.mapName == "MSM615A" &&
!_eFunctions.CheckReplyWarning(replySheet) && !_eFunctions.CheckReplyError(replySheet))
{
_cells.GetCell("A" + currentRow + ":" + "C" + currentRow).Style =
_cells.GetStyle(StyleConstants.Success);
}
}
else if (_eFunctions.CheckReplyError(replySheet))
{
_cells.GetCell("A" + currentRow + ":" + "B" + currentRow).Style =
_cells.GetStyle(StyleConstants.Error);
_cells.GetCell("A" + currentRow).AddComment(_cells.GetEmptyIfNull(replySheet.message));
}
else
{
_cells.GetCell("A" + currentRow + ":" + "C" + currentRow).Style =
_cells.GetStyle(StyleConstants.Success);
}
}
else if (_eFunctions.CheckReplyError(replySheet))
{
_cells.GetCell("A" + currentRow + ":" + "B" + currentRow).Style = _cells.GetStyle(StyleConstants.Error);
_cells.GetCell("A" + currentRow).AddComment(_cells.GetEmptyIfNull(replySheet.message));
}
else
{
_cells.GetCell("A" + currentRow + ":" + "B" + currentRow).Style = _cells.GetStyle(StyleConstants.Error);
_cells.GetCell("A" + currentRow).AddComment("NPI");
}
}
}
private void ExecuteProfile()
{
var statType = new List<string>();
var statEntry = new List<string>();
var arrayFields = new ArrayScreenNameValue();
_frmAuth.StartPosition = FormStartPosition.CenterScreen;
_frmAuth.selectedEnviroment = drpEnviroment.SelectedItem.Label;
if (_frmAuth.ShowDialog() != DialogResult.OK) return;
var opSheet = new Screen.OperationContext
{
district = _frmAuth.EllipseDsct,
position = _frmAuth.EllipsePost,
maxInstances = 100,
maxInstancesSpecified = true,
returnWarnings = _eFunctions.DebugWarnings
};
ClientConversation.authenticate(_frmAuth.EllipseUser, _frmAuth.EllipsePswd);
var proxySheet = new Screen.ScreenService();
var requestSheet = new Screen.ScreenSubmitRequestDTO();
var replySheet = new Screen.ScreenDTO();
proxySheet.Url = _eFunctions.GetServicesUrl(drpEnviroment.SelectedItem.Label) + "/ScreenService";
var currentRow = 5;
string option1I = _cells.GetEmptyIfNull(_cells.GetCell("A" + currentRow).Value);
try
{
while (!string.IsNullOrEmpty(option1I))
{
string profile;
string profileType;
switch (option1I)
{
case "3. Maintain Operating Statistics Profile":
string prStatType1I;
MaintainStatisticsProfile(ref option1I, statType, statEntry, ref arrayFields, opSheet,
proxySheet, requestSheet, ref replySheet, currentRow, out profile, out profileType,
out prStatType1I);
break;
case "4. Maintain General Equipment Profile":
string fuelOilType2I;
string fuelCapacity2I;
ManintainGeneralProfile(ref option1I, ref arrayFields, opSheet, proxySheet, requestSheet,
ref replySheet, currentRow, out profile, out profileType, out fuelOilType2I,
out fuelCapacity2I);
break;
case "Delete Profile":
DeleteProfile(ref option1I, ref arrayFields, opSheet, proxySheet, requestSheet,
ref replySheet, currentRow, out profile, out profileType);
break;
}
currentRow += 1;
option1I = "" + _cells.GetCell("A" + currentRow).Value;
}
}
catch (Exception error)
{
_cells.GetCell("A" + currentRow + ":" + "B" + currentRow).Style = _cells.GetStyle(StyleConstants.Error);
_cells.GetCell("A" + currentRow).AddComment("" + error.Message);
}
}
