public CharityProfile(int UserID, string UserName, UserRole Role,
string FullName,
string City, string Province, string PostalCode, string Address1, string Address2,
string Phone, string Website, string Email,
string RegNumber,
CharityCategory Category, CharityDesignation Designation) :
this(UserID, UserName, Role, FullName, City, Province, PostalCode, Address1, Address2, Phone, Website, Email,
RegNumber, Category, Designation, new List <CharityProgram>(), new List <CharityActivityCountry>())
{
}
public CharityProfile(int UserID, string UserName, UserRole Role,
string FullName,
string City, string Province, string PostalCode, string Address1, string Address2,
string Phone, string Website, string Email,
string RegNumber,
CharityCategory Category, CharityDesignation Designation)
: this(UserID, UserName, Role, FullName, City, Province, PostalCode, Address1, Address2, Phone, Website, Email,
RegNumber, Category, Designation, new List<CharityProgram>(), new List<CharityActivityCountry>())
{
}
public CharityProfile(int UserID, string UserName, UserRole Role,
string FullName,
string City, string Province, string PostalCode, string Address1, string Address2,
string Phone, string Website, string Email,
string RegNumber,
CharityCategory Category, CharityDesignation Designation,
List <CharityProgram> Programs, List <CharityActivityCountry> Countries) :
base(UserID, UserName, Role, FullName, City, Province, PostalCode, Address1, Address2, Phone, Website, Email)
{
this.RegNumber = RegNumber;
this.Category = Category;
this.Designation = Designation;
this.Programs = Programs;
this.Countries = Countries;
}
public CharityProfile(int UserID, string UserName, UserRole Role,
string FullName,
string City, string Province, string PostalCode, string Address1, string Address2,
string Phone, string Website, string Email,
string RegNumber,
CharityCategory Category, CharityDesignation Designation,
List<CharityProgram> Programs, List<CharityActivityCountry> Countries)
: base(UserID, UserName, Role, FullName, City, Province, PostalCode, Address1, Address2, Phone, Website, Email)
{
this.RegNumber = RegNumber;
this.Category = Category;
this.Designation = Designation;
this.Programs = Programs;
this.Countries = Countries;
}
private static CharityDesignation GetCharityDesignation(int CharityDesignationID)
{
try
{
//###########
//# Command #
//###########
string command = "SELECT designationID, description FROM [Designation] WHERE designationID = @DesignationID";
//##############
//# Parameters #
//##############
List<SqlParameter> parameters = new List<SqlParameter>();
parameters.Add(new SqlParameter("@DesignationID", CharityDesignationID));
//#############
//# Execution #
//#############
DataTable table = DatabaseManager.ExecuteDataQueryCommand(command, parameters.ToArray());
if (table == null)
return null;
//############
//# Analysis #
//############
CharityDesignation designation = null;
if (table.Rows.Count > 0)
{
DataRow row = table.Rows[0];
int designationID = int.Parse(row["designationID"].ToString());
string description = row["description"].ToString();
designation = new CharityDesignation(designationID, description);
}
return designation;
}
catch { return null; }
}