Adding optional parameter

Question

I want to give optional parameter value to objTest.TestNumber in my below code. My code as follows:-

 public class TestInfo
{
    public int Id { get; set; }
    public string TestNumber { get; set; }
}       



public string TestUpdate(TestInfo objTest)
    {
        int retVal = 0;
        try
        {
            dataContext = new AccretiveAPIContext(GetConnection(locationId));
            retVal = dataContext.Database.ExecuteSqlCommand(
                     "EXEC usp_TestUpdate @ID, @TestNumber",
                     new SqlParameter("@ID", objTest.Id),
                     new SqlParameter("@TestNumber", objTest.TestNumber),

                 );
        }
        catch (Exception)
        {
            throw;
        }
        return retVal.ToString();
    }

Please tell the changes I need to make to make "@TestNumber", objTest.TestNumber as optional parameter. I want to set its default value to zero ("0").

Please help.

You would do this on the creation of the stored procedure. Or if you did want to do it here couldn't you just use a ternary statement? new SqlParameter("@TestNumber", objTest.TestNumber == "" ? objTest.TestNumber : 0) — Dane
– Dane, Commented Feb 29, 2016 at 13:08
That isn't the way you should do this. Make it optional at procedure. — Amit Kumar Ghosh
– Amit Kumar Ghosh, Commented Feb 29, 2016 at 13:13

James Dev · Accepted Answer · 2016-02-29 13:13:07Z

6

Or even easier -

            retVal = dataContext.Database.ExecuteSqlCommand(
                 "EXEC usp_TestUpdate @ID, @TestNumber",
                 new SqlParameter("@ID", objTest.Id),
                 new SqlParameter("@TestNumber", string.IsNullOrEmpty(objTest.TestNumber) ? "0" : objTest.TestNumber),

answered Feb 29, 2016 at 13:13

James Dev

3,0191 gold badge13 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

rahul aggarwal Over a year ago

my one parameter is integer, how can I use the above statement

James Dev Over a year ago

Not sure what you mean? Your TestNumber property is a string and the Id is an integer.

rahul aggarwal Over a year ago

if I change "string TestNumber { get; set; }" to "int TestNumber { get; set; }"

James Dev Over a year ago

You could then make it a nullable int? and then the code would change to new SqlParameter("@TestNumber", objTest.TestNumber ?? 0)

Ferhat Sayan · Accepted Answer · 2016-02-29 13:11:09Z

4

Change your TestInfo class as following:

public class TestInfo
{
    private string _testNumber;

    public int Id { get; set; }
    public string TestNumber
    {
        get
        {
            if (string.IsNullOrEmpty(_testNumber))
            {
                _testNumber = "0";
            }
            return _testNumber;
        }
        set { _testNumber = value; }
    }
}

You could also modify your method and say something like:

var testNumber = string.IsNullOrEmpty(objTest.TestNumber) ? "0" : obj.TestNumber;

answered Feb 29, 2016 at 13:11

Ferhat Sayan

2361 gold badge4 silver badges20 bronze badges

Collectives™ on Stack Overflow

Adding optional parameter

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related