C# Discussion Boards - CodeProject

Advanced TypeScript Programming Projects

1-Aug-22 7:02

I wouldn't "null" a relation in one case and not another. I'd create one "default" ("blank") EqInfo record to be used in those cases when Equipemnt "has none". The "reserved" InfoId could be "0" or "1"; so you use that for filtering the existence of an "actual" EqInfo's.

"Before entering on an understanding, I have meditated for a long time, and have foreseen what might happen. It is not genius which reveals to me suddenly, secretly, what I have to say or to do in a circumstance unexpected by other people; it is reflection, it is meditation." - Napoleon I

Mocking HttpContext

SreeRama Govind31-Jul-22 17:26

SreeRama Govind

31-Jul-22 17:26

Hi All,

need to right a test case for webapi which is used to upload a excel sheet. currently to get file into webpai using code like HttpFileCollection file = HttpContext.Current.Request.Files;
Now to write test case for the webapi(with Moq), need to mock HttpContext.Current.Request.Files, this should have data as same as uploading excel file (even its ok to read from share location).

Please suggest the code sample or any working code.

Thanks in Advance.

Re: Mocking HttpContext

Pete O'Hanlon1-Aug-22 23:26

Pete O'Hanlon

1-Aug-22 23:26

Mocking HttpContext is fairly straightforward. I wrote a github project and described how to use it in this article. Easy HttpClient Testing with Goldlight.HttpClientTestSupport[^]

Re: Mocking HttpContext

SreeRama Govind3-Aug-22 8:59

SreeRama Govind

3-Aug-22 8:59

Thanks for the reply, but this article not suitable for requirements.
while uploading a excel sheet, in webapi assigning this file to HttpFileCollection = HttpContext.Current.Request.Files, now need to mock HttpContext.Current.Request.Files which is having same excel file data to continue the code testing.

ControlDesigner issue

mo149230-Jul-22 0:51

30-Jul-22 0:51

Not sure if this is the correct group for this question but I am working with C#.
I'm migrating from VS2005 to VS2022 and having problem with ControlDesigner in my Control. It seems that the ControlDesigner is not functioning. I'm not too familiar with ControlDesigner programming so after working on this for a while I decided to start from scratch. I found an example in Microsoft Help Viewer for ControlDesigner. I copied and pasted the example code into a project UserControl1 and it too does not seem to function. When moving the mouse over the control the outline does not highlight and also the OutlineColor property is not shown in the Properties window.
Can someone help? Below is the sample code from Help Viewer. The only difference the test control is called UserControl1
Thank you.

using System.ComponentModel;

namespace TestApp
{
    // ExampleControlDesigner is an example control designer that 
    // demonstrates basic functions of a ControlDesigner. 
    public class ExampleControlDesigner : System.Windows.Forms.Design.ControlDesigner
    {
        // This Boolean state reflects whether the mouse is over the control.
        private bool mouseover = false;
        // This color is a private field for the OutlineColor property.
        private Color lineColor = Color.White;

        // This color is used to outline the control when the mouse is 
        // over the control.
        public Color OutlineColor
        {
            get
            {
                return lineColor;
            }
            set
            {
                lineColor = value;
            }
        }

        public ExampleControlDesigner()
        {
        }

        // Sets a value and refreshes the control's display when the 
        // mouse position enters the area of the control.
        protected override void OnMouseEnter()
        {
            this.mouseover = true;
            this.Control.Refresh();
        }

        // Sets a value and refreshes the control's display when the 
        // mouse position enters the area of the control.        
        protected override void OnMouseLeave()
        {
            this.mouseover = false;
            this.Control.Refresh();
        }

        // Draws an outline around the control when the mouse is 
        // over the control.    
        protected override void OnPaintAdornments(System.Windows.Forms.PaintEventArgs pe)
        {
            if (this.mouseover)
            {
                pe.Graphics.DrawRectangle(
                    new Pen(new SolidBrush(this.lineColor), 6),
                    0,
                    0,
                    this.Control.Size.Width,
                    this.Control.Size.Height);
            }
        }

