//public DataTable GetCafedra() => new BaseCore(ConnectionStringManger.CampusBd,
// "SELECT distinct [ID_Subdivision],[SubdivName] FROM [eEmployees1]").LocalTable;
public void UpdateCampusDatabase(string[] g)
{
var Campus = new BaseCore(ConnectionStringManger.CampusBd, String.Format("SELECT * FROM {0}", g[1]));
var Vkd = new BaseCore(ConnectionStringManger.VkdBd, String.Format("SELECT * FROM {0}", g[0]));
UpdateDatabase(Campus, Vkd);
}
public SearchResult GetBySearchCondition(SearchFilters searchFilters)
{
//var getCampusInfo = new BaseCore(ConnectionStringManger.CampusBd, SQLFileProvider.SelectByConditionFromCampusTable, new SqlParameter[]
// {
// new SqlParameter("@Surname","N'%'" + searchFilters.LastName + "'%'"),
// new SqlParameter("@Name","N'%'" + searchFilters.FirstName + "'%'"),
// new SqlParameter("@DutiesName","N'%'" + searchFilters.Position + "'%'"),
// }).LocalTable;
//var getVKDInfo = new BaseCore(ConnectionStringManger.VkdBd, SQLFileProvider.SelectByConditionFromViewVKD, new SqlParameter[]
//{
// new SqlParameter("@Surname","N'%'" + searchFilters.LastName + "'%'"),
// new SqlParameter("@Name","N'%'" + searchFilters.FirstName + "'%"),
// new SqlParameter("@DutiesName","N'%'" + searchFilters.Position + "'%'"),
//}).LocalTable;
var getCampusInfo = new BaseCore(ConnectionStringManger.CampusBd,
string.Format(SQLFileProvider.SelectByConditionFromCampusTable, searchFilters.LastName, searchFilters.FirstName, searchFilters.Position, searchFilters.TableName)).LocalTable;
var getVKDInfo = new BaseCore(ConnectionStringManger.VkdBd,
string.Format(SQLFileProvider.SelectByConditionFromViewVKD, searchFilters.LastName, searchFilters.FirstName, searchFilters.Position, searchFilters.ViewName)).LocalTable;
var result = new SearchResult
{
CampusResult = getCampusInfo,
ViewResult = getVKDInfo
};
return(result);
}
protected void DeleteCheck(ref DataTable campus, ref DataTable Vkd, BaseCore campusBaseCore)
{
var employeesId = campus.AsEnumerable().Select(o => new
{
EmpId = o["ID_employee"],
SubId = o["ID_Subdivision"]
}).Distinct();
foreach (var ident in employeesId)
{
var empl = Vkd.AsEnumerable().Where(p => p["ID_employee"].ToString() == ident.EmpId.ToString() &&
p["ID_Subdivision"].ToString() == ident.SubId.ToString())
.Select(u => u["Surname"]).ToList();
if (!empl.Any())
{
var employees = campus.Select("ID_employee=" + ident.EmpId.ToString());
foreach (var row in employees)
{
if (row["vcChangeStatus"].ToString() != "Видалено")
{
row["vcChangeStatus"] = "Видалено";
row["vcChangeDate"] = DateTime.Now;
NLogCore.LogStatusAplication("Запис з ідентифікатором eEmployees1Id=" + row["eEmployees1Id"] + " видалено");
}
}
campusBaseCore.UpdateDataBase(campus);
}
}
}
public void PartialyUpdateCampusDatabase(DataToConvert dataToConvert)
{
var Campus = new BaseCore(ConnectionStringManger.CampusBd,
String.Format(SQLFileProvider.SelectRangeFromCampusTable, dataToConvert.TableName, string.Join(",", dataToConvert.CampusRows)));
var Vkd = new BaseCore(ConnectionStringManger.VkdBd,
String.Format(SQLFileProvider.SelectRangeFromViewVKD, dataToConvert.ViewName, string.Join(",", dataToConvert.VkdRows)));
UpdateDatabase(Campus, Vkd);
}
private void UpdateDatabase(BaseCore campus, BaseCore vkd)
{
var t = campus.LocalTable;
var y = vkd.LocalTable;
DataCheck(ref t, ref y);
campus.UpdateDataBase(t);
DeleteCheck(ref t, ref y, campus);
campus.UpdateDataBase(t);
}
public Dictionary <string, DataTable> GetAllTables()
{
var Campus = new BaseCore(ConnectionStringManger.CampusBd,
"SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES where TABLE_TYPE = 'BASE TABLE' order by TABLE_NAME");
var Vkd = new BaseCore(ConnectionStringManger.VkdBd,
"SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES where TABLE_TYPE = 'View' order by TABLE_NAME");
return(new Dictionary <string, DataTable>
{
["Список Представлень:"] = Vkd.LocalTable,
["Список Таблиц:"] = Campus.LocalTable
});
}
public int GetProgressBarCount(string t)
{
var Vkd = new BaseCore(ConnectionStringManger.VkdBd, String.Format("SELECT Count( distinct ID_Employee) as cou FROM {0}", t));
return(Convert.ToInt32(Vkd.LocalTable.AsEnumerable().Select(o => o["cou"]).ElementAt(0)));
}