C#

#region Update Comment
    public int Update_Comment(string Comment, string Leave_ID)
    {
        SqlCommand com = new SqlCommand("Update_Comments", con);
        com.CommandType =CommandType.StoredProcedure;
        com.Parameters.Add("@Comments",SqlDbType.NVarChar,1000).Value =Comment;
        com.Parameters.Add("@Leave_ID", SqlDbType.NVarChar, 50).Value = Leave_ID;
        con.Open();
        int row = com.ExecuteNonQuery();
        con.Dispose();
        con.Close();
        return row;

    }
    #endregion


 #region Updating Leave after approval
    public int Updating_Leave(string User_Id, string Leave_Type, int Leave_Applied)
    {
        SqlCommand com = new SqlCommand("Update_Leave", con);
        com.CommandType =CommandType.StoredProcedure;
        com.Parameters.Add("@User_Id",SqlDbType.NVarChar,50).Value = User_Id;
        com.Parameters.Add("@Leave_Type", SqlDbType.NVarChar, 50).Value = Leave_Type;
        com.Parameters.Add("@Leave_Applied", SqlDbType.Int).Value = Leave_Applied;
        con.Open();
        int row = com.ExecuteNonQuery();
        con.Dispose();
        con.Close();
        return row;
        
    }
    #endregion

here are two function first function is having 2 parametrs and the second one is having 3, but rest of the code is SAME.

So can it be possible, with the help of enum and param we can reduce the no of functions I made. all 12 functions are having different numbers of parameters.

can we reduce 20 functions to 1 or 2 functions [functions may be lengthy; having many if/else conditions] ? is this possible.

 enum Operation_Type
    {
        Insert,
        Update,
        Delete,
        Select
    }


public void Do_Insert_Update_Delete(string Proc_Name, Operation_Type Type ,int No_Of_Args , params object[] args)
    {
        if(Operation_Type.Insert ==Type)
        {
            SqlCommand com =new SqlCommand(Proc_Name,con);
            com.CommandType = CommandType.StoredProcedure;
            for(int i=1; i== No_Of_Args; i++)
            {
            com.Parameters.AddWithValue(args);
            }
            con.Open();
            com.ExecuteNonQuery();
            con.Close();
            con.Dispose();

        }
        
    }

protected void linknext_Click(object sender, EventArgs e)
   {
       int i = 0;
       if (i > 4)
       {
           i--;
       }
       if (i < 4)
       {
           i++;
       }

       Loadinstituteimages();
   }

   private void Loadinstituteimages()
   {
       string instid = Request.QueryString["instid"].ToString();

       string sqlqry = "select Instimg1, Instimg2, Instimg3, Instimg4 from InstituteDetails where instid='" + instid + "'";
       DataTable dtimages = SqlHelper.Instance.GetTableByQuery(sqlqry);
       if (dtimages.Rows.Count > 0)
       {
           for (int i = 0; i < dtimages.Rows.Count; i++)
           {
               //linkprevious.Visible = true;
               Byte[] barr = new Byte[100000];
               if (i == 0)
               {
                   barr = (Byte[])dtimages.Rows[0]["Instimg1"];
                   Session["imagebytes1"] = barr;
                   instimage.Src = "data:image/png/jpg/jpeg;base64," + Convert.ToBase64String(barr);
                   string imagename1 = Convert.ToBase64String(barr);
                   Session["imagebytes1"] = barr;
               }
               else
               {

               }

               if (i == 1)
               {
                   barr = (Byte[])dtimages.Rows[0]["Instimg2"];
                   Session["imagebytes2"] = barr;
                   instimage.Src = "data:image/png/jpg/jpeg;base64," + Convert.ToBase64String(barr);
                   string imagename2 = Convert.ToBase64String(barr);
                   Session["imagebytes2"] = barr;
               }
               else
               {

               }

               if (i == 2)
               {
                   barr = (Byte[])dtimages.Rows[0]["Instimg3"];
                   Session["imagebytes3"] = barr;
                   instimage.Src = "data:image/png/jpg/jpeg;base64," + Convert.ToBase64String(barr);
                   string imagename3 = Convert.ToBase64String(barr);
                   Session["imagebytes3"] = barr;
               }
               else
               {

               }

               if (i == 3)
               {
                   barr = (Byte[])dtimages.Rows[0]["Instimg4"];
                   Session["imagebytes4"] = barr;
                   instimage.Src = "data:image/png/jpg/jpeg;base64," + Convert.ToBase64String(barr);
                   string imagename4 = Convert.ToBase64String(barr);
                   Session["imagebytes4"] = barr;
               }
               else
               {

               }
           }
       }
   }

   protected void linkprevious_Click(object sender, EventArgs e)
   {

   }