コード例 #1
0
 protected void Page_Command(object sender, CommandEventArgs e)
 {
     try
     {
         if (e.CommandName == "AdvancedSearch")
         {
             Response.Redirect("default.aspx?Advanced=1");
         }
         else if (e.CommandName == "BasicSearch")
         {
             Response.Redirect("default.aspx?Advanced=0");
         }
         else if (e.CommandName == "Clear")
         {
             ctlSearch.ClearForm();
             Server.Transfer("default.aspx?Advanced=" + nAdvanced.ToString());
         }
         else if (e.CommandName == "Search")
         {
             // 10/13/2005 Paul.  Make sure to clear the page index prior to applying search.
             grdMain.CurrentPageIndex = 0;
             grdMain.ApplySort();
             grdMain.DataBind();
         }
         else if (e.CommandName == "MassUpdate")
         {
             string[] arrID = Request.Form.GetValues("chkMain");
             if (arrID != null)
             {
                 string sIDs = Utils.ValidateIDs(arrID);
                 sIDs = Utils.FilterByACL(m_sMODULE, "edit", arrID, "CAMPAIGNS");
                 if (!Sql.IsEmptyString(sIDs))
                 {
                     // 07/09/2006 Paul.  The date conversion was moved out of the MassUpdate control.
                     SqlProcs.spCAMPAIGNS_MassUpdate(sIDs, ctlMassUpdate.ASSIGNED_USER_ID, T10n.ToServerTime(ctlMassUpdate.START_DATE), T10n.ToServerTime(ctlMassUpdate.END_DATE), ctlMassUpdate.STATUS, ctlMassUpdate.CAMPAIGN_TYPE);
                     Response.Redirect("default.aspx");
                 }
             }
         }
         else if (e.CommandName == "MassDelete")
         {
             string[] arrID = Request.Form.GetValues("chkMain");
             if (arrID != null)
             {
                 string sIDs = Utils.ValidateIDs(arrID);
                 sIDs = Utils.FilterByACL(m_sMODULE, "delete", arrID, "CAMPAIGNS");
                 if (!Sql.IsEmptyString(sIDs))
                 {
                     SqlProcs.spCAMPAIGNS_MassDelete(sIDs);
                     Response.Redirect("default.aspx");
                 }
             }
         }
     }
     catch (Exception ex)
     {
         SplendidError.SystemError(new StackTrace(true).GetFrame(0), ex.Message);
         lblError.Text = ex.Message;
     }
 }
コード例 #2
0
 protected void Page_Command(object sender, CommandEventArgs e)
 {
     try
     {
         if (e.CommandName == "AdvancedSearch")
         {
             Response.Redirect("default.aspx?Advanced=1");
         }
         else if (e.CommandName == "BasicSearch")
         {
             Response.Redirect("default.aspx?Advanced=0");
         }
         else if (e.CommandName == "Clear")
         {
             ctlSearch.ClearForm();
             Server.Transfer("default.aspx?Advanced=" + nAdvanced.ToString());
         }
         else if (e.CommandName == "Search")
         {
             // 10/13/2005 Paul.  Make sure to clear the page index prior to applying search.
             grdMain.CurrentPageIndex = 0;
             grdMain.ApplySort();
             grdMain.DataBind();
         }
     }
     catch (Exception ex)
     {
         SplendidError.SystemError(new StackTrace(true).GetFrame(0), ex.Message);
         lblError.Text = ex.Message;
     }
 }
コード例 #3
0
 protected void Page_Command(object sender, CommandEventArgs e)
 {
     try
     {
         if (e.CommandName == "Clear")
         {
             ctlSearch.ClearForm();
             Server.Transfer("default.aspx");
         }
         else if (e.CommandName == "Search")
         {
             // 10/13/2005 Paul.  Make sure to clear the page index prior to applying search.
             grdMain.CurrentPageIndex = 0;
             grdMain.ApplySort();
             grdMain.DataBind();
         }
         else if (e.CommandName == "ACLRole.MakeDefault")
         {
             // 08/08/2006 Paul.  Update the config value.
             string sNAME     = "default_role";
             string sCATEGORY = "system";
             string sVALUE    = Sql.ToString(e.CommandArgument);
             SqlProcs.spCONFIG_Update(sCATEGORY, sNAME, sVALUE);
             Application["CONFIG." + sNAME] = sVALUE;
             Response.Redirect("default.aspx");
         }
         else if (e.CommandName == "ACLRole.Delete")
         {
             Guid gID = Sql.ToGuid(e.CommandArgument);
             SqlProcs.spACL_ROLES_Delete(gID);
             grdMain.CurrentPageIndex = 0;
             grdMain.ApplySort();
             grdMain.DataBind();
             Response.Redirect("default.aspx");
         }
         else if (e.CommandName == "MassDelete")
         {
             string[] arrID = Request.Form.GetValues("chkMain");
             if (arrID != null)
             {
                 string sIDs = Utils.ValidateIDs(arrID);
                 if (!Sql.IsEmptyString(sIDs))
                 {
                     SqlProcs.spACL_ROLES_MassDelete(sIDs);
                     Response.Redirect("default.aspx");
                 }
             }
         }
     }
     catch (Exception ex)
     {
         SplendidError.SystemError(new StackTrace(true).GetFrame(0), ex);
         lblError.Text = ex.Message;
     }
 }