        // Adds a property to this designer's control at design time 
        // that indicates the outline color to use. 
        // The DesignOnlyAttribute ensures that the OutlineColor
        // property is not serialized by the designer.
        protected override void PreFilterProperties(System.Collections.IDictionary properties)
        {
            PropertyDescriptor pd = TypeDescriptor.CreateProperty(
                typeof(ExampleControlDesigner),
                "OutlineColor",
                typeof(System.Drawing.Color),
                new Attribute[] { new DesignOnlyAttribute(true) });

            properties.Add("OutlineColor", pd);
        }
    }

    // This example control demonstrates the ExampleControlDesigner.
    [DesignerAttribute(typeof(ExampleControlDesigner))]
    public partial class UserControl1 : UserControl
    {
        public UserControl1()
        {
            InitializeComponent();
        }
    }
}

modified 30-Jul-22 7:42am.

Gerry Schmitz30-Jul-22 5:04

30-Jul-22 5:04

Here's the same code; only more complete, it seems.

ControlDesigner Class (System.Windows.Forms.Design) | Microsoft Docs

mo149230-Jul-22 7:35

30-Jul-22 7:35

Yes this is the example where a copied the test code from. I tried this example 'as is' but it did not work.
The code in my question is the same; It just uses a UserControl1 that I created in my test project while debugging.
I did not include the UserControl1.Designer.cs code which includes the other code.
Thank you

Gerry Schmitz30-Jul-22 14:49

30-Jul-22 14:49

It's not the same; it does not have / or you removed the disposing code.

Or did you think it just wasn't important so it's: "as is"?

mo149231-Jul-22 6:43

how to save Image or Bitmap to svg file

31-Jul-22 6:43

I'm sorry for the confusion. There are 2 files to a UserControl when created from the application:
In this case
UserControl1.cs
UserControl1.Designer.cs

The latter file contains the standard Dispose() code which I did not supply since it's just standard code.

For arguments sake, I started with the code you referenced 'as is'.. That means I copied and pasted the whole sample into a project file, built it, and tried it by loading it into a from from the toolbox; it did not function as described...

1. When the mouse moves into the control, the control does not show the highlight the border as the MouseEnter() method should do.
2. The property that is added in the designer "OutlineColor" does not show in the grid properties.

I've managed to get the debugger to work in DesignMode and set a break points in the MouseEnter() method and the OutLineColor.Set property and the OnPaintAdornments() method. None of the break points are hit when the control is loaded into the form.

thanks

Le@rner29-Jul-22 1:51

Le@rner

29-Jul-22 1:51

can anybody guide me

how to save Image or Bitmap to svg file

thanks

Re: how to save Image or Bitmap to svg file

OriginalGriff29-Jul-22 2:19

Re: how to save Image or Bitmap to svg file

29-Jul-22 2:19

.NET doesn't natively support SVG files - you will have to use an addon.
Try An SVG framework in C# and an SVG-GDI+ bridge[^] or start reading: How to Create SVG Files Programmatically in C# .NET | GCDocuments[^]

"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!

Gerry Schmitz29-Jul-22 8:38

Re: how to save Image or Bitmap to svg file

29-Jul-22 8:38

You can't: one uses pixels (bitmap); the other uses vector graphics (xml).

Calin Negru30-Jul-22 2:42

Calin Negru

30-Jul-22 2:42

