//Insert Class for Product master
public int Insert_product(DateTime p_date, String p_compy, String p_type, String p_name, String amount, String remark, String status)
{
Int32 i;
cmd1 = new SqlCommand();
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.CommandText = "sp_Insert_ProductMaster";
cmd1.Connection = c.OpenMyCon();
cmd1.Parameters.AddWithValue("@p_date", p_date);
cmd1.Parameters.AddWithValue("@p_compy", p_compy);
cmd1.Parameters.AddWithValue("@p_type", p_type);
cmd1.Parameters.AddWithValue("@p_name", p_name);
cmd1.Parameters.AddWithValue("@amount", amount);
cmd1.Parameters.AddWithValue("@remark", remark);
cmd1.Parameters.AddWithValue("@status", status);
i = cmd1.ExecuteNonQuery();
return(i);
}