public static bool AddCharity(Charity charity)
{
int ID = addCharity(charity.RegNumber, charity.UserRoleID, charity.UserFullName, charity.UserCity, charity.UserProvince, charity.UserPostalCode, charity.UserAddress1, charity.UserAddress2, charity.UserPhone, charity.UserWebsite, charity.UserEmail);
if (ID == -1)
return false;
if (!addCharityProfile(ID, charity.RegNumber, charity.CharityCategoryID, charity.CharityDesignationID))
return false;
foreach (string Program in charity.CharityPrograms)
{
bool valid = addCharityProgram(ID, Program);
}
foreach (string Country in charity.CharityCountries)
{
bool valid = addCharityActivityCountry(ID, Country);
}
return true;
}
private bool loadCharitiesIdentificationFile(string FileName)
{
charities = new List<Charity>();
charitiesDistinctRegNumbers = new List<string>();
charitiesErros = 0;
try
{
FileStream file = new FileStream(FileName, FileMode.Open);
StreamReader reader = new StreamReader(file);
if (!reader.EndOfStream)
reader.ReadLine();
int counter = 0;
while (!reader.EndOfStream)
{
counter++;
string line = reader.ReadLine();
string[] values = line.Split(',');
if (values.Length == 0)
continue;
for (int i = 0; i < values.Length; i++)
values[i] = values[i].Replace("***", ",").Trim();
string RegNum = values[0];
int CategoryID = int.Parse(values[1]);
string DesignationID = values[2];
string FullName = values[4];
string Address1 = values[5];
string Address2 = values[6];
string City = values[7];
string Province = values[8];
string PostalCode = values[9];
string Country = values[10].Trim();
string Phone = values[12];
string Email = values[13];
string Website = values[14];
if (Country.ToLower() != "ca")
{
charitiesErros++;
continue;
}
if (!charitiesDistinctRegNumbers.Contains(RegNum))
charitiesDistinctRegNumbers.Add(RegNum);
if (!charityTypesConvertedTable.ContainsKey(CategoryID))
{
charitiesErros++;
continue;
}
if (!designationConvertedTable.ContainsKey(DesignationID))
{
charitiesErros++;
continue;
}
Charity charity = new Charity(RegNum, FullName, City, Province, PostalCode, Address1, Address2, Phone, Website, Email, charityTypesConvertedTable[CategoryID], designationConvertedTable[DesignationID]);
charities.Add(charity);
}
file.Close();
reader.Close();
return true;
}
catch
{
MessageBox.Show("Charities Error");
return false;
}
}