private void UpdateDB2()
{
if (GridsSettings.Any(c => c.GridId == GridsIds.EarningsGridId))
{
return;
}
var flag = 0;
foreach (var propertyInfo in typeof(Budget).GetProperties().Where(c => Attribute.IsDefined(c, typeof(CoulmnId))))
{
var attribute = (CoulmnId)propertyInfo.GetCustomAttributes(typeof(CoulmnId), false).First();
GridsSettings.Add(new GridsSettings
{
GridId = GridsIds.EarningsGridId,
ColumnHeader = attribute.Text,
ColumnName = propertyInfo.Name,
IsVisible = false,
OrderNr = flag,
Width = 100
});
GridsSettings.Add(new GridsSettings
{
GridId = GridsIds.ExpensesGridId,
ColumnHeader = attribute.Text,
ColumnName = propertyInfo.Name,
IsVisible = false,
OrderNr = flag,
Width = 100
});
flag++;
}
SubmitChanges();
}
public void SwapColumnsOrder(int gridId, string colName1, string colName2)
{
var col1 = GridsSettings.FirstOrDefault(c => c.GridId == gridId && c.ColumnName == colName1);
var col2 = GridsSettings.FirstOrDefault(c => c.GridId == gridId && c.ColumnName == colName2);
if (col1 == null || col2 == null)
{
return;
}
col1.OrderNr++;
if (col2.OrderNr >= 0)
{
col2.OrderNr--;
}
SubmitChanges();
}
private void UpdateDB4()
{
if (GridsSettings.Any(c => c.GridId == GridsIds.PaymentsGridId && c.ColumnName == "PaymentType"))
{
return;
}
var flag = GridsSettings.Where(c => c.GridId == GridsIds.PaymentsGridId).Max(c => c.OrderNr) + 1;
GridsSettings.Add(new GridsSettings
{
GridId = GridsIds.PaymentsGridId,
ColumnHeader = "Оплата за",
ColumnName = "PaymentType",
IsVisible = false,
OrderNr = flag,
Width = 100
});
Payments.ForEach(c => c.PaymentType = 'A');
SubmitChanges();
}
private void UpdateDB1()
{
if (GridsSettings.Any(c => c.GridId == 1))
{
return;
}
GridsSettings.Clear();
var flag = 0;
foreach (var propertyInfo in typeof(Persons).GetProperties().Where(c => Attribute.IsDefined(c, typeof(CoulmnId))))
{
var attribute = (CoulmnId)propertyInfo.GetCustomAttributes(typeof(CoulmnId), false).First();
GridsSettings.Add(new GridsSettings
{
GridId = GridsIds.StrudentsGridId,
ColumnHeader = attribute.Text,
ColumnName = propertyInfo.Name,
IsVisible = false,
OrderNr = flag,
Width = 100
});
GridsSettings.Add(new GridsSettings
{
GridId = GridsIds.TeachersGridId,
ColumnHeader = attribute.Text,
ColumnName = propertyInfo.Name,
IsVisible = false,
OrderNr = flag,
Width = 100
});
GridsSettings.Add(new GridsSettings
{
GridId = GridsIds.ContactsGridId,
ColumnHeader = attribute.Text,
ColumnName = propertyInfo.Name,
IsVisible = false,
OrderNr = flag,
Width = 100
});
flag++;
}
GridsSettings.Add(new GridsSettings
{
GridId = GridsIds.StrudentsGridId,
ColumnHeader = "Группа",
ColumnName = "GroupId",
IsVisible = false,
OrderNr = flag + 1,
Width = 100
});
GridsSettings.Add(new GridsSettings
{
GridId = GridsIds.StrudentsGridId,
ColumnHeader = "Обучается с",
ColumnName = "SecondaryDateString",
IsVisible = false,
OrderNr = flag + 2,
Width = 100
});
GridsSettings.Add(new GridsSettings
{
GridId = GridsIds.TeachersGridId,
ColumnHeader = "Работает с",
ColumnName = "SecondaryDateString",
IsVisible = false,
OrderNr = flag + 1,
Width = 100
});
flag = 0;
foreach (var propertyInfo in typeof(Payments).GetProperties().Where(c => Attribute.IsDefined(c, typeof(CoulmnId))))
{
var attribute = (CoulmnId)propertyInfo.GetCustomAttributes(typeof(CoulmnId), false).First();
GridsSettings.Add(new GridsSettings
{
GridId = GridsIds.PaymentsGridId,
ColumnHeader = attribute.Text,
ColumnName = propertyInfo.Name,
IsVisible = false,
OrderNr = flag,
Width = 100
});
flag++;
}
GridsSettings.Add(new GridsSettings
{
GridId = GridsIds.PaymentsGridId,
ColumnHeader = "Студент",
ColumnName = "CustomerName",
IsVisible = false,
OrderNr = flag + 1,
Width = 100
});
flag = 0;
foreach (var propertyInfo in typeof(Groups).GetProperties().Where(c => Attribute.IsDefined(c, typeof(CoulmnId))))
{
var attribute = (CoulmnId)propertyInfo.GetCustomAttributes(typeof(CoulmnId), false).First();
GridsSettings.Add(new GridsSettings
{
GridId = GridsIds.GroupsGridId,
ColumnHeader = attribute.Text,
ColumnName = propertyInfo.Name,
IsVisible = false,
OrderNr = flag,
Width = 100
});
GridsSettings.Add(new GridsSettings
{
GridId = GridsIds.PrivateGridId,
ColumnHeader = attribute.Text,
ColumnName = propertyInfo.Name,
IsVisible = false,
OrderNr = flag,
Width = 100
});
flag++;
}
GridsSettings.Add(new GridsSettings
{
GridId = GridsIds.GroupsGridId,
ColumnName = "LessonsDays",
ColumnHeader = "Дни занятий",
IsVisible = false,
OrderNr = flag + 1,
Width = 100
});
GridsSettings.Add(new GridsSettings
{
GridId = GridsIds.PrivateGridId,
ColumnName = "LessonsDays",
ColumnHeader = "Дни занятий",
IsVisible = false,
OrderNr = flag + 1,
Width = 100
});
flag = 0;
foreach (var propertyInfo in typeof(Events).GetProperties().Where(c => Attribute.IsDefined(c, typeof(CoulmnId))))
{
var attribute = (CoulmnId)propertyInfo.GetCustomAttributes(typeof(CoulmnId), false).First();
GridsSettings.Add(new GridsSettings
{
GridId = GridsIds.EventsGridId,
ColumnHeader = attribute.Text,
ColumnName = propertyInfo.Name,
IsVisible = false,
OrderNr = flag,
Width = 100
});
GridsSettings.Add(new GridsSettings
{
GridId = GridsIds.MasterGridId,
ColumnHeader = attribute.Text,
ColumnName = propertyInfo.Name,
IsVisible = false,
OrderNr = flag,
Width = 100
});
flag++;
}
SubmitChanges();
}
private void UpdateDB3()
{
if (GridsSettings.Any(c => c.GridId == GridsIds.PaymentsReportGridId))
{
return;
}
var flag = 0;
GridsSettings.Add(new GridsSettings
{
GridId = GridsIds.PaymentsReportGridId,
ColumnHeader = "Дата",
ColumnName = "PaymentDate",
IsVisible = false,
OrderNr = flag,
Width = 100
});
flag++;
GridsSettings.Add(new GridsSettings
{
GridId = GridsIds.PaymentsReportGridId,
ColumnHeader = "Платежи",
ColumnName = "Costs",
IsVisible = false,
OrderNr = flag,
Width = 100
});
flag++;
GridsSettings.Add(new GridsSettings
{
GridId = GridsIds.PaymentsReportGridId,
ColumnHeader = "Источник платежей",
ColumnName = "CostsComments",
IsVisible = false,
OrderNr = flag,
Width = 100
});
flag++;
GridsSettings.Add(new GridsSettings
{
GridId = GridsIds.PaymentsReportGridId,
ColumnHeader = "Доходы",
ColumnName = "Earnings",
IsVisible = false,
OrderNr = flag,
Width = 100
});
flag++;
GridsSettings.Add(new GridsSettings
{
GridId = GridsIds.PaymentsReportGridId,
ColumnHeader = "Истоник доходов",
ColumnName = "EarningsComments",
IsVisible = false,
OrderNr = flag,
Width = 100
});
flag++;
GridsSettings.Add(new GridsSettings
{
GridId = GridsIds.PaymentsReportGridId,
ColumnHeader = "Расходы",
ColumnName = "Expenses",
IsVisible = false,
OrderNr = flag,
Width = 100
});
flag++;
GridsSettings.Add(new GridsSettings
{
GridId = GridsIds.PaymentsReportGridId,
ColumnHeader = "Цель расходов",
ColumnName = "ExpensesComments",
IsVisible = false,
OrderNr = flag,
Width = 100
});
flag++;
GridsSettings.Add(new GridsSettings
{
GridId = GridsIds.PaymentsReportGridId,
ColumnHeader = "Сумма за день",
ColumnName = "TotalPerDate",
IsVisible = false,
OrderNr = flag,
Width = 100
});
SubmitChanges();
}
