private static void LoadSprava()
{
var service = new OrganizationService(connection);
var context = new CrmOrganizationServiceContext(connection);
var dataFromXmlx = new Program().ExcelOpenSpreadsheets(@"C:\Users\savchinvv\Desktop\Дела_юр.xlsx");
for (int i = 37; i < dataFromXmlx.Tables[0].Rows.Count; i++)
{
var newSprava = new new_spravastr()
{
new_businessnumber = dataFromXmlx.Tables[0].Rows[i][0].ToString(),
new_nameid = FindClient(dataFromXmlx.Tables[0].Rows[i][1].ToString()),
new_partnercustomer = FindAccount(dataFromXmlx.Tables[0].Rows[i][2].ToString()),
new_typeofbusiness = EntityForm(dataFromXmlx.Tables[0].Rows[i][3].ToString()),
new_type_of_business = CheckType(dataFromXmlx.Tables[0].Rows[i][4].ToString()),
new_priority = ToInt32(dataFromXmlx.Tables[0].Rows[i][5].ToString()),
new_state = FindState(dataFromXmlx.Tables[0].Rows[i][6].ToString()),
new_creationdate = FindDate(dataFromXmlx.Tables[0].Rows[i][7].ToString()),
new_liquidated = FindBit(dataFromXmlx.Tables[0].Rows[i][8].ToString()),
new_gai = FindGos(dataFromXmlx.Tables[0].Rows[i][9].ToString()),
new_datedtp = FindDate(dataFromXmlx.Tables[0].Rows[i][10].ToString()),
new_Dateagreement = FindDate(dataFromXmlx.Tables[0].Rows[i][11].ToString()),
new_date_of_birth = FindDate(dataFromXmlx.Tables[0].Rows[i][12].ToString()),
new_date_death = FindDate(dataFromXmlx.Tables[0].Rows[i][13].ToString()),
new_pledge = dataFromXmlx.Tables[0].Rows[i][14].ToString(),
new_property1 = dataFromXmlx.Tables[0].Rows[i][15].ToString(),
new_property2 = dataFromXmlx.Tables[0].Rows[i][16].ToString(),
new_taxnumber = dataFromXmlx.Tables[0].Rows[i][17].ToString(),
new_code = dataFromXmlx.Tables[0].Rows[i][18].ToString(),
new_placedtp = dataFromXmlx.Tables[0].Rows[i][19].ToString(),
new_locality = dataFromXmlx.Tables[0].Rows[i][20].ToString(),
new_home = dataFromXmlx.Tables[0].Rows[i][21].ToString(),
new_Place_of_work_1 = dataFromXmlx.Tables[0].Rows[i][22].ToString(),
new_Place_of_work_2 = dataFromXmlx.Tables[0].Rows[i][23].ToString(),
new_Companyname = dataFromXmlx.Tables[0].Rows[i][24].ToString(),
new_insurancecompany = dataFromXmlx.Tables[0].Rows[i][25].ToString(),
new_taxaddress = dataFromXmlx.Tables[0].Rows[i][26].ToString(),
new_heir1 = FindClient(dataFromXmlx.Tables[0].Rows[i][27].ToString()),
new_heir2 = FindClient(dataFromXmlx.Tables[0].Rows[i][28].ToString()),
new_heir3 = FindClient(dataFromXmlx.Tables[0].Rows[i][29].ToString()),
new_Credit_agreement = dataFromXmlx.Tables[0].Rows[i][30].ToString(),
new_Social_security_number = dataFromXmlx.Tables[0].Rows[i][31].ToString(),
new_litigationnumber = dataFromXmlx.Tables[0].Rows[i][32].ToString(),
new_guarantor1 = FindClient(dataFromXmlx.Tables[0].Rows[i][33].ToString()),
new_guarantor2 = FindClient(dataFromXmlx.Tables[0].Rows[i][34].ToString()),
new_guarantor3 = FindClient(dataFromXmlx.Tables[0].Rows[i][35].ToString()),
new_amount_loan = ToDouble(dataFromXmlx.Tables[0].Rows[i][36].ToString()),
new_spouse = FindClient(dataFromXmlx.Tables[0].Rows[i][37].ToString()),
new_accident1 = FindClient(dataFromXmlx.Tables[0].Rows[i][38].ToString()),
new_accident2 = FindClient(dataFromXmlx.Tables[0].Rows[i][39].ToString()),
new_accident3 = FindClient(dataFromXmlx.Tables[0].Rows[i][40].ToString()),
new_accident4 = FindClient(dataFromXmlx.Tables[0].Rows[i][41].ToString()),
new_institution = FindGos(dataFromXmlx.Tables[0].Rows[i][42].ToString()),
new_amount = ToDouble(dataFromXmlx.Tables[0].Rows[i][43].ToString())
};
service.Create(newSprava);
Console.WriteLine("{0} Обработан и создан: {1}", i, dataFromXmlx.Tables[0].Rows[i][0].ToString());
}
}
private static void LoadSprava()
{
var service = new OrganizationService(connection);
var context = new CrmOrganizationServiceContext(connection);
var dataFromXmlx = new Program().ExcelOpenSpreadsheets(@"C:\Users\savchinvv\Desktop\Дела_юр.xlsx");
for (int i = 37; i < dataFromXmlx.Tables[0].Rows.Count; i++)
{
var newSprava = new new_spravastr()
{
new_businessnumber = dataFromXmlx.Tables[0].Rows[i][0].ToString(),
new_nameid = FindClient(dataFromXmlx.Tables[0].Rows[i][1].ToString()),
new_partnercustomer = FindAccount(dataFromXmlx.Tables[0].Rows[i][2].ToString()),
new_typeofbusiness = EntityForm(dataFromXmlx.Tables[0].Rows[i][3].ToString()),
new_type_of_business = CheckType(dataFromXmlx.Tables[0].Rows[i][4].ToString()),
new_priority = ToInt32(dataFromXmlx.Tables[0].Rows[i][5].ToString()),
new_state = FindState(dataFromXmlx.Tables[0].Rows[i][6].ToString()),
new_creationdate = FindDate(dataFromXmlx.Tables[0].Rows[i][7].ToString()),
new_liquidated = FindBit(dataFromXmlx.Tables[0].Rows[i][8].ToString()),
new_gai = FindGos(dataFromXmlx.Tables[0].Rows[i][9].ToString()),
new_datedtp = FindDate(dataFromXmlx.Tables[0].Rows[i][10].ToString()),
new_Dateagreement = FindDate(dataFromXmlx.Tables[0].Rows[i][11].ToString()),
new_date_of_birth = FindDate(dataFromXmlx.Tables[0].Rows[i][12].ToString()),
new_date_death = FindDate(dataFromXmlx.Tables[0].Rows[i][13].ToString()),
new_pledge = dataFromXmlx.Tables[0].Rows[i][14].ToString(),
new_property1 = dataFromXmlx.Tables[0].Rows[i][15].ToString(),
new_property2 = dataFromXmlx.Tables[0].Rows[i][16].ToString(),
new_taxnumber = dataFromXmlx.Tables[0].Rows[i][17].ToString(),
new_code = dataFromXmlx.Tables[0].Rows[i][18].ToString(),
new_placedtp = dataFromXmlx.Tables[0].Rows[i][19].ToString(),
new_locality = dataFromXmlx.Tables[0].Rows[i][20].ToString(),
new_home = dataFromXmlx.Tables[0].Rows[i][21].ToString(),
new_Place_of_work_1 = dataFromXmlx.Tables[0].Rows[i][22].ToString(),
new_Place_of_work_2 = dataFromXmlx.Tables[0].Rows[i][23].ToString(),
new_Companyname = dataFromXmlx.Tables[0].Rows[i][24].ToString(),
new_insurancecompany = dataFromXmlx.Tables[0].Rows[i][25].ToString(),
new_taxaddress = dataFromXmlx.Tables[0].Rows[i][26].ToString(),
new_heir1 = FindClient(dataFromXmlx.Tables[0].Rows[i][27].ToString()),
new_heir2 = FindClient(dataFromXmlx.Tables[0].Rows[i][28].ToString()),
new_heir3 = FindClient(dataFromXmlx.Tables[0].Rows[i][29].ToString()),
new_Credit_agreement = dataFromXmlx.Tables[0].Rows[i][30].ToString(),
new_Social_security_number = dataFromXmlx.Tables[0].Rows[i][31].ToString(),
new_litigationnumber = dataFromXmlx.Tables[0].Rows[i][32].ToString(),
new_guarantor1 = FindClient(dataFromXmlx.Tables[0].Rows[i][33].ToString()),
new_guarantor2 = FindClient(dataFromXmlx.Tables[0].Rows[i][34].ToString()),
new_guarantor3 = FindClient(dataFromXmlx.Tables[0].Rows[i][35].ToString()),
new_amount_loan = ToDouble(dataFromXmlx.Tables[0].Rows[i][36].ToString()),
new_spouse = FindClient(dataFromXmlx.Tables[0].Rows[i][37].ToString()),
new_accident1 = FindClient(dataFromXmlx.Tables[0].Rows[i][38].ToString()),
new_accident2 = FindClient(dataFromXmlx.Tables[0].Rows[i][39].ToString()),
new_accident3 = FindClient(dataFromXmlx.Tables[0].Rows[i][40].ToString()),
new_accident4 = FindClient(dataFromXmlx.Tables[0].Rows[i][41].ToString()),
new_institution = FindGos(dataFromXmlx.Tables[0].Rows[i][42].ToString()),
new_amount = ToDouble(dataFromXmlx.Tables[0].Rows[i][43].ToString())
};
service.Create(newSprava);
Console.WriteLine("{0} Обработан и создан: {1}", i, dataFromXmlx.Tables[0].Rows[i][0].ToString());
}
}
