public int ImportSexes()
{
var res = 0;
try
{
var obj = new Sex();
obj = DataManager.Instance.CreateObject <Sex>();
obj.Id = GuidComb.Generate();
obj.Code = "-";
obj.Name = "-";
obj.SourceId = 0;
DataManager.Instance.AddSex(obj);
obj = DataManager.Instance.CreateObject <Sex>();
obj.Id = GuidComb.Generate();
obj.Code = "";
obj.Name = "Мужской";
obj.SourceId = 1;
DataManager.Instance.AddSex(obj);
obj = DataManager.Instance.CreateObject <Sex>();
obj.Id = GuidComb.Generate();
obj.Code = "";
obj.Name = "Женский";
obj.SourceId = 2;
DataManager.Instance.AddSex(obj);
res = 1;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + " || " + ex.InnerException);
res = 0;
}
return(res);
}
public int ImportUsers()
{
var res = 0;
try
{
var sql =
"SELECT [ABSTRACT_RESPONSIBLE_PERSON_ID]" +
",[ABSTRACT_RESPONSIBLE_PERSON_NAME]" +
",[ABSTRACT_RESPONSIBLE_PERSON_EMAIL]" +
",[DATE_ADD],[DATE_UPDATE]" +
",[SUSER],[SOURCE_ID] " +
"FROM [Conference].[dbo].[abstract_responsible_person]";
var cmd = new SqlCommand(sql, conn);
if (conn.State.ToString() == "Closed")
{
conn.Open();
}
cmd.CommandTimeout = 120;
var rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
User obj;
obj = DataManager.Instance.CreateObject <User>();
obj.Id = GuidComb.Generate();
obj.Password = "******";
obj.Email = "---";
obj.Name = "-";
obj.FullName = "---";
obj.SourceId = 0;
obj.Role += "---";
DataManager.Instance.AddUser(obj);
while (rdr.Read())
{
obj = DataManager.Instance.CreateObject <User>();
obj.Id = GuidComb.Generate();
obj.Password = "******";
obj.Email = rdr.GetString(2);
obj.Name = rdr.GetString(1);
obj.FullName = rdr.GetString(1);
obj.SourceId = rdr.GetInt32(0);
obj.Role += "Reviewer";
DataManager.Instance.AddUser(obj);
}
}
rdr.Close();
rdr = null;
res = 1;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + " || " + ex.InnerException);
res = 0;
}
return(res);
}
public int ImportAbstractsWorks()
{
var res = 0;
try
{
var sql = "SELECT " +
"[ABSTRACT_STATE_ID]" + //0
",[ABSTRACT_ID]" + //1
",[ABSTRACT_RESPONSIBLE_PERSON_ID]" + //2
",[ABSTRACT_STATUS_ID]" + //3
",[IS_SEND_STATE_BY_EMAIL] " + //4
",[DATE_ADD]" + //5
"FROM [Conference].[dbo].[EXP_ABSTRACT_WORKS]";
var cmd = new SqlCommand(sql, conn);
if (conn.State.ToString() == "Closed")
{
conn.Open();
}
cmd.CommandTimeout = 120;
var rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
AbstractWork obj;
while (rdr.Read())
{
obj = DataManager.Instance.CreateObject <AbstractWork>();
obj.Id = GuidComb.Generate();
obj.AbstractStatusId = DataManager.Instance.GetAbstractStatusBySourceId(rdr.GetInt32(3)).Id;
obj.AbstractId = DataManager.Instance.GetAbstractBySourceId(rdr.GetInt32(1)).Id;
obj.ReviewerId = DataManager.Instance.GetUserBySourceId(rdr.GetInt32(2)).Id;
obj.IsSentByEmail = DataManager.Instance.GetBoolLogicBySourceId(rdr.GetInt16(4));
obj.DateWork = rdr.GetDateTime(5);
obj.SourceId = rdr.GetInt32(0);
DataManager.Instance.AddAbstractWork(obj);
res++;
// personConferenceCount++;
}
}
rdr.Close();
rdr = null;
// res = 1;
}
catch (Exception ex)
{
LogManager.Write(ex);
}
return(res);
}
public int ImportPersonConferences()
{
var res = 0;
personConferenceCount = 0;
try
{
var sql = "SELECT " +
"[PERSON_CONFERENCE_TYPE_ID]," +
"[PERSON_ID]," +
"[CONFERENCE_TYPE_ID]," +
"[DATE_ADD]," +
"[DATE_UPDATE]," +
"[SUSER]" +
" FROM [Conference].[dbo].[EXP_PERSON_CONFERENCE]";
var cmd = new SqlCommand(sql, conn);
if (conn.State.ToString() == "Closed")
{
conn.Open();
}
cmd.CommandTimeout = 120;
var rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
var obj = DataManager.Instance.CreateObject <PersonConference>();
while (rdr.Read())
{
obj = DataManager.Instance.CreateObject <PersonConference>();
obj.PersonConferenceId = GuidComb.Generate();
obj.PersonId = DataManager.Instance.GetPersonBySourceId(rdr.GetInt32(1)).Id;
obj.ConferenceId = DataManager.Instance.GetConferenceBySourceId(rdr.GetInt32(2)).Id;
obj.SourceId = rdr.GetInt32(0);
DataManager.Instance.AddPersonConference(obj);
res++;
}
}
rdr.Close();
rdr = null;
// res = 1;
}
catch (Exception ex)
{
LogManager.Write(ex);
MessageBox.Show(res.ToString());
}
return(res);
}
public int ImportAbstracts()
{
var res = 0;
Abstract obj;
try
{
var sql = "SELECT " +
"[ABSTRACT_ID]" + //0
",[PERSON_CONFERENCE_TYPE_ID]" + //1
",[OTHER_AUTHORS]" + //2
",[ABSTRACT_NAME]" + //3
",[ABSTRACT_TEXT]" + //4
",[ABSTRACT_TEXT_LINK] " + //5
"FROM [Conference].[dbo].[EXP_ABSTRACTS]";
var cmd = new SqlCommand(sql, conn);
if (conn.State.ToString() == "Closed")
{
conn.Open();
}
cmd.CommandTimeout = 120;
var rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
while (rdr.Read())
{
obj = DataManager.Instance.CreateObject <Abstract>();
obj.Id = GuidComb.Generate();
obj.PersonConferenceId = DataManager.Instance.GetPersonConferenceBySourceID(rdr.GetInt32(1)).PersonConferenceId;
obj.OtherAuthors = rdr.GetString(2);
obj.Name = rdr.GetString(3);
obj.Text = rdr.GetString(4);
obj.Link = rdr.GetString(5);
obj.SourceId = rdr.GetInt32(0);
DataManager.Instance.AddAbstract(obj);
res++;
// personConferenceCount++;
}
}
rdr.Close();
rdr = null;
// res = 1;
}
catch (Exception ex)
{
LogManager.Write(ex);
}
return(res);
}
public int ImportConferenceTypes()
{
var res = 0;
try
{
var sql =
"SELECT [CONFERENCE_TYPE_ID],"
+ "[CONFERENCE_TYPE_DESCRIPTION_ENG]"
+ ",[CONFERENCE_TYPE_DESCRIPTION_RUS]"
+ ",[DATE_ADD]"
+ ",[DATE_UPDATE]"
+ ",[SUSER]"
+ ",[SOURCE_ID]"
+ " FROM [Conference].[dbo].[conference_type]";
var cmd = new SqlCommand(sql, conn);
if (conn.State.ToString() == "Closed")
{
conn.Open();
}
cmd.CommandTimeout = 120;
var rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
Conference obj;
//obj = DataManager.Instance.CreateObject<Conference>();
//obj.Id = GuidComb.Generate();
//obj.Code = "-";
//obj.Name = "-";
//obj.SourceId = 0;
//DataManager.Instance.AddConference(obj);
while (rdr.Read())
{
obj = DataManager.Instance.CreateObject <Conference>();
obj.Id = GuidComb.Generate();
obj.Code = "";
obj.Name = rdr.GetString(2);
obj.SourceId = rdr.GetInt32(0);
DataManager.Instance.AddConference(obj);
res++;
}
}
rdr.Close();
rdr = null;
// res = 1;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + " || " + ex.InnerException);
res = 0;
}
return(res);
}
public int ImportPhones()
{
var res = 0;
Phone obj;
try
{
var sql =
"SELECT " +
"[PHONE_ID]" + //0
",[PERSON_ID]" + //1
",[PHONE_TYPE_ID]" + //2
",[PHONE_CODE]" + //3
",[PHONE_NUMBER] " + //4
"FROM [Conference].[dbo].[EXP_PHONES]";
var cmd = new SqlCommand(sql, conn);
if (conn.State.ToString() == "Closed")
{
conn.Open();
}
cmd.CommandTimeout = 120;
var rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
obj = DataManager.Instance.CreateObject <Phone>();
while (rdr.Read())
{
obj = DataManager.Instance.CreateObject <Phone>();
obj.Id = GuidComb.Generate();
obj.SourceId = rdr.GetInt32(0);
obj.ContactTypeId = DataManager.Instance.GetContactTypeBySourceId(rdr.GetInt32(2)).Id;
obj.Number = "(" + rdr.GetString(3) + ") " + rdr.GetString(4);
obj.PersonId = DataManager.Instance.GetPersonBySourceId(rdr.GetInt32(1)).Id;
DataManager.Instance.AddPhoneToPerson(DataManager.Instance.GetPersonBySourceId(rdr.GetInt32(1)), obj);
res++;
}
}
rdr.Close();
rdr = null;
// res = 1;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + " || " + ex.InnerException);
res = 0;
}
return(res);
}
public int ImportEmails()
{
var res = 0;
try
{
var sql =
"SELECT " +
"[EMAIL_ID]" + //0
",[PERSON_ID]" + //1
",[EMAIL] " + //2
"FROM [Conference].[dbo].[EXP_EMAILS]";
var cmd = new SqlCommand(sql, conn);
if (conn.State.ToString() == "Closed")
{
conn.Open();
}
cmd.CommandTimeout = 120;
var rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
var obj = DataManager.Instance.CreateObject <Email>();
while (rdr.Read())
{
obj = DataManager.Instance.CreateObject <Email>();
obj.Id = GuidComb.Generate();
obj.SourceId = rdr.GetInt32(0);
obj.ContactTypeId = DataManager.Instance.GetContactTypeBySourceId(0).Id;
obj.Name = rdr.GetString(2);
obj.PersonId = DataManager.Instance.GetPersonBySourceId(rdr.GetInt32(1)).Id;
DataManager.Instance.AddEmailToPerson(DataManager.Instance.GetPersonBySourceId(rdr.GetInt32(1)), obj);
res++;
}
}
rdr.Close();
rdr = null;
// res = 1;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + " || " + ex.InnerException);
res = 0;
}
return(res);
}
public int ImportSpecialities()
{
var res = 0;
try
{
var sql =
"SELECT [SPECIALITY_ID],[SPECIALITY_ENG],[SPECIALITY_RUS],[DATE_ADD],[DATE_UPDATE],[SUSER],[SOURCE_ID] FROM [Conference].[dbo].[speciality]";
var cmd = new SqlCommand(sql, conn);
if (conn.State.ToString() == "Closed")
{
conn.Open();
}
cmd.CommandTimeout = 120;
var rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
Speciality obj;
obj = DataManager.Instance.CreateObject <Speciality>();
obj.Id = GuidComb.Generate();
obj.Code = "-";
obj.Name = "-";
obj.SourceId = 0;
DataManager.Instance.AddSpeciality(obj);
while (rdr.Read())
{
obj = DataManager.Instance.CreateObject <Speciality>();
obj.Id = GuidComb.Generate();
obj.Code = "";
obj.Name = rdr.GetString(2);
obj.SourceId = rdr.GetInt32(0);
DataManager.Instance.AddSpeciality(obj);
res++;
}
}
rdr.Close();
rdr = null;
// res++;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + " || " + ex.InnerException);
res = 0;
}
return(res);
}
public int ImportAdresses()
{
var res = 0;
try
{
var sql =
"SELECT " +
"[ADDRESS_ID]," + //0
"[PERSON_ID]," + //1
"[ADDRESS_TYPE_ID]," + //2
"[COUNTRY_ID]," + //3
"[REGION_ID]," + //4
"[CITY_ID]," + //5
"[CITY_NAME]," + //6
"[ZIP]," + //7
"[STREET_HOUSE_FLAT]," + //8
"[COUNTRY_RUS]," + //9
"[REGION_RUS]," + //10
"[CITY_RUS] " + //11
"FROM [Conference].[dbo].[EXP_ADDRESS]";
var cmd = new SqlCommand(sql, conn);
if (conn.State.ToString() == "Closed")
{
conn.Open();
}
cmd.CommandTimeout = 120;
var rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
var obj = DataManager.Instance.CreateObject <Address>();
while (rdr.Read())
{
obj = DataManager.Instance.CreateObject <Address>();
obj.Id = GuidComb.Generate();
obj.SourceId = rdr.GetInt32(0);
obj.ContactTypeId = DataManager.Instance.GetContactTypeBySourceId(rdr.GetInt32(2)).Id;
obj.ZipCode = rdr.GetString(7);
obj.StreetHouseName = rdr.GetString(8);
obj.CountryName = rdr.GetString(9);
obj.RegionName = rdr.GetString(10);
obj.CityName = rdr.GetString(11);
obj.PersonId = DataManager.Instance.GetPersonBySourceId(rdr.GetInt32(1)).Id;
DataManager.Instance.AddAddressToPerson(DataManager.Instance.GetPersonBySourceId(rdr.GetInt32(1)), obj);
res++;
}
}
rdr.Close();
rdr = null;
// res = 1;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + " || " + ex.InnerException);
res = 0;
}
return(res);
}
public int ImportPersons()
{
personsCount = 0;
var res = 0;
//try
//{
var sql =
"SELECT " +
"[PERSON_ID]," + //0
"[LOGIN]," + //1
"[PASSWORD]," + //2
"ISNULL([FIRST_NAME],N'-')," + //3
"ISNULL([SECOND_NAME],N'-')," + //4
"ISNULL(SURNAME,N'-')," + //5
"ISNULL([SEX_CODE],0)," + //6
"ISNULL([WORK_PLACE],N'-')," + //7
"ISNULL([POST],N'-')," + //8
"ISNULL(SPECIALITY_ID,0)," + //9
"ISNULL([SCIENCE_DEGREE_ID],0)," + //10
"ISNULL([SCIENCE_STATUS_ID],0)," + //11
"[IS_IACMAC_MEMBER]," + //12
"[IACMAC_CARD_NUMBER]," + //13
"[DATE_ADD]," + //14
"[DATE_UPDATE]," + //15
"[SUSER]," + //16
"[SOURCE_ID]" + //17
",ISNULL([IACMAC_ID],0)" + //18
",ISNULL([IS_MEMBER],0)" + //19
",ISNULL([IACMAC_NUMBER],0)" + //20
",ISNULL([IACMAC_CODE],N'-')" + //21
",ISNULL([IS_CARD_CREATE],0)" + //22
",ISNULL([IS_CARD_SENT],0)" + //23
",ISNULL([IS_FORM],0)" + //24
",ISNULL([DATE_REGISTRATION], N'01.01.1970')" + //25
" FROM [Conference].[dbo].[EXP_PATIENT_IACMAC]";
var cmd = new SqlCommand(sql, conn);
if (conn.State.ToString() == "Closed")
{
conn.Open();
}
// cmd.CommandTimeout = 120;
var rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
var obj = DataManager.Instance.CreateObject <Person>();
while (rdr.Read())
{
obj = DataManager.Instance.CreateObject <Person>();
obj.Id = GuidComb.Generate();
obj.SourceId = rdr.GetInt32(0);
obj.FirstName = rdr.GetString(3);
obj.SecondName = rdr.GetString(4);
obj.ThirdName = rdr.GetString(5);
obj.Sex = DataManager.Instance.GetSexBySourceId((rdr.GetByte(6)));
obj.WorkPlace = rdr.GetString(7);
obj.Post = rdr.GetString(8);
obj.Speciality = DataManager.Instance.GetSpecialityBySourceId(rdr.GetInt32(9));
obj.ScienceDegree = DataManager.Instance.GetScienceDegreeBySourceID(rdr.GetInt32(10));
obj.ScienceStatus = DataManager.Instance.GetScienceStatusBySourceId(rdr.GetInt32(11));
DataManager.Instance.AddPerson(obj);
if (rdr.GetInt32(18) > 0)
{
var iacmac = DataManager.Instance.CreateObject <Iacmac>();
iacmac = DataManager.Instance.CreateObject <Iacmac>();
iacmac.PersonId = obj.Id;
iacmac.Code = rdr.GetString(21);
iacmac.DateRegistration = rdr.GetDateTime(25);
iacmac.IsCardCreate = DataManager.Instance.GetBoolLogicBySourceId(rdr.GetByte(22));
iacmac.IsCardSent = DataManager.Instance.GetBoolLogicBySourceId(rdr.GetByte(23));
iacmac.IsForm = DataManager.Instance.GetBoolLogicBySourceId((rdr.GetByte(24)));
iacmac.IsMember = DataManager.Instance.GetBoolLogicBySourceId(rdr.GetByte(19));
iacmac.Number = rdr.GetInt32(20);
DataManager.Instance.AddIacmacToPerson(obj, iacmac);
}
personsCount++;
}
}
rdr.Close();
rdr = null;
// res = 1;
//}
//catch (Exception ex)
//{
// MessageBox.Show(ex.Message + " || " + ex.InnerException + "||" + ex.Source + "||" + ex.StackTrace);
// res = 0;
//}
return(personsCount);
}
