public Form1(
IModState modState,
IModListInit modListInit,
ICheckBoxes checkBoxes,
IActionToTake actionToTake,
IInstaller installer,
IUninstall uninstall,
IProgressBarSteps progressBarSteps,
IVersion version,
ICheckExe checkExe,
IConverter converter,
IDataStorage dataStorage,
IDownloader downloader)
{
InitializeComponent();
_modState = modState;
_modListInit = modListInit;
_checkBoxes = checkBoxes;
_actionToTake = actionToTake;
_installer = installer;
_uninstall = uninstall;
_progressBarSteps = progressBarSteps;
_version = version;
_checkExe = checkExe;
_converter = converter;
_dataStorage = dataStorage;
_downloader = downloader;
OnInit();
}
/// <summary>
/// Generates the formula and linkedcell
/// </summary>
/// <param name="excelEngine">excel application engine</param>
private void GenerateFormula(ExcelEngine excelEngine)
{
//gets the address of the 1st sheet
IWorksheet worksheet = excelEngine.Excel.Workbooks[0].Worksheets[0];
ICheckBoxes checkBoxes = worksheet.CheckBoxes;
string formula;
// loop through each checkbox and assing the link
for (int i = 1; i < checkBoxes.Count; i++)
{
// range for linkedcell
IRange range = worksheet["Z" + (i + 1)];
checkBoxes[i].LinkedCell = range;
//formula to check whether the checkbox checked
formula = "IF(" + range.AddressLocal + ",1,0)";
worksheet["AA" + (i + 1)].Formula = formula;
}
}
protected void CorrectCheckboxes(ICheckBoxes model)
{
if (!model.IsApprovedByManagerEnable && model.IsApprovedByManagerHidden)
{
//if (ModelState.ContainsKey("IsApprovedByManager"))
// ModelState.Remove("IsApprovedByManager");
model.IsApprovedByManager = model.IsApprovedByManagerHidden;
}
if (!model.IsApprovedByPersonnelManagerEnable && model.IsApprovedByPersonnelManagerHidden)
{
//if (ModelState.ContainsKey("IsApprovedByPersonnelManager"))
// ModelState.Remove("IsApprovedByPersonnelManager");
model.IsApprovedByPersonnelManager = model.IsApprovedByPersonnelManagerHidden;
}
if (!model.IsApprovedByUserEnable && model.IsApprovedByUserHidden)
{
//if (ModelState.ContainsKey("IsApprovedByUser"))
// ModelState.Remove("IsApprovedByUser");
model.IsApprovedByUser = model.IsApprovedByUserHidden;
}
//if (model.IsApprovedByUserEnable && model.IsApprovedByUserChecked)
//{
// if (ModelState.ContainsKey("IsApprovedByUser"))
// ModelState.Remove("IsApprovedByUser");
// model.IsApprovedByUser = true;
//}
if (!model.IsPostedTo1CEnable && model.IsPostedTo1CHidden)
{
//if (ModelState.ContainsKey("IsPostedTo1C"))
// ModelState.Remove("IsPostedTo1C");
model.IsPostedTo1C = model.IsPostedTo1CHidden;
}
}
