public void TestAESDecrypt()
{
string key = "706a344a66ff2e45";
string data = "Z6sZ75oV3Ekuy0XIB9ks5Q==";
string result = AESUtil.AESDecrypt(data, key);
Assert.AreEqual("hello", result);
}
protected void DateButton_Click(object sender, EventArgs e)
{
//update database
txtBuildingID.Text = AESUtil.DecryptString(Request["BuildingID"].ToWSSafeString()); //viewstate is disabled, need to update this on postback
String fld = "INSP" + ConfigurationManager.AppSettings["InspectionYear"].ToWSSafeString();
String sSql = String.Format("UPDATE [{0}] SET [{1}] = DATE() WHERE [BUILDING_ID]={2} AND [{1}] IS NULL", m_FeatureClassTable, fld, txtBuildingID.Text);
DBUtil.ConnExecute(DBUtil.DBConnType.Oledb, m_LookupTablesDBConnection, sSql);
Response.Redirect(Request.RawUrl);
}
public static String GenerateSubMenu(String buildingid, String section, String category)
{
String sm = "";
String sql = String.Format("SELECT Q_SubCategory_List.SectionName, Q_SubCategory_List.Main_Category, Q_SubCategory_List.Sub_Category, IIf([Q_Data1_L2_Count].ct Is Null,0,[Q_Data1_L2_Count].ct) AS ct, IIf([Q_Data1_L2_Count_Failed].ct Is Null,0,[Q_Data1_L2_Count_Failed].ct) AS ctfailed, Q_SubCategory_List.DisplayOrder, QBDG.Building_ID, Q_SubCategory_List.DataForm, Q_SubCategory_List.ID FROM (Q_SubCategory_List LEFT JOIN (SELECT * FROM Q_Data1_L2_Count WHERE BUILDING_ID={0}) AS QBDG ON (Q_SubCategory_List.ID = QBDG.ID)) LEFT JOIN (SELECT * FROM Q_Data1_L2_Count_Failed WHERE BUILDING_ID={0}) AS QBDG2 ON (Q_SubCategory_List.ID = QBDG2.ID) WHERE Q_SubCategory_List.Main_Category='{2}' ORDER BY Q_SubCategory_List.DisplayOrder", buildingid, section.ToWSSafeString(), category.ToWSSafeString());
DataTable dtItemList = DBUtil.GetOLEDataTable("_SiteAccess", sql, "itemlist");
sm += "<ul data-role='listview' data-inset='true' data-filter='false' data-theme='f' >";
foreach (DataRow dr in dtItemList.Rows)
{
String menulabel = GetCategoryLabel(dr[m_field_subCategory].ToWSSafeString());
Int16 dataform = Convert.ToInt16(dr["DataForm"]);
String scid = dr["ID"].ToWSSafeString();
String linkurl = "";
Int16 dataCount = Convert.ToInt16(dr["ct"]);
Int16 failedCount = Convert.ToInt16(dr["ctfailed"]);
switch (dataform)
{
case 0:
linkurl = String.Format("{0}?BuildingID={1}&SCID={2}",
dataForm0, AESUtil.EncryptString(buildingid), AESUtil.EncryptString(scid));
string Form0Count = DBUtil.DoLookup(DBUtil.DBType.oledb, "_SiteAccess", "Building_ID", buildingid, DBUtil.FieldType.number, "ct", String.Format("SELECT * FROM [Q_Data0_L2_count] WHERE ID={0}", dr["ID"].ToWSSafeString()));
if (String.IsNullOrWhiteSpace(Form0Count))
{
dataCount = 0;
}
else
{
dataCount = Convert.ToInt16(Form0Count);
}
failedCount = 0;
break;
case 1:
linkurl = String.Format("{0}?BuildingID={1}&SCID={2}",
dataForm1, AESUtil.EncryptString(buildingid), AESUtil.EncryptString(scid));
break;
default:
linkurl = String.Format("{0}?BuildingID={1}&SCID={2}",
dataForm1, AESUtil.EncryptString(buildingid), AESUtil.EncryptString(scid));
break;
}
sm += "<li>";
sm += String.Format("<a class='listbutton-no-ellipsis' href='{1}'>{0}</a>", menulabel, linkurl);
if (failedCount > 0)
{
sm += String.Format("<span class='ul-li-image-bubble-container' ><span class='ul-li-image-bubble-caption'>{0}</span></span>", failedCount);
}
sm += String.Format("<span class='ui-li-count'>{0}</span>", dataCount);
sm += "</li>";
}
sm += "</ul>";
return(sm);
}