コード例 #4
0
 protected void Page_Command(object sender, CommandEventArgs e)
 {
     try
     {
         if (e.CommandName == "Clear")
         {
             ctlSearch.ClearForm();
             Server.Transfer("default.aspx?Advanced=" + nAdvanced.ToString());
         }
         else if (e.CommandName == "Search")
         {
             // 10/13/2005 Paul.  Make sure to clear the page index prior to applying search.
             grdMain.CurrentPageIndex = 0;
             grdMain.ApplySort();
             grdMain.DataBind();
         }
         else if (e.CommandName == "MassUpdate")
         {
             string[] arrID = Request.Form.GetValues("chkMain");
             if (arrID != null)
             {
                 string sIDs = Utils.ValidateIDs(arrID);
                 sIDs = Utils.FilterByACL(m_sMODULE, "edit", arrID, "NOTES");
                 if (!Sql.IsEmptyString(sIDs))
                 {
                     SqlProcs.spNOTES_MassUpdate(sIDs, ctlMassUpdate.PARENT_TYPE, ctlMassUpdate.PARENT_ID, ctlMassUpdate.CONTACT_ID);
                     Response.Redirect("default.aspx");
                 }
             }
         }
         else if (e.CommandName == "MassDelete")
         {
             string[] arrID = Request.Form.GetValues("chkMain");
             if (arrID != null)
             {
                 string sIDs = Utils.ValidateIDs(arrID);
                 sIDs = Utils.FilterByACL(m_sMODULE, "delete", arrID, "NOTES");
                 if (!Sql.IsEmptyString(sIDs))
                 {
                     SqlProcs.spNOTES_MassDelete(sIDs);
                     Response.Redirect("default.aspx");
                 }
             }
         }
     }
     catch (Exception ex)
     {
         SplendidError.SystemError(new StackTrace(true).GetFrame(0), ex.Message);
         lblError.Text = ex.Message;
     }
 }
コード例 #5
0
 protected void Page_Command(object sender, CommandEventArgs e)
 {
     try
     {
         if (e.CommandName == "Clear")
         {
             ctlSearch.ClearForm();
             Server.Transfer("default.aspx");
         }
         else if (e.CommandName == "Search")
         {
             // 10/13/2005 Paul.  Make sure to clear the page index prior to applying search.
             grdMain.CurrentPageIndex = 0;
             grdMain.ApplySort();
             grdMain.DataBind();
         }
         else if (e.CommandName == "Teams.Delete")
         {
             Guid gID = Sql.ToGuid(e.CommandArgument);
             SqlProcs.spTEAMS_Delete(gID);
             grdMain.CurrentPageIndex = 0;
             grdMain.ApplySort();
             grdMain.DataBind();
             Response.Redirect("default.aspx");
         }
         else if (e.CommandName == "MassDelete")
         {
             string[] arrID = Request.Form.GetValues("chkMain");
             if (arrID != null)
             {
                 string sIDs = Utils.ValidateIDs(arrID);
                 if (!Sql.IsEmptyString(sIDs))
                 {
                     SqlProcs.spTEAMS_MassDelete(sIDs);
                     Response.Redirect("default.aspx");
                 }
             }
         }
     }
     catch (Exception ex)
     {
         SplendidError.SystemError(new StackTrace(true).GetFrame(0), ex);
         lblError.Text = ex.Message;
     }
 }
