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