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)); }