C#

private void cust_update_Click(object sender, EventArgs e)
        {        
            bool success;
            success = dataAccess.AddCustomer(<big>Datagridview ID</big>, cust_name.Text, cust_add.Text, cust_account.Text, cust_phone.Text...);
            if (success)
            {
                MessageBox.Show("Data updated!");
            }
            else
            {
                MessageBox.Show("Update FAIL!!!");
            }
        }

public bool AddCustomer(string function, string custName, string custAdd, string custAcc, string custPhone.....)
        {
            bool success = false;
            string query = string.Empty;
            try
            {
                SqlCommand cmd = new SqlCommand();
                cmd.Parameters.Add(new SqlParameter("@companyName", custName));
                cmd.Parameters.Add(new SqlParameter("@customerAdd", custAdd));
                cmd.Parameters.Add(new SqlParameter("@attName", custAdd));
                cmd.Parameters.Add(new SqlParameter("@customerAcc", custAcc));
                cmd.Parameters.Add(new SqlParameter("@customerPhone", custPhone));

 query += "UPDATE CUSTOMER set company_name= @companyName, company_add= @customerAdd, att_name= @attName, account_num= @customerAcc, phone= @customerPhone...........";
 query += " where cust_id =   <big>??????????</big>   ";
              
                cmd.CommandText = query;

                if (cn.State == ConnectionState.Closed) cn.Open();
                cmd.Connection = cn;

                if (cmd.ExecuteNonQuery() > 0)
                {
                    success = true;
                    return success;
                }

N a v a n e e t h wrote:

I need to ensure that, my code is inserting values to a table and it's related values to other table. So how do I use mock objects here ? Just a clue will help me to get started.

Colin Angus Mackay wrote:

). There will be no database interaction going on, and no need to mock the database itself because your mock objects will be returning the values to the business layer.

Colin Angus Mackay wrote:

I hope that helps.

N a v a n e e t h wrote:

Business layer don't know anything about database and my DAL returns a IDataReader

N a v a n e e t h wrote:

So I should write a mock object which returns IDataReader instance for testing business layer right ?

Colin Angus Mackay wrote:

Ah... So it knows it is a database

Colin Angus Mackay wrote:

I normally try and create some sort of DTO (Data Transfer Object) which is a simple class with just a bunch of properties (very easily mocked).

N a v a n e e t h wrote:

This works pretty well and I can mock IProduct easily. Is this approach correct ?

N a v a n e e t h wrote:

So in a performance perceptive, will this be an overhead ?

class Product
{
   internal Product(ProductItem item)
   {
      this.Name = item.Name;
   }
   
   public string Name
   {
       get;set;
   }

   public static Product FromId(int productId)
   {
      ProductDAL data = new ProductDAL();
      ProductItem item = data.GetProductFromId(productId);
      return ProductFactory.CreateProduct(item);
   }

    public void Save()
    {
       ProductDAL data = new ProductDAL();
       ProductItem item = new ProductItem(this.Name);
       data.SaveDetails(item);
    }

}

static class ProductFactory
{
   public static CreateProduct(ProductItem item)
   {
      Product product = new Product(item);
      return product;
   }
}

// DTO class
class ProductItem
{
    public ProductItem(string name)
    {
       this.Name = name;
    }

    public string Name
    {
       get;set;
    }
}

using System.Globalization;

namespace Indian
{
    public static class ExtMethods
    {
        public static string ToIndian(this double amount, bool includePrefix)
        {
            CultureInfo indianCulture = new CultureInfo("hi-IN");
            string indianString = amount.ToString("C", indianCulture);
            if (includePrefix)
            {
                return indianString;
            }
            return indianString.Substring(2);
        }
    }
}

double doubleIndian = 1234567.89;
string stringIndian = doubleIndian.ToIndian(false);