コード例 #6
0
        protected void Page_Command(object sender, CommandEventArgs e)
        {
            try
            {
                if (e.CommandName == "Clear")
                {
                    ctlSearch.ClearForm();
                    Server.Transfer("default.aspx");
                }
                else if (e.CommandName == "Search")
                {
                    // 10/13/2005 Paul.  Make sure to clear the page index prior to applying search.
                    grdMain.CurrentPageIndex = 0;
                    grdMain.ApplySort();
                    grdMain.DataBind();
                }
                else if (e.CommandName == "Export")
                {
                    string[] arrTABLES = Request.Form.GetValues("chkMain");
                    if (arrTABLES != null)
                    {
                        DbProviderFactory dbf = DbProviderFactories.GetFactory();
                        using (IDbConnection con = dbf.CreateConnection())
                        {
                            con.Open();

                            int           nErrors = 0;
                            MemoryStream  stm     = new MemoryStream();
                            XmlTextWriter xw      = new XmlTextWriter(stm, Encoding.UTF8);
                            xw.Formatting  = Formatting.Indented;
                            xw.IndentChar  = ControlChars.Tab;
                            xw.Indentation = 1;
                            xw.WriteStartDocument();
                            xw.WriteStartElement("splendidcrm");
                            foreach (string sTABLE_NAME in arrTABLES)
                            {
                                vwMain.RowFilter = "TABLE_NAME = '" + sTABLE_NAME + "'";
                                if (vwMain.Count > 0)
                                {
                                    try
                                    {
                                        using (IDbCommand cmd = con.CreateCommand())
                                        {
                                            cmd.CommandText = "select * from " + sTABLE_NAME;
                                            using (IDataReader rdr = cmd.ExecuteReader())
                                            {
                                                int nRecordCount = 0;
                                                while (rdr.Read())
                                                {
                                                    nRecordCount++;
                                                    xw.WriteStartElement(sTABLE_NAME.ToLower());
                                                    for (int nColumn = 0; nColumn < rdr.FieldCount; nColumn++)
                                                    {
                                                        xw.WriteStartElement(rdr.GetName(nColumn).ToLower());
                                                        if (!rdr.IsDBNull(nColumn))
                                                        {
                                                            switch (rdr.GetFieldType(nColumn).FullName)
                                                            {
                                                            case "System.Boolean":  xw.WriteString(rdr.GetBoolean(nColumn) ? "1" : "0");  break;

                                                            case "System.Single":  xw.WriteString(rdr.GetDouble(nColumn).ToString());  break;

                                                            case "System.Double":  xw.WriteString(rdr.GetDouble(nColumn).ToString());  break;

                                                            case "System.Int16":  xw.WriteString(rdr.GetInt16(nColumn).ToString());  break;

                                                            case "System.Int32":  xw.WriteString(rdr.GetInt32(nColumn).ToString());  break;

                                                            case "System.Int64":  xw.WriteString(rdr.GetInt64(nColumn).ToString());  break;

                                                            case "System.Decimal":  xw.WriteString(rdr.GetDecimal(nColumn).ToString());  break;

                                                            case "System.DateTime":  xw.WriteString(rdr.GetDateTime(nColumn).ToUniversalTime().ToString(CalendarControl.SqlDateTimeFormat));  break;

                                                            case "System.Guid":  xw.WriteString(rdr.GetGuid(nColumn).ToString().ToUpper());  break;

                                                            case "System.String":  xw.WriteString(rdr.GetString(nColumn));  break;

                                                            case "System.Byte[]":
                                                            {
                                                                Byte[] buffer = rdr.GetValue(nColumn) as Byte[];
                                                                xw.WriteBase64(buffer, 0, buffer.Length);
                                                                break;
                                                            }

                                                            default:
                                                                throw(new Exception("Unsupported field type: " + rdr.GetFieldType(nColumn).FullName));
                                                            }
                                                        }
                                                        xw.WriteEndElement();
                                                    }
                                                    xw.WriteEndElement();
                                                }
                                                vwMain[0]["TABLE_STATUS"] = String.Format(L10n.Term("Export.LBL_RECORDS"), nRecordCount);
                                            }
                                        }
                                    }
                                    catch (Exception ex)
                                    {
                                        nErrors++;
                                        vwMain[0]["TABLE_STATUS"] = ex.Message;
                                    }
                                }
                            }
                            xw.WriteEndElement();
                            xw.WriteEndDocument();
                            xw.Flush();
                            if (nErrors == 0)
                            {
                                Response.ContentType = "text/xml";
                                Response.AddHeader("Content-Disposition", "attachment;filename=Export.xml");
                                stm.WriteTo(Response.OutputStream);
                                Response.End();
                            }
                            vwMain.RowFilter = null;
                            grdMain.DataBind();
                        }
                    }
                }
                else if (e.CommandName == "Cancel")
                {
                    Response.Redirect("~/Administration/default.aspx");
                }
            }
            catch (Exception ex)
            {
                SplendidError.SystemError(new StackTrace(true).GetFrame(0), ex);
                lblError.Text = Server.HtmlEncode(ex.Message);
            }
        }