private void LoadData(int _TenantID)
{
lblTenantID.Text = _TenantID.ToString();
string strSelect = "SELECT FName, MName, LName, Gender, Email, BDate, Street + ', ' + City + ' ' + Region + ' ' + Country AS 'Address', MobileNo, UN, PhotoFile, DateRegistered, FingerprintID FROM Tenants WHERE TenantID=@TID";
SqlParameter[] TID = { new SqlParameter("@TID", _TenantID) };
SqlDataReader dr = DataAccess.ReturnReader(strSelect, TID, ConnString);
dr.Read();
lblAddress.Text = dr["Address"].ToString();
lblContactNo.Text = dr["MobileNo"].ToString();
lblDateOfBirth.Text = Convert.ToDateTime(dr["BDate"].ToString()).ToString("MMMM dd, yyyy");
lblDateRegistered.Text = dr["DateRegistered"].ToString();
lblEmailAdd.Text = dr["Email"].ToString();
lblFingerID.Text = dr["FingerprintID"].ToString();
lblFName.Text = dr["FName"].ToString();
lblGender.Text = IntToWords.getGender(int.Parse(dr["Gender"].ToString()));
lblLName.Text = dr["LName"].ToString();
lblMName.Text = dr["MName"].ToString();
lblUsername.Text = dr["UN"].ToString();
string photofile = dr["PhotoFile"].ToString();
if (photofile.Trim() == "" || photofile == null)
{
ImgMyPhoto.ImageUrl = "~/images/nophoto.jpg";
}
else
{
ImgMyPhoto.ImageUrl = "~/uploads/" + photofile;
}
DataAccess.ForceConnectionToClose();
}
private void LoadData(int _EmployeeID)
{
lblEmployeeID.Text = _EmployeeID.ToString();
string strSelect = "SELECT * FROM Employees WHERE EmployeeID=@EID";
SqlParameter[] EID = { new SqlParameter("@EID", _EmployeeID) };
SqlDataReader dr = DataAccess.ReturnReader(strSelect, EID, ConnString);
dr.Read();
lblAdminAccess.Text = IntToWords.getAdminAccess(int.Parse(dr["AdminLevel"].ToString()));
lblContactNo.Text = dr["ContactNo"].ToString();
lblDateOfBirth.Text = Convert.ToDateTime(dr["BDate"].ToString()).ToString("MMMM dd, yyyy");
lblDateOfEmployment.Text = DateTime.Parse(dr["DateOfEmployment"].ToString()).ToString("MMMM dd, yyyy");
lblEmailAdd.Text = dr["Email"].ToString();
lblFingerID.Text = dr["FingerprintID"].ToString();
lblFName.Text = dr["FName"].ToString();
lblGender.Text = IntToWords.getGender(int.Parse(dr["Gender"].ToString()));
lblLName.Text = dr["LName"].ToString();
lblMName.Text = dr["MName"].ToString();
lblUsername.Text = dr["UN"].ToString();
string photofile = dr["PhotoFile"].ToString();
if (photofile.Trim() == "" || photofile == null)
{
ImgMyPhoto.ImageUrl = "~/images/nophoto.jpg";
}
else
{
ImgMyPhoto.ImageUrl = "~/uploads/" + photofile;
}
DataAccess.ForceConnectionToClose();
}
public void ConvertInt_Negative5Passed_ThrowsException()
{
Exception exception = null;
try
{
IntToWords.ConvertInt(-5);
}
catch (Exception ex)
{
exception = ex;
}
Assert.IsNotNull(exception);
}
private void LoadData(int _GuardianID)
{
lblGuardianID.Text = _GuardianID.ToString();
string strSelect = "SELECT FName, MName, LName, Gender, BDate, ContactNo, Email, Address, UN FROM Guardians WHERE GuardianID=@GID";
SqlParameter[] GID = { new SqlParameter("@GID", _GuardianID) };
SqlDataReader dr = DataAccess.ReturnReader(strSelect, GID, ConnString);
dr.Read();
lblAddress.Text = dr["Address"].ToString();
lblContactNo.Text = dr["ContactNo"].ToString();
lblDateOfBirth.Text = Convert.ToDateTime(dr["BDate"].ToString()).ToString("MMMM dd, yyyy");
lblEmailAdd.Text = dr["Email"].ToString();
lblFName.Text = dr["FName"].ToString();
lblGender.Text = IntToWords.getGender(int.Parse(dr["Gender"].ToString()));
lblLName.Text = dr["LName"].ToString();
lblMName.Text = dr["MName"].ToString();
lblUsername.Text = dr["UN"].ToString();
}
public string GetGender(int _GenderID)
{
return(IntToWords.getGender(_GenderID));
}
public string GetBedSide(int _BedSideID)
{
return(IntToWords.getBedside(_BedSideID));
}
public void ConvertInt_50000Passed_ReturnsFiftyThousand()
{
Assert.AreEqual("Fifty Thousand", IntToWords.ConvertInt(50000));
}
public void ConvertInt_123000Passed_ReturnsOneHundredTwentyThreeThousand()
{
Assert.AreEqual("One Hundred Twenty Three Thousand", IntToWords.ConvertInt(123000));
}
public void ConvertInt_123Passed_ReturnsOneHundredTwentyThree()
{
Assert.AreEqual("One Hundred Twenty Three", IntToWords.ConvertInt(123));
}
public void ConvertInt_1000010Passed_ReturnsOneMillionTen()
{
Assert.AreEqual("One Million Ten", IntToWords.ConvertInt(1000010));
}
public void ConvertInt_0Passed_ReturnsZero()
{
Assert.AreEqual("Zero", IntToWords.ConvertInt(0));
}