is Image a file format for saving textures? I might have heard of the "img" as file format but I`m not absolutely confident.

Can you use sqlite in vs2022? CLOSED

mo149228-Jul-22 13:18

Re: Can you use sqlite in vs2022? CLOSED

28-Jul-22 13:18

I Knew if I asked the question I would get it to work. I tried a different nuget package,
specifically System.Data.SQLite and now it works. Sorry for the bogus post.

I've just upgraded to VS2022 from VS2005 so I am sort of lost. I've tried several methods from
suggestions on the internet and still have not been able to add a reference to sqlite in my
test project. When I try to manually add the sqlite3.dll I get a message saying the dll is immutable.

Articles on the internet seem to suggest you can use it but I can't find a way to add a reference.

Can someony help?
Thanks

-- modified 28-Jul-22 20:11pm.

OriginalGriff28-Jul-22 19:00

C# Set voice in Text to Speech

28-Jul-22 19:00

mo1492 wrote:
I Knew if I asked the question I would get it to work.

That's the way if goes, sometimes - it's known as Rubber Duck Debugging[^] Laugh | :laugh:

Rockallica27-Jul-22 17:02

Rockallica

27-Jul-22 17:02

Hi,

How do I set the voice in Text to Speech in C#?

I have a toolStripMenu that I load the voices into. Then when one is chosen, I want it to use that voice. Haven't been able to figure set the voice to the chosen name.

Thanks.

private void Get_Voices()
{
    ISpeechObjectTokens voices = objSpeech.GetVoices("", "");

    foreach (ISpeechObjectToken v in voices)
    {
              ts_Menu = new ToolStripMenuItem();

               v_name = v.GetDescription(0);
   
               ts_Menu.Text = v_name;

               ts_Menu.CheckOnClick = true;

               voicesToolStripMenu.DropDownItems.Add(ts_Menu);
               
                ts_Menu.Click += voice_Menu_Click;
     }
}
 
private void voice_Menu_Click(object sender, EventArgs e)
{
         ToolStripMenuItem item = sender as ToolStripMenuItem;
          foreach (ToolStripMenuItem tempItemp in voicesToolStripMenu.DropDownItems)
          {

             if (tempItemp == item)
             {
                   tempItemp.Checked = true;
              } 
               else
               {
                   tempItemp.Checked = false;
                } 
           }

           choosen_voice = sender.ToString();

}

private void Speak(string txt)
{
   
     SpVoice objSpeech = new SpVoice();

     objSpeech.Speak(txt, SpeechVoiceSpeakFlags.SVSFlagsAsync);
            
     objSpeech.WaitUntilDone(Timeout.Infinite);
        
}

Re: C# Set voice in Text to Speech

OriginalGriff27-Jul-22 20:16

Re: C# Set voice in Text to Speech

27-Jul-22 20:16

See here: Speech - Text-To-Speech Synthesis in .NET | Microsoft Docs[^] - it includes sample code which does that.

Rockallica28-Jul-22 8:39

Rockallica

28-Jul-22 8:39

I see. Thanks!

Re: C# Set voice in Text to Speech

OriginalGriff28-Jul-22 8:52

In C# can't introduce a formula in Excel

28-Jul-22 8:52

You're welcome - but please try the official documentation first next time! Laugh | :laugh:

Ismael_199927-Jul-22 12:37

Ismael_1999

27-Jul-22 12:37

I use C# in Visual studio 2022 (in portuguese) and I have a form solution where I open an Excel file and introduce data. In one cell I have to put a formula: "=IF(H5=0;D5;H5)". When I do this I receive an error: System.Runtime.InteropServices.COMException: 'Exceção de HRESULT: 0x800A03EC'. For simple formulae, like "=B4*C4", it works fine. The error is the same wheter the formula is in portruguese or english. Does anyone know what is hapening? Thanks.

Re: In C# can't introduce a formula in Excel

trønderen27-Jul-22 12:55

trønderen

27-Jul-22 12:55

Googling the error code returns several hits suggesting that switching from .xls to the more recent (and more functional) .xlsx format can fix the problem. As always: An error code may have different underlaying causes. Maybe this doesn't help with yours. Make sure to use the .xlsx format anyway, to be sure that that is not the cause of your problems.

Re: In C# can't introduce a formula in Excel

Gerry Schmitz27-Jul-22 14:47