public override ValidationResult Validate(object value, CultureInfo cultureInfo)
{
//ExcelManager _manager = new ExcelManager();
//List<ExcelB> listB = _manager.LoadCollectionExcelB();
ExcelC entry = (value as BindingGroup).Items[0] as ExcelC;
if (string.IsNullOrEmpty(entry.Val1))
{
return(new ValidationResult(false, "Value 1 must not be empty!"));
}
//bool contains = false;
//foreach (var item in listB)
//{
// if (item.Val3Main.Equals(entry.Val3))
// contains = true;
//}
//if (contains)
// return ValidationResult.ValidResult;
//else
// return new ValidationResult(false, "Value 3 must exist in ExcelB!");
return(ValidationResult.ValidResult);
}
private string ShowEditEntryDialogFuncExcelC(ExcelC entryToEdit)
{
var dialog = new EditValueExcelCWindow(EditEntryFromDialogExcelC, entryToEdit);
dialog.ShowDialog();
return ""; //just pseudo
}
public EditValueExcelCWindow(Action <ExcelC> editingAction, ExcelC entryToEdit)
{
InitializeComponent();
vm = (EditValueExcelCWindowViewModel)this.DataContext;
vm.EditExcelCValue = entryToEdit;
vm.CloseDialogFunc = new Func <int, string>(ShowEditEntryDialogFuncExcelC);
callbackFromParentWindow = editingAction;
}
public void EditEntryExcelCFromCodeBehind(ExcelC entry)
{
if (entry != null)
{
List <ExcelC> tempList = MyCollectionC.ToList();
foreach (ExcelC item in tempList)
{
if (item.Val1.Equals(entry.Val1))
{
item.Val2 = entry.Val2;
item.Val3 = entry.Val3;
item.Val4 = entry.Val4;
MyCollectionC = new ObservableCollection <ExcelC>(tempList);
break;
}
}
}
}
public List <ExcelC> LoadCollectionExcelC(String month)
{
try
{
slDocExcelC = new SLDocument("ExcelC.xlsx");
}
catch (System.IO.FileNotFoundException e)
{
slDocExcelC = new SLDocument();
slDocExcelC.SaveAs("ExcelC.xlsx");
slDocExcelC = new SLDocument("ExcelC.xlsx");
}
catch (System.IO.IOException f)
{
throw f;
}
_InitWorkSheets(slDocExcelC);
slDocExcelC.SelectWorksheet(month);
List <ExcelC> tempList = new List <ExcelC>();
for (int i = 2; i < 80; i++)
{
ExcelC temp = new ExcelC();
temp.Val1 = slDocExcelC.GetCellValueAsString("B" + i.ToString());
temp.Val2 = slDocExcelC.GetCellValueAsString("C" + i.ToString());
temp.Val3 = slDocExcelC.GetCellValueAsString("D" + i.ToString());
temp.Val4 = slDocExcelC.GetCellValueAsString("E" + i.ToString());
if (string.IsNullOrEmpty(temp.Val1)) // Check for ID is not empty
{
break;
}
else
{
tempList.Add(temp);
}
}
return(tempList);
}
private void InitValuesAndCollections()
{
EditExcelCValue = new ExcelC();
}
public void AddEntryExcelCFromCodeBehind(ExcelC entry)
{
MyCollectionC.Add(entry);
}
private void EditEntryFromDialogExcelC(ExcelC entry)
{
vm.EditEntryExcelCFromCodeBehind(entry);
}
private void AddEntryFromDialogExcelC(ExcelC entry)
{
vm.AddEntryExcelCFromCodeBehind(entry);
}