static void Main(string[] args)
{
//Log Instance
Logger Log = new Logger();
Log.WriteEntry("Iniciando o SQL BUILDER", EventLogEntryType.Information);
//DataSet Instance
PersonsTableAdapter dsPersons = new PersonsTableAdapter();
#region DataBase Test
//Getting DataTable
PersonsDataTable dt = null;
dsPersons.Fill(dt);
//Generate the insert command from an excel file.
SqlBuilder.BuildInsertCommand(dt);
FileManager.WriteText(SqlBuilder.GeneratedSQL.ToString(), AppSettings.SCRIPT_PATH);
#endregion
#region Excel Test
DataTable dataTable = null;
//Reading Excel and Generate a DataTable
dataTable = ExcelReader.ReadRows();
//Setting a name to the Data Table.
dt.TableName = "dbo.Persons";
#endregion
Console.WriteLine("Scripts e Log gerados com sucesso. Aperte uma tecla para finalizar.");
Console.ReadLine();
}
private void importAccessData_Click(object sender, EventArgs e)
{
// Person
var PersonList = new List <Person>();
var personsData = new PersonsTableAdapter().GetData().Rows;
foreach (var person in personsData)
{
var row = (PersonsRow)person;
PersonList.Add(new Person {
Person_ID = row.Person_ID,
Person_FIO = row.Person_FIO
});
}
// Dolgnost
var DolgnostList = new List <Dolgnost>();
var dolgnostData = new DolgnostTableAdapter().GetData().Rows;
foreach (var dolgnost in dolgnostData)
{
var row = (DolgnostRow)dolgnost;
DolgnostList.Add(new Dolgnost
{
Dolg_Person_ID = row.Dolg_Person_ID,
DolgnostName = row.Dolgnost,
Uslovie_ID = row.Uslovie,
Prikaz = row.Prikaz,
Pokonkursu = row.Pokonkursu.ToString(),
Konkurs = row.Konkurs,
KafID = row.KafID
});
}
// DolgnostUsl
var DolgUslList = new List <DolgUsl>();
var duData = new DolgUslTableAdapter().GetData().Rows;
foreach (var du in duData)
{
var row = (DolgUslRow)du;
DolgUslList.Add(new DolgUsl
{
DolgUsl_ID = row.DolgUslovija_ID,
DolgUsl_Desc = row.DolgUslovija_Desc,
DolgUsl_Desc2 = row.DolgUslovija_Desc2
});
}
// Education
var EducationList = new List <AccessPps.AccessClasses.Education>();
var edData = new EducationTableAdapter().GetData().Rows;
foreach (var ed in edData)
{
var row = (EducationRow)ed;
EducationList.Add(new AccessPps.AccessClasses.Education
{
Edu_Person_ID = row.Edu_Person_ID,
Edu_Counter = row.Edu_Counter,
Edu_Level = row.Edu_Level,
Edu_Year = row.Edu_Year,
Edu_Kval = row.Edu_Kval,
Edu_Spec = row.Edu_Spec
});
}
// EduLevel
var EduLevelList = new List <AccessPps.AccessClasses.EduLevel>();
var elData = new EduLevelsTableAdapter().GetData().Rows;
foreach (var el in elData)
{
var row = (EduLevelsRow)el;
EduLevelList.Add(new EduLevel
{
Edu_Level_ID = row.Edu_Level_ID,
Edu_Level_Desc = row.Edu_Level_Disc
});
}
// Stage
var StageList = new List <Stage>();
var stData = new StageTableAdapter().GetData().Rows;
foreach (var st in stData)
{
var row = (StageRow)st;
StageList.Add(new Stage
{
Stage_Person_ID = row.Stage_Person_ID,
Stage_Typ_ID = row.Stage_Typ,
Stage_Years = row.Stage_Years,
Stage_Months = row.Stage_Months
});
}
// StageTyp
var StageTypList = new List <StageTyp>();
var sttData = new StageTypsTableAdapter().GetData().Rows;
foreach (var stt in sttData)
{
var row = (StageTypsRow)stt;
StageTypList.Add(new StageTyp
{
StageTyp_ID = row.StageTyp_ID,
StageTyp_Desc = row.StageTyp_Desc
});
}
// Zvanije
var ZvanijeList = new List <Zvanije>();
var zData = new ZvanijaTableAdapter().GetData().Rows;
foreach (var z in zData)
{
var row = (ZvanijaRow)z;
ZvanijeList.Add(new Zvanije
{
Zvanije_Person_ID = row.Zvan_Person_ID,
Zvanije_Counter = row.ZvanCounter,
Zvanije_Typ_ID = row.Zvan_ZvanID
});
}
// ZvanTyp
var ZvanijeTypList = new List <ZvanijeTyp>();
var ztData = new ZvanTypsTableAdapter().GetData().Rows;
foreach (var zt in ztData)
{
var row = (ZvanTypsRow)zt;
ZvanijeTypList.Add(new ZvanijeTyp
{
ZvanijeTyp_ID = row.ZvanTyp_ID,
ZvanijeTyp_Desc = row.ZvanTyp_Desc
});
}
// Stepeni
var StepenList = new List <Stepen>();
var sData = new StepeniTableAdapter().GetData().Rows;
foreach (var s in sData)
{
var row = (StepeniRow)s;
StepenList.Add(new Stepen
{
Step_Person_ID = row.Step_Person_ID,
Step_Counter = row.Step_Counter,
Step_TypID = row.Step_TypID,
Step_Nayk = row.Step_Nauk
});
}
// StepTyps
var StepTypList = new List <StepTyp>();
var stypsData = new StepTypsTableAdapter().GetData().Rows;
foreach (var styp in stypsData)
{
var row = (StepTypsRow)styp;
StepTypList.Add(new StepTyp
{
StepTyp_ID = row.StepTyp_ID,
StepTyp_Desc = row.StepTyp_Desc
});
}
// StepNauki
var StepNaukiList = new List <StepNauki>();
var snData = new StepNaukiTableAdapter().GetData().Rows;
foreach (var sn in snData)
{
var row = (StepNaukiRow)sn;
StepNaukiList.Add(new StepNauki
{
StepNayki_ID = row.StepNauki_ID,
StepNayki_Full = row.StepNauki_Full,
StepNayki_Short = row.StepNauki_Short
});
}
// Kaf
var KafList = new List <Kaf>();
var kData = new KafTableAdapter().GetData().Rows;
foreach (var k in kData)
{
var row = (KafRow)k;
KafList.Add(new Kaf
{
Kaf_ID = row.Kaf_ID,
Kaf_Im = row.Kaf_Im,
Kaf_Rd = row.Kaf_Rd,
Kaf_Src = row.Kaf_Src
});
}
var teachers = tRepo.all()
.OrderBy(t => t.f)
.ThenBy(t => t.i)
.ThenBy(t => t.o)
.ThenBy(t => t.birth_date)
.ToList();
var personTeacherIdDict = new Dictionary <int, int>();
for (int i = 0; i < teachers.Count; i++)
{
var teacher = teachers[i];
var p = PersonList.FirstOrDefault(per => per.Person_FIO == teacher.f + " " + teacher.i + " " + teacher.o);
if (p != null)
{
personTeacherIdDict.Add(p.Person_ID, teacher.id);
// Dolgnost
var dolList = DolgnostList
.Where(d => d.Dolg_Person_ID == p.Person_ID)
.ToList();
var positions = Position.FromAccessList(dolList, DolgUslList, KafList, teacher.id);
foreach (var pos in positions)
{
pRepo.add(pos);
}
// Education
var eduList = EducationList
.Where(ed => ed.Edu_Person_ID == p.Person_ID)
.ToList();
var educations = DomainClasses.Main.Education.FromAccessList(eduList, EduLevelList, teacher.id);
foreach (var education in educations)
{
eduRepo.add(education);
}
// Stage
var stList = StageList
.Where(st => st.Stage_Person_ID == p.Person_ID)
.ToList();
var experiences = Experience.FromAccessList(stList, StageTypList, teacher.id);
foreach (var experience in experiences)
{
expRepo.add(experience);
}
// Zavinija
var ZvanList = ZvanijeList
.Where(zv => zv.Zvanije_Person_ID == p.Person_ID)
.ToList();
var academicRanks = AcademicRank.FromAccessList(ZvanList, ZvanijeTypList, teacher.id);
foreach (var academicRank in academicRanks)
{
arRepo.add(academicRank);
}
//Steneni
var StepList = StepenList
.Where(st => st.Step_Person_ID == p.Person_ID)
.ToList();
var academicDegrees = AcademicDegree.FromAccessList(StepList, StepTypList, StepNaukiList, teacher.id);
foreach (var academicDegree in academicDegrees)
{
adRepo.add(academicDegree);
}
}
}
}