protected void Page_Load(object sender, EventArgs e) { SetPageTitle(Translation.GetTranslation.Term(m_sMODULE + ".LBL_LIST_FORM_TITLE")); var oQuery = new InlineQueryDBManager(); string innerSql = ApplicationSQL.SQL["Administration_ProductCategories_Popup"].ToString(); oQuery.CommandText = innerSql; ctlSearch.SqlSearchClause(oQuery); DataTable dt = oQuery.GetTable(); vwMain = dt.DefaultView; grdMain.DataSource = vwMain; if (!IsPostBack) { if (String.IsNullOrEmpty(grdMain.SortColumn)) { grdMain.SortColumn = "NAME"; grdMain.SortOrder = "asc"; } grdMain.ApplySort(); grdMain.DataBind(); } }
public string[] ItemNameList(string prefixText, int count) { var arrItems = new string[0]; if (Security.USER_ID == Guid.Empty) { throw (new Exception("Authentication required")); } var oQuery = new InlineQueryDBManager(); oQuery.CommandText = ApplicationSQL.SQL["ProductCatalog_AutoComplete_212"].ToString(); CRMSecurity.Filter(oQuery, "ProductTemplates", "list"); TypeConvert.AppendParameter(oQuery, prefixText, CommonTypeConvert.SqlFilterMode.StartsWith, "NAME"); oQuery.CommandText += " order by NAME" + ControlChars.CrLf; using (DataTable dt = oQuery.GetTable()) { arrItems = new string[dt.Rows.Count]; for (int i = 0; i < dt.Rows.Count; i++) { arrItems[i] = CommonTypeConvert.ToString(dt.Rows[i]["NAME"]); } } return(arrItems); }
protected void PAYMENT_TYPE_Changed(object sender, EventArgs e) { var PAYMENT_TYPE = tblMain.FindControl("PAYMENT_TYPE") as DropDownList; if (PAYMENT_TYPE != null) { bool bCreditCard = PAYMENT_TYPE.SelectedValue == "Credit Card"; ctlDynamicButtons.ShowButton("Charge", bCreditCard); new DynamicControl(this, "CREDIT_CARD_ID_LABEL").Visible = bCreditCard; new DynamicControl(this, "CREDIT_CARD_NAME").Visible = bCreditCard; new DynamicControl(this, "CREDIT_CARD_ID_btnChange").Visible = bCreditCard; new DynamicControl(this, "CREDIT_CARD_ID_btnClear").Visible = bCreditCard; if (bCreditCard && CommonTypeConvert.IsEmptyGuid(new DynamicControl(this, "CREDIT_CARD_ID").ID)) { var oQuery = new InlineQueryDBManager(); string innerSql = ApplicationSQL.SQL["Payments_EditView_214"].ToString(); oQuery.CommandText = innerSql; Guid gACCOUNT_ID = new DynamicControl(this, "ACCOUNT_ID").ID; TypeConvert.AppendParameter(oQuery, gACCOUNT_ID, "ACCOUNT_ID", false); using (SqlDataReader rdr = oQuery.ExecuteReader(CommandBehavior.SingleRow)) { if (rdr.Read()) { new DynamicControl(this, "CREDIT_CARD_ID").ID = CommonTypeConvert.ToGuid(rdr["ID"]); new DynamicControl(this, "CREDIT_CARD_NAME").Text = CommonTypeConvert.ToString(rdr["NAME"]); } } } } }
protected void btnProductChanged_Clicked(object sender, EventArgs e) { var oQuery = new InlineQueryDBManager(); string innerSql = ApplicationSQL.SQL["Products_EditView_161"].ToString(); oQuery.CommandText = innerSql; Guid gPRODUCT_TEMPLATE_ID = new DynamicControl(this, "PRODUCT_TEMPLATE_ID").ID; TypeConvert.AppendParameter(oQuery, gPRODUCT_TEMPLATE_ID, "ID", false); 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; CRMDynamic.SetEditViewFields(this, m_sMODULE + ".EditView", rdr); CRMDynamic.SetEditViewFields(this, m_sMODULE + ".CostView", rdr); CRMDynamic.SetEditViewFields(this, m_sMODULE + ".MftView", rdr); var txtNAME = FindControl("NAME") as TextBox; if (txtNAME != null) txtNAME.ReadOnly = false; } } }
public Invoice GetInvoiceByName(Guid gCURRENCY_ID, string sNAME) { var item = new Invoice(); { if (Security.USER_ID == Guid.Empty) throw (new Exception("Authentication required")); var oQuery = new InlineQueryDBManager(); string innerSql = ApplicationSQL.SQL["Invoices_AutoComplete_50"].ToString(); oQuery.CommandText = innerSql; CRMSecurity.Filter(oQuery, "Invoices", "list"); TypeConvert.AppendParameter(oQuery, sNAME, CommonTypeConvert.SqlFilterMode.StartsWith, "NAME"); using (SqlDataReader rdr = oQuery.ExecuteReader(CommandBehavior.SingleRow)) { if (rdr.Read()) { item.ID = CommonTypeConvert.ToGuid(rdr["ID"]); item.NAME = CommonTypeConvert.ToString(rdr["NAME"]); item.AMOUNT_DUE = CommonTypeConvert.ToDecimal(rdr["AMOUNT_DUE"]); item.AMOUNT_DUE_USDOLLAR = CommonTypeConvert.ToDecimal(rdr["AMOUNT_DUE_USDOLLAR"]); if (gCURRENCY_ID != CommonTypeConvert.ToGuid(rdr["CURRENCY_ID"])) { Currency C10n = Currency.CreateCurrency(gCURRENCY_ID); item.AMOUNT_DUE = Currency.GetCurrency.ToCurrency(item.AMOUNT_DUE_USDOLLAR); } } } if (CommonTypeConvert.IsEmptyGuid(item.ID)) throw (new Exception("Item not found")); } return item; }
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 btnProductChanged_Clicked(object sender, EventArgs e) { var oQuery = new InlineQueryDBManager(); string innerSql = ApplicationSQL.SQL["Products_EditView_161"].ToString(); oQuery.CommandText = innerSql; Guid gPRODUCT_TEMPLATE_ID = new DynamicControl(this, "PRODUCT_TEMPLATE_ID").ID; TypeConvert.AppendParameter(oQuery, gPRODUCT_TEMPLATE_ID, "ID", false); 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; CRMDynamic.SetEditViewFields(this, m_sMODULE + ".EditView", rdr); CRMDynamic.SetEditViewFields(this, m_sMODULE + ".CostView", rdr); CRMDynamic.SetEditViewFields(this, m_sMODULE + ".MftView", rdr); var txtNAME = FindControl("NAME") as TextBox; if (txtNAME != null) { txtNAME.ReadOnly = false; } } } }
protected void Page_Load(object sender, EventArgs e) { SetPageTitle(Translation.GetTranslation.Term(m_sMODULE + ".LBL_LIST_FORM_TITLE")); var oQuery = new InlineQueryDBManager(); string innerSql = " from vwPRODUCTS_List" + ControlChars.CrLf; oQuery.CommandText = innerSql; CRMSecurity.Filter(oQuery, m_sMODULE, "list"); grdMain.OrderByClause("NAME", "asc"); ctlSearchView.SqlSearchClause(oQuery); Guid gACCOUNT_ID = CommonTypeConvert.ToGuid(Request["ACCOUNT_ID"]); if (!CommonTypeConvert.IsEmptyGuid(gACCOUNT_ID)) { TypeConvert.AppendParameter(oQuery, gACCOUNT_ID, "ACCOUNT_ID"); } oQuery.CommandText = "select " + CommonTypeConvert.FormatSelectFields(arrSelectFields) + oQuery.CommandText + grdMain.OrderByClause(); DataTable dt = oQuery.GetTable(); vwMain = dt.DefaultView; grdMain.DataSource = vwMain; if (!IsPostBack) { grdMain.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { SetPageTitle(Translation.GetTranslation.Term("ProductTemplates.LBL_LIST_FORM_TITLE")); var oQuery = new InlineQueryDBManager(); string innerSql = " from vwPRODUCT_TEMPLATES_List" + ControlChars.CrLf + " where 1 = 1 " + ControlChars.CrLf; oQuery.CommandText = innerSql; if (!IsPostBack) { new DynamicControl(ctlSearchView, "NAME").Text = CommonTypeConvert.ToString(Request["NAME"]); } grdMain.OrderByClause("NAME", "asc"); ctlSearchView.SqlSearchClause(oQuery); oQuery.CommandText = "select " + CommonTypeConvert.FormatSelectFields(arrSelectFields) + oQuery.CommandText + grdMain.OrderByClause(); DataTable dt = oQuery.GetTable(); vwMain = dt.DefaultView; grdMain.DataSource = vwMain; if (!IsPostBack) { grdMain.DataBind(); } }
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); } } } }
protected void Page_Load(object sender, EventArgs e) { SetPageTitle(Translation.GetTranslation.Term(m_sMODULE + ".LBL_LIST_FORM_TITLE")); string innerSql = " from vwINVOICES_List" + ControlChars.CrLf; var oQuery = new InlineQueryDBManager(); oQuery.CommandText = innerSql; CRMSecurity.Filter(oQuery, m_sMODULE, "list"); grdMain.OrderByClause("NAME", "asc"); ctlSearchView.SqlSearchClause(oQuery); Guid gACCOUNT_ID = CommonTypeConvert.ToGuid(Request["ACCOUNT_ID"]); if (!CommonTypeConvert.IsEmptyGuid(gACCOUNT_ID)) { TypeConvert.AppendParameter(oQuery, gACCOUNT_ID, "ACCOUNT_ID"); } oQuery.CommandText = "select " + CommonTypeConvert.FormatSelectFields(arrSelectFields) + oQuery.CommandText + grdMain.OrderByClause(); using (DataTable dt = oQuery.GetTable()) { vwMain = dt.DefaultView; grdMain.DataSource = vwMain; if (!IsPostBack) { grdMain.DataBind(); } } }
protected void Page_Command(object sender, CommandEventArgs e) { if (e.CommandName == "Refund") { Guid gPAYMENTS_TRANSACTION_ID = CommonTypeConvert.ToGuid(e.CommandArgument); var oQuery = new InlineQueryDBManager(); string innerSql = ApplicationSQL.SQL["PaymentTransactions"].ToString(); oQuery.CommandText = innerSql; TypeConvert.AppendParameter(oQuery, gPAYMENTS_TRANSACTION_ID, "ID", false); using (SqlDataReader rdr = oQuery.ExecuteReader(CommandBehavior.SingleRow)) { if (rdr.Read()) { Guid gCURRENCY_ID = CommonTypeConvert.ToGuid(rdr["CURRENCY_ID"]); Guid gACCOUNT_ID = CommonTypeConvert.ToGuid(rdr["ACCOUNT_ID"]); Guid gCREDIT_CARD_ID = CommonTypeConvert.ToGuid(rdr["CREDIT_CARD_ID"]); string sINVOICE_NUMBER = CommonTypeConvert.ToString(rdr["INVOICE_NUMBER"]); Decimal dAMOUNT = CommonTypeConvert.ToDecimal(rdr["AMOUNT"]); string sDESCRIPTION = CommonTypeConvert.ToString(rdr["DESCRIPTION"]); string sTRANSACTION_NUMBER = CommonTypeConvert.ToString(rdr["TRANSACTION_NUMBER"]); //CRM.Common.Charge.CC.Refund(Application, gID, gCURRENCY_ID, gACCOUNT_ID, gCREDIT_CARD_ID, Request.UserHostAddress, sINVOICE_NUMBER, sDESCRIPTION, dAMOUNT, sTRANSACTION_NUMBER); BindGrid(); } } } }
protected void Page_Command(object sender, CommandEventArgs e) { if (e.CommandName == "Refund") { Guid gPAYMENTS_TRANSACTION_ID = CommonTypeConvert.ToGuid(e.CommandArgument); var oQuery = new InlineQueryDBManager(); string innerSql = ApplicationSQL.SQL["PaymentTransactions"].ToString(); oQuery.CommandText = innerSql; TypeConvert.AppendParameter(oQuery, gPAYMENTS_TRANSACTION_ID, "ID", false); using (SqlDataReader rdr = oQuery.ExecuteReader(CommandBehavior.SingleRow)) { if (rdr.Read()) { Guid gCURRENCY_ID = CommonTypeConvert.ToGuid(rdr["CURRENCY_ID"]); Guid gACCOUNT_ID = CommonTypeConvert.ToGuid(rdr["ACCOUNT_ID"]); Guid gCREDIT_CARD_ID = CommonTypeConvert.ToGuid(rdr["CREDIT_CARD_ID"]); string sINVOICE_NUMBER = CommonTypeConvert.ToString(rdr["INVOICE_NUMBER"]); Decimal dAMOUNT = CommonTypeConvert.ToDecimal(rdr["AMOUNT"]); string sDESCRIPTION = CommonTypeConvert.ToString(rdr["DESCRIPTION"]); string sTRANSACTION_NUMBER = CommonTypeConvert.ToString(rdr["TRANSACTION_NUMBER"]); //CRM.Common.Charge.CC.Refund(Application, gID, gCURRENCY_ID, gACCOUNT_ID, gCREDIT_CARD_ID, Request.UserHostAddress, sINVOICE_NUMBER, sDESCRIPTION, dAMOUNT, sTRANSACTION_NUMBER); BindGrid(); } } } }
protected void Page_Load(object sender, EventArgs e) { SetPageTitle(Translation.GetTranslation.Term("ProductCategories.LBL_LIST_FORM_TITLE")); Visible = Security.IS_ADMIN; Visible = Security.ADMIN_TYPE == 0 ? true : false; if (!Visible) { return; } var oQuery = new InlineQueryDBManager(); string innerSql = ApplicationSQL.SQL["Administration_ProductCategories_ListView"].ToString(); oQuery.CommandText = innerSql; DataTable dt = oQuery.GetTable(); vwMain = dt.DefaultView; grdMain.DataSource = vwMain; if (!IsPostBack) { grdMain.SortColumn = "LIST_ORDER"; grdMain.SortOrder = "asc"; grdMain.ApplySort(); grdMain.DataBind(); } }
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); }
protected void Page_Command(object sender, CommandEventArgs e) { if (e.CommandName == "Search") { grdMain.CurrentPageIndex = 0; grdMain.DataBind(); } else if (e.CommandName == "SortGrid") { grdMain.SetSortFields(e.CommandArgument as string[]); arrSelectFields.Add(grdMain.SortColumn); } else if (e.CommandName == "MassUpdate") { string[] arrID = Request.Form.GetValues("chkMain"); if (arrID != null) { Stack stk = Utils.FilterByACL_Stack(m_sMODULE, "edit", arrID, "PRODUCTS"); if (stk.Count > 0) { var oQuery = new InlineQueryDBManager(); while (stk.Count > 0) { string sIDs = Utils.BuildMassIDs(stk); } Response.Redirect("Index.aspx"); } } } else if (e.CommandName == "MassDelete") { string[] arrID = Request.Form.GetValues("chkMain"); if (arrID != null) { Stack stk = Utils.FilterByACL_Stack(m_sMODULE, "delete", arrID, "PRODUCTS"); if (stk.Count > 0) { while (stk.Count > 0) { string sIDs = Utils.BuildMassIDs(stk); CommonProcedure.ProductMassDelete(sIDs); } Response.Redirect("Index.aspx"); } } } else if (e.CommandName == "Export") { int nACLACCESS = Security.GetUserAccess(m_sMODULE, "export"); if (nACLACCESS >= 0) { if (nACLACCESS == ACL_ACCESS.OWNER) vwMain.RowFilter = "ASSIGNED_USER_ID = '" + Security.USER_ID + "'"; string[] arrID = Request.Form.GetValues("chkMain"); CRMExport.Export(vwMain, m_sMODULE, ctlExportHeader.ExportFormat, ctlExportHeader.ExportRange, grdMain.CurrentPageIndex, grdMain.PageSize, arrID); } } }
protected void BindGrid() { string innerSql = "select " + CommonTypeConvert.FormatSelectFields(arrSelectFields) + " from vwINVOICES_ACTIVITIES" + ControlChars.CrLf; var oQuery = new InlineQueryDBManager(); oQuery.CommandText = innerSql; CRMSecurity.Filter(oQuery, m_sMODULE, "list", "ACTIVITY_ASSIGNED_USER_ID"); TypeConvert.AppendParameter(oQuery, gID, "INVOICE_ID"); TypeConvert.AppendParameter(oQuery, true, "IS_OPEN", false); oQuery.CommandText += grdOpen.OrderByClause("DATE_DUE", "desc"); using (DataTable dt = oQuery.GetTable()) { foreach (DataRow row in dt.Rows) { switch (CommonTypeConvert.ToString(row["ACTIVITY_TYPE"])) { case "Calls": row["STATUS"] = Translation.GetTranslation.Term(".call_direction_dom.", row["DIRECTION"]) + " " + Translation.GetTranslation.Term(".call_status_dom.", row["STATUS"]); break; } } vwOpen = new DataView(dt); grdOpen.DataSource = vwOpen; grdOpen.DataBind(); } oQuery.CommandText = innerSql; CRMSecurity.Filter(oQuery, m_sMODULE, "list", "ACTIVITY_ASSIGNED_USER_ID"); TypeConvert.AppendParameter(oQuery, gID, "INVOICE_ID"); TypeConvert.AppendParameter(oQuery, false, "IS_OPEN", false); oQuery.CommandText += grdHistory.OrderByClause("DATE_MODIFIED", "desc"); using (DataTable dt = oQuery.GetTable()) { foreach (DataRow row in dt.Rows) { switch (CommonTypeConvert.ToString(row["ACTIVITY_TYPE"])) { case "Calls": row["STATUS"] = Translation.GetTranslation.Term(".call_direction_dom.", row["DIRECTION"]) + " " + Translation.GetTranslation.Term(".call_status_dom.", row["STATUS"]); break; } } vwHistory = new DataView(dt); grdHistory.DataSource = vwHistory; grdHistory.DataBind(); } }
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); } }
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)) { string innerSql = ApplicationSQL.SQL["Invoices_EditView_323"].ToString(); var oQuery = new InlineQueryDBManager(); oQuery.CommandText = innerSql; CRMSecurity.Filter(oQuery, m_sMODULE, "view"); TypeConvert.AppendParameter(oQuery, gID, "ID", false); 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); AppendDetailViewFields(m_sMODULE + ".SummaryView", tblSummary, rdr, Page_Command); Page.Items["ASSIGNED_USER_ID"] = CommonTypeConvert.ToGuid(rdr["ASSIGNED_USER_ID"]); ctlDynamicButtons.AppendButtons(m_sMODULE + ".DetailView", CommonTypeConvert.ToGuid(rdr["ASSIGNED_USER_ID"]), 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(); } } }
protected void BindGrid() { string innerSql = "select " + CommonTypeConvert.FormatSelectFields(arrSelectFields) + " from vwINVOICES_ACTIVITIES" + ControlChars.CrLf; var oQuery = new InlineQueryDBManager(); oQuery.CommandText = innerSql; CRMSecurity.Filter(oQuery, m_sMODULE, "list", "ACTIVITY_ASSIGNED_USER_ID"); TypeConvert.AppendParameter(oQuery, gID, "INVOICE_ID"); TypeConvert.AppendParameter(oQuery, true, "IS_OPEN", false); oQuery.CommandText += grdOpen.OrderByClause("DATE_DUE", "desc"); using (DataTable dt = oQuery.GetTable()) { foreach (DataRow row in dt.Rows) { switch (CommonTypeConvert.ToString(row["ACTIVITY_TYPE"])) { case "Calls": row["STATUS"] = Translation.GetTranslation.Term(".call_direction_dom.", row["DIRECTION"]) + " " + Translation.GetTranslation.Term(".call_status_dom.", row["STATUS"]); break; } } vwOpen = new DataView(dt); grdOpen.DataSource = vwOpen; grdOpen.DataBind(); } oQuery.CommandText = innerSql; CRMSecurity.Filter(oQuery, m_sMODULE, "list", "ACTIVITY_ASSIGNED_USER_ID"); TypeConvert.AppendParameter(oQuery, gID, "INVOICE_ID"); TypeConvert.AppendParameter(oQuery, false, "IS_OPEN", false); oQuery.CommandText += grdHistory.OrderByClause("DATE_MODIFIED", "desc"); using (DataTable dt = oQuery.GetTable()) { foreach (DataRow row in dt.Rows) { switch (CommonTypeConvert.ToString(row["ACTIVITY_TYPE"])) { case "Calls": row["STATUS"] = Translation.GetTranslation.Term(".call_direction_dom.", row["DIRECTION"]) + " " + Translation.GetTranslation.Term(".call_status_dom.", row["STATUS"]); break; } } vwHistory = new DataView(dt); grdHistory.DataSource = vwHistory; grdHistory.DataBind(); } }
protected void BindGrid() { var oQuery = new InlineQueryDBManager(); string innerSql = "select " + CommonTypeConvert.FormatSelectFields(arrSelectFields) + " from vwPRODUCT_TEMPLATES_PRODUCT_TEMPLATES" + ControlChars.CrLf + " where 1 = 1 " + ControlChars.CrLf; oQuery.CommandText = innerSql; TypeConvert.AppendParameter(oQuery, gID, "PRODUCT_TEMPLATE_ID"); oQuery.CommandText += grdMain.OrderByClause("DATE_ENTERED", "desc"); DataTable dt = oQuery.GetTable(); vwMain = dt.DefaultView; grdMain.DataSource = vwMain; grdMain.DataBind(); }
public static DataTable ActiveUsers() { Cache Cache = HttpRuntime.Cache; var dt = Cache.Get("vwUSERS_List") as DataTable; if (dt == null) { var oQuery = new InlineQueryDBManager(); string innerSql = ApplicationSQL.SQL["_code_CRMCache_1149"].ToString(); oQuery.CommandText = innerSql; dt = oQuery.GetTable(); Cache.Insert("vwUSERS_List", dt, null, DateTime.Now.AddSeconds(15), Cache.NoSlidingExpiration); } 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)) { string innerSql = ApplicationSQL.SQL["Invoices_EditView_323"].ToString(); var oQuery = new InlineQueryDBManager(); oQuery.CommandText = innerSql; CRMSecurity.Filter(oQuery, m_sMODULE, "view"); TypeConvert.AppendParameter(oQuery, gID, "ID", false); 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); AppendDetailViewFields(m_sMODULE + ".SummaryView", tblSummary, rdr, Page_Command); Page.Items["ASSIGNED_USER_ID"] = CommonTypeConvert.ToGuid(rdr["ASSIGNED_USER_ID"]); ctlDynamicButtons.AppendButtons(m_sMODULE + ".DetailView", CommonTypeConvert.ToGuid(rdr["ASSIGNED_USER_ID"]), 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(); } } }
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(); } } }
public static DataTable ReportingRelationships() { Cache Cache = HttpRuntime.Cache; var dt = Cache.Get("vwRELATIONSHIPS_Reporting") as DataTable; if (dt == null) { var oQuery = new InlineQueryDBManager(); string innerSql = ApplicationSQL.SQL["_code_CRMCache_448"].ToString(); oQuery.CommandText = innerSql; dt = oQuery.GetTable(); Cache.Insert("vwRELATIONSHIPS_Reporting", dt, null, DefaultCacheExpiration(), Cache.NoSlidingExpiration); } return(dt); }
public static DataTable ContractTypes() { Cache Cache = HttpRuntime.Cache; var dt = Cache.Get("vwCONTRACT_TYPES_LISTBOX") as DataTable; if (dt == null) { var oQuery = new InlineQueryDBManager(); string innerSql = ApplicationSQL.SQL["_code_CRMCache_908"].ToString(); oQuery.CommandText = innerSql; dt = oQuery.GetTable(); Cache.Insert("vwCONTRACT_TYPES_LISTBOX", dt, null, DefaultCacheExpiration(), Cache.NoSlidingExpiration); } return(dt); }
public static DataTable InboundEmailMonitored(HttpApplicationState Application) { Cache Cache = HttpRuntime.Cache; var dt = Cache.Get("vwINBOUND_EMAILS_Monitored") as DataTable; if (dt == null) { var oQuery = new InlineQueryDBManager(); string innerSql = ApplicationSQL.SQL["_code_CRMCache_2063"].ToString(); oQuery.CommandText = innerSql; dt = oQuery.GetTable(); Cache.Insert("vwINBOUND_EMAILS_Monitored", dt, null, DefaultCacheExpiration(), Cache.NoSlidingExpiration); } return(dt); }
public static DataTable TerminologyPickLists() { Cache Cache = HttpRuntime.Cache; var dt = Cache.Get("vwTERMINOLOGY_PickList") as DataTable; if (dt == null) { var oQuery = new InlineQueryDBManager(); string innerSql = ApplicationSQL.SQL["_code_CRMCache_1177"].ToString(); oQuery.CommandText = innerSql; dt = oQuery.GetTable(); Cache.Insert("vwTERMINOLOGY_PickList", dt, null, DefaultCacheExpiration(), Cache.NoSlidingExpiration); } return(dt); }
public static DataTable Modules() { Cache Cache = HttpRuntime.Cache; var dt = Cache.Get("vwMODULES") as DataTable; if (dt == null) { var oQuery = new InlineQueryDBManager(); string innerSql = ApplicationSQL.SQL["_code_CRMCache_1068"].ToString(); oQuery.CommandText = innerSql; dt = oQuery.GetTable(); Cache.Insert("vwMODULES", dt, null, DefaultCacheExpiration(), Cache.NoSlidingExpiration); } return(dt); }
public static DataTable ActiveUsers() { Cache Cache = HttpRuntime.Cache; var dt = Cache.Get("vwUSERS_List") as DataTable; if (dt == null) { var oQuery = new InlineQueryDBManager(); string innerSql = ApplicationSQL.SQL["_code_CRMCache_1149"].ToString(); oQuery.CommandText = innerSql; dt = oQuery.GetTable(); Cache.Insert("vwUSERS_List", dt, null, DateTime.Now.AddSeconds(15), Cache.NoSlidingExpiration); } return(dt); }
public LineItem GetItemDetailsByNumber(Guid gCURRENCY_ID, string sMFT_PART_NUM) { var item = new LineItem(); { if (Security.USER_ID == Guid.Empty) { throw (new Exception("Authentication required")); } var oQuery = new InlineQueryDBManager(); oQuery.CommandText = ApplicationSQL.SQL["ProductCatalog_AutoComplete_63"].ToString(); CRMSecurity.Filter(oQuery, "ProductTemplates", "list"); TypeConvert.AppendParameter(oQuery, sMFT_PART_NUM, CommonTypeConvert.SqlFilterMode.StartsWith, "MFT_PART_NUM"); oQuery.CommandText += " order by MFT_PART_NUM" + ControlChars.CrLf; using (SqlDataReader rdr = oQuery.ExecuteReader(CommandBehavior.SingleRow)) { if (rdr.Read()) { item.ID = CommonTypeConvert.ToGuid(rdr["ID"]); item.NAME = CommonTypeConvert.ToString(rdr["NAME"]); item.MFT_PART_NUM = CommonTypeConvert.ToString(rdr["MFT_PART_NUM"]); item.VENDOR_PART_NUM = CommonTypeConvert.ToString(rdr["VENDOR_PART_NUM"]); item.TAX_CLASS = CommonTypeConvert.ToString(rdr["TAX_CLASS"]); item.COST_PRICE = CommonTypeConvert.ToDecimal(rdr["COST_PRICE"]); item.COST_USDOLLAR = CommonTypeConvert.ToDecimal(rdr["COST_USDOLLAR"]); item.LIST_PRICE = CommonTypeConvert.ToDecimal(rdr["LIST_PRICE"]); item.LIST_USDOLLAR = CommonTypeConvert.ToDecimal(rdr["LIST_USDOLLAR"]); item.UNIT_PRICE = CommonTypeConvert.ToDecimal(rdr["UNIT_PRICE"]); item.UNIT_USDOLLAR = CommonTypeConvert.ToDecimal(rdr["UNIT_USDOLLAR"]); if (gCURRENCY_ID != CommonTypeConvert.ToGuid(rdr["CURRENCY_ID"])) { Currency C10n = Currency.CreateCurrency(gCURRENCY_ID); item.COST_PRICE = Currency.GetCurrency.ToCurrency(item.COST_USDOLLAR); item.LIST_PRICE = Currency.GetCurrency.ToCurrency(item.LIST_USDOLLAR); item.UNIT_PRICE = Currency.GetCurrency.ToCurrency(item.UNIT_USDOLLAR); } } } if (CommonTypeConvert.IsEmptyGuid(item.ID)) { throw (new Exception("Item not found")); } } return(item); }
protected void BindGrid() { var oQuery = new InlineQueryDBManager(); string innerSql = "select " + CommonTypeConvert.FormatSelectFields(arrSelectFields) + " from vwPRODUCT_TEMPLATES_PRODUCT_TEMPLATES" + ControlChars.CrLf + " where 1 = 1 " + ControlChars.CrLf; oQuery.CommandText = innerSql; TypeConvert.AppendParameter(oQuery, gID, "PRODUCT_TEMPLATE_ID"); oQuery.CommandText += grdMain.OrderByClause("DATE_ENTERED", "desc"); DataTable dt = oQuery.GetTable(); vwMain = dt.DefaultView; grdMain.DataSource = vwMain; grdMain.DataBind(); }
public static DataTable ProductCategories() { Cache Cache = HttpRuntime.Cache; var dt = Cache.Get("vwPRODUCT_CATEGORIES_LISTBOX") as DataTable; if (dt == null) { var oQuery = new InlineQueryDBManager(); string innerSql = ApplicationSQL.SQL["_code_CRMCache_716"].ToString(); oQuery.CommandText = innerSql; dt = oQuery.GetTable(); Cache.Insert("vwPRODUCT_CATEGORIES_LISTBOX", dt, null, DefaultCacheExpiration(), Cache.NoSlidingExpiration); } 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 BindGrid() { string innerSql = "select " + CommonTypeConvert.FormatSelectFields(arrSelectFields) + " from vwINVOICES_PAYMENTS" + ControlChars.CrLf; var oQuery = new InlineQueryDBManager(); oQuery.CommandText = innerSql; CRMSecurity.Filter(oQuery, m_sMODULE, "list"); TypeConvert.AppendParameter(oQuery, gID, "INVOICE_ID"); oQuery.CommandText += grdMain.OrderByClause("DATE_ENTERED", "desc"); using (DataTable dt = oQuery.GetTable()) { vwMain = dt.DefaultView; grdMain.DataSource = vwMain; grdMain.DataBind(); } }
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); }
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 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 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 TimezonesListbox() { Cache Cache = HttpRuntime.Cache; var dt = Cache.Get("vwTIMEZONES_LISTBOX") as DataTable; if (dt == null) { var oQuery = new InlineQueryDBManager(); string innerSql = "select ID " + ControlChars.CrLf + " , NAME " + ControlChars.CrLf + " from vwTIMEZONES_LISTBOX" + ControlChars.CrLf + " order by BIAS desc " + ControlChars.CrLf; oQuery.CommandText = innerSql; dt = oQuery.GetTable(); Cache.Insert("vwTIMEZONES_LISTBOX", dt, null, DefaultCacheExpiration(), Cache.NoSlidingExpiration); } return(dt); }
public string[] InvoiceNameList(string prefixText, int count) { var arrItems = new string[0]; if (Security.USER_ID == Guid.Empty) throw (new Exception("Authentication required")); var oQuery = new InlineQueryDBManager(); string innerSql = ApplicationSQL.SQL["Invoices_AutoComplete_94"].ToString(); oQuery.CommandText = innerSql; CRMSecurity.Filter(oQuery, "Invoices", "list"); TypeConvert.AppendParameter(oQuery, prefixText, CommonTypeConvert.SqlFilterMode.StartsWith, "NAME"); innerSql += " order by NAME" + ControlChars.CrLf; DataTable dt = oQuery.GetTable(); arrItems = new string[dt.Rows.Count]; for (int i = 0; i < dt.Rows.Count; i++) arrItems[i] = CommonTypeConvert.ToString(dt.Rows[i]["NAME"]); return arrItems; }
protected void Page_Load(object sender, EventArgs e) { SetPageTitle(Translation.GetTranslation.Term("ProductTypes.LBL_LIST_FORM_TITLE")); if (!Visible) return; var oQuery = new InlineQueryDBManager(); string innerSql = ApplicationSQL.SQL["Administration_ProductTypes_ListView"].ToString(); oQuery.CommandText = innerSql; DataTable dt = oQuery.GetTable(); vwMain = dt.DefaultView; grdMain.DataSource = vwMain; if (!IsPostBack) { grdMain.SortColumn = "LIST_ORDER"; grdMain.SortOrder = "asc"; grdMain.ApplySort(); grdMain.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { gID = CommonTypeConvert.ToGuid(Request["ID"]); string innerSql = ApplicationSQL.SQL["Invoices_LineItems"].ToString(); var oQuery = new InlineQueryDBManager(); oQuery.CommandText = innerSql; TypeConvert.AppendParameter(oQuery, gID, "INVOICE_ID", false); oQuery.CommandText += " order by POSITION asc" + ControlChars.CrLf; using (DataTable dt = oQuery.GetTable()) { vwMain = dt.DefaultView; grdMain.DataSource = vwMain; { grdMain.DataBind(); } } }
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(m_sMODULE + ".LBL_LIST_FORM_TITLE")); var oQuery = new InlineQueryDBManager(); string innerSql = " from vwPRODUCT_TEMPLATES_List" + ControlChars.CrLf + " where 1 = 1 " + ControlChars.CrLf; oQuery.CommandText = innerSql; grdMain.OrderByClause("NAME", "asc"); ctlSearchView.SqlSearchClause(oQuery); oQuery.CommandText = "select " + CommonTypeConvert.FormatSelectFields(arrSelectFields) + oQuery.CommandText + grdMain.OrderByClause(); DataTable dt = oQuery.GetTable(); vwMain = dt.DefaultView; grdMain.DataSource = vwMain; if (!IsPostBack) { grdMain.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { SetPageTitle(Translation.GetTranslation.Term(m_sMODULE + ".LBL_LIST_FORM_TITLE")); var oQuery = new InlineQueryDBManager(); string innerSql = ApplicationSQL.SQL["ProductCategories_Popup"].ToString(); oQuery.CommandText = innerSql; ctlSearch.SqlSearchClause(oQuery); DataTable dt = oQuery.GetTable(); vwMain = dt.DefaultView; grdMain.DataSource = vwMain; if (!IsPostBack) { if (String.IsNullOrEmpty(grdMain.SortColumn)) { grdMain.SortColumn = "LIST_ORDER"; grdMain.SortOrder = "asc"; } grdMain.ApplySort(); 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 void AppendEditViewFields(DataView dvFields, HtmlTable tbl, System.Data.SqlClient.SqlDataReader rdr, CommandEventHandler Page_Command, bool bLayoutMode, string sEDIT_NAME) { bool bIsMobile = false; CRMPage Page = tbl.Page as CRMPage; if (Page != null) bIsMobile = Page.IsMobile; HtmlTableRow tr = null; int nRowIndex = tbl.Rows.Count - 1; int nColIndex = 0; HtmlTableCell tdLabel = null; HtmlTableCell tdField = null; if (bLayoutMode) tbl.Border = 1; if (dvFields.Count == 0 && tbl.Rows.Count <= 1) tbl.Visible = false; DataView vwSchema = null; if (rdr != null) vwSchema = new DataView(rdr.GetSchemaTable()); bool bEnableTeamManagement = Common.Config.enable_team_management(); bool bRequireTeamManagement = Common.Config.require_team_management(); bool bRequireUserAssignment = Common.Config.require_user_assignment(); HttpSessionState Session = HttpContext.Current.Session; foreach (DataRowView row in dvFields) { int gID = TypeConvert.ToInteger(row["ID"]); int nFIELD_INDEX = TypeConvert.ToInteger(row["FIELD_INDEX"]); string sFIELD_TYPE = TypeConvert.ToString(row["FIELD_TYPE"]); string sDATA_LABEL = TypeConvert.ToString(row["DATA_LABEL"]); string sDATA_FIELD = TypeConvert.ToString(row["DATA_FIELD"]); string sDISPLAY_FIELD = TypeConvert.ToString(row["DISPLAY_FIELD"]); string sCACHE_NAME = TypeConvert.ToString(row["CACHE_NAME"]); bool bDATA_REQUIRED = TypeConvert.ToBoolean(row["DATA_REQUIRED"]); bool bUI_REQUIRED = TypeConvert.ToBoolean(row["UI_REQUIRED"]); string sONCLICK_SCRIPT = TypeConvert.ToString(row["ONCLICK_SCRIPT"]); string sFORMAT_SCRIPT = TypeConvert.ToString(row["FORMAT_SCRIPT"]); short nFORMAT_TAB_INDEX = TypeConvert.ToShort(row["FORMAT_TAB_INDEX"]); int nFORMAT_MAX_LENGTH = TypeConvert.ToInteger(row["FORMAT_MAX_LENGTH"]); int nFORMAT_SIZE = TypeConvert.ToInteger(row["FORMAT_SIZE"]); int nFORMAT_ROWS = TypeConvert.ToInteger(row["FORMAT_ROWS"]); int nFORMAT_COLUMNS = TypeConvert.ToInteger(row["FORMAT_COLUMNS"]); int nCOLSPAN = TypeConvert.ToInteger(row["COLSPAN"]); int nROWSPAN = TypeConvert.ToInteger(row["ROWSPAN"]); string sLABEL_WIDTH = TypeConvert.ToString(row["LABEL_WIDTH"]); string sFIELD_WIDTH = TypeConvert.ToString(row["FIELD_WIDTH"]); int nDATA_COLUMNS = TypeConvert.ToInteger(row["DATA_COLUMNS"]); string sFIELD_VALIDATOR_MESSAGE = TypeConvert.ToString(row["FIELD_VALIDATOR_MESSAGE"]); string sVALIDATION_TYPE = TypeConvert.ToString(row["VALIDATION_TYPE"]); string sREGULAR_EXPRESSION = TypeConvert.ToString(row["REGULAR_EXPRESSION"]); string sDATA_TYPE = TypeConvert.ToString(row["DATA_TYPE"]); string sMININUM_VALUE = TypeConvert.ToString(row["MININUM_VALUE"]); string sMAXIMUM_VALUE = TypeConvert.ToString(row["MAXIMUM_VALUE"]); string sCOMPARE_OPERATOR = TypeConvert.ToString(row["COMPARE_OPERATOR"]); if (nDATA_COLUMNS == 0) nDATA_COLUMNS = 2; if (!bLayoutMode && sDATA_FIELD == "TEAM_ID") { if (!bEnableTeamManagement) { sFIELD_TYPE = "Blank"; bUI_REQUIRED = false; } else { if (bRequireTeamManagement) bUI_REQUIRED = true; } } if (!bLayoutMode && sDATA_FIELD == "ASSIGNED_USER_ID") { if (bRequireUserAssignment) bUI_REQUIRED = true; } if (bIsMobile && String.Compare(sFIELD_TYPE, "AddressButtons", true) == 0) { continue; } if ((nCOLSPAN >= 0 && nColIndex == 0) || tr == null || bIsMobile) { nRowIndex++; tr = new HtmlTableRow(); tbl.Rows.Insert(nRowIndex, tr); } if (bLayoutMode) { HtmlTableCell tdAction = new HtmlTableCell(); tr.Cells.Add(tdAction); tdAction.Attributes.Add("class", "tabDetailViewDL"); tdAction.NoWrap = true; Literal litIndex = new Literal(); tdAction.Controls.Add(litIndex); litIndex.Text = " " + nFIELD_INDEX.ToString() + " "; ImageButton btnMoveUp = CreateLayoutImageButtonSkin(gID, "Layout.MoveUp", nFIELD_INDEX, Translation.GetTranslation.Term("Dropdown.LNK_UP"), "uparrow_inline", Page_Command); ImageButton btnMoveDown = CreateLayoutImageButtonSkin(gID, "Layout.MoveDown", nFIELD_INDEX, Translation.GetTranslation.Term("Dropdown.LNK_DOWN"), "downarrow_inline", Page_Command); ImageButton btnInsert = CreateLayoutImageButtonSkin(gID, "Layout.Insert", nFIELD_INDEX, Translation.GetTranslation.Term("Dropdown.LNK_INS"), "plus_inline", Page_Command); ImageButton btnEdit = CreateLayoutImageButtonSkin(gID, "Layout.Edit", nFIELD_INDEX, Translation.GetTranslation.Term("Dropdown.LNK_EDIT"), "edit_inline", Page_Command); ImageButton btnDelete = CreateLayoutImageButtonSkin(gID, "Layout.Delete", nFIELD_INDEX, Translation.GetTranslation.Term("Dropdown.LNK_DELETE"), "delete_inline", Page_Command); tdAction.Controls.Add(btnMoveUp); tdAction.Controls.Add(btnMoveDown); tdAction.Controls.Add(btnInsert); tdAction.Controls.Add(btnEdit); tdAction.Controls.Add(btnDelete); } Literal litLabel = new Literal(); if (!TypeConvert.IsEmptyString(sDATA_FIELD)) litLabel.ID = sDATA_FIELD + "_LABEL"; if (nCOLSPAN >= 0 || tdLabel == null || tdField == null) { tdLabel = new HtmlTableCell(); tdField = new HtmlTableCell(); tr.Cells.Add(tdLabel); tr.Cells.Add(tdField); if (nCOLSPAN > 0) { tdField.ColSpan = nCOLSPAN; if (bLayoutMode) tdField.ColSpan++; } tdLabel.Attributes.Add("class", "dataLabel"); tdLabel.VAlign = "top"; tdLabel.Width = sLABEL_WIDTH; tdField.Attributes.Add("class", "dataField"); tdField.VAlign = "top"; if (nCOLSPAN == 0) tdField.Width = sFIELD_WIDTH; tdLabel.Controls.Add(litLabel); if (bLayoutMode) litLabel.Text = sDATA_LABEL; else if (sDATA_LABEL.IndexOf(".") >= 0) litLabel.Text = Translation.GetTranslation.Term(sDATA_LABEL); else if (!TypeConvert.IsEmptyString(sDATA_LABEL) && rdr != null) { litLabel.Text = sDATA_LABEL; if (vwSchema != null) { vwSchema.RowFilter = "ColumnName = '" + TypeConvert.EscapeSQL(sDATA_LABEL) + "'"; if (vwSchema.Count > 0) litLabel.Text = TypeConvert.ToString(rdr[sDATA_LABEL]) + Translation.GetTranslation.Term("Calls.LBL_COLON"); } } else litLabel.Text = sDATA_LABEL; // " "; if (!bLayoutMode && bUI_REQUIRED) { Label lblRequired = new Label(); tdLabel.Controls.Add(lblRequired); lblRequired.CssClass = "required"; lblRequired.Text = Translation.GetTranslation.Term(".LBL_REQUIRED_SYMBOL"); } } if (String.Compare(sFIELD_TYPE, "Blank", true) == 0) { Literal litField = new Literal(); tdField.Controls.Add(litField); if (bLayoutMode) { litLabel.Text = "*** BLANK ***"; litField.Text = "*** BLANK ***"; } else { litLabel.Text = " "; litField.Text = " "; } } else if (String.Compare(sFIELD_TYPE, "Label", true) == 0) { if (!TypeConvert.IsEmptyString(sDATA_FIELD)) { Literal litField = new Literal(); tdField.Controls.Add(litField); tdField.VAlign = "middle"; litField.ID = sDATA_FIELD; if (bLayoutMode) litField.Text = sDATA_FIELD; else if (sDATA_FIELD.IndexOf(".") >= 0) litField.Text = Translation.GetTranslation.Term(sDATA_FIELD); else if (rdr != null) litField.Text = TypeConvert.ToString(rdr[sDATA_FIELD]); } } else if (String.Compare(sFIELD_TYPE, "ListBox", true) == 0) { if (!TypeConvert.IsEmptyString(sDATA_FIELD)) { ListControl lstField = null; if (nFORMAT_ROWS > 0) { ListBox lb = new ListBox(); lb.SelectionMode = ListSelectionMode.Multiple; lb.Rows = nFORMAT_ROWS; lstField = lb; } else { lstField = new KeySortDropDownList(); } tdField.Controls.Add(lstField); lstField.ID = sDATA_FIELD; lstField.TabIndex = nFORMAT_TAB_INDEX; if (!TypeConvert.IsEmptyString(sDATA_FIELD)) { if (!TypeConvert.IsEmptyString(sCACHE_NAME) && (bLayoutMode || !tbl.Page.IsPostBack)) { lstField.DataValueField = "NAME"; lstField.DataTextField = "DISPLAY_NAME"; lstField.DataSource = CRMCache.List(sCACHE_NAME); if (sCACHE_NAME != "lead_status_dom") { if (sCACHE_NAME != "Currencies") { lstField.Attributes.Add("class", "dropdown"); } } if (sCACHE_NAME != "program_plan" || sCACHE_NAME != "Currencies") { if (sCACHE_NAME != "Currencies") { lstField.Attributes.Add("dom", sCACHE_NAME); } } lstField.DataBind(); if (!TypeConvert.IsEmptyString(sONCLICK_SCRIPT)) lstField.Attributes.Add("onchange", sONCLICK_SCRIPT); if (!bUI_REQUIRED) { lstField.Items.Insert(0, new ListItem(Translation.GetTranslation.Term(".LBL_NONE"), "")); lstField.DataBound += new EventHandler(ListControl_DataBound_AllowNull); } } if (rdr != null) { string sVALUE = TypeConvert.ToString(rdr[sDATA_FIELD]); if (nFORMAT_ROWS > 0 && sVALUE.StartsWith("<?xml")) { XmlDocument xml = new XmlDocument(); xml.LoadXml(sVALUE); XmlNodeList nlValues = xml.DocumentElement.SelectNodes("Value"); foreach (XmlNode xValue in nlValues) { foreach (ListItem item in lstField.Items) { if (item.Value == xValue.InnerText) item.Selected = true; } } } else { lstField.SelectedValue = sVALUE; } } else if (rdr == null && !tbl.Page.IsPostBack && sCACHE_NAME == "AssignedUser") { if (nFORMAT_ROWS == 0) lstField.SelectedValue = CRMSecurity.USER_ID.ToString(); } } if (bLayoutMode) { Literal litField = new Literal(); litField.Text = sDATA_FIELD; tdField.Controls.Add(litField); } } } else if (String.Compare(sFIELD_TYPE, "CheckBox", true) == 0) { if (!TypeConvert.IsEmptyString(sDATA_FIELD)) { CheckBox chkField = new CheckBox(); tdField.Controls.Add(chkField); chkField.ID = sDATA_FIELD; chkField.CssClass = "checkbox"; chkField.TabIndex = nFORMAT_TAB_INDEX; if (rdr != null) chkField.Checked = TypeConvert.ToBoolean(rdr[sDATA_FIELD]); if (!TypeConvert.IsEmptyString(sONCLICK_SCRIPT)) chkField.Attributes.Add("onclick", sONCLICK_SCRIPT); if (bLayoutMode) { Literal litField = new Literal(); litField.Text = sDATA_FIELD; tdField.Controls.Add(litField); chkField.Enabled = false; } } } else if (String.Compare(sFIELD_TYPE, "ChangeButton", true) == 0) { if (!TypeConvert.IsEmptyString(sDATA_FIELD)) { if (sDATA_LABEL == "PARENT_TYPE") { tdLabel.Controls.Clear(); DropDownList lstField = new KeySortDropDownList(); tdLabel.Controls.Add(lstField); lstField.ID = sDATA_LABEL; lstField.TabIndex = nFORMAT_TAB_INDEX; lstField.Attributes.Add("onChange", "ChangeParentType();"); if (bLayoutMode || !tbl.Page.IsPostBack) { lstField.DataValueField = "NAME"; lstField.DataTextField = "DISPLAY_NAME"; lstField.DataSource = CRMCache.List("record_type_display"); lstField.DataBind(); if (rdr != null) { lstField.ClearSelection(); lstField.SelectedValue = TypeConvert.ToString(rdr[sDATA_LABEL]); } } } TextBox txtNAME = new TextBox(); tdField.Controls.Add(txtNAME); txtNAME.ID = sDISPLAY_FIELD; txtNAME.ReadOnly = true; txtNAME.TabIndex = nFORMAT_TAB_INDEX; txtNAME.EnableViewState = false; if (bLayoutMode) { txtNAME.Text = sDISPLAY_FIELD; txtNAME.Enabled = false; } else if (tbl.Page.IsPostBack) { if (tbl.Page.Request[txtNAME.UniqueID] != null) txtNAME.Text = TypeConvert.ToString(tbl.Page.Request[txtNAME.UniqueID]); } else if (!TypeConvert.IsEmptyString(sDISPLAY_FIELD) && rdr != null) txtNAME.Text = TypeConvert.ToString(rdr[sDISPLAY_FIELD]); else if (sDATA_FIELD == "TEAM_ID" && rdr == null && !tbl.Page.IsPostBack) txtNAME.Text = CRMSecurity.TEAM_NAME; else if (sDATA_FIELD == "ASSIGNED_USER_ID" && rdr == null && !tbl.Page.IsPostBack) txtNAME.Text = CRMSecurity.USER_NAME; HtmlInputHidden hidID = new HtmlInputHidden(); tdField.Controls.Add(hidID); hidID.ID = sDATA_FIELD; if (!bLayoutMode) { if (!TypeConvert.IsEmptyString(sDATA_FIELD) && rdr != null) { hidID.Value = TypeConvert.ToString(rdr[sDATA_FIELD]); hidID.Value = (TypeConvert.ToGuid(hidID.Value) == Guid.Empty) ? "" : hidID.Value; } else if (sDATA_FIELD == "TEAM_ID" && rdr == null && !tbl.Page.IsPostBack) hidID.Value = CRMSecurity.TEAM_ID.ToString(); else if (sDATA_FIELD == "ASSIGNED_USER_ID" && rdr == null && !tbl.Page.IsPostBack) hidID.Value = CRMSecurity.USER_ID.ToString(); } if (!String.IsNullOrEmpty(CRMSecurity.TEAM_NAME)) { txtNAME.Text = CRMSecurity.TEAM_NAME; } else { InlineQueryDBManager oQuery = new InlineQueryDBManager(); oQuery.CommandText = "select Teams.name,Teams.id from Teams where id in (select t.team_ID from users u " + "inner join Team_Memberships t on u.id = t.USER_ID " + "and u.id ='" + Security.USER_ID.ToString() + "')"; using (DataTable dt = oQuery.GetTable()) { if (dt.Rows.Count > 0 && (sDATA_FIELD != "ASSIGNED_USER_ID" && rdr == null && !tbl.Page.IsPostBack)) { txtNAME.Text = dt.Rows[0]["name"].ToString(); hidID.Value = dt.Rows[0]["id"].ToString(); } } } Literal litNBSP = new Literal(); tdField.Controls.Add(litNBSP); litNBSP.Text = " "; HtmlInputButton btnChange = new HtmlInputButton("button"); tdField.Controls.Add(btnChange); btnChange.ID = sDATA_FIELD + "_btnChange"; btnChange.Attributes.Add("class", "button"); if (!TypeConvert.IsEmptyString(sONCLICK_SCRIPT)) btnChange.Attributes.Add("onclick", sONCLICK_SCRIPT); btnChange.Attributes.Add("title", Translation.GetTranslation.Term(".LBL_SELECT_BUTTON_TITLE")); btnChange.Value = Translation.GetTranslation.Term(".LBL_SELECT_BUTTON_LABEL"); if (sONCLICK_SCRIPT.IndexOf("Popup();") > 0) { litNBSP = new Literal(); tdField.Controls.Add(litNBSP); litNBSP.Text = " "; HtmlInputButton btnClear = new HtmlInputButton("button"); tdField.Controls.Add(btnClear); btnClear.ID = sDATA_FIELD + "_btnClear"; btnClear.Attributes.Add("class", "button"); btnClear.Attributes.Add("onclick", sONCLICK_SCRIPT.Replace("Popup();", "('', '');").Replace("return ", "return Change")); btnClear.Attributes.Add("title", Translation.GetTranslation.Term(".LBL_CLEAR_BUTTON_TITLE")); btnClear.Value = Translation.GetTranslation.Term(".LBL_CLEAR_BUTTON_LABEL"); } if (!bLayoutMode && bUI_REQUIRED && !TypeConvert.IsEmptyString(sDATA_FIELD)) { RequiredFieldValidatorForHiddenInputs reqID = new RequiredFieldValidatorForHiddenInputs(); reqID.ID = sDATA_FIELD + "_REQUIRED"; reqID.ControlToValidate = hidID.ID; reqID.ErrorMessage = Translation.GetTranslation.Term(".ERR_REQUIRED_FIELD"); reqID.CssClass = "required"; reqID.EnableViewState = false; reqID.EnableClientScript = false; reqID.Enabled = false; reqID.Style.Add("padding-left", "4px"); tdField.Controls.Add(reqID); } } } else if (String.Compare(sFIELD_TYPE, "TextBox", true) == 0 || String.Compare(sFIELD_TYPE, "Password", true) == 0) { if (!TypeConvert.IsEmptyString(sDATA_FIELD)) { TextBox txtField = new TextBox(); tdField.Controls.Add(txtField); txtField.ID = sDATA_FIELD; txtField.TabIndex = nFORMAT_TAB_INDEX; if (nFORMAT_ROWS > 0 && nFORMAT_COLUMNS > 0) { txtField.Rows = nFORMAT_ROWS; txtField.Columns = nFORMAT_COLUMNS; txtField.TextMode = TextBoxMode.MultiLine; } else { txtField.MaxLength = nFORMAT_MAX_LENGTH; txtField.Attributes.Add("size", nFORMAT_SIZE.ToString()); txtField.TextMode = TextBoxMode.SingleLine; } if (bLayoutMode) { txtField.Text = sDATA_FIELD; txtField.ReadOnly = true; } else if (!TypeConvert.IsEmptyString(sDATA_FIELD) && rdr != null) { int nOrdinal = rdr.GetOrdinal(sDATA_FIELD); string sTypeName = rdr.GetDataTypeName(nOrdinal); if (sTypeName == "money" || rdr[sDATA_FIELD].GetType() == typeof(System.Decimal)) txtField.Text = TypeConvert.ToDecimal(rdr[sDATA_FIELD]).ToString("#,##0.00"); else txtField.Text = TypeConvert.ToString(rdr[sDATA_FIELD]); } if (String.Compare(sFIELD_TYPE, "Password", true) == 0) txtField.TextMode = TextBoxMode.Password; if (!bLayoutMode && bUI_REQUIRED && !TypeConvert.IsEmptyString(sDATA_FIELD)) { RequiredFieldValidator reqNAME = new RequiredFieldValidator(); reqNAME.ID = sDATA_FIELD + "_REQUIRED"; reqNAME.ControlToValidate = txtField.ID; reqNAME.ErrorMessage = Translation.GetTranslation.Term(".ERR_REQUIRED_FIELD"); reqNAME.CssClass = "required"; reqNAME.EnableViewState = false; reqNAME.EnableClientScript = false; reqNAME.Enabled = false; reqNAME.Style.Add("padding-left", "4px"); tdField.Controls.Add(reqNAME); } if (!bLayoutMode && !TypeConvert.IsEmptyString(sDATA_FIELD)) { if (sVALIDATION_TYPE == "RegularExpressionValidator" && !TypeConvert.IsEmptyString(sREGULAR_EXPRESSION) && !TypeConvert.IsEmptyString(sFIELD_VALIDATOR_MESSAGE)) { RegularExpressionValidator reqVALIDATOR = new RegularExpressionValidator(); reqVALIDATOR.ID = sDATA_FIELD + "_VALIDATOR"; reqVALIDATOR.ControlToValidate = txtField.ID; reqVALIDATOR.ErrorMessage = Translation.GetTranslation.Term(sFIELD_VALIDATOR_MESSAGE); reqVALIDATOR.ValidationExpression = sREGULAR_EXPRESSION; reqVALIDATOR.CssClass = "required"; reqVALIDATOR.EnableViewState = false; reqVALIDATOR.EnableClientScript = false; reqVALIDATOR.Enabled = false; reqVALIDATOR.Style.Add("padding-left", "4px"); tdField.Controls.Add(reqVALIDATOR); } } } } else if (String.Compare(sFIELD_TYPE, "DatePicker", true) == 0) { if (!TypeConvert.IsEmptyString(sDATA_FIELD)) { DatePicker ctlDate = tbl.Page.LoadControl("~/CRM/UserControls/DatePicker.ascx") as DatePicker; tdField.Controls.Add(ctlDate); ctlDate.ID = sDATA_FIELD; ctlDate.TabIndex = nFORMAT_TAB_INDEX; if (rdr != null) ctlDate.Value = CRM.Common.TimeZone.GetTimeZone.FromServerTime(rdr[sDATA_FIELD]); if (bLayoutMode) { Literal litField = new Literal(); litField.Text = sDATA_FIELD; tdField.Controls.Add(litField); } } } else if (String.Compare(sFIELD_TYPE, "DateRange", true) == 0) { if (!TypeConvert.IsEmptyString(sDATA_FIELD)) { Table tblDateRange = new Table(); tdField.Controls.Add(tblDateRange); TableRow trAfter = new TableRow(); TableRow trBefore = new TableRow(); tblDateRange.Rows.Add(trAfter); tblDateRange.Rows.Add(trBefore); TableCell tdAfterLabel = new TableCell(); TableCell tdAfterData = new TableCell(); TableCell tdBeforeLabel = new TableCell(); TableCell tdBeforeData = new TableCell(); trAfter.Cells.Add(tdAfterLabel); trAfter.Cells.Add(tdAfterData); trBefore.Cells.Add(tdBeforeLabel); trBefore.Cells.Add(tdBeforeData); DatePicker ctlDateStart = tbl.Page.LoadControl("~/CRM/UserControls/DatePicker.ascx") as DatePicker; DatePicker ctlDateEnd = tbl.Page.LoadControl("~/CRM/UserControls/DatePicker.ascx") as DatePicker; Literal litAfterLabel = new Literal(); Literal litBeforeLabel = new Literal(); litAfterLabel.Text = Translation.GetTranslation.Term("SavedSearch.LBL_SEARCH_AFTER"); litBeforeLabel.Text = Translation.GetTranslation.Term("SavedSearch.LBL_SEARCH_BEFORE"); tdAfterLabel.Controls.Add(litAfterLabel); tdAfterData.Controls.Add(ctlDateStart); tdBeforeLabel.Controls.Add(litBeforeLabel); tdBeforeData.Controls.Add(ctlDateEnd); ctlDateStart.ID = sDATA_FIELD + "_AFTER"; ctlDateEnd.ID = sDATA_FIELD + "_BEFORE"; ctlDateStart.TabIndex = nFORMAT_TAB_INDEX; ctlDateEnd.TabIndex = nFORMAT_TAB_INDEX; if (rdr != null) { ctlDateStart.Value = CRM.Common.TimeZone.GetTimeZone.FromServerTime(rdr[sDATA_FIELD]); ctlDateEnd.Value = CRM.Common.TimeZone.GetTimeZone.FromServerTime(rdr[sDATA_FIELD]); } if (bLayoutMode) { Literal litField = new Literal(); litField.Text = sDATA_FIELD; tdField.Controls.Add(litField); } } } else if (String.Compare(sFIELD_TYPE, "DateTimePicker", true) == 0) { if (!TypeConvert.IsEmptyString(sDATA_FIELD)) { DateTimePicker ctlDate = tbl.Page.LoadControl("~/CRM/UserControls/DateTimePicker.ascx") as DateTimePicker; tdField.Controls.Add(ctlDate); ctlDate.ID = sDATA_FIELD; ctlDate.TabIndex = nFORMAT_TAB_INDEX; if (rdr != null) ctlDate.Value = CRM.Common.TimeZone.GetTimeZone.FromServerTime(rdr[sDATA_FIELD]); if (bLayoutMode) { Literal litField = new Literal(); litField.Text = sDATA_FIELD; tdField.Controls.Add(litField); } } } else if (String.Compare(sFIELD_TYPE, "DateTimeEdit", true) == 0) { if (!TypeConvert.IsEmptyString(sDATA_FIELD)) { DateTimeEdit ctlDate = tbl.Page.LoadControl("~/CRM/UserControls/DateTimeEdit.ascx") as DateTimeEdit; tdField.Controls.Add(ctlDate); ctlDate.ID = sDATA_FIELD; ctlDate.TabIndex = nFORMAT_TAB_INDEX; if (rdr != null) ctlDate.Value = CRM.Common.TimeZone.GetTimeZone.FromServerTime(rdr[sDATA_FIELD]); if (!bLayoutMode && bUI_REQUIRED) { ctlDate.EnableNone = false; } if (bLayoutMode) { Literal litField = new Literal(); litField.Text = sDATA_FIELD; tdField.Controls.Add(litField); } } } else if (String.Compare(sFIELD_TYPE, "File", true) == 0) { if (!TypeConvert.IsEmptyString(sDATA_FIELD)) { HtmlInputFile ctlField = new HtmlInputFile(); tdField.Controls.Add(ctlField); ctlField.ID = sDATA_FIELD; ctlField.MaxLength = nFORMAT_MAX_LENGTH; ctlField.Size = nFORMAT_SIZE; ctlField.Attributes.Add("TabIndex", nFORMAT_TAB_INDEX.ToString()); if (!bLayoutMode && bUI_REQUIRED) { RequiredFieldValidator reqNAME = new RequiredFieldValidator(); reqNAME.ID = sDATA_FIELD + "_REQUIRED"; reqNAME.ControlToValidate = ctlField.ID; reqNAME.ErrorMessage = Translation.GetTranslation.Term(".ERR_REQUIRED_FIELD"); reqNAME.CssClass = "required"; reqNAME.EnableViewState = false; reqNAME.EnableClientScript = false; reqNAME.Enabled = false; reqNAME.Style.Add("padding-left", "4px"); tdField.Controls.Add(reqNAME); } } } else if (String.Compare(sFIELD_TYPE, "Image", true) == 0) { if (!TypeConvert.IsEmptyString(sDATA_FIELD)) { HtmlInputHidden ctlHidden = new HtmlInputHidden(); if (!bLayoutMode) { tdField.Controls.Add(ctlHidden); ctlHidden.ID = sDATA_FIELD; HtmlInputFile ctlField = new HtmlInputFile(); tdField.Controls.Add(ctlField); ctlField.ID = sDATA_FIELD + "_File"; Literal litBR = new Literal(); litBR.Text = "<br />"; tdField.Controls.Add(litBR); } Image imgField = new Image(); imgField.ID = "img" + sDATA_FIELD; try { if (bLayoutMode) { Literal litField = new Literal(); litField.Text = sDATA_FIELD; tdField.Controls.Add(litField); } else if (rdr != null) { if (!TypeConvert.IsEmptyString(rdr[sDATA_FIELD])) { ctlHidden.Value = TypeConvert.ToString(rdr[sDATA_FIELD]); imgField.ImageUrl = "~/CRM/Images/Image.aspx?ID=" + ctlHidden.Value; tdField.Controls.Add(imgField); Literal litClear = new Literal(); litClear.Text = "<br /><input type=\"button\" class=\"button\" onclick=\"form." + ctlHidden.ClientID + ".value='';form." + imgField.ClientID + ".src='';" + "\" value='" + " " + Translation.GetTranslation.Term(".LBL_CLEAR_BUTTON_LABEL") + " " + "' title='" + Translation.GetTranslation.Term(".LBL_CLEAR_BUTTON_TITLE") + "' />"; tdField.Controls.Add(litClear); } } } catch (Exception ex) { Literal litField = new Literal(); litField.Text = ex.Message; tdField.Controls.Add(litField); } } } else if (String.Compare(sFIELD_TYPE, "AddressButtons", true) == 0) { tr.Cells.Remove(tdField); tdLabel.Width = "10%"; tdLabel.RowSpan = nROWSPAN; tdLabel.VAlign = "middle"; tdLabel.Align = "center"; tdLabel.Attributes.Remove("class"); tdLabel.Attributes.Add("class", "tabFormAddDel"); HtmlInputButton btnCopyRight = new HtmlInputButton("button"); Literal litSpacer = new Literal(); HtmlInputButton btnCopyLeft = new HtmlInputButton("button"); tdLabel.Controls.Add(btnCopyRight); tdLabel.Controls.Add(litSpacer); tdLabel.Controls.Add(btnCopyLeft); btnCopyRight.Attributes.Add("title", Translation.GetTranslation.Term("Accounts.NTC_COPY_BILLING_ADDRESS")); btnCopyRight.Attributes.Add("onclick", "return copyAddressRight()"); btnCopyRight.Value = ">>"; litSpacer.Text = "<br><br>"; btnCopyLeft.Attributes.Add("title", Translation.GetTranslation.Term("Accounts.NTC_COPY_SHIPPING_ADDRESS")); btnCopyLeft.Attributes.Add("onclick", "return copyAddressLeft()"); btnCopyLeft.Value = "<<"; nColIndex = 0; } else if (String.Compare(sFIELD_TYPE, "Hidden", true) == 0) { if (!TypeConvert.IsEmptyString(sDATA_FIELD)) { HtmlInputHidden hidID = new HtmlInputHidden(); tdField.Controls.Add(hidID); hidID.ID = sDATA_FIELD; if (bLayoutMode) { TextBox txtNAME = new TextBox(); tdField.Controls.Add(txtNAME); txtNAME.ReadOnly = true; txtNAME.EnableViewState = false; txtNAME.Text = sDATA_FIELD; txtNAME.Enabled = false; } else { nCOLSPAN = -1; tr.Cells.Remove(tdLabel); tdField.Attributes.Add("style", "display:none"); if (!TypeConvert.IsEmptyString(sDATA_FIELD) && rdr != null) hidID.Value = TypeConvert.ToString(rdr[sDATA_FIELD]); else if (sDATA_FIELD == "TEAM_ID" && rdr == null && !tbl.Page.IsPostBack) hidID.Value = CRMSecurity.TEAM_ID.ToString(); else if (sDATA_FIELD == "ASSIGNED_USER_ID" && rdr == null && !tbl.Page.IsPostBack) hidID.Value = CRMSecurity.USER_ID.ToString(); } } } else { Literal litField = new Literal(); tdField.Controls.Add(litField); litField.Text = "Unknown field type " + sFIELD_TYPE; } if (nCOLSPAN > 0) nColIndex += nCOLSPAN; else if (nCOLSPAN == 0) nColIndex++; if (nColIndex >= nDATA_COLUMNS) nColIndex = 0; } }
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_Command(Object sender, CommandEventArgs e) { if (e.CommandName == "Save" || e.CommandName == "Charge") { ValidateEditViewFields(m_sMODULE + ".EditView"); bool bIsValid = Page.IsValid; Decimal dAMOUNT = new DynamicControl(this, "AMOUNT").DecimalValue; if (dAMOUNT != ctlAllocationsView.ALLOCATED_TOTAL) { ctlDynamicButtons.ErrorText = Translation.GetTranslation.Term("Payments.ERR_AMOUNT_MUST_MATCH_ALLOCATION"); bIsValid = false; } if (bIsValid) { string sCUSTOM_MODULE = "PAYMENTS"; DataTable dtCustomFields = CRMCache.FieldsMetaData_Validated(sCUSTOM_MODULE); var oQuery = new InlineQueryDBManager(); DataRow rowCurrent = null; if (!CommonTypeConvert.IsEmptyGuid(gID)) { string innerSql = ApplicationSQL.SQL["Payments_EditView_259"].ToString(); oQuery.CommandText = innerSql; CRMSecurity.Filter(oQuery, m_sMODULE, "edit"); TypeConvert.AppendParameter(oQuery, gID, "ID", false); DataTable dtCurrent = oQuery.GetTable(); if (dtCurrent.Rows.Count > 0) { rowCurrent = dtCurrent.Rows[0]; } else { gID = Guid.Empty; } } Guid gASSIGNED_USER_ID = new DynamicControl(this, rowCurrent, "ASSIGNED_USER_ID").ID; Guid gACCOUNT_ID = new DynamicControl(this, rowCurrent, "ACCOUNT_ID").ID; DateTime dtPAYMENT_DATE = new DynamicControl(this, rowCurrent, "PAYMENT_DATE").DateValue; string sPAYMENT_TYPE = new DynamicControl(this, rowCurrent, "PAYMENT_TYPE").SelectedValue; string sCUSTOMER_REFERENCE = new DynamicControl(this, rowCurrent, "CUSTOMER_REFERENCE").Text; Guid gCURRENCY_ID = new DynamicControl(this, rowCurrent, "CURRENCY_ID").ID; string sDESCRIPTION = new DynamicControl(this, rowCurrent, "DESCRIPTION").Text; Guid gTEAM_ID = new DynamicControl(this, rowCurrent, "TEAM_ID").ID; Guid gCREDIT_CARD_ID = new DynamicControl(this, rowCurrent, "CREDIT_CARD_ID").ID; if (sPAYMENT_TYPE != "Credit Card") gCREDIT_CARD_ID = Guid.Empty; float fEXCHANGE_RATE = new DynamicControl(ctlAllocationsView, rowCurrent, "EXCHANGE_RATE").FloatValue; var sbINVOICE_NUMBER = new StringBuilder(); if (dtPAYMENT_DATE == ((DateTime) SqlDateTime.MinValue) || e.CommandName == "Charge") dtPAYMENT_DATE = DateTime.Now; CommonProcedure.PatmentsUpdate (ref gID , gASSIGNED_USER_ID , gACCOUNT_ID , dtPAYMENT_DATE , sPAYMENT_TYPE , sCUSTOMER_REFERENCE , fEXCHANGE_RATE , gCURRENCY_ID , dAMOUNT , sDESCRIPTION , gTEAM_ID , gCREDIT_CARD_ID ); CRMDynamic.UpdateCustomFields(this, gID, sCUSTOM_MODULE, dtCustomFields); DataTable dtLineItems = ctlAllocationsView.LineItems; foreach (DataRow row in dtLineItems.Rows) { if (row.RowState == DataRowState.Deleted) { Guid gITEM_ID = CommonTypeConvert.ToGuid(row["ID", DataRowVersion.Original]); if (!CommonTypeConvert.IsEmptyGuid(gITEM_ID)) CommonProcedure.InvoicesPAYMENTS_Delete(gITEM_ID); } } foreach (DataRow row in dtLineItems.Rows) { if (row.RowState != DataRowState.Deleted) { Guid gITEM_ID = CommonTypeConvert.ToGuid(row["ID"]); Guid gINVOICE_ID = CommonTypeConvert.ToGuid(row["INVOICE_ID"]); Decimal dINVOICE_AMOUNT = CommonTypeConvert.ToDecimal(row["AMOUNT"]); if (!CommonTypeConvert.IsEmptyGuid(gINVOICE_ID)) { CommonProcedure.InvoicesPAYMENTS_Update (ref gITEM_ID , gINVOICE_ID , gID , dINVOICE_AMOUNT ); if (sbINVOICE_NUMBER.Length > 0) sbINVOICE_NUMBER.Append(","); sbINVOICE_NUMBER.Append(gINVOICE_ID.ToString()); } } } ViewState["ID"] = gID; if (e.CommandName == "Charge") { sbINVOICE_NUMBER.Append(" " + DateTime.UtcNow); //CRM.Common.Charge.CC.Charge(Application, gID, gCURRENCY_ID, gACCOUNT_ID, gCREDIT_CARD_ID, Request.UserHostAddress, sbINVOICE_NUMBER.ToString(), sDESCRIPTION, dAMOUNT); } Response.Redirect("view.aspx?ID=" + gID); } } else if (e.CommandName == "Cancel") { if (CommonTypeConvert.IsEmptyGuid(gID)) Response.Redirect("Index.aspx"); else Response.Redirect("view.aspx?ID=" + gID); } }
protected void PAYMENT_TYPE_Changed(object sender, EventArgs e) { var PAYMENT_TYPE = tblMain.FindControl("PAYMENT_TYPE") as DropDownList; if (PAYMENT_TYPE != null) { bool bCreditCard = PAYMENT_TYPE.SelectedValue == "Credit Card"; ctlDynamicButtons.ShowButton("Charge", bCreditCard); new DynamicControl(this, "CREDIT_CARD_ID_LABEL").Visible = bCreditCard; new DynamicControl(this, "CREDIT_CARD_NAME").Visible = bCreditCard; new DynamicControl(this, "CREDIT_CARD_ID_btnChange").Visible = bCreditCard; new DynamicControl(this, "CREDIT_CARD_ID_btnClear").Visible = bCreditCard; if (bCreditCard && CommonTypeConvert.IsEmptyGuid(new DynamicControl(this, "CREDIT_CARD_ID").ID)) { var oQuery = new InlineQueryDBManager(); string innerSql = ApplicationSQL.SQL["Payments_EditView_214"].ToString(); oQuery.CommandText = innerSql; Guid gACCOUNT_ID = new DynamicControl(this, "ACCOUNT_ID").ID; TypeConvert.AppendParameter(oQuery, gACCOUNT_ID, "ACCOUNT_ID", false); using (SqlDataReader rdr = oQuery.ExecuteReader(CommandBehavior.SingleRow)) { if (rdr.Read()) { new DynamicControl(this, "CREDIT_CARD_ID").ID = CommonTypeConvert.ToGuid(rdr["ID"]); new DynamicControl(this, "CREDIT_CARD_NAME").Text = CommonTypeConvert.ToString(rdr["NAME"]); } } } } }
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 (CommonTypeConvert.IsEmptyGuid(gID)) gID = CommonTypeConvert.ToGuid(ViewState["ID"]); if (!IsPostBack) { Guid gDuplicateID = CommonTypeConvert.ToGuid(Request["DuplicateID"]); if (!CommonTypeConvert.IsEmptyGuid(gID) || !CommonTypeConvert.IsEmptyGuid(gDuplicateID)) { var oQuery = new InlineQueryDBManager(); string innerSql = ApplicationSQL.SQL["Payments_EditView_259"].ToString(); oQuery.CommandText = innerSql; CRMSecurity.Filter(oQuery, m_sMODULE, "edit"); if (!CommonTypeConvert.IsEmptyGuid(gDuplicateID)) { TypeConvert.AppendParameter(oQuery, gDuplicateID, "ID", false); gID = Guid.Empty; } else { TypeConvert.AppendParameter(oQuery, gID, "ID", false); } using (SqlDataReader rdr = oQuery.ExecuteReader(CommandBehavior.SingleRow)) { if (rdr.Read()) { ctlModuleHeader.Title = CommonTypeConvert.ToString(rdr["PAYMENT_NUM"]); 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); ctlDynamicButtons.AppendButtons(m_sMODULE + ".EditView", CommonTypeConvert.ToGuid(rdr["ASSIGNED_USER_ID"]), rdr); var CURRENCY_ID = tblMain.FindControl("CURRENCY_ID") as DropDownList; if (CURRENCY_ID != null) { CURRENCY_ID.AutoPostBack = true; CURRENCY_ID.SelectedIndexChanged += CURRENCY_ID_Changed; } var PAYMENT_TYPE = tblMain.FindControl("PAYMENT_TYPE") as DropDownList; if (PAYMENT_TYPE != null) { PAYMENT_TYPE.AutoPostBack = true; PAYMENT_TYPE.SelectedIndexChanged += PAYMENT_TYPE_Changed; PAYMENT_TYPE_Changed(null, null); } Guid gACCOUNT_ID = CommonTypeConvert.ToGuid(rdr["ACCOUNT_ID"]); ctlAllocationsView.LoadLineItems(gID, gACCOUNT_ID, gDuplicateID, oQuery, rdr); } else { Guid gPARENT_ID = CommonTypeConvert.ToGuid(Request["PARENT_ID"]); ctlAllocationsView.LoadLineItems(gID, gPARENT_ID, gDuplicateID, oQuery, null); ctlDynamicButtons.AppendButtons(m_sMODULE + ".EditView", Guid.Empty, null); ctlDynamicButtons.DisableAll(); ctlDynamicButtons.ErrorText = Translation.GetTranslation.Term("ACL.LBL_NO_ACCESS"); } } } else { AppendEditViewFields(m_sMODULE + ".EditView", tblMain, null); ctlDynamicButtons.AppendButtons(m_sMODULE + ".EditView", Guid.Empty, null); var CURRENCY_ID = tblMain.FindControl("CURRENCY_ID") as DropDownList; if (CURRENCY_ID != null) { CURRENCY_ID.AutoPostBack = true; CURRENCY_ID.SelectedIndexChanged += CURRENCY_ID_Changed; } Guid gACCOUNT_ID = Guid.Empty; Guid gPARENT_ID = CommonTypeConvert.ToGuid(Request["PARENT_ID"]); new DynamicControl(this, "PAYMENT_DATE").DateValue = DateTime.Today; Guid gINVOICE_ID = gPARENT_ID; if (!CommonTypeConvert.IsEmptyGuid(gPARENT_ID)) { string sMODULE = String.Empty; string sPARENT_TYPE = String.Empty; string sPARENT_NAME = String.Empty; CommonProcedure.ParentGet(ref gPARENT_ID, ref sMODULE, ref sPARENT_TYPE, ref sPARENT_NAME); if (!CommonTypeConvert.IsEmptyGuid(gPARENT_ID) && sMODULE == "Accounts") { gACCOUNT_ID = gPARENT_ID; new DynamicControl(this, "ACCOUNT_ID").ID = gPARENT_ID; new DynamicControl(this, "ACCOUNT_NAME").Text = sPARENT_NAME; var oQuery = new InlineQueryDBManager(); ctlAllocationsView.LoadLineItems(gID, gACCOUNT_ID, gDuplicateID, oQuery, null); } else if (!CommonTypeConvert.IsEmptyGuid(gINVOICE_ID)) { var oQuery = new InlineQueryDBManager(); string innerSql = ApplicationSQL.SQL["Payments_EditView"].ToString(); oQuery.CommandText = innerSql; CRMSecurity.Filter(oQuery, "Invoices", "edit"); TypeConvert.AppendParameter(oQuery, gINVOICE_ID, "ID", false); using (SqlDataReader rdr = oQuery.ExecuteReader(CommandBehavior.SingleRow)) { if (rdr.Read()) { gACCOUNT_ID = CommonTypeConvert.ToGuid(rdr["BILLING_ACCOUNT_ID"]); new DynamicControl(this, "ACCOUNT_ID").ID = CommonTypeConvert.ToGuid(rdr["BILLING_ACCOUNT_ID"]); new DynamicControl(this, "ACCOUNT_NAME").Text = CommonTypeConvert.ToString(rdr["BILLING_ACCOUNT_NAME"]); ctlAllocationsView.LoadLineItems(gID, gACCOUNT_ID, gDuplicateID, oQuery, null); new DynamicControl(this, "AMOUNT").Text = Currency.GetCurrency.ToCurrency( CommonTypeConvert.ToDecimal(rdr["AMOUNT_DUE_USDOLLAR"])).ToString("0.00"); } } } } var PAYMENT_TYPE = tblMain.FindControl("PAYMENT_TYPE") as DropDownList; if (PAYMENT_TYPE != null) { PAYMENT_TYPE.AutoPostBack = true; PAYMENT_TYPE.SelectedIndexChanged += PAYMENT_TYPE_Changed; PAYMENT_TYPE_Changed(null, null); } } } else { ctlModuleHeader.Title = CommonTypeConvert.ToString(ViewState["ctlModuleHeader.Title"]); SetPageTitle(Translation.GetTranslation.Term(".moduleList." + m_sMODULE) + " - " + ctlModuleHeader.Title); } }
protected void Page_Load(object sender, EventArgs e) { SetPageTitle(Translation.GetTranslation.Term(m_sMODULE + ".LBL_LIST_FORM_TITLE")); Visible = (Security.GetUserAccess(m_sMODULE, "list") >= 0); if (!Visible) return; if (IsMobile && grdMain.Columns.Count > 0) grdMain.Columns[0].Visible = false; var oQuery = new InlineQueryDBManager(); string innerSql = " from vwPRODUCTS_List" + ControlChars.CrLf; oQuery.CommandText = innerSql; CRMSecurity.Filter(oQuery, m_sMODULE, "list"); grdMain.OrderByClause("NAME", "asc"); ctlSearchView.SqlSearchClause(oQuery); oQuery.CommandText = "select " + (Request.Form[ctlExportHeader.ExportUniqueID] != null ? "*" : CommonTypeConvert.FormatSelectFields(arrSelectFields)) + oQuery.CommandText + grdMain.OrderByClause(); DataTable dt = oQuery.GetTable(); vwMain = dt.DefaultView; grdMain.DataSource = vwMain; if (!IsPostBack) { grdMain.DataBind(); } }
protected void Page_Command(Object sender, CommandEventArgs e) { Guid gORDER_ID = CommonTypeConvert.ToGuid(Request["ORDER_ID"]); Guid gQUOTE_ID = CommonTypeConvert.ToGuid(Request["QUOTE_ID"]); Guid gPARENT_ID = CommonTypeConvert.ToGuid(Request["PARENT_ID"]); string sMODULE = String.Empty; string sPARENT_TYPE = String.Empty; string sPARENT_NAME = String.Empty; CommonProcedure.ParentGet(ref gPARENT_ID, ref sMODULE, ref sPARENT_TYPE, ref sPARENT_NAME); if (e.CommandName == "Save") { ValidateEditViewFields(m_sMODULE + ".EditView"); ValidateEditViewFields(m_sMODULE + ".EditAddress"); ValidateEditViewFields(m_sMODULE + ".EditDescription"); if (Page.IsValid) { string sCUSTOM_MODULE = "INVOICES"; DataTable dtCustomFields = CRMCache.FieldsMetaData_Validated(sCUSTOM_MODULE); DataTable dtCustomLineItems = CRMCache.FieldsMetaData_UnvalidatedCustomFields(sCUSTOM_MODULE + "_LINE_ITEMS"); DataRow rowCurrent = null; var dtCurrent = new DataTable(); if (!CommonTypeConvert.IsEmptyGuid(gID)) { string innerSql = ApplicationSQL.SQL["Invoices_EditView_323"].ToString(); var oQuery = new InlineQueryDBManager(); oQuery.CommandText = innerSql; CRMSecurity.Filter(oQuery, m_sMODULE, "edit"); TypeConvert.AppendParameter(oQuery, gID, "ID", false); dtCurrent = oQuery.GetTable(); if (dtCurrent.Rows.Count > 0) { rowCurrent = dtCurrent.Rows[0]; } else { gID = Guid.Empty; } } ctlEditLineItemsView.UpdateTotals(); CommonProcedure.InvoicesUpdate (ref gID , new DynamicControl(this, rowCurrent, "ASSIGNED_USER_ID").ID , new DynamicControl(this, rowCurrent, "NAME").Text , new DynamicControl(this, rowCurrent, "QUOTE_ID").ID , new DynamicControl(this, rowCurrent, "ORDER_ID").ID , new DynamicControl(this, rowCurrent, "OPPORTUNITY_ID").ID , new DynamicControl(this, rowCurrent, "PAYMENT_TERMS").SelectedValue , new DynamicControl(this, rowCurrent, "INVOICE_STAGE").SelectedValue , new DynamicControl(this, rowCurrent, "PURCHASE_ORDER_NUM").Text , new DynamicControl(this, rowCurrent, "DUE_DATE").DateValue , new DynamicControl(ctlEditLineItemsView, rowCurrent, "EXCHANGE_RATE").FloatValue , new DynamicControl(ctlEditLineItemsView, rowCurrent, "CURRENCY_ID").ID , new DynamicControl(ctlEditLineItemsView, rowCurrent, "TAXRATE_ID").ID , new DynamicControl(ctlEditLineItemsView, rowCurrent, "SHIPPER_ID").ID , new DynamicControl(ctlEditLineItemsView, rowCurrent, "SUBTOTAL").DecimalValue , new DynamicControl(ctlEditLineItemsView, rowCurrent, "DISCOUNT").DecimalValue , new DynamicControl(ctlEditLineItemsView, rowCurrent, "SHIPPING").DecimalValue , new DynamicControl(ctlEditLineItemsView, rowCurrent, "TAX").DecimalValue , new DynamicControl(ctlEditLineItemsView, rowCurrent, "TOTAL").DecimalValue , new DynamicControl(ctlEditLineItemsView, rowCurrent, "AMOUNT_DUE").DecimalValue , new DynamicControl(this, rowCurrent, "BILLING_ACCOUNT_ID").ID , new DynamicControl(this, rowCurrent, "BILLING_CONTACT_ID").ID , new DynamicControl(this, rowCurrent, "BILLING_ADDRESS_STREET").Text , new DynamicControl(this, rowCurrent, "BILLING_ADDRESS_CITY").Text , new DynamicControl(this, rowCurrent, "BILLING_ADDRESS_STATE").Text , new DynamicControl(this, rowCurrent, "BILLING_ADDRESS_POSTALCODE").Text , new DynamicControl(this, rowCurrent, "BILLING_ADDRESS_COUNTRY").Text , new DynamicControl(this, rowCurrent, "SHIPPING_ACCOUNT_ID").ID , new DynamicControl(this, rowCurrent, "SHIPPING_CONTACT_ID").ID , new DynamicControl(this, rowCurrent, "SHIPPING_ADDRESS_STREET").Text , new DynamicControl(this, rowCurrent, "SHIPPING_ADDRESS_CITY").Text , new DynamicControl(this, rowCurrent, "SHIPPING_ADDRESS_STATE").Text , new DynamicControl(this, rowCurrent, "SHIPPING_ADDRESS_POSTALCODE").Text , new DynamicControl(this, rowCurrent, "SHIPPING_ADDRESS_COUNTRY").Text , new DynamicControl(this, rowCurrent, "DESCRIPTION").Text , new DynamicControl(this, rowCurrent, "TEAM_ID").ID ); CRMDynamic.UpdateCustomFields(this, gID, sCUSTOM_MODULE, dtCustomFields); DataTable dtLineItems = ctlEditLineItemsView.LineItems; foreach (DataRow row in dtLineItems.Rows) { if (row.RowState == DataRowState.Deleted) { Guid gITEM_ID = CommonTypeConvert.ToGuid(row["ID", DataRowVersion.Original]); if (!CommonTypeConvert.IsEmptyGuid(gITEM_ID)) CommonProcedure.InvoicesLINE_ITEMS_Delete(gITEM_ID); } } int nPOSITION = 1; foreach (DataRow row in dtLineItems.Rows) { if (row.RowState != DataRowState.Deleted) { Guid gITEM_ID = CommonTypeConvert.ToGuid(row["ID"]); Guid gLINE_GROUP_ID = CommonTypeConvert.ToGuid(row["LINE_GROUP_ID"]); string sLINE_ITEM_TYPE = CommonTypeConvert.ToString(row["LINE_ITEM_TYPE"]); string sNAME = CommonTypeConvert.ToString(row["NAME"]); string sMFT_PART_NUM = CommonTypeConvert.ToString(row["MFT_PART_NUM"]); string sVENDOR_PART_NUM = CommonTypeConvert.ToString(row["VENDOR_PART_NUM"]); Guid gPRODUCT_TEMPLATE_ID = CommonTypeConvert.ToGuid(row["PRODUCT_TEMPLATE_ID"]); string sTAX_CLASS = CommonTypeConvert.ToString(row["TAX_CLASS"]); int nQUANTITY = CommonTypeConvert.ToInteger(row["QUANTITY"]); Decimal dCOST_PRICE = CommonTypeConvert.ToDecimal(row["COST_PRICE"]); Decimal dLIST_PRICE = CommonTypeConvert.ToDecimal(row["LIST_PRICE"]); Decimal dUNIT_PRICE = CommonTypeConvert.ToDecimal(row["UNIT_PRICE"]); string sDESCRIPTION = CommonTypeConvert.ToString(row["DESCRIPTION"]); if (!CommonTypeConvert.IsEmptyGuid(gPRODUCT_TEMPLATE_ID) || !CommonTypeConvert.IsEmptyString(sNAME)) { CommonProcedure.InvoicesLINE_ITEMS_Update (ref gITEM_ID , gID , gLINE_GROUP_ID , sLINE_ITEM_TYPE , nPOSITION , sNAME , sMFT_PART_NUM , sVENDOR_PART_NUM , gPRODUCT_TEMPLATE_ID , sTAX_CLASS , nQUANTITY , dCOST_PRICE , dLIST_PRICE , dUNIT_PRICE , sDESCRIPTION ); CRMDynamic.UpdateCustomFields(row, gITEM_ID, sCUSTOM_MODULE + "_LINE_ITEMS", dtCustomLineItems); nPOSITION++; } } } CommonProcedure.InvoicesUpdateAmountDue(gID); if (!CommonTypeConvert.IsEmptyGuid(gPARENT_ID)) Response.Redirect("~/CRM/" + sMODULE + "/view.aspx?ID=" + gPARENT_ID); else Response.Redirect("view.aspx?ID=" + gID); } } else if (e.CommandName == "Cancel") { if (!CommonTypeConvert.IsEmptyGuid(gPARENT_ID)) Response.Redirect("~/CRM/" + sMODULE + "/view.aspx?ID=" + gPARENT_ID); else if (!CommonTypeConvert.IsEmptyGuid(gORDER_ID)) Response.Redirect("~/CRM/Orders/view.aspx?ID=" + gORDER_ID); else if (!CommonTypeConvert.IsEmptyGuid(gQUOTE_ID)) Response.Redirect("~/CRM/Quotes/view.aspx?ID=" + gQUOTE_ID); else if (CommonTypeConvert.IsEmptyGuid(gID)) Response.Redirect("Index.aspx"); else Response.Redirect("view.aspx?ID=" + gID); } }
public static void UpdateCustomFields(DataRow rowForm, Guid gID, string sCUSTOM_MODULE, DataTable dtCustomFields) { if (dtCustomFields.Rows.Count > 0) { InlineQueryDBManager oQuery = new InlineQueryDBManager(); oQuery.CommandText = "update " + sCUSTOM_MODULE + "_CSTM" + ControlChars.CrLf; int nFieldIndex = 0; foreach (DataRow row in dtCustomFields.Rows) { string sNAME = TypeConvert.ToString(row["NAME"]).ToUpper(); string sCsType = TypeConvert.ToString(row["CsType"]); int nMAX_SIZE = TypeConvert.ToInteger(row["MAX_SIZE"]); if (rowForm.Table.Columns.Contains(sNAME)) { if (nFieldIndex == 0) oQuery.CommandText += " set "; else oQuery.CommandText += " , "; oQuery.CommandText += sNAME + " = @" + sNAME + ControlChars.CrLf; SqlParameter oParam = new SqlParameter(); switch (sCsType) { case "Guid": oParam = new SqlParameter("@" + sNAME, SqlDbType.UniqueIdentifier); oParam.Value = TypeConvert.ToGuid(rowForm[sNAME]); break; case "short": oParam = new SqlParameter("@" + sNAME, SqlDbType.Int); oParam.Value = TypeConvert.ToInteger(rowForm[sNAME]); break; case "Int32": oParam = new SqlParameter("@" + sNAME, SqlDbType.Int); oParam.Value = TypeConvert.ToInteger(rowForm[sNAME]); break; case "Int64": oParam = new SqlParameter("@" + sNAME, SqlDbType.Int); oParam.Value = TypeConvert.ToInteger(rowForm[sNAME]); break; case "float": oParam = new SqlParameter("@" + sNAME, SqlDbType.Float); oParam.Value = TypeConvert.ToFloat(rowForm[sNAME]); break; case "decimal": oParam = new SqlParameter("@" + sNAME, SqlDbType.Decimal); oParam.Value = TypeConvert.ToDecimal(rowForm[sNAME]); break; case "bool": oParam = new SqlParameter("@" + sNAME, SqlDbType.Bit); oParam.Value = TypeConvert.ToBoolean(rowForm[sNAME]); break; case "DateTime": oParam = new SqlParameter("@" + sNAME, SqlDbType.DateTime); oParam.Value = TypeConvert.ToDateTime(rowForm[sNAME]); break; default: oParam = new SqlParameter("@" + sNAME, SqlDbType.NVarChar, nMAX_SIZE); oParam.Value = TypeConvert.ToString(rowForm[sNAME]); break; } nFieldIndex++; } } if (nFieldIndex > 0) { oQuery.CommandText += " where ID_C = @ID_C" + ControlChars.CrLf; SqlParameter oParamID = new SqlParameter("@ID_C", SqlDbType.UniqueIdentifier); oParamID.Value = gID; oQuery.CommandType = CommandType.Text; oQuery.ExecuteNonQuery(oQuery.CommandText); } } }
public void LoadLineItems(Guid gID, Guid gACCOUNT_ID, Guid gDuplicateID, InlineQueryDBManager oQuery, SqlDataReader rdr) { this.gACCOUNT_ID = gACCOUNT_ID; if (!IsPostBack) { GetCurrencyControl(); CURRENCY_ID.SelectedValue = Currency.GetCurrency.ID.ToString(); EXCHANGE_RATE.Value = Currency.GetCurrency.CONVERSION_RATE.ToString(); foreach (DataControlField col in grdMain.Columns) { if (!CommonTypeConvert.IsEmptyString(col.HeaderText)) { col.HeaderText = Translation.GetTranslation.Term(col.HeaderText); } var cf = col as CommandField; if (cf != null) { cf.EditText = Translation.GetTranslation.Term(cf.EditText); cf.DeleteText = Translation.GetTranslation.Term(cf.DeleteText); cf.UpdateText = Translation.GetTranslation.Term(cf.UpdateText); cf.CancelText = Translation.GetTranslation.Term(cf.CancelText); } } if ((!CommonTypeConvert.IsEmptyGuid(gID) || !CommonTypeConvert.IsEmptyGuid(gDuplicateID)) && (oQuery != null) && (rdr != null)) { CURRENCY_ID.SelectedValue = CommonTypeConvert.ToString(rdr["CURRENCY_ID"]); EXCHANGE_RATE.Value = Currency.GetCurrency.CONVERSION_RATE.ToString(); float fEXCHANGE_RATE = CommonTypeConvert.ToFloat(rdr["EXCHANGE_RATE"]); if (fEXCHANGE_RATE == 0.0f) fEXCHANGE_RATE = 1.0f; EXCHANGE_RATE.Value = fEXCHANGE_RATE.ToString(); if (CURRENCY_ID.Items.Count > 0) { Guid gCURRENCY_ID = CommonTypeConvert.ToGuid(CURRENCY_ID.SelectedValue); SetCurrency(gCURRENCY_ID, fEXCHANGE_RATE); EXCHANGE_RATE.Value = Currency.GetCurrency.CONVERSION_RATE.ToString(); } ALLOCATED.Text = Currency.GetCurrency.ToCurrency(CommonTypeConvert.ToDecimal(rdr["TOTAL_ALLOCATED_USDOLLAR"])). ToString("c"); ALLOCATED_USDOLLAR.Value = CommonTypeConvert.ToDecimal(rdr["TOTAL_ALLOCATED_USDOLLAR"]).ToString("0.00"); rdr.Close(); string innerSql = ApplicationSQL.SQL["Payments_AllocationsView_233"].ToString(); oQuery.CommandText = innerSql; TypeConvert.AppendParameter(oQuery, gID, "PAYMENT_ID", false); oQuery.CommandText += " order by DATE_MODIFIED asc" + ControlChars.CrLf; DataTable dtLineItems = oQuery.GetTable(); if (!CommonTypeConvert.IsEmptyGuid(gDuplicateID)) { foreach (DataRow row in dtLineItems.Rows) { row["ID"] = Guid.NewGuid(); } } DataRow rowNew = dtLineItems.NewRow(); dtLineItems.Rows.Add(rowNew); ViewState["LineItems"] = dtLineItems; grdMain.DataSource = dtLineItems; grdMain.EditIndex = dtLineItems.Rows.Count - 1; grdMain.DataBind(); } else { dtLineItems = new DataTable(); var colID = new DataColumn("ID", Type.GetType("System.Guid")); var colINVOICE_NAME = new DataColumn("INVOICE_NAME", Type.GetType("System.String")); var colINVOICE_ID = new DataColumn("INVOICE_ID", Type.GetType("System.Guid")); var colAMOUNT_DUE = new DataColumn("AMOUNT_DUE", Type.GetType("System.Decimal")); var colAMOUNT_DUE_USDOLLAR = new DataColumn("AMOUNT_DUE_USDOLLAR", Type.GetType("System.Decimal")); var colAMOUNT = new DataColumn("AMOUNT", Type.GetType("System.Decimal")); var colAMOUNT_USDOLLAR = new DataColumn("AMOUNT_USDOLLAR", Type.GetType("System.Decimal")); dtLineItems.Columns.Add(colID); dtLineItems.Columns.Add(colINVOICE_NAME); dtLineItems.Columns.Add(colINVOICE_ID); dtLineItems.Columns.Add(colAMOUNT_DUE); dtLineItems.Columns.Add(colAMOUNT_DUE_USDOLLAR); dtLineItems.Columns.Add(colAMOUNT); dtLineItems.Columns.Add(colAMOUNT_USDOLLAR); DataRow rowNew = null; string innerSql = ApplicationSQL.SQL["Payments_AllocationsView"].ToString(); oQuery.CommandText = innerSql; Guid gPARENT_ID = CommonTypeConvert.ToGuid(Request["PARENT_ID"]); TypeConvert.AppendParameter(oQuery, gPARENT_ID, "ID", false); using (SqlDataReader rdrInvoice = oQuery.ExecuteReader(CommandBehavior.SingleRow)) { if (rdrInvoice.Read()) { rowNew = dtLineItems.NewRow(); rowNew["INVOICE_NAME"] = CommonTypeConvert.ToString(rdrInvoice["NAME"]); rowNew["INVOICE_ID"] = CommonTypeConvert.ToGuid(rdrInvoice["ID"]); rowNew["AMOUNT_DUE"] = CommonTypeConvert.ToDecimal(rdrInvoice["AMOUNT_DUE"]); rowNew["AMOUNT_DUE_USDOLLAR"] = CommonTypeConvert.ToDecimal(rdrInvoice["AMOUNT_DUE_USDOLLAR"]); rowNew["AMOUNT"] = CommonTypeConvert.ToDecimal(rdrInvoice["AMOUNT_DUE"]); rowNew["AMOUNT_USDOLLAR"] = CommonTypeConvert.ToDecimal(rdrInvoice["AMOUNT_DUE_USDOLLAR"]); if (rdrInvoice["AMOUNT_DUE"] == DBNull.Value) { rowNew["AMOUNT_DUE"] = CommonTypeConvert.ToDecimal(rdrInvoice["TOTAL"]); rowNew["AMOUNT_DUE_USDOLLAR"] = CommonTypeConvert.ToDecimal(rdrInvoice["TOTAL_USDOLLAR"]); rowNew["AMOUNT"] = CommonTypeConvert.ToDecimal(rdrInvoice["TOTAL"]); rowNew["AMOUNT_USDOLLAR"] = CommonTypeConvert.ToDecimal(rdrInvoice["TOTAL_USDOLLAR"]); } dtLineItems.Rows.Add(rowNew); } } rowNew = dtLineItems.NewRow(); dtLineItems.Rows.Add(rowNew); ViewState["LineItems"] = dtLineItems; grdMain.DataSource = dtLineItems; grdMain.EditIndex = dtLineItems.Rows.Count - 1; grdMain.DataBind(); UpdateTotals(); } } }
public override void SqlSearchClause(InlineQueryDBManager oQuery) { TypeConvert.AppendParameter(oQuery, txtNAME.Text, 50, CommonTypeConvert.SqlFilterMode.StartsWith, "NAME"); }
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); } } } }
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) { string sLOAD_MODULE = "Invoices"; string sLOAD_MODULE_KEY = "INVOICE_ID"; Guid gQUOTE_ID = CommonTypeConvert.ToGuid(Request["QUOTE_ID"]); Guid gORDER_ID = CommonTypeConvert.ToGuid(Request["ORDER_ID"]); Guid gDuplicateID = CommonTypeConvert.ToGuid(Request["DuplicateID"]); if (!CommonTypeConvert.IsEmptyGuid(gID) || !CommonTypeConvert.IsEmptyGuid(gDuplicateID) || !CommonTypeConvert.IsEmptyGuid(gQUOTE_ID) || !CommonTypeConvert.IsEmptyGuid(gORDER_ID)) { string innerSql = ApplicationSQL.SQL["Invoices_EditView_323"].ToString(); var oQuery = new InlineQueryDBManager(); oQuery.CommandText = innerSql; if (!CommonTypeConvert.IsEmptyGuid(gQUOTE_ID)) { //Load the data from the QUOTES record. sLOAD_MODULE = "Quotes"; sLOAD_MODULE_KEY = "QUOTE_ID"; innerSql = ApplicationSQL.SQL["Invoices_EditView_333"].ToString(); oQuery.CommandText = innerSql; //Filter by the module we are loading. CRMSecurity.Filter(oQuery, sLOAD_MODULE, "edit"); TypeConvert.AppendParameter(oQuery, gQUOTE_ID, "ID", false); } else if (!CommonTypeConvert.IsEmptyGuid(gORDER_ID)) { // Load the data from the ORDERS record. sLOAD_MODULE = "Orders"; sLOAD_MODULE_KEY = "ORDER_ID"; innerSql = ApplicationSQL.SQL["Invoices_EditView"].ToString(); oQuery.CommandText = innerSql; //Filter by the module we are loading. CRMSecurity.Filter(oQuery, sLOAD_MODULE, "edit"); TypeConvert.AppendParameter(oQuery, gORDER_ID, "ID", false); } else { //Use new CRMSecurity.Filter() function to apply Team and ACL security rules. CRMSecurity.Filter(oQuery, m_sMODULE, "edit"); if (!CommonTypeConvert.IsEmptyGuid(gDuplicateID)) { TypeConvert.AppendParameter(oQuery, gDuplicateID, "ID", false); gID = Guid.Empty; } else { TypeConvert.AppendParameter(oQuery, gID, "ID", false); } } 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; ViewState["BILLING_ACCOUNT_ID"] = CommonTypeConvert.ToGuid(rdr["BILLING_ACCOUNT_ID"]); ViewState["SHIPPING_ACCOUNT_ID"] = CommonTypeConvert.ToGuid(rdr["SHIPPING_ACCOUNT_ID"]); new DynamicControl(this, "QUOTE_ID").ID = CommonTypeConvert.ToGuid(rdr["QUOTE_ID"]); new DynamicControl(this, "ORDER_ID").ID = CommonTypeConvert.ToGuid(rdr["ORDER_ID"]); AppendEditViewFields(m_sMODULE + ".EditView", tblMain, rdr); AppendEditViewFields(m_sMODULE + ".EditAddress", tblAddress, rdr); AppendEditViewFields(m_sMODULE + ".EditDescription", tblDescription, rdr); //Dynamic buttons need to be recreated in order for events to fire. ctlDynamicButtons.AppendButtons(m_sMODULE + ".EditView", CommonTypeConvert.ToGuid(rdr["ASSIGNED_USER_ID"]), rdr); if (!CommonTypeConvert.IsEmptyGuid(gQUOTE_ID)) { new DynamicControl(this, "QUOTE_ID").ID = gQUOTE_ID; new DynamicControl(this, "QUOTE_NAME").Text = CommonTypeConvert.ToString(rdr["NAME"]); ctlEditLineItemsView.LoadLineItems(gQUOTE_ID, Guid.Empty, rdr, sLOAD_MODULE, sLOAD_MODULE_KEY); } else if (!CommonTypeConvert.IsEmptyGuid(gORDER_ID)) { new DynamicControl(this, "ORDER_ID").ID = gORDER_ID; new DynamicControl(this, "ORDER_NAME").Text = CommonTypeConvert.ToString(rdr["NAME"]); ctlEditLineItemsView.LoadLineItems(gORDER_ID, Guid.Empty, rdr, sLOAD_MODULE, sLOAD_MODULE_KEY); } else { ctlEditLineItemsView.LoadLineItems(gID, gDuplicateID, rdr, sLOAD_MODULE, sLOAD_MODULE_KEY); } } else { ctlEditLineItemsView.LoadLineItems(gID, gDuplicateID, null, String.Empty, String.Empty); //If item is not visible, then don't allow save //Dynamic buttons need to be recreated in order for events to fire. ctlDynamicButtons.AppendButtons(m_sMODULE + ".EditView", Guid.Empty, null); ctlDynamicButtons.DisableAll(); ctlDynamicButtons.ErrorText = Translation.GetTranslation.Term("ACL.LBL_NO_ACCESS"); } } } else { AppendEditViewFields(m_sMODULE + ".EditView", tblMain, null); AppendEditViewFields(m_sMODULE + ".EditAddress", tblAddress, null); AppendEditViewFields(m_sMODULE + ".EditDescription", tblDescription, null); //Dynamic buttons need to be recreated in order for events to fire. ctlDynamicButtons.AppendButtons(m_sMODULE + ".EditView", Guid.Empty, null); //Prepopulate the Account. Guid gPARENT_ID = CommonTypeConvert.ToGuid(Request["PARENT_ID"]); if (!CommonTypeConvert.IsEmptyGuid(gPARENT_ID)) { string sMODULE = String.Empty; string sPARENT_TYPE = String.Empty; string sPARENT_NAME = String.Empty; CommonProcedure.ParentGet(ref gPARENT_ID, ref sMODULE, ref sPARENT_TYPE, ref sPARENT_NAME); if (!CommonTypeConvert.IsEmptyGuid(gPARENT_ID) && sMODULE == "Accounts") { UpdateAccount(gPARENT_ID, true, true); } if (!CommonTypeConvert.IsEmptyGuid(gPARENT_ID) && sMODULE == "Contacts") { UpdateContact(gPARENT_ID, true, true); } else if (!CommonTypeConvert.IsEmptyGuid(gPARENT_ID) && sMODULE == "Opportunities") { new DynamicControl(this, "OPPORTUNITY_ID").ID = gPARENT_ID; new DynamicControl(this, "OPPORTUNITY_NAME").Text = sPARENT_NAME; } } ctlEditLineItemsView.LoadLineItems(gID, gDuplicateID, new InlineQueryDBManager(), null, String.Empty, String.Empty); } } else { // When validation fails, the header title does not retain its value. Update manually. ctlModuleHeader.Title = CommonTypeConvert.ToString(ViewState["ctlModuleHeader.Title"]); SetPageTitle(Translation.GetTranslation.Term(".moduleList." + m_sMODULE) + " - " + ctlModuleHeader.Title); var ctlBILLING_ACCOUNT_ID = new DynamicControl(this, "BILLING_ACCOUNT_ID"); var ctlSHIPPING_ACCOUNT_ID = new DynamicControl(this, "SHIPPING_ACCOUNT_ID"); if (CommonTypeConvert.ToGuid(ViewState["BILLING_ACCOUNT_ID"]) != ctlBILLING_ACCOUNT_ID.ID) { UpdateAccount(ctlBILLING_ACCOUNT_ID.ID, true, true); ViewState["BILLING_ACCOUNT_ID"] = ctlBILLING_ACCOUNT_ID.ID; ViewState["SHIPPING_ACCOUNT_ID"] = ctlBILLING_ACCOUNT_ID.ID; } if (CommonTypeConvert.ToGuid(ViewState["SHIPPING_ACCOUNT_ID"]) != ctlSHIPPING_ACCOUNT_ID.ID) { UpdateAccount(ctlSHIPPING_ACCOUNT_ID.ID, false, true); ViewState["SHIPPING_ACCOUNT_ID"] = ctlSHIPPING_ACCOUNT_ID.ID; } } }