public static DataTable SavedSearch(string sMODULE) { HttpSessionState Session = HttpContext.Current.Session; var dt = Session["vwSAVED_SEARCH." + sMODULE] as DataTable; if (dt == null) { dt = new DataTable(); if (Security.IsAuthenticated()) { var oQuery = new InlineQueryDBManager(); string innerSql = "select ID " + ControlChars.CrLf + " , NAME " + ControlChars.CrLf + " , CONTENTS " + ControlChars.CrLf + " from vwSAVED_SEARCH " + ControlChars.CrLf + " where ASSIGNED_USER_ID = @USER_ID" + ControlChars.CrLf + " and SEARCH_MODULE = @MODULE " + ControlChars.CrLf + " order by NAME " + ControlChars.CrLf; oQuery.CommandText = innerSql; oQuery.Add("@USER_ID", SqlDbType.UniqueIdentifier, Security.USER_ID); oQuery.Add("@MODULE", SqlDbType.VarChar, sMODULE); dt = oQuery.GetTable(); Session["vwSAVED_SEARCH." + sMODULE] = dt; } } return(dt); }
protected void Page_Load(object sender, EventArgs e) { SetPageTitle(Translation.GetTranslation.Term(".moduleList." + m_sMODULE)); Visible = (Security.GetUserAccess(m_sMODULE, "edit") >= 0); if (!Visible) { return; } gID = CommonTypeConvert.ToGuid(Request["ID"]); if (!IsPostBack) { ctlDynamicButtons.AppendButtons(m_sMODULE + ".EditView", Guid.Empty, null); Guid gDuplicateID = CommonTypeConvert.ToGuid(Request["DuplicateID"]); if (!CommonTypeConvert.IsEmptyGuid(gID) || !CommonTypeConvert.IsEmptyGuid(gDuplicateID)) { var oQuery = new InlineQueryDBManager(); string innerSql = ApplicationSQL.SQL["Administration_ProductTemplates_EditView"].ToString(); oQuery.CommandText = innerSql; if (!CommonTypeConvert.IsEmptyGuid(gDuplicateID)) { oQuery.Add("@ID", SqlDbType.UniqueIdentifier, gDuplicateID); gID = Guid.Empty; } else { oQuery.Add("@ID", SqlDbType.UniqueIdentifier, gID); } using (SqlDataReader rdr = oQuery.ExecuteReader(CommandBehavior.SingleRow)) { if (rdr.Read()) { ctlModuleHeader.Title = CommonTypeConvert.ToString(rdr["NAME"]); SetPageTitle(Translation.GetTranslation.Term(".moduleList." + m_sMODULE) + " - " + ctlModuleHeader.Title); Utils.UpdateTracker(Page, m_sMODULE, gID, ctlModuleHeader.Title); ViewState["ctlModuleHeader.Title"] = ctlModuleHeader.Title; AppendEditViewFields(m_sMODULE + ".EditView", tblMain, rdr); } } } else { AppendEditViewFields(m_sMODULE + ".EditView", tblMain, null); } } else { ctlModuleHeader.Title = CommonTypeConvert.ToString(ViewState["ctlModuleHeader.Title"]); SetPageTitle(Translation.GetTranslation.Term(".moduleList." + m_sMODULE) + " - " + ctlModuleHeader.Title); } }
public static DataTable ReportingModules() { Cache Cache = HttpRuntime.Cache; var dt = Cache.Get("vwMODULES_Reporting_" + Security.USER_ID) as DataTable; if (dt == null) { var oQuery = new InlineQueryDBManager(); string innerSql = "select MODULE_NAME " + ControlChars.CrLf + " , DISPLAY_NAME " + ControlChars.CrLf + " from vwMODULES_Reporting " + ControlChars.CrLf + " where USER_ID = @USER_ID " + ControlChars.CrLf + " or USER_ID is null " + ControlChars.CrLf; oQuery.CommandText = innerSql; oQuery.Add("@USER_ID", SqlDbType.UniqueIdentifier, Security.USER_ID); dt = oQuery.GetTable(); foreach (DataRow row in dt.Rows) { row["DISPLAY_NAME"] = Translation.GetTranslation.Term(CommonTypeConvert.ToString(row["DISPLAY_NAME"])); } Cache.Insert("vwMODULES_Reporting_" + Security.USER_ID, dt, null, DefaultCacheExpiration(), Cache.NoSlidingExpiration); } return(dt); }
private void UpdateContact(Guid gCONTACT_ID, bool bUpdateBilling, bool bUpdateShipping) { string innerSql = ApplicationSQL.SQL["Invoices_EditView_267"].ToString(); var oQuery = new InlineQueryDBManager(); oQuery.CommandText = innerSql; oQuery.Add("@ID", SqlDbType.UniqueIdentifier, gCONTACT_ID); using (SqlDataReader rdr = oQuery.ExecuteReader(CommandBehavior.SingleRow)) { if (rdr.Read()) { if (bUpdateBilling) { new DynamicControl(this, "BILLING_CONTACT_ID").ID = CommonTypeConvert.ToGuid(rdr["ID"]); new DynamicControl(this, "BILLING_CONTACT_NAME").Text = CommonTypeConvert.ToString(rdr["NAME"]); } if (bUpdateShipping) { new DynamicControl(this, "SHIPPING_CONTACT_ID").ID = CommonTypeConvert.ToGuid(rdr["ID"]); new DynamicControl(this, "SHIPPING_CONTACT_NAME").Text = CommonTypeConvert.ToString(rdr["NAME"]); } Guid gACCOUNT_ID = CommonTypeConvert.ToGuid(rdr["ACCOUNT_ID"]); if (!CommonTypeConvert.IsEmptyGuid(gACCOUNT_ID)) { UpdateAccount(gACCOUNT_ID, bUpdateBilling, bUpdateShipping); } } } }
public static string ReportingFilterColumnsListName(string sMODULE_NAME, string sDATA_FIELD) { Cache Cache = HttpRuntime.Cache; var sLIST_NAME = Cache.Get("vwSqlColumns_ListName." + sMODULE_NAME + "." + sDATA_FIELD) as string; if (sLIST_NAME == null) { var oQuery = new InlineQueryDBManager(); string innerSql = ApplicationSQL.SQL["_code_CRMCache_529"].ToString(); oQuery.CommandText = innerSql; oQuery.Add("@OBJECTNAME", SqlDbType.VarChar, 100, "vw" + sMODULE_NAME); oQuery.Add("@DATA_FIELD", SqlDbType.VarChar, 100, sDATA_FIELD); sLIST_NAME = CommonTypeConvert.ToString(oQuery.ExecuteScalar()); Cache.Insert("vwSqlColumns_ListName." + sMODULE_NAME + "." + sDATA_FIELD, sLIST_NAME, null, DefaultCacheExpiration(), Cache.NoSlidingExpiration); } return(sLIST_NAME); }
public static DataTable List(string sModuleName, string sListName) { Cache Cache = HttpRuntime.Cache; var dt = Cache.Get(Translation.GetTranslation.NAME + "." + sListName) as DataTable; if (dt == null) { var oQuery = new InlineQueryDBManager(); string innerSql = ApplicationSQL.SQL["_code_CRMCache_177"].ToString(); oQuery.CommandText = innerSql; oQuery.Add("@MODULE_NAME", SqlDbType.NVarChar, sModuleName.ToLower()); oQuery.Add("@LIST_NAME", SqlDbType.NVarChar, sListName.ToLower()); oQuery.Add("@LANG", SqlDbType.NVarChar, Translation.GetTranslation.NAME.ToLower()); dt = oQuery.GetTable(); Cache.Insert(Translation.GetTranslation.NAME + "." + sListName, dt, null, DefaultCacheExpiration(), Cache.NoSlidingExpiration); } return(dt); }
public static DataTable Shortcuts(string sMODULE_NAME) { var dt = HttpContext.Current.Session["vwSHORTCUTS_Menu_ByUser." + sMODULE_NAME + "." + Security.USER_ID] as DataTable; if (dt == null) { dt = new DataTable(); if (Security.IsAuthenticated()) { var oQuery = new InlineQueryDBManager(); string innerSql = ApplicationSQL.SQL["_code_CRMCache_1304"].ToString(); oQuery.CommandText = innerSql; oQuery.Add("@MODULE_NAME", SqlDbType.VarChar, 100, sMODULE_NAME); oQuery.Add("@USER_ID", SqlDbType.UniqueIdentifier, Security.USER_ID); dt = oQuery.GetTable(); HttpContext.Current.Session["vwSHORTCUTS_Menu_ByUser." + sMODULE_NAME + "." + Security.USER_ID] = dt; } } return(dt); }
protected void Page_Load(object sender, EventArgs e) { SetPageTitle(Translation.GetTranslation.Term("Manufacturers.LBL_NAME")); Visible = Security.IS_ADMIN; Visible = Security.ADMIN_TYPE == 0 ? true : false; if (!Visible) { return; } reqNAME.DataBind(); reqLIST_ORDER.DataBind(); gID = CommonTypeConvert.ToGuid(Request["ID"]); if (!IsPostBack) { ctlDynamicButtons.AppendButtons(m_sMODULE + ".EditView", Guid.Empty, null); lstSTATUS.DataSource = CRMCache.List("manufacturer_status_dom"); lstSTATUS.DataBind(); if (!CommonTypeConvert.IsEmptyGuid(gID)) { var oQuery = new InlineQueryDBManager(); string innerSql = ApplicationSQL.SQL["Administration_Manufacturers_EditView"].ToString(); oQuery.CommandText = innerSql; oQuery.Add("@ID", SqlDbType.UniqueIdentifier, gID); using (SqlDataReader rdr = oQuery.ExecuteReader(CommandBehavior.SingleRow)) { if (rdr.Read()) { txtNAME.Text = CommonTypeConvert.ToString(rdr["NAME"]); ctlListHeader.Title = Translation.GetTranslation.Term("Manufacturers.LBL_NAME") + " " + txtNAME.Text; txtLIST_ORDER.Text = CommonTypeConvert.ToString(rdr["LIST_ORDER"]); lstSTATUS.SelectedValue = CommonTypeConvert.ToString(rdr["STATUS"]); } } } else { var oQuery = new InlineQueryDBManager(); string innerSql = ApplicationSQL.SQL["Manufacturers_EditView_113"].ToString(); oQuery.CommandText = innerSql; txtLIST_ORDER.Text = (CommonTypeConvert.ToInteger(oQuery.ExecuteScalar()) + 1).ToString(); } } }
protected void Page_Load(object sender, EventArgs e) { SetPageTitle(Translation.GetTranslation.Term("Manufacturers.LBL_NAME")); Visible = Security.IS_ADMIN; Visible = Security.ADMIN_TYPE == 0 ? true : false; if (!Visible) return; reqNAME.DataBind(); reqLIST_ORDER.DataBind(); gID = CommonTypeConvert.ToGuid(Request["ID"]); if (!IsPostBack) { ctlDynamicButtons.AppendButtons(m_sMODULE + ".EditView", Guid.Empty, null); lstSTATUS.DataSource = CRMCache.List("manufacturer_status_dom"); lstSTATUS.DataBind(); if (!CommonTypeConvert.IsEmptyGuid(gID)) { var oQuery = new InlineQueryDBManager(); string innerSql = ApplicationSQL.SQL["Administration_Manufacturers_EditView"].ToString(); oQuery.CommandText = innerSql; oQuery.Add("@ID", SqlDbType.UniqueIdentifier, gID); using (SqlDataReader rdr = oQuery.ExecuteReader(CommandBehavior.SingleRow)) { if (rdr.Read()) { txtNAME.Text = CommonTypeConvert.ToString(rdr["NAME"]); ctlListHeader.Title = Translation.GetTranslation.Term("Manufacturers.LBL_NAME") + " " + txtNAME.Text; txtLIST_ORDER.Text = CommonTypeConvert.ToString(rdr["LIST_ORDER"]); lstSTATUS.SelectedValue = CommonTypeConvert.ToString(rdr["STATUS"]); } } } else { var oQuery = new InlineQueryDBManager(); string innerSql = ApplicationSQL.SQL["Manufacturers_EditView_113"].ToString(); oQuery.CommandText = innerSql; txtLIST_ORDER.Text = (CommonTypeConvert.ToInteger(oQuery.ExecuteScalar()) + 1).ToString(); } } }
protected void Page_Load(object sender, EventArgs e) { SetPageTitle(Translation.GetTranslation.Term(".moduleList." + m_sMODULE)); Visible = (Security.GetUserAccess(m_sMODULE, "view") >= 0); if (!Visible) { return; } gID = CommonTypeConvert.ToGuid(Request["ID"]); if (!IsPostBack) { if (!CommonTypeConvert.IsEmptyGuid(gID)) { var oQuery = new InlineQueryDBManager(); string innerSql = ApplicationSQL.SQL["Administration_ProductTemplates_EditView"].ToString(); oQuery.CommandText = innerSql; oQuery.Add("@ID", SqlDbType.UniqueIdentifier, gID); using (SqlDataReader rdr = oQuery.ExecuteReader(CommandBehavior.SingleRow)) { if (rdr.Read()) { ctlModuleHeader.Title = CommonTypeConvert.ToString(rdr["NAME"]); SetPageTitle(Translation.GetTranslation.Term(".moduleList." + m_sMODULE) + " - " + ctlModuleHeader.Title); Utils.UpdateTracker(Page, m_sMODULE, gID, ctlModuleHeader.Title); AppendDetailViewFields(m_sMODULE + ".DetailView", tblMain, rdr, Page_Command); ctlDynamicButtons.AppendButtons(m_sMODULE + ".DetailView", Guid.Empty, rdr); } else { plcSubPanel.Visible = false; ctlDynamicButtons.AppendButtons(m_sMODULE + ".DetailView", Guid.Empty, null); ctlDynamicButtons.DisableAll(); ctlDynamicButtons.ErrorText = Translation.GetTranslation.Term("ACL.LBL_NO_ACCESS"); } } } else { ctlDynamicButtons.AppendButtons(m_sMODULE + ".DetailView", Guid.Empty, null); ctlDynamicButtons.DisableAll(); } } }
public static DataTable ReportingFilterColumns(string sMODULE_NAME) { Cache Cache = HttpRuntime.Cache; var dt = Cache.Get("vwSqlColumns_Reporting." + sMODULE_NAME) as DataTable; if (dt == null) { var oQuery = new InlineQueryDBManager(); string innerSql = ApplicationSQL.SQL["_code_CRMCache_491"].ToString(); oQuery.CommandText = innerSql; oQuery.Add("@OBJECTNAME", SqlDbType.VarChar, 100, "vw" + sMODULE_NAME); dt = oQuery.GetTable(); Cache.Insert("vwSqlColumns_Reporting." + sMODULE_NAME, dt, null, DefaultCacheExpiration(), Cache.NoSlidingExpiration); } return(dt); }
public static DataTable FieldsMetaData_Validated(string sMODULE) { Cache Cache = HttpRuntime.Cache; var dt = Cache.Get("vwFIELDS_META_DATA_Validated." + sMODULE) as DataTable; if (dt == null) { var oQuery = new InlineQueryDBManager(); string innerSql = ApplicationSQL.SQL["_code_CRMCache_1741"].ToString(); oQuery.CommandText = innerSql; oQuery.Add("@CUSTOM_MODULE", SqlDbType.VarChar, sMODULE); dt = oQuery.GetTable(); Cache.Insert("vwFIELDS_META_DATA_Validated." + sMODULE, dt, null, DefaultCacheExpiration(), Cache.NoSlidingExpiration); } return(dt); }
public static DataTable FieldsMetaData_UnvalidatedCustomFields(string sTABLE_NAME) { Cache Cache = HttpRuntime.Cache; var dt = Cache.Get("vwFIELDS_META_DATA_Unvalidated." + sTABLE_NAME) as DataTable; if (dt == null) { var oQuery = new InlineQueryDBManager(); string innerSql = ApplicationSQL.SQL["_code_CRMCache_1694"].ToString(); oQuery.CommandText = innerSql; oQuery.Add("@TABLE_NAME", SqlDbType.VarChar, sTABLE_NAME + "_CSTM"); dt = oQuery.GetTable(); Cache.Insert("vwFIELDS_META_DATA_Unvalidated." + sTABLE_NAME, dt, null, DefaultCacheExpiration(), Cache.NoSlidingExpiration); } return(dt); }
protected void BindGrid() { var oQuery = new InlineQueryDBManager(); string innerSql = "select " + CommonTypeConvert.FormatSelectFields(arrSelectFields) + " from vwPRODUCT_TEMPLATES_NOTES" + ControlChars.CrLf + " where 1 = 1 " + ControlChars.CrLf; oQuery.CommandText = innerSql; oQuery.Add("@PRODUCT_TEMPLATE_ID", SqlDbType.UniqueIdentifier, gID); TypeConvert.AppendParameter(oQuery, gID, "PRODUCT_TEMPLATE_ID"); oQuery.CommandText += grdMain.OrderByClause("DATE_MODIFIED", "asc"); DataTable dt = oQuery.GetTable(); vwMain = dt.DefaultView; grdMain.DataSource = vwMain; grdMain.DataBind(); }
public static DataTable MobileMenu() { HttpSessionState Session = HttpContext.Current.Session; var dt = Session["vwMODULES_MobileMenu_ByUser." + Security.USER_ID] as DataTable; if (dt == null) { var oQuery = new InlineQueryDBManager(); string innerSql = ApplicationSQL.SQL["_code_CRMCache_1252"].ToString(); oQuery.CommandText = innerSql; oQuery.Add("@USER_ID", SqlDbType.UniqueIdentifier, Security.USER_ID); dt = oQuery.GetTable(); Session["vwMODULES_MobileMenu_ByUser." + Security.USER_ID] = dt; } return(dt); }
protected void Page_Load(object sender, EventArgs e) { SetPageTitle(Translation.GetTranslation.Term(".moduleList." + m_sMODULE)); Visible = (Security.GetUserAccess(m_sMODULE, "view") >= 0); if (!Visible) return; gID = CommonTypeConvert.ToGuid(Request["ID"]); if (!IsPostBack) { if (!CommonTypeConvert.IsEmptyGuid(gID)) { var oQuery = new InlineQueryDBManager(); string innerSql = ApplicationSQL.SQL["Administration_ProductTemplates_EditView"].ToString(); oQuery.CommandText = innerSql; oQuery.Add("@ID", SqlDbType.UniqueIdentifier, gID); using (SqlDataReader rdr = oQuery.ExecuteReader(CommandBehavior.SingleRow)) { if (rdr.Read()) { ctlModuleHeader.Title = CommonTypeConvert.ToString(rdr["NAME"]); SetPageTitle(Translation.GetTranslation.Term(".moduleList." + m_sMODULE) + " - " + ctlModuleHeader.Title); Utils.UpdateTracker(Page, m_sMODULE, gID, ctlModuleHeader.Title); AppendDetailViewFields(m_sMODULE + ".DetailView", tblMain, rdr, Page_Command); ctlDynamicButtons.AppendButtons(m_sMODULE + ".DetailView", Guid.Empty, rdr); } else { plcSubPanel.Visible = false; ctlDynamicButtons.AppendButtons(m_sMODULE + ".DetailView", Guid.Empty, null); ctlDynamicButtons.DisableAll(); ctlDynamicButtons.ErrorText = Translation.GetTranslation.Term("ACL.LBL_NO_ACCESS"); } } } else { ctlDynamicButtons.AppendButtons(m_sMODULE + ".DetailView", Guid.Empty, null); ctlDynamicButtons.DisableAll(); } } }
private void UpdateAccount(Guid gACCOUNT_ID, bool bUpdateBilling, bool bUpdateShipping) { string innerSql = ApplicationSQL.SQL["Invoices_EditView_223"].ToString(); var oQuery = new InlineQueryDBManager(); oQuery.CommandText = innerSql; oQuery.Add("@ID", SqlDbType.UniqueIdentifier, gACCOUNT_ID); using (SqlDataReader rdr = oQuery.ExecuteReader(CommandBehavior.SingleRow)) { if (rdr.Read()) { if (bUpdateBilling) { new DynamicControl(this, "BILLING_ACCOUNT_ID").ID = CommonTypeConvert.ToGuid(rdr["ID"]); new DynamicControl(this, "BILLING_ACCOUNT_NAME").Text = CommonTypeConvert.ToString(rdr["NAME"]); new DynamicControl(this, "BILLING_ADDRESS_STREET").Text = CommonTypeConvert.ToString(rdr["BILLING_ADDRESS_STREET"]); new DynamicControl(this, "BILLING_ADDRESS_CITY").Text = CommonTypeConvert.ToString(rdr["BILLING_ADDRESS_CITY"]); new DynamicControl(this, "BILLING_ADDRESS_STATE").Text = CommonTypeConvert.ToString(rdr["BILLING_ADDRESS_STATE"]); new DynamicControl(this, "BILLING_ADDRESS_POSTALCODE").Text = CommonTypeConvert.ToString(rdr["BILLING_ADDRESS_POSTALCODE"]); new DynamicControl(this, "BILLING_ADDRESS_COUNTRY").Text = CommonTypeConvert.ToString(rdr["BILLING_ADDRESS_COUNTRY"]); } if (bUpdateShipping) { new DynamicControl(this, "SHIPPING_ACCOUNT_ID").ID = CommonTypeConvert.ToGuid(rdr["ID"]); new DynamicControl(this, "SHIPPING_ACCOUNT_NAME").Text = CommonTypeConvert.ToString(rdr["NAME"]); new DynamicControl(this, "SHIPPING_ADDRESS_STREET").Text = CommonTypeConvert.ToString(rdr["SHIPPING_ADDRESS_STREET"]); new DynamicControl(this, "SHIPPING_ADDRESS_CITY").Text = CommonTypeConvert.ToString(rdr["SHIPPING_ADDRESS_CITY"]); new DynamicControl(this, "SHIPPING_ADDRESS_STATE").Text = CommonTypeConvert.ToString(rdr["SHIPPING_ADDRESS_STATE"]); new DynamicControl(this, "SHIPPING_ADDRESS_POSTALCODE").Text = CommonTypeConvert.ToString(rdr["SHIPPING_ADDRESS_POSTALCODE"]); new DynamicControl(this, "SHIPPING_ADDRESS_COUNTRY").Text = CommonTypeConvert.ToString(rdr["SHIPPING_ADDRESS_COUNTRY"]); } } } }
protected void Page_Load(object sender, EventArgs e) { SetPageTitle(Translation.GetTranslation.Term("ProductTypes.LBL_NAME")); if (!Visible) { return; } reqNAME.DataBind(); reqLIST_ORDER.DataBind(); gID = CommonTypeConvert.ToGuid(Request["ID"]); if (!IsPostBack) { ctlDynamicButtons.AppendButtons(m_sMODULE + ".EditView", Guid.Empty, null); if (!CommonTypeConvert.IsEmptyGuid(gID)) { var oQuery = new InlineQueryDBManager(); string innerSql = ApplicationSQL.SQL["Administration_ProductTypes_EditView"].ToString(); oQuery.CommandText = innerSql; oQuery.Add("@ID", SqlDbType.UniqueIdentifier, gID); using (SqlDataReader rdr = oQuery.ExecuteReader(CommandBehavior.SingleRow)) { if (rdr.Read()) { txtNAME.Text = CommonTypeConvert.ToString(rdr["NAME"]); ctlListHeader.Title = Translation.GetTranslation.Term("ProductTypes.LBL_NAME") + " " + txtNAME.Text; txtDESCRIPTION.Text = CommonTypeConvert.ToString(rdr["DESCRIPTION"]); txtLIST_ORDER.Text = CommonTypeConvert.ToString(rdr["LIST_ORDER"]); } } } else { var oQuery = new InlineQueryDBManager(); string innerSql = ApplicationSQL.SQL["ProductTypes_EditView_104"].ToString(); oQuery.CommandText = innerSql; txtLIST_ORDER.Text = (CommonTypeConvert.ToInteger(oQuery.ExecuteScalar()) + 1).ToString(); } } }
public static DataTable AssignedUser() { Cache Cache = HttpRuntime.Cache; bool bTeamFilter = !Security.IS_ADMIN && Config.enable_team_management(); string sCACHE_NAME = String.Empty; if (bTeamFilter) { sCACHE_NAME = "vwTEAMS_ASSIGNED_TO." + Security.USER_ID; } else { sCACHE_NAME = "vwUSERS_ASSIGNED_TO"; } var dt = Cache.Get(sCACHE_NAME) as DataTable; if (dt == null) { var oQuery = new InlineQueryDBManager(); string innerSql; if (bTeamFilter) { innerSql = ApplicationSQL.SQL["_code_CRMCache_256"].ToString(); } else { innerSql = "select ID " + ControlChars.CrLf + " , USER_NAME " + ControlChars.CrLf + " from vwUSERS_ASSIGNED_TO" + ControlChars.CrLf + " order by USER_NAME " + ControlChars.CrLf; } oQuery.CommandText = innerSql; if (bTeamFilter) { oQuery.Add("@MEMBERSHIP_USER_ID", SqlDbType.UniqueIdentifier, Security.USER_ID); } dt = oQuery.GetTable(); Cache.Insert(sCACHE_NAME, dt, null, DefaultCacheExpiration(), Cache.NoSlidingExpiration); } return(dt); }
public static DataTable TabMenuDescription() { HttpSessionState Session = HttpContext.Current.Session; var dt = Session["vwMODULES_DESCRIPTION_ByUser." + Security.USER_ID] as DataTable; if (dt == null) { dt = new DataTable(); if (Security.IsAuthenticated()) { var oQuery = new InlineQueryDBManager(); string innerSql = ApplicationSQL.SQL["_code_CRMCache_1939"].ToString(); oQuery.CommandText = innerSql; oQuery.Add("@USER_ID", SqlDbType.UniqueIdentifier, Security.USER_ID); dt = oQuery.GetTable(); Session["vwMODULES_DESCRIPTION_ByUser." + Security.USER_ID] = dt; } } return(dt); }
protected void BindGrid() { var oQuery = new InlineQueryDBManager(); string innerSql = ApplicationSQL.SQL["Products_relatedProducts_58"].ToString(); oQuery.CommandText = innerSql; oQuery.Add("@ID", SqlDbType.UniqueIdentifier, gID); gACCOUNT_ID = CommonTypeConvert.ToGuid(oQuery.ExecuteScalar()); innerSql = "select " + CommonTypeConvert.FormatSelectFields(arrSelectFields) + " from vwPRODUCTS_RELATED_PRODUCTS" + ControlChars.CrLf + " where 1 = 1 " + ControlChars.CrLf; oQuery.CommandText = innerSql; TypeConvert.AppendParameter(oQuery, gID, "PARENT_ID"); oQuery.CommandText += grdMain.OrderByClause("DATE_ENTERED", "desc"); DataTable dt = oQuery.GetTable(); vwMain = dt.DefaultView; grdMain.DataSource = vwMain; grdMain.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { SetPageTitle(Translation.GetTranslation.Term("ProductTypes.LBL_NAME")); if (!Visible) return; reqNAME.DataBind(); reqLIST_ORDER.DataBind(); gID = CommonTypeConvert.ToGuid(Request["ID"]); if (!IsPostBack) { ctlDynamicButtons.AppendButtons(m_sMODULE + ".EditView", Guid.Empty, null); if (!CommonTypeConvert.IsEmptyGuid(gID)) { var oQuery = new InlineQueryDBManager(); string innerSql = ApplicationSQL.SQL["Administration_ProductTypes_EditView"].ToString(); oQuery.CommandText = innerSql; oQuery.Add("@ID", SqlDbType.UniqueIdentifier, gID); using (SqlDataReader rdr = oQuery.ExecuteReader(CommandBehavior.SingleRow)) { if (rdr.Read()) { txtNAME.Text = CommonTypeConvert.ToString(rdr["NAME"]); ctlListHeader.Title = Translation.GetTranslation.Term("ProductTypes.LBL_NAME") + " " + txtNAME.Text; txtDESCRIPTION.Text = CommonTypeConvert.ToString(rdr["DESCRIPTION"]); txtLIST_ORDER.Text = CommonTypeConvert.ToString(rdr["LIST_ORDER"]); } } } else { var oQuery = new InlineQueryDBManager(); string innerSql = ApplicationSQL.SQL["ProductTypes_EditView_104"].ToString(); oQuery.CommandText = innerSql; txtLIST_ORDER.Text = (CommonTypeConvert.ToInteger(oQuery.ExecuteScalar()) + 1).ToString(); } } }
public static DataTable ImportModules() { Cache Cache = HttpRuntime.Cache; var dt = Cache.Get("vwMODULES_Import_" + Security.USER_ID) as DataTable; if (dt == null) { var oQuery = new InlineQueryDBManager(); string innerSql = ApplicationSQL.SQL["_code_RMCache_392"].ToString(); oQuery.CommandText = innerSql; oQuery.Add("@USER_ID", SqlDbType.UniqueIdentifier, Security.USER_ID); dt = oQuery.GetTable(); foreach (DataRow row in dt.Rows) { row["DISPLAY_NAME"] = Translation.GetTranslation.Term(CommonTypeConvert.ToString(row["DISPLAY_NAME"])); } Cache.Insert("vwMODULES_Import_" + Security.USER_ID, dt, null, DefaultCacheExpiration(), Cache.NoSlidingExpiration); } return(dt); }
public static DataTable ReportingModules() { Cache Cache = HttpRuntime.Cache; var dt = Cache.Get("vwMODULES_Reporting_" + Security.USER_ID) as DataTable; if (dt == null) { var oQuery = new InlineQueryDBManager(); string innerSql = "select MODULE_NAME " + ControlChars.CrLf + " , DISPLAY_NAME " + ControlChars.CrLf + " from vwMODULES_Reporting " + ControlChars.CrLf + " where USER_ID = @USER_ID " + ControlChars.CrLf + " or USER_ID is null " + ControlChars.CrLf; oQuery.CommandText = innerSql; oQuery.Add("@USER_ID", SqlDbType.UniqueIdentifier, Security.USER_ID); dt = oQuery.GetTable(); foreach (DataRow row in dt.Rows) { row["DISPLAY_NAME"] = Translation.GetTranslation.Term(CommonTypeConvert.ToString(row["DISPLAY_NAME"])); } Cache.Insert("vwMODULES_Reporting_" + Security.USER_ID, dt, null, DefaultCacheExpiration(), Cache.NoSlidingExpiration); } return dt; }
public static DataTable ImportColumns(string sMODULE_NAME) { Cache Cache = HttpRuntime.Cache; var dt = Cache.Get("vwSqlColumns_Import." + sMODULE_NAME) as DataTable; if (dt == null) { string sTABLE_NAME = CommonTypeConvert.ToString(HttpContext.Current.Application["Modules." + sMODULE_NAME + ".TableName"]); if (CommonTypeConvert.IsEmptyString(sTABLE_NAME)) sTABLE_NAME = sMODULE_NAME.ToUpper(); var oQuery = new InlineQueryDBManager(); dt = new DataTable(); dt.Columns.Add("ColumnName", Type.GetType("System.String")); dt.Columns.Add("NAME", Type.GetType("System.String")); dt.Columns.Add("DISPLAY_NAME", Type.GetType("System.String")); dt.Columns.Add("ColumnType", Type.GetType("System.String")); dt.Columns.Add("Size", Type.GetType("System.Int32")); dt.Columns.Add("Scale", Type.GetType("System.Int32")); dt.Columns.Add("Precision", Type.GetType("System.Int32")); dt.Columns.Add("colid", Type.GetType("System.Int32")); dt.Columns.Add("CustomField", Type.GetType("System.Boolean")); { oQuery = null; try { oQuery = InlineQueryDBManager.Factory("stp_Zpro_" + sTABLE_NAME + "_Import"); if (oQuery == null) throw new Exception(); } catch { oQuery = InlineQueryDBManager.Factory("stp_Zpro_" + sTABLE_NAME + "_Update"); } for (int i = 0; i < oQuery.Count; i++) { SqlParameter par = oQuery[i]; DataRow row = dt.NewRow(); dt.Rows.Add(row); row["ColumnName"] = par.ParameterName; row["NAME"] = CommonTypeConvert.ExtractDbName(par.ParameterName); row["DISPLAY_NAME"] = row["NAME"]; row["ColumnType"] = par.DbType.ToString(); row["Size"] = par.Size; row["Scale"] = par.Scale; row["Precision"] = par.Precision; row["colid"] = i; row["CustomField"] = false; } string sSQL; if (Config.enable_team_management()) { bool bModuleIsTeamed = CommonTypeConvert.ToBoolean( HttpContext.Current.Application["Modules." + sMODULE_NAME + ".Teamed"]); DataRow row = dt.NewRow(); row = dt.NewRow(); row["ColumnName"] = "@TEAM_NAME"; row["NAME"] = "TEAM_NAME"; row["DISPLAY_NAME"] = "TEAM_NAME"; row["ColumnType"] = "string"; row["Size"] = 128; row["colid"] = dt.Rows.Count; row["CustomField"] = false; dt.Rows.Add(row); } sSQL = ApplicationSQL.SQL["_code_CRMCache_629"]; oQuery = new InlineQueryDBManager(); oQuery.CommandText = sSQL; oQuery.Add("@OBJECTNAME", SqlDbType.NVarChar, sTABLE_NAME + "_CSTM"); DataTable dtCSTM = oQuery.GetTable(); foreach (DataRow rowCSTM in dtCSTM.Rows) { DataRow row = dt.NewRow(); row["ColumnName"] = CommonTypeConvert.ToString(rowCSTM["ColumnName"]); row["NAME"] = CommonTypeConvert.ToString(rowCSTM["ColumnName"]); row["DISPLAY_NAME"] = CommonTypeConvert.ToString(rowCSTM["ColumnName"]); row["ColumnType"] = CommonTypeConvert.ToString(rowCSTM["CsType"]); row["Size"] = CommonTypeConvert.ToInteger(rowCSTM["length"]); row["colid"] = dt.Rows.Count; row["CustomField"] = true; dt.Rows.Add(row); } Cache.Insert("vwSqlColumns_Import." + sMODULE_NAME, dt, null, DefaultCacheExpiration(), Cache.NoSlidingExpiration); } } return dt; //return new DataTable(); }
public static DataTable ImportModules() { Cache Cache = HttpRuntime.Cache; var dt = Cache.Get("vwMODULES_Import_" + Security.USER_ID) as DataTable; if (dt == null) { var oQuery = new InlineQueryDBManager(); string innerSql = ApplicationSQL.SQL["_code_RMCache_392"].ToString(); oQuery.CommandText = innerSql; oQuery.Add("@USER_ID", SqlDbType.UniqueIdentifier, Security.USER_ID); dt = oQuery.GetTable(); foreach (DataRow row in dt.Rows) { row["DISPLAY_NAME"] = Translation.GetTranslation.Term(CommonTypeConvert.ToString(row["DISPLAY_NAME"])); } Cache.Insert("vwMODULES_Import_" + Security.USER_ID, dt, null, DefaultCacheExpiration(), Cache.NoSlidingExpiration); } return dt; }
public static DataTable List(string sModuleName, string sListName) { Cache Cache = HttpRuntime.Cache; var dt = Cache.Get(Translation.GetTranslation.NAME + "." + sListName) as DataTable; if (dt == null) { var oQuery = new InlineQueryDBManager(); string innerSql = ApplicationSQL.SQL["_code_CRMCache_177"].ToString(); oQuery.CommandText = innerSql; oQuery.Add("@MODULE_NAME", SqlDbType.NVarChar, sModuleName.ToLower()); oQuery.Add("@LIST_NAME", SqlDbType.NVarChar, sListName.ToLower()); oQuery.Add("@LANG", SqlDbType.NVarChar, Translation.GetTranslation.NAME.ToLower()); dt = oQuery.GetTable(); Cache.Insert(Translation.GetTranslation.NAME + "." + sListName, dt, null, DefaultCacheExpiration(), Cache.NoSlidingExpiration); } return dt; }
public static DataTable MobileMenu() { HttpSessionState Session = HttpContext.Current.Session; var dt = Session["vwMODULES_MobileMenu_ByUser." + Security.USER_ID] as DataTable; if (dt == null) { var oQuery = new InlineQueryDBManager(); string innerSql = ApplicationSQL.SQL["_code_CRMCache_1252"].ToString(); oQuery.CommandText = innerSql; oQuery.Add("@USER_ID", SqlDbType.UniqueIdentifier, Security.USER_ID); dt = oQuery.GetTable(); Session["vwMODULES_MobileMenu_ByUser." + Security.USER_ID] = dt; } return dt; }
public static DataTable FieldsMetaData_UnvalidatedCustomFields(string sTABLE_NAME) { Cache Cache = HttpRuntime.Cache; var dt = Cache.Get("vwFIELDS_META_DATA_Unvalidated." + sTABLE_NAME) as DataTable; if (dt == null) { var oQuery = new InlineQueryDBManager(); string innerSql = ApplicationSQL.SQL["_code_CRMCache_1694"].ToString(); oQuery.CommandText = innerSql; oQuery.Add("@TABLE_NAME", SqlDbType.VarChar, sTABLE_NAME + "_CSTM"); dt = oQuery.GetTable(); Cache.Insert("vwFIELDS_META_DATA_Unvalidated." + sTABLE_NAME, dt, null, DefaultCacheExpiration(), Cache.NoSlidingExpiration); } return dt; }
public static DataTable ImportColumns(string sMODULE_NAME) { Cache Cache = HttpRuntime.Cache; var dt = Cache.Get("vwSqlColumns_Import." + sMODULE_NAME) as DataTable; if (dt == null) { string sTABLE_NAME = CommonTypeConvert.ToString(HttpContext.Current.Application["Modules." + sMODULE_NAME + ".TableName"]); if (CommonTypeConvert.IsEmptyString(sTABLE_NAME)) { sTABLE_NAME = sMODULE_NAME.ToUpper(); } var oQuery = new InlineQueryDBManager(); dt = new DataTable(); dt.Columns.Add("ColumnName", Type.GetType("System.String")); dt.Columns.Add("NAME", Type.GetType("System.String")); dt.Columns.Add("DISPLAY_NAME", Type.GetType("System.String")); dt.Columns.Add("ColumnType", Type.GetType("System.String")); dt.Columns.Add("Size", Type.GetType("System.Int32")); dt.Columns.Add("Scale", Type.GetType("System.Int32")); dt.Columns.Add("Precision", Type.GetType("System.Int32")); dt.Columns.Add("colid", Type.GetType("System.Int32")); dt.Columns.Add("CustomField", Type.GetType("System.Boolean")); { oQuery = null; try { oQuery = InlineQueryDBManager.Factory("stp_Zpro_" + sTABLE_NAME + "_Import"); if (oQuery == null) { throw new Exception(); } } catch { oQuery = InlineQueryDBManager.Factory("stp_Zpro_" + sTABLE_NAME + "_Update"); } for (int i = 0; i < oQuery.Count; i++) { SqlParameter par = oQuery[i]; DataRow row = dt.NewRow(); dt.Rows.Add(row); row["ColumnName"] = par.ParameterName; row["NAME"] = CommonTypeConvert.ExtractDbName(par.ParameterName); row["DISPLAY_NAME"] = row["NAME"]; row["ColumnType"] = par.DbType.ToString(); row["Size"] = par.Size; row["Scale"] = par.Scale; row["Precision"] = par.Precision; row["colid"] = i; row["CustomField"] = false; } string sSQL; if (Config.enable_team_management()) { bool bModuleIsTeamed = CommonTypeConvert.ToBoolean( HttpContext.Current.Application["Modules." + sMODULE_NAME + ".Teamed"]); DataRow row = dt.NewRow(); row = dt.NewRow(); row["ColumnName"] = "@TEAM_NAME"; row["NAME"] = "TEAM_NAME"; row["DISPLAY_NAME"] = "TEAM_NAME"; row["ColumnType"] = "string"; row["Size"] = 128; row["colid"] = dt.Rows.Count; row["CustomField"] = false; dt.Rows.Add(row); } sSQL = ApplicationSQL.SQL["_code_CRMCache_629"]; oQuery = new InlineQueryDBManager(); oQuery.CommandText = sSQL; oQuery.Add("@OBJECTNAME", SqlDbType.NVarChar, sTABLE_NAME + "_CSTM"); DataTable dtCSTM = oQuery.GetTable(); foreach (DataRow rowCSTM in dtCSTM.Rows) { DataRow row = dt.NewRow(); row["ColumnName"] = CommonTypeConvert.ToString(rowCSTM["ColumnName"]); row["NAME"] = CommonTypeConvert.ToString(rowCSTM["ColumnName"]); row["DISPLAY_NAME"] = CommonTypeConvert.ToString(rowCSTM["ColumnName"]); row["ColumnType"] = CommonTypeConvert.ToString(rowCSTM["CsType"]); row["Size"] = CommonTypeConvert.ToInteger(rowCSTM["length"]); row["colid"] = dt.Rows.Count; row["CustomField"] = true; dt.Rows.Add(row); } Cache.Insert("vwSqlColumns_Import." + sMODULE_NAME, dt, null, DefaultCacheExpiration(), Cache.NoSlidingExpiration); } } return(dt); //return new DataTable(); }
public static DataTable FieldsMetaData_Validated(string sMODULE) { Cache Cache = HttpRuntime.Cache; var dt = Cache.Get("vwFIELDS_META_DATA_Validated." + sMODULE) as DataTable; if (dt == null) { var oQuery = new InlineQueryDBManager(); string innerSql = ApplicationSQL.SQL["_code_CRMCache_1741"].ToString(); oQuery.CommandText = innerSql; oQuery.Add("@CUSTOM_MODULE", SqlDbType.VarChar, sMODULE); dt = oQuery.GetTable(); Cache.Insert("vwFIELDS_META_DATA_Validated." + sMODULE, dt, null, DefaultCacheExpiration(), Cache.NoSlidingExpiration); } return dt; }
public static DataTable SavedSearch(string sMODULE) { HttpSessionState Session = HttpContext.Current.Session; var dt = Session["vwSAVED_SEARCH." + sMODULE] as DataTable; if (dt == null) { dt = new DataTable(); if (Security.IsAuthenticated()) { var oQuery = new InlineQueryDBManager(); string innerSql = "select ID " + ControlChars.CrLf + " , NAME " + ControlChars.CrLf + " , CONTENTS " + ControlChars.CrLf + " from vwSAVED_SEARCH " + ControlChars.CrLf + " where ASSIGNED_USER_ID = @USER_ID" + ControlChars.CrLf + " and SEARCH_MODULE = @MODULE " + ControlChars.CrLf + " order by NAME " + ControlChars.CrLf; oQuery.CommandText = innerSql; oQuery.Add("@USER_ID", SqlDbType.UniqueIdentifier, Security.USER_ID); oQuery.Add("@MODULE", SqlDbType.VarChar, sMODULE); dt = oQuery.GetTable(); Session["vwSAVED_SEARCH." + sMODULE] = dt; } } return dt; }
public static DataTable TabMenuDescription() { HttpSessionState Session = HttpContext.Current.Session; var dt = Session["vwMODULES_DESCRIPTION_ByUser." + Security.USER_ID] as DataTable; if (dt == null) { dt = new DataTable(); if (Security.IsAuthenticated()) { var oQuery = new InlineQueryDBManager(); string innerSql = ApplicationSQL.SQL["_code_CRMCache_1939"].ToString(); oQuery.CommandText = innerSql; oQuery.Add("@USER_ID", SqlDbType.UniqueIdentifier, Security.USER_ID); dt = oQuery.GetTable(); Session["vwMODULES_DESCRIPTION_ByUser." + Security.USER_ID] = dt; } } return dt; }
public static DataTable SearchColumns(string sVIEW_NAME) { Cache Cache = HttpRuntime.Cache; var dt = Cache.Get("vwSqlColumns_Searching." + sVIEW_NAME) as DataTable; if (dt == null) { var oQuery = new InlineQueryDBManager(); string innerSql = ApplicationSQL.SQL["_code_CRMCache_1926"].ToString(); oQuery.CommandText = innerSql; oQuery.Add("@OBJECTNAME", SqlDbType.VarChar, sVIEW_NAME); dt = oQuery.GetTable(); Cache.Insert("vwSqlColumns_Searching." + sVIEW_NAME, dt, null, DefaultCacheExpiration(), Cache.NoSlidingExpiration); } return dt; }
public static DataTable Shortcuts(string sMODULE_NAME) { var dt = HttpContext.Current.Session["vwSHORTCUTS_Menu_ByUser." + sMODULE_NAME + "." + Security.USER_ID] as DataTable; if (dt == null) { dt = new DataTable(); if (Security.IsAuthenticated()) { var oQuery = new InlineQueryDBManager(); string innerSql = ApplicationSQL.SQL["_code_CRMCache_1304"].ToString(); oQuery.CommandText = innerSql; oQuery.Add("@MODULE_NAME", SqlDbType.VarChar, 100, sMODULE_NAME); oQuery.Add("@USER_ID", SqlDbType.UniqueIdentifier, Security.USER_ID); dt = oQuery.GetTable(); HttpContext.Current.Session["vwSHORTCUTS_Menu_ByUser." + sMODULE_NAME + "." + Security.USER_ID] = dt; } } return dt; }
public static string ReportingFilterColumnsListName(string sMODULE_NAME, string sDATA_FIELD) { Cache Cache = HttpRuntime.Cache; var sLIST_NAME = Cache.Get("vwSqlColumns_ListName." + sMODULE_NAME + "." + sDATA_FIELD) as string; if (sLIST_NAME == null) { var oQuery = new InlineQueryDBManager(); string innerSql = ApplicationSQL.SQL["_code_CRMCache_529"].ToString(); oQuery.CommandText = innerSql; oQuery.Add("@OBJECTNAME", SqlDbType.VarChar, 100, "vw" + sMODULE_NAME); oQuery.Add("@DATA_FIELD", SqlDbType.VarChar, 100, sDATA_FIELD); sLIST_NAME = CommonTypeConvert.ToString(oQuery.ExecuteScalar()); Cache.Insert("vwSqlColumns_ListName." + sMODULE_NAME + "." + sDATA_FIELD, sLIST_NAME, null, DefaultCacheExpiration(), Cache.NoSlidingExpiration); } return sLIST_NAME; }
public static DataTable AssignedUser() { Cache Cache = HttpRuntime.Cache; bool bTeamFilter = !Security.IS_ADMIN && Config.enable_team_management(); string sCACHE_NAME = String.Empty; if (bTeamFilter) sCACHE_NAME = "vwTEAMS_ASSIGNED_TO." + Security.USER_ID; else sCACHE_NAME = "vwUSERS_ASSIGNED_TO"; var dt = Cache.Get(sCACHE_NAME) as DataTable; if (dt == null) { var oQuery = new InlineQueryDBManager(); string innerSql; if (bTeamFilter) { innerSql = ApplicationSQL.SQL["_code_CRMCache_256"].ToString(); } else { innerSql = "select ID " + ControlChars.CrLf + " , USER_NAME " + ControlChars.CrLf + " from vwUSERS_ASSIGNED_TO" + ControlChars.CrLf + " order by USER_NAME " + ControlChars.CrLf; } oQuery.CommandText = innerSql; if (bTeamFilter) oQuery.Add("@MEMBERSHIP_USER_ID", SqlDbType.UniqueIdentifier, Security.USER_ID); dt = oQuery.GetTable(); Cache.Insert(sCACHE_NAME, dt, null, DefaultCacheExpiration(), Cache.NoSlidingExpiration); } return dt; }
protected void Page_Load(object sender, EventArgs e) { SetPageTitle(Translation.GetTranslation.Term(".moduleList." + m_sMODULE)); Visible = (Security.GetUserAccess(m_sMODULE, "edit") >= 0); if (!Visible) return; gID = CommonTypeConvert.ToGuid(Request["ID"]); if (!IsPostBack) { ctlDynamicButtons.AppendButtons(m_sMODULE + ".EditView", Guid.Empty, null); Guid gDuplicateID = CommonTypeConvert.ToGuid(Request["DuplicateID"]); if (!CommonTypeConvert.IsEmptyGuid(gID) || !CommonTypeConvert.IsEmptyGuid(gDuplicateID)) { var oQuery = new InlineQueryDBManager(); string innerSql = ApplicationSQL.SQL["Administration_ProductTemplates_EditView"].ToString(); oQuery.CommandText = innerSql; if (!CommonTypeConvert.IsEmptyGuid(gDuplicateID)) { oQuery.Add("@ID", SqlDbType.UniqueIdentifier, gDuplicateID); gID = Guid.Empty; } else { oQuery.Add("@ID", SqlDbType.UniqueIdentifier, gID); } using (SqlDataReader rdr = oQuery.ExecuteReader(CommandBehavior.SingleRow)) { if (rdr.Read()) { ctlModuleHeader.Title = CommonTypeConvert.ToString(rdr["NAME"]); SetPageTitle(Translation.GetTranslation.Term(".moduleList." + m_sMODULE) + " - " + ctlModuleHeader.Title); Utils.UpdateTracker(Page, m_sMODULE, gID, ctlModuleHeader.Title); ViewState["ctlModuleHeader.Title"] = ctlModuleHeader.Title; AppendEditViewFields(m_sMODULE + ".EditView", tblMain, rdr); } } } else { AppendEditViewFields(m_sMODULE + ".EditView", tblMain, null); } } else { ctlModuleHeader.Title = CommonTypeConvert.ToString(ViewState["ctlModuleHeader.Title"]); SetPageTitle(Translation.GetTranslation.Term(".moduleList." + m_sMODULE) + " - " + ctlModuleHeader.Title); } }